Skip to Content
Former Member
May 19, 2016 at 04:01 PM

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


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?"