Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
philip zhu 2/24/2017 10:25:17 PM

SOP line total mismatch document subtotal

Every once in a while we come across some occurrences of SOP line total mismatch the subtotal of the whole document. I.e. in one order I have five order lines, the subtotal of each line is, say, $50. But the document subtotal is $300 instead of 250. After I run reconcile against the order, the document subtotal changed from $300 back to $250.

To detect this kind of issue I can create a smart list or SQL view to list orders that have this kind of issue. However, since we create hundreds of orders a day if not more, it's hard to expect people to pull this smart list every time they make some changes to the SOP document. Neither it's ideal to have users to frequently turn to GP admin to run reconcile.

Just wonder whether anyone has similar experience and how do you deal with that.

Many thanks and wish you all great weekend!


Version: GP 2015
Section: Dynamics GP

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables