Notifications
Announcements
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…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 627 Super User 2025 Season 2
Abhilash Warrier 438 Super User 2025 Season 2
Martin Dráb 358 Most Valuable Professional