Sage 100

Good Afternoon Does anyone have feedback on Scanco Warehouse as a solution to automate receiving inventory transfers and shipping? If you have experience with this product would you recommend it? We are struggling with the decision as the receiving…

We brought in some shelving - they are in inventory at a cost of $5. Now we have to send some of these out to get painted - the painting is going to cost $2/shelf. What is the best practice to bring these items back in at $7/shelf - but pay the painter…

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…

Looking to see quantities and part numbers and value of transactions to tell how many pieces we are selling vs allocating into work tickets. We stock part numbers that could be sold directly to customers or allocated into larger bill of materials/work…

Hello, I have a bunch of custom scripts that get triggered Post-Write on different tables, for example, sales order, item, alias, etc. Only one script would not trigger, and I can't find why. The script should trigger Post-Write on the table IM_ItemWarehouse…

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…

Hello, I am running into an issue when importing vendors. We are mass importing items along with the vendors, but are running into a block on the vendor import. It appears that this popup might be blocking the vendors from being imported. Is there…

Where do I start? We are a manufacturer and I purchase raw materials and sell the finished product. I currently use the sales order module for sales orders & invoicing. I need direction and recommendations.

Hi guys, Would you please lend me your hand in finding the table that stores beginning qty (and also value) for inventory? Basically, i'm trying to replicate the "5.History" tab in Inventory Inquiry. I've looked into IM_PeriodPostingHistory, IM_ItemWhseHistoryByPeriod…

Hi, When I do an inventory inquiry, it shows 104 of an item on hand, but we only have 40. I couldn't do an inventory adjustment of -64, because there are less than 64 to distribute. How do I get the inventory that shows on hand in inventory inquiry to…

Hello to all, Have a question regarding Weighted Average Cost and FIFO when returning purchases to vendor 1- Weighted Average Cost we have following purchase: 10 unit @ $20 & 5 unit @ $15 so average cost per unit is $ 18.33 = (10*20)+(5*15)/15 after that…

Hi There, Is there a way to run a batch file to change all items entered into inventory with a none reorder method to reorderpoint? Thanks in advance, \\shane\

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?

We are producing a custom item for a customer. They will be charged $20,000 for their first order on Net 30 terms...which covers the full run. They will only be taking a portion. The remainder will be on our property and when we ship out any of the balance…

I am really new to Sage program. I ran a physical count variance report after a physical count was done. However, the Quantity on Hand shows zeros for every item. What did I do wrong> Thank you

We have purchased a company using Sage 100 and will need to identify the inventory on hand at a particular point in time. The ERP system we have has all inventory transactions in one table, thus it is possible to start at the end or the beginning and…

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!

For one item / warehouse (that we know of so far), the On Sales Order quantity listed on the Stock Status report and the quantity on the Open Sales Order Report by Item report do not match. Actually a difference of 4300. Can't seem to find a reason. I…

When attempting to create line items for a Inventory Transaction Receipt batch I'm having issues when I attempt to update the distribution. my code was working on Sage 2018 but they are upgrading to Sage 2021 and it now throws an System.Runtime.InteropServices…

Do you have to list a product type on the Item Maintenance screen? What if you don't want to breakdown your inventory items?

Hello, Where in Sage can the user update IM_ItemWarehouse > BinLocation? We had Scanco's MultiBin product and are in the process of disabling it, and there are values in this field but I can't get at them. Thanks!