SQL Select Statement

NavStudent

Hello

I need to write a sql select statement to find inventory value and Received Not Invoiced Value.
It looks like Navision uses in report 10138. Inventory to G/L Reconcile report uses Value Entry table. I tried to sum up the

Cost amount (Actual), Cost Amount (Expected), but I still cannot come up to the value on that report. Anybody who has written a sql statement would be appreciated.

Savatage

When we add up the Amt Received Not Invoiced total - we look to the "Purchase Line". Field 59 is called "Amt. Rcd. Not Invoiced" I add that up and that's it.

Just throwing it out there 8)

NavStudent

thank you for that idea. That will give me amount received but not invoiced.
So for inventory value I would sum up Cost amount (Actual) in value entry?

I have to see if this adds up to GL.