Sage 100

How do you setup FEFO

Hello, We have comments on sales order dropship lines that we would like copied to automatically generated purchase orders, if possible. We are unsure how to accomplish this. Is it possible to transfer sales order line item comments to dropship purchase…

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!

A finished good item was changed to a kit item. In BOM maintenance the bill number is a finished good number. However, the component used for this kit, has the same item code. I get an error saying "the item code you have entered (SROP7000) is the same…

Need some perspective with what I am seeing in PM. Screen below is from the materials tab of work ticket entry. The first 225 LINES are from the requirements import (CSV file). After that are quantities from inventory transaction entry (materials). Most…

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…

Can someone please tell me how to easily find a vendor invoice detail lines from a PO number? The reason why i ask is that both the window through the "Receipts" button in Purchase Order History Inquiry and Receipt History Inquiry doesn't seem to capture…

We currently use all the core modules (GL, AP, AR, BR, PR, IM, PO, plus Job Cost and Time Card. I am looking for something, for example - we may have 1-3 jobs at a time (up to 90 days each), each job will have 2-3 work tickets, and each work ticket generates…

We are testing exploding kits to be able to sell bundled items and have teh cost calculate from the components and the inventory of the individual components reduced with sales of the kits. In our test environment though, neither of these things are happening…

Does anyone have parts inventory for sale that also deals with this confusing "committed" inventory column? Can we shut down committed because it just seems to cause more confusion than for little benfit it gives? Or, how do we deal with this committed…

I can think of a way using VI, but it's a bit laborious. I'm sure a script could be set up to do it, but I would think there is a way within the program to set it up to just keep using the same number from Sales Order Entry in Invoice Data Entry. Probably…

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…

Trying to figure out if there is a way to reserve a portion of a LOT Number for Make to Stock finished goods. For instance: The company I work for makes paint. If we make a batch of a particular color, give that batch a LOT Number and enter it into…

Hi, We have a few Work Orders with issue method set to Automatic (We normally use Backflush). The Release transaction was processed, but no labor transactions were generated. My question: What could be causing this to occur? This hasn't happened…

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, I have noted that if you change routing for a BOM but a Work Order was already created, the work order doesn't see the change. I noted that with some Backflushed Work Orders, the Backflushed totals matched the old routing not the new. I just…

Does any one know how Sage chooses with Production to Reverse when choosing Disassembly Type: Production Reversal? I just tried it for the first time in my test company and noticed it reversed the Production I wanted along with one from 7/10/2015. …

I am developing a Windows Forms application which is required to connect to Sage 100 and get order information. I am using ASP.NET and SQL Server 2008. Is there a way to connect to the sage 100 database?

How do you set up locations in SAGE 100?

Hello, my company currently uses inventory management to track in house supplies. We are a medical facility, that has 70+ departments. We do not sell the inventory outside of the company, however as departments need supplies we do an "Inventory Issue…

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…

What is the fundamental logic difference MAS uses when entering line items to sales order that exceed available quantity? To be clear, suppose you're entering a sales order line item that has an available quantity of 5. If you enter quantity 6, you…

Good morning. I have created some routings which have 5 key steps to them for 5 key phases of manufacture to improve visibility. I have made these steps standardized across routings. The step numbers are set off by 100s so there is a step 0100, 0200…

Is there a way to keep a work order up to date based on real time progress of a part's manufacturing? For example...for a particular work order we will have 3-4 work centers a part must go through to get to completion. Today, until that part is fully…

Hi there, Does anybody know if it's possible to mix issue methods in Work Orders? We have some Bills of Materials which are quite lengthy with expensive, lot/serial controlled components that we need to manually allocate. Mixed into the BoMs are a bunch…