IC item valuation report different from location cost

[johnhugh]

Hello,

I'm using Accpac 5.5.
I'm running an Item valuation (transaction cost) report up until August for 1 of our stores.
The total I get from the item valuation report is different from the total the Stock Transaction Report shows me.

I have run a day end before printing both reports. How can I find out which report is correct?

 

[ettienne]

The only report I trust is the Item Valuation report by Location Detail Costs, the others I do not trust.

 

[johnhugh]

Thanks for your reply ettiene.
How would I go about finding out what causes the differences?

Only way I can think of is adding up all transactions for this location manually?

 

[DjangMan]

In theory if you run day end you can take the values in ICILOC and then reverse the sign on all ICHIST or ICIVAL transactions in reverse date order you'll end up with a zero subtotal.

If you don't end up at zero then you have missing records. There was a great utility called Uni Stock Card that would offer to fill in the missing values as a mini data repair. It isn't hard to plug in a record to correct any gap.

Off hand I'm not sure but the stock transaction report might pull from ICHIST. The Inventory Valuation report, when run in transaction code mode, pulls from ICIVAL.

If you have a disconnect between your ICHIST and ICIVAL then that might point you to the missing transactions (assuming that either ICHIST or ICIVAL reverses to zero and that any missing transaction is not missing from both tables).

The item valuation by location details pulls directly from ICILOC. When you look to see if you have stock on hand you look in ICILOC. ICHIST and ICIVAL are more like audit trails.

 

[ettienne]

I would trust the numbers in ICHIST more than the numbers in ICIVAL, just my opinion...

 

[johnhugh]

Thank you for your replies.
I will have a look at these 2 tables.