[OFBiz] Users - Cycle counting & other OFBiz inventory curiosities

[Christopher Farley]

Do any OFBiz users do have a cycle counting program? If so, how do you 
manage count frequencies, adjustments, etc.? Do you use an external program
to track "last counted" dates, or does OFBiz handle this somewhere?

Regarding inventory adjustments: Let's say you have a product at a
facility with the following inventory items: 

Item ID		ATP/QOH 
10001		2/2
10002		2/2
10003		3/3

Now let's say you did a physical count of the item and you discovered you 
had only 1 on hand (the variance is -6). For whatever reason, it is impossible
to determine the root cause of the error. Do you:

a) Enter a variance of -6 on only one randomly selected inventory item? 
b) Create a new inventory item, and enter a variance of -6 there?
c) Enter a variance of -2 on Inventory Item 10001, -2 on Item 10002, and 
   -2 on Item 10003?

Now let's say you counted 10, and you have a variance of +3. Where do you 
enter the variance? Does it matter?

I have also noticed that new Inventory Items are created each time a 
product is received or manufactured. When the product is sold, quantities 
are subtracted from existing Inventory Items. However, when a product
sale results in a negative quantity, the negative Inventory Item will 
never 'clear' out of the system without manual intervention. Is this  
by design?

Thanks OFBiz gurus!

-- 
Christopher Farley
www.northernbrewer.com