balance/amount field

mgkmgk Member Posts: 15
we have integrated Navision with a brokerage software. While we transfer entries this software to Navision, We have realized that amount field works different in brokerage system and Navision. In Turkey, Balance field calculation formula for brokerage is Credit-Debit but Navision works Debit-Credit. All reports and screens in navision works like this. Do you have any idea how we can make this calculation parametrically? For example, we may add a option in General Ledger Setup to select balance calculation option. but I don't know how to proceed afterwards. please give a light to me
thanks a lot

Comments

  • sggsgg Member Posts: 109
    You May choose to chnage the sign of your Amount fields When Reporting In Navision.

    For Instance, you may choose to show The Column Values in Opposite sign Using the Column Layout Setup for Account Schedules.

    This is also possible Using the Option "Show Opposite Sign" in Analysis By Dimension View.

    This way, you could Make your reports look as Balance = Credit - Debit
    Sunday, Godwin G
Sign In or Register to comment.