You’re offline. This is a read only version of the page.
client reimbursed their customers refunds - payments made via AP checks - now, many many checks have not been cashed so the client voided all these checks, thus opening all these invoices again. client will be remitting one check to the 'state' for all these unclaimed refunds.
is there any way to mass void all the open invoices in AP? sql? number of transactions is roughly 2,000
*This post is locked for comments
Do they have to issue a single check? If so, one way to accomplish it is to 'pay' all of the invoices with a credit card that is tied to a vendor that you create which is the state. The payables will be settled and an invoice will be created for the 'credit card' vendor that you can then pay with a single check. If you were using GP 2016, you could do a 'credit card run' just like you do a check run and move all of those transactions to a credit card vendor. I see in your post that you are using GP 2015, if I were in this position I would create a mail-merge macro that would create manual credit card payments for each of these payables thereby ending up in the same place. I really think this is the cleanest way to accomplish your objective.
Kind regards,
Leslie
Micki,
My favorite post on this process is: community.dynamics.com/.../escheatment-and-unclaimed-property-procedures-in-microsoft-dynamics-gp.
My teammate Tim and I then came up with the following:
1. Put all of these vendors in one class (if they are not already).
2. Create your list in Excel to import a credit memo for each invoice/vendor in integration manager.
3. Create a check batch for this class of vendors - marking automatically apply existing unapplied (to auto apply the credit memos to the invoices).
4. Print the remittances and be done.
Let me know if this does not make sense.
Heather
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
