Hi All,
I am new to DAX development area.
I've been assigned a task to create location wise fixed asset report according to following format:
| DOP |
Location |
Code |
Group |
Decription |
Cost |
Depreciation |
Accum. Depreciation |
Net Book Value |
|
7/1/2016
|
ABC
|
RE013
|
AC
|
AC-2-RE013
|
45,000
|
20%
|
25,600
|
19,400
|
I've already created the report up to 70% but i am not able to find the Net Book Value and Fixed asset depreciation value from any DB table. Here are the tables which i've closely analyzed.
[ASSETDEPRECIATIONPROFILE]
[ASSETBOOKTABLE]
[ASSETTABLE]
[ASSETBOOK]
[ASSETBOOKMERGE]
[ASSETTRANS]
[ASSETBALANCES]
Can anyone please help me with this issue. Where to find depreciation value and net book value from database. I've to submit the report very soon.
Thanks in advance.
|
R
select * from [dbo].[ASSETDEPRECIATIONPROFILE]
select * from [dbo].[ASSETBOOKTABLE]
select * from ASSETTABLE
select * from [dbo].[ASSETBOOK]
select * from [dbo].[ASSETBOOKMERGE]
select * from dbo.ASSETTRANS
select * from ASSETBALANCESelation
|
Account code |
Account selection |
Item
code
|
Item relation |
| Price (sales) |
Group |
TrdAgrWS |
Table |
000103 |
*This post is locked for comments
I have the same question (0)
