Skip to Content

Inventory stock quantity with respective received date

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 31, 2017 at 08:33 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • 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.

    Add comment
    10|10000 characters needed characters exceeded