As a Dexterity developer, I have written a number of customisations to Microsoft Dynamics GP which add additional fields to the system. These additional fields are often have a relationship to existing data in Dynamics GP.
It is quite common to store the additional data in a parallel table (sometimes called companion or shadow table). This is a table having same primary key as an existing table, with the additional fields.
If the fields need to be displayed via the user interface, they would normally use an alternate window. This is created by modifying the original window from Dynamics.dic and including it in your custom dictionary. Triggers are used to handle the display, save and delete events.
If the fields need to be displayed on a report, you would have to use an alternate report with custom Report Writer functions to pull your data in. Alternate reports are also created by modifying the original report from Dynamics.dic and including it in your dictionary.
There are three problems with alternate windows and reports:
So, Is there a better way?
Yes, there is....
For the windows, you have two options:
For the reports, you can't create "parallel" reports, so you must use Report Writer, but you still have two options:
For details on these functions and how to writer triggers for them, see the Knowledge Base (KB) article 888884.The article has the parameter lists and example code for the six functions:
These are the same functions used by Extender to allow Extender data to be added to reports and by the Support Debugging Tool to allow creation of user defined Report Writer functions.
For more information on this topic have a read of the following articles:
Hope you found this information helpful.
Posting from Janakiram at Dynamics Blogger
Posting from Mark Polino at DynamicAccounting.net
(I seem to have an opinion about everything i read this morning) any chance you could add tags/keywords of "shadow" and "companion" to this? I have seen those terms used more in doco, articles, and discussions for additional data/windows than I have "parallel". just sayin...
I added the other terms as well.
PLEASE READ BEFORE POSTING
Please only post comments relating to the topic of this page.
If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.