Great,Plains,Consultant,News,S computer Great Plains Consultant News: Sales Returns in Dynamics GP C
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
Sales Order Processing based Reporting is in essence themost popular among Dynamics GP report designers, and in this small publicationwe would like to review it, plus concentrate on returns calculation formulaeand options. On technical level we aretalking about SOP30200 and SOP30300 tables, Sale History document header andlines respectively. If you have concernsand questions on Great Plains Microsoft Dynamics GP, please feel free to callour office number or email us: 1. ItemsReturned back to stock, damaged, lost. Depending on your business customer service policies, you may be able toresell returned goods, however if you are in retail business, you may decide todiscount in order to sell returned merchandize on the condition of as is, nowarranty. If you are looking forexperienced Dynamics GP Great Plains Reseller, who is familiar with GreatPlains Sales Order Processing module business logic, you should discuss yourSOP business processes with them 2. GreatPlains Invoicing module. This is lightversion 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 Invoicingyou have the only option of Invoice. However both SOP and Invoicing are integrated with Great PlainsInventory control module. Invoicingmodule is not covered in Dynamics GP eConnect, so if you are trying to programecommerce integration, you should take a route of Invoicing module targetingSQL stored procedures 3. CrystalReports 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 aregoing beyond CR trivia, you should consider coding Crystal Report DB side inSQL Server View or Stored Procedure. GPInventory Item Master table is IV00101 for your reference. To review and analyze Dynamics GP tablesstructure, please follow this path: Dynamics GP->Tools->ResourceDescription->Tables Structure, or for advanced options install Dynamics GPSDK from GP 10.0 CD2
Great,Plains,Consultant,News,S