Trying to get a complete history list of inventory balance and quantities can be difficult. The IN.INItemCostHist table only contains a value if the inventory balance has changed from the previous period and is missing rows if the period did not contain have any transactions. For example, the AMPCB item…