Browse By Tags

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?

HI Bit annoyed with Sage online support, just sending me links to training video's and knowledge base articles. No where it shows what I am after. In any normal purchase cycle, small/micro business or massive corporate, suppliers deliver goods without…

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…

Is there a utility that will allow me to check the "Allow Trade Discount" box for a range of inventory items?

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!

Hi All, I was wondering if anyone has used any 3rd party inventory solutions with BW. We find that the inventory module isn't quite doing enough for us and are constantly forecasting/managing inventory levels using excel via an ODBC connection to be…

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…

Hello everyone, We are a currently using an external software for our inventory needs and we are looking into Sage's Inventory module since it talks to other modules. Is there anyone that is currently using the inventory module? Please share with…

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…

Hello, We were performing an inventory count however one of our employees made a stock transfer from one location (being counted) to another. When we look at the part number through the inquiry function, we see the appropraite quantity in each location…

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,

Is anyone able to walk me through the building of an inventory item from start to finish? I'm confused on how to use the program for this... I have a single product, we have multiple things that went into creating this product. I want to be able to track…

Hi there, My company has several Inventory Items that we would like to remove from our system for various reasons. Our supplier has discontinued them, upgraded to a new version, etc. However many of these inventory items have been sold to customers…

When entering stock issues the unit cost always pulls the average cost and as a result we have to manually update the unit cost to our most recent stock receipt cost. Is there a way to have the unit cost when entering stock issues automatically pull the…

Hi! Will there be some way in which I can create two types of inventories? For example: I want an inventory for the stock merchandise and another for the transit merchandise or the merch that is ordered Let's called the stock merch inventory 01…

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…