dgutie02 6/23/2021 12:38:25 PM

Posting a batch from SQL

Hello, I apologize if this question is a repeat in some form.

I have some SQL code which is currently responsible for creating invoices in our customers GP database. It calls: taSopLineIvcInsert, taSopLineIvcTaxInsert, & taSopHdrIvcInsert to accomplish this.

 

The customer is now requesting that we extend this code to automatically post the batch this transaction is in. They do this manually at the moment by using the following actions in their interface: Press "Sales Batch" -> Find the Batch By ID -> Press "Post"

I'm having trouble finding any documented stored procedures that can handle this, and am seeing a lot of references to the fact that this may not be possible. But I'm not versed-enough with GP to understand if I am misunderstanding these statements.

Some places that say it may not be possible:

  • http://dyndeveloper.com/thread.aspx?Threadid=5142
  • http://dyndeveloper.com/thread.aspx?threadid=308

 

I would greatly appreciate any advice on the matter. If I can provide any additional information, just let me know.

Version: Unknown or N/A
Section: 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
3