Query reports pulling from GL and AP ledger

Michele Elliott

We are putting details on the AP invoices that I would love to have attached to reports that I run in the General Ledger. Sometimes I have to reclass or do a journal entry for some expenses so a simple report from the AP ledger will not pull accurate records for activity in the GL. Does anyone have a work around or a way to run a report that pulls all the details from both systems into one report. The GL is the master, but there is information in the AP ledger that I would like to see on detailed reports pulled from the GL.

We just moved to Blackbaud in August 21 and I am still struggling to figure out how to get departmental reports with good data to be able to furnish to my managers that manage their own budgets.

Kristy Soular

What details from AP are you wanting to see on your GL reports?

If you go into Database - Accounts Payable - Configuration - Posting Information - You are able to set-up the information that posts in the GL

The drop down is longer than this but here are some options. I don't recall what the defaults were.

Is it something more than these options you were hoping to see detailed in the GL?

Sharelle Buyer

I would highly recommend you do your re-classes/adjustments in the AP module and not do a journal entry. We started doing this when we converted to Blackbaud. This way you have a trail in AP of where exactly your coded the invoice, etc. There was always confusion when looking in AP and we saw where the invoices was coded but could see that it was re-classed at a later date. This was all “transactions” that apply to an invoice are located in the AP module.