Browse By Tags

  • Cost Tier Adjustment

    Adjustments to inventory value are made using Process Cost Tier Adjustments task. Here are some important things to know about cost adjustments : Inventory Quantity cannot be adjusted through Cost Tier Adjustments. Quantities in the cost tiers are…
  • What is the difference between the Inventory Cost report and the Inventory Valuation report?

    What is the difference between the Inventory Cost report and the Inventory Valuation report? Why is there an option for both Cost and Valuation in the Cost report? The differences between the Inventory Cost and Inventory Valuation reports are primarily…
  • Cost Tier table schema

    The cost tier is an important costing feature provided by IM which allows the system to track the actual cost at which an item was purchased every time. Sage 500 stores the cost in table timCostTier . Here is the schema for that table: A cost…
  • Average cost calculation

    Client has a few items with really far out Average costs. Supposed to be $1 and shows $950 Average cost. The MRC is good and last cost is good. Is there a way to fix the average cost? There was an adjustment done a few months back that was in error…
  • Trying to create a report in SQL that pulls all costs for an item.

    I am trying to create a report that pulls all OE sales by month and includes standard cost, average cost, most recent cost, last cost, alt cost 1 and alt cost 2. I can't seem to find which table or view has all of these costs. It looks like they are…