Reconciling Item Ledger Entry

ajmalsherifajmalsherif Member Posts: 111
I am trying to show if Items purchased and showing as purchase receipt Item ledger entries have been paid.

In SQL studio manager i can link Item Value entry and Item Ledger entry however i not able to see the Remaining Amount field in my sql query field selection box


  • Options
    ChinmoyChinmoy Member Posts: 359
    Flowfields are not available when you access NAV tables from SQL. You have to access the tables from within NAV object designer. IF you want to take out these values, export the table to Excel or CSV.
  • Options
    bbrownbbrown Member Posts: 3,268
    The Item ledger or Value Entry are not going to tell you if something has been paid. They'll only tell you whether you have posted the invoice ("qty invoiced). The invoice could stil be open in AP, therefore the inventory is unpaid.
    There are no bugs - only undocumented features.
  • Options
    ajmalsherifajmalsherif Member Posts: 111
    many thanks
Sign In or Register to comment.