Andrew Karasev

Great Plains Consultant News: Sales Returns in Dynamics GP Crystal Reports Design

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

Article Tags: Great Plains, Crystal Reports, Sales Order

Source: Free Articles from ArticlesFactory.com

ABOUT THE AUTHOR