This is a follow up on a previous question. We have been puzzled with the Item Stock Inquiry screen. Items have multiple U/Ms. The problem is the conversion. The base U/M is POUND with a conversion factor of 1. An item can have 4 other U/M's with varying conversion factors. The problem is once new transactions are entered when we select to view other U/Ms the quantities no longer match between the IV00102 and the transactions. Now what I have done is remove all inventory transactions. I then confirm the U/M schedule and then I import the transactions back into GP. At that moment all U/M quantities match and all is well. As soon as they start entering new transactions the differences reappear. They are using the project accounting module. Both U/M schedules match. As an example:
Item 1 : Gallon and Box of 4. Total Stock is 0.250 GALLONS and 0.062 Box Of 4(0.250/4.00=0.062)
Item 2 : Pound and Drum, Total stock is 1,174.46 Pounds and 2.352 Drums(1,176.46/500=2.352)
These numbers makes sense. What does not make sense are the numbers in the grid. As long as the conversion factor is 1, the quantity for balance equals the total stock on the last transaction line. For all other U/Ms the balance quantities make no sense some of them even go negative. What could be causing this? What am I missing?
