Post Reply 
 
Thread Rating:
  • 0 Votes - 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.)
Post: #1
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.

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


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

Forum Jump:


User(s) browsing this thread: 1 Guest(s)