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.
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