What should the Data Relationship (source and destination column) be in Fixed Asset allocation (page 46) screen
Yes, that is the out of the box data relationship and if it's generating equal values, that will work. You could also use the Cost Center column.
Hi Omar, Did you see the hint below the image on page 46?
Hint: There is really only one decent option for a matching column. If you’re stuck feel free to open a new tab so that you can look at both the Cost Source columns and Fixed Asset columns simultaneously.
You are looking for a column in the Cost Source Master Data that would have a matching value to a field in the Fixed Asset Master Data. Have you looked at the data tables to see where you might fine a match?
I did but still not sure about the correct values. Also, the formula for depreciation on page 44 – struggling with that also.
Omar Zettler | Systems Analyst II ITD | Financial Planning
9500 Euclid Ave. Cleveland, OH 44195
Check out this post. What should my formula be under Fixed Asset Ledger for both Asset Count & Depreciation Amount?
Ok the depreciation value makes sense – thanks!. How would I figure out the data relationship values now?
I didn’t see your hint at first. Let me try on my own.
Got it Cost source fixed asset key
Retrieving data ...