Item Ledger Entries - Cost Amount

RabbitPost

I wish to import the Item Ledger Entry for an item in to Excel, using SQL and the SQL database as an External data source for Excel. When I do this the 'Cost Amount (actual)' does not pull through as it is not kept on the Item Ledger Entry table. Which table holds the financials that I can 'join' to the Item Ledger Entry table using the 'Entry No.'

Thanks in advance

bbrown

"Value Entry" joined on "Item Ledger Entry No.". There may be multiple related value entry records. You need the sum of the corresponding fields.

bbrown

"Value Entry" joined on "Item Ledger Entry No.". There may be multiple related value entry records. You need the sum of the corresponding fields.

RabbitPost

Thank you BBrown