I’m attempting to edit the Sales Gross Margin report. The end result being a SGM report that has the capability to show results by different ShipToNums, This is just getting started so my first issue that I’m having is pulling in and displaying the ShipToNum field. No matter where I attempt to pull the data from it keeps coming up blank. Any pointers on where to start this process since I’m evidently going the wrong direction?
Have a look at the Report Data Definition (RDD) first.
By default, it looks like the ShipToNum has the ExcludeColumn checked.
If you want the ShipToNum to come through, copy the Report Data Definition, and change your report style to use the new RDD with the ShipToNum not excluded.
After you make the changes, run the report and make sure you archive the report and check the data on the SQL server.
Thanks for the reply Toby. I managed to make some progress on this. The issue I’m having now is that the ShipToNum only shows up for invoices where the customer only has one ShipTo address. Regardless of what’s in the ShipToNum field on the invoice, if the customer has any other ShipTo addresses then nothing shows up.
