Microsoft,Dynamics,SCM,Add-Ons computer Microsoft Dynamics GP SCM Add-Ons: Automatic Sales Order All
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 ----------------------------------------------------------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
typically programmed in Great Plains Dexterity. Popular custom logic is also when you are allocating Dynamics GP Sales Order or Invoice lines based on EDI code from your customers. Customization works with native Dynamics GP Supply Chain Management set of modules: Sales Order Processing, Inventory Control, Purchase Order Processing. We recommend this small publication for introduction:1.Allocation in Sales Document. Sales Invoice, Order, Return, Back Order or Fulfillment Order have two components: document header (table SOP10100 where customer info, invoice number, shipping address, etc. go) and document lines (table SOP10200 where you have inventory item info, warehouse, etc.). If you decide to do order fulfillment in separate process, you have control in picking and packing - typically most of the Warehouse Management System deploy Barcoding for separate lines allocation. If you need to introduce custom formula, you may change item quantities, based on the expected future order volume. This is where Dexterity allows you to change QTY field in SOP10200 and call all the associated internal SOP logic to update Order Line and Order Header records2.EDI or Electronic Document Interchange in Order Allocation. EDI code typically comes in precisely structured text file format with document header, lines and trailer. As Dynamics GP is MS SQL Server based ERP application, you can deploy pretty simple connection from MS SQL Server to the text file via ODBC and do precise SQL Select statement to read and parse elements of the Sales Order or Invoice, including Customer ID, Item Numbers, Quantities. You may do all the job in EDI scenario in SQL Stored Procedure (filling SOP10100, SOP10200 and associated tables), however better results could be achieved in Dynamics GP Integration Manager (where you have to deploy Advanced ODBC data query for flexibility), or if you are Microsoft Visual Studio C# or VB developer - then your preferred tool might be eConnect (it has methods to creating SOP documents and add lines), or even Dexterity, if your business logic requires too much customization3.Warehouse Management System for Picking and Packing. As we already mentioned WMS deploys barcode scanning, RFID technologies to upload scanned data directly to Dynamics GP. In picking and packing it translates into SOP Order Line allocation, based on Item Number scanned and then followed by item quantity and sometimes lot or serial number. WMS user interface runs on the LCD screen of the barcode scanner4.How to get help? Please call us 1-866-528-0577, 1-630-961-5918 or email us [email protected] We work with nationwide clientele. International clients welcome. Our WMS, Barcoding, Logistics and Distributions consultants speak English, Chinese, Spanish, Portuguese, Russian, Filipino, Arabic. In the countries, where Dynamics GP is not localized we would recommend Dynamics AX for large subsidiaries, and SAP Business One for smaller facilities
Microsoft,Dynamics,SCM,Add-Ons