AP Invoice BAQ Help

Kinetic ERP
, , ,
1

I am trying to create a BAQ showing all invoices (1/1/2025 - current), inv lines, total invoice amount and amount per line, vendor name, part numbers and descriptions. I would also like to add the GL account associated to the invoices.

Currently have: APInvHed inner joined to APInvDtl on Company = Company, InvNum = InvNum, VendorNum = VendorNum.
ApInvHed inner joined to Vendor on Company = Company and VendorNum = VendorNum
ApInvDtl left outer joined to Part on Company = Company and PartNum = Partnum.

image
image580×377 17.7 KB

image
image786×229 4.55 KB

I believe I have a solid foundation for it but am running into the problem of not all Part numbers are displaying. Prime example is Invoice 82955886 has 6 lines, none of which show part #, desc, or UOM. But in AP invoice tracker, it shows these were added.
image
image1805×221 18 KB

image
image515×244 4.84 KB

Can someone help me understand why this is happening before I even attempt to try and add the GLaccounts? - side note, I plan to use GLJrnDtl to accomplish this, does anyone have advice on if this is the correct way to accomplish what I’m looking for?

Any help is appreciated, thank you BAQ Wizards.

2

Update, I was initially pulling Part#, Desc, UOM from Parts table but instead pulled them from ApInvDtl.

3

The Part details for the example you are showing as Line Type “Receipt of Goods” can be pulled from APInvDtl.RcptPartNum and/or APInvDtl.POPartNum (I have mine set to POPartNum so it includes Qty Released and Qty Received). The parts that pulled from the successful attempt are non-PO or Misc items and the part number is entered on the Invoice line directly.