Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#34 Mantis ID:7317 - Detailed Inventory History by Lot/Serial #

open
nobody
None
3
2008-09-03
2008-09-03
omfgppc
No

Reporter: kleedom
Severity: Patch
Category: Inventory
Project: xTupleApps

Version: 3.0.1

Description:
Detailed Inventory History by Lot/Serial # report fails in Multi-Level Trace "forward" mode. Database Log displays error shown in attached text file.
Also, report can show repeated information in "backward" mode.

Steps to reproduce:
Failure problem appears to be isolated to circumstances where the report's forward "trace" encounters a Lot Controlled component where multiple receipts of the component were assigned to the same Lot Number. A simple BOM was created where all items were lot controlled. All components were received, however, one of the components was received twice using the same Lot Number. A work order was created and completed for the parent item, components issued, etc. Forward tracing from any component causes the report to fail.

A complete "backward" trace from the parent of the above example showed repeated detail of "sub-components" when the double-receipt-same-lot was tested on a sub-assembly component.

Additional information:
Key tables involved appear to be ls and ls_detail. The double-receipt-same-lot causes multiple ls_detail records each refering to a single ls record. Also, the failure appears to involve the function, lshist.

Read more at http://www.xtuple.org/mantis/view.php?id=7317

Discussion