Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Work Order Costing - Missing Qty / Cost
11-20-2018, 06:11 AM,
#1
Work Order Costing - Missing Qty / Cost
WorkOrderCosting.php

When viewing Work Order Costing prior to any issues "Qty Reqd" and "Cost Reqd" show values of zero.

I changed the SQL on line 143 to use qtyreqd instead of qtyrecd.

Can somebody please check this for me?

Thank You!
https://www.linkedin.com/in/eclipsepaulbecker
Reply
11-20-2018, 12:28 PM, (This post was last modified: 11-20-2018, 12:33 PM by TurboPT.)
#2
RE: Work Order Costing - Missing Qty / Cost
If this is the line 143 that you referenced: (in case file versions differ)

PHP Code:
SUM(worequirements.qtypu*woitems.qtyrecd) AS requiredqty

...then yes, I'd agree that should instead be qtyreqd in the calculated sum, based on the AS alias reference. (instead of qtyrecd in the calculation)
Reply
11-20-2018, 08:48 PM, (This post was last modified: 11-20-2018, 08:50 PM by VortecCPI.)
#3
RE: Work Order Costing - Missing Qty / Cost
Sorry about that... These two lines:

PHP Code:
SUM(worequirements.qtypu*woitems.qtyreqd) AS requiredqty,
SUM(worequirements.stdcost*worequirements.qtypu*woitems.qtyreqd) AS expectedcost 

Work Orders are about to become very important to us so I will be doing a lot of testing over the next few days...
https://www.linkedin.com/in/eclipsepaulbecker
Reply
11-29-2018, 12:51 AM,
#4
RE: Work Order Costing - Missing Qty / Cost
So now on partial receipt and close we get a usage variance written to the GL...
https://www.linkedin.com/in/eclipsepaulbecker
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)