Item Valuation Report vs Count Sheet value

Posted By N P 16 days ago

Hi,

I'm preparing for our annual inventory counts and having a valuation issue. When I run the Item Valuation report as of March 31st for a range of account sets and locations it gives me a total for each location. But when I generate the inventory worksheet for the same date, account sets and location and total up the unit cost and quantity on hand it gives me a different total.

We've had this issue once before and it was a unit of measure issue where items in specific locations were set to a different stocking unit. We've tried to correct these and all look good but issue remains. We've got over 2000 items so don't want to go through each one by one. Any idea on how to start tracking down the source of our issues?

Thanks,

Nathan

0 DCrampton 13 days ago

Hi Nathan,

I think it would be best to take this issue off of the forum and open a customer support ticket.. Please let me know if this is possible and when the Support Ticket is created, I will then most likely take over this support ticket.

Thank-you,

DCrampton
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 N P 13 days ago in reply to DCrampton

Hi DCrampton,

I was able to run the Item Valuation report by detail for each location to get the values of each specific inventory item, and then compared that to the Count Sheet item values. Turns out a majority of the issue was items that still had value that had been made inactive. They were included in the Item Valuations but not on the count sheets.

The way the two reports calculate the item value seems to be different though (Count Sheets are Qty x Unit Cost = Value, Item Valuation seems to be Value / Unit Cost = quantity). The total values are the same though and I can live with that.

Thanks,

Nathan
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Item Valuation Report vs Count Sheet value

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING