Voiding multiple Invoice integration
-
Voiding multiple Invoice integration
Posted by Cecile Dinh on June 16, 2020 at 5:35 pm-
Hello –
We have 300+ SOP Invoices to be voided.
I heard it is possible using eConnect integration or Macro. Do you have any documentation I can follow?I really appreciate it!
——————————
Cecile Dinh
GP Admin at ARC (Airlines Reporting Corp.)
GPUG Chapter Leader – Washington, D. C.
—————————— -
Hi Cecile-
If you are using SmartConnect, there is an eConnect node for voiding sales transactions:
For the source query to feed the data into SmartConnect, you could just write a SQL statement to pick up all of the SOP invoices needed to be voided. Then in the mapping it just needs SOP Type and SOP Number:
I hope this helps.
Joe——————————
Joseph C. Markovich
Valparaiso IN
——————————
——————————————- -
Hi Joseph!
?This is awesome! Thank you so much!!!
Have a great day.——————————
Cecile Dinh
GP Admin at ARC (Airlines Reporting Corp.)
GPUG Chapter Leader – Washington, D. C.
——————————
——————————————- -
You could also automate this easily with GP Power Tools – Developer Tools module.
A SQL Query to pull up the transactions and then a Goto script to open a window to void each one in sequence.
Regards
David
——————————
David Musgrave MVP, GPUG All-StarManaging Director
Winthrop Development ConsultantsPerth, Western Australia
http://www.winthropdc.com
——————————
——————————————- -
Hi Joseph,
I did my testing – it seems like this node is only voiding the unposted SOP Invoice. What if the SOP Invoices are posted?
Thanks,
Cecile
——————————
Cecile Dinh
GP Admin at ARC (Airlines Reporting Corp.)
GPUG Chapter Leader – Washington, D. C.
——————————
——————————————- -
An even easier way is simply to make sure to put integrated transactions into a Batch. Then you just delete the entire batch prior to posting. (I use this when testing new integrations.)
If the invoices have already been posted, you can use an integration to change the Void Status on all of them. One note: changing the void status on the documents in the SOP tables doesn’t necessarily void the receivables records in the RM tables. That still has to be done separately.
——————————
Blair Christensen
Database Administrator
Oppenheimer Companies, Inc.
Boise Idaho GPUG Chapter Leader
——————————
——————————————- -
Hi Blair,
Yes, the invoices are already posted. There are only two SOP Void status (0 = Not voided and 1 = Voided). Does it mean, I will change first the status to Voided?
What would be the next step? It looks like this SOP Node is only voiding the unposted SOP invoice.Thanks,
Cecile——————————
Cecile Dinh
GP Admin at ARC (Airlines Reporting Corp.)
GPUG Chapter Leader – Washington, D. C.
——————————
——————————————- -
While voiding invoices through Dynamics GP is preferable, doing this in bulk through Integration Manager for large batches is more efficient. This doesn’t void the Receivable, however. To do that, you still have to identify the receivable and void it. I have a script I run every month to check for documents voided in SOP module which need to be voided in the RM module and vice-versa. If interested, email me and I’ll send it over to you.
——————————
Blair Christensen
Database Administrator
Oppenheimer Companies, Inc.
Boise Idaho GPUG Chapter Leader
——————————
——————————————- -
Hi
How are you?
The issue is that once an invoice is posted in SOP it is also in the Receivables tables.
Theoretically, and ESPECIALLY if counted inventory is involved you should do a SOP Return to create a credit for the customer and then apply that credit to the invoice, which will ‘void’ the invoice, but also keep inventory straight.
You can also go to ‘Posted Transactions’ and use a macro there to void them, but you’ll get an error that they originated in the SOP Module and you should use a return there (as in the latter paragraph).
Again, if they have posted just running a script to void them or trying to use IM or SmartConnect to do it might not work because the POSTED SOP Invoices are also NOW in Receivables Management (RM) tables as well as SOP tables.
If it were me, I’d create an integration that does the return and then one that applies the return to the correct SOP Invoice.
?
-
Thank you Blair and Jo!
——————————
Cecile Dinh
GP Admin at ARC (Airlines Reporting Corp.)
GPUG Chapter Leader – Washington, D. C.
——————————
——————————————-
Cecile Dinh replied 3 years, 10 months ago 1 Member · 0 Replies -
-
0 Replies
Sorry, there were no replies found.
The discussion ‘Voiding multiple Invoice integration’ is closed to new replies.