Re: [GNC] reconciling specific credit cards in an account

2022-02-16 Thread Adrien Monteleone
If you have multiple cards from the same bank, you'll need to differentiate them in GnuCash somehow. Some people use the last digits, some the card 'brand' which can be different, even from the same bank. (not just card 'type' though that may be sufficient) Your Bank *might* offer you the

Re: [GNC] Download GnuCash issue

2022-02-16 Thread Adrien Monteleone
Glad you got it working, but 11Gb is more than enough to install GnuCash. (by 10+Gb) Perhaps something else was amiss that you happened to clear up. Regards, Adrien On 2/12/22 11:48 AM, David Long wrote: Hi, To update, my laptop is a 64 bit machine. I cleared up a bit of disk space, and now

Re: [GNC] Trying to get report with total when account has sub-accounts

2022-02-16 Thread Adrien Monteleone
, Jan 11, 2022 at 6:38 PM wrote: Date: Tue, 11 Jan 2022 17:14:29 -0600 From: Adrien Monteleone To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Trying to get report with total when account has sub-accounts Message-ID: Content-Type: text/plain; charset=UTF-8; format=flowed Why not use

Re: [GNC] Discount cards question

2022-02-08 Thread Adrien Monteleone
I record them as Current Assets and decrease them as I spend them. I record the receipt of them as Gifts Received. (which in some jurisdictions is exempt from greedy hands up to a reasonably high limit) Regards, Adrien On 2/8/22 6:02 PM, Mike via gnucash-user wrote: What is the correct

Re: [GNC] filtering in report

2022-02-08 Thread Adrien Monteleone
I'm not 100% certain, but investigate Regex 'look behind'. I seem to recall using it for negation effectively but it has been some time. Another option is to do a Find (always from the Accounts tab) and there you can do Regex and/or 'does not match' type criteria for exclusions. Then run an

Re: [GNC] Managing multiple vehicles

2022-02-08 Thread Adrien Monteleone
Play with your tags and the Transaction Report, particularly the Regex filter option. This won't get you a single report with all vehicles, but you can isolate transactions by vehicle that way. (and maybe get something useful out of the Multi-Column Report for more than one vehicle, if not

Re: [GNC] Customer Deposits

2022-02-08 Thread Adrien Monteleone
You can create such a liability account though you'd have to run a separate Account Report on it and later combine it with a Customer Report outside of GnuCash. (in a spreadsheet) And when you record pre-payments, you have to do them manually in that Deposits account, then later, 'pay' the

Re: [GNC] PDF creation option

2022-02-08 Thread Adrien Monteleone
Not without crafting a custom report in Scheme. You can however play with the Multi-Column report where you can have a report in one 'column' and a chart in another. (or one on top of the other for example) The other option is as I noted in my last reply: Export to spreadsheet and chart

Re: [GNC] PDF creation option

2022-02-04 Thread Adrien Monteleone
Try opening the PDF in a web browser or external app. I seem to recall there are various printing issues with some versions of Webkit which GnuCash uses for reports. (and the version used is OS specific) Alternatively, open in a spreadsheet and format and print from there. (you should just

Re: [GNC] How to properly import a csv with the correct settings.

2022-02-02 Thread Adrien Monteleone
And then you can create a special folder for messages from this list, and setup a filter to put them there automatically so from then on, you don't have to hunt through Allmail. There is also an option in Mailman preferences to not receive copies of your own messages. If you turn this off,

Re: [GNC] credit card minimum payment due

2022-01-28 Thread Adrien Monteleone
While formulas and variables are possible with Scheduled Transactions, unfortunately, they can't grab the current account balance. (and there are no 'if:then' logic functions possible anyway, just straight math) But you can choose to schedule the payment regardless of the balance, but set it

Re: [GNC] Could you please add a "reset to default" function?

2022-01-28 Thread Adrien Monteleone
That is an interesting request. In the meantime, you could start a new file, examine the default preferences, and write them down. Then go back to your main file and change them back accordingly. (there *might* be a page on the wiki documenting these already, I haven't looked, but I suspect

Re: [GNC] Updates

2022-01-28 Thread Adrien Monteleone
Have you tried File > Open? Then navigate to where you saved your data file. It should open and then when you close GnuCash, it will remember this location in the future. Since you are on Windows, you also have the option to double-click the data file itself and GnuCash will launch and open

Re: [GNC] Report Options - Closing Entries Pattern

2022-01-25 Thread Adrien Monteleone
Derek and Liz give the correct advice to keep separate books, but to your particular question of getting a filtered P—"you can't." You can however, get really close to one using the Transaction Report and its more robust filtering abilities. Then export that to a spreadsheet and fill in your

Re: [GNC] Accounting Question re Balance Sheet

2022-01-25 Thread Adrien Monteleone
I think you'll have issues if you try to have different account types between parents and children. I vaguely recall a thread about that a few years ago. (And I might have even done it once myself) Some folks were making Top Level accounts for various properties and duplicating other parts of

Re: [GNC] show unposted invoices in customer report?

2022-01-25 Thread Adrien Monteleone
The advantage to using a 'work completed' or similar account is that I'm booking revenue in the period in which it was earned. (following the Matching Principle—think I have that one named correctly) And I don't have to back-post invoices. If you want to stick with a spreadsheet, you can also

Re: [GNC] gnucash-user Digest, Vol 226, Issue 60

2022-01-21 Thread Adrien Monteleone
Click the Options button once you have the report up. Then go to the General tab and change the date range. Regards, Adrien p.s. when replying to a digest, please only quote the relevant part, and when starting a new thread, just send a new message to the list rather than hitting 'reply' to

Re: [GNC] Lost Back ground

2022-01-21 Thread Adrien Monteleone
Are you certain you are in the right data file and not in an old or different one? Regards, Adrien On 1/20/22 10:00 AM, Richard E. Barmann wrote: After using GnuCash for years I suddenly  have it start me with a o1 Invoice number instead of 001478,  Also I cannot retrieve my STYLE of

Re: [GNC] couple questions

2022-01-21 Thread Adrien Monteleone
Heide, It would likely be safest and easiest to upgrade in these steps: 1. 2.6.21 (the last 2.6.x version) 2. 3.11 (the last 3.x version) 3. 4.9 (the current version) I'm fairly certain, you don't need to upgrade to lower releases of each major version first. (such as 3.0 or 3.1, and 4.0 or

Re: [GNC] reports: filter by number

2022-01-12 Thread Adrien Monteleone
Good to know, thanks for the follow-up! Regards, Adrien On 1/12/22 3:31 AM, Bregt - ICTgroup.be via gnucash-user wrote: Hi Adrien, Your first suggestion works like a charm. The created report is exactly what I need. I'll have to work on the layout, as the options are more limited, but that's

Re: [GNC] Does GNUCash have an install DVD for Macintosh?

2022-01-11 Thread Adrien Monteleone
1. As Derek noted, you should download the .dmg file. 2. When it finishes downloading, double-click it to open it. 3. Then open a second Finder window and navigate to your Applications folder. 4. Drag the GnuCash icon from the GnuCash.dmg window to the Applications folder in the second

Re: [GNC] Trying to get report with total when account has sub-accounts

2022-01-11 Thread Adrien Monteleone
Why not use the Budget Report? It rolls up sub accounts, and shows a variance if you like. I'm pretty certain you can restrict the accounts reported on as well to reduce clutter. Another option is to use the P/Income Statement, select just the expense accounts you want. There is an option

Re: [GNC] reports: filter by number

2022-01-11 Thread Adrien Monteleone
Do the bill#'s show up in the NUM field (or elsewhere) in your expense account registers? If so, my first suggestion would be to do a Find (from the CoA tab) filtering for the string you want. Then run an Account Report (or File > Export > Active Tab to CSV) on the Find results tab. Let

Re: [GNC] Tax question - gross income for the year

2022-01-05 Thread Adrien Monteleone
Don't use the transaction report. Use the P or Income Statement. (same report, different names) If you are working on a cash basis, you'll have to make adjusting entries or else don't post invoices till you receive payment. If you are on an accrual basis, then no adjusting or delayed posting

Re: [GNC] A good tutorial on connecting online to my bank accounts?

2022-01-05 Thread Adrien Monteleone
Cool! Sorry, I didn't think this was possible based on past threads. Regards, Adrien On 1/5/22 4:35 AM, Frank H. Ellenberger wrote: please do not tell false facts! With the * german protocol FinTS you can initiate transfers. It is used by GnuCash users on a daily base. Note: with DTAUS we had

Re: [GNC] GNUCash 4.9

2022-01-04 Thread Adrien Monteleone
Glad to hear you resolved it, thanks for reporting back what worked. Regards, Adrien On 1/4/22 10:53 AM, Steve Mortimer wrote: What I did to correct my problem was to take the last backup file and remove all of the dates in the file name and made that my main (orginial) transaction file.  I

Re: [GNC] A repository for user-contributed files

2022-01-04 Thread Adrien Monteleone
I'd say more like 'ask' or 'request' or 'inform' people about that method in the Wiki. And while it has been some time, I think that method does work. I used to use it for a spell and I don't recall un-threading issues. But further confirmation would be needed. Regards, Adrien On 1/4/22

Re: [GNC] show unposted invoices in customer report?

2022-01-04 Thread Adrien Monteleone
On 1/4/22 12:24 PM, Derek Atkins wrote: Feel free to write a new report and submit it to the team for inclusion. In 20 years, you're the first person to ask for this. Maybe not to this level of detail, or with this specific solution/suggestion, but the basic question I've seen several times,

Re: [GNC] A good tutorial on connecting online to my bank accounts?

2022-01-04 Thread Adrien Monteleone
GnuCash cannot initiate transactions. You are limited to syncing previous transactions from the institution to GnuCash. Regards, Adrien On 1/4/22 2:27 PM, John Smith wrote: Is there a way to use GnuCash to connect to my credit union’s bank account and then move those funds from one account

Re: [GNC] Idiots guide to building GNC 4.9 on Ubuntu 20.04LTS

2022-01-04 Thread Adrien Monteleone
*Caveat, I haven't tried building 4.9 yet, or used the referenced script, but the below should still apply generally: You're not dealing with a PPA. The script is getting the source from Github and then building. A PPA contains already built packages. The wiki shows how to get info from the

Re: [GNC] Frustrated at invoice options

2022-01-03 Thread Adrien Monteleone
I think it has to do with how you run the Invoice Report. Unfortunately, it should work the same regardless of how you get there, but it does not. (there are several 'entry points' to getting a printed invoice, and they don't all work the same) There is at least one if not two other recent

Re: [GNC] Closing Books - Pros & Cons

2022-01-03 Thread Adrien Monteleone
You're welcome, and you did right by changing the subject. Unfortunately, replying to a digest doesn't thread to your original post. (as discussed in another thread) No way around that of which I am aware, but at least the subject is the same so we know what you are discussing! The only

Re: [GNC] GNUCash 4.9

2022-01-03 Thread Adrien Monteleone
Your original file never changes names, unless you do a File > Save As, or change it via your OS file manager. If you ever see a file with a date stamp, it is a backup. Do not try to open it in order to work in your main file. If you do, you are instead working in a backup copy and the main

Re: [GNC] GNUCash 4.9

2022-01-03 Thread Adrien Monteleone
The file names listed appear to have more than one date stamp: "1223GNUCASH.gnucash.20...0103063517.gnucash.LCK 1223GNUCASH.gnucash.201...cash.20220103114501.log " That would imply the last stamp before the '.gnucash.LCK' and '.log' extensions were the stamp when they were made, (which you are

Re: [GNC] Closing Books - Pros & Cons

2022-01-03 Thread Adrien Monteleone
The list archive is littered with such questions and answers. I'm not sure if anyone put any definitive Pro-Con write up together. The short answer is, you don't ever *need* to close because you don't *need* to reset your CoA. GnuCash dutifully reports both 'from the beginning' and 'this

Re: [GNC] GNUCash 4.9

2022-01-03 Thread Adrien Monteleone
Steve, I'll add that it appears you are opening backup files, not the main GnuCash file. The very long file names indicate this. So it seems you have backups of backups. If you find the main file, it might not have all the same transactions as whatever you are currently working in. Regards,

Re: [GNC] A repository for user-contributed files

2022-01-03 Thread Adrien Monteleone
I didn't examine the Message-ID because it had the same subject line. (so it *appears* that it *should* have been threaded properly) But I guess if they are replying to the digest and they copy-paste the subject, as they should, then it will appear un-threaded. I guess in that case, the

Re: [GNC] A repository for user-contributed files

2022-01-03 Thread Adrien Monteleone
_tools> On Fri, Dec 31, 2021 at 5:16 AM Dr. David Kirkby < drkir...@kirkbymicrowave.co.uk> wrote: On Thu, 30 Dec 2021 at 05:59, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: Thanks for the link, and I'll take a look, but I am curious... Why not just post that info on

Re: [GNC] MEMORIZING PAYEE ADDRESS

2022-01-02 Thread Adrien Monteleone
Victor, don't forget to copy the list! I was simply going to File > Print Checks after selecting the transaction, but as you point out, it seems printing from the Process Payment screen works reliably as well. We haven't heard back from the OP, but I guess they are either on an older

Re: [GNC] How to customize the default invoice (on print invoice button)

2022-01-02 Thread Adrien Monteleone
Hmm.. This will be interesting. I don't see a way using Gmane with Thunderbird that I can CC anyone. I get the option to 'reply' but that doesn't properly go through Gmane, or I can 'Followup' which does, but doesn't let me CC anyone. Anyway, I think the issue is one of the Stylesheet has to

Re: [GNC] A repository for user-contributed files

2022-01-02 Thread Adrien Monteleone
I'm sure time will tell, but I suspect it will indeed be found useful. There are plenty of questions concerning custom reports, and a place for people to find them is most appreciated. (that's why I made the suggestion in the first place!) Thanks again for the offering. (and I agree that

Re: [GNC] MEMORIZING PAYEE ADDRESS

2022-01-01 Thread Adrien Monteleone
Indeed, my file meets both conditions. Regards, Adrien On 1/1/22 7:03 AM, R. Victor Klassen wrote: I’m fairly certain you also have to be using the business features and have the payee listed as a vendor. On Dec 28, 2021, at 5:32 PM, Adrien Monteleone wrote: What is your process? I

Re: [GNC] access to backup Reports

2021-12-31 Thread Adrien Monteleone
Are you asking how to actually move the file? I can't help you with that part. It is just something you'll have to learn. As for *where*, the answer is to put them in the same place on the computer where you found them on the old one. (as long as you're using the same operating system) But

Re: [GNC] Editing a Budget - "from this period onwards"

2021-12-31 Thread Adrien Monteleone
I get that, but that's the best we have at the moment. Your hands don't have to leave the keyboard though, so it isn't terribly slow. Unfortunately, I don't think the Budget screen is implemented as a 'spreadsheet' though it has rows and columns of cells. That is probably why the

Re: [GNC] Exporting Data

2021-12-30 Thread Adrien Monteleone
There is nothing special about opening balances. They are just regular transactions that the fresh start wizard makes for you. You should be able to edit those transactions just like any other. But I don't understand what the problem is. Even the Retained Earnings account would have an

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

2021-12-29 Thread Adrien Monteleone
day. Maybe the code that makes them possible is yours... Regards, Adrien On 12/29/21 3:44 PM, Dr. David Kirkby wrote: On Wed, 29 Dec 2021 at 20:16, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: Quotations/Proformas are not basic functionality. They aren't even 'acco

Re: [GNC] A repository for user-contributed files

2021-12-29 Thread Adrien Monteleone
Thanks for the link, and I'll take a look, but I am curious... Why not just post that info on the Wiki in that place? What happens if your company site goes down/dark? Do the various tips not still apply to GnuCash which has no relation to your company? Are you opposed to sharing your tips

Re: [GNC] Exporting invoices and vendor bills to excel or Quickbooks

2021-12-29 Thread Adrien Monteleone
Yes. 1.) Find (from the CoA tab) For Invoices: Do a Find where the Account matches AR and Value has Debits ≥ 0.00 For Bills: Do a Find where the Account matches AP and Value has Credits ≥ 0.00 *For Credit Notes for each of AR/AP, change to Value has Debits/Credits ≤ 0.00

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

2021-12-29 Thread Adrien Monteleone
Yes, and the CSV schema is covered in the documentation. So one can use an outside app to generate a Quote/Proforma and then import the final invoice data to GnuCash for accounting purposes. Regards, Adrien On 12/29/21 7:24 AM, Maf. King wrote: just a thought. Create the Quote outside GC,

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

2021-12-29 Thread Adrien Monteleone
On 12/29/21 7:00 AM, Dr. David Kirkby wrote: On Wed, 29 Dec 2021 at 03:41, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: I thought the document number was assigned on creation, but I'd have to verify. (you can't delete an invoice for example, and you'd have to change the

Re: [GNC] access to backup Reports

2021-12-28 Thread Adrien Monteleone
Please don't repost questions in new threads. You received a reply the last time, but I don't see that you answered the question asked of you. I'm not sure what you mean by "not being able to access spreadsheets after upgrade, had to downgrade for that to work." What does accessing

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

2021-12-28 Thread Adrien Monteleone
I thought the document number was assigned on creation, but I'd have to verify. (you can't delete an invoice for example, and you'd have to change the number to something like 'use next' if you made an error creating it) Of course, that would mean you get the same number for the invoice as

Re: [GNC] Job Expenses? Job Profit Reports?

2021-12-28 Thread Adrien Monteleone
Me, sorry. I took a break for some time, and decided to look over some threads that didn't get answers and see if I could help. A few other threads looked interesting and where I thought I could add to the discussion, decided to chime in. I happen to be all done now! (There are a few

Re: [GNC] Description from Bill/Invoice not Posting on General Ledger Memo Field (GNU Cash V4.5)

2021-12-28 Thread Adrien Monteleone
By 'Descriptions' I'm guessing you mean the descriptions for the individual line items. (there is no generic 'description' field for a bill/invoice) The only way to see that is to uncheck the 'accumulate splits' box when posting. (alternatively, under Preferences > Business > General >

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

2021-12-28 Thread Adrien Monteleone
You might find luck playing with the Custom CSS stylesheet. Also, you can create/duplicate your own stylesheets and use one for invoices and one for quotations. Regards, Adrien On 12/28/21 6:40 PM, Dr. David Kirkby wrote: Next I will need to sort out how to alter the report. I can see this

Re: [GNC] Looking for an easy way to share Custom Reports (Windows 10) among users

2021-12-28 Thread Adrien Monteleone
I see you didn't get a reply on this so I'll hazard a suggestion... There is a thread from April '21 about upgrading from 2.6.21 to 4.x. This one in particular though also was about migrating computers. In that thread, Geert offered a detailed method for making sure your preferences and

Re: [GNC] Changing the order of splits

2021-12-28 Thread Adrien Monteleone
This might be overkill, but it might work too: You could create an 'Invoice' and list the players/teams as line items. (the 'Customer' here can just be 'Players' or some such and probably doesn't matter) In an invoice you *can* reorder the line items to suit your needs. (it can be

Re: [GNC] Simple Update Question

2021-12-28 Thread Adrien Monteleone
If I recall correctly, the official policy is to support: 1. The last major GnuCash release, 2. On the oldest officially supported OS release. This doesn't mean older versions won't work, (some people are still in 2.6.x land!) or that newer versions won't necessarily work on older OS

Re: [GNC] budget report and scrolling

2021-12-28 Thread Adrien Monteleone
Not sure about LibreOffice, but for those on MacOS, Numbers.app lets you define 'groups' that you can expand and collapse with a click. You could then define each of your periods as a group, then expand/collapse to show/hide the Actual/Budget/Diff columns for each. Regards, Adrien On 8/6/21

Re: [GNC] Income statement report change

2021-12-28 Thread Adrien Monteleone
I'll hazard the suggestion to examine the main loop that spits out the account names and either prepend or append code that does: "if my special option is true, then lookup and output *this* data." You may have to rename the account name variable and concatenate the two under the original

Re: [GNC] Recurring Monthly bills, How to Auto Post... TFN ?

2021-12-28 Thread Adrien Monteleone
In addition to the other suggestions, there is a Duplicate Bill/Invoice button. Then make your edits before posting. Regards, Adrien On 8/13/21 1:23 PM, Fran_3 via gnucash-user wrote: Like many we have a number of regular monthly bills. Is there a way to have these bills "auto posted" each

Re: [GNC] Can't get to GnuCash windows and menus

2021-12-28 Thread Adrien Monteleone
Did you solve this? It sounds like you might be running GnuCash from inside the DMG. Be sure to copy the GnuCash.app from the DMG window to your Applications folder via Finder. (that is, open another Finder window set to Applications and then drag & drop the icon from the DMG to the

Re: [GNC] Printing invoices and statements, Spanish language version stylesheets

2021-12-28 Thread Adrien Monteleone
Sounds like a Webkit problem with reports where I believe the workaround is to save the report, open it in a web browser and print from there - and 'poof', no blank page. I could be conflating bugs, but it won't hurt to give it a try. Regards, Adrien On 8/25/21 11:40 AM, rmom...@gmail.com

Re: [GNC] Search/report by description

2021-12-28 Thread Adrien Monteleone
Technically you can, *if* you don't 'accumulate splits' when posting. Then those line items will show up in all affected registers and you can use the Transaction Report's filtering options to get what you want. (or do a Find and then an Account Report) I wouldn't recommend un-posting and

Re: [GNC] Job Expenses? Job Profit Reports?

2021-12-28 Thread Adrien Monteleone
The short answer is, "you can't." 'Jobs' aren't quite what the name implies. Rather, think 'Purchase Order'. There are various use cases the 'Jobs' feature does not work for: Multiple Customers (and even split with stock orders) for the same Job. Yeah, I know this sounds weird, but if a Job

Re: [GNC] Scheduled Transaction Posting Order

2021-12-28 Thread Adrien Monteleone
There was a bug some time ago that was fixed for this with regular manual transactions, perhaps file another for Scheduled Transactions? (not certain why it would matter, but apparently it does) Deposits should I think in most, if not all, cases post before withdrawals. I've never found a

Re: [GNC] Billing Terms Editor not "sticky"

2021-12-28 Thread Adrien Monteleone
I've been using this feature since long before 3.8 and it has always worked. Be certain the *Customer/Vendor* has a defined term. The 'Billing Terms' dialog is to create a 'list of terms'. You then have to assign a term *from that list* to each and every Customer/Vendor if you want a

Re: [GNC] Invoicing

2021-12-28 Thread Adrien Monteleone
If I understand what you are trying to do, you can't directly. 1. Create another income/revenue account. (if using the tax features, don't link it to anything) 2. Invoice the members with the line-item assigned to this other account. 3. After receiving payment create a transaction moving

Re: [GNC] Count Transactions

2021-12-28 Thread Adrien Monteleone
A similar approach could be by filtering and then using Export > Export Active Register to CSV. Open that CSV in a spreadsheet. Last Row # - 1 = transaction count. (-1 for the header row) This way you don't have possible label rows or individual splits to subtract also which may be the case

Re: [GNC] editing memorized transactions

2021-12-28 Thread Adrien Monteleone
GnuCash also has a 'Due Reminders' feature but you need to enter Bills/Invoices using the Business Features to see it and take advantage of it. (as distinct from Scheduled Transactions) Regards, Adrien On 10/29/21 1:59 PM, p...@kroitor.ca wrote: Both GnuCash and Quicken have the Scheduled

Re: [GNC] difficulties with managing accounts with lots of split transactions

2021-12-28 Thread Adrien Monteleone
Personally I use #2 as Transaction Journal & Double Line mode 24/7. The always visible detail doesn't bother me and I generally like to have it instantly available without having to change modes, but I understand mileage varies. Regards, Adrien On 11/7/21 6:08 AM, Platon Pronko wrote: Hi!

Re: [GNC] MEMORIZING PAYEE ADDRESS

2021-12-28 Thread Adrien Monteleone
What is your process? I first select the transaction, then go to File > Print Checks, and everything is filled out for me. Also, what OS/version are you using? Regards, Adrien On 11/10/21 12:22 PM, men...@fastmail.fm wrote: Hi I print checks occassionally using GnuCash. I find that the

Re: [GNC] Has bugs-admin been hacked? Re: [Bug 797953] RFE: provide access to filter-by on right-mouse-click in Accounts register

2021-12-28 Thread Adrien Monteleone
I think the idea was to remove it from the archives since it was link spam. Certainly, anyone who received the message has it in their own e-mail storage. But clearly, that is your call if you think it worth the trouble or not. Regards, Adrien On 12/28/21 3:48 PM, Liz Dodd wrote: No, it's

Re: [GNC] How can I fudge a quotation in GnuCash and convert it to invoice if accepted?

2021-12-28 Thread Adrien Monteleone
That's the way to do it, but if you are getting no content, then you might not be opening the correct invoice. (or not actually opening any invoice) How are you (in detail) 'retrieving the invoice'? Regards, Adrien On 12/28/21 4:00 PM, Dr. David Kirkby wrote: I think there are some fudges

Re: [GNC] GNUCash & Macros

2021-12-28 Thread Adrien Monteleone
Check this out: https://lists.gnucash.org/pipermail/gnucash-user/2017-February/069016.html Not sure if it is still available or works on your OS. Regards, Adrien On 5/26/21 9:52 AM, Jack Frillman via gnucash-user wrote: Does GNUCash have a macro feature? I searched the documentation and I

Re: [GNC] Has bugs-admin been hacked? Re: [Bug 797953] RFE: provide access to filter-by on right-mouse-click in Accounts register

2021-12-28 Thread Adrien Monteleone
On 11/5/21 12:37 PM, Michael Hendry wrote: I take it there’s no way I can delete the post I sent which includes all those unwanted URLs? No but Liz probably can. Regards, Adrien ___ gnucash-user mailing list gnucash-user@gnucash.org To update

Re: [GNC] How to copy open budget to spreadsheet

2021-12-28 Thread Adrien Monteleone
Not sure if you solved this but I see no one has replied. Run a Budget Report. (best to exclude the Actuals and Diff columns) Then copy/paste or save/open the resulting report in your favorite spreadsheet app. Regards, Adrien On 4/17/21 9:32 AM, Morris Beavers wrote: Hello GNUCash, My

Re: [GNC] Real Estate property-segregated costs tracking

2021-12-27 Thread Adrien Monteleone
This question applies to various business models where you need to track revenue and expenses by 'entity' or 'project'. GnuCash does not have an analogy to 'classes' as an extra dimension for reporting or tracking purposes. There are various alternatives: 1. Use a spreadsheet or alternative

Re: [GNC] Exporting Data

2021-12-27 Thread Adrien Monteleone
First: File > Export > Export Account Tree in CSV is what you were looking for. Second: if you have a backup as of 12/31/20 then make it your current file and start 2021 over again. I've never had to do this, so not sure if the reconcile column flag is in the transaction CSV, but I suspect

Re: [GNC] Correcting reconciles

2021-12-27 Thread Adrien Monteleone
On 12/27/21 6:07 PM, David Carlson wrote: One more issue that I rarely see mentioned in these discussions about reconciliation problems is that there are some cases where attempting to correct an error in one account of a transaction can unreconcile a different account in that same transaction.

Re: [GNC] Correcting reconciles

2021-12-27 Thread Adrien Monteleone
On 12/27/21 9:54 AM, Mahon Finbar wrote: Thanks all, "Un-reconciling doesn't delete anything. I'm not sure what you are describing there" - I am describing an obvious error, such as an entry in the wrong a/c, it happens. Unreconciling shouldn't be expected to delete a transaction. You can

Re: [GNC] Correcting reconciles

2021-12-27 Thread Adrien Monteleone
Uncheck: Preferences > Register > Reconciling > 'Check Cleared Transactions' I have this turned on, because if I've 'cleared' them in the register, I already know they are correct and reported by the institution. Thus I'd only have non-cleared transactions left to reconcile, saving me time.

Re: [GNC] Editing a Budget - "from this period onwards"

2021-12-27 Thread Adrien Monteleone
There is the function to edit 'all periods' for a particular account at a time. (on the toolbar, and in the Edit menu) Of course this isn't just 'to the right' but for all periods in the budget. There is not an easy way I can see to copy an entire period to others. And of course there is the

Re: [GNC] Editing a Budget - "from this period onwards"

2021-12-26 Thread Adrien Monteleone
You can simply tab over and do copy/paste, but otherwise, not that I'm aware of. Regards, Adrien On 12/26/21 9:43 AM, Graham Ward wrote: You can edit a budget by changing the individual values by period, but is there a way to edit all future periods from say period 3 - 12 rather than having

Re: [GNC] Changing the amount of data displayed

2021-12-26 Thread Adrien Monteleone
I just tested and Save Filter works as of 4.7 for sure, mileage may vary on earlier releases. Regards, Adrien On 12/26/21 9:55 AM, Stan Brown wrote: On 2021-12-25 12:13, Adrien Monteleone wrote: There is also Tools > General Journal, which shows transactions from all accounts but o

Re: [GNC] Changing the amount of data displayed

2021-12-25 Thread Adrien Monteleone
Unfortunately I don't think so, but there are 2 other options: There is Preferences > Register Defaults which sets a hard limit by number of transactions, but I can't see how that is as useful as applying a filter across the board. While filters have an indicator in each register (top right

Re: [GNC] Another Beginner Accounting Question

2021-12-24 Thread Adrien Monteleone
Like Michael, I'm not quite certain what you have going on here. It sounds like a consignment type operation. I too don't think you need to consider the difference as a 'loss' or 'expense'. It is their margin, not yours. But perhaps I am not understanding your situation properly. As for

Re: [GNC] Correcting reconciles

2021-12-24 Thread Adrien Monteleone
There's no shortcut to finding out why you are out of balance. There are 'math tricks' however to guide you. For example, if the unbalanced amount ends with a '9' there is a decent probability you transposed digits somewhere. Un-reconciling doesn't delete anything. I'm not sure what you are

Re: [GNC] Windows11 compatibility?

2021-12-19 Thread Adrien Monteleone
Would this be similar to the problem described in Bug 797502 that was just fixed in 4.9? https://bugs.gnucash.org/show_bug.cgi?id=797502 Regards, Adrien On 12/19/21 11:52 AM, ckozlov carykozlov.com wrote: Thanks everyone for your responses! I have a Windows 10 machine, and I'm feeling more

Re: [GNC] [GNC-dev] GnuCash 4.9 Released

2021-12-19 Thread Adrien Monteleone
The Github links work though just fine. No need to wait. Regards, Adrien On 12/19/21 5:06 PM, py...@cox.net wrote: Getting the same for Windows. No links for 4.9 -- still shows 4.8 Maybe it's a timing thing -- will try later this afternoon ___

Re: [GNC] Beginner Accounting Question Using GnuCash

2021-12-19 Thread Adrien Monteleone
Perhaps try the Account Report? Open the 'Stock on Hand' account, then Reports > Account Report. You can also try the Transaction Report and choose to report just on your inventory account(s). Regards, Adrien On 12/17/21 5:19 AM, Patrick Skelton wrote: Hi, I am trying to get my head

Re: [GNC] Colored account tabs in 4.8 don't show current selection

2021-12-13 Thread Adrien Monteleone
That is likely the highlight color of the base theme. Regards, Adrien On 12/13/21 2:40 PM, AC wrote: That was it.  I added padding-right: 5px; to the tabs and the blue bar is now visible. I'm not sure how to change that bar's color since I'd like to do something that stands out mroe against

Re: [GNC] any way to make a report of assets?

2021-12-13 Thread Adrien Monteleone
So each asset doesn't have its own account? (that would be much easier) Otherwise, some reports allow REGEX filters where you can use your own custom 'tags' and then report accordingly. But I've only done that with specific individual tags, not many tags. If the assets are aggregated in

Re: [GNC] Does anyone produce a "UK balance sheet" (FRS 102) ?

2021-12-13 Thread Adrien Monteleone
I certainly did not mean to suggest something for the devs to have to maintain. This would strictly be a community project, and you'd have to add those reports yourself, they should not be included in a default install. This may already exist, but I haven't gone searching, or heard any

Re: [GNC] Trouble creating this report

2021-12-13 Thread Adrien Monteleone
You want Reports>Experimental>Income Statement (multicolumn) On the Options>General tab, set the Period Duration to 'One Month' and on the Accounts tab, deselect all but the Expense accounts. You can also add a Total column via "If more than 1 period column, include overall period?" on the

Re: [GNC] Colored account tabs in 4.8 don't show current selection

2021-12-13 Thread Adrien Monteleone
Your CSS might be at play. I'm using 4.8 and I have some tabs colored. They show the blue line just like the non-colored tabs. However, I have some padding/margin around these colors, so it looks more like a high-lighter effect. (the base color of the tab is still visible around the custom

Re: [GNC] How to fix zero-length register column?

2021-12-12 Thread Adrien Monteleone
I could be mistaken, but I'm fairly certain you don't have to 'stumble' on that 'trick' or any other as it is a designed feature. It should be documented in Help or the Guide. There is a section devoted to resizing columns. There was some work done on setting widths for all 'similar'

Re: [GNC] Can I add a customer and/or vendor to a previously entered transaction?

2021-12-12 Thread Adrien Monteleone
If you don't want to enter the entire actual Bill/Invoice/Payment history for a Customer/Vendor, then simply enter a Bill/Invoice as needed for any remaining/current amount as of the start date of your book with a line item description such as 'balance forward'. (and maybe a reference note on

Re: [GNC] Can I add a customer and/or vendor to a previously entered transaction?

2021-12-12 Thread Adrien Monteleone
As noted in other replies, you can assign payments to bills/invoices after the fact if you didn't use the 'Business Features' UI to record them, however, there is no similar feature to turn regular transactions in to Bills/Invoices. You'd have to create those normally, then delete the manual

Re: [GNC] Does anyone produce a "UK balance sheet" (FRS 102) ?

2021-12-12 Thread Adrien Monteleone
I think you can get pretty far with a careful organization of your Chart of Accounts, *and* careful selection of accounts to include in the stock Balance Sheet report. Where you find the stock report doesn't work as expected/desired after those customizations, then you can certainly craft

<    9   10   11   12   13   14   15   16   17   18   >