Custom Stock report in B1

[Former Member]

Hi all,

I need to create a custom report in SAP B1 within query manager but having never done it in a little lost on what to do. What I need to do is

Item > total stock > stock promised > balance > set Min stock level > total opened PO

This is so I can run a report and see all items (raw material and finished goods) that are either below or about to hit their min stock levels. So that I can reorder.

Ta

Andy

[kothandaraman_nagarajan]

Hi,

Have you checked Available to Promise report under Inventory Reports?

Regards,

Nagarajan