web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Intrastat

(0) ShareShare
ReportReport
Posted on by 273

Hello,

I am trying to automate the Intrastat process, and I came across two particular situations by the purchasing department.
The first point is that a supplier may be from Spain (for example) and have an address in the importing country. In this case Nav is parameterized to ignore the goods transaction because the country of origin is the same of destination. But the purchasing department includes this transaction because the VAT Registration number is Spanish.

Secondly, a supplier who has his headquarters for example in Switzerland, but the VAT Registration number is for example in Belgium. From what I understand the NAV also ignores these transactions because of the country of the supplier, but also the purchasing department considers these imports to the intrastat because the VAT Registration number belongs to a member of the European Union.

Should I consider what Nav does or implement code changes for these cases?
I use the NAV 2016 version and am editing the Report 594 Get Item Ledger Entries

I guess this function needs to be changed or create a new one

LOCAL CountryOfOrigin(CountryRegionCode : Code[20]) : Boolean
                                    
IF ("Item Ledger Entry"."Country/Region Code" IN [CompanyInfo."Country/Region Code",'']) =
   (CountryRegionCode IN [CompanyInfo."Country/Region Code",'']) THEN 

EXIT(FALSE);

IF CountryRegionCode <> '' THEN BEGIN 

  CountryRegion.GET(CountryRegionCode);
  IF CountryRegion."Intrastat Code" = '' THEN
    EXIT(FALSE);

END;
EXIT(TRUE);


*This post is locked for comments

I have the same question (0)
  • Hannes Holst Profile Picture
    5,767 on at
    RE: Intrastat

    Hi,

    As far as I know, Intrastat does register the movement of goods in the EU only. That means, where the invoice is going to, does not matter.

    Any other movement outside the EU is registered by Customs. I would say the change is not necessary. Additionally, you can trust the NAV-Team at Microsoft. In situation with a wrong implementation of law (or changes to the intrastat-law), Microsoft would have been corrected/changed that.

  • Rikarddo Profile Picture
    273 on at
    RE: Intrastat

    Ok but lets imagine this examples

    Vendor 1 From Spain has goods in Portugal. We buy to Vendor 1 but the goods are in Portugal. Nav does not consider into intrastat journal. Reason: Origin country same Destination Country. But VAT is Spanish.

    Vendor 2 From Switzerland has Belgium VAT . We buy at vendor 2 but Nav does not consider into Intratsat Journal. Reason: Country From Origin (CH) Not intrastat member or EU member. Yet VAT is belgium.

    Any thoughts? or shall i keep to NAV-development?

  • Verified answer
    Hannes Holst Profile Picture
    5,767 on at
    RE: Intrastat

    Hi,

    As mentioned, the invoice is not interesting for Intrastat. Intrastat is interested, when goods crossing a boarder inside EU.

    Vendor 1: Goods remain in Portugal. The goods do not cross the boarder of Portugal. No reporting necessary. (The move from Spain and Portugal was registered before already.)

    Vendor 2: Goods do not remain inside EU. The customs check when leaving the EU will register the movement of the goods.

  • Rikarddo Profile Picture
    273 on at
    RE: Intrastat

    Hannes,

    I totally agree with you. That's what i always thought. Now i have to explain that to my purchase department. That the information given by NAV is correct, that's if  the operational procedures are being well implemented by the users. And even in the two particular cases posted by me.

    Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Alexander Ermakov Profile Picture

Alexander Ermakov 2

#2
SC666 Profile Picture

SC666 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans