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
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.
