RMS Physical Inventory Expected Values

hi Damian, Well I checked what you said and I belive there are some misunderstanding issue. the physical inventory works perfectly at my side, what I did as you said created 2 items made one Item qty to postiive +1 and one to negative -1 then I made the physical count for the new items and enter for item 1 count to 1 but for item 2 i put count qty to zero which make sense or whatever you have.

Now then I calcuated and the exptected qty -1 but delta is 1 which make my item 2 to zero as counted. so work perfectly I am not sure what you are check> The value that RMS currently calculates the Expected qty and Value on the

I would have to agree with Damian, there is an issue with the Physical Inventory Expected Value vs. the Item Value report. I also tested 2 items and it seemed to work fine. But when I did an entire department, there was on obvious difference. I ran an Item Value for the department, filtered out zero quantity items. I then ran a physical inventory for that same department, calculated it, and the expected qty and expected value were off (higher qty and value than the report). I printed the Item Value Report and went line by line on the Calculated inventory and compared it to the Item Value Report everything matched to a tee, except the total qty and value; the physical inventory expected is incorrect. It seems that (at least on the dept I ran) the negative qtys are the issue. It appears to be adding them twice instead of deducting. I have a total of -11 qty on my physical inventory sheet and the difference between the 2 (physical inv vs report) is a qty of 22.

I just stumbled on this yesterday and have not been able to do much investigation, but there is definately a problem. Do this: Run an Item Value Report and then go and create a new physical inventory (do not put any counts in) and calculate. You should see a difference in the expected qty and expected value.

T> hi Damian, Well I checked what you said and I belive there are some

I agree that there is a problem! Assume that I have negative quantities in my data. I do the following:

1. Inventory -> Physical Inventory -> New -> OK (All items). This saves my current inventory.
2. On Physical Inventory Count form I click Calculate and OK in message. This shows me expected item quantities list. The problem is that in the header part of the Physical Inventory Discrepancy list form in the Summary part the Expected Quantity and Value numbers are wrong. Seems like some calculations are made with the absolute values because the difference is sum of 2*negative values.

When I click Print to get the Physical Inventory Report (Summary) I get correct quantities. But I have to customize that report for my customers who want to see cost. The default report shows cost of 1 peace of individual items and if I make some grouping it calculates the sum of individual costs - the information of no use (it is so in some other reports too where I have to remove the sum of individual costs for clarity). I add calculated columns Cost*Quantity (Expected and Counted; Delta Cost is OK) and sum these columns for grouping.