Sage 100

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,

Which Sage 100 IM table contains the Standard Cost field? I need it for a Crystal report, but can't seem to locate it.

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…

How do I export inventory part no, descripition & quantities? thank you, charlene

As per thread title... can anyone help on this? We have ACS Multi-Bin Warehouse Management and are currently on Sage 2015 v5.20

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.

I am attempting to write a report that needs to list the on hand qty of an inventory item for a given closed period. The same information you see in the History tab of Item Maintenance/Inquiry. I need to be able to look back at period 1 of this year for…

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…

The GL is higher than the trial balance, and varies over the next several months, and in December 2015. We saw entries in the transaction tab of Inventory item maintenance for Dec 2015. There are probably other entries which had GL dates that were different…