Great Plains Reseller - Customer Address Update on SOP Invoices ? Alba Spectrum

Microsoft Dynamics GP is open to customizations, modifications and reporting just via the fact that it is in essence Microsoft SQL Server database application.

Microsoft Dynamics GP is open to customizations, modifications and reporting just via the fact that it is in essence Microsoft SQL Server database application. Unlike others small business and mid-market ERP applications (SAP Business One, for example), GP allows you to update its tables fields via SQL update command. However, before you ask your SQL DBA to stand out, create Update script and incorporate it as regular (overnight) SQL job, we would like you to think about MRP and ERP auditing implications. If this data alteration is not a concern, then, let?s go to the details:

1. SOP work and historical invoices. Please review the following GP tables: SOP10100 ? this is Sales Order Processing Work Document Header and SOP30200 ? this is respectively historical one

2. Statement To Address. When you create SOP document: Invoice, Quotation or Sales Order, you copy customer address from Statement To Address ID directly to SOP header table

3. What happens if your customer moves and changes contact person. Imagine scenario, when you send out customer invoice, then in a month from that date you realized that customer office moved to new location and they let old contact person and now they hired new warehouse manager. In this scenario, you most likely would like to create Crystal Reports or probably even giving it lower profile ? Smart List report in GP to reflect new address and new purchasing manager. In some cases you would like to reprint historical sales documents with new customer address and contact person info. All these routines are doable and all we need is simple SQL update statement, however again we would like you to evaluate auditing implication

4. If you are positive to go ahead. Please, contact our office via email or directly by our 866 number below

Andrew Karasev, Alba Spectrum help ( @ ) albaspectrum dot com 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


Contact Details

Company Name: Alba Spectrum Group
Issued By: Andrew Karasev
Phone: 1-866-528-0577
Zip: 60565
Website: Visit the website

by Andrew Karasev (few years ago!)

Latest Press Releases

The Mad Hatter Now Offer a Full Line of Hearth Products and Full Line of Grills

Diabetes Insulin Delivery Pens Market Research Report 2018

Dr Kapadia Provides Tips to Patients Interested in Hair Transplant Procedures

love vashikaran specialist

Solar Blanket Sales Market Report 2018

Spring Bottled Water Market Insights, Forecast to 2025

Biochemical Incubator Sales Market Report 2018

Quinine Sulphate Sales Market Report 2018

Automotive Chassisc System Market Insights, Forecast to 2025

2,6-Dicarboxypyridine market size in key regions like North America, Europe, Asia Pacific an..

Remove this press release ?

Due to extra work required to remove the press-releases we have started charging $1.99 for press release removal.

Your press release will be removed in 24 hours, once the payment has been received.

Search Press Release
e.g. Business, Computer, etc.