Skip to Content

Stocks Query Horizontally & Vertically based on Customer Ref.

sales-order-query.jpg

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.

Thanks

Shahzad Ahmed

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers