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

[Adrien Monteleone]

That is dependent on the business. Not all businesses operate on those 
terms.


I am in 100% agreement that quotations/proformas are 'useful' and they 
might even be so to a significant proportion of businesses. But they are 
not 'accounting' and (from my personal experience) do not exist in 
'every' piece of 'other' 'accounting' software.


Sure, some of the big players may include such functionality.

I'd direct you to read the purpose of GnuCash, that is, who it is for.

That might inform you as to the target audience of the developers.

Maybe Quotations/Proformas will be included some 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
'accounting'. (Invoices and Credit Notes are however)



Quotations are certainly not accounting, but they are really useful to a
business, and exist on every piece of commercial accounting software I
could find.

A lot of companies want to see a proforma invoice before they will pay in
advance of receiving the goods.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 and tricks with the broader GnuCash 
community?


Do you mind if they are posted on the GnuCash wiki directly?

Regards,
Adrien

On 12/29/21 2:58 PM, Dr. David Kirkby wrote:

Far more useful, in my opinion, is for users to share their tricks for

getting gnucash to do their bidding, for which pages on the wiki (such as
https://wiki.gnucash.org/wiki/Using_GnuCash) were created to allow.



Given the fact nothing exists and what you say about there not likely to be
many contributors, I created a subdomain on my company website
https://gnucash.kirkbymicrowave.co.uk/
I added a comment about the Wiki too.

If it's useful people can use it. If it is not, I have not spent any more
than an hour or two setting it up, so it's not a big deal.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Report 'Equity Statement' - Investments and Withdrawals are always "0.00"

[Ismael]

Hello, My report 'Equity Statement For Period Covering 01.01.2021 to 
31.12.2021' shows: Capital, 01.01.2021 >> "correct value" Net income for Period 
>> "correct value" Investments for Period 0.00 Withdrawals for Period 0.00 
Increase in capital >> "correct value" Capital, 31.12.2021 >> "correct value" 
PROBLEM: Investments for Period & Withdrawals for Period are always "0.00". For 
buying new shares I followed the guide '9.5.2. Buying New Shares' and the 
accounts selected for the split are ASSET accounts (Asset:Stock:xyz & 
Asset:Bank). Further, my reports 'Investment Portfolio' & 'Advanced Portfolio' 
are correct. Via trial and error, I noticed that ‘Investments for Period’ & 
‘Withdrawals for Period’ refer to 'Accounts Type = Equity'. In consequence 
'Investments for Period' & 'Withdrawals for Period' in my Equity Statement will 
be always "0.00" for all shares purchased and/or sold during any accounting 
period. Is this a bug or do I misunderstand the meaning of 'Investments for 
Period & Withdrawals for Period' ? Regards Ismael Smajli
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] 4.9 account set up of going business

[William Prescott]

Please disregard.

About a year ago, I set up a new Gnucash data file and chart of accounts. I 
remember making some mistakes setting up the opening balances. I recollect 
having problems changing the Opening Balance entries and having to edit the 
Opening Balances account (from the Accounts tab->Opening Balances->Edit) and 
changing something to make the entries editable. 

But I cannot reproduce it now.

Will

On 2021 Dec 29, at 12-29 20:41:13, Rogier F. van Vlissingen 
 wrote:

Hi, thanks for that, but I cannot find any mechanism to "unlock" a read only 
account, nor does there seem to be anything in the manual about "unlocking?" 
Please clarify. 




On Wed, Dec 29, 2021 at 9:29 PM William Prescott mailto:w...@theprescotts.com>> wrote:
I'm not sure if this is relevant …

By default, the Opening Balance account is locked and transactions are only 
created there when you create a new account and give it an opening balance. But 
you can unlock the Opening Balance account and then adjust the transactions or 
add or delete them like in any other account.

Will

On 2021 Dec 29, at 12-29 18:52:16, John Ralls mailto:jra...@ceridwen.us>> wrote:



> On Dec 29, 2021, at 4:08 PM, Rogier F. van Vlissingen  > wrote:
> 
> I had previously moved to GnuCash3.8 starting 1/1/2020, unfortunately,
> there appears to be some sort of corruption in my file.
> 
> I am now doing it over in 4.9.
> 
> However, I am having a problem with the Opening Balances for 2020, as I
> seem to be unable to set up an opening balance for retained earnings.
> 
> The numbers check out, but everything goes in Opening balances, which is
> therefore too high by the amount of the retained earnings.
> 
> You can't even do a transfer.
> 
> 
> What is to be done?

A business book wouldn't normally have an opening balances account. OTOH money 
is fungible and it doesn't really make sense to divide every asset's 
start-of-year balance between liabilities, paid-in capital, and retained 
earnings, so it's in my mind quite defensible to use Opening Balances to 
accumulate everything. Liabilities are handled by creating normal opening 
balance entries. The New File Hierarchy Assistant doesn't let you make opening 
balance entries in Equity accounts, but you can add transactions to RE and 
whatever you're calling paid-in capital to zero out Opening Balances when 
you've finished with the assistant.

Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user 

If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists 
 for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user 

If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists 
 for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Incorrect QFX Import

[Jean L]

OK, that would have been too easy :D... Any chance you could send me the 
OFX? Remove anything that's private in it if you want. I'll debug on my 
end. If you get a chance, open a bug, and put the file there, otherwise 
send it to me directly...

Thanks!

Jean


On 12/29/2021 7:58 PM, Steve Cohen wrote:

There do not appear to be any duplicate FITIDs here.

I ran the command

grep FITID downloaded.QFX | sort > fitid.txt

and could easily see that there were no duplicates in the 136 entries 
in the file. The bank (Chase) appears to assign FITIDs of the form 
mmDD# where # is a consecutive number from 0-9.  What it would do 
if there were more than 10 entries isn't clear to me but that 
eventuality did not occur in this file which has only 136 entries over 
a year.




On Wed, Dec 29, 2021 at 4:18 PM Jean Laroche > wrote:


GC will not import an ofx transaction it thinks it already has
imported.
To determine whether a transaction has been imported GC looks at the
FITID. So if two transactions in your OFX file have the same
FITID, the
second one won't be imported.

Can you check that the transactions that are missing don't have
the same
FITID as some of the transactions that were imported?
Some banks are not good at assigning unique FITID to transactions,
and
that can cause a problem for GC.
Jean

On 12/29/21 2:13 PM, Steve Cohen wrote:
> Additionally, I tried exiting GnuCash and trying the import
again.  This
> made no difference.
>
> On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen mailto:stevec...@gmail.com>> wrote:
>
>> I downloaded all of 2021's transactions from my bank in QFX
format and
>> tried to import the file.
>>
>> As I was doing so, I noticed an anomaly.  I receive monthly direct
>> deposits from a pension, all arrive on or shortly after the
first of each
>> month, the same amount every month. But on the QFX import
screen, only 5 of
>> the months showed the deposit,
>> for January, May, August, September and December. The other
seven months
>> were not on the import screen. I tried sorting by date, by
amount, by
>> description - they aren't there.
>>
>> In an attempt to learn what was going on, I first checked my bank
>> statements.  Was the pension not being deposited? No, that
wasn't it, the
>> deposits came in every month as they were supposed to. I then
opened the
>> QFX file in a text editor to see if the deposits were listed in
the QFX.
>> They all were.  So I am trying to understand if there's a bug
in the import
>> function that would throw these transactions away.
>>
>> Here are the QFX entries from December and November. Perhaps
someone
>> looking at them can tell me why the first one was accepted and
the second
>> not? I see no important difference.
>>
>> 
>> CREDIT
>> 2021120112[0:GMT]
>> 1772.79
>> 202112010
>> COOK COUNTY PENS PENSIONS
>> PPD ID: 3660023021
>> 
>>
>> 
>> CREDIT
>> 2021110112[0:GMT]
>> 1772.79
>> 202111010
>> COOK COUNTY PENS PENSIONS
>> PPD ID: 3660023021
>> 
>>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Incorrect QFX Import

[Steve Cohen]

There do not appear to be any duplicate FITIDs here.

I ran the command

grep FITID downloaded.QFX | sort > fitid.txt

and could easily see that there were no duplicates in the 136 entries in
the file. The bank (Chase) appears to assign FITIDs of the form mmDD#
where # is a consecutive number from 0-9.  What it would do if there were
more than 10 entries isn't clear to me but that eventuality did not occur
in this file which has only 136 entries over a year.



On Wed, Dec 29, 2021 at 4:18 PM Jean Laroche  wrote:

> GC will not import an ofx transaction it thinks it already has imported.
> To determine whether a transaction has been imported GC looks at the
> FITID. So if two transactions in your OFX file have the same FITID, the
> second one won't be imported.
>
> Can you check that the transactions that are missing don't have the same
> FITID as some of the transactions that were imported?
> Some banks are not good at assigning unique FITID to transactions, and
> that can cause a problem for GC.
> Jean
>
> On 12/29/21 2:13 PM, Steve Cohen wrote:
> > Additionally, I tried exiting GnuCash and trying the import again.  This
> > made no difference.
> >
> > On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen  wrote:
> >
> >> I downloaded all of 2021's transactions from my bank in QFX format and
> >> tried to import the file.
> >>
> >> As I was doing so, I noticed an anomaly.  I receive monthly direct
> >> deposits from a pension, all arrive on or shortly after the first of
> each
> >> month, the same amount every month. But on the QFX import screen, only
> 5 of
> >> the months showed the deposit,
> >> for January, May, August, September and December.  The other seven
> months
> >> were not on the import screen. I tried sorting by date, by amount, by
> >> description - they aren't there.
> >>
> >> In an attempt to learn what was going on, I first checked my bank
> >> statements.  Was the pension not being deposited?  No, that wasn't it,
> the
> >> deposits came in every month as they were supposed to. I then opened the
> >> QFX file in a text editor to see if the deposits were listed in the QFX.
> >> They all were.  So I am trying to understand if there's a bug in the
> import
> >> function that would throw these transactions away.
> >>
> >> Here are the QFX entries from December and November. Perhaps someone
> >> looking at them can tell me why the first one was accepted and the
> second
> >> not? I see no important difference.
> >>
> >> 
> >> CREDIT
> >> 2021120112[0:GMT]
> >> 1772.79
> >> 202112010
> >> COOK COUNTY PENS PENSIONS
> >> PPD ID: 3660023021
> >> 
> >>
> >> 
> >> CREDIT
> >> 2021110112[0:GMT]
> >> 1772.79
> >> 202111010
> >> COOK COUNTY PENS PENSIONS
> >> PPD ID: 3660023021
> >> 
> >>
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] 4.9 account set up of going business

[Rogier F. van Vlissingen]

Hi, thanks for that, but I cannot find any mechanism to "unlock" a read
only account, nor does there seem to be anything in the manual about
"unlocking?" Please clarify.




On Wed, Dec 29, 2021 at 9:29 PM William Prescott 
wrote:

> I'm not sure if this is relevant …
>
> By default, the Opening Balance account is locked and transactions are
> only created there when you create a new account and give it an opening
> balance. But you can unlock the Opening Balance account and then adjust the
> transactions or add or delete them like in any other account.
>
> Will
>
> On 2021 Dec 29, at 12-29 18:52:16, John Ralls  wrote:
>
>
>
> > On Dec 29, 2021, at 4:08 PM, Rogier F. van Vlissingen <
> vlisc...@gmail.com> wrote:
> >
> > I had previously moved to GnuCash3.8 starting 1/1/2020, unfortunately,
> > there appears to be some sort of corruption in my file.
> >
> > I am now doing it over in 4.9.
> >
> > However, I am having a problem with the Opening Balances for 2020, as I
> > seem to be unable to set up an opening balance for retained earnings.
> >
> > The numbers check out, but everything goes in Opening balances, which is
> > therefore too high by the amount of the retained earnings.
> >
> > You can't even do a transfer.
> >
> >
> > What is to be done?
>
> A business book wouldn't normally have an opening balances account. OTOH
> money is fungible and it doesn't really make sense to divide every asset's
> start-of-year balance between liabilities, paid-in capital, and retained
> earnings, so it's in my mind quite defensible to use Opening Balances to
> accumulate everything. Liabilities are handled by creating normal opening
> balance entries. The New File Hierarchy Assistant doesn't let you make
> opening balance entries in Equity accounts, but you can add transactions to
> RE and whatever you're calling paid-in capital to zero out Opening Balances
> when you've finished with the assistant.
>
> Regards,
> John Ralls
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] 4.9 account set up of going business

[William Prescott]

I'm not sure if this is relevant …

By default, the Opening Balance account is locked and transactions are only 
created there when you create a new account and give it an opening balance. But 
you can unlock the Opening Balance account and then adjust the transactions or 
add or delete them like in any other account.

Will

On 2021 Dec 29, at 12-29 18:52:16, John Ralls  wrote:



> On Dec 29, 2021, at 4:08 PM, Rogier F. van Vlissingen  
> wrote:
> 
> I had previously moved to GnuCash3.8 starting 1/1/2020, unfortunately,
> there appears to be some sort of corruption in my file.
> 
> I am now doing it over in 4.9.
> 
> However, I am having a problem with the Opening Balances for 2020, as I
> seem to be unable to set up an opening balance for retained earnings.
> 
> The numbers check out, but everything goes in Opening balances, which is
> therefore too high by the amount of the retained earnings.
> 
> You can't even do a transfer.
> 
> 
> What is to be done?

A business book wouldn't normally have an opening balances account. OTOH money 
is fungible and it doesn't really make sense to divide every asset's 
start-of-year balance between liabilities, paid-in capital, and retained 
earnings, so it's in my mind quite defensible to use Opening Balances to 
accumulate everything. Liabilities are handled by creating normal opening 
balance entries. The New File Hierarchy Assistant doesn't let you make opening 
balance entries in Equity accounts, but you can add transactions to RE and 
whatever you're calling paid-in capital to zero out Opening Balances when 
you've finished with the assistant.

Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Advancing scheduled transactions

[Stephen M. Butler]

Roger,

That would be nice.  Need to enter an enhancement request to have that 
added during the copious amounts of free time the developers have!


But, to get around that limitation, I do use the "Create in Advance" so 
it is in the register early (but for the scheduled date).  That way I 
can just adjust the date on the transaction that is already waiting.


That's the only way now to move a scheduled transaction earlier. Now, if 
you want an extra one, duplicate it from the prior month.


--Steve

On 12/29/21 16:15, rmom...@gmail.com wrote:


Steve,

Just want the option to trigger a post manually, not a permanent 
change in the schedule. As you do, I set up my scheduled transactions 
to post on the 1^st of the month regardless of the date of the 
transaction. I usually wait till the first to pay and post my bills to 
accommodate the scheduled transactions limitations. It would be like 
skipping a scheduled transaction for one month only the opposite, 
activating it early. Pick a scheduled transaction and tell the program 
to go ahead and post it today, on the 30^th of month prior to the next 
scheduled transaction date. Hope that explains what I’m looking for.


Thanks,

Roger

*From:* Steve Butler 
*Sent:* Wednesday, December 29, 2021 10:47 AM
*To:* rmom...@gmail.com
*Subject:* Re: [GNC] Advancing scheduled transactions

Not sure what you are asking.  Do you want to permanently change the 
date the transaction fires?


Or is this just a random change because it came early that month?

Note:  I generally have scheduled transactions automatically post 
15-20 days early so I can see their effect in the registers of 
interest.  If I note that the transaction posted on a date different, 
it is easy to change the date in that register.


I haven't tried editing the general/overview panel on a scheduled 
transaction to see if the scheduled date could be permanently changed.


On Wed, Dec 29, 2021, 08:24  wrote:

Is there a way to advance a specific scheduled transaction in
Version: 4.6
Build ID: 4.6+(2021-06-26). Be nice to have an option of advancing a
scheduled transaction for example when I get paid before the end
of the
month. I don't see a way to do that. Hasn't been one as far as I
know in
previous versions. Just be a handy feature.



Happy New Year,

Roger




--
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] 4.9 account set up of going business

[John Ralls]

> On Dec 29, 2021, at 4:08 PM, Rogier F. van Vlissingen  
> wrote:
> 
> I had previously moved to GnuCash3.8 starting 1/1/2020, unfortunately,
> there appears to be some sort of corruption in my file.
> 
> I am now doing it over in 4.9.
> 
> However, I am having a problem with the Opening Balances for 2020, as I
> seem to be unable to set up an opening balance for retained earnings.
> 
> The numbers check out, but everything goes in Opening balances, which is
> therefore too high by the amount of the retained earnings.
> 
> You can't even do a transfer.
> 
> 
> What is to be done?

A business book wouldn't normally have an opening balances account. OTOH money 
is fungible and it doesn't really make sense to divide every asset's 
start-of-year balance between liabilities, paid-in capital, and retained 
earnings, so it's in my mind quite defensible to use Opening Balances to 
accumulate everything. Liabilities are handled by creating normal opening 
balance entries. The New File Hierarchy Assistant doesn't let you make opening 
balance entries in Equity accounts, but you can add transactions to RE and 
whatever you're calling paid-in capital to zero out Opening Balances when 
you've finished with the assistant.

Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Incorrect QFX Import

[Jean L]

There a debug flag you can enable to have info printed out when 
transactions are skipped, but I don't remember off the top of my head 
which flag that is.



On 12/29/2021 3:42 PM, Christopher Lam wrote:


It would be nice to have visibility of these imported transactions? 
Checkbox at the bottom would reveal them, all grayed out, and clicky 
link to the matched split in the register?


*From: *Jean Laroche 
*Sent: *Thursday, 30 December 2021 6:18 AM
*To: *gnucash-user@gnucash.org 
*Subject: *Re: [GNC] Incorrect QFX Import

GC will not import an ofx transaction it thinks it already has imported.

To determine whether a transaction has been imported GC looks at the

FITID. So if two transactions in your OFX file have the same FITID, the

second one won't be imported.

Can you check that the transactions that are missing don't have the same

FITID as some of the transactions that were imported?

Some banks are not good at assigning unique FITID to transactions, and

that can cause a problem for GC.

Jean

On 12/29/21 2:13 PM, Steve Cohen wrote:

> Additionally, I tried exiting GnuCash and trying the import again.  This

> made no difference.

>

> On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen  wrote:

>

>> I downloaded all of 2021's transactions from my bank in QFX format and

>> tried to import the file.

>>

>> As I was doing so, I noticed an anomaly.  I receive monthly direct

>> deposits from a pension, all arrive on or shortly after the first 
of each


>> month, the same amount every month. But on the QFX import screen, 
only 5 of


>> the months showed the deposit,

>> for January, May, August, September and December.  The other seven 
months


>> were not on the import screen. I tried sorting by date, by amount, by

>> description - they aren't there.

>>

>> In an attempt to learn what was going on, I first checked my bank

>> statements.  Was the pension not being deposited?  No, that wasn't 
it, the


>> deposits came in every month as they were supposed to. I then 
opened the


>> QFX file in a text editor to see if the deposits were listed in the 
QFX.


>> They all were.  So I am trying to understand if there's a bug in 
the import


>> function that would throw these transactions away.

>>

>> Here are the QFX entries from December and November. Perhaps someone

>> looking at them can tell me why the first one was accepted and the 
second


>> not? I see no important difference.

>>

>> 

>> CREDIT

>> 2021120112[0:GMT]

>> 1772.79

>> 202112010

>> COOK COUNTY PENS PENSIONS

>> PPD ID: 3660023021

>> 

>>

>> 

>> CREDIT

>> 2021110112[0:GMT]

>> 1772.79

>> 202111010

>> COOK COUNTY PENS PENSIONS

>> PPD ID: 3660023021

>> 

>>

> ___

> gnucash-user mailing list

> gnucash-user@gnucash.org

> To update your subscription preferences or to unsubscribe:

> https://lists.gnucash.org/mailman/listinfo/gnucash-user

> If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.


> -

> Please remember to CC this list on all your replies.

> You can do this by using Reply-To-List or Reply-All.

___

gnucash-user mailing list

gnucash-user@gnucash.org

To update your subscription preferences or to unsubscribe:

https://lists.gnucash.org/mailman/listinfo/gnucash-user

If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.


-

Please remember to CC this list on all your replies.

You can do this by using Reply-To-List or Reply-All.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Advancing scheduled transations

[rmomxtx]

Exactly. I know how to program scheduled transactions and how to change
them. But I don't want to change the entire schedule for a one time early
deposit. You describe it perfectly, "right-click a scheduled transaction and
have a post now option or even a skip this time option." I suspect such is
not the case but thought I would ask. The answers I have gotten on this in
the past convince me that I have not been able to communicate well what I'm
trying to accomplish.

 

Thanks much,

Roger

 

From: Gyle McCollam  
Sent: Wednesday, December 29, 2021 10:57 AM
To: rmom...@gmail.com
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Advancing scheduled transations

 

Roger, I was just looking at that the last few days myself.  It would be
fantastic if you could say right-click a scheduled transaction and have a
post now option and even a skip this time option.  I know if the payday
comes on a Saturday or a Sunday you can set, under frequency/except on
weekends, to "Use previous weekday" or "Use next weekday", but that doesn't
always work.  This coming month the first is on a Saturday, but the previous
weekday is a holiday, so the payment is actually going to be on Thursday
12/30 and there is no way to accelerate that scheduled transaction date.

 

So, I second that request.  It is a great idea.

 

Thank You,   
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

  gmccol...@live.com   email

  _  

From: gnucash-user mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org> > on behalf of
rmom...@gmail.com   mailto:rmom...@gmail.com> >
Sent: Wednesday, December 29, 2021 11:23 AM
To: GnuCash mailto:gnucash-user@gnucash.org> >
Subject: [GNC] Advancing scheduled transations 

 

Is there a way to advance a specific scheduled transaction in Version: 4.6
Build ID: 4.6+(2021-06-26). Be nice to have an option of advancing a
scheduled transaction for example when I get paid before the end of the
month. I don't see a way to do that. Hasn't been one as far as I know in
previous versions. Just be a handy feature.

 

Happy New Year,

Roger

___
gnucash-user mailing list
gnucash-user@gnucash.org  
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Advancing scheduled transactions

[rmomxtx]

Steve,

 

Just want the option to trigger a post manually, not a permanent change in the 
schedule. As you do, I set up my scheduled transactions to post on the 1st of 
the month regardless of the date of the transaction. I usually wait till the 
first to pay and post my bills to accommodate the scheduled transactions 
limitations. It would be like skipping a scheduled transaction for one month 
only the opposite, activating it early. Pick a scheduled transaction and tell 
the program to go ahead and post it today, on the 30th of month prior to the 
next scheduled transaction date. Hope that explains what I’m looking for.

 

Thanks,

Roger

 

From: Steve Butler  
Sent: Wednesday, December 29, 2021 10:47 AM
To: rmom...@gmail.com
Subject: Re: [GNC] Advancing scheduled transactions

 

Not sure what you are asking.  Do you want to permanently change the date the 
transaction fires?

 

Or is this just a random change because it came early that month?

 

Note:  I generally have scheduled transactions automatically post 15-20 days 
early so I can see their effect in the registers of interest.  If I note that 
the transaction posted on a date different, it is easy to change the date in 
that register.

 

I haven't tried editing the general/overview panel on a scheduled transaction 
to see if the scheduled date could be permanently changed.

 

On Wed, Dec 29, 2021, 08:24 mailto:rmom...@gmail.com> > 
wrote:

Is there a way to advance a specific scheduled transaction in Version: 4.6
Build ID: 4.6+(2021-06-26). Be nice to have an option of advancing a
scheduled transaction for example when I get paid before the end of the
month. I don't see a way to do that. Hasn't been one as far as I know in
previous versions. Just be a handy feature.



Happy New Year,

Roger

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] 4.9 account set up of going business

[Rogier F. van Vlissingen]

I had previously moved to GnuCash3.8 starting 1/1/2020, unfortunately,
there appears to be some sort of corruption in my file.

I am now doing it over in 4.9.

However, I am having a problem with the Opening Balances for 2020, as I
seem to be unable to set up an opening balance for retained earnings.

The numbers check out, but everything goes in Opening balances, which is
therefore too high by the amount of the retained earnings.

You can't even do a transfer.


What is to be done?



Rogier Fentener van Vlissingen 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Incorrect QFX Import

[Christopher Lam]

   It would be nice to have visibility of these imported transactions?
   Checkbox at the bottom would reveal them, all grayed out, and clicky
   link to the matched split in the register?


   From: [1]Jean Laroche
   Sent: Thursday, 30 December 2021 6:18 AM
   To: [2]gnucash-user@gnucash.org
   Subject: Re: [GNC] Incorrect QFX Import


   GC will not import an ofx transaction it thinks it already has
   imported.

   To determine whether a transaction has been imported GC looks at the

   FITID. So if two transactions in your OFX file have the same FITID, the

   second one won't be imported.


   Can you check that the transactions that are missing don't have the
   same

   FITID as some of the transactions that were imported?

   Some banks are not good at assigning unique FITID to transactions, and

   that can cause a problem for GC.

   Jean


   On 12/29/21 2:13 PM, Steve Cohen wrote:

   > Additionally, I tried exiting GnuCash and trying the import again.
   This

   > made no difference.

   >

   > On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen 
   wrote:

   >

   >> I downloaded all of 2021's transactions from my bank in QFX format
   and

   >> tried to import the file.

   >>

   >> As I was doing so, I noticed an anomaly.  I receive monthly direct

   >> deposits from a pension, all arrive on or shortly after the first of
   each

   >> month, the same amount every month. But on the QFX import screen,
   only 5 of

   >> the months showed the deposit,

   >> for January, May, August, September and December.  The other seven
   months

   >> were not on the import screen. I tried sorting by date, by amount,
   by

   >> description - they aren't there.

   >>

   >> In an attempt to learn what was going on, I first checked my bank

   >> statements.  Was the pension not being deposited?  No, that wasn't
   it, the

   >> deposits came in every month as they were supposed to. I then opened
   the

   >> QFX file in a text editor to see if the deposits were listed in the
   QFX.

   >> They all were.  So I am trying to understand if there's a bug in the
   import

   >> function that would throw these transactions away.

   >>

   >> Here are the QFX entries from December and November. Perhaps someone

   >> looking at them can tell me why the first one was accepted and the
   second

   >> not? I see no important difference.

   >>

   >> 

   >> CREDIT

   >> 2021120112[0:GMT]

   >> 1772.79

   >> 202112010

   >> COOK COUNTY PENS PENSIONS

   >> PPD ID: 3660023021

   >> 

   >>

   >> 

   >> CREDIT

   >> 2021110112[0:GMT]

   >> 1772.79

   >> 202111010

   >> COOK COUNTY PENS PENSIONS

   >> PPD ID: 3660023021

   >> 

   >>

   > ___

   > gnucash-user mailing list

   > gnucash-user@gnucash.org

   > To update your subscription preferences or to unsubscribe:

   > https://lists.gnucash.org/mailman/listinfo/gnucash-user

   > If you are using Nabble or Gmane, please see
   https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

   > -

   > Please remember to CC this list on all your replies.

   > You can do this by using Reply-To-List or Reply-All.

   ___

   gnucash-user mailing list

   gnucash-user@gnucash.org

   To update your subscription preferences or to unsubscribe:

   https://lists.gnucash.org/mailman/listinfo/gnucash-user

   If you are using Nabble or Gmane, please see
   https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

   -

   Please remember to CC this list on all your replies.

   You can do this by using Reply-To-List or Reply-All.

References

   1. mailto:rip...@gmail.com
   2. mailto:gnucash-user@gnucash.org
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Incorrect QFX Import

[Jean Laroche]

GC will not import an ofx transaction it thinks it already has imported. 
To determine whether a transaction has been imported GC looks at the 
FITID. So if two transactions in your OFX file have the same FITID, the 
second one won't be imported.


Can you check that the transactions that are missing don't have the same 
FITID as some of the transactions that were imported?
Some banks are not good at assigning unique FITID to transactions, and 
that can cause a problem for GC.

Jean

On 12/29/21 2:13 PM, Steve Cohen wrote:

Additionally, I tried exiting GnuCash and trying the import again.  This
made no difference.

On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen  wrote:


I downloaded all of 2021's transactions from my bank in QFX format and
tried to import the file.

As I was doing so, I noticed an anomaly.  I receive monthly direct
deposits from a pension, all arrive on or shortly after the first of each
month, the same amount every month. But on the QFX import screen, only 5 of
the months showed the deposit,
for January, May, August, September and December.  The other seven months
were not on the import screen. I tried sorting by date, by amount, by
description - they aren't there.

In an attempt to learn what was going on, I first checked my bank
statements.  Was the pension not being deposited?  No, that wasn't it, the
deposits came in every month as they were supposed to. I then opened the
QFX file in a text editor to see if the deposits were listed in the QFX.
They all were.  So I am trying to understand if there's a bug in the import
function that would throw these transactions away.

Here are the QFX entries from December and November. Perhaps someone
looking at them can tell me why the first one was accepted and the second
not? I see no important difference.


CREDIT
2021120112[0:GMT]
1772.79
202112010
COOK COUNTY PENS PENSIONS
PPD ID: 3660023021



CREDIT
2021110112[0:GMT]
1772.79
202111010
COOK COUNTY PENS PENSIONS
PPD ID: 3660023021



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Incorrect QFX Import

[Steve Cohen]

Additionally, I tried exiting GnuCash and trying the import again.  This
made no difference.

On Wed, Dec 29, 2021 at 4:06 PM Steve Cohen  wrote:

> I downloaded all of 2021's transactions from my bank in QFX format and
> tried to import the file.
>
> As I was doing so, I noticed an anomaly.  I receive monthly direct
> deposits from a pension, all arrive on or shortly after the first of each
> month, the same amount every month. But on the QFX import screen, only 5 of
> the months showed the deposit,
> for January, May, August, September and December.  The other seven months
> were not on the import screen. I tried sorting by date, by amount, by
> description - they aren't there.
>
> In an attempt to learn what was going on, I first checked my bank
> statements.  Was the pension not being deposited?  No, that wasn't it, the
> deposits came in every month as they were supposed to. I then opened the
> QFX file in a text editor to see if the deposits were listed in the QFX.
> They all were.  So I am trying to understand if there's a bug in the import
> function that would throw these transactions away.
>
> Here are the QFX entries from December and November. Perhaps someone
> looking at them can tell me why the first one was accepted and the second
> not? I see no important difference.
>
> 
> CREDIT
> 2021120112[0:GMT]
> 1772.79
> 202112010
> COOK COUNTY PENS PENSIONS
> PPD ID: 3660023021
> 
>
> 
> CREDIT
> 2021110112[0:GMT]
> 1772.79
> 202111010
> COOK COUNTY PENS PENSIONS
> PPD ID: 3660023021
> 
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Incorrect QFX Import

[Steve Cohen]

I downloaded all of 2021's transactions from my bank in QFX format and
tried to import the file.

As I was doing so, I noticed an anomaly.  I receive monthly direct deposits
from a pension, all arrive on or shortly after the first of each month, the
same amount every month. But on the QFX import screen, only 5 of the months
showed the deposit,
for January, May, August, September and December.  The other seven months
were not on the import screen. I tried sorting by date, by amount, by
description - they aren't there.

In an attempt to learn what was going on, I first checked my bank
statements.  Was the pension not being deposited?  No, that wasn't it, the
deposits came in every month as they were supposed to. I then opened the
QFX file in a text editor to see if the deposits were listed in the QFX.
They all were.  So I am trying to understand if there's a bug in the import
function that would throw these transactions away.

Here are the QFX entries from December and November. Perhaps someone
looking at them can tell me why the first one was accepted and the second
not? I see no important difference.


CREDIT
2021120112[0:GMT]
1772.79
202112010
COOK COUNTY PENS PENSIONS
PPD ID: 3660023021



CREDIT
2021110112[0:GMT]
1772.79
202111010
COOK COUNTY PENS PENSIONS
PPD ID: 3660023021

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Dr. David Kirkby]

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
> 'accounting'. (Invoices and Credit Notes are however)
>

Quotations are certainly not accounting, but they are really useful to a
business, and exist on every piece of commercial accounting software I
could find.

A lot of companies want to see a proforma invoice before they will pay in
advance of receiving the goods.

>
> (though as I noted before, some preliminary work has been done on
> quotations, but it has not been finalized or implemented yet)
>
> Best of luck.
>
> Regards,
> Adrien
>

Dave
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Dr. David Kirkby]

On Tue, 14 Dec 2021 at 00:36, D.  wrote:

> Dr. Kirkby,
>
> I appreciate your enthusiasm for this idea.
>
> I honestly doubt you'll get many contributors.
>

Far more useful, in my opinion, is for users to share their tricks for
> getting gnucash to do their bidding, for which pages on the wiki (such as
> https://wiki.gnucash.org/wiki/Using_GnuCash) were created to allow.
>

Given the fact nothing exists and what you say about there not likely to be
many contributors, I created a subdomain on my company website
https://gnucash.kirkbymicrowave.co.uk/
I added a comment about the Wiki too.

If it's useful people can use it. If it is not, I have not spent any more
than an hour or two setting it up, so it's not a big deal.

>
> Best,
> David T.
>

Dave
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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


2.) File > Export > Export Active Register to CSV while viewing one of 
the above search results registers.


You might well end up with all splits for each invoice, not just one 
line each. In that case, simply sort/massage as needed in a spreadsheet app.


Regards,
Adrien

On 12/29/21 1:40 AM, Omer Hayat wrote:

is there a way to export the list of invoices generated to excel? as well as 
the vendor bills inputted into the system?

Scenario: We are a branch, and our main parent uses Quickbooks. Due to our low 
volume of transactions, it will be easier to maintain our part of the accounts 
separate, and just import them into their Quickbooks on a monthly basis.
We don’t need to import the complete chart of accounts etc, but just the 
invoices and vendor bills.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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, then iff the quote is accepted,
import into GC?  ISTR that it may be possible to CSV import an invoice?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[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 number to something like 'use next' if you made an error
creating it)



If the invoice can not be deleted before posting, that would probably mean
it is unsuitable for use in the UK, as I believe invoice numbers have to be
created sequentially.  One should *not* have invoice numbers of 1, 2, 4, 7
etc.


That shouldn't be a problem since you can edit the numbers if need be. 
But that would mean you'd need to devise of separate quote number 
system. (investigate File > Properties where you can set numbering schemes)


There are plenty of UK users here on this list. I'm sure one of them can 
give some tips in this regard.





The Business Features originally were created by a dev for their own
limited use case. Some UI improvements and bug fixes have been made over
the years, but the functionality hasn't really been expanded much for
some time. (I think Credit Notes being added was the last major change
and that was way back in 2.4.x or early 2.6.x)



The user interface is obviously important, but the lack of some basic
functionality is annoying. >
The other thing that I would like (support for crypto currencies) is
something that I expect I could easily add to the source code myself. But
there’s no way I could add the invoice/proforma invoice, is not something
that I am going to be able to do.

I will have a look around and see if other open-source software that might
meet my needs better.

I think the ability to convert a quotation into an invoice, *and also to a
proforma invoice*, is pretty is pretty important.


Quotations/Proformas are not basic functionality. They aren't even 
'accounting'. (Invoices and Credit Notes are however)


(though as I noted before, some preliminary work has been done on 
quotations, but it has not been finalized or implemented yet)


Best of luck.

Regards,
Adrien

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Advancing scheduled transations

[Gyle McCollam]

Thanks, Dan and Glenn, both are good options.  I like Dan's option better for 
this "Holiday" scenario, but there are occasions where I think Glen's idea 
would work better.  Good thing I have two work arounds now!


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: Glenn Fowler 
Sent: Wednesday, December 29, 2021 12:28 PM
To: Gyle McCollam 
Cc: David Carlson ; gnucash-user@gnucash.org 

Subject: Re: [GNC] Advancing scheduled transations

Hi Gyle,

If the payment isn't consistent, using "duplicate" monthly may work better in 
your case.

If the early pay is a rare occurrence, you could duplicate for that month and 
then change the start date in the scheduled transaction for the next month.

On Wed, Dec 29, 2021 at 12:00 PM Gyle McCollam 
mailto:gmccol...@live.com>> wrote:
Editing works, but then you have to go back and edit it again to get it back on 
the "correct" schedule.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com>
   email


From: gnucash-user 
mailto:gmail@gnucash.org>>
 on behalf of David Carlson 
mailto:david.carlson@gmail.com>>
Sent: Wednesday, December 29, 2021 11:48 AM
To: Roger Oliver mailto:rmom...@gmail.com>>
Cc: GnuCash mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] Advancing scheduled transations

To edit a scheduled transaction, use Actions > Scheduled Transactions >
Scheduled Transaction Editor.  To enter a scheduled translation into the
account register use Actions > Scheduled Transactions > Since Last Run...

There is a lot more detail in the help manual.

On Wed, Dec 29, 2021 at 10:24 AM mailto:rmom...@gmail.com>> 
wrote:

> Is there a way to advance a specific scheduled transaction in Version: 4.6
> Build ID: 4.6+(2021-06-26). Be nice to have an option of advancing a
> scheduled transaction for example when I get paid before the end of the
> month. I don't see a way to do that. Hasn't been one as far as I know in
> previous versions. Just be a handy feature.
>
>
>
> Happy New Year,
>
> Roger
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


--
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Advancing scheduled transations

[Glenn Fowler]

Hi Gyle,

If the payment isn't consistent, using "duplicate" monthly may work better
in your case.

If the early pay is a rare occurrence, you could duplicate for that month
and then change the start date in the scheduled transaction for the
next month.

On Wed, Dec 29, 2021 at 12:00 PM Gyle McCollam  wrote:

> Editing works, but then you have to go back and edit it again to get it
> back on the "correct" schedule.
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com   email
>
> 
> From: gnucash-user  on
> behalf of David Carlson 
> Sent: Wednesday, December 29, 2021 11:48 AM
> To: Roger Oliver 
> Cc: GnuCash 
> Subject: Re: [GNC] Advancing scheduled transations
>
> To edit a scheduled transaction, use Actions > Scheduled Transactions >
> Scheduled Transaction Editor.  To enter a scheduled translation into the
> account register use Actions > Scheduled Transactions > Since Last Run...
>
> There is a lot more detail in the help manual.
>
> On Wed, Dec 29, 2021 at 10:24 AM  wrote:
>
> > Is there a way to advance a specific scheduled transaction in Version:
> 4.6
> > Build ID: 4.6+(2021-06-26). Be nice to have an option of advancing a
> > scheduled transaction for example when I get paid before the end of the
> > month. I don't see a way to do that. Hasn't been one as far as I know in
> > previous versions. Just be a handy feature.
> >
> >
> >
> > Happy New Year,
> >
> > Roger
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
>
>
> --
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Advancing scheduled transations

[Dan Black]

There is the option to create the entry so many days in advance. Then you 
can edit the date of the transaction.


Dan

On December 29, 2021 12:01:37 PM Gyle McCollam  wrote:

Editing works, but then you have to go back and edit it again to get it 
back on the "correct" schedule.



Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on 
behalf of David Carlson 

Sent: Wednesday, December 29, 2021 11:48 AM
To: Roger Oliver 
Cc: GnuCash 
Subject: Re: [GNC] Advancing scheduled transations

To edit a scheduled transaction, use Actions > Scheduled Transactions >
Scheduled Transaction Editor.  To enter a scheduled translation into the
account register use Actions > Scheduled Transactions > Since Last Run...

There is a lot more detail in the help manual.

On Wed, Dec 29, 2021 at 10:24 AM  wrote:


Is there a way to advance a specific scheduled transaction in Version: 4.6
Build ID: 4.6+(2021-06-26). Be nice to have an option of advancing a
scheduled transaction for example when I get paid before the end of the
month. I don't see a way to do that. Hasn't been one as far as I know in
previous versions. Just be a handy feature.



Happy New Year,

Roger

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.




--
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Advancing scheduled transations

[Gyle McCollam]

Editing works, but then you have to go back and edit it again to get it back on 
the "correct" schedule.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on 
behalf of David Carlson 
Sent: Wednesday, December 29, 2021 11:48 AM
To: Roger Oliver 
Cc: GnuCash 
Subject: Re: [GNC] Advancing scheduled transations

To edit a scheduled transaction, use Actions > Scheduled Transactions >
Scheduled Transaction Editor.  To enter a scheduled translation into the
account register use Actions > Scheduled Transactions > Since Last Run...

There is a lot more detail in the help manual.

On Wed, Dec 29, 2021 at 10:24 AM  wrote:

> Is there a way to advance a specific scheduled transaction in Version: 4.6
> Build ID: 4.6+(2021-06-26). Be nice to have an option of advancing a
> scheduled transaction for example when I get paid before the end of the
> month. I don't see a way to do that. Hasn't been one as far as I know in
> previous versions. Just be a handy feature.
>
>
>
> Happy New Year,
>
> Roger
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


--
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Advancing scheduled transations

[Gyle McCollam]

Roger, I was just looking at that the last few days myself.  It would be 
fantastic if you could say right-click a scheduled transaction and have a post 
now option and even a skip this time option.  I know if the payday comes on a 
Saturday or a Sunday you can set, under frequency/except on weekends, to "Use 
previous weekday" or "Use next weekday", but that doesn't always work.  This 
coming month the first is on a Saturday, but the previous weekday is a holiday, 
so the payment is actually going to be on Thursday 12/30 and there is no way to 
accelerate that scheduled transaction date.

So, I second that request.  It is a great idea.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on 
behalf of rmom...@gmail.com 
Sent: Wednesday, December 29, 2021 11:23 AM
To: GnuCash 
Subject: [GNC] Advancing scheduled transations

Is there a way to advance a specific scheduled transaction in Version: 4.6
Build ID: 4.6+(2021-06-26). Be nice to have an option of advancing a
scheduled transaction for example when I get paid before the end of the
month. I don't see a way to do that. Hasn't been one as far as I know in
previous versions. Just be a handy feature.



Happy New Year,

Roger

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Advancing scheduled transations

[David Carlson]

To edit a scheduled transaction, use Actions > Scheduled Transactions >
Scheduled Transaction Editor.  To enter a scheduled translation into the
account register use Actions > Scheduled Transactions > Since Last Run...

There is a lot more detail in the help manual.

On Wed, Dec 29, 2021 at 10:24 AM  wrote:

> Is there a way to advance a specific scheduled transaction in Version: 4.6
> Build ID: 4.6+(2021-06-26). Be nice to have an option of advancing a
> scheduled transaction for example when I get paid before the end of the
> month. I don't see a way to do that. Hasn't been one as far as I know in
> previous versions. Just be a handy feature.
>
>
>
> Happy New Year,
>
> Roger
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Advancing scheduled transations

[rmomxtx]

Is there a way to advance a specific scheduled transaction in Version: 4.6
Build ID: 4.6+(2021-06-26). Be nice to have an option of advancing a
scheduled transaction for example when I get paid before the end of the
month. I don't see a way to do that. Hasn't been one as far as I know in
previous versions. Just be a handy feature.

 

Happy New Year,

Roger

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Maf. King]

just a thought.  Create the Quote outside GC, then iff the quote is accepted, 
import into GC?  ISTR that it may be possible to CSV import an invoice?

Best wishes for 2022,
Maf.



On Wednesday, 29 December 2021 13:00:30 GMT 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 number to something like 'use next' if you made an error
> > creating it)
> 
> If the invoice can not be deleted before posting, that would probably mean
> it is unsuitable for use in the UK, as I believe invoice numbers have to be
> created sequentially.  One should *not* have invoice numbers of 1, 2, 4, 7
> etc.
> 
> > The Business Features originally were created by a dev for their own
> > limited use case. Some UI improvements and bug fixes have been made over
> > the years, but the functionality hasn't really been expanded much for
> > some time. (I think Credit Notes being added was the last major change
> > and that was way back in 2.4.x or early 2.6.x)
> 
> The user interface is obviously important, but the lack of some basic
> functionality is annoying.
> 
> The other thing that I would like (support for crypto currencies) is
> something that I expect I could easily add to the source code myself. But
> there’s no way I could add the invoice/proforma invoice, is not something
> that I am going to be able to do.
> 
> I will have a look around and see if other open-source software that might
> meet my needs better.
> 
> I think the ability to convert a quotation into an invoice, *and also to a
> proforma invoice*, is pretty is pretty important.
> 
> > Regards,
> > Adrien
> 
> Dave




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[Dr. David Kirkby]

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 number to something like 'use next' if you made an error
> creating it)


If the invoice can not be deleted before posting, that would probably mean
it is unsuitable for use in the UK, as I believe invoice numbers have to be
created sequentially.  One should *not* have invoice numbers of 1, 2, 4, 7
etc.


> The Business Features originally were created by a dev for their own
> limited use case. Some UI improvements and bug fixes have been made over
> the years, but the functionality hasn't really been expanded much for
> some time. (I think Credit Notes being added was the last major change
> and that was way back in 2.4.x or early 2.6.x)


The user interface is obviously important, but the lack of some basic
functionality is annoying.

The other thing that I would like (support for crypto currencies) is
something that I expect I could easily add to the source code myself. But
there’s no way I could add the invoice/proforma invoice, is not something
that I am going to be able to do.

I will have a look around and see if other open-source software that might
meet my needs better.

I think the ability to convert a quotation into an invoice, *and also to a
proforma invoice*, is pretty is pretty important.

>
> Regards,
> Adrien


Dave
-- 
Dr. David Kirkby,
Kirkby Microwave Ltd,
drkir...@kirkbymicrowave.co.uk
https://www.kirkbymicrowave.co.uk/
Telephone 01621-680100./ +44 1621 680100

Registered in England & Wales, company number 08914892.
Registered office:
Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
Kingdom
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.