Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Work Orders With Multiple Items - Context?
11-27-2018, 12:59 AM, (This post was last modified: 11-30-2018, 10:39 PM by VortecCPI.)
Work Orders With Multiple Items - Context?
This does not seem to work at all. Costing appears to be okay but Issue and Status seem to mix items together.
Looking at the SQL queries there is no way this will work given all material is grouped together at the Work Order level using reference field in stockmoves.

Again this whole Work Order feature appears to be only half baked or never thoroughly tested.

Sorry guys but this is VERY irritating...
Should not the SQL used for WorkOrderStatus.php and WorkOrderIssue.php be the same?

Why do we have Group BYs in Issue SQL but not in Status SQL?

Are these pages supposed to be per WO or per WO item?

Very confusing...
It appears Issue is for the entire Work Order but Status is for a Work Order item?

In some places Issue has GROUP BY and $_POST['StockID'] in the WHERE clause.

Messages In This Thread
Work Orders With Multiple Items - Context? - by VortecCPI - 11-27-2018, 12:59 AM
RE: Work Orders With Multiple Items - by phil - 11-27-2018, 05:06 AM

Forum Jump:

Users browsing this thread: 2 Guest(s)