Fixed Assets Balance by Asset to today. This can be modified to get a balance at a point in time by replacing getDate() with a particular date.
AX Version:
Module:
CREATE VIEW...
Continue Reading Nathan Clouse’s Article on their blog
Fixed Assets Balance by Asset
Blog Syndicated with Nathan Clouse’s Permission