• Change of Inventory Valuation Methods

    There is preliminary discussion in our company about changing our inventory valuation method in Sage 100. All skus are currently at Average Cost and discussion is to change to LIFO. I have been looking to find more information on the technical/system…
  • Need reference for Inventory Module/Cost Accounting in Sage 100

    We are considering purchasing this module to use for a new manufacturing division that is schedule to open soon. I was hoping to get some advice on how the installation went well or poorly for your organization and whether you would recommend the purchase…
  • Move Inventory from one warehouse to another

    We are closing warehouse 000 and need to move inventory items of about 6000 items to warehouse 001. I know this can be done in the inventory transaction module for one inventory item at a time, but how can I do this with the entire stock of inventory…
  • Previously purchased item changed to a KIT for Purchase Unit of Measure, how do we remove the Last cost information as item no longer purchased?

    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…
  • Allowing Customers to Field Scrap

    What is the most efficient way you have found to process a field scrap? There are instances when it is not cost effective to have a customer return a damaged item so we allow them to keep the item (field scrap it). Right now we create an RMA to issue…
  • Receipt of Goods

    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…
  • Inventory error

    Was closing out the year and the last process is Inventory Management. Mas200. Received an error IMWPAA...then it showed up again this past month closing out. Anyone know what this is ? I know it's an ancient version... Thanks!
  • how to change UOM for item already in inventory

    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?
  • remove item from physical count entry

    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…
  • Inventory value with zero quantity using FIFO

    Note: Current version is 4.4, going to Sage 2015 live this weekend. This is regarding items with all IM_ItemCost records having zero quantity (meaning, Negative cost tiers, if any, have been applied), yet one of the records has and extended value cost…
  • record an item return on a sales order

    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.…
  • What is the best explanation of how OVERDIST (over distribution) tiers that are created using FIFO?

    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?