To-do list

These steps are required for all countries.

The next section details additional steps for specific countries.

Update the Nature of Transfer codes list by integrating the patch or manually updating for France and Germany after the last report for December 2021 is processed, typically mid-January 2022.

The same changes can apply to other countries; however the rules were not published by the local authorities when this document was published. You can copy and paste the German or French list when the local authorities confirm the changes.
Run the Database mass update utility (AMIEXE) to update the 2022 records for specific transactions, such as loans and inter-site, and to switch from NoTC 11 and 12 to 31 and 32, respectively. See Appendix 3 for the new determination rules.

Sage highly recommends that you run this utility in simulation mode first and check the results so you can make adjustments if needed.

If you reprocess the Intrastat report, you need to rerun the utility before exporting the data.

Additional steps for country-specific processes

The following to-do lists are in addition to the list above.

French export process

Update the IMPDEB script (integrate the patch)
Update the FREECEXP - Intrastat dispatches import/export template. (integrate the patch). Using the new formulas for fields 2, 3, and 6, the Nature of Transaction is calculated in the export template depending on the type of customer: B2B or B2C. The Country of origin defaults from the country of the site from where the good is shipped.

Field	Description	Current Formula	New Forumula
2	Trs nature	mid$(EECNAT,1+(len(EECNAT)-2)*(len(EECNAT)>0),1)	*6
3	Trs nature	mid$(EECNAT,2+(len(EECNAT)-2)*(len(EECNAT)>0),1)	*7
6	Country of origin		*5

German export process

Update the IMPDEB process (integrate the patch)
Update the IDES - Intrastat export template (integrate the patch). Add the IMPDEB standard script.

Using the new formulas for fields 6 and 8, the Nature of Transaction is calculated in the export template depending on the type of customer: B2B or B2C.

The Country of origin defaults from the country of the site from where the good is shipped.

Field	Description	Current Formula	New Formula
6	Country of origin		*5
8	Transaction nature	right$(EECNAT,3)	*6

The export file must be imported into the IDES software for Germany or RTIC software for Austria that generates the final file.