web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Bulk Void Payable

(0) ShareShare
ReportReport
Posted on by 5

I have a problem where we need to void a lot of payable transactions every week due to extra payments. Is there a way to do this with a file or a script? Please help.

Categories:
I have the same question (0)
  • Suggested answer
    Andrea Melroe Profile Picture
    3,437 on at

    Hi mhyle,

    This is Andrea, and I’ll assist you with your question today.

    No, there is not a simple script/file backend solution to void payables transactions in bulk.

    To ensure data integrity, I highly recommend transactions be voided on the front end because there are several tables/modules involved here (Payables, Bank Rec if you’re voiding payments, General Ledger,etc.).

    Have you considered addressing the reason behind ‘why’ you are having to void so many payables transactions on a regular basis? Maybe a process can be put in place to avoid the creation of all these ‘extra’ documents that have to be voided?

    Others may have some ideas for you, but again I would not recommend trying to do this on the backend as the likelihood of damaged data as a result is high.

    Thanks,

    Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP

  • mhyle Profile Picture
    5 on at

    Thanks Andrea,

    I understand how this can be a complex task. And you are correct that this should be something that should be handled at the data origin.

    However, "stuff" happens and anything happening in the front end is just calling a stored procedure or function that takes the input (in this case, voiding a payable) and updating the database including all ancillary tables. I am surprised that this wouldn't be callable outside of the UI or that there isn't a built in-feature of the UI to take a bulk file.

  • Suggested answer
    Andrea Melroe Profile Picture
    3,437 on at

    You are very welcome mhyle,

    I totally understand where you’re coming from with wanting the ability to void payables documents in bulk (in other words you don’t want to have to restrict on the vendor when you choose which documents to void). Our integration tools (IM and eConnect) do not have that functionality built in.

    With that said, GP doesn’t just call a stored procedure or function when you void a payables transaction. There is dexterity code coming into play, and that dexterity code calls appropriate procedures/functions (a lot of them – not just one or two or three). You could get a SQL profiler trace to see all the stored procedures/functions being called when you void if desired (you'll see what I'm referring to). Additionally, which stored procedures are getting called depends on which modules are being used (like RED or AA) in addition to the modules we think about when we think about voiding a payables document (like PM, BR, GL). All of those scenarios would need to be taken into account when determining/developing a backend solution to void payables in bulk.

    I think this would be a great product suggestion! I’m sure you are not the only person who’d like to see this functionality added to the product.

    The most powerful tool at our disposal to bring visibility to Development, and drive change within Microsoft Dynamics GP is the Product Suggestion. Development reviews each suggestion very seriously when determining what GP’s upcoming features will be. The more votes the suggestion gets, the higher the likelihood it will be included in an upcoming release. This is an ideal method to let Development know that you’d like to see a specific change made within the product.

     

    Here is more information on entering a Product Suggestion:

     

    You can use the site below to add a new suggestion or enter a vote for an existing product suggestion:

     

    https://experience.dynamics.com/ideas/

     

    I wish I had a different answer for you here, mhyle. It’s possible others in the community will have other suggestions for you.

    Thanks,

    Andrea

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 544 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans