1,811
Hii,
Report: Fixed Asset Balances (Fixed assets > Reports > Transactions > Periodic > Fixed asset balances)
How to achieve it by customization...following are the requirements..
a) Financial Dimensions (BusinessUnit and Employee) as new columns ?
b) When running the report on parameter window adding date filtration. From Date and To Date ?
Thanks,
*This post is locked for comments
Thanks!!
Got if finally.
Fixed Asset Balances Report data source is a query AssetBalances and this query uses View name AssetBalances.
See the screen shot and it contains all AOT objects related to AssetBalances report.
In the view AssetBalances->Fields added three fields from AssetBookMerge table and then added to the query as well.
LastDepreciationDate
AcquisitionDate
DefaultDimension
Added LastDepreciationDate in to the query Range for date filtration.
In the AssetBalances View methods added two Display Methods to get BusinessUnit and Employee from Asset Value Model.
I can directly place the financial dimensions fields on the report, but we have two companies where dimension names are different so i wrote the display methods..
On re-selecting the query in Visual Studio, Now I can see new fields, display methods and a new table for DefaultDimensions.
Now I can filter the report by LastDepreciationDate and displayed BusinessUnit and Employee dimensions on report for each asset.
#1
André Arnaud de Cal...
291,735
Super User 2024 Season 2
#2
Martin Dráb
230,466
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
