Microsoft Dynamics GP report writer Calculated fields

Question

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

Answer 1

You don't need to create any calculated field, just add Item Master table in reports table, select item master table and drag and drop the Tax Commodity field on report.