GL Detail Filtered By Transaction Date or Created Date

Kelsey Emerick
Kelsey Emerick
Fifth Anniversary Kudos 1 Name Dropper Participant
in Blackbaud Financial Edge NXT® General Discussions

Our grantors are asking for a gl detail report of our expenses on each request for reimbursement that we send to them. Previously we have included an income statement but not a gl detail.

The issue with this is we don't have a hard monthly close because we follow true accrual accounting. So we could process something through AP or create a JE in say January and its post dates will go back to December or November maybe. So the way we invoice we take total expenses minus previously invoiced expenses to get that “months” expenses. To include a GL detail of this we have to go through and manually delete lines that were invoiced in previous months. We couldn't just pull all the transactions in January for January's invoice because there may be some transactions that got posted to December but were processed after we invoiced for December so they are being picked up in the January invoice.

So we are trying to figure out a way to filter that GL detail by the transaction date or created date. But we also have to be able to limit it by project and grant t-code so we only get that specific grantors transactions. Anyone have thoughts on how to do this? Possibly with a query?

Comments

  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @Kelsey Emerick
    YOu can use a transaction query for that. In the criteria , go to the last section called trasnaction properties. There it will have date created , or date added. That is the actual date something is done regardless of the “post date”. You can use the operator of “Between” so you have start and end dates. IF you have over 16,400 lines in the results tab, you'll need to break up the dates more as the query can't export more than 16,400 lines in a single export in database view.

  • Kelsey Emerick
    Kelsey Emerick
    Fifth Anniversary Kudos 1 Name Dropper Participant

    @Kevin Brazell I did find this and I'm able to limit it by project but when I add a grant ID filter its like nothing has a grant for some reason. Which I know is not the case because I can find the same transaction in webview with a GL report and it has a grant t-code attached. Maybe I'll contact support about that and see if they can help.

Categories