Sage 100

My company has a policy where if the revision of an individual part or subassembly changes (like a cable changing from Revision B to C), the top-level assembly revision must also change (like 000 to 001). Since many top-level assemblies may use the…

Is there a way to change an old REV of a BOM to history in order for the inactive REVs to not show on every inquiry? We have been using Sage for a long time and some of our BOMs are no longer active as we no longer build those items. We need to keep the…

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. …

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…

I am looking to utilize sales kits to add and remove parts on sales orders. However I want the sales kit pricing to be a roll up of the part prices and not have to put a price on the sale kit parent part. Individual part prices can change and I don't…

I had an employee Disassemble something that was produced a week ago. When they disassembled the product the quantity she needed to select was off by 200lbs. How can something be produced at a quantity and not be able to be disassembled at the same quantity…

I don't have the work order/production module. What is the best way to incorporate labor rates into Sage 100 BOMs? Right now I'm set up using misc codes.

Hi everyone, Could you share your experience on how to deal with a flow of goods like below? Raw material is shipped to a vendor the vendor processes it, charges service fee, which becomes a finished goods, then they ship it back the returned…

Hello SAGE ppl, We buy parts from vendor as 001 and that part for outside job and receive it as 002 - How can we account that in SAGE system? We are placing PO and receiving 001 part @ price X. Now we are placing PO and and receive the part 002 @…

Hello, our company is new to Sage 100 and in the process of setting up Sage. My question is this, is there a way to setup alternate BOM's? The closest thing I can find are BOM "options" but according to Sage this should only be used at the top level assembly…

When running the Costed Bill of Materials Report some items will print displaying all components. Others do not. Bills are all setup as Standard. BOM Options: Maximum number of levels is 10, but these are not levels, just components listed in the lines…

Hi, I have the code below for automatic registration/update of the production transactions. I've been getting an error on the UpdateInit method. oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister = oScript2.NewObject…

Hi, I've been wondering if there's a way to get the latest revision number from A Bill of Materials. I've tried to get the value by uising oProduction.nGetValue("Revision$", strRevisionNo) but im still getting the "000" revision number. Thanks…

Hi, I've been wondering if someone else encountered or might have a solution for this. Im getting the error "The register must be printed prior to posting" oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister…

Hi, i've been constantly getting the error "System.Exception: <NewObject Error: 200>" when I register the BM production entries. here's what I have coded: oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister =…

Hi, I've been wondering for a couple of days now. it seems that the Distribution line is adding a bunch of numbers on my Lot. retVal = oProduction.oLines.oDistribution.nAddDistributionLine("B456") oProduction.oLines.oDistribution.sLastErrorMsg says…

Hi, So i've been trying to put an entry on BOM Produciton entry, it seems to be having an error with the Distribution part. (im using an item with Lot Valuation) retVal = oProduction.oLines.oDistribution.nAddDistributionLine("B456") retVal = oProduction…

Is there a quick handbook for putting together multi-level bills? Thanks! Dan

I'm looking for any point of sale recommendations for Sage 100. One that works and has an open API. This is for the lumber/hardware/construction retail industry with 20+ stores. Any recommendations???? Thanks!

We have several BOMs with Options that require removing one item and adding another when a specific option is selected. Without this checkbox checked to allow negative quantities, we have to use Option Interactions which can get very confusing. I would…

Hello, I've tried to create a VI Import job for BM_BillDetail. But, that table is not an option. I see BM_BillHeader is an option, so I've selected that. I've picked the following Data values... H.BillNo, H.Revision, L.LineKey, L.ComponentItemCode…

Receiving an error while trying to import new BOM into sage. The message is, "S Only bills may be entered". In my VI job, I am assigned a H.Billtype = S. I am not reading from file for that column:

Is it possible to display the cost of a BOM in the BOM entry screen(s)? My team members are having to complete the build & then run a report in order to see the cost of a BOM.

Hello fellow Sage users, We have one FG item that used to be Make, but in the past years we switched to Buy. We thought about putting the BOM into inactive status, but when our sales team enters a line with aforementioned item, Sage generates the error…

i am trying to update a UDF in line level using script on a button click Dim count Set fso = CreateObject("Scripting.FileSystemObject") Set dict = CreateObject("Scripting.Dictionary") If (fso.FileExists("C:\XIDT\line.txt")) Then Set file = fso.OpenTextFile…