Skip to main content

Notifications

Announcements

No record found.

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

Recurring General Journal BD balance by Dimension

Posted on by 5

Hi All,

BC has been offering the following new Recurring method functionality since 2020: docs.microsoft.com/.../use-recurring-journals-allocate-balances-dimension-values

This looks interesting, but I can't find a good instruction anywhere on how this recurring method works. Does anyone have experience with this and even better a step by step instruction? Thank you very much!

Willem

Categories:
  • WillemNL Profile Picture
    WillemNL 5 on at
    RE: Recurring General Journal BD balance by Dimension

    Thanks Kim!

    I am now leaving the office (CET) and tomorrow will be my last day before Holidays.

    Kind regards,

    Wim

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Recurring General Journal BD balance by Dimension

    I still think you can do this effectively.

  • WillemNL Profile Picture
    WillemNL 5 on at
    RE: Recurring General Journal BD balance by Dimension

    Hi Kim,

    Thanks for your quick reply!

    My intention is somewhat different from yours.

    I have a Business Units dimension and a Departments dimension. When I post my purchase invoices during the month, I would like to post it on the Business Unit dimension (high level). At the end of the month, I would like to post with the Recurring General Journal the entries of the Business Unit to the right department of that Business Unit.

    Any idea about this set up and working?

    Thanks!

    Wim

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Recurring General Journal BD balance by Dimension

    It's really fairly straightforward. BD allows you to take an individual GL account with defined dimensions and allocate to other sets of accounts and dimensions.

    Once you set your line up with method, frequency, document number, gl account and amount, you need to define your dimension set filter. Use Line>>Set Dimension Filter. The dimension filter can be one dimension and value or multiple dimensions and values.

    pastedimage1658151934147v1.png

    Next you need to define the Allocations by using Line>>Allocations. These will be the gl accounts and dimensions that are the offset to the line you setup above. You will need to define dimensions for each line in the allocations.

    pastedimage1658151978481v2.png

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans