we have almost all item sites with "Multiple Location Control" active.
When trying to receive, adjust or CC any item to a specific location, the actions seem to have completed successfully.
But trying to look at QOH reports for the item displays the total QOH appears to e correct; it also lists the locations where the inventory was distributed but shows the qty as ZERO against these locations.
The items are then displayed on the unbalanced report. Doing a right click and 'Balance item site' action does not fix the problem on the item side. Also the item still remains on the unbalanced window so a user can do the balancing action again (second time or even more!) causing further corruption of data.
i understand the balancing action essentially ZEROS out the quantity in the itemsite/location. This is not the desired result we want to achieve.
ALSO The information appears in Orange Color BUT the item is not frozen.
Steps to reproduce:
The follow on affect of this issue is on Pick Lists. I have attached the modified form we use where the locations with their respective qty is listed. This report is now only listing location but does not display qty.
The next issue is error in the Issue stock to shipping function because of the itemsite location not getting associated to a qty.
Read more at http://www.xtuple.org/mantis/view.php?id=7035