[andrywang]

Hi All,

does anyone have done scripting / create saved search to get as of date inventory on hand?

for example:

Today is 1st of may 2017.

I wanna get inventory on hand as of date 1st January 2017.

Can we get it by using saved search or scripting queries?

Thanks
This is a cached copy. Click here to see the original post.

[JCirocco]

There is an Inventory Valuation report which does just that.

[Olivier Gagnon NC]

I have created this as a saved search before.

The most logical way is to pull all transactions from the beginning of time and sum them up to your as-of date.

The far trickier, but less data-intensive way is to "subtract down". Taking the On Hand quantity specified on Item records, SUBTRACT transactions from end of time down to your desire as-of date.

[Author]

Posts