Sage 100

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…

what section in security controls access to the Orders tab in Item Inquiry?

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.

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…

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…

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…

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…

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…

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…

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…

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…

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

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!

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.…

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…

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…

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.

How do I export inventory part no, descripition & quantities? thank you, charlene

Sage 100 Advanced ERP 2013 - We want to remove the Lot/Serial Numbers with ZERO Quantity on Hand so that they do not appear in Physical Count Entry or anywhere else for that matter. I've tried the Purge Lot/Serial History Utility in SO without success…