| Table of Contents |
|---|
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(1)
- Billing line
- Schedule line
- Order 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.
...
2) Purchase Order reports
...
Rules
...
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.
...
- Order lines created more than 24 months ago are excluded
...
Sales document used in the reports
INVOICED | |||||
B1 | Reb.Credit Memo Req. | RE | RE Returns | ZDRB | Debit Memo Req. BR |
B2 | Rebate Correctn Rqst | REA | REA Returns-AR | ZITI | Sales Order ITI BR |
B3 | PartRebSettl.Request | SB | SB Third-p.dir order | ZORB | Standard Order BR |
B4 | Reb.Req.f.Man.Accrls | SO | SO Rush Order | ZOUT | Other Outputs BR |
CR | CR Credit Memo Req. | TA | Standard Order | ZPVA | ZPVA Ord.immed.ship. |
CRV | CRV Credit Mem Value | TAF | Standard Order (FPl) | ZRCM | Sales Accnt/Order BR |
DR | DR Debit Memo Req. | TAM | Delivery Order | ZREN | Returns NFe Custo BR |
DRV | DRV Debit Memo Value | TAV | Standard Order (VMI) | ZROB | Own NFe Returns BR |
KE | KE Consignment Issue | TD | TD Standard Order | ZSAM | Sample Order BR |
KR | KR Consign. Returns | TSA | Telesales | ZTDL | ZTDL StdOrder w/o GI |
R1 | R1 Fictive Return | ZCRB | Credit Memo Req. BR |
| |
R4 | R4 Returns free ch. | ZDON | Donation Order BR |
| |
OPEN ORDERS AND SHIPPED NOT INVOICED | |||
KB | KB Consign. Fill-up | ZITI | Sales Order ITI BR |
KBCC | KBCC CC Consign.Sto. | ZORB | Standard Order BR |
SB | SB Third-p.dir order | ZOUT | Other Outputs BR |
SO | SO Rush Order | ZPVA | ZPVA Ord.immed.ship. |
TA | Standard Order | ZRCM | Sales Accnt/Order BR |
TAF | Standard Order (FPl) | ZSAM | Sample Order BR |
TAM | Delivery Order | ZTDL | ZTDL StdOrder w/o GI |
TAV | Standard Order (VMI) | ZVEX | Fut. Dely Invoice BR |
TD | TD Standard Order | ZVEY | Fut. Dely Shipmnt BR |
TSA | Telesales | ZVNO | Del N/Prod(w/o acct) |
ZDON | Donation Order BR | ZVNP | Non Product Order BR |
To-Be-Invoiced Date (M, M+1,..)
...
Notes:
One month before: there quality features to capture previous months that needs to be rescheduled. Granularity is at line item level.
PF1 Rules
Orders are categorized based on characteristics such as having POD, shipping condition, incoterms,....
...
All cases except Proof Of Delivery
Priority order→ if shipment document created, the first rule if not I look at delivery document,...
With Proof Of Delivery
...
WP1 Rules
Based on inc
With Proof Of Delivery
Export, NON Air/Sea
...
NON POD, Air/Sea, NON CIP/CPT/FAS/DAT/PPA/PPD
NON POD,
...
Air/Sea (mode of transport and type of packaging like full container or half), AC/AF/AI (Shipping condition), Entity Zone <> Plant zone
Air/Sea, CIP/CPT/FAS/DAT/PPA/PPD
WP1: Tolerance
Tolerance is the term used to indicate the number of days allowed after the "To be invoiced" date within which an invoice can be generated or submitted. In other words, it represents the allowed period during which an invoice can still be considered timely, even if it is issued after the initially specified invoicing date.
To check with technical if it has been applied
All GBU Legal Company country = BR +0
...
Other GBU +3
The definition of consignment is a business arrangement where a certain quantity of products is placed in the stock or possession of a third party (consignee) who is not the owner of the goods. The consignor, who is the owner of the products, retains ownership until the goods are sold or consumed by the consignee. In the reports context, the products are transferred to the third party, and they are invoiced based on their consumption. This means that the consignee will receive an invoice for the products they have used or sold.
Consignment KE-KB special rule
...