I have posted an entry in the FA G/L Journal to write down an asset. However now my sub ledger does not match my general ledger. The asset account and the accum depreciation accounts are off by the same amount. (amount of entry) What did I do wrong. Please Help??
What did you choose as FA Posting type and what exactly was your intention?
Write-Down - is used to lower the “value” of FA, e.g. revaluating a heavily worn out, but still working machinery and so on;
Dispose - completely get rid of FA, either selling it or moving to junkyard. In this case a series of postings are made, as writing off possible remaining book value, moving accumulated depreciation to corresponding GL accs, and in case of sale - gain/loss from it depending on sales price & book value at the moment of sales.
I used FA G/L journal. My objective was to lower the value of the fixed asset, which it did in the general ledger but not it the subledger. Also for some the reason the same amount was increased in the accum depreciation. I really cant understand it.
In FA ledger there should appear an entry… F9-Statistics from FA Card should reflect the changes - check WriteDown and Deprec.basis, drilldown in these fields must contain your entry.
Check in FA Posting groups - seemingly you have set up the same GL Acc for Write-Down Expense Acc as Accumulated Deprec.Acc.
In the FA Posting groups the GL acc that appears in write-down is P&L account - Impairment loss on fixed asset, so not the same as accum dep.
In FA PG there are 2 columns:
Write-Down Acc - this should be Balance acc, kind of 1330 Decreases during year in DEMO base, it is NOT the same as 1340 Accum.deprec. Does your CoA have a similar account? Or here you’ve set up the Accum.deprec. account, which is not correct from accounting point of view.
Normally there should be separate balance accounts for regular depreciation and other decreases of FA value, as well as increases are not the same as acquisition cost unless you purchase some new part for your FA, not revaluate it…
Write-Down Expense Acc - this should be a P&L acc, in your case - your “Impairment loss on fixed asset”
When a type=Write-down posting is done, Navision creates a Db W-DEA / Cr W-DA entry in GL. If in your case it hit the wrong GL Accs, it is setup problem, not Navision inaccurate behaviour.