Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

Moving Opening G/L Balance into BC With More Details

Posted on by 15,419

Hi 

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

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 68,586 Super User 2024 Season 2 on at
    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

  • MahGah Profile Picture
    MahGah 15,419 on at
    RE: Moving Opening G/L Balance into BC With More Details

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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    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

  • MahGah Profile Picture
    MahGah 15,419 on at
    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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    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?

  • MahGah Profile Picture
    MahGah 15,419 on at
    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.

  • Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    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?

  • MahGah Profile Picture
    MahGah 15,419 on at
    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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    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?

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,025 on at
    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

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,326 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,166 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans