Re: [GNC-dev] [GNC] Customer Report versus Receivables Aging
I have a client that has frequent pre-payments and their entry in the Aging report shows a negative balance. (I owe them because they have pre-paid) I’m also using 3.7. Are you entering pre-payments using the “process payment” function? If you are simply taking the payment entered as a manual transaction, and later using the ‘apply as payment’ function, then the Aging report won’t see it till you do that. The business features and associated reports aren’t cognizant of manual entries. Regards, Adrien > On Nov 6, 2019 w45d310, at 11:00 PM, John Morris wrote: > > Hi All, > > Having recently upgraded from GnuCash 2.6.something to 3.7, we are > having trouble with the some of the customer features. Specifically, > two reports help us see the amounts we are owed and what we owe our > clients. Those reports are Reports -> Business -> Receiveable Aging > and Reports -> Business -> Customer Report. The first report gives us > a handy list of all the clients who have a balance (positive or > negative). The second report gives us details (invoices and payments) > about a particular customer and can be accessed from the first report. > > The problem we are having is that in version 2.6, Receivable Aging > included all invoices and all payments in its assessment of each > client's balance. Thus, if a client has overpaid by $100 but that > payment has not been applied to any invoices, it would show that the > client had a $100 negative balance. In version 3.7, no payments that > have not been applied to any invoices are included in the calculations > for this report. Thus, if a client completely pays all past invoices > and then sends another check for $100 to be applied to future work, > that client does not show up in the Receivable Aging report because it > thinks the client has a zero balance. As soon as I use even one penny > from that payment to pay an invoice, the entire $100 shows up in the > report. > > In contrast, the Customer Report shows all invoices and all payments > for a particular client, so we know if we owe the client or the client > owes us. Unfortunately, with over 1,700 customers, this is not a > practical way to track our receivables. > > Is there any way around this problem? We don't have many, but we do > have a few clients who regularly prepay their projects, so it is very > important for us to know who they are and where we stand with them. If > there is no way around this new functionality, how else do other > people keep track of prepaying clients? > > Thanks, > John ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] [GNC] Customer Report versus Receivables Aging
Hi John You're in luck... If you're willing to beta test the new versions of customer-report and aging-report, you can download the nightly at https://code.gnucash.org/builds/win32/maint/ and try the new versions in the Experimental reports submenu. Choose a build after 2-November. There's only one such build so far dated 3-November. The new customer report (beta) will have option to display all invoice->payments and payment->invoice links. Both will also handle prepayments in the aging table separately. Please report any bugs in https://bugs.gnucash.org The old customer and aging reports are otherwise unchanged and will hopefully be mothballed. Please report any unwanted discrepancies between old and new. On Thu, 7 Nov 2019, 13:01 John Morris, wrote: > Hi All, > > Having recently upgraded from GnuCash 2.6.something to 3.7, we are > having trouble with the some of the customer features. Specifically, > two reports help us see the amounts we are owed and what we owe our > clients. Those reports are Reports -> Business -> Receiveable Aging > and Reports -> Business -> Customer Report. The first report gives us > a handy list of all the clients who have a balance (positive or > negative). The second report gives us details (invoices and payments) > about a particular customer and can be accessed from the first report. > > The problem we are having is that in version 2.6, Receivable Aging > included all invoices and all payments in its assessment of each > client's balance. Thus, if a client has overpaid by $100 but that > payment has not been applied to any invoices, it would show that the > client had a $100 negative balance. In version 3.7, no payments that > have not been applied to any invoices are included in the calculations > for this report. Thus, if a client completely pays all past invoices > and then sends another check for $100 to be applied to future work, > that client does not show up in the Receivable Aging report because it > thinks the client has a zero balance. As soon as I use even one penny > from that payment to pay an invoice, the entire $100 shows up in the > report. > > In contrast, the Customer Report shows all invoices and all payments > for a particular client, so we know if we owe the client or the client > owes us. Unfortunately, with over 1,700 customers, this is not a > practical way to track our receivables. > > Is there any way around this problem? We don't have many, but we do > have a few clients who regularly prepay their projects, so it is very > important for us to know who they are and where we stand with them. If > there is no way around this new functionality, how else do other > people keep track of prepaying clients? > > Thanks, > John > ___ > gnucash-user mailing list > gnucash-u...@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] owner-report, receivables-aging etc
Hi Adrien You're better off building from current maint. It'll be in Reports/Experimental. Thx for beta testing. On Wed, 6 Nov 2019 at 16:00, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Christopher, > > I have some AR cleanup in-progress and your revised owner-report would > come in handy matching up payments to invoices. I’ll be happy to report > back any testing issues I encounter while using it. > > I can’t seem to find your link in the list threads, can you provide a > current link? (I have your github bookmarked but can’t seem to find where > this particular report is buried) > > Can I simply place it in my reports folder and load it or do I need to > build maint first? Thanks. > > Regards, > Adrien > > > On Jul 19, 2019 w29d200, at 3:56 AM, Christopher Lam < > christopher@gmail.com> wrote: > > > > Wish to canvas opinion on what is considered best practice for the > > following real-data simulations, for rebuilding owner-report and > > aging-report. This illustrates current buggy behaviour. > > > > * I have a $100 customer invoice, posted- and due-dates 6 weeks ago. > > * I have a $50 credit-note to same customer, posted and due-dates are 2 > > weeks ago. > > > > Intuitively the customer owes $50. But I haven't formally yet linked the > > credit-note to the invoice though. The $100 invoice is still unpaid > > > > Attachments show: > > * the Customer Report counts the $100 and $50 separately into separate > > owing date ranges. > > * the Receivables Aging report shows the CN $50 was automatically used to > > fund the $100 invoice, via FIFO (paying oldest invoice first). > > > > Which behaviour should we standardise on? > > > > > > [image: image.png] > > > > [image: image.png] > > ___ > > gnucash-devel mailing list > > gnucash-devel@gnucash.org > > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > > > ___ > gnucash-devel mailing list > gnucash-devel@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
[GNC-dev] owner-report, receivables-aging etc
> On Jul 19, 2019 w29d200, at 3:56 AM, Christopher Lam > wrote: > > Wish to canvas opinion on what is considered best practice for the > following real-data simulations, for rebuilding owner-report and > aging-report. This illustrates current buggy behaviour. > > * I have a $100 customer invoice, posted- and due-dates 6 weeks ago. > * I have a $50 credit-note to same customer, posted and due-dates are 2 > weeks ago. > > Intuitively the customer owes $50. But I haven't formally yet linked the > credit-note to the invoice though. The $100 invoice is still unpaid > > Attachments show: > * the Customer Report counts the $100 and $50 separately into separate > owing date ranges. > * the Receivables Aging report shows the CN $50 was automatically used to > fund the $100 invoice, via FIFO (paying oldest invoice first). > > Which behaviour should we standardise on? I've been using GC for several years and only started using AR this Spring. My preference is to use it as shown by your aging report. So far, my efforts to use a credit to pay a bill has been a dismal failure even when I make a cash payment and try to get both invoice AND credit. I'm currently on 3.6 on Win 10. Bruce Preach the Gospel wherever you go. If necessary, use words. ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
Re: [GNC-dev] owner-report, receivables-aging etc
Christopher, I have some AR cleanup in-progress and your revised owner-report would come in handy matching up payments to invoices. I’ll be happy to report back any testing issues I encounter while using it. I can’t seem to find your link in the list threads, can you provide a current link? (I have your github bookmarked but can’t seem to find where this particular report is buried) Can I simply place it in my reports folder and load it or do I need to build maint first? Thanks. Regards, Adrien > On Jul 19, 2019 w29d200, at 3:56 AM, Christopher Lam > wrote: > > Wish to canvas opinion on what is considered best practice for the > following real-data simulations, for rebuilding owner-report and > aging-report. This illustrates current buggy behaviour. > > * I have a $100 customer invoice, posted- and due-dates 6 weeks ago. > * I have a $50 credit-note to same customer, posted and due-dates are 2 > weeks ago. > > Intuitively the customer owes $50. But I haven't formally yet linked the > credit-note to the invoice though. The $100 invoice is still unpaid > > Attachments show: > * the Customer Report counts the $100 and $50 separately into separate > owing date ranges. > * the Receivables Aging report shows the CN $50 was automatically used to > fund the $100 invoice, via FIFO (paying oldest invoice first). > > Which behaviour should we standardise on? > > > [image: image.png] > > [image: image.png] > ___ > gnucash-devel mailing list > gnucash-devel@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
