I want to know the relationship between 2 types of AR invoices, MIS and SHP:
The SHP invoice I see when I save the data has all PackNum and PackLine in InvcDtl, but the MIS invoice does not exist, so I want to know the relationship between the two types of invoices to make a report to track whether all goods have been exported based on each shipment and MIS invoice and SHP invoice
Do a left outer join .Join type should be :All rows from invcdtl
1 Like