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
mark4yesu 2/29/2016 3:47:55 PM

Receivings Entry (Shipment Invoice)

Hi, I have a proc that calls the [taPopRcptHdrInsert] to create full Shipment/Invoice transactions in GP10.

On some transactions it doesn't insert the header (in my larger script), but if run just that proc with the desired variables in Query Analyzer, it creates the record.

Any ideas on how to troubleshoot this? No errors and I'm calling the scripts from SQL (no XML or .NET).  The procs report success in all situations but sometimes no header record for my POP receivings invoice appears unless I then go manually run the script by itself.  



Version: GP 10
Section: Dynamics GP, eConnect, SQL Scripts

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