xperttech
asked on
How do I insert a data field with external data into a GP 10 Report Writer template?
We use Papersave in conjunction with Microsoft Great Plains Dynamics 10.
I need to insert a barcode field into a check stub in a template. PaperSave module Forms Recapture needs this. This barcode field is made up of multiple fields, which some are gathered from external SQL tables. I'm new to GP and have no idea how to accomplish this.
Below I'm including code for a portion fo the field, but I also attached the document that described the field composition.
I need to insert a barcode field into a check stub in a template. PaperSave module Forms Recapture needs this. This barcode field is made up of multiple fields, which some are gathered from external SQL tables. I'm new to GP and have no idea how to accomplish this.
Below I'm including code for a portion fo the field, but I also attached the document that described the field composition.
Barcode field format:
*PSVACC%%[PaperSave Company ID]%%[Document Type ID]%%[Transaction ID]CG*
Use PaperSave
Select c.id as [PaperSave Company ID], c.CompanyName From Company c
PaperSave-Re-Capture-GP-Forms-Mo.doc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1. Open GP 10.0 and login to any company
2. Click on Microsoft Dynamics GP 10.0 -> Tools -> Customize -> Report Writer
3. Select the product Microsoft Dynamics GP and click OK
4. You are now in to GP 10 Report Writer, you should see a button for Reports, click it to see a list of all the canned reports, and a list of modified reports. Select the report you want to modify and add it to the modified list if it is not already there.
5. Select that report in the modified reports list, and click open, then click Layout. You should get instructions from PaperSave on how exactly to add in this new text field into the report itself.
If you have more questions about the Report Writer itself ask. Hope this helps.