cancel
Showing results for 
Search instead for 
Did you mean: 

Inventory Report

Former Member
0 Kudos

Hi Experts,

I wand to generate an inventory reports in SAP B1. Following columns should include in this report.

ID (UPC)

Item Name

Qty In Whe

Price (Each price list values should be listed separately in report)

Any query is available, please give me.

Thanks & Regards,

ABDUL RASHEED.P

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Dear Abdul,

If you find a solution from your requirement, Please Post it here and mark the question as Answered.

Thank you,

Antonis

Former Member
0 Kudos

Dear Abdul

You Can Try This:

SELECT T0.ItemCode,T0.ItemName,T0.OnHand,  T1.Price AS Price1,T2.Price AS Price2,T3.Price AS Price3 from OITM T0 LEFT JOIN

(SELECT ItemCode,Price From ITM1 WHERE PriceList=1)T1 ON T0.ItemCode=T1.ItemCode

LEFT JOIN

(SELECT ItemCode,Price From ITM1 WHERE PriceList=2)T2 ON T0.ItemCode=T2.ItemCode

LEFT JOIN

(SELECT Itemcode,Price From ITM1 WHERE PriceList=3)T3 ON T0.ItemCode=T3.ItemCode

You can add more prices in the above query. The disadvantage is that if you create a new price list you must add manual extra line in this query.

The other option is to use a cursor to built the query but needs practice.

Best Regards,

Antonis