Connecting InvcHead to ShipHead in BAQ

Kinetic ERP
1

Hello everyone,

In my previous post, I linked the Salse Category with your help. But I am facing another difficulty.
I’m trying to create the AR invoice report that our users want at BAQ. They want only the total amount to be displayed on one line, not the invoice details. So I took InvcHead instead of InvcDtl.
But, they want this report to include the Label Comment and Tracking Number in Shipment Entry. This field is in ShipHead, and ShipHead is not linked to InvcHead. These two tables don’t even have relationship fields.
How can I link these two tables and get the Label Comment and Tracking Number fields that I want? As a prerequisite, it should be created as one line of invoice total, which is also why I brought Head instead of Dtl.
I would like to ask for your help. Thanks,

image
image1969×1139 105 KB

image
image1152×934 124 KB

2

Hi
Probably the best way is to create sub-query linking InvcDtl to ShipDtl to ShipHead which will return the invoice number and the tracking details that you want.

Then create a top-level query linking InvcHead to your sub-query which returns the InvcHead information that you want and the tracking details from your sub-query

2 Likes