Hi All,
I'm creating a fixed asset register and am struggling to get a book value for assets at a given date (eg 28/02/2011). The closest I've been able to get is returning the current book value (31/10/2011). The table I'm attempting to use is "FA Depreciation Book".
Any help would be greatly appreciated :)
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Ally,
I took a quick look at the "Book Value" field on the FA Depreciation Book table in NAV. It's a flow field that is defined like this in standard NAV:Sum("FA Ledger Entry".Amount WHERE (FA No.=FIELD(FA No.),Depreciation Book Code=FIELD(Depreciation Book Code),Part of Book Value=CONST(Yes),FA Posting Date=FIELD(FA Posting Date Filter)))
So basically it's summing the Amount field from the FA Ledger Entry table with the specific fixed asset number and depreciation book code from the current table, where "Part of Book Value" is Yes and (here's the important bit), where the fixed asset posting date is the value of the "FA Posting Date Filter". So you have 2 options here. You can continue to use the FA Depreciation Book table and filter for dates on the "FA Posting Date Filter" field. Or you can get sums from the FA Ledger Entry table directly (which is what the flow field is doing anyway) and filter appropriately there. Does this answer your question?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
Just wanted to say thanks - that answer helped me a lot. I ended up using this NL function:=NL("Sum","FA Ledger Entry","Amount","FA No.",$C10,"Depreciation Book Code",R$7,"FA Posting Date","<="&$H$6,"Part of Book Value","True")Where C10 is my FA Number (which I have as rows), R7 is my Depreciation Book Code (which I have as columns) and H6 is my end date.
Please sign in to leave a comment.