Microsoft Dynamics GP is open to customizations, modifications and reporting simply by way of the truth that it’s in essence Microsoft SQL Server database software.  In contrast to others small enterprise and mid-market ERP purposes (SAP Enterprise One, for instance), GP lets you replace its tables fields by way of SQL replace command.  Nevertheless, earlier than you ask your SQL DBA to face out, create Replace script and incorporate it as common (in a single day) SQL job, we wish you to consider MRP and ERP auditing implications.  If this knowledge alteration shouldn’t be a priority, then, let’s go to the small print:

1.       SOP work and historic invoices.  Please evaluation the next GP tables: SOP10100 – that is Gross sales Order Processing Work Doc Header and SOP30200 – that is respectively historic one

2.       Assertion To Tackle.  Whenever you create SOP doc: Bill, Citation or Gross sales Order, you copy buyer deal with from Assertion To Tackle ID on to SOP header desk

three.       What occurs in case your buyer strikes and modifications contact particular person.  Think about situation, while you ship out buyer bill, then in a month from that date you realized that buyer workplace moved to new location they usually let outdated contact particular person and now they employed new warehouse supervisor.  On this situation, you probably wish to create Crystal Studies or most likely even giving it decrease profile – Sensible Checklist report in GP to mirror new deal with and new buying supervisor.  In some instances you wish to reprint historic gross sales paperwork with new buyer deal with and speak to particular person information.  All these routines are doable and all we’d like is straightforward SQL replace assertion, nonetheless once more we wish you to judge auditing implication

four.       In case you are optimistic to go forward.  Please, contact our workplace by way of e mail or instantly by our 866 quantity under

You may also like

No Comment

You can post first response comment.

Leave A Comment

Please enter your name. Please enter an valid email address. Please enter a message.
Rankie WordPress Plugin