Re: [GNC] What report shows all amounts owed in one receivables account?
There was a bug with some reports showing up blank in some cases on an older version, but I don't recall the specific version or cause. If you can, I'd recommend upgrading to the most recent release, 5.3, and report back the result. Regards, Adrien On 8/22/23 5:44 AM, Adam Mackler via gnucash-user wrote: Thank you for the response Adrien and Murugan. Unfortunately what you suggest is failing for me. The "Customer Report" generates only a blank tab. I selected the report directly from Reports → Business → Customer Report. After getting the blank tab I clicked on "Options", then on the "General" tab clicked the "Select..." button next to the "Customer" label, searched for the customer (the only customer I have) and then "Select" after finding the customer which takes me back to the Customer Report Options with the customer name now showing in the field between the "Customer" label on the left and the "Select..." button on the right. Then I click "Apply" and nothing changes. I still have a blank tab for the Customer Report. I tried changing the start date from "Start of accounting period" to a date earlier than the first invoice. Still the "Customer Report" tab is blank. I only accessed the Customer Report directly from the "Reports" menu. The alternative method you describe Adrien is impossible for me (clicking a link in the Receivable Aging report) because the Receivable Aging report is blank also. I am using GnuCash version 4.4. What else can I check to find what I am doing wrong? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] What report shows all amounts owed in one receivables account?
Thank you for the response Adrien and Murugan. Unfortunately what you suggest is failing for me. The "Customer Report" generates only a blank tab. I selected the report directly from Reports → Business → Customer Report. After getting the blank tab I clicked on "Options", then on the "General" tab clicked the "Select..." button next to the "Customer" label, searched for the customer (the only customer I have) and then "Select" after finding the customer which takes me back to the Customer Report Options with the customer name now showing in the field between the "Customer" label on the left and the "Select..." button on the right. Then I click "Apply" and nothing changes. I still have a blank tab for the Customer Report. I tried changing the start date from "Start of accounting period" to a date earlier than the first invoice. Still the "Customer Report" tab is blank. I only accessed the Customer Report directly from the "Reports" menu. The alternative method you describe Adrien is impossible for me (clicking a link in the Receivable Aging report) because the Receivable Aging report is blank also. I am using GnuCash version 4.4. What else can I check to find what I am doing wrong? Thank you again. --- Original Message --- On Sunday, August 20th, 2023 at 6:33 PM, Adrien Monteleone wrote: > > > You want the Customer Report. > > Note, you can run it directly and set the customer in Options > General, > > or you can click the total amount owed for that Customer in the > Receivable Aging Report. (it is a clickable link) > > Also, note the Customer Report has Options > Display Columns > > > Transaction Links where you can show which payments applied to which > invoices and vice versa. (there is a Simple and Detailed version of this > info) > > The aging information is for the entire account at the bottom. I don't > know of a report that will show aging per invoice. And coming from using > software in several other businesses, that info is very rare to find in > a report. AR is usually handled per-account rather than per-invoice at > least for tracking purposes with the general principles of: > > 1. Payments are always applied to an account before new charges on the > same day. > 2. Payments apply to the oldest outstanding invoice unless otherwise > requested. > > Of course, you may be required to operate differently. > > Regards, > Adrien > > On 8/20/23 10:05 AM, Adam Mackler via gnucash-user wrote: > > > Hi, sorry if this is a basic question, but I have not figured it out from > > the documentation. > > > > How do I generate a report that shows all amounts owed as recorded in a > > given receivables account, itemized by invoice, showing the amount > > remaining due for each invoice and the amount of time past the due date for > > each invoice? > > > > I tried Reports → Account Report from the register of the receivables > > account, but I got a blank tab with the header "Receivable Aging." The > > title sounds correct but the blank tab is not. > > > > I also tried Reports → Receivable Aging which did the same thing. > > > > I have multiple open invoices recorded in that receivables account, and I > > want to give the customer an account statement showing what he owes and how > > much is for which invoice (some invoices are partially paid). How can I > > generate such a report? > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] What report shows all amounts owed in one receivables account?
You want the Customer Report. Note, you can run it directly and set the customer in Options > General, or you can click the total amount owed for that Customer in the Receivable Aging Report. (it is a clickable link) Also, note the Customer Report has Options > Display Columns > Transaction Links where you can show which payments applied to which invoices and vice versa. (there is a Simple and Detailed version of this info) The aging information is for the entire account at the bottom. I don't know of a report that will show aging per invoice. And coming from using software in several other businesses, that info is very rare to find in a report. AR is usually handled per-account rather than per-invoice at least for tracking purposes with the general principles of: 1. Payments are always applied to an account before new charges on the same day. 2. Payments apply to the oldest outstanding invoice unless otherwise requested. Of course, you may be required to operate differently. Regards, Adrien On 8/20/23 10:05 AM, Adam Mackler via gnucash-user wrote: Hi, sorry if this is a basic question, but I have not figured it out from the documentation. How do I generate a report that shows all amounts owed as recorded in a given receivables account, itemized by invoice, showing the amount remaining due for each invoice and the amount of time past the due date for each invoice? I tried Reports → Account Report from the register of the receivables account, but I got a blank tab with the header "Receivable Aging." The title sounds correct but the blank tab is not. I also tried Reports → Receivable Aging which did the same thing. I have multiple open invoices recorded in that receivables account, and I want to give the customer an account statement showing what he owes and how much is for which invoice (some invoices are partially paid). How can I generate such a report? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] What report shows all amounts owed in one receivables account?
Hi, sorry if this is a basic question, but I have not figured it out from the documentation. How do I generate a report that shows all amounts owed as recorded in a given receivables account, itemized by invoice, showing the amount remaining due for each invoice and the amount of time past the due date for each invoice? I tried Reports → Account Report from the register of the receivables account, but I got a blank tab with the header "Receivable Aging." The title sounds correct but the blank tab is not. I also tried Reports → Receivable Aging which did the same thing. I have multiple open invoices recorded in that receivables account, and I want to give the customer an account statement showing what he owes and how much is for which invoice (some invoices are partially paid). How can I generate such a report? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
