Start Rebuild Inventory Cost Table

This new starter function creates and fills a new table 'Item_Costs_By_Lctn' (dropping a pre-existing table if one exists). When this function is run, it will create a snapshot of inventory costs at each location at that moment in time that may be used for reporting purposes. Note that although the table will exist in your database, a View is not available in SAM Pro.

If your firm has a significant amount of inventory history, you may wish to run this function after hours. Reports that access this table should be run as soon as possible after the function is run. This table will contain the following columns evaluated for each combination of item and location in the invntryitmlctn table:

    invntryitm_rn
    lctn_rn
    qntty_on_hnd
    avrge_cst
    lst_cst