Bug Tracker Incident #7035
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.
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.
ALSO The information appears in Orange Color BUT the item is not frozen.
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.
Customer reports this is working now after applying scripts.
There were actually two issues at work here. The first was from improperly imported data causing the core problem. The second was the balanceitemsite() function was not working correctly. Solved both problems by adding in some schema changes to fix the data problem and prevent it from happening in the future and by updating the balanceitemsite() function to correctly post inventory history transactions.
I tested this on customer''s server and witnessed the behavior described. Somehow (unclear at this point), the Item Site in question became unbalanced. Then when trying to balance the Item Site, the balance routine did not complete successfully.
|Incident||3654||Improve checks for deleting Vendor||Related to||x|
|Project||XTUPLEAPPS||Ported From Mantis||x|
SubscribersYou do not have permission to view subscribers.
|12/16/10 09:12||acdrupal||New||Incident Added|