How are serial numbers linked to invoice lines?

Kinetic ERP
1

What table(s) tie a serial number to a specific AR Invoice line?

I can see in SNTran that there are fields for PackSlip and Pack line, but no similar fields for Invoice and Invoice line (InvcDtl).

An indirect association from:
SNTran<>ShipDtl<>InvcDtl
is insufficient, as it seems a PackLine can be associated with multiple InvoiceLines.

2

Take a look at the SerialNo table it should get you the info you’re looking for…

3

I don’t see any fields in SerialNo which uniquely tie a s/n to a specific InvcDtl line. There are fields for Packslip and Packline, but like SNTrans, those do not uniquely tie to a specific invoiceline.

4

Something like this:

image
image1203×800 263 KB

5

Thanks, that worked - at least for the latest invoice to which the serial number belongs. :slight_smile: