RMS Physical Inventory Expected Values

Loading thread data ...

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.

Reply to
Koit Lahesoo

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.