Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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?
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…
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…
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…
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…
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…
The Bill of Material allows a parent item with components.
Is there a way to create a serial number for the Parent Item and then assign serial numbers for the components? Thanks!
I just want to bounce some thoughts around. We're a manufacturing and distribution company. We are trying to take into account how many boxes we use for packing our finished goods. These finished goods are sold to our intercompany via p.o and receipt…
How do you handle purchase orders for non-inventory items. Two examples - 1) the office heater is broken, we call repair shop to fix it - PO needs to be created to match up with billing invoice,do you just use a comment field? But do you still have to…
We have a ton of components that are set to INACTIVE, that still show up on the WHERE-USED Inquiry lookup and the WHERE-USED Report. How can we get them to not show up? We tested an item and set it to Discontinued and set it to Inactive but it still shows…
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…
My question is what's the correct way to bad debt an inventory item? We have an item that we want to take out of inventory and put to bad debt. I have played different scenarios in my head but not sure which way is the proper way and which GL's it's going…
Hello All,
I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…
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…
My inventory valuation report is pulling around $9 million dollars and my GL account inventory is pulling around $ 1 million. anyone know how i can fix this or see what the difference is ?
Thank you,
Does Sage 100 (v. 2019) provide a method for specifying minimum order quantities by vendor for inventory items? We know how to set minimum order quantities for an item at the warehouse level using "Reorder Maintenance," but we have not found a facility…
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…
Hi!
We have recently created a second warehouse in our system and are trying to find the most efficient/effective way to transfer the inventory in the system as well as physically. I know there is a transfer option in inventory management, but we are…
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…
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.…
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…
To start off, we are on Sage 100c Advanced v2018.2
How can we append an original Lot # when transferring qty from 1 whs to another?
Create PO for Qty = 100,000.
ROG the full Qty 100,000 to an offsite warehouse ("OFF") with Lot # 12345.
When when…
