• Why does my *item in sales order not show on my picking sheets for shipping to "ship"

    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.
  • Incorrect cost on closed work order

    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!
  • How can I verify where items are committed? Sales Orders/Backorders/Etc.

    My company manufactures products that we categorize by Lot #. As an example, I have an item with Lot # ABCD that we delivered into Sage 4,143 bottles. Of that Lot #, I can confirm that 3,628 have been invoiced and sold, leaving 515 left, which is exactly…
  • Bad debt and write offs

    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…
  • serialized items are showing as available but they have been invoiced

    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…
  • Can an Inventory Depletion be Linked to the Receipt???

    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,…
  • Need support for quarterly and year end closings. Sage 100 with Job Cost

    We are network cabling contractors using Sage 100 with Job Cost and lost our Sage 100 support person. We have a CPA, but need someone for quarterly/year end closings. Located in Orange County, CA near John Wayne Airport. Any referrals would be appreciated…
  • Intracompany transactions

    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…
  • Physical Inventory Count Posted Accidently

    Hi, We were reviewing the physical count and posted it on accident. Is there a way to reverse that? Regards, Becki
  • Inventory History

    What is the recommended length of time to retain inventory history in Sage 100?
  • MATERIAL RECEIVED WRONG WAREHOUSE

    Hello, We sent a PO to one of our vendors and it was supposed to get shipped to our CA location, however they sent it to our FL location. We now need to send this material to our other warehouse as we have no space here to keep the product. For…
  • Transferring FG inventory from one warehouse to another

    Hi! We have recently created a second warehouse in our system and are trying to find the most efficient/effective way to transfer the inventory in the system as well as physically. I know there is a transfer option in inventory management, but we are…
  • Average Costing Negative Inventory

    We are currently exploring moving some of our smaller, order-in products from FIFO to Average costing. I understand how the valuation works on both sides, but we are still working through some company process issues where sometimes a S/O will get finalized…
  • Sage 100 migration taking WIP turning into Inventory

    We are currently Migrating from Sage 50 to Sage 100 and about to go live. We have one particular item we sell that we put as a job in Sage 50 where all costs go to WIP and then an Inventory adjustment puts the item into inventory. For clarification we…
  • Quantity Avaiable field

    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.…
  • Goods Received incorrectly reflected in wrong Warehouse.

    Hi All, I had an issue with my receipt of goods entry... Basically the Goods entered as Received in Warehouse 008 but its balances is reflected in warehouse 001 in Inventory valuation report. What causes this and how do i rectified it?
  • PO for Inventory but was paid with credit card

    A PO was issued for inventory items. There were received and have been paid with a credit card. How do I clear the PO? I need to invoice something so the PO closes. I can't invoice it, since I've already paid for it with a credit card. Thanks! …
  • How to append a Lot # when transferring from 1 Whs to another?

    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…
  • PO Receipt of Goods error

    Has anyone had an issue with a receipt of goods doubling the inventory on hand with correct data posting to PO and GL?
  • Sales Order / Back Order Updates

    Hope I am formatting this correctly. Running a back orders report for the month, I came across some inventory items that we for sure have in stock. Digging into the cause I found that data entry had manually entered some cancelled orders for one customer…
  • Can anyone duplicate this bug in Sales Kit Maintenance?

    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…
  • Inventory adjustments and return of goods

    Greetings everyone, I'm new to the community and have been lurking for a bit on subjects that I'm unaware of. I decided to register and stick to the community. Welcome! Before my time, some of the books were a complete mess. We are slowly correcting…
  • Merging two companies (one company absorbing the other company)

    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…
  • Changing Product Lines and Keeping History

    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…
  • Sub ledgers don't match financial statements

    I am new to Sage. I am reviewing books for a client and find that none of their sub ledgers (A/R, A/P or Inventory) match the financial statements. In QuickBooks I know how to trouble shoot these; but not so in Sage. Can someone point out the common mistakes…