Sage 100

Does Sage 100 (v. 2019) provide a method for specifying minimum order quantities by vendor for inventory items? We know how to set minimum order quantities for an item at the warehouse level using "Reorder Maintenance," but we have not found a facility…

A customer wants to get a report of new inventory to publish on a web site and wants to know if he can get an inventory list by dates created?

What is the recommended length of time to retain inventory history in Sage 100?

Hello, Is there a way to show which PO's that have been received in are missing an invoice? We just switched over from Sage 50 and when the warehouse would receive material in, they would check off the box "waiting on bill". That way I could then just…

Hello All, We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty. SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts In the below example, in main I m seeing a open PO qty but in…

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…

We are trying to find an easier way to show what is on hand for a costed bill of material inquiry. The report obviously shows what the components are but we want to show the quanitityy of those components on hand. I tried checking all the reports that…

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!

Months ago I created this post about the Stock Status Report and Sales Order Qty: https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-distribution-manufacturing-and-internet-modules/110446/inventory-valuation-which-shows-available-balance…

Hello all, I am trying to find a way to solve an issue that I have with how the Quantity Available field is displayed in Item Inquiry. It's kind of a difficult issue to explain but I'll try my best here: Lets say I have 300pcs of an item On Hand.…

Trying to get a very simple report from IM. Item Number, Reorder Point, Quantity Sold YTD and PY along with a calculated field. The Reorder Point prints fine as do other fields such as Quantity On Hand and Quantity on Sales Order but I get nothing…

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…

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…

Merged over 3,300 items to code "Z_Discontinued" after months of working with staff to make sure all items on list were approved for merging. Now they need 2 of the 3,300 items restored, historical data. I created the original item numbers and setup…

Has anyone had an issue with a receipt of goods doubling the inventory on hand with correct data posting to PO and GL?

Sage 100 Version 5.20 Crystal 2011 for Sage Window server 2012 R2 Ok, here is an odd one. We had been having incorrect data running a Inventory List via Crystal. We have a total of 600 items. When I add a filter for Category 2 data I am getting…

I have a client that is exploring the idea of converting their inventory numbers (most are vendor numbers) to be generic numbers that will be sequential. They are a service company that has 16 years of Sage data. Some parts are drop shipped to their customers…

I am on Sage 100 Advanced 2017 (5.40.1.0). I am getting an error message in Sales Kit Maintenance when I perform a particular set of actions and I'm able to duplicate it in the test company. I'm wondering if anyone else has seen this, or if it's fixed…

In the pre-business framework days, this information was available in the resources link. I need to know which files are used by the Inventory Trial Balance report.

We have two separate companies - one is a sales and distribution company, the other, a manufacturing company. The only customer of the manufacturing company is the sales & distribution company. We are looking to merge the manufacturing company into the…

We want to clean up a bunch of product lines by moving items into new ones, but we want to see all the history in the new product lines. We're reducing the product lines from about ten to four. Is this the correct way of doing this? 1. Create new…

Can anyone tell me when the "Beginning Quantity" is set in Sage 100C? We make adjustments after an actual count on the last day of our fiscal year but those adjustments are posted back to period 12 after we have advanced to period 1. I have a feeling…

Sage 2016 I have a client that has a User-defined Cost field that they used to use when they had an enhancement for converting Sales Orders to Purchase Orders. Since this is now included in the software, I need to modify the Unit Cost field in the…

Previously purchased items are no longer being purchased. The items unit of measure for purchases was changed to KIT. The concern is the item still shows costing information and it is very old and misconceiving. How can we remove the costing information…