Item Ledger Entries - Cost Amount

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

Best Answer

  • bbrownbbrown Member Posts: 3,268
    Answer ✓
    "Value Entry" joined on "Item Ledger Entry No.". There may be multiple related value entry records. You need the sum of the corresponding fields.
    There are no bugs - only undocumented features.

Answers

  • bbrownbbrown Member Posts: 3,268
    Answer ✓
    "Value Entry" joined on "Item Ledger Entry No.". There may be multiple related value entry records. You need the sum of the corresponding fields.
    There are no bugs - only undocumented features.
  • RabbitPostRabbitPost Member Posts: 17
    Thank you BBrown
Sign In or Register to comment.