News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) EC Sales list not pick...

Microsoft Dynamics NAV (Archived)

EC Sales list not picking up customer

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hi,

I now have to do Intrastat and whilst looking how to set it up I have started an audit of EC Sales so that i can make sure everything is spot on.

When I run a sales report to include all EU sales for a given period, I get a sale of 5000.00 to XYZ company, however, when running the EU sales list the transaction is not there. I have run the list from the beginning of the year to date and nothing. I checked the company has "EU" in the correct field on the customer setup and that is OK.

I have done some searching to try and see if there is any further setup and I cannot see anything.

Any ideas on this will be very much appreciated.

many thanks

Bruce

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: EC Sales list not picking up customer

Well, I found out that in the countries/regions list you have to show columns and then choose the EU and Intrastat columns. Unless you have the country code next to the country in the corresponding columns, it will not show in the EC sales list.

Gobsmacked by my list only having 14 countries and Malta did not even exist in the list of countries. Biggest surprise though was founding EU member Luxembourg was not in the list...

So I answered my own question with a little help from an external party and left the answer here in case others have the same issue.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans