What table is the invoice payment method is stored in?

Question

I'm trying to pull invoices from JrnlHdr using ODBC and am having trouble determining if the invoice was paid by check, CC, ACH, etc...

keysd · Accepted Answer

Okay, I found my answer. 
 The field is PayMethodRecNum and its in the JrnlHdr table. For some reason I don't see that field listed in the data dictionary.

Sage 50 US

What table is the invoice payment method is stored in?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING