ssolberg
VIP Member
I've had reports of the Average Cost on a part getting way out of whack and I can't seem to replicate it but as you can see from the info below (I'll explain) from the Cardex, "something happened". Here is what the user explained to me.
1. The avg cost was 1.44 for a real long time (see various bottom transactions up until 5/31/06)
2. They incorrectly received a PO on 6/09 at a unit cost of 211.00, then they reversed the receipt on 6/13. They then properly rec'd the PO at a Unit Cost of 2.11.
3. I have no way of knowing what the Avg Cost looked like at that point but you would expect it to be somewhere between 1.44 and 2.11, yes? (about a 1.82 if I figure things correctly)
4. They then did a Sales Order on 6/21 and as you can see, it seems to think the Avg Cost was 91.63! I have no idea where this came from.
5. They then rec'd some more parts (again at 2.11) and it obviously recalced again but things were already wrong by this point.
6. They then did a cost adjustment on 1/22/07 to get Avg Cost back in line.
Anyone have something like this happen before? I setup essentially the same scenario and tested and although the reversal of an incorrectly rec'd PO DOES not get it "exactly" back to what the avg cost was before the mistake, it is pretty close. If the user did something, I sure can't find it... Thoughts? I scoured the KG and the JDEList archives and didn't find anything...
Document Ty Date Warehouse Quantity UM Unit Cost Ext. Cost
1195612 IB 01/22/07 S EA 52.98- 3,920.52-
477112 SO 01/12/07 S 12- EA 55.09 661.08-
458032 SO 09/18/06 S 6- EA 55.09 330.54-
448430 SO 07/31/06 S 6- EA 55.09 330.54-
260922 OP 06/30/06 S 40 EA 2.11 84.40
440570 SO 06/21/06 S 12- EA 91.63 1,099.56-
257251 OP 06/13/06 S 40 EA 2.11 84.40
257251 OP 06/13/06 S 40- EA 211.00 8,440.00-
257251 OP 06/09/06 S 40 EA 211.00 8,440.00
436343 SO 05/31/06 S 12- EA 1.44 17.28-
436343 SO 05/31/06 S 12- EA 1.44 17.28-
436093 SO 05/27/06 S 6- EA 1.44 8.64-
433384 SO 05/13/06 S 24- EA 1.44 34.56-
22317 IA 05/11/06 S 9- EA 1.44 12.96-
431670 SO 05/05/06 S 12- EA 1.44 17.28-
471144 SW 04/04/06 S 40- EA 1.44 57.60-
20740 PI 12/17/05 S 28 EA 1.44 40.32
404678 SO 11/12/05 S 11- EA 1.44 15.84-
1. The avg cost was 1.44 for a real long time (see various bottom transactions up until 5/31/06)
2. They incorrectly received a PO on 6/09 at a unit cost of 211.00, then they reversed the receipt on 6/13. They then properly rec'd the PO at a Unit Cost of 2.11.
3. I have no way of knowing what the Avg Cost looked like at that point but you would expect it to be somewhere between 1.44 and 2.11, yes? (about a 1.82 if I figure things correctly)
4. They then did a Sales Order on 6/21 and as you can see, it seems to think the Avg Cost was 91.63! I have no idea where this came from.
5. They then rec'd some more parts (again at 2.11) and it obviously recalced again but things were already wrong by this point.
6. They then did a cost adjustment on 1/22/07 to get Avg Cost back in line.
Anyone have something like this happen before? I setup essentially the same scenario and tested and although the reversal of an incorrectly rec'd PO DOES not get it "exactly" back to what the avg cost was before the mistake, it is pretty close. If the user did something, I sure can't find it... Thoughts? I scoured the KG and the JDEList archives and didn't find anything...
Document Ty Date Warehouse Quantity UM Unit Cost Ext. Cost
1195612 IB 01/22/07 S EA 52.98- 3,920.52-
477112 SO 01/12/07 S 12- EA 55.09 661.08-
458032 SO 09/18/06 S 6- EA 55.09 330.54-
448430 SO 07/31/06 S 6- EA 55.09 330.54-
260922 OP 06/30/06 S 40 EA 2.11 84.40
440570 SO 06/21/06 S 12- EA 91.63 1,099.56-
257251 OP 06/13/06 S 40 EA 2.11 84.40
257251 OP 06/13/06 S 40- EA 211.00 8,440.00-
257251 OP 06/09/06 S 40 EA 211.00 8,440.00
436343 SO 05/31/06 S 12- EA 1.44 17.28-
436343 SO 05/31/06 S 12- EA 1.44 17.28-
436093 SO 05/27/06 S 6- EA 1.44 8.64-
433384 SO 05/13/06 S 24- EA 1.44 34.56-
22317 IA 05/11/06 S 9- EA 1.44 12.96-
431670 SO 05/05/06 S 12- EA 1.44 17.28-
471144 SW 04/04/06 S 40- EA 1.44 57.60-
20740 PI 12/17/05 S 28 EA 1.44 40.32
404678 SO 11/12/05 S 11- EA 1.44 15.84-
