News and Announcements icon

Dynamics 365 CommunityForums 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) Share

Report

Report

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

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Lisa at AonC.com 3,141 on at

Like (0)

Report

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. ...
Louise 45 on at

Like (0)

Report

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

Andrew John Dean 1,337 on at

Like (0)

Report

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans