Hello,
how do I get the number of pcs reported by a worker in a production? in x++. (In progress or as Feedback)
I know that for quantity by operation I can go JmgJobTable::QuantityGood()
I appreciate you help
thanks a lot before hand,
Hi CBNestor,
Maybe you can create new method like ProdRoute.qtyGood, but instead of filtering by route information, you can filter by worker. Something like this:
public ProdReportedGood qtyGoodByWorker(RecId _workerRecId) { return (select sum(QtyGood) from prodRouteTrans where prodRouteTrans.TransRefId == this.ProdId && prodRouteTrans.TransRefType == ProdTransRefType::Production && prodRouteTrans.Worker == _workerRecId && prodRouteTrans.TransType == ProdRouteTransType::Qty).QtyGood; }
Perfect Sergei,
as always thanks a lot
Just what I needed, I created it as a static method cuz I need to call that from an outside class
By the way Sergei,
Why the OprNum and OprId are not recorded in the ProdRouteTrans Table??
thanks a lot
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 1,922
André Arnaud de Cal... 835 Super User 2025 Season 2
