Price1 is showing sporadic values in Design Inventory Reports
PROBLEM:
When generating a Design Inventory Report and using the Price 1 column, some items appear with a price, while others are blank.
SOLUTION:
The difference in the items listed in the report arises from how the landed prices are calculated for serialized and non-serialized items.
Price Level 1, which applies a markup to the landed cost, is calculated as follows:
- Non-serialized items: The landed price is the next available cost if there are items in stock; otherwise, it uses the standard cost.
- Serialized items: The landed price is the standard cost, except when printing the price for a specific serial number, in which case it uses the actual landed price for that serial number. If you choose the option to “list serial numbers,” you will observe that the Price1 for serialized items will not be zero.