Inventory stock quantity with respective received date

[too_muihwee]

Hi,

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.

[too_muihwee]

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.

[Johan_H]

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

[Johan_H]

Hi,

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.

Regards,

Johan