• Item Valuation Report vs Count Sheet value

    Hi, I'm preparing for our annual inventory counts and having a valuation issue. When I run the Item Valuation report as of March 31st for a range of account sets and locations it gives me a total for each location. But when I generate the inventory…
  • Adding a large amount of new inventory

    We are adding a large number of new products to our Inventory Master list which requires new part numbers, adding each part to the Pricing list, entering the quantities for each part and its location. What is the most efficient method to add this information…
  • IC Item Stock Unit Conversion Factor

    Hi..I have a question which need advise from the experts here. If the Item is 16.7g per bottle. And every time to use in IC BOM, it required 0.35g. How do I set the Stocking Unit Conversion in the IC Item? As the Conversion Factor not allow to use decimal…
  • Data integrity errors

    Am gettingthe below errors What might cause this to happen? Wjhat can i do to fix this? Purchase Order Line: PO0311816, 10, 700511-IRGP E: Item number does not exist. E: Unit of measure EA does not exist. Purchase Order Line: PO0311816, 14, 9533266…
  • GLJED CompanyID field with incorrect company ID

    We have noticed that the CompanyID field in the GLJED table does not tie up with the actual company AUDTORG field. The bulk of the record have the correct company ID, however many have either blanks or random company ID's I have checked this at several…
  • Qty in Bin Location not matching IC Qty - How do I get them to Match?

    We running SAGE 300 ERP and we have a problem with Qty in Bin Location not matching IC Qty. How do I get SAGE to automatically sync the Bin and IC Qty? Doing each transaction manually takes way to long. Thanks
  • Update Inventory Worksheet via SDK

    Hi Guys, I am having an issue while updating Inventory Counts in SAGE300. I have created the Macro but it actually does not update the Quantity Counted in I/C Physical Inventory Quantities. Has someone successfully updated /C Physical Inventory…