Copying Report Writer Calculated Fields
Posted Wednesday, December 3rd, 2008
I was working on a report writer report recently and due to some required date to text manipulation, I ended up with a boat load of calculated fields on an invoice. By a boat load I mean like 20, what a pain. I then needed to replicate that information on the historical invoice and the credit memo. But it was a real pain to recreate those calculated fields without any typos or goofs.
Well, Vanessa in our office came up with a better idea so she gets credit for this even if I’m writing the post.
She managed to copy the the calculated fields from the invoice to the historical invoice and the credit memo. The steps she took to copy the calculated fields from one report to another were:
1) Export the report you want to copy from
2) Export the report you want to copy to
3) Open the FROM exported package in Notepad
4) Find the calculated fields that you want to copy and paste them into the TO package using Notepad
5) Correct any names that change across reports. For example, SOP_LINE_WORK in an invoice, becomes SOP_LINE_HIST in the Hstorical invoice. Find/Replace works great for this.
6) Reimport the TO package.
Another nice thing about this method is that you can correct misspellings that might otherwise require you to completely re-enter a calculated field.
Tags: Report Writer
Posted in Reporting
Need Expert Help With Dynamics GP?
Get the support you need to effectively manage your business.
Learn more about our Dynamics GP support options
