on 01-12-2015 6:05 AM
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
Dear Abdul,
If you find a solution from your requirement, Please Post it here and mark the question as Answered.
Thank you,
Antonis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.