Topic Options
#13038 - 06/07/08 02:46 PM OE and IC discrepancy
CPS Offline
Adagio Guru

Registered: 01/05/06
Posts: 121
Loc: Antigua & Barbuda
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?

Top
#13040 - 06/07/08 05:15 PM Re: OE and IC discrepancy [Re: CPS]
Ralph Allan Offline
Adagio Virtuoso

Registered: 06/02/04
Posts: 694
Loc: Prince George BC
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).
_________________________
Ralph Allan
Business Computer Centre
Prince George BC Canada

Top
#13068 - 06/09/08 08:58 PM Re: OE and IC discrepancy [Re: Ralph Allan]
CPS Offline
Adagio Guru

Registered: 01/05/06
Posts: 121
Loc: Antigua & Barbuda
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.

Top
#13069 - 06/09/08 09:20 PM Re: OE and IC discrepancy [Re: CPS]
CPS Offline
Adagio Guru

Registered: 01/05/06
Posts: 121
Loc: Antigua & Barbuda
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?

Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 47 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1860 Members
5 Forums
14361 Topics
70256 Posts

Max Online: 359 @ 11/18/19 09:08 PM
December
Su M Tu W Th F Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31