Update IEC Transactions

---

Open this form under Process > Intrastat/EC Sales > Update IEC Transactions or on the Intrastat transaction entry forms by selecting the EC Sales option, and using the Intrastat process report forms by using the View option.

When accessed from a transaction, the fields are populated using the transaction it is invoked from. When accessed from an Intrastat process report form, only the transactions that are reported on display.

The Intrastat detail displays for lines having an Intrastat Reportable Country Combination, which is determined as:

1. The From and To countries must both be IEC countries (EU movement)) — for example UK, France, Germany….
2. The From and To countries must be different (inter-state movement) — for example UK to FR, but not UK to UK, nor FR to FR.
3. Where the IEC Module Control Reporting scope is set to Local, the Line Item country must be the same as the current company's country) — for example, UK.

• Line item country refers to the IN Warehouse, FA Asset, JC Job country.
• For IN Transfers, the test is that one of the (warehouse) countries matches the current company's country.
• For Job Issues/Returns, the test is that one of the (job or warehouse) countries matches the current company's county.

Reporting scope examples

1. Local line item (for example, UK Warehouse) to IEC Customer /Supplier (for example FR) - fields are visible.
2. IEC line item (for example, FR Warehouse) to Local Customer /Supplier (for example UK) - visible only if reporting scope is set to include All IEC countries.

The EC Sales detail displays for lines having an EC Sales Reportable Country Combination - which is determined as:

1. The From and To countries must both be IEC countries (EU movement) — for example, UK, France, Germany….
2. The From and To countries must be different (inter-state movement) — for example, UK to FR, but not UK to UK, nor FR to FR….

Customer/Supplier/All

Select the option to be applied. The default and read only status are determined by if the form is accessed from.

Tran Type

Select the transaction type to be applied. Those available are determined by the Customer/Supplier/Allselection, which modules are enabled and which line types are enabled on the IEC Module Control form.

Branch

Select All or the required branch to be applied. Those available are determined by the set up of Branch Maintenance Intrastat/EC Sales Intrastat branch code not set to null.

Country

Select All or the required country to be applied. This is available if the form is accessed from the Intrastat process report forms by using the View option.\

Code

Select the Customer/Supplier code to be applied. This is only enabled if the form Customer/Supplier/All selection is not All.

Alpha

Select the Customer/Supplier alpha to be applied. This is only enabled if the form Customer/Supplier/All selection is not All.

Name

Select the Customer/Supplier name to be applied. This is only enabled if the form Customer/Supplier/All selection is not All.

Reference

Select the reference to be applied. This is available if the form Customer/Supplier/All selection is not All. If only a Tran Type is selected, all references for the Tran Type are selectable.

Date From

Enter or select the date from which transactions are to be updated.

Date To

Enter or select the date to which transactions are to be updated.

All Lines

Set this to true if on using Apply the selection criteria is to return all transactions to the table. This is not visible if the form is accessed from the Intrastat process report forms by using the View option. The default is set to false.

Reportable Lines

Select this option if on using Apply the selection criteria is to return only Intrastat reportable transactions to the table. This is not visible if the form is accessed from the Intrastat process report forms by using the View option.

Current Line

This is read only. This is available if the form is accessed from a particular transaction, if the Data entry option on the User Preferences form is set to save line by line.

Reproduction

Set this to true if on using Apply the selection criteria is to return transactions to the table if the Intrastat reporting date on them is equal to the Period end Date. This is available if the form is accessed from the Intrastat process report forms by using the View option.

Original

Select this option when using Apply the selection criteria to return transactions to the table if the Intrastat reporting date on them is not set. This is available if the form is accessed from the Intrastat process report forms by using the View option.

Include prior transactions

Select this option when using Apply the selection criteria to return transactions to the table if any unreported transactions before the Date From are also included. This is available if the form is accessed from the Intrastat process report forms by using the View option. The default is set to that of the Intrastat process report.

Apply

Use this option (Hot key <Alt| A) to appliey the selection criteria to the related Intrastat objects and populate the clever table.

From Country

Displays the IEC country from which the goods are moved for the transaction of the selected table line. This is read only , and is enabled if Intrastat reporting is applicable for the selected line item.

To Country

Displays the IEC country to which the goods are moved for the transaction of the selected table line.

This is read only — you can only make changes using the table — and is enabled if Intrastat reporting is applicable for the selected line item.

NoTC

Displays the IEC nature of transaction code for the transaction of the selected table line.

This is read only, and is enabled if Intrastat reporting is applicable for the selected line item.

Delivery Terms

Displays the IEC delivery term for the transaction of the selected table line.

This is read only, and is enabled if Intrastat reporting is applicable for the selected line item.

Goods Returned

Displays the IEC goods returned status for the transaction of the selected table line.

This is read only, and is enabled if Intrastat reporting is applicable for the selected line item. Where the status is selected the NoTC and delivery term for the returned goods also display to the right.

Commodity Code

Displays the IEC commodity code for the transaction of the selected table line.

This is read only, and is enabled if Intrastat reporting is applicable for the selected line item. The commodity code description displays below the code and is also read only.

Net Mass

Displays the IEC net mass for the transaction of the selected table line.

This is read only, and is enabled if Intrastat reporting is applicable for the selected line item.

Intrastat Date

Displays the IEC date for the transaction of the selected table line, if the line has already been included in an Intrastat report.

This is read only, and is enabled if Intrastat reporting is applicable for the selected line item.

EC Sales Indicator

Displays the EC Sales option for the transaction of the selected table line.

This is read only, and is enabled if EC Sales reporting is applicable for the selected line item.

The options are (blank), Goods, Services, and Drop Ship. Special checking is implemented for drop shipment transactions in sales orders only and this Drop Ship setting flows through to any purchase orders if the SO drop ship option is selected when that the Purchase Order is created from or linked to the Sales Order.

These should flow through to subsequent SO/AR or PO/AP transactions using normal source transaction defaulting rules. No special logic is implemented to update these subsequent transactions if the SO drop ship flag is toggled after they have been linked/created. Because Credit Notes default from the Line Item code instead of what is on the invoice, users may need to change this to the Drop Shipment code.

EC Sales Date

Displays the EC Sales date for the transaction of the selected table line, if the line has already been included in an EC Sales report. This is read only, and is enabled if EC Sales reporting is applicable for the selected line item.

Update Mode Single Line/All Lines

Set to Single Line if any transaction table changes made by the user applies to that line/field only. Set to All Lines if any transaction table changes made by the user applies to all lines. The default is Single Line.

Reset Defaults

Use this option to reset the Intrastat detail to the defaults that would occur on re-entering the transactions. Where Update Mode is set to Single Line, only the transaction table line with the focus has the Intrastat detail reset to the defaults. Where Update Mode is set to All Lines, all transaction table lines have the Intrastat detail reset to the defaults.

Transaction table

Provides the clever table function, allowing users to return any combination of lines. All non IEC fields are read only and displayed using the information in the data entry forms.

The editable IEC fields are From Country, To Country, NoTC, Delivery Terms, Goods Returned, Goods Returned NoTC, Goods Returned Delivery Terms, Commodity Code, Net Mass, EC Sales Indicator.

---