Skip to main content

Notifications

Announcements

No record found.

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

Rounding Unit Costs is Mayhem...

Posted on by 24
BC newb, trying to understand what we need to do to unify the rounding precision across all forms and reports. We're having an issue where fields will sometimes round up or down at their own will. It throws our reports off and makes life hell for our billing team.
 
Take a look at line items 1 and 3. They are the same item, different unit cost/ unit amounts. Some are rounded up some are rounded down. Absolutely no idea why or how we fix this. To make matters worse, when I run the Inventory Valuation report, line item 3 will show as 1.42, even further rounding up? Help Obi wan Kenobi, you're my only hope!

//
Categories:
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,926 Super User 2024 Season 2 on at
    Rounding Unit Costs is Mayhem...
    We don't want everything to be 2 decimals places, we need the 5 places for internal costs / reporting, but 2 decimals for external things like invoices.
    That is how system is setup up by default. So if You haven't changed anything, it should be like that.
     
    regarding Your last comment:
    "our item that cost us $1,417.50 is being rounded up to $1,418. If I sell 250,000 of those my costs are way off. "
     
    here You are wrong. If You bought 1000 items, for $1417,50, then even if the system would show Your unit cost for 1 item 1,418  and You would think that once you sell all 1000 items the costs would have a difference of $0,50  but actually the difference would be 0. System does adjust the unit costs - so that the outgoing items are always with the same cost as incoming items. 

    Even if after few weeks you get additional costs for delivery for these items, You can add it and system will re-calculate all the already sold item unit costs.
  • Tricon916 Profile Picture
    Tricon916 24 on at
    Rounding Unit Costs is Mayhem...
    We don't want everything to be 2 decimals places, we need the 5 places for internal costs / reporting, but 2 decimals for external things like invoices.

    We sell items that are sometimes listed as per thousand, or EACH. So an item that is $2,375 per thousand, would have a cost of $2.375 EACH. You can see how this would effect our reports because in the example above our item that cost us $1,417.50 is being rounded up to $1,418. If I sell 250,000 of those my costs are way off. 
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,926 Super User 2024 Season 2 on at
    Rounding Unit Costs is Mayhem...
    Not sure if You want all to be rounded to 2 digits after decimal point?
    Then in General Ledger Setup edit the field Unit-Amount Rounding precision = 0,01 and Unit-Amount Decimal Places = 2:2  (it will affect the field Unit Amount in Item Journal).  And as previously suggested it is also possible to provide the needed rounding for Invoice and VAT amounts. Usually these are by default 2:2. Last place to look is in case the transaction is in Currency - then in the Currency list, for each currency You can also set up how amounts in each currency are rounded and how many decimals are displayed after decimal point.

    But in Journal lines - system is somehow built in to auto-correct roundings... for example if you have two entries for the same quantity for amount1.415   - then one will be rounded to 1.42 and the other one will be rounded to 1.41  = therefore the total quantity value is the one You entered 1.415

     
  • Tricon916 Profile Picture
    Tricon916 24 on at
    Rounding Unit Costs is Mayhem...
    Mine is similar, although I'm not using VAT, but looks the same to me? Other than the Inv. Rounding Precision?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,647 Super User 2024 Season 2 on at
    Rounding Unit Costs is Mayhem...

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