Sage 100

I am looking to update the item locations for a large number of SKUs, is it possible to update that information in bulk via an Excel upload or something similar? I don't want to have to open each SKU individually in Item Maintenance and update them if…

Hello All, I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…

My inventory valuation report is pulling around $9 million dollars and my GL account inventory is pulling around $ 1 million. anyone know how i can fix this or see what the difference is ? Thank you,

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…

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…

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…

We just upgraded to Sage 100 2017. Is there an easy way to delete warehouses?

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.

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…