Skip to Content
Aug 16, 2017 at 01:22 PM

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

201 Views Last edit Aug 16, 2017 at 01:26 PM 3 rev

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?




journal-entry.png (76.4 kB)