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

Sign Up Now!Log In
Falk0r 10/31/2016 2:41:04 PM

GP Web Services: Purchase Invoice not accurate


  I am currently having an issue regarding Purchase Invoices.  


  1. Purchase Order is Created
  2. Receipt is received
  3. Invoice pushed to GP via GP Web Services

The push is successful but the subtotal against the PO returns a negative value.

The subtotal against the PO SHOULD be 0 when it is closed out evenly like so.


When the auto invoice functionality is used, the sub total is equal 0 and the Purchase Order is closed correctly.

If the invoice is generated via GP Web Services then the subtotal is a negative on the Purchase Order.


As you can see in the above picture, the total is 2,500 however its leaving the PO with a negative 5,000 balance.


Please advise best approach.




Version: All, GP 2015, GP 2013, GP 2010
Section: .NET Development, Dynamics GP, Web Services

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