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


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

Version: 3.0.1

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


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks