Skip to Content

Inventory Report

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 13, 2015 at 10:37 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 22, 2015 at 04:26 PM

    Dear Abdul,

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

    Thank you,

    Antonis

    Add comment
    10|10000 characters needed characters exceeded