Skip to Content
0

How to get material, quantity and Company currency Amount in journal entries in the backend ?

Aug 16, 2017 at 01:22 PM

95

avatar image

Hello Experts,

I need to get materials, quantity, and company currency from the production confirmation type journal entry, from that we will perform some calculation in our custom UI and show it to the end user.

I found Journal Entries view belongs to AccountingDocument XBO. From there I searched for the below path

AccountingDocument-> LineItem-> MaterialLedgerAccount

here I couldn't find the material ID.

then I searched on productionLedgerAccount as below,

AccountingDocument-> LineItem->ProductionLedgerAccount

I can get the production lot ID from there I can get the material details, but I cannot map those materials with quantity and Currency Amount.

Could anybody give me hint where I can find the materials with its quantity and currency amount?

Regards,

Senz

journal-entry.png (76.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Charm M Aug 17, 2017 at 01:51 AM
0

Dear Senz Evo ,

You can get material quantity in AccountingDocument⇒ Item⇒ MaterialLedgerAccountItem ⇒ EntryQuantity/content

You can get material ID in AccountingDocument⇒ Item⇒ MaterialLedgerAccountItem ⇒MaterialLedgerAccount⇒MaterialValuationData⇒Material⇒InternalID/content

Best Regards,

Charm

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks a lot, Charm,

Best Regards,

Senz

1