AP foreign key to GL

Bryce Whiteside

Hi, does anyone know how to connect records from the Accounts Payable API with records in the General Ledger API? I'm sure everyone is setup differently, and it might be that our configuration doesn't have any kind of foreign key that is common between the two, but if anyone has an ideas, I'd love to hear them. Thank you.

Eddie Barker

Hi Bryce,

Unfortunately, that does not exist at this time. You can add it to the Idea Bank at the top of the Community page or at https://community.blackbaud.com/developer/ideas - this is one of the first things we look at when planning functionality. Please let me know if you have questions. Thanks!


Eddie Barker

Financial Edge NXT Product Management

Bryce Whiteside

Thanks Eddie. I appreciate the reply. For what it's worth, the closest thing I found in our configuration is:


[General Ledger]. [Transaction Distribution List].reference occasionally equals [Accounts Payable].Invoice.vendor_name + '-' + [Accounts Payable].Invoice.invoice_number + '-' + [Accounts Payable].Invoice.description


However, it depends on the finance team being consistent in how they enter the [General Ledger]. [Transaction Distribution List].reference. Apparently, our team is not consistent in that regard, so I can't use it to make a consistent join. That was the best convergence I could find, so I think I'm going to give up on making that join for now.


Thanks again for your reply.