1. Home
  2. /
  3. Panel Help
  4. /
  5. Distribution
  6. /
  7. Intrastat inventory movements maintenance...

Intrastat inventory movements maintenance (DIR60001)

This panel displays inventory movement transactions between two EU countries, if the EU reporting function is activated in the system. You can add, change or delete entries.

The transactions are either created via the Work with inventory menu item or via the normal sales- and purchase order routines for internal replenishment orders.

When goods are moved from a warehouse in one EU country to a warehouse in another EU country, two transactions will be created and updated on this panel; one transaction for the dispatch and one for the arrival.

Note: Transactions belonging to internal replenishment orders are updated and displayed on this panel when the status on the orders is 60.

If you want to include the transactions on the intrastat declaration, the transactions have to be transferred to the Intrastat file. This is done via the Transfer Intrastat from DIS to FIN menu item.

Note: As soon as the transactions are transferred to the Intrastat file, they are removed from this panel.

Function keys

Selection fields

Intrastat inventory movements maintenance (DIR60003)

This program is used for maintaining information for inventory movements between two EU countries. Transactions for both Internal replenishment orders and normal inventory movements can be maintained.

If you want to include the transactions on the intrastat declaration, the transactions have to be transferred to the Intrastat file. This is done via the Transfer Intrastat from DIS to FIN menu item.

A printout of the information in this program can be obtained via the Print Intrastat stock movements program.

Stat procedure
Displays a code from the Statistical procedure table indicating the goods flow (i.e. dispatch or acquisition).
From warehouse
Displays the code for the warehouse from which the goods are being delivered.
To warehouse
Displays the code for the warehouse to which the goods are being delivered.
Trader country
Displays the code for the trader country indicating the country that is initiating the trade. The code is retrieved from the Warehouse table.
Disp address country
If the transactions is a dispatch (according to the statistical procedure), displays the code of the country to which the goods was delivered. If the transactions is an arrival (according to the statistical procedure), displays the code of the country from which the goods was delivered.
Department
Displays the code from the Warehouse file, if any, but can be changed. Enter the code for the department in the delivering/receiving warehouse.
Terms of delivery
If the transaction is created from an internal replenishment order, displays the code for the terms of delivery from the order, but can be changed.

If the transaction is created in the Work with inventory, Inventory movement program, the field is blank. Enter a code from the Terms of delivery table.

Note: The terms of delivery code also controls if any ancillary cost should be added, by checking the Border value table.

If this transaction has no ancillary cost and you enter a terms of delivery code that exists in the Border value table, the system will add an ancillary cost to the transaction.

However, if this transaction already has an ancillary cost and you select another Terms of delivery code that exist in the Border value table, the system will not recalculate the ancillary cost automatically. In this case you have to change the ancillary cost manually on the second panel (DIR60004).

Port of arr/dispatch
This field displays different information depending on the goods flow (i.e. dispatch or arrival).

Displays port of arrival code if moving goods to a warehouse (i.e. if statistical procedure is for an arrival).

Displays port of dispatch code if moving goods from a warehouse (i.e. if statistical procedure is for a dispatch).

This field is mandatory if the entered Manner of transport requires a port, as defined in the Manner of transport table.

Note: The field is not updated automatically if this transaction was created via the Work with inventory menu item.

Manner of transport
If the transaction is created from an internal replenishment order, displays the code for the manner of transport from the order, but can be changed.

If the transaction is created in the Work with inventory, Inventory movement program, the following apply if DC1 Inventory Control is installed and activated:

  • The value is retrieved from the Internal transport time table.
  • If no record exists in the Internal transport time table, the value is retrieved from the Internal MOT field in the Warehouse table for the delivering warehouse.

If the transaction is created in the Work with inventory, Inventory movement program, the following apply if DC1 Inventory Control is not installed:

  • the value is retrieved from the Internal MOT field in the Warehouse table, for the delivering warehouse.
Nature of trans
If the transaction is created from an internal replenishment order, displays the code for the nature of transaction from the order, but can be changed.

If the transaction is created in the Work with inventory, Inventory movement program, this field will automatically be updated with the first record in the Nature of transaction table for the delivering/receiving country.

Dispatch time
Displays the date when this transaction was delivered/received, but can be changed.

Accounting period
Customer/Supplier no
This field displays different information depending on the type of transaction. Displays a customer number if this is an internal sales order transaction.

Displays a supplier number if this is an internal purchase order transaction.

The field is blank if this transaction was created in the Work with inventory, Inventory movement program.

Order number
This field displays different information depending on the type of transaction. Displays a sales order number if this is an internal sales order transaction. Displays a purchase order number if this is an internal purchase order transaction. The field is blank if this transaction was created in the Work with inventory, Inventory movement program.
Order line number
This field displays different information depending on the type of transaction. Displays a sales order line number if this is an internal sales order transaction. Displays a purchase order line number if this is an internal purchase order transaction. The field is blank if this transaction was created in the Work with inventory, Inventory movement program.

Intrastat inventory movements maintenance (DIR60004)

This panel displays quantity and currency information, which can be updated.

Function keys

Item
Displays the item code of this transaction, but can be changed.
Country of origin
Displays the country of origin code for the item. 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 orders/sales orders programs, if this transaction is an internal replenishment order.
Commodity code
Displays the commodity code for the item. Note: Normally the commodity code on this panel is the same as in the Item file, but the code could have been changed in the Work with purchase orders/sales orders programs, if this transaction is an internal replenishment order.
Stock quantity
Displays the quantity of the item in the stock unit, but can be changed.
Invoiced quantity
If the transaction is created from an internal replenishment order, displays the quantity in the sales/purchase unit from the order, but can be changed.

If the transaction is created in the Work with inventory, Inventory movement program, displays the quantity in stock unit, but can be changed.

Unit
If the transaction is created from an internal replenishment order, displays the sales/purchase unit from the order, but can be changed.

If the transaction is created in the Work with inventory, Inventory movement program, displays the stock unit, but can be changed.

Quantity (kg)
Displays the total weight of the item. This quantity is automatically calculated from the Stock quantity field and the weight defined in the Item file. This field can be updated.
Reporting quantity
Displays the reporting quantity for the item. This quantity is automatically calculated from the Stock quantity and Commodity code fields, based on the unit and conversion factor in the Commodity code table. This field can be updated.

Note: The field is blank if no reporting unit is defined in the Commodity code table.

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.
Transaction currency
Displays the transaction currency in which the transaction is processed.

Amount in trans curr
Displays the amount in transaction currency, but can be changed.

Anc cost trans curr
Displays the ancillary cost in transaction currency, e.g. insurance cost, but can be changed.

Note: The ancillary cost can automatically be retrieved from the Border value table depending on the from/to country and the Terms of delivery code.

Amount in syst curr
Displays the amount in system currency.

Anc cost syst curr
Displays the ancillary cost in system currency.

Note: The ancillary cost can automatically be retrieved from the Border value table. depending on the from/to country and the Terms of delivery code.