• Enabling Return for Items?

    We are testing items to return in RMA, but we are getting the notification that the item isn't setup for returns. Where can we enable this?
  • Auto filling Inventory from Receiving Purchase Orders

    We are using Scanforce to receive our purchase orders once they are placed. We can see the receipts in the Receipt of good entry section once they are received, but would like to see the inventory auto update to our on hand stock once received. Do we…
  • Template No. Question

    We have a company with BOM turned on as well as Production Management turned on. A few questions have been asked about having a template number on an item in Item Maintenance. The issue with this is for us an item could be used in multiple different product…
  • Negative quantities for Sale Order.

    We have 2 items in our inventory, that show an SO for a negative amount. I cannot find an orders that have negative amounts and no orders that match the quantities. For example, we on hand 110 units of product A with SO of -15 and an available inventory…
  • permissions in Item Inquiry Orders tab

    what section in security controls access to the Orders tab in Item Inquiry?
  • Retaining history when changing item code

    Is there a way to change an item code or merge with a new item code while retaining the sales history from the original code?
  • Query data from IM_PeriodPostingHistory

    Hello, I'm trying to export the history tab of Item Inquiry window (see above) to excel sheet for reporting purpose. I created query which pulls data from the table of IM_PeriodPostingHistory. However, the beginning quantity of each month shows 0…
  • Error Message when using Delete/Change Items

    I am getting this error message when I am going to rename these items. Has anyone every encountered this? I've never seen it before.
  • Serialized device floating in limbo.

    I was in the middle of Transferring two Serialized Devices from one Warehouse to another. While in the middle of this sage crashed. Now when I go back in the devices still say they are in the same warehouse but they are not available. How do I fix this…
  • Item Valuation Change Selection: Phantom Connected Users

    We have had this problem since switching to Sage 100. When we try to change an item's valuation in the Item Valuation Change Selection task in Inventory Management, and all users are logged out of Sage, we get the below dialog: When I click More…
  • serialized items are showing as available but they have been invoiced

    We are showing a serialized item on hand and available, but it was sold in November 2021. History shows the item was received and sold, with no further movement on this serial number It's still showing on the Inventory Valuation Report - item in…
  • Earmark part of a LOT Number not for sale

    Trying to figure out if there is a way to reserve a portion of a LOT Number for Make to Stock finished goods. For instance: The company I work for makes paint. If we make a batch of a particular color, give that batch a LOT Number and enter it into…
  • Open PO Qty vs On PO qty discrepancy

    Hello All, We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty. SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts In the below example, in main I m seeing a open PO qty but in…
  • Item Maintenance>Order tab

    I have a lot going on in this pic but a recent upgrade to v2019 Adv with Production Management show on the Item Maintenance Orders tab the choices Work Ticket (s/b Purchase Order and they are under there) Sales Order and Work Order (looks like it should…
  • Inventory with serial numbers

    We have a finished good that is serialized, however we will now be selling this item with an additional component that we would like deducted from inventory automatically. We had considered changing the serialized item into a 'kit', however that would…
  • Item Maintenance Tab Orders Count

    Hello, I am trying to come up with a counter for the number of orders (Standard or Backorders) that an item is on. So far I have tried a script that counts the line inside of SO_SalesOrderDetail but it won't write to the two UDFs made in CI_ITEM. Has…
  • Can't Add New Product Codes in Item Maintenance

    When we enter a new item code into "Item Maintenance," it used to create a new product in the system. However now when we enter a new product code, everything goes blank, but it says "NEW" right by the Description (as it would do before). Everything else…
  • Item Cost showing in IM-Transaction Entry for ISSUES

    Has anyone found a way to have Item Cost show in the line information during an Inventory Management Issue transaction? Thanks, Erin
  • Change Default for Inventory Valuation

    Does anyone know how to change the valuation default in Item Maintenance from Standard to Lot? Trying to prevent incorrect entries when setting up a new inventory item. Thanks for your help!
  • Quantity Avaiable field

    Hello all, I am trying to find a way to solve an issue that I have with how the Quantity Available field is displayed in Item Inquiry. It's kind of a difficult issue to explain but I'll try my best here: Lets say I have 300pcs of an item On Hand.…
  • Food Service manufacturer and distributor

    FormerMember
    FormerMember
    My company is a broad line food distributor and we also manufacture deli products such as bologna, salami, etc. We carry about 1,500 different items. There are about 10 employees that work picking order throughout the day and night and its all done on…
  • Reverse Item Merge

    Merged over 3,300 items to code "Z_Discontinued" after months of working with staff to make sure all items on list were approved for merging. Now they need 2 of the 3,300 items restored, historical data. I created the original item numbers and setup…
  • Back Order Fill Report (From posting a PO Receipt of Goods)

    The back order fill report included drop ship line items from sales orders. It would seem best to exclude drop ship as those lines will not be filled from the warehouse. Rich Garrett DSG, Inc.
  • VI Export Inventory quantities

    How do I export inventory part no, descripition & quantities? thank you, charlene
  • Historical Inventory Quantities

    Hello Sage 100 Community. I was wondering if any of you know a way to view an inventory snapshot of a particular date in history (historical inventory quantity). I'm just trying to see the quantities for all items at a particular date in the past. …