Sage 100

HI Folks
   A developer we work with asked the following question and I have no idea on the answer.  Hoping some of the script gurus out there can shed some light.  They are importing AP invoices and updating them.  In one case it failed and wound up with a duplicate entry for the invoice number.   This is the script and the question in on the function of the UpdateCleanup line - basically what does it do.   And of course any thoughts on this would be welcome.  

  apInvoiceRegister.nInitReportEngine();
  apInvoiceRegister.nProcessReport("deferred");
  apInvoiceRegister.nUpdateInit();
  apInvoiceRegister.nUpdateMain();
  apInvoiceRegister.nUpdateCleanup();
​

​

------------------------------
Bob Osborn
Consultant
ACI Consulting
------------------------------

Bob - The UpdateCleanup method is for clean-up of temporary things and can vary by the _upd program. One reason is to remove the restart key which was maintained with the current document no throughout the update. Another is to clear out temporary posting work files. It varies by _upd class but what's interesting is that AP_InvoiceRegister_upd itself doesn't have a UpdateCleanup() method, so I'm not sure if the script needs it. Also, looks like to handle that so your script won't get an error, the main UpdateCleanup in Sy_Update always returns a "success". So the cause of your duplicates is something else like an interrupted update, as David suggested.

Also, as you may know, when you manually do an AP invoice and key in a duplicate number, you're prompted by the system on whether to reject the dupe or do an adjustment. But in code, it always defaults to an adjustment (which is why you see the ubiquitous Perform Logic for VI import into AP Invoices to reject the dupe (by yours truly)). So maybe the dupe you're seeing is actually an adjustment to the original invoice??

------------------------------
Alnoor Cassim
------------------------------

Was a hard error encountered during the first attempt to update the entries resulting in an interrupted register?
If yes, depending on where the error occurred, it could result in the duplicate invoice when resumed.
As for what UpdateCleanup() does, in the stock code, it appears to reference a null function that always returns "success".  It might be implemented this way to allow an extra hook for third-party enhancements to use.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Original Message:
Sent: 12/1/2022 2:11:00 PM
From: David Speck II
Subject: RE: AP Script question

Was a hard error encountered during the first attempt to update the entries resulting in an interrupted register?
If yes, depending on where the error occurred, it could result in the duplicate invoice when resumed.
As for what UpdateCleanup() does, in the stock code, it appears to reference a null function that always returns "success".  It might be implemented this way to allow an extra hook for third-party enhancements to use.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------