• Part not updating in inventory after invoiced from work ticket

    We are having an issue with a part not being updated in our inventory after a work ticket is invoiced. We can manually do an adjustment but there is another issue with a button greyed out. This is for Sage 100 v2017. Any help would be appreciated.
  • negative tier report vs inventory valuation report

    I've recently started opening up can of worms when I was assigned "inhouse sage specialist". I know some things in sage and the rest is picked up as I go along. I have come across our Negative Tier Report and holy cow, 163 pages. I've done some research…
  • Item Cost showing in IM-Transaction Entry for ISSUES

    Has anyone found a way to have Item Cost show in the line information during an Inventory Management Issue transaction? Thanks, Erin
  • Inventory and Lot Numbers

    Sage 100 manufacturer, but only has been using the Distribution modules. Has not had a perpetual inventory in place. Company now is wanting to move to perpetual inventory within Sage 100 and then into the Manufacturing modules. Inventory items need…
  • Change Default for Inventory Valuation

    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!
  • search by alias number within Item Inquiry / Item Maintenance?

    Is it possible to search by alias number within Item Inquiry or Item Maintenance? How?
  • Change Default for Inventory Valuation

    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!
  • Serialized item on hand but not available.

    I am trying to assign a serial number that shows it is on hand, but when I try to assign it to the sales order, it is not available? How do I correct this? Sage 100 v.2017 v 5.40.1.0 Any suggestions on how to correct this would be appreciated.
  • 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.…
  • Crystal Report Data from IM

    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…
  • How do I figure out exactly what is preventing Item Merge Utility from working?

    I have several items that I need to merge, but every time I try to run the Delete and Change Items Utility I get the error message, "You cannot proceed with unposted data in IM Transaction entry." I have confirmed that I do not have any open IM Transaction…
  • Purchase Order for Tools, Supplies, and Non-Stock Items

    I want to know what is the right way to make purchase orders (or equivalent entry) for items that aren't going to be sold like tools, equipment, machine, and supplies. Is a PO the correct entry for this? I do not think it is appropriate to receive these…
  • Can't Delete Inventory Items - But No Transactions Exist

    I have several items that when I go to delete them, I get this message: However, when I attempt to look at the transactions for that item, I can’t find anything at all. See below, showing all warehouse and all dates, no transactions at all How…
  • How to setup allow returns in Product line Mainentance

    I am setting up product lines in Product maintenance and I don't see the allow returns box or Restocking charge method Restocking Charge Rate
  • Customer Returns: Multiple parts from multiple invoices

    We are a company that sells plumbing tees, elbows, valves, etc. When customers are finished with a project, they just bring back a large box with a mixture of parts. The warehouse writes up the part numbers and quantities. These parts could have been…
  • 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…
  • BIN Creation

    I am new to SAGE 100 and we are not using multi-bin (SCANCO) but will be in the future. I cant find out how to create a bin through the SAGE 100 screens. I dont want to start inserting values directily into SQL Tables. Is there a way to create a…
  • Crystal report formula to show zero on base "im_transaction history" issued

    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…
  • Food Service manufacturer and distributor

    FormerMember
    FormerMember
    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…
  • Multi-Bin videos and volume

    Want to do training using the DSD prepared videos that download with Sage 100cloud, however, the volume is not loud enough to hear. Have also tried the same videos on the DSD website and have the same problem. How can I get these videos so they are usable…
  • Reverse Item Merge

    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…
  • Back Order Fill Report (From posting a PO Receipt of Goods)

    The back order fill report included drop ship line items from sales orders. It would seem best to exclude drop ship as those lines will not be filled from the warehouse. Rich Garrett DSG, Inc.
  • Purchase order and invoice price discrepancy

    How does one correct an item received at the wrong price and billed at a cheaper price? The item cannot be returned as it has been used from inventory. Example: Item 1234 received at 1.80 ea, but billed at 1.65 ea.
  • Receiving "Drop Ship" PO to offset SO?

    FormerMember
    FormerMember
    I recently found the DROP SHIP PO and it is applicable in our business. However, we still recieve all PO's into our "inventory" which is then offset by a Sales Order. Once we invoice it then it is removed from inventory. We are unable to receive DROP…
  • Sequentially numbering Inventory Items - Pros and Cons

    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…