Showing Country Of Origin in Sales Invoice

(0) Share

Report

Posted on by Community Member

Hi all,

We have one new request from users to show the country of origin in sales invoice.

All the items were set to have 'NONE' as the Tracking Dimension Group. we have come out with a few ideas on how to do this but not feasible. Can anyone suggest how can we do this?

1. Set the Tracking dimension group as 'BATCH' and then indicate this information during GRN process.

Disadvantage: we have to duplicate all the items in AX.

2. Indicate the Country of origin in sales order line (under Foreign trade tab)

Disadvantage: User who posted the DA and invoice will not know whats the country of origin.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Avangeline,

For what purpose do you need the country of origin?

For example to fulfil some required government reporting or for some internal analysis purposes?

For foreign trade related reporting, such as intrastat, we have the foreign trade parameters available in the released products form.

There you can setup the origin and get this information inherited into your sales orders.

Do you already make use of that feature?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

hi Ludwig,

the purpose of indicating country of origin in DA and invoice is for government to determine the tariff rates for exports when we ship internationally.

noted on your suggestion but the problem is that the country of origin is not fixed. sometimes, this batch of GRN is imported from Thailand while next batch is from Vietnam.

So how can we link this information in Sales Invoice?

Was this reply helpful? Yes No
Crispin John Augustine 37,081 on at

Like (0)

Report
Copy link

Link copied!

To get the field in the Report, you have to add the field CountyOrigDest to the SalesInvoiceTmp table, set it's value in the SalesInvoiceDP class (the value should come from SalesLine), and add the field to Report design(follow the Standard new field Addition steps)

The field CountyOrigDest already exists in both SalesTable and SalesLine. How you wish to manage that getting filled, is another matter altogether.

Was this reply helpful? Yes No