Allocation In Microsoft Dynamics Gp Supply Chain Management
If you are deploying Great Plains or how it is known now Microsoft Dynamics GP in Manufacturing
, or light assembly with picking and packing, shipping and receiving and you would like to produce regular shipments to your customers, based on the percentages of planned finished goods, or based on historical orders with fractional increase, or with another possible formula in mind - you need custom add-on, 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 records
2.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 customization
3.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 scanner
4.How to get help? Please call us 1-866-528-0577, 1-630-961-5918 or email us help@albaspectrum.com 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
Andrew Karasev, Alba Spectrum http://www.albaspectrum.com 1-866-528-0577, help@albaspectrum.com Informational portal http://www.pegasplanet.com Andrew is Dynamics GP Certified Master and specializes in challenging customizations, data conversions, integrations, reporting
If you are deploying Great Plains or how it is known now Microsoft Dynamics GP in Manufacturing, or light assembly with picking and packing, shipping and receiving and you would like to produce regular shipments to your customers, based on the percentages of planned finished goods, or based on historical orders with fractional increase, or with another possible formula in mind - you need custom add-on, 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 records
2.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 customization
3.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 scanner
4.How to get help? Please call us 1-866-528-0577, 1-630-961-5918 or email us help@albaspectrum.com 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
by: Andrew Karasev
What Is Anger Management Therapy? Anger Management Techniques: Top 7 for the Holidays Anger Management Skills: Coping with Holiday Stress Irregular periods and management Hair loss, baldness and management Get Rid of Debt with Debt Management Services How to Hire a Property Management Company The Secret to Weight Loss Management Significance of media management firm in Sussex Career Opportunities In Management Consultancy Logistics Management, Supply Chain Solutions And Their Advantages Logistics Management, Ecommerce Fulfillment And Their Importance Reputation Management: The Ethical Question