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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Posting Mass amounts o...
Finance | Project Operations, Human Resources, ...
Suggested answer

Posting Mass amounts of Financial Batches using SQL

(0) ShareShare
ReportReport
Posted on by Brenda Edders 20

I need to post Millions (not kidding) of unposted financial batches. I have been using a macro to select and post one at a time however this taking a very long time. to do. I would like to know if there is a way to run a sql script to post the open batches. 

Please note , if you haven't already figured out, they do not do financial reports in these companies in gp. We need to post all batches to complete the Company Data Archive process. 

Please let me know if there are other ways to do this using Sql... 

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Andrew John Dean Profile Picture
    Andrew John Dean 1,337 on at
    RE: Posting Mass amounts of Financial Batches using SQL

    Hi Brenda

    Envisage Software has a tool that can post up to 8 batches at the same time, making the overall posting process x8 faster. So instead of taking 10+ days to post 1 million batches, it will take a little over 1 day.
    https://envisagesoftware.com/post-master

    Regards
    Andrew Dean
    0317.Envisage.jpg

  • Louise Profile Picture
    Louise 45 on at
    RE: Posting Mass amounts of Financial Batches using SQL

    In SQL Server, you can use a format file in bulk-import operations. A format file maps the fields of the data file to the columns of the table. www.myallsaversconnect.net/

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 857 Super User 2025 Season 2 on at
    RE: Posting Mass amounts of Financial Batches using SQL

    Assuming these are unposted Single Use journal entries/batches.

    What about using SQL to update the Batch Number in the unposted GL table so there are several entries in a single batch?  I wouldn't put a million JEs in a single batch, but you could do some grouping.)

    Once you did the SQL update, you'll need to run the Reconcile Batch routine in GP prior to posting.

    Normal disclaimers go here:  Backup, run in test first, etc. ...

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,028

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 579 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans