At least three staff members have reported that there are differences in item quantities between order entry and inventory. They way when they are trying to sell an item, an error message occurs saying there are insufficient quantities, however, when they check the same item in inventory there is sufficient quantities. I usually work in the evening and whenever they report the matter to me giving an exact example the quantities agree between OE and IC. Could this issue have anything to do with running dayend?

You are correct: running day-end adjusts the quantities on hand in inventory.

The quantity shown in OE is on-hand minus the number on sales orders.

Day-end processing takes the sold quantities from OE and updates IC (among other things).

If I am understanding you correctly, you are saying that the reason why we receive an insufficient quantity in order entry is because items are on sales orders. Basically the quantity in Order Entry plus the quantity on sales orders should equeal the amount in inventory.

However, they are saying that there is nothing on sales orders.

Or are you saying that the shipments are not reflected in IC until dayend, but are instantly updated in OE. For me to see whether the quantities are correct, I would have to look at the starting inventory in IC, get the shipments from OE and those on sales orders and subtract.

I hope I am reading you correctly.

We do not allow negative quantities, however, sometimes when viewing an item from the stock card, the item is in negative quantity. It is often that the product is physically in the warehouse, but the inventory value is incorrect. We would need to post an adjustment before we are able to sell the item. Is the negative quantity due to the fact that the adjustment would not be reflected before dayend and the shipment is deducted from the inventory onhand prior to the addition for the adjustment?