Re: [GNC] Working with dates in Postgresql DB

Was the problem that he entered variant dates, or that GnuCash reinterpreted his Perth transactions to a new date? My point is this: if he entered transactions in Perth for the 11th, and then returned to California, and they showed the 10th, wouldn't his problem have been solved if GnuCash had

Re: [GNC] Change account type by editing XML?

The intent of my post was to report you can't reassign transactions between Asset and Expenses accounts either using the process previously described. Yes, the account in Asset was created by the import wizard. It's nothing serious, went back to the previous file and imported again. On Sat, May

Re: [GNC] Working with dates in Postgresql DB

First off, flight time between California and Australia is something like 17 hours (to Hawaii, it's about 11), so if, after all that, you have energy to do your accounting in GnuCash, well, you're more of a masochist than I. Second, if I were to land on the 10th in California, I personally

[GNC] Change account type by editing XML?

No it's not specific to type A/R and/or A/P accounts. I clicked the wrong account and accidentally imported an expenses account into assets. I was expecting I could just delete it and move it to Expenses:Account but it just moved to Assets. (Import Matcher pisses me off because the account was

Re: [GNC] Working with dates in Postgresql DB

That's exactly what happened a few years ago to a guy from California who did some updates while visiting New Zealand. Regards, John Ralls > On May 1, 2020, at 3:16 PM, David H wrote: > > Might be a problem if you were in Perth on April 11 entering txns and then > back in California on

Re: [GNC] Working with dates in Postgresql DB

Might be a problem if you were in Perth on April 11 entering txns and then back in California on April 10 entering further txns using today's date ? i.e. if you travelled to a timezone that was still the previous day ? Cheers David H. On Sat, 2 May 2020 at 04:35, D. via gnucash-user wrote: >

Re: [GNC] Working with dates in Postgresql DB

I hope the posted time in DB in transactions and invoices will be the same 10:59 at least after fixing these two bugs when posting the invoices and set offsets through the lots. > > On May 1, 2020 at 21:32, mailto:sunfis...@yahoo.com)> wrote: > > > > I

Re: [GNC] Working with dates in Postgresql DB

I understand that a lot of debate and discussion and heartache had gone into this, so I really don't mean to be a pain, but it would seem to me that if I entered April 10, 2020 for a transaction, and GnuCash then stored 2020-04-10 HH:MM:SS (where HH:MM:SS represents any arbitrary time), if

Re: [GNC] Working with dates in Postgresql DB

David, You're not thinking it through: It's about 11:00 on Friday 1 May here in California but it's 03:00 on Saturday 2 May in Western Australia. Chopping off the time doesn't solve anything, a point illustrated by Finfort when he pointed out that just changing the time on the errant dates

Re: [GNC] Change account type by editing XML?

Assuming I have understood correctly, this still doesn't allow me to change the account type. See attached screenshot of the Edit Account dialogue after having moved an account to the top level. David On Fri, 1 May 2020 at 17:57, Derek Atkins wrote: > > "Stephen M. Butler" writes: > > > On

Re: [GNC] Change account type by editing XML?

"Stephen M. Butler" writes: > On 4/29/20 11:25 AM, david whiting wrote: >> Hello, >> >> When I first set up my accounts (for a local club) I knew very little >> about accounting and misinterpreted some information I was given by an >> accountant and ended up creating some sub-accounts in

Re: [GNC] AqBanking for Canadian banks

Nelson writes: > Hello everyone. > > Just wondering if anyone was successful in setting up any Canadian banks for > online banking in GnuCash. Thanks for sharing. Do they support OFX-DC? You can check OFXHome for your bank info? Good Luck, > Please remember to CC this list on all your

Re: [GNC] Why do Imported Transactions NEED to be Matched?

Hi, flywire writes: > Agree that import works in small chunks (as posted previously). Does that > response cover any way of getting GUIDs on the data? The GUIDs are 100% internal to GnuCash and unique per user per object (account, transaction, etc). There is no way to add GUIDs to imports,

Re: [GNC] Mortgage repayment schedule : error while inputting million

Hi, Sorry for the delayed response (I'm still catching up on old emails). Murugan writes: > i am new to this forum. i am trying to create a mortgage repayment schedule > for 2 Million pesos , but the formula is not picking up the value and > showing a zero. can you please let me know what i

Re: [GNC] Customer Chargeback

Hi, I don't see any responses to this question; sorry for the delay but I am catching up on 2 months of email.. Marcell Madar writes: > Hi, > > I am trying to use the chargeback function in Gnucash. The chargeback > customer and job are both specified when I create the bill and the >

Re: [GNC] Restoring "Unable to save to database" error?

Yes, that's exactly what I did...made a copy of the Gnucash file in another directory as a backup, then "Save As" over the old file. Worked like a charm. Eric H. Bowen e...@ehbowen.net On 5/1/2020 9:48 AM, Derek Atkins wrote: > Hi Eric, > > Sorry to respond to

Re: [GNC] Restoring "Unable to save to database" error?

Hi Eric, Sorry to respond to an old message but I didn't see any responses and I am currently catching up on ~2 months of email.. "Eric H. Bowen via gnucash-user" writes: > I've been getting the "Unable to save to database" error whenever I > import and/or save transactions in one of my asset

Re: [GNC] Find or search all expenses in a certain account

Hi, Sorry to respond to an old thread, but I'm catching up on 2 months of emails while I was heads-down on another project.. Gio Bacareza writes: > I'll give it a try. Thanks Adrien > > On Tue, Mar 10, 2020 at 11:41 AM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> That was

Re: [GNC] Invoice Date

Adrien, Sorry for the delayed response -- I'm catching up on 2 months of emails while I was heads-down on other projects. Adrien Monteleone writes: > I forgot to mention, if you didn’t notice the ‘date opened’ field in > the pop-up, and you are already in the invoice, click the Edit Invoice >

Re: [GNC] New User - Unique Transaction Number & Dates

Hi Stan, Sorry to respond to an old message, but I'm catching up on ~2 months of mail when I was heads-down on other projects.. Stan Brown writes: > David, you may be thinking of File » Properties » Accounts » Day > Threshold for Read-Only Transactions (red-line). > > I'm not sure why the

Re: [GNC] Reporting transactions

Yes :) They differ from other brokerage accounts in regulations on tax and on when and how you can withdraw funds. e.g. when you use it in retirement as your pension income, withdrawals from the fund into your normal bank account are taxed as income at the point of withdrawal (again, from a tax

Re: [GNC] Reporting transactions

IIUC the SIPP is simply a wrapper around stock-type and cash-type investments, so, you'd handle it exactly the same as any Broker and Broker investments. See https://www.gnucash.org/docs/v3/C/gnucash-guide/invest-setup1.html - the SIPP wrapper would be the "Brokerage Accounts" asset. You may

Re: [GNC] Reporting transactions

Yes sure that's one perspective and I agree with it, and that's why I have my SIPP in the same GC file as everything else. I was just noting that the way contributions are reported (i.e. as expenses eligible for tax rebates, not as income that is taxed) seems more in line with a different

Re: [GNC] Reporting transactions

I wouldn't classify sipp contributions as expense. You'd be incorrectly reducing your net worth whenever you contribute to it. On Fri, 1 May 2020, 5:23 pm Ruaraidh Sackville Hamilton, < ruaraidh...@gmail.com> wrote: > Ah yes you are right! I didn't think of the case where an employer pays >

Re: [GNC] Reporting transactions

Ah yes you are right! I didn't think of the case where an employer pays directly into a SIPP. In that case it is clearly an income. Not in mine. Conceptually, it might be better thought of as a business expense. The business is the SIPP and the government encourages investment in the business by

Re: [GNC] Superannuation Co-Vid payment

Did you read thre recommendations that David Cousens gave in: https://lists.gnucash.org/pipermail/gnucash-user/2020-May/090891.html David T. Original Message From: Chris Taylor Sent: Fri May 01 11:37:46 GMT+05:30 2020 To: gnucash-user@gnucash.org Subject: [GNC]

Re: [GNC] Adding Transactions From Another Program

I thought it was related to the due identity issues with python 2.7 and python 3.x On Fri, 1 May 2020 at 06:30, D. via gnucash-user wrote: > > That somehow seems to be an entirely justified substitution in my case! > > > Original Message > From: John Ralls > Sent: Fri May 01

[GNC] Superannuation Co-Vid payment

Hi everyone Looking for some advice on how to setup a account system Ok. What I have done is take up the Gov on the Co-Vid superannuation payment (withdrawal) of $10,000 What I wish to do is have it show up in bank account AAA that works day to day, I will be buying Gold this this money on a