Great Plains Customization Simple Contract Pricing Programming Example

techno12

In Microsoft Dynamics GP Inventory Control module you can handle pretty complex price lists with markup formulas, based on cost, price list, currency amount, and other features. In some cases you have customers on the contract during the year (example would be government customers), for whom you need in essence to maintain parallel item price list. Of course you can purchase existing add-ons, but in the case if your formula is very simple, you may consider just to create small custom module for your unique business requirements. Let’s rephrase again, that standard GP allows you to have one base price for item, but for simplicity – you need multiple base prices for the item, each for your customer class. We will show you how to program this custom routine in Great Plains Dexterity:

1.Item Customer Class Price table. This is new table, which got to be created in Microsoft Dexterity, where you will maintain custom item price per customer class. Let’s assume you have several government contractor customer classes, and for each class you need to maintain its own price list per item

2.Customer Class Price List update screen. Likely you have your own Excel files, where you maintain customer class specific price lists and you would like to load these price lists to Great Plains with maximal level of automation. Your Great Plains Dexterity programmer will need to add custom screen, having customer class field, file selection and update buttons. The logic, your developer needs to program will read the file, open Dexterity cursor to come through each record one by one and update item price list per class in the table, described in #1

3.Price logic in Sales Order Processing Transaction Entry screen. We recommend you to deploy Dexterity trigger and do not modify SOP Entry form directly – this is recommended for future GP version upgrade flexibility, plus SOP Entry window is typically modified in popular GP Add-Ons, so you don’t want to compete with them and avoid possible alternative business logic conflicts. Your Dex trigger will be attached to SOP Scroll Line logic and will read customer class and if the class requires alternative price list – it will supersede standard GP unit of measure price with alternative. Nice and elegant GP modification, as we think

Andrew Karasev, Alba Spectrum 1-866-528-0577, 1-630-961-5918, serving Great Plains USA and Canada nationwide. Local service in Chicago, Houston, Dallas, San Diego. Please visit our information portal Pegas Planet: . If you need custom programming for GP, we are happy to help you with Dexterity, eConnect, VBA/Modifier, SQL Stored Procedures, Crystal Reports. We also provide instant support to new and existing clients via web sessions for the customers in CA, IL, WI, NY, FL, IN, MI, TX, GA, NE, NM, AI, NC, SC, OR, WA, DC, DE, PA, VI, AZ, LA

Related Posts

This entry was posted in Server & Programming. Bookmark: permalink.

Recent Posts

Best Links

Copyright © 2017 On The Samepage