Skip to Content

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 17, 2017 at 01:51 AM

    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

    Add comment
    10|10000 characters needed characters exceeded