Skip to Content

Stocks Query Horizontally & Vertically based on Customer Ref.

Nov 13, 2017 at 04:10 PM


avatar image


Hi Gurus.

I need to have a query where i can see open sales order quantity (PO and In stock) but i need to see based on customer reference. i have a customer who many stores. and his order # joins a store #. so under every order there can be 100 stores at a time. Against every store there is a sales order in SAP B1 9.1 having referece like 818201-3001(PO# -Store#) so that goods can be ship according to store address. Splitting "NUMATCARD" and consolidating quantity at store level is beyond my approach.

I need to have a query which show results as attached output sheet.

if you could help me write this query it would make everyone life here a heaven.


Shahzad Ahmed

10 |10000 characters needed characters left characters exceeded

is it possible to build this type of query?


Gurus, some urgent help required.


is above info sufficient for gurus to understand what i need.?

* Please Login or Register to Answer, Follow or Comment.

0 Answers