69
Intrastat reporting depends heavily of how properly users enters data into system, starting from master data (items/customer/vendor) setup and ending with actual transactions posting. If anything will be posted incorrectly, preparation of Intrastat journal can be challenging and in standard, there little to no possibility to enforce some policies on users. Intrastat Setup is a good start, but we need to add more control features.

Such control features were part of so called "EAST" regional layer for Eastern European countries for NAV versions 5.0 SP1 FP1 and 2009 (and in some cases later ones). A lot of Eastern Europe localizations still have such or similar functionality as it's deemed to be critically required by customers. Those are examples of such control features:

• Transaction Type Mandatory - If a checkmark is inserted in this field,
the system checks during posting whether the Transaction Type field has
been filled in sales, purchase and transfer documents. After posting these
documents, the entries will be created in the following tables: Item Ledger
Entries or Job Ledger Entries tables.
• Transaction Spec. Mandatory - If a checkmark is inserted in this field,
the system checks during posting whether the Transaction Specification
field has been filled in sales, purchase and transfer documents. After posting
these documents, the entries will be created in the following tables: Item
Ledger Entries or Job Ledger Entries tables.
• Transport Method Mandatory -If a checkmark is inserted in this field,
the system checks during posting whether the Transport Method field has
been filled in sales, purchase and transfer documents. After posting these
documents, the entries will be created in the Item Ledger Entries or Job
Ledger Entries tables.
• Shipment Method Mandatory - If a checkmark is inserted in this field,
the system checks during posting whether the Shipment Method Code
field has been filled in sales, purchase and transfer documents. After posting
these documents, the entries will be created in the following tables: Item
Ledger Entries or Job Ledger Entries tables.
• Tariff No. Mandatory – If a checkmark is inserted in this field, the system
checks during posting whether the Tariff No. field has been filled in sales,
purchase and transfer documents. After posting these documents,
the entries will be created in the Item Ledger Entries or Job Ledger Entries
tables.
• Net Weight Mandatory – If a checkmark is inserted in this field, the system
checks during posting whether the Net Weight field has been filled in sales,
purchase and transfer documents. After posting these documents, the
entries will be created in the Item Ledger Entries or Job Ledger Entries
tables.
• Country/Region of Origin Mand. – If a checkmark has been inserted in this
field, during posting the system checks whether the Country/Region of
Origin Code field has been filled in sales, purchase and transfer documents.
After posting these documents, the entries will be created in the Item
Ledger Entries or Job Ledger Entries tables.

If would be also good to make possible to use card, not transactional data for some of Intrastat attributes, like:

• Get Tariff No. From – Click the drop-down arrow in this field to select a
source for the tariff number used when creating Intrastat journal lines.
The following options are available:
- Posted Entries - The system will get the tariff number from entries from
the following tables: Item Ledger Entries or Job Ledger Entries.
- Item Card – The system will enter the tariff number from the item card.
• Get Net Weight From – Click the drop-down arrow in this field to select
a source for the net weight used when creating Intrastat journal lines.
The following options are available:
- Posted Entries – The system will get the net weight from entries from
the Item Ledger Entries or Job Ledger Entries tables.
- Item Card – The system will get a net weight value from the item card.
• Get Country/Region of Origin – Click the drop-down arrow in this field to
select a source for the country/region of origin used when creating Intrastat
journal lines. The following options are available:
- Posted Entries – The system will enter the country/region of origin from
entries from the Item Ledger Entries or Job Ledger Entries tables.
- Item Card
STATUS DETAILS
Under Review
Ideas Administrator

Thanks for your feedback. We will check if this is applicable in our architecture during intrastat redesign.

Comments

T

Other then making (manual) entry on sales and purchase orders mandatory, it would be nice to have defaults for these values on the customer and vendor level.

Category: Financial Management