• batch report creation

    Hi There, Is there a way to run a batch file to change all items entered into inventory with a none reorder method to reorderpoint? Thanks in advance, \\shane\
  • Point in Time Inventory

    We have purchased a company using Sage 100 and will need to identify the inventory on hand at a particular point in time. The ERP system we have has all inventory transactions in one table, thus it is possible to start at the end or the beginning and…
  • Sales Order - Stock Status on Sales Order Quantity and Sales Order by Item Report Quantity are Different

    For one item / warehouse (that we know of so far), the On Sales Order quantity listed on the Stock Status report and the quantity on the Open Sales Order Report by Item report do not match. Actually a difference of 4300. Can't seem to find a reason. I…
  • Report Automation with Sage Alerts

    Is it possible to set up a Sage Alert to run a system report on a schedule? I want to get the Inventory report Multi-Bin QOH and Valuation Report to email on a schedule, but I can't get the report to generate values unless I run it through Sage. I've…
  • INVENTORY VALUATION AND GL ACCOUNT DIFFERENCE

    My inventory valuation report is pulling around $9 million dollars and my GL account inventory is pulling around $ 1 million. anyone know how i can fix this or see what the difference is ? Thank you,
  • RECEIVED PO / MISSING INVOICE #

    Hello, Is there a way to show which PO's that have been received in are missing an invoice? We just switched over from Sage 50 and when the warehouse would receive material in, they would check off the box "waiting on bill". That way I could then just…
  • 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…
  • Crystal Report Data from IM

    Trying to get a very simple report from IM. Item Number, Reorder Point, Quantity Sold YTD and PY along with a calculated field. The Reorder Point prints fine as do other fields such as Quantity On Hand and Quantity on Sales Order but I get nothing…
  • Inventory Stock Status Report vs. Physical Count Variance Register

    We are currently using MAS 200 for inventory reconciliation. I use the stock status report to balance our physical counts to MAS, giving us a potential variance amount. Once I enter the physical count numbers into physical count entry I am finding that…