Showing results for 
Search instead for 
Did you mean: 

Why are Fixed Assets and Item Master Data stored in the same table?

Former Member
0 Kudos

This doesn't make sense to me. For instance, I have a query that I want to create where I can pull either the NBV of an item if it exists, or the avgprice if the NBV doesn't exist. I know that the fixed asset is of ItemCode XYZ, but Fixed Assets assigns it the name FA123 instead. As a result, it's difficult or impossible to join the fixed asset to its associated item in the system.

This isn't asking for help--I figured out a way to make the formatted search work how I wanted (involving CTE, etc), but more of a general "Why is it this way?"

Accepted Solutions (0)

Answers (2)

Answers (2)

Active Contributor
0 Kudos


It does make some sense, as they are similar in nature, and can still be bought & sold

We have got around this by using a MfrCatalogNo for the asset which is the same as that for the itemcode, so this allows for us to identify them together in queries

Active Contributor
0 Kudos


I think the main reason is that in older versions OITM is the used table.

Kind regards

Agustin Marcos Cividanes