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
woodsdarren 11/4/2011 9:53:25 AM

GP Web Services - Sales Payments

I am writing an integration between Counterpoint POS and GP.  The requirements are for sales invoices to originate in CP and be moved to GP.  I have written web services code that creates a sales invoice, line items, lot number, serials and payments.  The problem is when I run the update code when an invoice has changed.  What is the procedure for updatng payments when they change and in some cases removing the payments from the invoice and adding totally new payments? I found the DeleteonUpdate, but I can not seem to get that to work the way I need it to.



Edited 11/8/2011

Related errors:

A validation exception has occurred.
Validation Errors:
- PaymentAmount does not match deposits + payments for document.
- Unable to update the existing SOP Header record

Version: GP 2010
Section: 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