Announcements
We've entered the Tariff Numbers and Countries of Origins we use to items in the item cards. How do we get this information to print on our Purchase and Sales orders?
*This post is locked for comments
You just need to add the column in the Sales Line and need to write the code on the OnValidate Trigger of the Field "No." in Item Table.
You can achieve this in two ways, One is add the field tariff No. to the sales line and populate that value on No. validate and use that in the report or modify the report to get the value based on the item in a variable and use that in the report.
You need to modify the report for printing the trariff details. If you are not developer then take help of developer for modification
Thank you for the information.
What action would need to be taken to have the Country of Origin print on the Purchase and Sales Orders?
Have you looked at the above comments ?
Yes, thank you. I just wanted to verify that these suggestions were for both items.
Yes it applies to both documents. Either you can add the field to sales line or purchase line or modify the report directly to get the value from Item and use that value in the report.
Hi,
You can add a flowfield in Sales and Purchase tables to look for the specific details from Item Table and use those fields on the Report directly.
Or you can get those details directly on the report as well from Item table as per the No.
-Yogesh KulkarniPlease verify, if you find answer helpful.
In addition to what other members described, you should also consider a situation when the same item is imported from different countries (and even might have different item Tariff Numbers depending on exact shipment and how customs broker cleared it at the customs). Thus, ideally, the information about the country of origin and tariff number should be a property of the specific lot for the item, or you would need to create new item each time it comes from a different country. Some NAV localizations (e.g., Russian localization) has this mechanism developed.
Thank you all for your advise!!!
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
