BaQ with List of Part Number and the Latest Job it was Manufactured

Kinetic ERP
1

Hi Everyone,
Need help on this please.
I am trying to create a BAQ which lists all manufactured parts and a column which shows the latest job it was manufactured.

I am stuck with a lists of parts and showing all jobs that it was manufactured.
Would like to only show the latest job for each part.

2

“Latest” job might mean a few different things… can you narrow it down?
e.g.

  • max PartTran for a Job where the TranType = MFG-STK or MFG-CUS?
  • max LaborDtl for a Jobs Final Operation where the Complete Qty > 0?
  • or just any job for that part?
3

Hi @bordway , it is MFG-STK or MFG-CUS trantype.

4

The simplest solution would be to have two columns
PartNumber, MAX(TranDate)
GroupBy Partnumber.

Add a table criteria to filter on those parttran.trantypes.

2 Likes
5

Here is a quick example from E10.06… if you want to try importing
(I think it is working but I didn’t really check too much)
CUS-PartsLastJobs.baq (22.6 KB)

6

Thank you @bordway !!