• The AR InvoiceHistoryHeader file is being used by another task and cannot be opened.

    We have been trying to restore the AR_InvoiceHistoryDetail file for a couple days and continue to hit corrupt file errors. error 106 key file error. I finally found a file that when restored and rebuilt works and opens correctly in the "TST" test company…
  • Bill of Materials Mark Inactive

    Is there a way to mark a bill of materials inactive? I want to only see active product codes for on the Costed Bill of Materials report but it shows everything.
  • How to auto update all BOMs after Replace and Delete Component Entry or revision change of subassembly part

    My company has a policy where if the revision of an individual part or subassembly changes (like a cable changing from Revision B to C), the top-level assembly revision must also change (like 000 to 001). Since many top-level assemblies may use the…
  • Inventory Item Type

    Do you have to list a product type on the Item Maintenance screen? What if you don't want to breakdown your inventory items?
  • After using Delete and Change Items Utility, Item Inquiry/Maintenace is blank

    I was changing a few Item codes usint the Delete and Change Items Utility. The log report showed that a New Item Code Description was created and the action was a Rename. When I now search for the item, I can see the new name in the search screen, but…
  • Unable to Change and Delete Items.

    Hi, I am trying to use the Delete and Change Items Utility, (Module>Inventory Management>Utilities> Delete and Change Items). When I try to open the utility, a window appears saying, "You cannot proceed with unposted data in Item Valuation Selection…
  • Work Order operations descriptions disappearing

    I have run into something weird in Sage 100 and am hoping someone might have some insight. I have run the rebuild and resort utilities on the work order module to attempt to repair some issues. The issues were repaired but a side effect appears to be…
  • Material Requirements Planning Set-Up

    Hello, The employee who was trained on MRP and set it up, left the company back in January. Ever since, no one has had training and we stopped using MRP. What are the best resources for setting up and maintaining MRP? We will more than likely empty…
  • Purging Obsolete Open SOs

    I'd like to clean up open SOs our test environment. We have hundreds of SOs in test due to site scraper software pulling in orders from our online store. Is the Purge Obsolete SO utility the way to go? And do people need to be out of our production…
  • Adding a quantity discount from a supplier to an item in Item Maintenance (NOT Price)

    I have found many ways to add a price break from the sales standpoint, using Price Codes to adjust the retail price based on ranges of quantities sold to customer. However, I have found very little on how to enter the same info on the Purchases side …
  • Unable to Delete and Change Items

    I am trying to use the Delete and Change Items Utility, (Module>Inventory Management>Utilities> Delete and Change Items). When I try to open the utility, a window appears saying, "You cannot proceed with unposted data in Item Valuation Selection entry…
  • Can't Add New Product Codes in Item Maintenance

    When we enter a new item code into "Item Maintenance," it used to create a new product in the system. However now when we enter a new product code, everything goes blank, but it says "NEW" right by the Description (as it would do before). Everything else…
  • Delete and Change Items Utility

    I have some item codes in my system that have not been sold yet, but some of them are on sales order/back order. I now need to change these item codes due to a character limitation of one of my customers. My question is if I change these item codes using…
  • Bill of Materials

    We're having an issue with the costs not staying put. When billing the product, at that time, its correct, but when it comes time to print reports for what the costs are, its wrong. We have been trying to keep up with cost fluctations of ingredients as…
  • Promotion Redemption Codes

    FormerMember
    FormerMember
    We are a distributor, looking to expand sales via electronic marketing. I don't see any forum/category that mentions sales, so here I am I am looking for the SAGE 100 solution for offering a promotion code via email or postcard that ONLY applies the…
  • Sales Order weight calculation?

    We have never used the automatic freight calculation before, but I'm testing it out. I have an item number set up as weight = 2. When I have qty 1 on my SO, the Ship Weight comes out to "00010", and if I change the qty to 20, the Ship Weight comes out…
  • How do I find info on how to use the delete and change customers utility?

    Need to know how to merge customers and or change customer numbers in AR Customer table.
  • Lot Costing, Need Price Code to Pull Last Item Cost

    Using Lot Costing here for our Inventory Costing. I have all price codes set up - but for those pulling from cost, it's pulling from the Standard Cost (as it should) - BUT I need it to pull from the Last Item Cost. How can I change this? Each individual…
  • Merging Item Numbers

    In MAS v4.3, the merge function used to be in the drop down box within the "item delete/renumber/merge" screen, however, now I do not see this function in MAS 2014? It seems I can merge two item numbers in MAS 2014 that are next to each other in the list…
  • Remove Zero Quantity Costing Tiers

    What does the "Remove Zero Quantity Costing Tiers" utility actually do? I believe it removes any tier in the ItemCost file that has a quantity on hand of zero and a date prior to or equal to the date chosen in the utility BUT does this remove the ability…