| FAQ on Replacing SOP Reports
Frequently asked questions on GP Reports Viewer and SOP reports |
 Q: I have GP Reports Viewer installed, but I do not see the option to Replace SOP Reports on the menu, where is it?
- A: To have the Replace SOP Reports functionality you need to install Build 48 of GP Reports Viewer. Build 48 can be found on our
downloads page. Also, please see our
FAQ on upgrading to a new build of GP Reports Viewer. You can check what version you have installed by going to Tools > GP Reports Viewer > About.
- Q: I have installed GP Reports Viewer Build 48 and have set up Crystal reports to replace my SOP reports, but am getting an error when I try to print an invoice.
- A: There may be different causes for this, but the most common one is that the Crystal report does not have the parameters GP Reports Viewer is expecting. Instructions on setting this up can be found in the section called 'Modifying a Crystal Report for use with Sales Order Processing' of our
User Guide (this section starts on page 32).
- Q: I have 2 different Crystal reports for Invoices and I want to control which prints with the Invoice Type ID. Can I set that up to happen automatically, or will I have to pick which invoice format to use every time I print an invoice?
- A: There are 2 things that need to be set up for this to work:
- Go to Tools > GP Reports Viewer > Replace SOP Reports and set up your Crystal reports for the corresponding formats of the Invoice report.
- Go to Tools > Setup > Sales > Sales Order Processing, click on Fulfillment Order/Invoice and bring up the first Invoice Type ID. Select the format corresponding to the Crystal Report setup for this Invoice Type ID. Click Save. Bring up the second Invoice Type ID, select the format that should print with this Invoice Type ID, click Save.
|
Addresses on Crystal Reports
Use text object and suppress embedded blank lines for addresses |
 In Dynamics GP addresses are stored in a number of different fields and some of these may be blank for any given record. For example, Address 3 or Country are often left blank, but since you cannot predict whether they will be blank when designing a report, it is better to add them.
To get the address to appear without any blank fields, instead of adding each field individually, first add a text object (Insert > Text Object), then drag each address field into the text object in the order they should appear. Insert carriage returns and additional spacing or punctuation where needed between the fields. Once done, right click on the text object and choose Format Text. On the Common tab check Suppress Embedded Field Blank Lines. On the same tab, Can Grow is also useful - this lets you make the text object the size of your typical address and if the address is larger, Crystal will automatically adjust the size of the field and the rest of the report. |
| This Month in IT History
By: Joseph Puntasecca |
 In 1992 the first Info Day was held and employees got the first look at what would eventually be called Dexterity and Dynamics.
Two years later in 1994 Dynamics Graphical Report Writer for Great Plains Accounting was released.
Dynamics release 2.1 shipped in June of 1995 together with two new modules: Sales Order Processing with Advanced Invoicing and Multicurrency Management for General Ledger. |
