Microsoft Great Plains Distribution, Barcoding, Consignment - overview for consultant

Let’s consider consignment, barcoding and distribution/warehouse management

Consignment Sales & Recurring Sales. If your business is bakery, sandwiches or ice cream making – you probably send recurring daily shipments / trucks to your customers on consignment. You need accurate system with daily predictions and recommendation on the lot size, based on historical data: day of the week, season, holiday, etc. This is very popular Dexterity customization, dealing with SOP (Sales Order Processing) and IV (Inventory Control) modules Trucks Scheduling / Distribution. In the case of consignment sales you may have your own fleet of trucks. Then for each truck you should have SOP orders batch and you need to print picking tickets. You should first print the picking tickets for the longest route and then one-by-one up to the shortest route. This is also Dexterity customization for SOP module Barcoding, Warehouse Management. Lot number tracking, Receiving, Order Fulfillment, Inventory transfer and Cycle Count could be automated with Barcoding. Barcode scanner could automate picking list allocation by reading first picking list number and then scan items and quantities – and doing so – allocate Items for Sales Order in Sales Order Processing. Usually you write Visual Basic application or routine to work with the scanner and then communicate with Microsoft Great Plains SQL database – more precisely – with Sales Order and Inventory tables: SOP10100. SOP10200, IV00100 Wholesale – daily sales and comparisons, profit by item and salesperson. Yes – all these calculations could be pulled from SOP historical and work tables, item sales analysis, etc. You can deploy Crystal Reports and even Datawarehousing solution to pivot your cube. If you need fixed number of reports and criteria – you may need again Dexterity or .Net application to arrange reporting data

Considering Microsoft Great Plains – majority of the logic above is implemented and could be implemented in Great Plains Dexterity. Alternative platform would be Microsoft C# or VB.Net ASPX web programming with Microsoft Great Plains at the back end. You can use such tools as eConnect to work with Great Plains object creation and retrieving or go ahead with direct SQL Stored Procedure. To certain level you could use legacy technologies, such as Great Plains Modifier with Continuum for VB, VBA scripting, etc.

Good luck and you can always seek our help in customization, implementation, integration and support. Call us: 1-866-528-0577 or 1-630-961-5918, help@albaspectrum.com
 
 
About the Author
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies – USA nationwide Great Plains, Microsoft CRM customization company, serving Chicago, California, Arizona, Texas, Florida, Georgia, New York, Australia, UK, Canada, Continental Europe, Russia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK

Article Source: http://www.simplysearch4it.com/article/2118.html
 

If you wish to add the above article to your website or newsletters then please include the "Article Source: http://www.simplysearch4it.com/article/2118.html" as shown above and make it hyperlinked.

Some other articles by Andrew Karasev

SAP Business One Implementation for Multinational Companies with subsidiaries in Brazil SAP B1 has over 200 installations in Brazil at this time and the number of new customers is growing. In this article we would ... SAP Business One in Illinois: implementation, upgrade, customization, integration Chicago metropolitan area and downstate Illinois might be characterized as mid-west distribution place. This means that we see large number of diversified mid-size businesses, engaged in ... SAP Business One Chicago Market Review, plus customization, integration & data conversion SAP B1 is becoming more popular in the USA, increases number of implementation each year substantially. Originally designed by one of the ... Microsoft Dynamics GP Office Stack Integration advances – Microsoft Great Plains Dynamics GP is on the way of Microsoft Dynamics or former Microsoft Project Green advances. Great Plains Dexterity is still a core of fat client workstation plus it defines ODBC Dex database access, ... eConnect and Microsoft Dexterity: Dynamics GP development tools comparison notes This article is dedicated to Microsoft Great Plains eCommerce and web software development primarily, plus Microsoft Dynamics GP customization, integration, data conversion and reporting. As software programmer you should know where one ... Microsoft Dynamics GP Dexterity Customization Microsoft Great Plains software development, customizations, reporting. Microsoft Dexterity programming as reliable alternative to newer technologies and platforms, such as .Net, C# and VB MS Visual Studio development, ...