Mantis Bugtracker

Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000059 [Both Evo and DBA Classic] major random 2009-03-26 07:44 2009-10-26 19:31
Reporter PHIPPSBIRD View Status public  
Assigned To NovaZyg
Priority normal Resolution fixed  
Status resolved  
Summary 0000059: Inventory quantity doubles and loses location
Description App. one to two weeks ago we installed updates to the software. This week when issueing material to a work order, WO-G, some materials showed zero quantity on hand even though IN-A showed the material on hand. Thus saying there was negative quantities on hand and issued. Next went to IN-K to make inventory adjustments, in doing so note pops up This part does not have any inventory locations. Go to IN-B, saved the part number with no changes or change warehouse from Q to Y (tried both ways). Go back to IN-K, move inventory changes and looks successful. Go IN-A, the inventory quantity doubles every time while total value goes into negative dollar amounts.
Additional Information Lastly I went to IN-E, inventory transactions report, print report in date range of items the problem is occurring in and noticed this line description:
C $ CHANGE (T and action) note says Adjustment to AVGC.
Tags No tags attached.
Banner Date 2009-03-26
Error Message
Program Name
Repeatable in Test Company
Attached Files

- Relationships

-  Notes
(0000062)
lpantic (administrator)
2009-05-04 15:53

this behavior is related to Binary Zeroes (null characters) in the Location field resulting it hte program thinking there are no Locations assigned when in fact there are. Resolution is to use UT-K-E and eliminate the BLANK Warehouse Location and replace it with a named Location. If you are on the latest IS Tech update, there is an updated version of UT-K-E that can be run with Warehouse Control turned on and allows you to select multiple existing Locations to retain rather than forcing you to consolidate to a single named Location.
(0000066)
HecTech (manager)
2009-06-08 11:49

Did the above note resolve your problem?
(0000101)
lpantic (administrator)
2009-10-26 19:31

SP3 for 9/16/09 update addresses several Inventory Location related issues which should correct this problem. Using UT-K-E to change a blank Warehouse Location to a named Location is recommended.

- Issue History
Date Modified Username Field Change
2009-03-26 07:44 PHIPPSBIRD New Issue
2009-03-26 07:44 PHIPPSBIRD Banner Date => 2009-03-26
2009-03-26 15:32 HecTech Assigned To => HecTech
2009-03-26 15:32 HecTech Status new => assigned
2009-05-04 15:53 lpantic Note Added: 0000062
2009-05-04 15:53 lpantic Status assigned => acknowledged
2009-05-04 15:53 lpantic Resolution open => fixed
2009-06-08 11:49 HecTech Note Added: 0000066
2009-07-06 16:56 HecTech Assigned To HecTech => NovaZyg
2009-07-06 16:56 HecTech Status acknowledged => assigned
2009-10-26 19:31 lpantic Note Added: 0000101
2009-10-26 19:31 lpantic Status assigned => resolved


Mantis 1.1.2[^]
Copyright © 2000 - 2008 Mantis Group
Powered by Mantis Bugtracker