• Error 11 Can anyone shed some light on how to correct?

    We have an user that is moving parts around on several bill of materials. He is consistently receiving this message. Often after the message is received the items behave oddly, such as not being able to delete or modify. When we try to delete or modify…
  • Manufacturing table layouts

    link SO to WT .docx I'm trying to find a file that contains the quantity on WorkTicket shown on the Sales Order line if exploded. see attached word doc for screen shot. The SO detail file contains the work ticket number and the item number but not…
  • Open PO Qty vs On PO qty discrepancy

    Hello All, We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty. SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts In the below example, in main I m seeing a open PO qty but in…
  • 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…
  • Inventory Categories. Data Corruption? A mystery

    Sage 100 Version 5.20 Crystal 2011 for Sage Window server 2012 R2 Ok, here is an odd one. We had been having incorrect data running a Inventory List via Crystal. We have a total of 600 items. When I add a filter for Category 2 data I am getting…
  • MRP Generation Date - Is it stored somewhere?

    I'm using Sage 100 Advanced 2017. I've been successful in coding a new MRP reporting solution for my business using the existing MP database files in Sage. One small but crucial bit of information I haven't found in the database is the actual creation…
  • Deleting Warehouses in Sage 100 2017

    We just upgraded to Sage 100 2017. Is there an easy way to delete warehouses?
  • How can I export any/all the email addresses in paperless office?

    I would like to have a list of all email address associated with every account, but I am not aware of a method to do this.
  • Cleaning Out Non-Existent Inventory in Sales Orders

    We are having an issue with non-existent inventory items in our Sales Orders occasionally showing up as a "-1" item, but they do exist. Our software support company looked into this a while back but was not able to resolve the issue. I am wondering…