Hi
Fisrt I will answer you

Is integrity clean in the other modules/programs you are using?
Yes
Job Tracker 7.0A (update 07 july 2004) ok
Counter Sales 2007.11.20
POA 8.0(08 oct2007)OK
G/L 9.0A(071219) ok (still have to install the serve pack)
and so on for payable, recevable, pay dirt

IC Item....60 errors found

Determine when the costs go out again and why.....
February 21, I found exactly what was the problem.
I don't thing the problem is a costing problem , but maybe a quatity rounding problem...


Item valuation 497773.52$ GL 497780.12 including for example:

CAT (FER) 43719.39(ITEM VAL) GL ACC 43720.49 DIFFERENCE -1.10
(ELE) 153630.60(ITEM VAL) GL ACC 153626.16 DIFFERENCE +2.24

The next day (first thing in the morning) I make sure to only post POA first and do an another check. The difference was the same.
So we proceed with the Counter Sales posting. I was able to note 2 item that was not into to error integrity list but having decimal quantity, so I note the cost , the average cost and so one.

(FER) ACI-SA1045 1 1/4 cost 6.38/feet sold 1.125 feet

(ELE) ELE-T1770 cost .51/inches sold .25 inches

After the posting I check the gl transactions with the transaction history the cost was ok BUT...............

when I reprint the item valuation, redo the check data integrity and reprint it, and checked the GL amount I found that the difference was:


CAT (FER) 42787.88(ITEM VAL) GL ACC 42876.12 DIFFERENCE 1.76:
-1.10(cat difference) + 2.86(NEW ITEM IN THE LISTING INTEGRITY ERROR )
ADD into the integrity check list:
Item ACI-SA1045 1/2 total quantity on hand is 33.55 but should be 34. (.45x6.38=2.87)

same:
(ELE) 153374.05(ITEM VAL) GL ACC 153371.74 DIFFERENCE -.13
2.44 + -.13 (NEW ITEM IN THE LISTING INTEGRITY ERROR )
Item ELE-T1770 total quantity on hand is -29.75 but should be-30.(-.25x.51=-.13)

It seam to me to be a rounding decimal problem not a costing one

I know that those amount are small but before doing the testing I posted a GL transaction to be sure that the GL and the item valuation was balancing (almost 1108.$). After the GL transaction were made I test each day the GL transaction (actif acc, and CGS acc, and transaction history in IC)I found nothing wrong, each amount was matching.

Hope that will help you to find what is my problem with decimal quantity and not my costing problem.

Monique