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.