Re: [GNC] AR problems
> On Jan 15, 2020 w3d15, at 9:42 AM, Bruce Irving via gnucash-user > wrote: > > Thank you Adrien for your detailed reply. And my BP has dropped - I should > have waited another day before I made my "rant". My apologies. > >> Win10, GC 3.8, SQLLiteI am very disappointed - to the extent that I'm angry! >> I have tried all the reports in Business and Experimental and I could find >> none that give me a summary of my customers WITH a balance! Neither >> Customer Overview nor Customer Summary include the Balance and the Customer >> Report won't show which invoices are paid! > > The Receivables Aging Report shows all customers with a balance, as well as > the aging breakdowns of those balances. By default, only customers with a > balance are shown, but you can opt to show all customers if you like. Note, > there are problems with the standard version of this report. The beta version > in the experimental menu is better and will eventually be the standard. This > is probably the report you are looking for. > > The Customer Overview *does* show a balance, though maybe not by default. > There is a down arrow with a drop-down menu to the far right of the header. > From there you can select visible columns, where you will find ?balance? as > an option. > > The Customer Summary is not designed to show balances owed, but rather > profitability. However, it appears it doesn?t presently work properly. (and > some columns I can?t seem to figure out how to influence, that is, how does > the report calculate markup or expenses if those associated figures have no > place to be entered in the app?) > > Seeing which invoices are paid is a little different, and arguably the UI > could be better here. > > First, the new beta Customer Report has the option to show you the linked > ?documents?, that is, which payments apply to which invoices and do so in a > simple or detailed fashion. Think of this report as a ?statement of account? > where you can show more or less detail as desired. > > Second, the traditional and current official method for seeing which invoices > are paid/unpaid is to run a Find for all invoices (or by customer). There you > will see a Paid? checkbox column. You can?t mark them paid here, but you can > see if they are paid or not. You can also filter your search by if they are > paid or not, thus only giving you unpaid invoices, if you prefer. Sadly, this > result is not exportable nor can you copy/paste it somewhere else for > processing or tracking outside of GnuCash. (I?m pretty sure there is a bug > filed on this) > > Third, the Business > Customer > Invoices Due Reminder dialog will list all > invoices that have not been paid in full, along with their remaining > balances. I normally run GnuCash less than full width on a 1080p monitor and > I have enough room on the side for this reminder list to always be visible. > (as well as the AP equivalent, and my scheduled transaction up-next list) > > There are lots of ways to see the info you want, right out of the box. There > are others that might involve some creative searches and reporting based on > the AP or other Registers as well, but the above methods are much easier to > work with. > > Wow! When I get back to the office tomorrow, I'll dive into those reports > again. I guess my frustration was that there wasn't an edit report from the > toolbar. What I want to do is print statements for customers with a balance > due. As it stands, I have to look at each of 100+ customers one by one to > see if they have a balance, then print their statement. It’s the Receivables Aging Report you want then. When you get it configured with the options you like so it displays nicely, you’ll notice the total column amounts are all hyperlinks. Click the total of the customer for whom you want to print a statement and —voila! a Customer Report (aka Statement of Account) for that customer showing invoice and payment history along with aging and balance due. Note, this report (as all) have options for customization and you can pretty it up if you delve into report stylesheets. I leave my aging reports (AR & AP) open 24/7 in their own tabs along with GnuCash. I just reload them for a refresh as needed. It is a much saner workflow than having to run a blank Customer Report (statement) and then choose a customer in options. (when you get really adventurous, you can make a ‘dashboard’ using the multi-column report with your AR aging in one slot and the AP aging in another!) Now, as noted, the Aging reports have some problems. And they aren’t going to be fixed. Instead, new beta reports have been created from scratch. (In the experimental menu) Unfortunately, those versions hyper-link to the current standard Customer Report. That’s still usable, but the new corresponding beta version of that report allows for showing linked payments applied to each invoice. So if you want to use that newer version, t
Re: [GNC] AR problems
Thank you Adrien for your detailed reply. And my BP has dropped - I should have waited another day before I made my "rant". My apologies. > Win10, GC 3.8, SQLLiteI am very disappointed - to the extent that I'm angry! > I have tried all the reports in Business and Experimental and I could find > none that give me a summary of my customers WITH a balance! Neither Customer > Overview nor Customer Summary include the Balance and the Customer Report > won't show which invoices are paid! The Receivables Aging Report shows all customers with a balance, as well as the aging breakdowns of those balances. By default, only customers with a balance are shown, but you can opt to show all customers if you like. Note, there are problems with the standard version of this report. The beta version in the experimental menu is better and will eventually be the standard. This is probably the report you are looking for. The Customer Overview *does* show a balance, though maybe not by default. There is a down arrow with a drop-down menu to the far right of the header. From there you can select visible columns, where you will find ?balance? as an option. The Customer Summary is not designed to show balances owed, but rather profitability. However, it appears it doesn?t presently work properly. (and some columns I can?t seem to figure out how to influence, that is, how does the report calculate markup or expenses if those associated figures have no place to be entered in the app?) Seeing which invoices are paid is a little different, and arguably the UI could be better here. First, the new beta Customer Report has the option to show you the linked ?documents?, that is, which payments apply to which invoices and do so in a simple or detailed fashion. Think of this report as a ?statement of account? where you can show more or less detail as desired. Second, the traditional and current official method for seeing which invoices are paid/unpaid is to run a Find for all invoices (or by customer). There you will see a Paid? checkbox column. You can?t mark them paid here, but you can see if they are paid or not. You can also filter your search by if they are paid or not, thus only giving you unpaid invoices, if you prefer. Sadly, this result is not exportable nor can you copy/paste it somewhere else for processing or tracking outside of GnuCash. (I?m pretty sure there is a bug filed on this) Third, the Business > Customer > Invoices Due Reminder dialog will list all invoices that have not been paid in full, along with their remaining balances. I normally run GnuCash less than full width on a 1080p monitor and I have enough room on the side for this reminder list to always be visible. (as well as the AP equivalent, and my scheduled transaction up-next list) There are lots of ways to see the info you want, right out of the box. There are others that might involve some creative searches and reporting based on the AP or other Registers as well, but the above methods are much easier to work with. Wow! When I get back to the office tomorrow, I'll dive into those reports again. I guess my frustration was that there wasn't an edit report from the toolbar. What I want to do is print statements for customers with a balance due. As it stands, I have to look at each of 100+ customers one by one to see if they have a balance, then print their statement. > Also, I attempted to enter a Credit Memo and it would NOT allow me to > designate Cash on Hand. The message said something to the effect that the > account must be in the same currency. ALL of my accounts are USD!I finally > exported the AR Register and massaged it in a spreadsheet - a rather > cumbersome effort to get it massaged. I?m not exactly sure what went wrong here. I?d have to do a test. But make sure the customer you are issuing the credit note for is set for USD. (should be by default) I believe the warning is about the customer?s assigned currency has to match the account. I also have been using GNC since 2.6.? I have over 100 potential customers - all members of my Post (club). I imported the members last year from my member spreadsheet. I will order items for them and most pay me sometime after they receive them - even a year later. This one, however, paid by cash and the item is still in-transit - and that is a rare occurrence. It's my understanding that this credit will be applied to the invoice which will be made in the future. Payments either go into Cash on Hand or Checks on Hand. (They haven't been deposited yet.) Though I would ask, why do you want to issue a credit note linked to ?cash on hand?? Usually a credit note line item will be posted against an income/revenue account which will act as a reversing transaction. (a debit to income, rather than the normal credit) The credit note itself will post a credit to AR, which would reduce the customer?s AR balance. Maybe a walk-through of the part
Re: [GNC] AR problems
Oh, I get the markup formula, it was where GnuCash is supposed to get those numbers that was throwing me off. Reading the manual a bit more seems to indicate this was designed to only be useful with the chargeback function, which is still confusing to me and I think is very limited to how it can be used. (confusing in that it never seems to work as I think it would, but it has been some time since I visited it) I think it is also tied to the ‘jobs’ feature, which is also very limited and misnamed. (I have a bug report on that one) ‘Jobs’ are really more like ‘purchase orders’ they are *not* really a way to aggregate expenses or revenues by what most people would consider as a ‘job’ or ‘project’. The manual even notes that the report really relies on the user creating artificial account layers/hierarchy for this tracking and analysis purpose, something that would better be handled by some sort of category or tag/label method instead. Indeed, running the report on my book assigns everything to “No Customer” which the manual notes is indicative of not having something set up properly with respect to chargebacks and special accounts. I wonder if anyone is using this report (or the associated chargeback functions) and if so, how are they setup to utilize it properly? Such examples might be useful to generalize and add to the docs as the current state of the section leaves a new user a bit unsure exactly how to proceed. Regards, Adrien > On Jan 14, 2020 w3d14, at 5:04 PM, Christopher Lam > wrote: > > On Tue, 14 Jan 2020 at 22:03, Adrien Monteleone > wrote: > The Customer Overview *does* show a balance, though maybe not by default. > There is a down arrow with a drop-down menu to the far right of the header. > From there you can select visible columns, where you will find ‘balance’ as > an option. > > The Customer Summary is not designed to show balances owed, but rather > profitability. However, it appears it doesn’t presently work properly. (and > some columns I can’t seem to figure out how to influence, that is, how does > the report calculate markup or expenses if those associated figures have no > place to be entered in the app?) > > A customer's "markup" is defined by "profit / sales". Profit is defined by > "sales - expense". Expenses are supposed to be retrieved by checking > Customer's Expenses; I can't find mechanism to assign expense-transactions to > a customer either. I think this report is an anachronism, reporting things > that may have been possible in a previous generation. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] AR problems
On Tue, 14 Jan 2020 at 22:03, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > The Customer Overview *does* show a balance, though maybe not by default. > There is a down arrow with a drop-down menu to the far right of the header. > From there you can select visible columns, where you will find ‘balance’ as > an option. > > The Customer Summary is not designed to show balances owed, but rather > profitability. However, it appears it doesn’t presently work properly. (and > some columns I can’t seem to figure out how to influence, that is, how does > the report calculate markup or expenses if those associated figures have no > place to be entered in the app?) > A customer's "markup" is defined by "profit / sales". Profit is defined by "sales - expense". Expenses are supposed to be retrieved by checking Customer's Expenses; I can't find mechanism to assign expense-transactions to a customer either. I think this report is an anachronism, reporting things that may have been possible in a previous generation. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] AR problems
On Tue, 14 Jan 2020 at 19:31, Bruce Irving via gnucash-user wrote: > > Win10, GC 3.8, SQLLiteI am very disappointed - to the extent that I'm angry! Rather than ranting it might be more productive if you asked for help. Explain exactly what result you want and someone may be able to point you in the right direction. Also remember that all those here are volunteers providing their time to try to help others, so getting angry will not help. Colin ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] AR problems
Bruce, I can appreciate frustrations, but toning down the exasperation and seeking help for specific issues will likely yield the results you’re looking for. Also note, GnuCash is ‘free’ as in ‘free beer’, it isn’t a product you paid for. (and even those don’t guarantee any fit or usefulness for any particular purpose if you read their licenses) GnuCash is also ‘free’ as in ‘freedom’ in that anyone can work on the project. You don’t have to be an employee of some closed development company to make it better or work the way you would like. While many would interpret that last part to meaning, “You can code it” it also means you can contribute via this mailing list, through bug reports, and through testing changes and reporting their efficacy. Just by asking a question on this list, many have contributed to all of us better understanding how the software works, and where it doesn’t, how maybe it can be made better. Let’s take your issues one at a time. For clarity, I’m currently using v3.8 on MacOS 10.15 with the sqlite backend, and I use the business features daily. I’ve also used the XML backend in the past (on Linux) and I’ve been using GnuCash since the days of 2.6.early or so. (I don’t recall the exact version, but it was less than 2.6.teens) I’ve used it on Linux and now Mac, starting with Snow Leopard. I’ve never attempted any use of it on Windows. Note, while there are some exceptions concerning data storage, the use of different backends should not affect functionality such as how reports work, what they display, or what they are intended to calculate and convey. My below suggestions apply to all 3 options— the default XML, sqlite, and MySQL, and should apply to all operating system platorms GnuCash can run on. (that is, there aren’t hobbled or more functional versions depending on your OS. All are supposed to work the same, but that doesn’t mean an OS specific bug might not result in something not quite right.) For the first part: > On Jan 14, 2020 w3d14, at 1:28 PM, Bruce Irving via gnucash-user > wrote: > > Win10, GC 3.8, SQLLiteI am very disappointed - to the extent that I'm angry! > I have tried all the reports in Business and Experimental and I could find > none that give me a summary of my customers WITH a balance! Neither Customer > Overview nor Customer Summary include the Balance and the Customer Report > won't show which invoices are paid! The Receivables Aging Report shows all customers with a balance, as well as the aging breakdowns of those balances. By default, only customers with a balance are shown, but you can opt to show all customers if you like. Note, there are problems with the standard version of this report. The beta version in the experimental menu is better and will eventually be the standard. This is probably the report you are looking for. The Customer Overview *does* show a balance, though maybe not by default. There is a down arrow with a drop-down menu to the far right of the header. From there you can select visible columns, where you will find ‘balance’ as an option. The Customer Summary is not designed to show balances owed, but rather profitability. However, it appears it doesn’t presently work properly. (and some columns I can’t seem to figure out how to influence, that is, how does the report calculate markup or expenses if those associated figures have no place to be entered in the app?) Seeing which invoices are paid is a little different, and arguably the UI could be better here. First, the new beta Customer Report has the option to show you the linked ‘documents’, that is, which payments apply to which invoices and do so in a simple or detailed fashion. Think of this report as a ’statement of account’ where you can show more or less detail as desired. Second, the traditional and current official method for seeing which invoices are paid/unpaid is to run a Find for all invoices (or by customer). There you will see a Paid? checkbox column. You can’t mark them paid here, but you can see if they are paid or not. You can also filter your search by if they are paid or not, thus only giving you unpaid invoices, if you prefer. Sadly, this result is not exportable nor can you copy/paste it somewhere else for processing or tracking outside of GnuCash. (I’m pretty sure there is a bug filed on this) Third, the Business > Customer > Invoices Due Reminder dialog will list all invoices that have not been paid in full, along with their remaining balances. I normally run GnuCash less than full width on a 1080p monitor and I have enough room on the side for this reminder list to always be visible. (as well as the AP equivalent, and my scheduled transaction up-next list) There are lots of ways to see the info you want, right out of the box. There are others that might involve some creative searches and reporting based on the AP or other Registers as well, but the above methods are much easier to work w
[GNC] AR problems
Win10, GC 3.8, SQLLiteI am very disappointed - to the extent that I'm angry! I have tried all the reports in Business and Experimental and I could find none that give me a summary of my customers WITH a balance! Neither Customer Overview nor Customer Summary include the Balance and the Customer Report won't show which invoices are paid! Also, I attempted to enter a Credit Memo and it would NOT allow me to designate Cash on Hand. The message said something to the effect that the account must be in the same currency. ALL of my accounts are USD!I finally exported the AR Register and massaged it in a spreadsheet - a rather cumbersome effort to get it massaged. Bruce Preach the Gospel wherever you go. If necessary, use words. ___ gnucash-user mailing list gnucash-user@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.