General Ledger Report

David Dover · April 2022

We're new to FENXT and need a detailed ledger report that shows account number, account description, transaction date, description (from both Expense Management and A/P) - this is super basic stuff. The chat folks say the GL Report uses Reference instead of Description, which doesn't help me. Does anyone know of a report that can pull these 5 fields and be sorted by account number? Thanks!

David Dover · April 2022

We also need Amount (either Debit or Credit).

Lisa Olscamp · April 2022

How are you entering your data that the reference does not show your description? That should pull in your info.

Sylvia Cook · April 2022

It is the description of the expense category that populates the journal reference field in the GL. So the description higher in the invoice request screen is not the description that populates the GL. It is a short description of the expense to aid the person approving the expense.

When you select an expense category you change that description to anything you want to show in the GL. You no need to keep the default description of the expense category.

I hope I understood your question correctly.

7a5a29c74e12e21b14f9deaeb734da6d-huge-im

David Dover · April 2022

The GL Report puts Payee information in the Reference column for expense management. At least that's what our system is pulling.

David Dover · April 2022

We put a description of the payment in the Description field in Expense Management (same for A/P for invoices). But the GL report pulls Reference not Description. Reference is the vendor in both modules. I just had a chat with Blackbaud and they said Description is not available in their canned reports or in queries. So, it's a useless field. I don't believe that, so I'm hoping someone can tell me how to get the Description field onto a report of some type. Otherwise, our department managers will never know what they are spending money on unless we go online and pull up each transaction individually.

Sylvia Cook · April 2022

Hmm… ok, check posting information in AP. Here you can see that we have "invoice line item description', a space, vendor name, hyphen, and then invoice number. That all populate to the GL.

Note: when you make a change here, it will only apply to the future. Can't go back to past data.

f9069ae50e0b0374ecbb577fcd66b311-huge-im

Paul Sepulveda · April 2022

Overall, this is exactly what I'm running into. General Ledger report only summarizes AP transaction detail. You'd have to run an AP report to get the AP transaction detail and a ledger detail and remove the AP transactions and combine… I'm not happy with this either…

Mark Eisinger · April 2022

Here is a Knowledgebase article to show details on Control Accounts and to turn off summarize on the General Ledger Report.

Lisa Olscamp · April 2022

It is definitely possible. Our GL detail reports show everything as you would expect to see them. Make sure you are capturing all including unposted entries.

Tricia Fourman · April 2022

The only way I have been able to get the description is through a Query in Database view. You can get payment date, payee name, description, amount, and account number. My only issue here is that it gives you the full distribution (offsetting cash account and inter fund accounts) for every transaction, so there is still clean up before the report is useful. This is just one of the reasons I've been pushing to make queries available in NXT.

David Dover · April 2022

Thanks, Sylvia. I think this might work!

General Ledger Report

Comments

Categories