Tuesday, July 7, 2020

Norming Asset Management - Reducing Method Formula



Sage 300 Fixed Asset -Norming Asset Management formula for fixed reducing balance method


The fixed reducing balance method in norming AM requires to write a formula. I have struggled to find the right one and hope this will help someone else.

If there is no salvage value for the asset, this formula should work:

AMASST.BKNETVAL * BRT /100

However, if there is a salvage value then:

(AMASST.BKNETVAL -BSV)* BRT /100

Notes:
AMASST.BKNETVAL = Master Date Net Value
BSV= Salvage Value
BRT=Depreciation Rate

If this solution does not work for you or you find a discrepancy, feel free to comment.


No comments:

Post a Comment

Norming Asset Management - Reducing Method Formula

Sage 300 Fixed Asset -Norming Asset Management formula for fixed reducing balance method The fixed reducing balance method in normin...