I am having a problem with the physical inventory feature. This is the example
I pull a Item Value List report with only supplier as the filter. The total on this report is as follows QTY: -5 EXTENDED COST - $10 (these are minus's) Now I go to the physical inventory and select NEW then ONLY ITEMS FROM SELECTED SUPPLIERS and I choose the same supplier I choose on the ITEM VALUE LIST I choose to update maching item and replace existing items. I am importing 10 of the item that had a -5 when I started. Now when I calulate now expected should read what my ITEM VALUE LIST started with which was -$10 but instead this is starting with a +$10???????? Those items were already sold so my beginning inventory should not have been $10 it should have been
-$10. Right? This is how i think the formula is for the Summary EXPECTED VALUE + OVER VALUE - UNDER VALUE= total of that supplier (or what ever your filter is) If the formula is what i think it is that would mean that my total would be $40 Which is not right. But when I run a report in Item Value list again the correct total is right.