Sage 100

I created a UDF Table with 3 UDF fields in the Inventory Module (see photo). Is it possible to add this UDF table to the Inventory Maint./Inquiry ALE look up on Available Fields section see photo..

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…

Hello - we are using Sage 100 Premium 2021 and I have questions about item kits/kit explosions. Item Kit "ABC-KIT" has 3 components: Components: ABC-001 ABC-002 ABC-003 Explode Kit field is designated as "Always" SOs show the following…

USING SAGE 100 ADVANCED 2021. Is there a way to create a warehouse that does not apply any unit cost to an item? we want this new warehouse code to hold items that will eventually be replaced by the factory. so if we receive a container full of…

Hi. we are currently on Sage100 Advanced 2021. We are a drop shipper which normally only sells the items it receives from overseas in the same box it is received in. We are looking at grouping items as bundles and trying to sell as a collection. …

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,

I am trying to export a report, by vendor (or product line), of the quantity of items sold AND issued for the last 12 months. We would like to be able to export it using any custom date range that we want. What is the best way of getting this data? I…

I need to add several hundred product from our website into sage. I can export product codes from our website, and I'd prefer to format descriptions on one master excel sheet. Can you "mass add" products using VI? I'm a bit new to VI, so I wanted to ask…

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…

Currently we are on Sage 100 2014. We have finished product that is assembled from homeworkers and received/entered via Inventory Adjustment / Receipts. In this entry we calculate the cost of the item based on the raw materials and the labor to assemble…

We have the expiration add-in, and the shipping department tried to ship out some expired product (intentionally), but got a message saying that these products are expired, without any option to override and ship anyway. For some reason, when I try to…

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…

I understand how negative OVERDIST tiers occur, but a bit fuzzy on how positive OVERDIST tiers occur. Is there a good write up that someone has done that explains this process for both myself and my clients?

Hello, We are a distribution company that is looking to implement a WMS that can integrate with Sage 100. Preferably one that can stand alone as well. We are going through some growing pains and may also be looking to a new ERP in years to come. May…

We are currently using MAS 200 for inventory reconciliation. I use the stock status report to balance our physical counts to MAS, giving us a potential variance amount. Once I enter the physical count numbers into physical count entry I am finding that…

Hi, Let me start by saying I am new to MAS90. The issue we have is trying to create an 846 doc (using Gentran Director). We have a report called Inventory Stock Status Report, that give's the information that I need for my 846 document. but when I try…

Are there any fields in inventory management to enter a product's case dimensions, legnth, width, height? also block and tier for pallets? Or is the only way to create UDF's for these? Thanks

Good Afternoon, I am hoping to get some help with customized inventory reports. We had a MAS upgrade this past fall and it has recently come to our attention one of our reports was not transferred. I have copies of the report; this helping me know…