| 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
AROMA Order delivery condition code AA-AB-AC-AD-AE-AF-BQ-BP
& Plant geo zone = AMERIQ +14
& Plant geo zone <> AMERIQ +10
Order delivery condition code 8-10-0
& Plant geo zone = AMERIQ +14
& Plant geo zone <> AMERIQ +10
Order delivery condition code 40-AG-AH-AI-AZ-BA +7
Other +0
SILICA +7
Sp. Chem Order delivery condition code AA-AB-AC (LCL) +13
Order delivery condition code AD -AE-AF (FCL) +7
Other +0
NOVECARE Legal company zone in "AMERICA" +11
Other +7
Technology Solutions
By Shipping Plant Zone:
North America +7
Europe, Middle-East & Africa +5
Asia Pacific +2
Latin America +3
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
The quantity sent by Solvay to the customer :
→ KB, KBCC, KA, KN, KL
→ in the open order and shipped not billed
The consumption done by the customer :
→ KE
→ in the invoiced
Important: KB order value is forced to zero for both PF1/WP1. This is because the real amount invoiced to the customer will be done via a KE order.
To-Be-invoiced Quantity (Rest To Be Delivered)
For PF1 system, if the “Part.Dlv./Item” = B (at order line level) and Actual GI date is populated
in a delivery, the order line will be excluded from Open Orders.
This flag closes definitively the order line and indicates that the customer does not wish to receive multiple deliveries for the order line, even if the remaining quantity to be delivered is above the under-delivery tolerance.
