Bug Tracker Incident #7035

 


Summary
Project
INCDT - xTuple ERP
Incident Category
Bugs
Incident Number
7035
Visibility
public


Product Version
3.0.1
Fixed In Version
3.1.0Beta


Summary
unbalanced QOH by class code does not work


Description

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.


Details
Reporter
sajeev
CRM Account
TS & B Retail Systems
Status
Closed
Assigned
cryan


Priority
Urgent
Severity
Major
Updated
09-06-12 15:39
Resolution
Fixed



Comments

DateUsernameComment
03/04/11 08:25mfgadmin

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.

03/04/11 08:25mfgadmin

Additional Info:

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.

08/07/08 10:01ptyler

Customer reports this is working now after applying scripts.

07/29/08 09:24cryan

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.

07/29/08 09:21svn

Revision: 2805
http://postbooks.svn.sourceforge.net/postbooks/?rev=2805&view=rev
Author: cryan
Date: 2008-07-29 13:20:56 +0000 (Tue, 29 Jul 2008)

Log Message:
-----------
Updated table definition to not allow null values and default to false for itemsite_freeze. Issue #7035.

Added Paths:
-----------
xtupleserver/trunk/updatescripts/from_310alpha/
xtupleserver/trunk/updatescripts/from_310alpha/alterItemsite.sql

07/29/08 09:08svn

Revision: 2804
http://postbooks.svn.sourceforge.net/postbooks/?rev=2804&view=rev
Author: cryan
Date: 2008-07-29 13:08:38 +0000 (Tue, 29 Jul 2008)

Log Message:
-----------
Added in some code to fix the balanceitemsite function. Issue #7035.

Modified Paths:
--------------
xtupleserver/trunk/dbscripts/functions/balanceitemsite.sql

07/17/08 21:48ptyler

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.



Characteristics

Operating System
 
Doc Flag
False
Copyright Assigned
Yes

Files

Filename
PickingListSOLocsNoClosedLines.xm


Related Documents

TypeNumberDescriptionRelationshipRemove
Incident3654Improve checks for deleting VendorRelated tox
ProjectXTUPLEAPPSPorted From Mantisx


Subscribers

You do not have permission to view subscribers.


Incident History

DateUsernameFieldChange
12/16/10 09:12acdrupalNewIncident Added