Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Work Order Costing - Missing Qty / Cost
11-20-2018, 06:11 AM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
11-20-2018, 12:28 PM (This post was last modified: 11-20-2018 12:33 PM by TurboPT.)
Post: #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)
Find all posts by this user
Quote this message in a reply
11-20-2018, 08:48 PM (This post was last modified: 11-20-2018 08:50 PM by VortecCPI.)
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
11-29-2018, 12:51 AM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


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