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 have an user that is moving parts around on several bill of materials. He is consistently receiving this message. Often after the message is received the items behave oddly, such as not being able to delete or modify. When we try to delete or modify…

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…

Hello All We do not utilize payroll in sage and I am attempting to import our labor into operations Mangement via Direct time entry DATA COLLECTOR. The system is unfortunately not returning any usable error messages (actually none at all.) Does…

In Item Code Maintenance where you set up the units of measure. What is "SALES" used for? Is it used for sales to an end user, or is it used for the recipes/bill of materials/costed bill sales?

Does anyone have a crystal report that is able to do Lot Traceability when using Production Management? Sage said they were going to try and resolve this in the next product update version but it is not available out of the box in version 2021.

I have created a custom Work Ticket report setting with a subreport. The subreport uses the JT_WorkTicketAttachments file. The main report links to the sub report by SalesOrderNo and WTNumber. I have placed an image placeholder on the sub report detail…

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…

I just want to bounce some thoughts around. We're a manufacturing and distribution company. We are trying to take into account how many boxes we use for packing our finished goods. These finished goods are sold to our intercompany via p.o and receipt…

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…

I'm preparing my upgrade from v2019 to Sage 100c Advanced v2021 with PU1 (due to Scanco Operations Mgmt compatibility) and notice KB articles referring to slow performance issues with STANDARD and PREMIUM. But nothing with ADVANCED. Does anyone know…

Hi, Is there a cross reference list of what the WO tables/fields are now called/located in PM. I'm looking to make a new query for PM to replace what I had in WO coming from the WO9 table or WOO depending on Active or History. Thanks, Ryan

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…

Can I set up an automated task to run the Daily Parts Usage log at night? TIA Tracy

link SO to WT .docx I'm trying to find a file that contains the quantity on WorkTicket shown on the Sales Order line if exploded. see attached word doc for screen shot. The SO detail file contains the work ticket number and the item number but not…

Is there and if so, where can you switch Direct time entry in the manufacturing module SAGE 100 to batch positing? TIA, Tracy

I ran the component exception report for make items with no cut off date. I cut work tickets for required items and continued until there were no new items. However I found items in our inventory report that have hit the reorder point but didn't show…

Does anyone know how to change the valuation default in Item Maintenance from Standard to Lot? Trying to prevent incorrect entries when setting up a new inventory item. Thanks for your help!

We recently upgraded to have Bill of Materials so that we can issue inventory when we manufacture goods. An issue we're having is that Bill of Materials seems completely unsuited to companies who manufacture custom items to order. We manufacture items…

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…

Using 100c and Manufacturing Module. Within Work Ticket (W/T) is there a way to auto-fill QTY used ? Our BOM's have 50+ components and selecting each line by line for QTY Reqd and QTY Used really slows down the process.

My company is a broad line food distributor and we also manufacture deli products such as bologna, salami, etc. We carry about 1,500 different items. There are about 10 employees that work picking order throughout the day and night and its all done on…

We are getting Sage 100C Manufacturing (JobOps) set up and have run into an issue with some of my tests. We have orders made up of Custom Made to Order Items, which we create a work ticket for via the Sales Order Line Entry. We then have other items that…

We are on SQL and light manufacturer. Need the ability to make to order. What have other companies utilized?

I'm using Sage 100 Advanced 2017. I've been successful in coding a new MRP reporting solution for my business using the existing MP database files in Sage. One small but crucial bit of information I haven't found in the database is the actual creation…