Rounding problem

amisdesagaamisdesaga Member Posts: 9
In my country, the accounting is done on whole values that is to say that all amounts are always rounded to 1 franc higher.
How to take this into account in Microsoft Dynamics NAV 2016? I noticed that in the rounding parameters of accounting parameter, the amounts are rounded in presentation and extraction of the data.
The problem is that as soon as you export a balance for the financial statements, we always see an imbalance of plus or minus 1 Franc. Also, during a letdown, some writings are still open despite visually everything is let down.
How to solve this problem of rounding on purchases / sales / journal entries?


  • Slawek_GuzekSlawek_Guzek Member Posts: 1,690
    If in your country the accounting is done on whole values then I guess all the documents you are processing, all amounts, net, tax, on these should be already the whole numbers?

    Or do you issue an invoice for total of, say 10.49 franc and record only 10 franc in your books?
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • amisdesagaamisdesaga Member Posts: 9
    Indeed, all amounts (net, taxes, etc.) are integers.
    Basically all that is accounted for is necessarily an integer value.
    For example 10, 41 or 10.52 will give 11.
  • mucamuca Member Posts: 42
    In Navision there normal (nearest value) rounding is used.
    ROUND(Amount,Currency."Amount Rounding Precision")
    If You want all amounts rounded up then You need to change all navision code where are this (ROUND) function used
    ROUND(Amount,Currency."Amount Rounding Precision",'>')
    add field "Rounding Direction" but anyway changes there will be too much, like
    ROUND(Amount,Currency."Amount Rounding Precision",Currency."Rounding Direction")

    and one more thing about how the navision document will looks like, when all amounts are rounded up.
  • amisdesagaamisdesaga Member Posts: 9
    Besides the CODEUNIT, or this function is used in addition to the codes for the sales documents (order, invoice, credit memo), purchases (order, invoice, credit memo).
  • krikikriki Member, Moderator Posts: 9,086
    [Topic moved from 'Navision Financials' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • vaprogvaprog Member Posts: 1,113
    Hi amisdesga,

    If there is a localisation of NAV for your country, use it. It will have provided for this.

    I am not sure, where rounding up is to be applied. NAV provides setup for rounding type for invoices (as far as I can tell for documents in general) and for VAT. See the General Ledger Setup table (Fields 58, 59, 66, 67, 73, 74, (75), 90).
Sign In or Register to comment.