In this program you can maintain Intrastat transactions for purchase orders, internal replenishment orders (both sales and purchase orders) and inventory movements, which all are created in DC1 Distribution.
To be able to maintain the above described Intrastat transactions, the orders and inventory movements must be transferred to the Intrastat file. This is done via the Goods transaction Intrastat transfer menu item.
Note: You cannot maintain Intrastat transactions for purchase orders that have been matched with an A/P invoice in DC1 Financials.
Access the program’s two modes by toggling Stock movements and Purchase/IRO orders.
Function keys
| Stock movements | Maintain Intrastat transactions concerning inventory movements. |
Selection fields
- Supplier/Customer
- Displays the supplier or customer number of the transactions. If DC1 Financials is installed and activated, only a supplier number can be displayed.
- Order
- Displays the order number of the purchase order or the internal purchase/sales order.
- Line
- Displays the order line number of the purchase order or the internal purchase/sales order.
- Commodity code
- Displays the commodity code of the Intrastat transaction.
- Weight
- Displays the total weight of the item. Note: The value is displayed with negative sign for arrivals and with positive sign for dispatches.
- Ancillary cost
- Displays the ancillary cost.
- Curr
- Displays the currency in which the ancillary cost has been calculated.
Intrastat transaction maintenance (GCFD2804)
On this panel you can maintain information for the Intrastat transaction.
- Customer
- Only displayed if this Intrastat transaction is an internal sales order. Displays the customer number of the transaction. This field is not displayed if DC1 Financials is installed and activated.
- Supplier
- Only displayed if this Intrastat transaction is a purchase order or an internal purchase order. Displays the supplier number of the transaction.
- Order number
- Only displayed if this Intrastat transaction is a purchase order or an internal purchase/sales order. Displays the order number of the purchase order or the internal purchase/sales order.
- Order line
- Only displayed if this Intrastat transaction is a purchase order or an internal purchase/sales order. Displays the order line number of the purchase order or the internal purchase/sales order.
- Dispatch date
- Only displayed when you work with Intrastat transactions for inventory movements. Displays the dispatch date of the transaction.
- From country
- Only displayed when you work with Intrastat transactions for inventory movements. Displays from which country the goods was delivered.
- To country
- Only displayed when you work with Intrastat transactions for inventory movements. Displays to which country the goods was delivered.
- Country arrived from
- If this Intrastat transaction is a purchase order or an internal purchase order, displays the country from which the goods was delivered. If you change the country, the new country must be a member of EU.
- Country disp. to
- If this Intrastat transaction is an internal sales order, displays the country to which the goods was delivered. If you change the country, the new country must be a member of EU.
- Country of origin
- Displays the country of origin code for the item from the order line/Intrastat inventory movement transaction. Note: Normally the country of origin on this panel is the same as in the Item file, but the country of origin could have been changed in the Work with purchase order/sales order programs or the Intrastat inventory movements maintenance program.
- Terms of delivery
- Displays the terms of delivery code from the order line/Intrastat inventory movement transaction.
- Nature of trans
- Displays the nature of transaction code from the order line/Intrastat inventory movement transaction.
- Manner of transport
- Displays the nature of transaction code from the order line/Intrastat inventory movement transaction.
- Port of dispatch
- If this Intrastat transaction is a dispatch, displays the port of dispatch. Only mandatory if the manner of transport on this panel is defined with a YES setting in the Port mandatory field in the Manner of transport table.
- Port of arrival
- If this Intrastat transaction is an arrival, displays the port of arrival. Only mandatory if the manner of transport on this panel is defined with a YES setting in the Port mandatory field in the Manner of transport table.
- Commodity code
- Displays the commodity code of the Intrastat transaction.
- Weight in kg
- Displays the total weight of the item. Note: The value is displayed with negative sign for arrivals and with positive sign for dispatches.
- Dispatched quantity
- Displays the total quantity in the delivering unit.
- Delivering unit
- Displays the delivering unit of measure.
- Reporting quantity
- Displays the total quantity in the reporting unit. This quantity is automatically calculated from the Dispatched quantity and Commodity code fields, based on the unit and conversion factor in the Commodity code table. If no reporting unit is defined in the Commodity code table, this field is blank.
- Reporting unit
- Displays the reporting unit of measure. This unit is defined in the Commodity code table. If no reporting unit is defined in the Commodity code table, this field is blank.
- Amount
- Displays the amount in transaction currency. If you change this amount, you have to blank the Amount in VAT curr field if you want the system to recalculate the amount in VAT currency. The system will then recalculate both the amount in system currency and the amount in VAT reporting currency. Note: The amount in system currency is not displayed on this panel.
When recalculating the amount in system currency, the system uses the Exchange rate table. The time value and time level defined in the:
- A/P control file will decide which rate to use, if the statistical procedure indicates an arrival
- A/R control file will decide which rate to use, if the statistical procedure indicates a dispatch
When recalculating the amount in VAT reporting currency, the system uses the Exchange rate table. The time value and time level defined for the trader country in the Country table will decide which rate to use.
- Ancillary cost
- Displays the ancillary cost in transaction currency. If you change this amount, you have to blank the Anc cost VAT curr field if you want the system to recalculate the ancillary cost in VAT currency. The system will then recalculate both the ancillary cost in system currency and the ancillary cost in VAT reporting currency. Note: The ancillary cost in system currency is not displayed on this panel.
When recalculating the ancillary cost in system currency, the system uses the Exchange rate table. The time value and time level defined in the:
- A/P control file will decide which rate to use, if the statistical procedure indicates an arrival
- A/R control file will decide which rate to use, if the statistical procedure indicates a dispatch
When recalculating the ancillary cost in VAT reporting currency, the system uses the Exchange rate table. The time value and time level defined for the trader country in the Country table will decide which rate to use.
- Amount in VAT curr
- Displays the amount in VAT reporting currency. The calculation of the amount is done in two steps:
- From amount in transaction currency (the Amount field on this panel) to amount in base currency, using the exchange rate for the transaction currency.
- From amount in base currency (which is not displayed on this panel) to amount in VAT currency, using the exchange rate for the VAT currency which is defined in the Country table for the Country of trader.
- Anc.cost VAT curr
- Displays the ancillary cost in VAT reporting currency. The calculation of the amount is done in two steps:
- From amount in transaction currency (the Ancillary cost field on this panel) to amount in base currency, using the exchange rate for the transaction currency.
- From amount in base currency (which is not displayed on this panel) to amount in VAT currency, using the exchange rate for the VAT currency which is defined in the Country table for the Country of trader.
- Stat procedure
- Displays a code from the Statistical procedure table indicating the goods flow (i.e. dispatch or acquisition).
- Department
- Displays the code from the Warehouse file, if any, but can be changed.
- Quantity statistics
- Indicates if this transaction should be included on the Intrastat declaration. If this field is set to YES, the Weight in kg and Dispatched quantity fields must be completed. If this field is set to NO, the Weight in kg and Dispatched quantity fields must not be completed.
Intrastat transaction maintenance (GCFD2805)
This panel is displayed when you click Stock movements to work with Intrastat transactions for inventory movements. Enter a delivery date and/or a commodity code in the selection fields at the bottom of the panel to display Intrastat transactions for inventory movements.
Function keys
| Purchase/IRO orders | Maintain Intrastat transactions concerning purchase and internal replenishment orders (IRO). |
Selection fields
- Dsp date
- Only displayed when you work with Intrastat transactions for inventory movements. Displays the dispatch date of the transaction.
- Commodity code
- Displays the commodity code of the Intrastat transaction.
- Weight
- Displays the total weight of the item. Note: The value is displayed with negative sign for arrivals and with positive sign for dispatches.
- Ancillary cost
- Displays the ancillary cost.
- Curr
- Displays the currency in which the ancillary cost has been calculated.