News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Microsoft Dynamics GP ...

Microsoft Dynamics GP (Archived)

Microsoft Dynamics GP report writer Calculated fields

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Does anyone know how to add Tax Commodity code which is in IV00101 (Item Master table) on to SOP invoice as a calculated field.

I could go create a new calculated field and then select 'Item Master' from Fields --> Resources,then select 'Tax Commodity Code' to be added as a new calculated field. this does create a XML field but does not pull through a value when placed on the invoice.

I'm sure there is a way to do this.....it'd be great if anyone could help Thanks

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Justin Thorp 2,265 on at

Like (0)

Report

RE: Microsoft Dynamics GP report writer Calculated fields

Before attempting to make a calculated field based on Tax Commodity Code I recommend:

1.) Just drag out Tax Commodity Code from the Item Master and place it on the report layout (It should go in H2, but depending on your modifications it might need to go into a different section. One approach you can use is place it in all sections of the report).

2.) Make sure the item on the invoice you are printing has a Tax Commodity Code.

3.) Make sure you have modified the correct report, and you are printing this same report. (Print the report to screen, then choose to customize current report).

4.) Make sure you have security to the modified version of the report (otherwise you will be printing the default version and it won't show your modifications).

Thanks,

Justin

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans