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!