Moving Opening G/L Balance into BC With More Details

(0) Share

Report

Posted on by MahGah

15,511

Let say a company moves from GP to BC. In GP they have a development that they keep track of specific G/L with two "custom" code. Lets call them Code1 and Code2. Combination of these codes provide them information that they need for their business. These codes use in SO and PO. But they can see it in G/L and remaining balance for combo of both code.

Is it possible when data moves to BC to create G/L entry for combination of these codes and instead of one transaction multiple transactions move to BC? This is to enter opening balance for "codes" to keep track in the future.

Thanks

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

YUN ZHU 89,839 Super User 2025 Season 2 on at

Like (1)

Report

RE: Moving Opening G/L Balance into BC With More Details

Hi, just adding some info.

Maybe this new feature in this wave might give you some help.

https://learn.microsoft.com/en-us/dynamics365-release-plan/2022wave2/smb/dynamics365-business-central/migrate-more-data-dynamics-gp

Thanks

ZHU

Was this reply helpful? Yes No
MahGah 15,511 on at

Like (1)

Report

RE: Moving Opening G/L Balance into BC With More Details

Thanks Inge. I will see if we can take out Xml from GP.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,035 Moderator on at

Like (1)

Report

RE: Moving Opening G/L Balance into BC With More Details

It depends a little on the export format you get from GP. If you get xml data i would use the xml buffer or xml doc import. If not the excel buffer or csv buffers can also be good options.

Xml or Json would be my preferred format but i do not know anything about the GP export options.

The last migration i did i used xml files generated directly from SQL queries.

learn.microsoft.com/.../for-xml-sql-server

Was this reply helpful? Yes No
MahGah 15,511 on at

Like (0)

Report

RE: Moving Opening G/L Balance into BC With More Details

It is BC SaaS. You are right we may need different method here. What is your suggestion? XML import? Dataverse? Etc?

Also, to make sure then for General Journal for that account we create one journal (or multiple journal) with those transactions and exact code selected then we post them?

Thanks

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,035 Moderator on at

Like (0)

Report

RE: Moving Opening G/L Balance into BC With More Details

Yes you can, You just need an interim balance account that you use for the opening balance. Kind of the same way that you do it when you register opening balance for inventory, Customer Ledger Entries and Vendor ledger entries.

And if you have millions of records i think i would prefer another method then configuration packages. Are you in BC online or OnPrem?

Was this reply helpful? Yes No
MahGah 15,511 on at

Like (0)

Report

RE: Moving Opening G/L Balance into BC With More Details

We have the same customization in BC. Our challenge is on how to move the remaining/beginning balance into BC.

Can we create same General Journal for each of those transactions with remaining account? This is to transfer opening balance.

Was this reply helpful? Yes No
Inge M. Bruvik 1,035 Moderator on at

Like (0)

Report

RE: Moving Opening G/L Balance into BC With More Details

Have you customized corresponding fields in the BC G/L or how will you handle it in BC?

Was this reply helpful? Yes No
MahGah 15,511 on at

Like (0)

Report

RE: Moving Opening G/L Balance into BC With More Details

Thanks Inge

In this case we need to take the data out of GP then upload through configuration package. I mean for this G/L only. It is too many customizations involved for this specific G/L . The scenario is like this

Code1: Source of fund

Code 2: destination of fund

Then Code1+Code2 give client information about fund coming for which "usage" and Code2 is the usage. Then when they consume the fund based on these codes it reduce it to know how much fund is available.

Originally the plan was to use Dimension but realized it is more than 2m code for each Code.

Thanks

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,035 Moderator on at

Like (0)

Report

RE: Moving Opening G/L Balance into BC With More Details

As long as you are able to read the data from GP in a structured format that lets BC read enough data to process the export in the way you want them imported it should not be a problem.

Are you exporting them using a fixed format from GP?

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,035 on at

Like (0)

Report

RE: Moving Opening G/L Balance into BC With More Details

Hi,

Pls refer the below link for OB in BC D365

https://erpconsultors.com/create-general-journals-in-d365-bc/

regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No