web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

HowTo Good Quantity by Worker

(0) ShareShare
ReportReport
Posted on by 46

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,

I have the same question (0)
  • Verified answer
    Sergei Minozhenko Profile Picture
    23,093 on at

    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;
    }
    

  • CBNestor Profile Picture
    46 on at

    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

  • CBNestor Profile Picture
    46 on at

    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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 627 Super User 2025 Season 2

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 438 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 358 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans