If you are Dynamics GP administrator for your company, and if you are looking for getting quotes on Crystal Reports, or even Microsoft SQL Server Reporting Service (SSRS).
Sales Order Processing based Reporting is in essence the most popular among Dynamics GP report designers, and in this small publication we would like to review it, plus concentrate on returns calculation formulae and options. On technical level we are talking about SOP30200 and SOP30300 tables, Sale History document header and lines respectively. If you have concerns and questions on Great Plains Microsoft Dynamics GP, please feel free to call our office number or email us:
1. Items Returned back to stock, damaged, lost. Depending on your business customer service policies, you may be able to resell returned goods, however if you are in retail business, you may decide to discount in order to sell returned merchandize on the condition of as is, no warranty. If you are looking for experienced Dynamics GP Great Plains Reseller, who is familiar with Great Plains Sales Order Processing module business logic, you should discuss your SOP business processes with them
2. Great Plains Invoicing module. This is light version of Sales in Dynamics GP. Normally you would like to deploy Dynamics GP Sales Order Processing, where you have Sales transaction option to be started as Quote, Sales Order, Backorder, Invoice, Return. In Invoicing you have the only option of Invoice. However both SOP and Invoicing are integrated with Great Plains Inventory control module. Invoicing module is not covered in Dynamics GP eConnect, so if you are trying to program ecommerce integration, you should take a route of Invoicing module targeting SQL stored procedures
3. Crystal Reports for Great Plains recommendations. If you need very simple CR for GP, something like Inventory Items list, you can definitely try Crystal Reports DB connection wizard, but if you are going beyond CR trivia, you should consider coding Crystal Report DB side in SQL Server View or Stored Procedure. GP Inventory Item Master table is IV00101 for your reference. To review and analyze Dynamics GP tables structure, please follow this path: Dynamics GP->Tools->Resource Description->Tables Structure, or for advanced options install Dynamics GP SDK from GP 10.0 CD2
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQ
Planning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.
Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella
