Reconciling Item Ledger Entry

ajmalsherif

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

Chinmoy

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.

bbrown

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.

ajmalsherif

many thanks