| Info | ||||
|---|---|---|---|---|
| ||||
Diogo PaivaIS OtC Reporting Coordinator |
| Info | ||||
|---|---|---|---|---|
| ||||
Miriam Luttrin |
General Description
The Order Book section is an excellent place to get details of your daily order book.
In Highlight tab you are able to see a quick glimpse of your order book on the graph and easily compare your current month orderbook to future month open orders or previous month and same month of previous year actuals. Forecast is available as well for some GBUs.
On the graph, hover your mouse over the different colored sections in order to get a pop up with the exact amount constituting that section.
On the right, you can get a view of your order book by the ASP (Average Sales Price). The ASP calculation is Revenue/Volume (or price per volume unit).
At the Bottom of this page is the Detailed Orderbook View table. You can pivot the view of the details table to see your order book by product, payer, ship to, plant, or one of a number of other views (see dimensions list below) that can be interesting to your business.
My Report allows you to build your own pivot table based on the available Dimensions, Indicators, and Details from their respective menus. As long as you make at least one selection from each section, a pivot table will appear based on those selections.
Details | Definition | Exchange rate | Source | Reference Date |
|---|---|---|---|---|
Y-1 M | Last year | P&L:QV query: | Posting date | |
M-1 | Last month | |||
Invoiced (M) | Orders based on the shipment start or completions date based on incoterms for current month | |||
M | Current Month Total: | |||
Shipped Not Billed (M) | Same as "Delivered not invoiced", pending confirmation from freight forwarder if vessel has sailed for current month | CAR 4 | Global Sales (Default):QV query | |
): | Global Sales Orderbook: |
Confirmed Open Orders (M) |
Sales orders which Solvay already confirmed a date and quantity for delivery to customer for current month |
Not Confirmed Open Orders (M) |
Sales orders received from customer without confirmation of date and quantity for delivery by Solvay for current month | ||
M+1 | Orders to be invoiced on M+1 | CAR 4Monthly forecast rate |
M+2 | Orders to be invoiced on M+2 | |
M+3 | Orders to be invoiced on M+3 |
| Info |
|---|
Open orders with item category = TAS "Third Party Item" are excluded from the open orders and shipped not billed because they do not generate delivery documents, but a PO to an external vendor instead. Since vendor is in charge of the transport, we cannot estimate the goods issue/invoicing date for these orders. However they will appear in the “invoiced” section as soon as they are billed.
|
| KPI | KPI | Revenue | ||
|---|---|---|---|---|
Revenue (CURR) | Original Currency | |||
Volume | VKGFor more information about VKG click here | |||
ASP | Average Sales Price = Revenue/Volume | |||
Budget | Budget is provided by the GBU and is static for the year. Click here for more information. | |||
BFR | BFR is provided by the GBU and uses the latest version. Updated quarterly and provided directly by the GBUs, the different versions are based on quarter: BFR03, BFR06, BFR09. Click here for more information. | |||
Forecast | Click here for more information. |