Small and medium business | Business Central, N...

How to apply entries after data has been migrated

(0) Share

Report

Posted on by AleAlonso

315

Hello,

We are going to use Journals to migrate all the data from the old system into Business Central. I'm talking about thousands of transactions on vendor/customer accounts. Once it's done, is there a quick way to match all the vendor/customer ledger entries?

Thanks

Alejandra

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Amit Baru 3,043 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

If you transfer Vendor and Customer entries document wise then application of entries possible. Second there is no batch available in standard system to applies entries in one go. So for achieving this create one Batch report and call the Application function to applies entries in on go.

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
Suggested answer

Dallefeld 235 User Group Leader on at

Like
a
(1)

Report
Copy link

Link copied!

This is not a good idea. You will spend a tremendous amount of time on this and the client will not be happy with the cost.

Put in separate tables and don't worry about application.

Was this reply helpful? Yes No
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

What i normally do is to import all the applied entries first. And when i do that i use the apply to oldest method.

Once all appliced entries are imported i switch to apply manually when i import entries that are open at the time of migration.

The apply to oldest will usually not match 100% the application that was done in the old system but at least only open entries from the old system will be open in Business Central.

Another strategy is to simply skip all old entries and just migrate the open entries.

Was this reply helpful? Yes No
SonnyPawchuk 116 on at

Like
a
(0)

Report
Copy link

Link copied!

Kim's answer is best.

Doing a project right now to load seven years of detailed transaction history from GP after running the migration tool. Loading that information with out affecting historical balances is hard enough without having to worry about matching the the customer/vendor.

Best to load into separate tables and write a report to access/merge the historical data with the current data.

See you all at Dynamics summit 2022.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,499 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

First of all, the capacity of BC SaaS is limited. I agree with the above experts. It is recommended to import only Opening Balance.

If you still want to do it, try the methods discussed below.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,043 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

My idea is according to the standard system.

If entries store in different table, then you cannot do analysis on the historical data by using standard reports like Vendor Aging, Customer Aging. for that analysis you have to develop new reports.

From this solution Client implementation cost increase.

Regards

Amit Sharma

Was this reply helpful? Yes No