Execution

image-1588653432417.png

image-1588653765019.png

Criteria

This report provides us the details about sales orders against invoice detail

Selection fields

1. Organisation: Select the organization from where the report needs to populate and display the data.

2. Business partner: The system will display the business partner name from the quotation document

3. Business partner group: select the business partner group

4. Product: The product will be displayed by the system from the order selected

5. Product category

6. Document number: A document number can be selected so that the data will be displayed for the selected document Number.

7. Target Document type

8. Sales Representative: This field represents who we going to Quotation prepare the product.

9. Date Ordered

Output fields

1. Customer name: The system will display the customer name

2. customer group: The system will display the customer group details

3. Sales Doc No: The system will display the sales order document number.

4. Date Ordered: The system will display the date ordered in order

5. Warehouse

6. Customer PO No: The system will display the customer PO document number

7. Date promised

8. Delay Days

9. Product Name

10. Attribute set: This field is shown product attribute & serial number.

11. Sales Qty Entered: how many qty sold against the sales order.

12. Order Line Amount

13. Order Total Amount

14. Order Grand Total

15. UOM

16. Sales Qty Delivered

17. Shipment No: The system will display the shipment document number.

18. Shipment Qty: The system will display the shipment qty details

19. Shipment Pending Qty: System will display the Shipment pending qty details

20. Invoice No: The system will display the invoice document number.

21. Date Invoiced

22. Invoice Qty: how many qty sold against the order.

23. Invoice Line Amount

24. Invoice Total Amount

25. Invoice Grand Total

26. Status

27. Pending Qty