Re: [GNC] [gnc] Forecasting savings

2024-05-22 Thread Adrien Monteleone
There is a budget module. Otherwise, you can use scheduled transactions, or just enter transactions in advance and run relevant reports. As the real-world transactions happen, edit those already entered to reflect any differences. If you want to preserve the prediction vs. actual, you might

Re: [GNC] Can't download stock prices

2024-05-21 Thread John Ralls
Ernie, You probably built it for the wrong architecture. GnuCash is x86_64 so all of the perl modules that aren’t pure perl need to be multi-architecture. See https://wiki.gnucash.org/wiki/Online_Quotes#Installing_Finance::Quote_on_macOS_from_a_Terminal_prompt for an explanation. Regards,

Re: [GNC] Can't download stock prices

2024-05-21 Thread Ernie Wakamatsu
HI John and Gnucash Supporters, I was afraid you were going to say that. As far as I can tell, I have JSON::Parse installed, but gnucash-cli is not finding it. Ernie-Mac-mini% cpan JSON::Parse Loading internal logger. Log::Log4perl recommended for better logging Reading

Re: [GNC] Can't download stock prices

2024-05-21 Thread John Ralls
Depends on the bug. Just like every other development team they have more bugs than engineers so they have to prioritize. Some things get fixed quickly, others take a while, and some never get attention. I don’t know who maintains the libc that Apple uses. If it’s FreeBSD then they won’t

Re: [GNC] Can't download stock prices

2024-05-20 Thread David Reiser via gnucash-user
> On May 20, 2024, at 21:07, Ernie Wakamatsu wrote: > > Very strange. I get two results. > > First, following your instructions, by coping and pasting > Ernie@Ernie-Mac-mini contents % zsh -df > Ernie-Mac-mini% /Applications/Gnucash.app/Contents/MacOS/gnucash-cli -Q info > Application Path

Re: [GNC] Can't download stock prices

2024-05-20 Thread Ernie Wakamatsu
One could hope Apple will fix bugs in a timely manner :-p. So what should I do to workaround this bug or am I hosed? Ernie > On 21 May 2024, at 1:21 PM, John Ralls wrote: > > Hah! I didn’t even notice that. It’s pretty funny. > > The *file system* is by default case-preserving, meaning

Re: [GNC] Easier way to print to PDF

2024-05-20 Thread Adrien Monteleone
PDFs that are images are almost always scans of physical paper without an OCR step. Though, I'm sure some 'printers' take the image route rather than create a proper PDF. (Portable Document Format) Regards, Adrien On 5/20/24 7:43 PM, David G. Pickett via gnucash-user wrote: PDF pitfall: some

Re: [GNC] Can't download stock prices

2024-05-20 Thread John Ralls
Hah! I didn’t even notice that. It’s pretty funny. The *file system* is by default case-preserving, meaning that you can create either macOS or MacOS but not both; preserving means that it will keep whichever one you create first. The shell is too, though Bash completion is case-sensitive.

Re: [GNC] Can't download stock prices

2024-05-20 Thread Ernie Wakamatsu
Very strange. I get two results. First, following your instructions, by coping and pasting Ernie@Ernie-Mac-mini contents % zsh -df Ernie-Mac-mini% /Applications/Gnucash.app/Contents/MacOS/gnucash-cli -Q info Application Path /Applications/Gnucash.app/Contents/MacOS/gnucash-cli Failed to

Re: [GNC] Easier way to print to PDF

2024-05-20 Thread David G. Pickett via gnucash-user
PDF pitfall: some apps print a graphical file, which cannot be searched, and some print text with annotations to set position and font size, name, bold, italic, underlined, which can be searched.  You can even find apps to convert the first to the second!  My presbytery sends out the first,

Re: [GNC] Easier way to print to PDF

2024-05-20 Thread Adrien Monteleone
Does this answer your question?:https://askubuntu.com/questions/1263902/how-to-quickly-modify-cups-pdf-printer-output-folder-setting If not, you can set bookmarks to other locations in that file dialog. While this won't change the default, it would just be one extra click on the bookmarked

Re: [GNC] Easier way to print to PDF

2024-05-20 Thread Mark at Lorimark
Keep two Folder explorers open, one where it prints to, and one where you want to move the file to. Once it's printed, drag the file to the preferred location. Yea, I don't like it either. ~mark petryk ~w:http://www.lorimarksolutions.com On 5/19/24 18:33, Daffy Duck wrote: Linux.  The

Re: [GNC] Easier way to print to PDF

2024-05-20 Thread Daffy Duck
Linux.  The issue is, every time I try to print to PDF, it starts at home directory, which takes forever to get back to where I was printing to.   On Sun, 2024-05-19 at 19:29 -0400, Joseph Keithley wrote: > If you are on a Windows machine you can use the Windows built-in PDF > printer driver

Re: [GNC] Can't download stock prices

2024-05-20 Thread John Ralls
Ernie, The double slash is present in my output too, and it’s harmless. That shows that the app bundle is complete and uncorrupted. Something is getting in the way of dlopen finding those two libraries. Try getting a purely default shell environment by running zsh -df That opens a new sub

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Joseph Keithley
Only because I don't have any keyboard shortcuts memorized except ctrl-c and ctrl-v. On Sun, May 19, 2024 at 11:25 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Any reason not to use CTRL+A? > > Regards, > Adrien > > On 5/19/24 9:08 PM, Joseph Keithley wrote: > > If the whole

Re: [GNC] Can't download stock prices

2024-05-19 Thread Ernie Wakamatsu
Thanks John, I ran the below commands and this is what I got. Ernie@Ernie-Mac-mini contents % spctl --assess -vv /applications/gnucash.app /applications/gnucash.app: accepted source=Notarized Developer ID origin=Developer ID Application: John D Ralls (Y9EHT5WMK7) Ernie@Ernie-Mac-mini contents %

Re: [GNC] Easier way to print to PDF

2024-05-19 Thread Stan Brown (using GC 4.14)
On 2024-05-19 16:29, Joseph Keithley wrote: > If you are on a Windows machine you can use the Windows built-in PDF > printer driver (Settings > Devices > Printers > Add Printer - "Microsoft > Print to PDF"). Caution! Microsoft Print to PDF makes huge, bloated PDF files. A one-page simple

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Stan Brown (using GC 4.14)
Open the report in Excel and _then_ do your copy and pasting. (You probably want Edit » Paste Special » Values, keyboard Alt+E, S, V.) Stan Brown Tehachapi, CA, USA https://BrownMath.com On 2024-05-19 17:35, David Long wrote: > Hi > I mean copy paste from a gnucash report. > Rgds > David > >

Re: [GNC] Can't download stock prices

2024-05-19 Thread John Ralls
> On May 19, 2024, at 18:03, Ernie Wakamatsu wrote: > > Hi, > > First time user of this mailing list and just starting to use gnucash. Been > transferring information over from Quicken and I am getting things close to > the way I would like. > > I am trying to download stock prices, but

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Adrien Monteleone
Any reason not to use CTRL+A? Regards, Adrien On 5/19/24 9:08 PM, Joseph Keithley wrote: If the whole left-click hold copy and drag doesn't work well, there is an alternate method. When you move the mouse cursor to the top left of the tab, move the cursor slowly to the right until the mouse

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Joseph Keithley
If the whole left-click hold copy and drag doesn't work well, there is an alternate method. When you move the mouse cursor to the top left of the tab, move the cursor slowly to the right until the mouse cursor changes from an arrow to a line (assuming your PC set up is similar to mine) and

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Joseph Keithley
Understood. I can tell you what I do with copy/pasting a paticular report. I've never had a problem with double quotes. In my case, I copy/paste the "Investment Portfolio" report under "Assets and Liabilities" to Excel. When the tab opens with the report, I put the mouse cursor on the top left

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread David Long
Hi I mean copy paste from a gnucash report. Rgds David On Mon, 20 May 2024, 04:13 Joseph Keithley, wrote: > Not sure what you mean by "copy". In the Windows version of GnuCash 5.5 > you can export your accounts to a csv file. You pick the account, the date > range, and the separator

Re: [GNC] Easier way to print to PDF

2024-05-19 Thread Joseph Keithley
If you are on a Windows machine you can use the Windows built-in PDF printer driver (Settings > Devices > Printers > Add Printer - "Microsoft Print to PDF"). Alternatively, you can export the report (shows up as an .html) and open it with Microsoft Edge and save it as a PDF. On Sun, May 19,

Re: [GNC] Delete a trading account => crash

2024-05-19 Thread Fred Tydeman
Enter, that got me a popup to adjust the number of shares. Press Enter and all was fixed. Doing that was a lot easier than deleting and re-entering the transactions. When I was done, one stock asset account and one trading account were both empty, so could be deleted. I also deleted the wrong

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Joseph Keithley
Not sure what you mean by "copy". In the Windows version of GnuCash 5.5 you can export your accounts to a csv file. You pick the account, the date range, and the separator (usually a comma). There is also an option to either add double quotes or not. On Sun, May 19, 2024 at 12:41 PM David Long

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread sunfish62--- via gnucash-user
And if your currency is using character strings ("USD", "CHF", etc.), you can customize the currency designator so that Excel can process them. ⁣David T. ​ On May 19, 2024, 8:50 PM, at 8:50 PM, "Stan Brown (using GC 4.14)" wrote: >On 2024-05-19 09:39, David Long wrote: >> When I copy data

Re: [GNC] Saved Reports accross several PCs

2024-05-19 Thread Stan Brown (using GC 4.14)
On 2024-05-19 09:35, David Long wrote: > I am running gnucash on more than one PCs. When I create report on one PC I > find I have create that report on other PC even though they are both > pulling in data from the same file. Is there anything I can do to not have > recreate these reports?. Sure

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Stan Brown (using GC 4.14)
On 2024-05-19 09:39, David Long wrote: > When I copy data from Gnucash to Excel it arrives on text format along with > the currency denomination, so I cannot then manipulate it in Excel. > Is there anyway I can export data to Excel in data format?. > Thanks > David Hi, David! Which "data" are

Re: [GNC] All Reports Crashing Version 5.6-1

2024-05-19 Thread John Ralls
> On May 19, 2024, at 01:05, Rodney Harrex via gnucash-user > wrote: > > Running any report will crash GnuCash. In > C:\Users\Rodney\AppData\Local\Temp. Any of the reports selected will appear > as HTML file along with a file like > > gnucash.trace.ITONN2.log with the content: 17:31:13

Re: [GNC] Delete a trading account => crash

2024-05-19 Thread John Ralls
> On May 18, 2024, at 22:04, Fred Tydeman wrote: > > Running GnuCash 4.14 on Fedora Linux. > > Due to a mistake on my part, I have two Trading accounts: > IVR-PC > IVRPRC > for the same security. > > First, I tried changing Trading:IVRPRC to Trading:IVR-PC in a Sell or Buy > transaction

Re: [GNC] Delete a trading account => crash

2024-05-19 Thread Kalpesh Patel
That is the behavior, sadly, where it goes back to what the original transaction was. It is undesired but it is there and not likely to be fixed.. (I run into it when I want to duplicate the transaction and then just update the quantity) To get around, you technically have to enter the entire

Re: [GNC] Accounts page error

2024-05-19 Thread Ken Farley
I have seen "overnight" massive gains when there's been a stock split I wasn't aware of, a 10 to 1 reverse split, or something like that. Usually it is the opposite effect of what you are seeing, where suddenly I'm down a lot of net worth. The only other thing I can think of is that maybe one

Re: [GNC] Transferring Gnu Cash Data to New Computer

2024-05-17 Thread John Ralls
> On May 17, 2024, at 3:00 PM, R Losey wrote: > > On Fri, May 17, 2024 at 12:27 PM Stan Brown (using GC 4.14) < > stan...@fastmail.fm> wrote: > >> On 2024-05-17 07:44, R Losey wrote: >>> I hope you know where that file is stored. One >>> way to find it is to open the old GnuCash and then

Re: [GNC] Transferring Gnu Cash Data to New Computer

2024-05-17 Thread R Losey
On Fri, May 17, 2024 at 12:27 PM Stan Brown (using GC 4.14) < stan...@fastmail.fm> wrote: > On 2024-05-17 07:44, R Losey wrote: > > I hope you know where that file is stored. One > > way to find it is to open the old GnuCash and then under File, choose > "Save > > As" - it will open in the same

Re: [GNC] Transferring Gnu Cash Data to New Computer

2024-05-17 Thread Jim DeLaHunt
Gary: On 2024-05-15 18:07, Gary Slade wrote: I need to transfer Gnu Cash data from my old Mac to my new Mac. How do I locate the data? Regards, Gary Slade Pioneer, CA In addition to the other answers, check out this entry in the GnuCash FAQ: "Q: I just got a new computer. What should I

Re: [GNC] Transferring Gnu Cash Data to New Computer

2024-05-17 Thread Stan Brown (using GC 4.14)
On 2024-05-17 07:44, R Losey wrote: > I hope you know where that file is stored. One > way to find it is to open the old GnuCash and then under File, choose "Save > As" - it will open in the same directory as your current file is stored. While that will work, I think it's easier just to click

Re: [GNC] Continued blank reports from within gnucash, printed version looks fine

2024-05-17 Thread Charlie Morrison
Quoting a previous message from John Ralls may be of value to resolve this issue: On 12/14/23 10:58, john wrote: It won't be fixed in the next release because it's not something that GnuCash can fix. As you say, the work around is to stop WebKit using the GPU with

Re: [GNC] Continued blank reports from within gnucash, printed version looks fine

2024-05-17 Thread Alex Aycinena
arcoux > To: Daffy Duck > Cc: Gnucash Users > Bcc: > Date: Fri, 17 May 2024 07:45:25 -0400 > Subject: Re: [GNC] Continued blank reports from within gnucash, printed > version looks fine > I experienced the same blank report running Linux Mint 21.3 after an update > introduced a

Re: [GNC] Transferring Gnu Cash Data to New Computer

2024-05-17 Thread R Losey
On Fri, May 17, 2024 at 6:21 AM Gary Slade wrote: > I need to transfer Gnu Cash data from my old Mac to my new Mac. How do I > locate the data? > > Regards, > > Gary Slade > Pioneer, CA > > Gary - the financial transactions are kept in one file; generally called .gnucash. Where this is stored is

Re: [GNC] Transferring Gnu Cash Data to New Computer

2024-05-17 Thread Michael or Penny Novack
On 5/15/2024 9:07 PM, Gary Slade wrote: I need to transfer Gnu Cash data from my old Mac to my new Mac. How do I locate the data? Regards, Gary Slade Pioneer, CA I need to transfer a data file, a data directory, all of my user data, to a new machine << in other words, not really a gnucash

Re: [GNC] Continued blank reports from within gnucash, printed version looks fine

2024-05-17 Thread Pierre Marcoux
I experienced the same blank report running Linux Mint 21.3 after an update introduced after April 26. I restored my system using Timeshift with a snapshot of April 26 and the reports are no longer blank. Will wait for a fix before updating again. I I have GNUCASH version 5.6 Build ID Flathub

Re: [GNC] Unable to Refine Existing Search

2024-05-17 Thread Derek Atkins
AND > BEFORE-dd/yy/mm AND CONTAINS-STRING-[tag]*. Then what I'd want to do it > run > the search again with the same date constraints but a different tag. So, > it > appears your answer means I will simply have to re-enter the date range > every time. Correct, you cannot change t

Re: [GNC] Unable to Refine Existing Search

2024-05-17 Thread Patrick Skelton
again with the same date constraints but a different tag. So, it appears your answer means I will simply have to re-enter the date range every time. I am an absolute amateur when it comes to accounts, but it does seem to me that the GnuCash could be improved in this area. Tags would be great, as would

Re: [GNC] Finance-Quote 1.62 released!

2024-05-16 Thread Bruce Schuck
On Thu May 16 22:22:53 EDT 2024, Adrien Monteleone wrote: Coding can be fun in many cases, but you seem to find solace in the mindbogglingly headache-inducing game of whack-a-mole, to everyone else's benefit! heh-heh. Sometimes it does seem like playing whack-a-mole. Thank you for the

Re: [GNC] Finance-Quote 1.62 released!

2024-05-16 Thread Adrien Monteleone
Bruce, et al, Coding can be fun in many cases, but you seem to find solace in the mindbogglingly headache-inducing game of whack-a-mole, to everyone else's benefit! Thank you for the insane amount of effort you put forth on this project. I have yet to use (or profit) from all of it, but

Re: [GNC] Simultaneous access

2024-05-16 Thread Michael or Penny Novack
On 5/16/2024 2:17 PM, David G. Pickett via gnucash-user wrote: Yes, if gnucash was running as a remote service, it might be able to deal with multiple users.  Imagine that gnucash becomes a web service and the user interface is a relatively simple web page.  Even in this scenario, you would

Re: [GNC] Simultaneous access

2024-05-16 Thread David G. Pickett via gnucash-user
Yes, if gnucash was running as a remote service, it might be able to deal with multiple users.  Imagine that gnucash becomes a web service and the user interface is a relatively simple web page.  Even in this scenario, you would need to avoid processing too much in JavaScript and local files

Re: [GNC] Use of cash discounts in business account tree

2024-05-16 Thread Adrien Monteleone
I am no accountant, but that doesn't sound quite correct. If you put the Cash Discounts account under Expenses, then that would be a contra-account as it reduces the price of your expenses you pay the wholesaler. So that credit is correct, but I don't see that there should be a debit to your

Re: [GNC] Importing bank data, sending instructions.

2024-05-15 Thread David Reiser via gnucash-user
> On May 15, 2024, at 17:58, Chris Miller wrote: > > Hi Folks, > > GnuCash will import bank data in OFX format. OFX imports advise me of > activity that originates with the bank, so I can "sync" my books with the > bank. So far; so good. > > Wells Fargo produces an OFX import file with

Re: [GNC] Simultaneous access

2024-05-15 Thread Ken Farley
No. Using an SQL database just means you are deciding where you are going to save your data. The way the program works is that it loads your data file into memory and any changes you make are done in memory. Data is not saved anywhere until you specifically write it to wherever you store it.

Re: [GNC] Simultaneous access

2024-05-15 Thread Derek Atkins
Hi, On Wed, May 15, 2024 7:14 pm, Chris Miller wrote: > The application gnucash does NOT support multiple simultaneous > access. > That would require a DBM (database manager) > >Apparently there are a variety of DBM "back-ends". If I configure >Postgress, for example, do I

Re: [GNC] Simultaneous access

2024-05-15 Thread Chris Miller
The application gnucash does NOT support multiple simultaneous access. That would require a DBM (database manager) Apparently there are a variety of DBM "back-ends". If I configure Postgress, for example, do I get simultaneous access? Thanks for the help, Chris.

Re: [GNC] Use of cash discounts in business account tree

2024-05-15 Thread Michael or Penny Novack
Thank you Michael. I was unsure of how to use this in a double entry account. WHen I get a discount from a wholesaler, then there is a credit to Cash discounts, which is an expense. There is also a corresponding debit to my checking account. When I issue a site wide discount there is a debit to

Re: [GNC] Simultaneous access

2024-05-15 Thread Michael or Penny Novack
On 5/15/2024 6:02 PM, Chris Miller wrote: Hi Folks, Can I store my GnuCash "books" on a server, or a NAS, and do my bookkeeping from any of my machines, meaning my windows desktop or my Linux development station? Can I do this simultaneously? The application gnucash supports multiple

Re: [GNC] Use of cash discounts in business account tree

2024-05-15 Thread nisp1953
On Tue, May 14, 2024 at 10:10 PM Michael or Penny Novack wrote: > The wizard is only a starting point giving an example of TYPICAL > accounts. There is no guarantee tat the set of accounts would =meet the > needs of YOUR business. If your business never offered cash discounts, > then your

Re: [GNC] Simultaneous access

2024-05-15 Thread Geoff
Hi Chris > Can I store my GnuCash "books" on a server, or a NAS, and do > my bookkeeping from any of my machines, meaning my windows desktop or > my Linux development station? Yes - provided you have the GnuCash software (preferably the same version) installed on each of those client

Re: [GNC] Unable to Refine Existing Search

2024-05-15 Thread Derek Atkins
David, On Wed, May 15, 2024 12:07 pm, David Carlson wrote: > I vaguely recall asking for an enhancement a few years ago to show the > search criteria along with the results but I have forgotten whether that > was in Bugzilla or in that other place which I now cannot even remember > the > name of.

Re: [GNC] Unable to Refine Existing Search

2024-05-15 Thread David Carlson
r perhaps even > save a set of criteria so they can be re-run. > > I realise what I am really wanting here is a custom report but I need it to > contain only records containing a certain string and I can't see how to get > the reporting to do this. > > Kind wishes - Patrick >

Re: [GNC] Unable to Refine Existing Search

2024-05-15 Thread Adrien Monteleone
The Transaction Report has a Filter option that takes simple text as well as a Regular Expression. Regards, Adrien On 5/14/24 2:24 AM, Patrick Skelton wrote: I realise what I am really wanting here is a custom report but I need it to contain only records containing a certain string and I

Re: [GNC] How to transfer customer and vendor information from a previous GNUCash file?

2024-05-15 Thread Adrien Monteleone
Please remember to hit reply-all or reply-list so others can participate and benefit from the discussion. - While you can't delete an Invoice/Bill, you can reuse them. When I end up in such a situation, I change the document ID to "Use Next" so I can find it easily, and then simply edit

Re: [GNC] Unable to Refine Existing Search

2024-05-15 Thread Derek Atkins
iteria again. No, the initial criteria are still there -- just inaccessible. You're just appending to them with an additional AND statement (refine) or OR statement (add results). > > Is there a way to modify the search criteria already used or perhaps even > save a set of criteria so

Re: [GNC] How to enter an accrued expense before Invoice?

2024-05-15 Thread Adrien Monteleone
be paying the Bill, reducing liabilities. (this is the date you actually remit payment) - As for payments unlinking themselves when unposting a Bill/Invoice that is normal. It however should do its best to automatically re-link that payment when you re-post the document after editing

Re: [GNC] How to enter an accrued expense before Invoice?

2024-05-15 Thread Adrien Monteleone
That's only if you do everything manually as you describe. You could also use the Business Features to enter the Accountant's Invoice (Bill) to you, and then enter a payment to clear it. The line item(s) of that Bill, would connect to your Accrued Expenses account, though admittedly, not

Re: [GNC] How to enter an accrued expense before Invoice?

2024-05-15 Thread Wesley Brooks
I think I've cracked it. Thanks to Adrien and David for the pointers. I have created an Accrued Expenses account in: Liabilities:Accrued Expenses At the final day of my current accounting period I create a transfer which adds money to this account as such: Actions > Transfer Within the pop

Re: [GNC] How to enter an accrued expense before Invoice?

2024-05-15 Thread Wesley Brooks
system as it stands at the moment is that if I subsequently need to edit a bill (wrong date, missed description when posted, typo in line, etc), if I unpost it make a change then GNUCash forgets the connection between the bill and the transaction that cleared the bill. I then need to delete the p

Re: [GNC] Use of cash discounts in business account tree

2024-05-14 Thread Michael or Penny Novack
On 5/14/2024 8:52 PM, nisp1953 wrote: OS; OpenBSD 7.5 GENERIC.MP#82 amd64 Gnucash Ver.: GnuCash 5.5 Build ID: 5.5+(2023-12-16) I have set up a simple business account tree using the wizard. I have Cash Discounst under expenses like so: \/ Expenses Bank Service Charge $0.00

Re: [GNC] How to enter an accrued expense before Invoice?

2024-05-14 Thread David Cousens
Wesley, you have to think through what the objective of the accrued accounting expense is and that is to charge the expense to the expense account as it accrues. You will eventually have to pay the money to the accountant when he presents his invoice so the total accrued amount is a liability

Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-14 Thread Adrien Monteleone
A confirmation dialog that the Check & Repair was completed (maybe even with or without incident or a summary) would be nice to have, but I know the devs already have a full plate. Perhaps file an RFE (Request For Enhancement) in the bug tracker if that one doesn't already exist. Regards,

Re: [GNC] How to transfer customer and vendor information from a previous GNUCash file?

2024-05-14 Thread Adrien Monteleone
As far as I am aware, there is no means within GnuCash to export/import Business Features setup data such as Customers, Vendors, Employees, or Tax Tables. You can import Invoices/Bills from a CSV, (such as data generated by another app) but you can't export them. (outside of running relevant

Re: [GNC] How to enter an accrued expense before Invoice?

2024-05-14 Thread Adrien Monteleone
This is essentially a basic accounting question, not so much 'how to do this in GnuCash.' The exact accounts used are up to you, but generically between an accounts such as: Dr. Expenses:Professional Services Cr. Liabilities:Accrued Expenses When the invoice is received, draw down the

Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-14 Thread Phyllis Bruce
Thanks Richard, that helps too. Didn’t know there was a progress bar when I was trying to run it. Po On May 13, 2024, at 8:26 PM, R Losey wrote:  The Check & Repair used to be slow (minutes); somewhere along the way, there was a major improvement; it is so fast (less

Re: [GNC] Question about OFX imports

2024-05-13 Thread Kalpesh Patel
, possibly ones that were already reconciled after import would entail needless download again, and then re-imports again for those accounts, especially now that description can be appended from two sides of import of a transaction. Since CSV and QIF already permits reimport and reconciliation

Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-13 Thread R Losey
The Check & Repair used to be slow (minutes); somewhere along the way, there was a major improvement; it is so fast (less than a second) on my network file with 6+ years of data that I can barely see the progress bar. So, it may be running; just very, very quickly. On Mon, May 13, 2024 at 9:41 

Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-13 Thread Adrien Monteleone
I think there were issues too with reports on Linux with NVIDIA graphics though there is a workaround and if I'm not mistaken, now also a fix. Regards, Adrien On 5/12/24 6:03 PM, Paul Kroitor wrote: You're on a Linux platform so it won't directly matter, but be aware that the Windows 5.5

Re: [GNC] Question about OFX imports

2024-05-13 Thread Jean Laroche
Also, you definitely would not want to double-import the same transaction, so there isn't a good reason to want to mock with the FITID. What *could* be useful (but in extremely rare cases) would be to force a re-import of the same transaction despite the fact that it's been imported previous

Re: [GNC] Question about OFX imports

2024-05-13 Thread David Reiser via gnucash-user
> On May 13, 2024, at 17:50, David Carlson wrote: > > Now it is my turn to ask a question. > > My bank recently had an issue with the description text for a few > transactions that resulted in the transactions being reposted with > corrected descriptions. Now I am trying to import the

Re: [GNC] Question about OFX imports

2024-05-13 Thread Jean Laroche
Yes, I believe that if you delete the previously imported transaction, the new one will be imported. For your 2nd question, there isn't a way to remove or edit that FITID value without hacking either the OFX or your database... I don't think GC ever shows you the FITID of transactions (even

Re: [GNC] Question about OFX imports

2024-05-13 Thread Phyllis Bruce
If it wasn’t many transactions cannot you just edit the cleared transactions? I’ m thinking Gnu won’t allow you to clear clear the nut ones as a feature to avoid duplicates. Alternatively, you might delete the cleared transactions and reimport. At least, that’s what I would do. > On May 13,

Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-13 Thread Phyllis Bruce
Thanks David, you are always a great help. I have created a backup copy of the data file and have no scheduled transactions or business features to worry about. I’ll (ahem) assume the check and repair has run. And will proceed with my upgrade. However, this old brain would like

Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-13 Thread David Carlson
Phyllis, I have noticed that it is important to select the best starting point for your purpose. I would also save the file before starting. If you start from an account rrgister and select check all, it only checks all the transactions in that register. To check the entire file, start from

Re: [GNC] blank reports

2024-05-13 Thread Mark at Lorimark
Hi Scott, I am running a flatpak version and so launching through that. I added a 'shortcut' to my start-menu so that I could launch the program. The shortcut uses a script file at ~/bin/gnuchash.sh Here is the script file contents; 11:03 AM mark@nixhp:~/bin $ cat gnucash.sh

Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-13 Thread Phyllis Bruce
Just when you thought you were done with this….. I’m running 4.13 on a windows 10 computer. I have a big problem getting any reports to run properly but today it is the check and repair function. No option that I choose gives me a “working” indication. I’m trying to be proactive before

Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-12 Thread Paul Kroitor
You're on a Linux platform so it won't directly matter, but be aware that the Windows 5.5 version has a major bug (many reports don't work). It's fixed in 5.5.1 and 5.6, so if you ever share your data files into the Windows universe, it's unlikely it would be to 5.5. That said, I'm not aware any

Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-12 Thread Chris Green
On Sat, May 11, 2024 at 03:49:04PM -0500, Adrien Monteleone wrote: > On 5/11/24 3:08 PM, Chris Green wrote: > > So, given that I'm going up just one major release I shouls be OK, but > > running "Check & Repair" before doing anything else is a good idea. > Correct. The Check & Repair should run

Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-11 Thread Adrien Monteleone
Correct. The Check & Repair should run silently automatically upon first opening your file with 5.5, but it doesn't hurt to do it intentionally. The biggest change I recall between 4 & 5 is the new type-ahead search method for the Description field. I personally prefer the change, but some

Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-11 Thread Chris Green
On Sat, May 11, 2024 at 12:45:11PM -0700, Jim DeLaHunt wrote: > Chris: > > On 2024-05-11 03:21, Chris Green wrote: > > I am changing my Linux desktop computer from one running xubuntu 22.04 > > to one running xubuntu 24.04. As a result of this the GnuCash version > > will move from 4.8 to 5.5. >

Re: [GNC] Moving from GnuCash 4.8 to GnuCash 5.5 - any issues likely to bite me?

2024-05-11 Thread Jim DeLaHunt
Chris: On 2024-05-11 03:21, Chris Green wrote: I am changing my Linux desktop computer from one running xubuntu 22.04 to one running xubuntu 24.04. As a result of this the GnuCash version will move from 4.8 to 5.5. Are there likely to be any problems or should it 'just work'? I'm using

Re: [GNC] Thank You Michael D Novack (Geoff)

2024-05-10 Thread Clare Vanessa | Web Freelancer
get 'how' to force your numbers into the system in order to make them 'fit' and 'appear' correctly. Kind regards, Clare Vanessa (Chapman) Freelance Web Designer & Copywriter e: cont...@clarevanessa.com.au p: 61 (0) 2 6644 9869 w: www.clarevanessa.com.au -Original Message----- RE: T

Re: [GNC] Stomped with interface between GNC (v4.18) and F::Q (v1.61_02)

2024-05-10 Thread Kalpesh Patel
That was it. Rounding down to 9 decimal places works. Thank you! -Original Message- From: John Ralls Sent: Wednesday, May 08, 2024 10:13 PM To: Kalpesh Patel Cc: GnuCash User Subject: Re: [GNC] Stomped with interface between GNC (v4.18) and F::Q (v1.61_02) Kalpesh, I think your

Re: [GNC] Update on financequote?

2024-05-10 Thread Kalpesh Patel
Your query seems to be garbled up but from what I make out from it: yes, F::Q works fine as of v1.61_03 release if that is what you are asking. -Original Message- From: interesse Sent: Friday, May 10, 2024 7:29 AM To: gnucash-user@gnucash.org Subject: [GNC] Update on financequote?

Re: [GNC] Importing historical stock prices to GnuCash in Windows

2024-05-10 Thread Kalpesh Patel
You may want to look at https://github.com/ka-patel/dl_quotes/tree/main/yfinance which is Python based... -Original Message- From: sunfis...@yahoo.com Sent: Friday, May 10, 2024 2:59 AM To: Leung Wing Cheong Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Importing historical stock

Re: [GNC] Problem building Gnucash from source using wiki page "macOS/Quartz"

2024-05-10 Thread John Ralls
> On May 9, 2024, at 10:08, Paul Ingram wrote: > > > Trying to build gnucash-5.6 from source on a mac mini running macOS 14.4.1 in > accordance with the instructions on > https://wiki.gnucash.org/wiki/MacOS/Quartz. > > Created administrator account “gtkosx” > Switched to the new account:

Re: [GNC] Importing historical stock prices to GnuCash in Windows

2024-05-10 Thread sunfish62--- via gnucash-user
, 2024, 11:31 AM, at 11:31 AM, Leung Wing Cheong wrote: >Got it, many thanks! >Wing > >-Original Message- >From: sunfis...@yahoo.com >Sent: Friday, May 10, 2024 2:59 PM >To: Leung Wing Cheong >Cc: gnucash-user@gnucash.org >Subject: Re: [GNC] Importing histori

Re: [GNC] Importing historical stock prices to GnuCash in Windows

2024-05-10 Thread Leung Wing Cheong
Got it, many thanks! Wing -Original Message- From: sunfis...@yahoo.com Sent: Friday, May 10, 2024 2:59 PM To: Leung Wing Cheong Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Importing historical stock prices to GnuCash in Windows Of course there is. The csv importer can handle any

Re: [GNC] Importing historical stock prices to GnuCash in Windows

2024-05-10 Thread sunfish62--- via gnucash-user
Of course there is. The csv importer can handle any price data, including historical data, as long as you supply the proper dates along with the other data elements. The challenge is gathering that price data in the first place. It used to be possible to retrieve unlimited price quotes from a

Re: [GNC] sales tax liability report?

2024-05-09 Thread Deva via gnucash-user
eans net income after accounting for sales tax liability. Cheers. === Date: Thu, 9 May 2024 09:52:49 -0400 From: Michael or Penny Novack To: gnucash-user@gnucash.org Subject: Re: [GNC] sales tax liability report? Message-ID: <44cd4d3d-502e-45cb-8a95-62cd472c5...@

Re: [GNC] [resolved] Re: no drop-down accounts list in ledger Transfer column.

2024-05-09 Thread Adrien Monteleone
You're welcome. Though, I don't think those AppImage builds are from the GnuCash development team. Caution is advised. Regards, Adrien On 5/9/24 5:59 AM, v@scottsonline.org.uk wrote: On 09/05/2024 01:16, Adrien Monteleone wrote: Any opposition to using flatpak? You wouldn't have to

Re: [GNC] sales tax liability report?

2024-05-09 Thread Michael or Penny Novack
On 5/9/2024 2:57 AM, Deva via gnucash-user wrote: Ted, If you have setup your accounts based on suggestions in the tutorial and concepts guide, you can try the following report - Reports -> Income & Expense -> Income and GST Statement In your case, GST = Sales Tax We MIGHT need a

Re: [GNC] [resolved] Re: no drop-down accounts list in ledger Transfer column.

2024-05-09 Thread v . gcs
On 09/05/2024 01:16, Adrien Monteleone wrote: Any opposition to using flatpak? You wouldn't have to wait. I avoid flatpak, having heard bad things about it. However (and thanks for the idea) there is an appimage version on github. I've downloaded 4.13 and given it a quick test, and it does

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