Browse By Tags

  • 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\
  • How to obtain Quantity of Items Sold and Issued with Custom Date Range

    I am trying to export a report, by vendor (or product line), of the quantity of items sold AND issued for the last 12 months. We would like to be able to export it using any custom date range that we want. What is the best way of getting this data? I…
  • Reports

    We are trying to find an easier way to show what is on hand for a costed bill of material inquiry. The report obviously shows what the components are but we want to show the quanitityy of those components on hand. I tried checking all the reports that…
  • 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…
  • 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…
  • Custom Crystal Report - IC. Sage 300 2014 PU4

    I designed a report based on ICITEM,ICREORD and ICILOC that gives reorder quantities and some calculated columns for a parameterized input of location and item segment (from segment and to segment). These are dynamic parameters. The report DOES NOT…
  • Historical Stock Valuation

    I'm using Sage X3 (7.1.6); I'm writing a crystal report that needs to include the value of all stock as at the end of last month. Are there any simple ways to get this value? Or further still, how would I get the value of stock as at the end of…