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

[former_member187312]

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

[former_member275924 · Accepted solution]

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

[former_member187312 · Accepted solution]

Thanks a lot, Charm,

Best Regards,

Senz