List of originating products
Description
With this module, proofs of origin can be created for individual items of customer or warehouse orders. This is a list of all those purchased parts for which the respective suppliers cannot explicitly provide proof of valid certificates of origin (origin EU) at the time of delivery (the value of the non-originating goods in a delivery item determines the amount of import duties for some countries).
Such declarations can be made by companies acting as "approved exporters" by the customs authorities.
Alternatively, a list of the purchased parts clearly declared as originating, as well as a list of all purchased parts - regardless of their originating status - can be issued.
The following information on the origin of a product can be entered(if an identifier is no longer valid from the date - as it is older than one year - the system will place a "?" in front of the identifier for further verification. e.g. "?N"):
| Description | Identification |
|---|---|
| Original product | U |
| not originating | N |
| Reference to invoice | R |
| not specified | - |
| Requested | A |
With regard to the country of origin, the following information can be entered(if an identifier is no longer valid from the date - as it is older than one year - the system will place a "?" in front of the identifier for further verification. e.g. "?DE"):
| Description | Identification |
|---|---|
| Country code of the country of origin | DE (Germany), CH (Switzerland), ... |
| not specified | - |
| Various countries are eligible | # |
Functionality
Processing starts by dragging and dropping the order items (or groups) for which such a proof of origin is to be created into the list window. There are two buttons (see below) to select either sales or stock order items.
The items selected in this way are identified - depending on their processing in the logistical business process - as purchased or manufactured parts, and in the process as either taken from stock or directly scheduled. Thus, not only the master information of a part is assumed: A part, which may be a production part by default, could also - e.g. due to capacity bottlenecks - have been directly procured from a supplier for the order in question, i.e. an order was triggered for this part in this order item. In this case, the part is therefore to be regarded as a purchased part and no longer as a production part.
It can therefore happen that a stock-keeping production part has been removed from the warehouse for an order. In order to be able to trace the origin, however, the parts list of this production part must be exploded during the evaluation to see which parts with which origin this production part consists of.
Note:
Please note that when evaluating the proof of origin before the start, the system-wide validity date is set either to the reference date set manually via the options, or to the creation date of the earliest invoice of the order. If an invoice has not yet been created for the order, the order creation date is used.
If the evaluation is aborted, the system date will NOT be reset to the current date, please make sure to reset the system date to the current date. This is done via the main menu "System>Change date>Session date", there the field "Validity date".
If it is determined for a purchased part on an order position that there is neither an order nor a stock withdrawal for this, an error message is issued. Similarly, an error message is issued for a production part if there is neither a stock withdrawal nor a production-specific parts list.
The further processing and evaluation of the parts is shown in the following table:
| Part in order item | Stock goods | Further processing and evaluation |
|---|---|---|
| Purchase section | yes | Price, supplier and proof of origin are determined in accordance with the rules for determining these parameters for purchased parts held in stock(see A) |
| no | Price, supplier and proof of origin are determined in accordance with the rules for determining these sizes for purchased parts not kept in stock(see B) | |
| Production part | no | The production-specific parts list is run through completely recursively and the items are evaluated according to their logistical processing. For non-stock purchased parts, the price and supplier - and thus the proof of origin - are taken from the order. For stock purchased parts, the rules for determining the price, supplier and proof of origin apply (see below). For production parts, the standard material costs are calculated (only listed for list option: "All parts" and "Purchased and production parts" and is used for control and coordination purposes only) |
| yes | The last valid parts pre-calculation is used as a basis for the parts list | |
| Text article | only "no" is adopted | currently not supported |
A. Rules for determining the supplier, price and proof of origin for purchased parts held in stock:
- All defined suppliers of the purchased part are searched for the supplier who delivered last (date "last price"). If no supplier is found because none of them has the date "last price" (e.g. in the case of a new part for which only the eligible suppliers with their prices and conditions have been entered but no purchase order has been placed so far, or in the case of information which has been taken over from an external system and this date has not been transmitted), the "A" supplier is taken. If only one supplier is defined, this supplier is always taken. If no supplier is found, the message"No valid order data" is displayed. For the reasons mentioned above, it can happen that the "A" supplier is not taken into account because the date "last price" is not set there or because this date is older.
- The price is then determined from the order data of the supplier found under 1. If this is a quantity-dependent price table, the standard order quantity is used as the starting point. If the price cannot be determined, the message"Price table incomplete" is displayed. If there is no date for this price, the message"No price date" is displayed.
- All defined "A" and "B" suppliers of the purchased part are searched again to determine the origin of the goods. If the "last price" date is older than one year or not available at all, this information is read over, unless the "A" supplier is involved. If only one supplier is defined, this supplier is always taken into account. If the origin code is not clearly defined across all the suppliers considered, an "?N" is always issued. If the origin goods identification is unique, but older than one year, a question mark is displayed in the first place (see above).
B. Rules for determining the supplier, price and proof of origin for purchased parts not kept in stock:
- The supplier of the order is taken.
- The price of the order is taken (if there is an incoming invoice, the price there is taken).
- The origin code of the supplier of the order is issued. If it is older than one year, a question mark is displayed in the first place.
List window
| Menu item | Description |
|---|---|
| Edit | - |
| : Mission | - |
| : : Read in | - |
| : : : Customer order | Import of sales order items |
| : : : Stock order | Reading of stock order items |
| : : : Customer offer | Reading of customer quotation positions |
| Initialise list | Any existing evaluation/list is deleted and all variables are reset. This menu item is relevant if the option "Initialisation" is set to "Manual" (see below). |
| Options | Call up the option window |
| Symbol | Description |
|---|---|
 | Call up the selection window for order items |
 | Call up the selection window for stock order items |
 | Calling up the selection window for offer items |
 | Calling the document history for an entry selected in the list |
 | Calling the part master mask for an entry selected in the list |
 | Call up the logistics account for an entry selected in the list |
 | Call up the order article master mask for an entry selected in the list |
 | Call up the print output of the proof of origin |
List
After selecting the items to be processed, the list is built up. In the following section you will find some explanations of the structure/columns of the list.
The listing of each position starts with a blue-green (cyan) line, in which
- the order number
- the product group
- the number and name of the part
- the quantity of the item
- the sales value (column "purchase price" with the unit price, column "per date" with the total sales value of the item)
- Value share of non-originating goods which do not belong to the product group (the first 4 digits of the above-mentioned product group are compared) of the heading (40% allowed): this total is shown again in the line "Totals" at the end of the list
- Value share of non-originating goods belonging to the product group (the first 4 digits of the above-mentioned product group are compared) of the heading (10% allowed): this total is shown again in the line "Totals" at the end of the list
- (Standard) logistics Identification of the part of the item
- (Standard) provision Identification of the part of the item
- Reference date: either the date of first invoicing for this item or manual specification. This date is used as a reference for the validity of the data: see note
In the following lines - depending on the setting of the filters - all parts necessary to deliver the item (parts list information) are output. Some more detailed explanations of these columns follow:
Column "Order price
It is always rounded to 2 decimal places if the order price is greater than 0.01.
It is always rounded to 4 decimal places if the order price is less than 0.01, provided that this does not make it zero.
Procurement" column
| Text | Description | Addition |
|---|---|---|
| C S | The part was identified as a standard purchased part, the purchase information is taken from the standard data. | |
| C S B | ... the purchase information is taken from the last order. | This corresponds to the "last price" of the supplier agreement with the most recent last price. A prerequisite is that the standard procurement price is not conditional - except for quantity scales. If the order item role is attached to the variant part and the sub parts have their own unit tables, then the price is also considered to be conditional, since different conversion rates can lead to different prices. |
| C S L | ... the purchase information is taken from the price agreement with the "A" supplier. | The price will be determined in the following order: 1) If the order price is not conditional, the price from the supplier agreement with the most recent last price is taken. |
| C S S | ... the standard purchase price is used. | |
| K D | The part was identified as a disposable purchase part, the purchase information is taken from the order. | |
| C D B | ... the value from the order is used. | |
| C D R | ... the value from the incoming invoice is used (without additional costs). |
| Number | Text | Description |
|---|---|---|
| F1 | No order roll | The part has been identified as a standard purchased part, but the order roll is missing. |
| F2 | No suppliers | The part was identified as a standard purchased part, but neither sales (movement monitors) nor price agreements with suppliers were found in the system. |
| F3 | No valid order data | The part was identified as a standard purchased part, but no price agreement was found. |
| F4 | No supplier | The supplier of the price agreement is invalid. |
| F5 | Price is zero | A price agreement was found with the supplier, but the price is zero. |
| F6 | No price Date | A price agreement was found with the supplier, but the date is missing from the price given. |
| F7 | Price date without price | A price agreement was found with the supplier with a date, but without a price indication. |
| F8 | No price | No (valid) price agreement was found with the supplier. |
| F9 | No order quantity | The order for the part does not specify the quantity. |
| F10 | Order value is zero | The internally calculated total order value of the part is zero. |
| F11 | No order value | The order of the part has no internally calculated total order value. |
| F12 | Supplier has no order account | The supplier listed in the order does not have an order account (neither price agreement nor previous turnover exists). |
| F13 | Order item has no order account | The ordered part does not have an order account (neither price agreement with any supplier nor previous turnover exists). |
| F14 | No part / supplier data | The part has been ordered from other suppliers so far, for the current supplier there is no price agreement yet, declaration of origin. |
| F15 | No supplier in order | The order for the part is without suppliers. |
| F16 | Standard material costs are zero | The standard material costs in the production roll of the part are zero. |
| F17 | No standard material costs | The production roll of the part has no (valid) standard material costs. |
| F18 | Undefined deployment identifier | The staging code in the logistics account of the part is not defined. |
| F19 | Stock removal despite order | For the part, both an order and a stock withdrawal were carried out (the data of the order has higher priority). |
| F20 | Order item has an underdefined part | The part specified in the order item is a variant part whose characteristics list cannot be fully defined (missing characteristic(s) in the order) |
| F21 | Part in order item different from part in successor | The following documents for the order item refer to a different part (part in the order subsequently changed?). |
| F22 | Undefined disposition type | The disposition in the gozintograph of the part is not defined. |
| F23 | Text article | The part in the order is a text article. |
| F24 | No order | For the (disposable purchase) part no order has been placed yet. |
| F25 | Price table incomplete | In the supplier's existing price table there is no entry for the standard order quantity and/or the specified validity date. If a standard procurement price is available, this can be used. |
| F26 | No last price | The information in the price agreement for the last order price from the supplier is missing. |
| F27 | Last price is zero | The last order price is missing or 0 in the price agreement with the supplier. |
| F28 | invoice value is zero | The value of the (balanced) A/P invoice(s) and/or A/P credit memo items is zero. |
| F29 | Note of origin of goods in incoming invoice/credit note documents different | The order item of the part has several incoming invoice and/or incoming credit note items, the indication of origin of which is different. |
| F30 | Missing indication of origin of goods in incoming invoice/credit note | The order item of the part has an incoming invoice and/or incoming credit note item, which still has the identifier "reference to invoice", i.e. it has not been further specified. |
| F31 | Indication of origin of goods in incoming invoice/credit note documents undefined | The order item of the part has an incoming invoice and/or incoming credit note item whose indication of origin is unknown (neither "original goods yes/no" nor "indication on invoice"). |
| F32 | product group missing | The product group (customs number) of the part is missing. |
| F33 | No supplier in purchase invoice | The incoming invoice for the part is without supplier. |
| F34 | Quantity missing | The part has no quantity (quantity is zero). |
| F35 | Incoming invoice / credit memo item not released | The valuation option "Consider incoming invoices (if available)" is set, but not all found incoming invoice / credit note items have been released, the value may still be uncertain (because not internally accepted / released). |
At the end of the list, the totals for the two (according to the 10% and 40% rule) value shares of non-originating goods, their share of the sales value and the total sum of the value of non-originating goods - with their share of the sales value - are again displayed. The sum line "Control value of originating goods" shows the value of the parts that were recognised by the system as originating goods.
Option window
All settings can be made here. The window can only be closed with the "OK" button.
| Menu item | Description |
|---|---|
| Edit | - |
| : Set default settings | all changed settings are reset to default |
Each time the main window is opened, the options described here are reset to the default settings.
| Field | Description |
|---|---|
| Parts selection | |
| : original product | - |
| : : Not originating | Only output of non-originating goods in the order item |
| : : Original product | Only output of the original goods in the order item |
| : : All parts | Output of originating and non-originating goods in the order item |
| : Parts logistics | - |
| : : Only purchased parts | Only purchased parts are considered and issued |
| : : Purchased and manufactured parts | Purchased and manufactured parts are considered and issued |
| Evaluation | |
| : Reference date | - |
| : : Manual reference date | A window opens to enter the validity date for retrieving the data. If this option is not set, the date of the first invoice of an item is specified as the validity date for retrieving the data. |
| : Incoming invoices | - |
| : : Consider (if available) | If incoming invoices are entered in the system for the disposable purchased parts, then these data (price without additional costs, origin goods identification) are used primarily for the data of the order. |
| : : Not to be considered | Only the data of the order (price, origin of goods identification from price agreement with suppliers) are used for evaluation (even if incoming invoices exist). |
| : Rounding | - |
| : : Rounding down to 0,00 allowed | The value of a part could fall below 0.00 in small quantities by rounding: this should be allowed. |
| : : Rounding results in at least 0.01 | Although the value of a part may fall below 0.00 due to rounding, at least 0.01 is output (reminder value). If the part has no price or quantity (i.e. the value is zero by itself), the value is not increased to 0.01. |
| Structure | |
| : Initialize | - |
| : : Automatic (if order item is selected) | If new order items are selected for evaluation, any existing evaluation (list) is deleted. |
| : : Manual | If new order items are selected for evaluation, any existing evaluation (list) remains available. |
| : summation | - |
| : : Per selected position | If individual items/item groups are selected, the values for each item/item group are added up. |
| : : About all selected positions | The values of all selected items/item groups are output at the end of the list in a single total. |
| : Grouping | - |
| : : Retain | Possibly selected position groups are also shown in the evaluation. Group lines ("H") are output. |
| : : Dissolve | Possibly selected item groups are not shown in the evaluation, only the subordinate items are included in the evaluation. Group lines ("H") are not output. |
| button | Description |
|---|---|
| OK | The settings are saved and the window is closed. |
Related topics
Technical documentation
List of originating products
Either a transaction or an order item is transferred to the message ORIGIN_PARTS_LIST.
Every found position is evaluated by a "case" branch.
Already determined values which are stored in slots of the displayed container (tmpContainer):
Product group: Copy(tradeNumber)
Part: Get(itemPointer)
Quantity: Get(quantity)
Procurement price: Get(value)
Value: Copy(total.value)
Disposition: Copy(dispositionEnum)
(Standard) Logistics: Copy(itemPointer.StructureByID(FONT COLOR="#800000">"LOGISTICS").uniqueID)
(Standard) provision: Copy(itemPointer.supplyEnum)
Main supplier: Copy(supplied.businessObjectPointer)
Module name
origpart.mod
Classes
Security
In addition to restricting access rights via the class and its data fields, the module can be restricted in its use via some of the received messages.
| Message | Parameters | Function | Security |
|---|---|---|---|
| ORIGIN_PARTS_LIST | Calling the module |
| Message | Parameters | Function |
|---|---|---|
;){kind=link}
;){kind=link}
;){kind=link}