Skip to Content

Inventory stock quantity with respective received date

Mar 31, 2017 at 06:42 AM


avatar image


I need to extract inventory balance quantity based on stock aging date, any idea how to achieve this? The items are not manage by batch or serial.

E.g. if i retrieve item A from inventory audit report, i get the quantity balance as 100 pcs and value = 5000. But out of this 100pcs, i need to know what is the receive date & quantity for each so that i can use this information to import into another company.

Reason for doing so is that currently there are 2 division inside 1 SAP B1 company, moving forward, they wanted to split into 2 SAP B1 companies, thus i need to extract out the inventory balance for division 2 and import into 2nd SAP B1 company as opening balance. I find it is quite difficult to get this information. Please help, thanks.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Johan Hakkesteegt Mar 31, 2017 at 08:33 AM


If you run the audit report with a date range of more than one day (for example a whole month), all changes in the quantity balance will be displayed separately., giving you the info you need.

Please note however, that the audit report is a resource hog, and depending on the number of different (inventory) items in your database or chosen in the report parameters, and the length of the date range chosen, it can easily crash the B1 client. So if you use it, please make sure to use as small a date range as possible, and as few items at a time as possible.



10 |10000 characters needed characters left characters exceeded
Too Mui Hwee Mar 31, 2017 at 09:06 AM

Hi Johan,

Thanks for the answer, but audit report will have a lot of in and out, if last purchase qty less than current stock qty, means my balance stock is comes from more than 1 purchase, can even from inventory transfer.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Well yes, that is what you asked isn't it? To see where each of the 100 pcs came from?