web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :

Difference between "Inventory" and "Net Change" fields in 27 "Item" table

Andrey Baludin Profile Picture Andrey Baludin 3,943

I brought black news for guys like me who still thinking that they can get quantity of Items on selected date this way:

invcalc.JPG

Lets look at fields 68 "Inventory" and 70 "Net Change" in table 27 "Item". They both are flow fields based on "Item Ledger Entry" table with Sum method by field "Quantity":

flow.JPG

But what we can see in Table Filter:

"Inventory" field:

Inventory.JPG

"Net Change" field:

Netchange.JPG

So, "Inventory" doesn't have a Posting Date filter at all. And it always shows Quantity on current moment whatever you set in "Date filter" flow filter.

If you you need quantity on some date - take it from "Net Change" field:

netchangecalc.JPG

(and read the manuals from time to time)

Comments

*This post is locked for comments