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

Announcements

No record found.

News and Announcements icon
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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

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... 527 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 473

#3
Adis Profile Picture

Adis 284 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans