Microsoft Dynamics GP report writer Calculated fields
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
Solution
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.
- Powershell command to handle a Dynamics 365 Security Role
- How to create a web service that accepts a json with an array?
- Dynamics CRM - C# Plug-in for specific view
- How do you export Attached Documents from Database taken from Microsoft Dynamics CRM 2016?
- How to get data from join table and display in a Dynamics 365 form - combining multiple tables in a single form
- Business Central API V2 Uploaded Attachment is empty
- How to use Azure Data Factory to take Business Central data and put into Azure SQL DB?
- Dynamics 365 (CRM) and Sharepoint Integration / Power Automate
- Dynamics NAV RTC : Command Line Parameter Passing
- Dynamics CRM 2016 on-premises - Javascript Suddenly stopped working
- SalesLine.update function has been called incorrectly
- Uploading to LCS Dynamics using API
- Procedure FINTAG_INSTEADOFINSERTTRIGGER, Line 41 Cannot insert an explicit value into a timestamp column
- How to use Global Variable in Cloud Flow in Power Apps
- Trigger Plugin when change in specific dropdown in Dynamics 365
- Webhook Listener in Power Platform
- How to add a column/attribute dynamically by clicking a button in MS Dynamics 365?
- Excluding a substring in dynamics 365 in the workflow editor
- How can I get Hebrew formatting (rtl) for my .rdl report
- Create annotation to a contact entity in Microsoft Dynamics CRM by API
- Reload Form on reload/refresh of subgrid in Dynamics 365 CRM Unified Interface
- D365 ambiguous advice/instructions on on-premises cumulative updates page
- X++ select statement on related tabled
- get optionset value using powerautomate flow in D365
- How to find employee of system user
- Dynamics CRM security role privileges on Email entity
- Call external API to get a file and attach it in Notes
- Dataverse plugin not sending logs to Application Insights
- Deploy CRM solution using Package Deployer as update instead of upgrade
- unable to load CRM organization