Query IN SAP B1

[Former Member]

Hello All,

Please help how I can create consumptiom query in sap B1 , I need to create with fields:

1. Catalog number

2. Description

3. Stock hand (up to day)

4. A single cost

5. Sum of stock (single cost * stock)

6. consumption per month

7. Stock years (stock/consumption (average)12 month)

8. group mane

9. sum of open purchase order

10. sum of open order

Please Help

Best Regards

Diana

[Former Member · Accepted solution]

Dear,

Create Self defined Logistic Information System,

Regards,

kapil