Skip to main content

Notifications

Announcements

No record found.

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

Rounding difference - automatic dimension

Posted on by 22

Hi all,

In my firm we use the costcenter dimension to account for cost per business unit. In all G/L entries this dimension should be filled.

In the 'General ledger setup' I set the 'Appl rounding precision' to 1 and in the vendor posting group I assigned an account for the rounding. This all works fine. However when I post an application the general journal is fine, except that it lacks the costcenter.

I tried using dimension same code and code mandatory with a predefined value in the 'G/L account card' but nothing changes. It still remains blank.

Is it possible to setup that it will automatically fill the costcenter?

Thanks in advance.

  • Roy1987 Profile Picture
    Roy1987 22 on at
    RE: Rounding difference - automatic dimension

    Hi Bryan,

    Your thoughts were correct.

    If the Vendor had no dimension set or only afterwards it did not work.

    When I added a cost center to the vendor, than posted a total new invoice + a total new payment. The cost center was automatically set when using the application.

    Not really what I was hoping for, but at least now I know how this functionality works. Thanks.

  • Verified answer
    RE: Rounding difference - automatic dimension

    Hi Roy,

    I'm doing well too, thank you:)

    I'm not quite sure on your exact scenario so let me ask you some questions so I can better understand where you are at in your processing...

    1. Is the Payment you are trying to apply to an already posted payment, and you are just going into the Vendor ledger Entries and trying to apply it against an Invoice?

    2. If #1 is TRUE, then does the Payment itself that was previously posted have a Cost Center dimension value on it?

    3. Or is it that the Payment is not posted, you are about to pay it but before posting the payment journal you are trying to apply the payment you are about to post to the Invoice.

    I may have been assuming in my last response that the Payment was not posted/created yet when you had the Dimension value on the Vendor.  If you have the Dimension value on the Vendor, and then you create the payment....I would think the dimension value that is passed onto the payment would then be inherited onto the application rounding entry.

    Dimensions can be tricky and don't work so well if you have posted entries and then all of a sudden want to change the rules and have code mandatory.  Now we are left with one set of data with no dimensions, but then when you set the new dimension rules, the old data causes issues.

    If you have a Cronus database, I would suggest to try these tests.  Please let me know what situation has occurred from your questions and I'll try to respond as soon as I can.  Thanks much!

    Bryan

  • Roy1987 Profile Picture
    Roy1987 22 on at
    RE: Rounding difference - automatic dimension

    Hi Brian,

    Thanks for your reply. I am fine and hope you as well.

    I can't confirm or deny your solution. I tried to do so, but when I am in the 'Apply Vendor Entries'-screen, it does requires the cost center. However when I press 'Post Application' my Costcenter suddenly disappears. Is this something you are familiar with or something I should consult our implementation partner with?

  • Suggested answer
    RE: Rounding difference - automatic dimension

    Hi Roy,

    Thank you for posting your question in the NAV Communities.  I hope you are doing well :)

    In the example you provided, the Dimension will not pull from the GL Account.   Instead however, it is the GL Account that you are specifying that needs a Dimension (Code Mandatory or Sames Code) when posted to it.  In that regards, you would want to set a Dimension Code on the Vendor. 

    Thank you.

    Bryan

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans