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

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

Data, Analytics & AI Platform > Orderbook: To be invoiced > image2023-9-13_14-53-33.png

With Proof Of Delivery

Data, Analytics & AI Platform > Orderbook: To be invoiced > image2023-9-13_14-57-57.png

WP1 Rules

Based on inc

With Proof Of Delivery

Data, Analytics & AI Platform > Orderbook: To be invoiced > image2023-9-13_15-1-50.png

Export, NON Air/Sea

Data, Analytics & AI Platform > Orderbook: To be invoiced > image2023-9-13_15-3-40.png

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

Data, Analytics & AI Platform > Orderbook: To be invoiced > image2023-9-13_15-6-10.png

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

Data, Analytics & AI Platform > Orderbook: To be invoiced > image2023-9-13_15-11-42.png

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

Data, Analytics & AI Platform > Orderbook: To be invoiced > image2023-9-13_15-13-23.png

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

Data, Analytics & AI Platform > Orderbook: To be invoiced > image2023-9-13_15-24-32.png

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)

Data, Analytics & AI Platform > Orderbook: To be invoiced > image2023-9-13_15-30-36.png

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.

Data, Analytics & AI Platform > Orderbook: To be invoiced > image2023-9-13_15-32-38.png