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…

I am looking to update the item locations for a large number of SKUs, is it possible to update that information in bulk via an Excel upload or something similar? I don't want to have to open each SKU individually in Item Maintenance and update them if…

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…

Where can I find a detailed explanation of how Item Maintenance works and what each valuation does and setting up Units of Measure? We have a terrible habit of just copying what is done for other items that have been set up in the past. I want everyone…

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…

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…

I have clients using Work Order with scanco Multi-bin with License Plating/Pallet for over 6 years and it works great. It has the same Pallet ID Production screen in WO Completions and in BOM production entry to auto generate. After installing the upgrade…

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,

When I enter the purchase order, I s elect the standard order type as shown below. And the PO already has been issuing invoice and batch also has been run. So now the amount of PO shows as inventory G/L account. But it should be purchase G/L account…

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…

Is it possible to search by alias number within Item Inquiry or Item Maintenance? How?

We have items that we purchase as expense items but for which we need to manage quantities. Therefore, we want zero unit costs across all warehouses and zero Last Costs. We have a lot of years of data and there are current open SOs and POs. Once the unit…

Good Afternoon, I am creating a part number in Sage 100 and it is a finished good that's procurement type is a make. From what I have been taught, if it is this kind of finished good, I fill in the Retail price and the Standard price but do not touch…

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…

I was wondering if any one has done this type report I did a custom crystal report that i'm able to see specific item code, but for some reason when i'm running the report those item codes that doesn't have any transaction history is not showing and…

When I print the PO it lists the item on the PO twice, once for each alias. Is there any way to have multiple alias for same item/vendor or do I have to create a new item key? Reason being is the vendor sells same product from 2 different suppliers.

We have a packaging company with a large variety of items which are packed to order. As we don’t prepack, virtually all our sales are through kits with the option selected to “always explode”. We do have a bill of materials (BOM) for each kit as items…

We recently upgraded our ERP to Sage 100 5.10.4 and it appears we lost a magnifying glass in the upgrade. Under the Inventory Management module -> Reports, we don't have the option of using the Magnifying Glass for Item Description anymore. It was available…