• Inventory economic reorder method doesn't recommend ordering enough to meet quantity available..

    I'm struggling with how Sage 100 calculates the suggested reorder quantity when using the ECONOMIC reorder method on an item. It determines reorder is necessary based on quantity available but then only recommends ordering the amount in the Economic Qty…
  • Quantities Grid; Available field (Required for Work Ticket)

    Is there a way for the Available field to automatically take into account the "Req for W/T" quantity? It seems completely illogical that the On Hand Quantity is the same as the Available when parts are needed for an open Work Ticket. I mean it takes…
  • 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?
  • IP TYPE CODE

    Does IP Type Code show up in transaction tab for all items during inventory count or does it only show up in the transaction tab if a count was made towards the item?
  • 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…
  • IZ TYPE CODE

    How does an IZ TYPE CODE IN INVENTORY TRANSACTION ENTRY populate?
  • Product in Shipping but no Sales Order To Review

    Hello Sage Community, Todays question is how to find order(s) in shipping that I cant find! In the image below, I have the part in Shipping and cannot find it!! I've reviewed numerous orders and shipping batches that are not updated yet, they are nowhere…
  • 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…
  • QR Barcodes Length

    Hello, Our manufacturer recently changed our old barcodes to the QR barcodes, however, when we are trying to scan the products into SAGE 100 it is not taking the full serial number length. Is there a way I can update the serial length within SAGE…
  • NEGATIVE QUANTITY I REPORT, BUT IN "ITEM INQUERY"

    Hello all again, I've been getting some very good advice here lately, thank you all! I create a custom report in the "Item List" that includes "Total Quantity On Hand". The issues I have is when the report shows a negative qty, however the Item Detail…
  • Full Inventory Inventory List w/filters

    Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
  • Inventory transfer form out of MAS

    Has anyone ever created an inventory transfer form that can be generated out of MAS that a shipping department can complete. I am looking for a picking sheet type of form but the item is simply being transferred from one warehouse to another (therefore…
  • CHANGING MULTIPLE ITEMS "INVENTORY CYCLE"

    Hi all, Boy I sure wish it was easier to look up SAGE help ANYWHERE on the internet... I need to modify hundreds of items "INVENTORY CYCLE" code/status. We just did Inventory and out of 87 pages printed, there were actually only around 6-7 pages of…
  • 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…
  • Report of Inactive Items ONLY

    Good morning, I need to produce an inventory report of ONLY the inactive items/SKU's. In the Inventory Item Listing report there is an option to include Inactive items, but I don't see a mechanism to report ONLY inactive items without ALSO including…
  • RETURN AND ALLOCATIONS

    I don't work in shipping but I had a shipping question brought up to me. We have a customer that placed a rather large order. They notified us that they made a mistake and ordered too much of one item. To avoid a ton of work, I did a return of just the…
  • permissions in Item Inquiry Orders tab

    what section in security controls access to the Orders tab in Item Inquiry?
  • COMMITTED ITEMS NOT ACTUALLY SHOWING ON ORDER

    Hey there I have an issue with an item showing that it is on sales order and its committed but we have no open sales orders with the item nor back orders. I'm also going to mention that we use multi bin and I can see that 7 are set in a warehouse but…
  • Allow Trade Discount

    Is there a utility that will allow me to check the "Allow Trade Discount" box for a range of inventory items?
  • Expanded Price Levels (DSD IMXL)

    I have an end user that is considering DSD's Expanded Price Levels enhancement. I am a little nervous adding an enhancement that will have such a large impact on Sage 100. Just wondering if anyone has any experience with this enhancement. If so, are you…
  • Item Code Setup

    In Item Code Maintenance where you set up the units of measure. What is "SALES" used for? Is it used for sales to an end user, or is it used for the recipes/bill of materials/costed bill sales?
  • 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?
  • Inventory Usage Reports by Product

    Good afternoon, This question is related to inventory management. I work for a company which has several locations treated as separate warehouses in the inventory management module. We use physical counts to determine materials usage for Cost of Goods…
  • Multi-Bin Location Maintenance

    I need to delete approximately 1200+ bin locations. Please tell me there is a way to mass delete? Thanks for any assistance.
  • 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…