Key field between Invoice Header and Detail 1

[cfcanter]

What is the key field I can use to link AP_13InvHistoryDetial (A/P Invoice History Detail File) & AP_12InvHistoryHeader (A/P Invoice History Header File) ?

I see Invoice Number and Header Sequence Number in each table. The problem I have is where two vendors have the same invoice number.

Thank you

Craig Canter
Controller
Elgin IL

 

[BigLouie]

If you have the same invoice number in there twice this is where the header sequence number comes in. One vendor's invoice is sequence 000 while the other is 001 and so on. You link on Invoice Number and Header Sequence Number.

 

[cfcanter]

THANK YOU!

We tested 40 invoices and got it right each time.

Craig Canter
Controller
Elgin IL