Browse By Tags

  • Inventory Valuation Report, Decimal Places for Last Unit Cost

    Is there a way to increase the decimal places on the report for Avg Cost or Last Unit Cost? The reporting for cost, is inaccurate as it rounds to the nearest penny. The value of many products may be based on purchases in hundreds or thounds of an item…
  • Update Inventory Item Costs

    Hi There, Slight Background: We currently operate on an Average Cost Valuation Method within SAGE 200, With that being said, we are also within the manufacturing industry and thus, once a manufacturing Process Order is closed, A finished product …
  • Stock Valuation Report by Bins

    Is there a way to add bins to the stock valuation report. I need to know the value by bins. Thanks!
  • How to match Inventory (trial balance) amount with Inventory Valuation by Category - SQL statement

    For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter. Does anybody built a report on this using…
  • Inventory Valuation Report That Includes Items on Sales Order

    Months ago I created this post about the Stock Status Report and Sales Order Qty: https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-distribution-manufacturing-and-internet-modules/110446/inventory-valuation-which-shows-available-balance…
  • Inventory value with zero quantity using FIFO

    Note: Current version is 4.4, going to Sage 2015 live this weekend. This is regarding items with all IM_ItemCost records having zero quantity (meaning, Negative cost tiers, if any, have been applied), yet one of the records has and extended value cost…