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.
(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
- by default in the prompt of the query, the following material types are excluded :
- 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
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
Definition of consignment→ add from recordings→ certain amount of products go to stock of a third party and the based on the consumption they will be invoiced.
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.
