has been implemented by a large Chicago area manufacturer and distributor of ethnic foods running a 24/7 operation. Scribe replaced several customizations enabling them to upgrade from Great Plains v 7.5 to and automate certain processes that required users to manually launch custom code.
The customizations, including some Visual Basic applets, were written to . To move data out of Dynamics GP, Scribe integrations were created to extract customer aging and invoice detail as well as pricing and promotion information. Scribe delivers the data to a separate Microsoft SQL server running in a virtual environment. These integrations are scheduled via the Scribe Console to run during off hours.
There are two types of data coming into Dynamics GP – new sales orders and payments.
New orders taken by delivery drivers via a hand held device are uploaded into the on the virtual server. Scribe integrations were created to monitor the virtual server for new orders and to load them into Dynamics GP.
When an order is delivered, the same driver creates an invoice on his hand held device. The invoice gets sent to a warehouse/inventory control system and ultimately into Dynamics GP. Payments made for delivered goods is recorded on the hand held device but not saved with the invoice. Therefore, a Scribe integration was created to monitor the virtual server for payments received for these invoices. The integration to the appropriate unposted invoice in Dynamics GP.
Another Scribe integration was created to upload cash receipts into Dynamics GP for payments not designated for a specific invoice.
The system has been up and running for some time with only a few minor issues reported. By removing a large amount of custom code, the client is less likely to remain on an unsupported version of Dynamics GP for as long as they have in the past and are able to take advantage of features in the new releases sooner.
By Gerry Weiler, Project Manager, at your
|
More Posts By Crestwood Associates
- Checkbook ID Defaults on Computer Check Batch in Microsoft Dynamics GP 2018 R2
- Dynamics GP SmartList Builder: PO Shipment Receipt & Matching Line Number
- Management Reporter (MR) Refresher: Advanced MR Tips with Downloadable Guides!
- Post Through the General Ledger at the Transaction Level (New Feature in Microsoft Dynamics GP 2018 R2)
- Create a SmartList to Analyze AP Invoices Paid by GL Accounts in Dynamics GP
Related Posts
- Utilizing WennSoft and Microsoft Dynamics GP to Manage Your Service Business
- Encore Business Solutions Adds Value To SmartList, Project Tracking and Billing
- Microsoft Dynamics GP Development Environment Overview
- Lessons in Allocations in Microsoft Dynamics GP
- Successful Upgrade of Microsoft Dynamics GP 9 Healthcare Customer to Microsoft Dynamics GP 2010
