Re: [GNC] Balance column Lost

2023-12-19 Thread Adrien Monteleone
Your welcome, and I'm glad you were able to recover the column. Your suggestion sounds like a good idea. But what would be even nicer would be a menu option to restore default widths for any register in one click. (this is currently possible with invoice/bill column widths, but not registers,

Re: [GNC] Can I print an account?

2023-12-18 Thread Adrien Monteleone
In addition to the Transaction Report (and a ScreenCap by various methods), there are two other options: 1. Use View > Filter by... to set the range of transactions you want visible in the register, then run Reports > Account Report. 2. While the main Accounts tab is in focus, do a Find for

Re: [GNC] Accounting Period Change issue

2023-12-18 Thread Adrien Monteleone
If it is intended to redraw-refresh and is not, then certainly, I'd call that a bug, otherwise, a Request For Enhancement. Regards, Adrien On 12/18/23 2:11 PM, Kalpesh Patel wrote: Hmmm! For 1) see the attached jpg. It describes the situation that no one wants to be in (fyi - I am current

Re: [GNC] Updating GnuCash

2023-12-18 Thread Adrien Monteleone
Yes. Regards, Adrien On 12/18/23 11:56 AM, Edwin Booth wrote: I just downloaded the GnuCash 5.5-1 onto my MacBook. This is the first update I’ve downloaded (currently running 5.4 but am still pretty new to it all—including the Mac). What do I do to update the program? Do I slide the icon over

Re: [GNC] ANNOUNCE: GnuCash 5.5 Released

2023-12-17 Thread Adrien Monteleone
Does it work on 5.5. if you run an Aging Report and then click the total amount for a customer to get a Customer Report? (just curious about different paths to the report) Regards, Adrien On 12/17/23 9:18 PM, Glenn Fowler wrote: Hi, I just installed 5.5 on Windows and I noticed when opening

Re: [GNC] Size of description column not shrinkable?

2023-12-17 Thread Adrien Monteleone
Yes, the Description/Memo columns spring back. Always grab the right handle and drag left and they will snap to fill the remaining space. You *can* specify the widths numerically, but you have to edit your .gcm file by hand to do so. See the wiki for the file location on your OS:

Re: [GNC] Balance column Lost

2023-12-17 Thread Adrien Monteleone
Paras, I just broke mine to learn how to fix it for you! 1. Close GnuCash 2. Go to this page on the wiki, and open the file location diagram for your OS: https://wiki.gnucash.org/wiki/Configuration_Locations 3. Look for the location of the .gcm files. 4. Navigate to that location in your

Re: [GNC] Wrong Total(Period)

2023-12-14 Thread Adrien Monteleone
I'm not familiar with how it works with multiple currencies, but at first glance, that looks like the sub-accounts are rolling up to the parents, which is as expected. Regards, Adrien On 12/13/23 7:10 PM, Fred Tydeman wrote: OS: Fedora Linux 36 GnuCash: 4.14 Looking at the expanded Chart

Re: [GNC] Nice to Have?

2023-12-14 Thread Adrien Monteleone
No Stan, they aren't talking about not showing them at all, but rather showing those not due to fire or due to be reminded, for that same day, in the Since Last Run (SLR) dialog. See the screenshot Grace posted. This isn't the editor, this is the SLR dialog. Also see my other post threaded

Re: [GNC] Monthly Expense summary Report

2023-12-14 Thread Adrien Monteleone
It works the same on MacOS (with CMD). If you only want Income & Expenses, click Clear All. Then collapse the tree completely so you can see the main accounts. Select Expenses and click Select Children Holding Ctrl/Cmd, Select Income and again (still holding Ctrl/Cmd) click Select Children.

Re: [GNC] Nice to Have?

2023-12-14 Thread Adrien Monteleone
Yes. Regards, Adrien On 12/14/23 2:47 PM, Mark at Lorimark wrote: Did you close the program and re-open it after resetting the option? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Nice to Have?

2023-12-14 Thread Adrien Monteleone
to fire. But setting it back, and re-running the SLR, now all Enabled SX are listed (below the Reminders unlike Grace's screenshot) and I can't seem to make them go away and get back to the original behavior. Regards, Adrien On 12/14/23 2:35 PM, Adrien Monteleone wrote: It looks like that is what

Re: [GNC] Nice to Have?

2023-12-14 Thread Adrien Monteleone
It looks like that is what Grace is already referring to by the screenshot. I'm not even sure how to show all SX on that dialog, even those not set to remind or auto-create yet. If I set a window or untick the option entirely, they don't show up. If there are none for the day, I get that

Re: [GNC] Nice to Have?

2023-12-14 Thread Adrien Monteleone
I take it back. There are global preferences under Preferences > Scheduled Transactions but as far as I can tell, the auto-create and notify window periods are only for 'new' SX as defaults. You can still individually change these. Regards, Adrien On 12/14/23 10:49 AM, Adrien Montele

Re: [GNC] Nice to Have?

2023-12-14 Thread Adrien Monteleone
Yes, that is called the Since Last Run dialog. You can also fire it manually under the Actions > Scheduled Transactions menu item. I just tested it on 5.4 and the behavior for me has not changed. If I untick the box to remind me, and there are no SX for today, instead of the list, I get a

Re: [GNC] Monthly Expense summary Report

2023-12-14 Thread Adrien Monteleone
Either of those reports (Transaction or Budget) should allow you to select any accounts you want. Regards, Adrien On 12/14/23 12:19 PM, Alan Johnson via gnucash-user wrote: Thanks, That will work. Only annoyance is that I can't seem to select both income and expense at the same time,

Re: [GNC] How to change date of balance on register?

2023-12-14 Thread Adrien Monteleone
A Filter on the view might get close to what you want. Regards, Adrien On 12/14/23 9:13 AM, Alan Johnson via gnucash-user wrote: It would be nice of one of those options was customizeable - say 30 or 60 days or a chosen date out. ___ gnucash-user

Re: [GNC] Monthly Expense summary Report

2023-12-14 Thread Adrien Monteleone
The Transaction Report can group by period with subtotals and totals. That is a listing of each transaction though. You can likely reduce detail, but there should be a summary table you can turn on which might get you close. Also take a look at the Budget Report multi-period feature. If you

Re: [GNC] Nice to Have?

2023-12-14 Thread Adrien Monteleone
If I'm not mistaken, that is part of the setting for each Scheduled Transaction. You set how many days in advance you want it to remind you. If you would only want same-day, I'm hazarding a guess that "0" days would work. If that doesn't, try "1" day. I don't think this is configurable for

Re: [GNC] Linux Mint version of Gnucash 5.4 Stopped Generating Reports

2023-12-13 Thread Adrien Monteleone
Wait, I see now you say you are running 5.4, but the build ID is for 5.3. Definitely get that squared away first. Regards, Adrien On 12/14/23 12:12 AM, Larry Nagel wrote: My apologies in advance because I think this question has been asked and answered.  I have been running gnucash on Linux

Re: [GNC] Linux Mint version of Gnucash 5.4 Stopped Generating Reports

2023-12-13 Thread Adrien Monteleone
There was an issue with reports at one point, but I thought by that build it was fixed. There is another list thread if I'm not mistaken covering which build the fix first appeared in. Maybe see if you can find it and double check against your install. If you don't have the latest one, grab

Re: [GNC] How to fix Accounts Rec'ble aging? (have a prepayment & an "unpaid" invoice that cancel each other)

2023-12-13 Thread Adrien Monteleone
You could have also simply clicked both the prepayment and the desired invoice and the payment would have been applied to it. This is the same way you'd otherwise handle pre/overpayments that need to be later applied to invoices. Regards, Adrien On 12/13/23 2:32 PM, Eric Chapman wrote:

Re: [GNC] Easier way to jump to specific tab/register in main window

2023-12-13 Thread Adrien Monteleone
On MacOS at least, this does not work once you hit the Accounts tab. At that point, the tab takes input as if you are doing a visible-text search. There is no way with the keyboard to navigate off that tab again. (so far as I can figure out) (v5.4 on Monterey) Regards, Adrien On 12/12/23

Re: [GNC] UI Problem with 4.14

2023-12-11 Thread Adrien Monteleone
The label is there, but only in Basic View. Split & Transaction Journal do not have it. I'd say that is a bug. Regards, Adrien On 12/11/23 4:21 PM, Manfred Usselmann wrote: Yes, but then much more screen space is used. The border is there even with single lines, just without a visible border

Re: [GNC] Definition of document root

2023-12-10 Thread Adrien Monteleone
As Jim mentioned—good suggestion. I too think it would be more flexible as a book-preference. This does sound familiar, so it may be an existing bug/rfe, or maybe it simply has been brought up on the list before. Regards, Adrien On 12/10/23 9:17 PM, Brook Milligan wrote: The root path to

Re: [GNC] iPhone or iPad app

2023-12-10 Thread Adrien Monteleone
There is no official app other than the main GnuCash app for desktop. Anything else you find is a 3rd Party project. Regards, Adrien On 12/10/23 12:36 PM, Edwin Booth wrote: Do either of these apps work at all? It just says “Import” when I open the app, but then doesn’t do anything. I’d like

Re: [GNC] overdue column in customer/vendor overview

2023-12-10 Thread Adrien Monteleone
Try the Receivables Aging Report. You can keep that tab open at all times and just refresh it occasionally. If you want to see individual invoice and payment info for a customer from there, click the total owed for that customer and a Customer Report will show up. Depending on the detail

Re: [GNC] Business Income Statement: manipulating Cost of Goods sold

2023-12-09 Thread Adrien Monteleone
My first exposure to Income Statements (dubbed P in this case) was in the restaurant industry. Many of those businesses also put COGS as a 'top line' expense. But note, it was never part of the Income section. The organization was something like: Revenue Gross Sales Discounts &

Re: [GNC] Search not working

2023-12-08 Thread Adrien Monteleone
More specifically, not just 'within the register' but it will only search in splits tied to that register. So if you have the Bank Account register open and you do a find, but that info is not in a Bank Account split, but say an expense account split, GnuCash will not return it in the

Re: [GNC] Business Income Statement: manipulating Cost of Goods sold

2023-12-08 Thread Adrien Monteleone
Cost of Goods Sold (COGS) is an Expense account, not Income. What you are looking for is a different type of Income Statement that does not exist in GnuCash. (the basic math is the same, you just are looking for a 'Net Sales' figure by moving COGS to the upper part of the report. This is

Re: [GNC] UI Problem with 4.14

2023-12-08 Thread Adrien Monteleone
The border between the Account and Reconciliation column does exist, but you have to turn on View > Double Line to see it. And thanks for the tip about double-clicking. I forgot about that part. Regards, Adrien On 12/7/23 7:55 PM, Manfred Usselmann wrote: There is one additional difficulty

Re: [GNC] Business: return of goods to vendor with refund to credit card

2023-12-07 Thread Adrien Monteleone
You are welcome, and thank you for the kind sentiment. I try to help out when and where I can. Regards, Adrien On 12/7/23 2:06 PM, Eric Chapman wrote: Thanks, Adrian. You are a good and thorough teacher and a great asset to this list. Eric ___

Re: [GNC] UI Problem with 4.14

2023-12-07 Thread Adrien Monteleone
On 12/7/23 2:07 PM, Robert Heller wrote: At Thu, 7 Dec 2023 13:46:19 -0600 adrien.montele...@lusfiber.net wrote: The Description column always fills the remaining width of the window. You adjust the other columns to your liking, then reduce the window width to shrink the Description

Re: [GNC] Business: return of goods to vendor with refund to credit card

2023-12-07 Thread Adrien Monteleone
I can't speak to your chosen solution, but to do this with a Credit Note: 1. Raise the Credit Note, assigning the line items to their proper Expense accounts. This will result in Credit entries (right column) in those affected Expense accounts, where normally Expenses are Debits(left column)

Re: [GNC] UI Problem with 4.14

2023-12-07 Thread Adrien Monteleone
The Description column always fills the remaining width of the window. You adjust the other columns to your liking, then reduce the window width to shrink the Description column. Otherwise, you can after setting the other columns, drag the right handle of the Description column to the left

Re: [GNC] Advise me please: go up to 5.4.2 or stay at 4.13?

2023-12-07 Thread Adrien Monteleone
Correct. The extra processes were on Windows only. The Mac version is fine otherwise. Regards, Adrien On 12/7/23 9:42 AM, Eric Chapman wrote: It does not: I'm running GnuCash on the Mac side! So I'm OK, I guess. ___ gnucash-user mailing list

Re: [GNC] Selling an unpaid invoice to another business at face value?

2023-12-06 Thread Adrien Monteleone via gnucash-user
The amount owed stays in AR. Who owes it is what changes. How you do that is not specific to GnuCash. You will likely have to employ intermediary accounts, but what those should be, are up to you and your needs/requirements. Perhaps ask a local CPA. Regards, Adrien On 12/6/23 7:01 PM,

Re: [GNC] Reports for Personal Finance

2023-12-06 Thread Adrien Monteleone via gnucash-user
You use Edit > Stylesheets. Alter the one you want. When you run the report, select that stylesheet in Options. There may not be a way to adjust that column easily. You'll have to poke around to find out or craft a careful CSS rule using the Experimental stylesheet. Regards, Adrien On

Re: [GNC] Reports for Personal Finance

2023-12-05 Thread Adrien Monteleone
If you are that far along, the Budget module can 'auto-estimate' based on previous data. Investigate and play with that feature. Even if you don't use it as a basis of a new budget, it can at least provide you with some analysis that otherwise might be more difficult to craft in a report as it

Re: [GNC] Selling an unpaid invoice to another business at face value?

2023-12-05 Thread Adrien Monteleone
Sorry Morgan, I didn't mean to exasperate you. What I meant by 'How would you do this on paper?', was, "Using Pen and Ink, How would you record this according to standard Accounting rules?" If you can do it with pen and ink, you can likely do it with GnuCash. So the question, for this list,

Re: [GNC] Business use: Producing 1099s for vendors

2023-12-05 Thread Adrien Monteleone
The 'status' can change with the wind. GnuCash, so far, does offer you a wealth of information concerning your activity with each 'vendor' that is most likely useful for information you have *already determined* need a 1099. That is, your question is not a GnuCash question, but a legal one.

Re: [GNC] Advise me please: go up to 5.4.2 or stay at 4.13?

2023-12-05 Thread Adrien Monteleone
There is nothing wrong with that approach as long as you are clear on 'what isn't wrong' and 'what isn't broken'. Many bugs are fixed each release. Some of them are otherwise unknown bugs that the devs discover as they are refining the code and fixing other known bugs. But plenty are the

Re: [GNC] How to export reports to spreadsheet format(s)?

2023-12-05 Thread Adrien Monteleone
#1 - Run Report, Select-All, Copy, Open Spreadsheet app, Paste #2 - Run Report, Export as HTML, Open resulting file with Spreadsheet app. #3 - Run Report, Export, Use 'Insert from File' in Spreadsheet app. With the last two, you will likely be asked to confirm formatting ala importing a CSV

Re: [GNC] Where can I download the 5.4 Tutorial and Concepts Guide (the "Documentation", which I call the "manual")

2023-12-05 Thread Adrien Monteleone
Did you not see the 'Documentation' link in the website menu that points here: https://gnucash.org/docs.phtml ? Regards, Adrien On 12/5/23 9:05 AM, Eric Chapman wrote: I found it: https://code.gnucash.org/docs/C/gnucash-guide.pdf ___

Re: [GNC] Selling an unpaid invoice to another business at face value?

2023-12-05 Thread Adrien Monteleone
I'm not sure that adds much clarity. Your initial description appeared to be that you had two business entities and you were transferring old debts owed to the first entity, to a new one - where you control/own both. Now it appears that you are 'selling a debt' owed by one entity, to

Re: [GNC] Upgrading to 5.3 from 2.6.15

2023-12-04 Thread Adrien Monteleone
Possibly. I see that I filed it while using 5.3. I don't recall exactly, but it might be in the Experimental folder, but I'm uncertain. Regards, Adrien On 12/4/23 10:29 PM, larry johnston wrote: In ver 4.14 I don't see any other options than Range Start and Range End, maybe Collapsed

Re: [GNC] Upgrading to 5.3 from 2.6.15

2023-12-04 Thread Adrien Monteleone
If you clicked the link for the bug and read it, you should see discussion on it. If you want to file a bug, or comment on this one, you need an account on that site. If I'm not mistaken, I'm derelict on getting back with a screenshot showing the problem. I hope to get that up to speed this

Re: [GNC] How to "lock" expenses from previous year?

2023-12-04 Thread Adrien Monteleone
That will only keep you from editing those reconciled transactions without receiving a warning. (that is, you *can* still edit them, they are not 'locked' but you will get a warning about editing a reconciled transaction, which you can override, and also, dismiss the warning, which means you

Re: [GNC] How to fix: I posted a bill to 1969 (should be 2022)

2023-12-04 Thread Adrien Monteleone
You didn't post it to 12/31/1969, but likely entered an invalid date. (easy to do when typing and clicking fast) GnuCash will sometimes default to that date in such a case. To fix it, simply unpost and repost with the correct date. If you need to change the 'opening date', then after

Re: [GNC] Advise me please: go up to 5.4.2 or stay at 4.13?

2023-12-04 Thread Adrien Monteleone
The 5.x series introduced a new way of auto-completing Descriptions. (you get a drop down list to choose from if you want to) There are some kinks for a few folks, and the new method takes a little getting used to, but overall I find it to be a vast improvement. Some folks aren't so keen on

Re: [GNC] Customizing appearance of parent accounts only in Accounts tree

2023-12-02 Thread Adrien Monteleone
For completeness, in case anyone is wondering and knows about the ability to use CSS to alter UI appearance: No, the contents of the Accounts Tab cannot be targeted by CSS. That area of the window is a GtkTreeView where none of the items within it are exposed for styling rules. You can target

Re: [GNC] Navigation through chart of accounts: shortcuts or bookmarks?

2023-12-01 Thread Adrien Monteleone
Regards, Adrien On 12/1/23 9:01 PM, Adrien Monteleone wrote: Numbering is likely the way to go for the closest workflow to what you are using now, but there is also a 'Find Account' feature that might work for you as well. However, it will take more

Re: [GNC] Navigation through chart of accounts: shortcuts or bookmarks?

2023-12-01 Thread Adrien Monteleone
Numbering is likely the way to go for the closest workflow to what you are using now, but there is also a 'Find Account' feature that might work for you as well. However, it will take more keystrokes. Regards, Adrien On 12/1/23 8:25 PM, Art Chimes wrote: I've never numbered my accounts. This

Re: [GNC] GNU Cash not performing math functions correctly on entry [SOLVED]

2023-12-01 Thread Adrien Monteleone
On those machines it certainly *still is* a nice feature. Yes, some small businesses still use 40–50 year old adding machines. Why? Because they still work and are always at hand. You don't have to open an app with 'features', you just do quick math. (and yes, some companies still manufacture

Re: [GNC] Transaction Report Options menu bug report

2023-12-01 Thread Adrien Monteleone
Might be something in a dependency in 23.10. I can report it also works fine on MacOS. Regards, Adrien On 12/1/23 2:52 PM, Murugan Muruganandam wrote: i am able to print and make pdf Gnucash 5.4 Build Flathub 5.4.1 Ubuntu 22.04.3 ___

Re: [GNC] Enhancement suggestion

2023-12-01 Thread Adrien Monteleone
I wouldn't be in favor of a blinking tab. And if it were implemented, I'd for sure want to turn it off. But there might be some other effective method. Other than what was described in the bug report about directing you back to the uncommitted transaction explicitly, I can't see a path to

Re: [GNC] GNU Cash not performing math functions correctly on entry [SOLVED]

2023-12-01 Thread Adrien Monteleone
Indeed, I'm not sure how it worked for me earlier, but it is failing for each type of operand. It seems the code for auto-decimal is occurring with each numerical entry, rather than the final result. I'd call that a bug. Regards, Adrien On 12/1/23 12:52 PM, Fred Bone wrote: On 01 December

Re: [GNC] GNU Cash not performing math functions correctly on entry [SOLVED]

2023-11-30 Thread Adrien Monteleone
It is working fine here on MacOS and Linux Mint. Can you replicate it with a fresh test book using all default settings? Regards, Adrien On 11/30/23 10:25 PM, Michael Campbell via gnucash-user wrote: Fixed. Eventually. I unchecked the "Numbers, Date, Time" -> "Automatic decimal point" check

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-30 Thread Adrien Monteleone
Is there any way to get a report showing amounts 'as entered'. That is, are all foreign transactions converted by those rules in aggregate, or is there a method for getting the actual converted amounts tallied? (for example, the exchange rate might vary enough from the beginning of the report

Re: [GNC] GNU Cash not performing math functions correctly on entry

2023-11-30 Thread Adrien Monteleone
That sounds like a 'smallest commodity fraction' issue off the top of my head. Check your settings for your affected currency. Another place to check is the setting for automatic decimal points. Regards, Adrien On 11/30/23 4:20 PM, Michael Campbell via gnucash-user wrote: Hello All, Long

Re: [GNC] Enhancement suggestion

2023-11-30 Thread Adrien Monteleone
I could be mistaken, but I don't think uncommitted transactions are written using the SQL backends. An edit perhaps, but not a new transaction. Note, the OP is referencing a crash, or leaving GnuCash open, forgetting about a pending edit to be committed, and restarting the computer. I think

Re: [GNC] An operation is still running, wait for it to complete before quitting

2023-11-30 Thread Adrien Monteleone
Have you run Actions > Check & Repair > Check & Repair All? There might be something amiss that such scrubbing can clean up. Regards, Adrien On 11/30/23 9:53 AM, David Kirkby wrote: This may be related to my other issues, but I sometimes see this. I just deleted all my USD transactions,

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-30 Thread Adrien Monteleone
As Derek noted, this is likely not a bug, but an issue with your pricedb in your main file. I too lost the plot, and forgot that those reports can target which price to use for such cases. Your options then are to: 1. Play with the price target option 2. Edit, or delete the offending

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-30 Thread Adrien Monteleone
First, yes, that warning is for when you try to delete the *Invoice*, not the payment. (same for Bills with Vendors) Second, as you may have noticed, inline images are not possible with this list, you have to attach them separately. Because of that, if you can, please give them some

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-30 Thread Adrien Monteleone
Apparently so! You can't delete the *invoice* but you can delete the payment. I don't ever recall anything different and I've been using GnuCash for 10+ years. Of course, you do get the confirmation for deleting the payment, but it isn't an error. Deleting the payment *should* 'unattach'

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-30 Thread Adrien Monteleone
Once again - please remember to reply to the list... - It was several replies up the thread, but I was replying to your point about being able to delete payments for only some currencies. (though you've now discovered that currency isn't a limitation) Here was my posting: Let's get

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-29 Thread Adrien Monteleone
On 11/29/23 6:05 PM, David Kirkby wrote: Is it possible, and so how, to move the A/R USD account directly under the assets and not under the GBP account? When I set up accounts like that, the P and trial balance agreed with each other. On the Accounts tab, select that USD account and click the

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-29 Thread Adrien Monteleone
Since all of them are of type A/R and this isn't working with your current tree arrangement, I'd say you found a bug in the reports. You might want to file one and ask if you should separately file the same for the others. When you do so, create and upload a test file with just enough

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-29 Thread Adrien Monteleone
Receivables and Payables are not tied to each other. So there is no concern with matching their respective set of currencies. (that is, you don't need an HKD A/R account if you never receive funds in that currency for an invoice.) Regards, Adrien On 11/29/23 5:02 PM, David Kirkby wrote: The

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-29 Thread Adrien Monteleone
You can set your bank accounts nested however you want. GnuCash doesn't care as there is nothing special about such accounts. Gnucash *does* care about types Accounts Receivable and Accounts Payable. (regardless of what you name them) But exactly how these should be structured is still to be

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-29 Thread Adrien Monteleone
Thanks. I saw that from the bug report. Please double-check all three of those and make sure they are of 'type' "Accounts Receivable". Regards, Adrien On 11/29/23 2:47 PM, David Kirkby wrote: This is what I have. I changed the name of one account, adding "GBP" as you suggested.

Re: [GNC] How do I add AP and AR for multiple currencies?

2023-11-29 Thread Adrien Monteleone
No, that bug needed to be filed. The documentation is lacking and that bug will help alert for the need, and allow tracking of the progress. And thanks for the tree screenshot. That clears things up for the other thread. Note, the Wiki FAQ does have a smidge of more information on this

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-29 Thread Adrien Monteleone
On 11/29/23 2:24 PM, Adrien Monteleone wrote: Maybe expand that part of your tree in the Accounts tab and send us a screenshot? (and maybe do the same for A/P while you are at it, so we can put that to rest as well) ___ gnucash-user mailing list

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-29 Thread Adrien Monteleone
On 11/29/23 10:39 AM, David Kirkby wrote: On Tue, 28 Nov 2023 at 15:55, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: If so, I'd rename it. It is possible you don't even need it if that is your book currency. Just stick with the original Assets:Accounts Receivable, but you

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-29 Thread Adrien Monteleone
On 11/28/23 3:55 PM, David Kirkby wrote: On Tue, 28 Nov 2023 at 15:55, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: David, I could be mistaken, but I think this is influencing your reporting problem. (if the A/P side looks like what you posted below concerning A/R) Asse

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-29 Thread Adrien Monteleone
On 11/28/23 3:42 PM, David Kirkby wrote: Make a copy of your book and test out if one of these does the trick by editing one bill and/or payment accordingly (you might be able to just re-parent the account(s) though: Assets:A/R --Assets:A/R (GBP) --Assets:A/R (USD) --Assets:A/R (EUR) I see

Re: [GNC] How do I add AP and AR for multiple currencies?

2023-11-28 Thread Adrien Monteleone
As I noted in the other thread, you might not have to delete any transactions, just re-parent the account(s). In a worst case, you'd have to unpost and repost bills/invoices accordingly if you need to assign some to a different AR/AP account. (you can't delete bills or invoices, but you can

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread Adrien Monteleone
Weird. Without that bill, do the vendors show but with everything as zero balances? If not, try Options > General > Show zero balance items. If that works and your balances are all zero as of the end of Feb '22, then your A/P as of that date was indeed zero. Any discrepancy otherwise

Re: [GNC] Have I got my USD accounts set up wrong?

2023-11-28 Thread Adrien Monteleone
David, I could be mistaken, but I think this is influencing your reporting problem. (if the A/P side looks like what you posted below concerning A/R) I'm hazarding a guess that: Assets:Accounts Receivable:Accounts Receivable is in GBP, though you have no indication in the name. If so, I'd

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread Adrien Monteleone
On 11/28/23 5:34 AM, David Kirkby wrote: On Tue, 28 Nov 2023 at 10:35, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: Neither of those is an Accounts Payable Aging Report. I'm not certain what the first one is. The second is a Transaction Report. Go to Reports >

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread Adrien Monteleone
Neither of those is an Accounts Payable Aging Report. I'm not certain what the first one is. The second is a Transaction Report. Go to Reports > Business > Payable Aging Regards, Adrien On 11/27/23 4:58 PM, David Kirkby wrote: [image: image.png] [image: image.png]

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread Adrien Monteleone
Not so. Go back and read my replies again. You absolutely can get what you are looking for after the fact. Most accountants just want the total AP number. But if you need to provide it by Vendor, I've given you the steps to get that info. Regards, Adrien On 11/27/23 7:08 PM, David Kirkby

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-28 Thread Adrien Monteleone
The Payables Aging Report will tell you the *amount* that is outstanding, and to who, and with an aging time frame, as of the date of the report. Once you have the Payables Aging Report - you know who you owed money to as of that date and how much. To see which bills that entails, you have

Re: [GNC] Find what was in Accounts Payable some date in the past.

2023-11-27 Thread Adrien Monteleone
There's an Payable Aging Report. You can then click the total amounts owed for each Vendor to see which documents are outstanding. (this runs a Vendor Report) If you set the option on the Vendor Report for detailed links, you'll see which payments were applied to which bills and which bills

Re: [GNC] GnuCash 5.3 autofill headaches

2023-11-25 Thread Adrien Monteleone
ESC doesn't even work for me. See bug: https://bugs.gnucash.org/show_bug.cgi?id=799136 Regards, Adrien On 11/23/23 2:17 PM, David H wrote: Yes I've been caught by that a number of times, now having to check everytime and hit escape to not auto complete:-)

Re: [GNC] GnuCash 5.3 autofill headaches

2023-11-25 Thread Adrien Monteleone
I filed a bug a few days ago on this. The issue seems to be that the Don't Autocomplete option only works using a mouse. If you select it, then TAB, ENTER, or ESC, the autocomplete happens anyway. Regards, Adrien On 11/23/23 4:25 AM, Ruaraidh Sackville Hamilton wrote: I'm on Win 11 Gnucash

Re: [GNC] Can I find transactions into an account that has only one split?

2023-11-22 Thread Adrien Monteleone
Also, please remember to copy the list on all replies. Regards, Adrien On 11/22/23 3:53 AM, David Kirkby wrote: Unfortunately that's a bit difficult, as a lot of times I buy things with PayPal, so there's an entry in the PayPal account where no fees need to be paid, as the seller pays the

Re: [GNC] Last reconciled transactions have an error.

2023-11-22 Thread Adrien Monteleone
There is no issue with transactions not being reconciled and having later transactions reconciled. What matters is did those transactions that are reconciled really clear the bank? Do they explain how you got from the opening balance to the ending balance? That is all reconciliation is

Re: [GNC] Can I find transactions into an account that has only one split?

2023-11-22 Thread Adrien Monteleone
Then I'm at a loss as even with a well crafted Find operation, or using the Transaction Report as Chris suggested, you can't end up with a list that doesn't include transactions where no fee was paid by you. Only *you* know if a split needs to be added for that fee. How do you expect GnuCash

Re: [GNC] How do I change keybindings for tab switching in GnuCash?

2023-11-22 Thread Adrien Monteleone
Not certain, maybe someone else has, but have you checked your OS settings for this combo? That may be overriding your gtk file. Regards, Adrien On 11/22/23 10:13 AM, Glenn Fowler wrote: I am trying to change keybindings for tab switching in GnuCash which is default CTRL + ALT + PAGE UP/DOWN.

Re: [GNC] Can I find transactions into an account that has only one split?

2023-11-21 Thread Adrien Monteleone
(face palm!) Yes, thanks Chris! (not just for the suggestion, but for the awesome report work too!) Regards, Adrien On 11/22/23 12:43 AM, Christopher Lam wrote: Check the Transaction Report's Account tab. On Wed, 22 Nov 2023, 2:36 pm Adrien Monteleone, < adrien.montele...@lusfiber.

Re: [GNC] Can I find transactions into an account that has only one split?

2023-11-21 Thread Adrien Monteleone
Another option is to just open the Assets:PayPal register and look over them one by one to see if they contain an additional split to Expenses:PayPal Fees, then edit the ones that do not as needed. Regards, Adrien On 11/21/23 7:43 PM, David Kirkby wrote: I often receive PayPal transactions,

Re: [GNC] Can I find transactions into an account that has only one split?

2023-11-21 Thread Adrien Monteleone
Yeah, that's why I started off with this would be trial and error level effort. The OP wants transactions where at least one split appears in set A, but excludes any such transactions when *other splits* also appear in set B. I *think* this is possible, but I have to admit, I've never tried.

Re: [GNC] Can I find transactions into an account that has only one split?

2023-11-21 Thread Adrien Monteleone
Maybe. That's a trial and error sort of situation. Certainly, you can craft a Find from the Accounts tab with multiple criteria, the first should likely find all transactions matching Assets:PayPal, then the next might exclude all other accounts, or specific accounts. (since it is most likely

Re: [GNC] Import Bills & Invoices

2023-11-21 Thread Adrien Monteleone
Malformed CSV. See the Tutorial & Concepts Guide §18.1 Importing Bills and Invoices. The columns need to be in that exact order and format. Regards, Adrien On 11/21/23 9:02 AM, Mark at Lorimark wrote: I am trying to run File | Import | Import Bills & Invoices. The file-type to pick is *.csv

Re: [GNC] Can I produce a trial balance as a simple CSV file?

2023-11-21 Thread Adrien Monteleone
David, It may take a bit of setup, but there are other options: 1. html2csv - a python CLI app that will extract the table in the report to a CSV 2. online converters (some may be simply using the above python script) The first option keeps everything on your machine. The second allows drag

Re: [GNC] Auto-complete of Memo field suffers short term memory

2023-11-20 Thread Adrien Monteleone
Through further testing as I noted in the bug report followups, I have narrowed this down to GnuCash only auto-filling whatever has been previously entered in the same session. Restarting the app causes the amnesia. And this is for both Memo and Notes fields. My next two steps are to test a

Re: [GNC] Editable and Non-Editable Transactions in the same register

2023-11-20 Thread Adrien Monteleone
I'm not sure how you got to an 'edit payment' without first having a bill or invoice posted that the payment was applied to. It should only show that option if it has already been processed. Otherwise, it would say 'Assign as payment'. Note, while you can certainly make manual transactions of

Re: [GNC] Editable and Non-Editable Transactions in the same register

2023-11-20 Thread Adrien Monteleone
Mark, Business Feature transactions in the AP/AR registers cannot be edited. They are immutable via normal means. Manual transactions in those registers can be edited. The correct way to edit an invoice/bill is to unpost, edit, repost. If the payment is already linked and simple (applying

Re: [GNC] Transaction not showing as reconciled when it should be.

2023-11-20 Thread Adrien Monteleone
Your ending balance is £98.00 more than your starting balance. That's why only that one Debit gets you to zero. Are you saying the £107.29 transaction appears on this statement and needs to be reconciled? If so, either you have a duplicate as Steve mentioned, or you are missing an offsetting

<    1   2   3   4   5   6   7   8   9   10   >