1) Sales Order reports 

The reports present the detailed level of all sales orders placed in SAP/PF1 system, being possible to determine:

• • Sales Order on going and open
  • Sales Orders Shipped Not Billed
  • Sales Orders invoiced

The sales order book is defined at most detailed level. That means at the schedule line level. The concept of line is very important to understand how the order book works. Each sales document can generate an item, the combination of document number / item number is a line.

To generate the sales order book,  the documents lines below are used:

• • Order line
    • Schedule line
      • Delivery line
      • Shipment⁽¹⁾
      • Billing line

Document line generation:

• • Each sales order document can generate n order line.
  • Each scheduled line can generate n delivery document.
  • Each delivery document can generate n delivery line.
  • Each delivery line can generate n billing document.
  • Each Billing document can generate n billing line.

(1)  the shipment line are not used in the reports. Information necessary to generate the sales order book are at the shipment to the end customer in the header level.   Define shipment to the end customer

2) Purchase Order reports 

3) Rules 

3.1) Data excluded from the report

• • All sales order with any Rejection code are excluded in the “To be invoiced”, “open order” and “shipped not billed” reports.
  • For the invoiced part there are no restrictions.

(If an invoice has been issued for an order with rejection code, it will appear in the "Invoiced (M)" section).

NB : sometime, rejection code for the order is applied after the invoice creation

• • by default in the prompt of the query, the following material types are excluded :
    • PF1     Z703      Packaging & accessories
    • WP1     ZDIE       Services
    • WP1     ZVER      Packaging
    • WP1     ZUNB      Stocked and not valuated

• • Order lines created more than 24 months ago are excluded

3.2) To-Be-Invoiced Date (M, M+1,..)

3.2.1) PF1 Rules 

All cases except Proof Of Delivery

With Proof Of Delivery

3.2.2) WP1 Rules

With Proof Of Delivery

Export, NON Air/Sea

NON POD, Air/Sea, NON CIP/CPT/FAS/DAT/PPA/PPD