RC2020
(Miguel Lopez)
July 28, 2022, 11:08pm
#1
Hello Everyone,
I need assistance in creating a BAQ to display Packslip and PO information against Purchase Orders for outside processing.
The main items I need on my BAQ is PO#, Packslip, Job Number and Part Number.
I get the information but it is not always pulling the PO associated with the Job and operation.
Below is my layout. I am sure it has to do with table association.
Thanks in Advance
Miguel Lopez
prash172
(Prashanth Malavalli Sathyanarayana)
July 29, 2022, 9:36am
#2
@RC2020
Try as shown below, you can display
PartNum from PODetial
PO# , Job Num from PORel
Packslip from Rcvdtl
1 Like
RC2020
(Miguel Lopez)
July 29, 2022, 5:37pm
#3
Hello Prashanth,
I am not getting any Job Numbers populated on the query. In addition, I need to pull information from Job Operations that have outside processing.
My setup below:
My output below:
Thanks in advance.
Miguel
markb_wi
(Mark Bernhardt)
July 29, 2022, 6:02pm
#4
If you are looking for historical outside processing receipts to jobs, maybe try looking at parttran which should have most everything, once you find the proper TranType.
1 Like
RC2020
(Miguel Lopez)
July 29, 2022, 8:17pm
#5
Ok, I will give that a try. Thank you.
RC2020
(Miguel Lopez)
August 1, 2022, 6:06pm
#6
Hello Mark,
The part_Tran table is not working for me either.
The issue I need the Outside Operations for selected jobs received within a date range.
I need the specific Operations with the associated purchase order and job number.
On my original baq all data was good but the relationship between Job and Packing Slip and PO don’t line up.
I would appreciate any assistance or other ideas.
Thanks in Advance.
Miguel