Sage 100

Trying to figure out why " *item" line items show at time shipping is picking the order in one Company, but not in a different company. I feel like something is not turned on in the company.

We created a work order for a part number and accidentally put the unit cost in as $1,486.4667 instead of $14.8429. The work order is closed and inventory is overstated. Help!

My question is what's the correct way to bad debt an inventory item? We have an item that we want to take out of inventory and put to bad debt. I have played different scenarios in my head but not sure which way is the proper way and which GL's it's going…

We are showing a serialized item on hand and available, but it was sold in November 2021. History shows the item was received and sold, with no further movement on this serial number It's still showing on the Inventory Valuation Report - item in…

First off, our ultimate goal is to look at an Invoice in AR_InvoiceHistoryHeader and Detail and know what the Landed Cost is. The Purchase Order Module's History Files does a pretty good job of tracking Landed Cost History by Receipt Number. However,…

Hello, I am very familiar on how to post intercompany transactions but not with intracompany. I am hoping someone can assist me. My business for privacy is called ABC. ABC has 3 locations, WV, KY, TN. We utilize the WO module to purchasing, including…

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

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

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…

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

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…

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…

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…

Hello-I have Sage 100 ERP 2014 version. I am very new to Sage and was wondering if there is a way to receive in goods on a PO without creating an invoice to the supplier? I would also like to go back and add in freight to the PO if needed. I am trying…

I have a few items in inventory that were purchased at one UOM and I would like to change them to a different UOM. What would be the correct way steps to do that?

After Physical Count Worksheet is run, can items be removed from the Physical Count Entry? I have an couple items that were adjusted after the the worksheet was run. I can see the items in the physical count entry with a qty. What if I just leave the…

We have customers that buy a new piece of equipment and trade-in an old one at the same time. How would we record the trade-in on the sale? Do we put a negative amount in the quantity field? This appears to use the wrong cost for the returned item.…

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?