Re: [GNC] Vendor posting

[sunfish62--- via gnucash-user]

All of which begs the questions that Derek asked earlier: do you have accounts 
of *type* A/P and A/R, and are they in the proper currency?

⁣David T.​

On Sep 10, 2024, 9:05 AM, at 9:05 AM, David Cousens  
wrote:
>Heidi,
>
>The invoice/bill dialogue automatically posts an invoice or bill to
>Accounts Receivable or Accounts Payable respectively. The account you
>are required to select in the dialogue is the appropriate income
>account for an invoice  or expense account for a bill  and then fill in
>the rest of the detail. The dialogue then creates a transaction which
>debits the Accounts Payable account and credits the Expense account
>selected.  The system is designed to only have a single accounts
>receivable and a single accounts payable which is why there is no
>selection.
>
>Justa couple of points on the mailing list etiquette: 
>Always address emails to the GnuCash mailing list to gnucash-
>u...@gnucash.org ;
>It is not kosher unless requested specifically to send emails to
>individuals who reply to the mailing list;
>For a new query/problem use a new subject heading rather than reply to
>either a digest heading or a  topic thread on another heading.
>Your email client should have a Reply to List  or Reply to All
>selection which normally does this but you may have to work out exactly
>what your client is doing.  Ideally there should only be gnucash-
>u...@gnucash.org in the To field.
>
>Other helpful info to include in a help request is the GnuCash Version
>(Help->About ) and the Operating system and version for your computer.
>I don't know if that was in tour original request or not.
>
>cheers
>
>David
>
>
>On Mon, 2024-09-09 at 19:44 -0400, halatch1008 wrote:
>> David, 
>>  In the dialog box when it says "do u really want to post"? Where it
>> says " post to account", "Liabilities:accts.payable" is suppose to
>> automatically show up there. Mine does NOT, nothing shows up there.
>> And when I click on the little arrow that should make the chart of
>> accounts show up. They don't either.
>> This is my problem. I know how to Enter vendor bills. But cannot get
>> it to post to the Liab/access pay. Account. Can U help?
>> Thanks,
>> HEIDI 
>> Sent from my Verizon, Samsung Galaxy smartphone
>> 
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Recommendations for hosting gnucash file - Google Drive, ? Microsoft 365, Local server?

[Robert Heller]

I have a RPi 5 with a M.2 SSD (using the mini-pci interface).  It is quite
fast.  I also have another drive (rotating rust) on a USB-SATA interface and
it is fast enough.

At Tue, 10 Sep 2024 06:49:28 +0300 "sunfis...@yahoo.com"  
wrote:

>
> Can't resist noting that using a Raspberry Pi in this way can be very slow. 
> Using USB for file transfer and storage is a bottleneck that loses its luster 
> after a time.
>
> ⁣David T. ​
>
> On Sep 10, 2024, 2:31 AM, at 2:31 AM, Kalpesh Patel 
>  wrote:
> >Raspberry PI can handle USB drives no problem -- get an externally
> >powered one, possibly hardware raid type one . You can load up NTFS
> >package for it and share it out as CIFS which would be equivalent of a
> >NAS box.
> >
> >-Original Message-
> >From: Bruce Griffis 
> >Sent: Monday, September 09, 2024 4:09 PM
> >To: Kalpesh Patel ; gnucash-user@gnucash.org
> >Subject: Re: [GNC] Recommendations for hosting gnucash file - Google
> >Drive, Microsoft 365, Local server?
> >
> >I'll need to take a closer look at CryptSync. I did go and install
> >syncthing and am synchronizing GnuCash files for my family, my mom (I'm
> >her Power of Attorney) and an eBay side hustle. Three sets of books.
> >Three completely different sets of banks/credit cards/debit cards, ...
> >
> >I yoinked my GnuCash files off Google drive and Microsoft OneDrive.
> >
> >Next up is a backup solution. I back up my Ubuntu desktop to USB and my
> >Win11 laptop to OneDrive. I have a Raspberry PI 3B in a little
> >enclosure setting unused. I have a tablet style display for it, and a
> >USB drive to connect to it. I need to fire it up and see if it can
> >power a traditional USB drive. I also have an SSD drive, but don't
> >really trust that for long term use as a backup. Alternatively, I could
> >just buy a NAS.
> >
> >I want to get away from Google Drive and Microsoft OneDrive for
> >sensitive files.
> >
> >On 9/8/24 09:46, Kalpesh Patel wrote:
> >> If you are paranoid about cloud provider snooping into your files and
> >folders when storing data in the cloud, please look into excellent open
> >source tool called CryptSync
> >(https://tools.stefankueng.com/CryptSync.html) which I have mentioned
> >it in the past.  It works as advertised so far. I do not rely on
> >anyone's word once that data leaves my control as they can change their
> >prerogative at their whims. I've been in IT world far too long to know
> >this for sure, sadly!
> >>
> >> (snip)
> >
> >
> >___
> >gnucash-user mailing list
> >gnucash-user@gnucash.org
> >To update your subscription preferences or to unsubscribe:
> >https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >-
> >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
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>

--
Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] New Australian user questions

[Kevin Buckley via gnucash-user]

On Sunday, September 8th, 2024 at 11:40, Megan Tilley  
wrote:
> 
> 
> This email failed anti-phishing checks when it was received by SimpleLogin, 
> be careful with its content.
> More info on https://simplelogin.io/docs/getting-started/anti-phishing/
> 
> --
> Hi everyone!
> 
> You all appear to have a good handle on GnuCash, but I am a brand newbie!!!
> 
> My environment is:
> Local Currency: Australian Dollar (AUD)
> Exchange Rates required for:
> == USD
> == GBP (UK)
> == EUR
> == SEK (Sweden)
> - and are usually purchases that I pass through Paypal (no balance in
> Paypal, at all) => buy with AUD and currency conversion made by Paypal into
> seller's currency
> All my investments are AUD

Hi Megan,

the following comes from my tracking of a "multi-currency" card in GnuCash,
though I can't speak to the "windows" side of your environment.


One way to handle this sort of thing, or at least one thing to try out to 
see if it works for you, would be to create a "top level" Asset account 
called

Paypal

Then create sub-accounts below that called 

AUD Balance
GBP Balance
EUR Balance
SEK Balance

each with the Security/Currency set to to be the "foreign" Currency.


Beneath the top-level Expenses account, similarly create accounts
such as

Forex Purchases EUR
Forex Purchases GBP
Forex Purchases SEK

again with the relevant Security/Currency.

Now, when you make. say, a "Forex Purchases SEK" purchase, you could
withdraw the money from the 

Assets::Paypal::SEK Balance

which would be a Transaction (TXN) soley enacted in SEK. but which 
would leave you needing to "move" some AUD into the SEK Balance, so
as to leave that as 0.00) at which point you would be able to record
the AUD-SEK exchange rate.

You might not even need the 

Assets::Paypal::AUD Balance

account, depending on where you withdraw the AUD monies that go via
Paypal, but, having that account as a "staging" account might help
you keep track.

As I say, set up a test Gnucash file an play around

Depending on which currency Paypal deduct their fees in, you might
also want/need to create Expense accounts for, say 

Forex Fees AUD
Forex Fees EUR
Forex Fees GBP
Forex Fees SEK

and play around with a few TXNs to see if you think that lets you
keep a better record of where your money went.

HTH


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Regular Expressions in Reports

[Grace]

I'm forgetting everything I used to know.

Can someone point me to where I can find out how to filter by regular 
expressions in the transaction report option.


Many thanks,

Grace.


--
This email has been checked for viruses by Avast antivirus software.
www.avast.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] New Australian user questions

[R Losey]

My answers are interspersed with your questions (well, some of your
questions)




On Mon, Sep 9, 2024 at 5:09 PM Megan Tilley  wrote:

> Hi everyone!
>
> My environment is:
> Local Currency: Australian Dollar (AUD)
> Exchange Rates required for:
> == USD
> == GBP (UK)
> == EUR
> == SEK (Sweden)
> - and are usually purchases that I pass through Paypal (no balance in
> Paypal, at all) => buy with AUD and currency conversion made by Paypal into
> seller's currency
> All my investments are AUD
>

I have a similar setup, but in USD. I just do everything in USD - when I
purchase something that is 39.99 AUD, once it gets charged to my bank
account or credit card, it will be in USD, and I enter it that way, usually
with a note in the Memo about what I paid in the "other" currency.

I don't know that I can add much to the other responses.


> As I was hoping to initiate the automatic updates for Banking balances,
> stock prices and currency rates, I followed the instructions and ran the
> AqBanking Setup, but nothing happened as I could not get the Help button to
> operate in GC === terminology between the US and Australia is significantly
> different so I could not figure out the corollaries between my
> understanding of Australian banking terms and what appears in the AqBanking
> window (Ids and Bank Codes, etc.)
>

I used this back when I used Quicken, and it was handy, for those
institutions that supported it. It seemed more complex to get going in
GnuCash, so I decided not to use it... that was 7 years ago, and I have not
missed this feature.



> I moved on to Finance::Quote (F::Q) and followed the instructions to set up
> Quote Retrieval (
> https://www.gnucash.org/docs/v5/C/gnucash-manual/finance-quote.html) in
> the
> "Procedure 11.3. On Windows" the instructions stated to "run the program
> Install Online Price Retrieval for GnuCash" which I found in my
> installation data under "C:\Program Files
> (x86)\gnucash\bin\install-fq-mods.cmd".
>

This is something I've tried to get working on my Windows machine and on my
iMac; the only machine that has done this simply and easily is my Linux
machine (Ubuntu 22.04). I have been able to get them working for a while on
Windows and/or iMac, but then something breaks. I finally decided that I
can get by just fine without this feature... the places I have investments
have tools to show good price history.


I have used Quicken and Quicken Home & Business for over 25 years, so I am
> very used to that data structure. I spend something and one account goes
> down in value and I acquire an asset - a coat, for example.
> I understand that GC is a double-entry bookkeeping program, each
> transaction has an accompanying transaction in another account. However, I
> am very unsure where in the account register the transaction should be put
> to "buy" the coat = in Quicken it is a Debit (out of my pocket) in the
> Debit column of the Banking account.
>

I'll probably get accused of heresy by the GnuCash faithful, but, to be
honest, I didn't really see a difference (from the user perspective) in
entering transactions in Quicken and GnuCash. Every transaction in Quicken
needs a "category" to record the income or expense.  GnuCash isn't that
different, but they use accounts instead of categories. A simple
transaction, such as purchasing a coat on a credit card is the same in
both: Your credit card balance (what you owe) goes up and the
Expenses:Clothing account (GnuCash) / category (Quicken) increases by that
amount.  (I know that categories and accounts are different; I am talking
about what is done to enter a transaction appears to be very similar in
both GnuCash and Quicken).


Question 4: Which perspective should I adopt when looking at a transaction?
> I stand in my account and pay out using the Debit column, or I stand in the
> Coat account and use the debit column (correspondingly, the bank account is
> the credit column)?
>

If you find the Debits/Credits labels confusing, you may went to go into
the Preferences (maybe Settings?), go to the "Accounts"  area and UN-check
the "Use formal accounting labels"

All accounts have DEBITs and CREDITs in that order. For the coat
transaction above, it is a DEBIT (first column) to the Expense:Clothing
account and a CREDIT (second column) to your credit card (or bank account,
if you used a debit card or check).



Further to this last, as I said, I use Paypal as a pass through conversion
> channel- my Aussie bank account is used to pay for an item in a US market
> (NOT an investment/shares/stocks) - say, a 'Reference Book'. I know that I
> have to have 3 entries in a transaction: origin (Aussie Bank account), into
> Paypal as AUD, conversion by Paypal to USD, payment to US company for my
> 'Reference Book'. Referring to Question 4 :-
>

As I noted above, I just enter the transaction as if I'd made it in AUD,
with (usually) a entry in the "Notes" as to what I paid in the other
currency.


-- 
_
Richard

Re: [GNC] Recommendations for hosting gnucash file - Google Drive, Microsoft 365, Local server?

[R Losey]

Well, but think about it... after the password is entered, THEN what? The
"correct" password would have to be stored somewhere so that GnuCash could
verify what is entered is correct, and clearly saving the password in clear
text is not secure. Because the software is open source, anyone could read
the steps taken to secure the password, and that would be a huge help in
breaking the password.


On Mon, Sep 9, 2024 at 5:35 PM David G. Pickett via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Nobody suggested putting a password in gnucash, just a pop up dialog to
> ask the user for it.
>

-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] New Australian user questions

[sunfish62--- via gnucash-user]

If it were me, I'd just register everything in AUD, as an earlier person 
suggested. If everything comes through PayPal as AUD, why engage in this 
complexity? Is there a compelling reason to track costs in the original 
currencies? 

Having lived in a number of different countries around the world, I've only 
created native currency accounts for a very limited number of things, things 
where I was paying out in a local currency from a local currency-denominated 
account, such as a local bank account. That just makes reconciling a little 
easier. 

Transactions from my native currency to a local currency (e.g., when I buy 
something in a local store but use my native credit card) I register only in 
the native currency. 

Is there something I'm missing here? 

⁣David T. ​

On Sep 10, 2024, 1:45 PM, at 1:45 PM, Kevin Buckley via gnucash-user 
 wrote:
>On Sunday, September 8th, 2024 at 11:40, Megan Tilley
> wrote:
>> 
>> 
>> This email failed anti-phishing checks when it was received by
>SimpleLogin, be careful with its content.
>> More info on
>https://simplelogin.io/docs/getting-started/anti-phishing/
>> 
>> --
>> Hi everyone!
>> 
>> You all appear to have a good handle on GnuCash, but I am a brand
>newbie!!!
>> 
>> My environment is:
>> Local Currency: Australian Dollar (AUD)
>> Exchange Rates required for:
>> == USD
>> == GBP (UK)
>> == EUR
>> == SEK (Sweden)
>> - and are usually purchases that I pass through Paypal (no balance in
>> Paypal, at all) => buy with AUD and currency conversion made by
>Paypal into
>> seller's currency
>> All my investments are AUD
>
>Hi Megan,
>
>the following comes from my tracking of a "multi-currency" card in
>GnuCash,
>though I can't speak to the "windows" side of your environment.
>
>
>One way to handle this sort of thing, or at least one thing to try out
>to 
>see if it works for you, would be to create a "top level" Asset account
>
>called
>
>Paypal
>
>Then create sub-accounts below that called 
>
>AUD Balance
>GBP Balance
>EUR Balance
>SEK Balance
>
>each with the Security/Currency set to to be the "foreign" Currency.
>
>
>Beneath the top-level Expenses account, similarly create accounts
>such as
>
>Forex Purchases EUR
>Forex Purchases GBP
>Forex Purchases SEK
>
>again with the relevant Security/Currency.
>
>Now, when you make. say, a "Forex Purchases SEK" purchase, you could
>withdraw the money from the 
>
>Assets::Paypal::SEK Balance
>
>which would be a Transaction (TXN) soley enacted in SEK. but which 
>would leave you needing to "move" some AUD into the SEK Balance, so
>as to leave that as 0.00) at which point you would be able to record
>the AUD-SEK exchange rate.
>
>You might not even need the 
>
>Assets::Paypal::AUD Balance
>
>account, depending on where you withdraw the AUD monies that go via
>Paypal, but, having that account as a "staging" account might help
>you keep track.
>
>As I say, set up a test Gnucash file an play around
>
>Depending on which currency Paypal deduct their fees in, you might
>also want/need to create Expense accounts for, say 
>
>Forex Fees AUD
>Forex Fees EUR
>Forex Fees GBP
>Forex Fees SEK
>
>and play around with a few TXNs to see if you think that lets you
>keep a better record of where your money went.
>
>HTH
>
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Recommendations for hosting gnucash file - Google Drive, Microsoft 365, Local server?

[David G. Pickett via gnucash-user]

 Of course you need to select an algorithm in a compatible library, of which 
there are many.  I was just responding to the idea that a unchanging common 
password would be hard coded is open source, a very odd idea.  If you used 
triple DES, for example, all the open source would show is that you used triple 
DES and got a password from the console.

I have coded things like this, and found several ways to keep the password out 
of the code, like asking the user for it at the start.  GnuCash would hold it 
for use when it saved, so I suppose you might find it in a crash dump file, if 
it crashed, and a core dump was generated, and that got shared into an 
untrusted space, like with a shared folder as current working directory.
On Monday, September 9, 2024 at 09:34:38 PM EDT, David Carlson 
 wrote:   

 Not just a pop-up.  All the security stuff would have to be added too, and the 
developers have made it abundantly clear that they do not want to do that when 
a huge development effort would be required to do it right.  From the rest of 
this thread you can see that no size fits all anyway.  They are confident that 
we users can find a solution outside of their bailiwick.


On Mon, Sep 9, 2024 at 5:35 PM David G. Pickett via gnucash-user 
 wrote:

Nobody suggested putting a password in gnucash, just a pop up dialog to ask the 
user for it.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Recommendations for hosting gnucash file - Google Drive, Microsoft 365, Local server?

[David G. Pickett via gnucash-user]

 Generally when you type in a password to anything, it is stored in a variable 
in memory, virtual memory, possibly written to swap space, but those memory and 
disk spaces are protected and ephemeral, so there is no easy access to them and 
even then, they are hard to decipher.
In theory, one could encrypt it using a one-session generated random password 
just to make it hard to find in a core dump file or if someone cared to search 
your swap file pages.  Then at write time during that same session, it can be 
decrypted for use.  Many encryption systems actually digest the password into 
binary keys and discard it.  I am no expert, as this is a fast evolving area.

Since we all type in passwords all day, there are industry standards one can 
follow on how to acquire them, store them, use them.
GnuCash might also want a password after any period of inactivity, to protect 
your data from house guests and the like.  While PCs tend to promise this, I 
see them not timing out oh so often.  Web sites often do this.


On Tuesday, September 10, 2024 at 03:09:24 PM EDT, R Losey 
 wrote:   

 Well, but think about it... after the password is entered, THEN what? The 
"correct" password would have to be stored somewhere so that GnuCash could 
verify what is entered is correct, and clearly saving the password in clear 
text is not secure. Because the software is open source, anyone could read the 
steps taken to secure the password, and that would be a huge help in breaking 
the password.

On Mon, Sep 9, 2024 at 5:35 PM David G. Pickett via gnucash-user 
 wrote:

Nobody suggested putting a password in gnucash, just a pop up dialog to ask the 
user for it.


-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Vendor posting problem

[David Cousens]

Heidi,

Please don't reply to my direct email address, but send your reply to
gnucash-user@gnucash.org. It will reach me through the mailing list in
any case. Your message will not reach the mailing list unless you do
this.  While it can be confusing to deal with replies from multiple
people, it usually helps to sort out difficulties more rapidly as you
get access to a wider range of expertise and experience. 
  
It will also pay to send answers to any questions asked particularly by
Derek (or John Ralls or Geert Janssens ) as Derek was the major
developer of the business features and Derek, John and Geert are the
core of the development team for GnuCash but also fairly busy. 

If there is no account for selection in the Post to Account part of the
dialog then it is likely you have a problem with the account setup.
Then as Derek asked earlier do you have an Accounts Payable account and
what currency is it setup with? Is it the same as your default currency
for the book?

To find out, if you go to the Accounts tab in the main window, if you
have created Accounts Payable and Accounts Receivable, they normally
appear as the first two accounts in the displayed chart of accounts. 

If you do see AccountsPayable and Accounts Receivable on the Accounts
tab, if you didn't set them up with the Actions->New File Heirarchy
menu item (it is normally run automatically during the initial GnuCash
setup) and you have created the Accounts Payable and Accounts
Receivable manually, they may not be setup correctly which would
explain why they don't appear in the dialogue.  

If you right click on the Accounts Payable in the accounts tab you will
get a drop down menu. Select Edit Account from that.  In the dialogue
box check that the Parent Account is set to "New Top Level Account"
(and not Asset Account), the account type is set to "A/Payable" and the
correct currency is chosen. The Accounts Receivable has the same
setting for Parent Account  and account type is "A/Receivable".

If they don't exist there then you have likely not set up the business
features in Gnucash. 

In which case clickon  the Actions-> New Account Heirarchy  menu item
to run a dialog In the third step in the dialogue make sure the
Business Accounts checkbox is selected.  You may want to select other
accounts which may be relevant to your situation as well, if you
haven't done this previously.

David Cousens

On Tue, 2024-09-10 at 09:26 -0400, halatch1008 wrote:
> DAVID,
>  In "dialog box" NOTHING comes up in "post to Acct" it's BLANK, & u
> can NOT scroll down to search for Liabilities/Accts.Payable.
> Heidi
> 
> 
> 
> Sent from my Verizon, Samsung Galaxy smartphone
> 
> 
>  Original message 
> From: David Cousens  
> Date: 9/10/24 2:04 AM (GMT-05:00) 
> To: halatch1008 , gnucash-user@gnucash.org 
> Subject: Re: Vendor posting 
> 
> Heidi,
> 
> The invoice/bill dialogue automatically posts an invoice or bill to
> Accounts Receivable or Accounts Payable respectively. The account you
> are required to select in the dialogue is the appropriate income
> account for an invoice  or expense account for a bill  and then fill
> in
> the rest of the detail. The dialogue then creates a transaction which
> debits the Accounts Payable account and credits the Expense account
> selected.  The system is designed to only have a single accounts
> receivable and a single accounts payable which is why there is no
> selection.
> 
> Justa couple of points on the mailing list etiquette: 
> Always address emails to the GnuCash mailing list to gnucash-
> u...@gnucash.org ;
> It is not kosher unless requested specifically to send emails to
> individuals who reply to the mailing list;
> For a new query/problem use a new subject heading rather than reply
> to
> either a digest heading or a  topic thread on another heading.
> Your email client should have a Reply to List  or Reply to All
> selection which normally does this but you may have to work out
> exactly
> what your client is doing.  Ideally there should only be gnucash-
> u...@gnucash.org in the To field.
> 
> Other helpful info to include in a help request is the GnuCash
> Version
> (Help->About ) and the Operating system and version for your
> computer.
> I don't know if that was in tour original request or not.
> 
> cheers
> 
> David
> 
> 
> On Mon, 2024-09-09 at 19:44 -0400, halatch1008 wrote:
> > David, 
> >  In the dialog box when it says "do u really want to post"? Where
> > it
> > says " post to account", "Liabilities:accts.payable" is suppose to
> > automatically show up there. Mine does NOT, nothing shows up there.
> > And when I click on the little arrow that should make the chart of
> > accounts show up. They don't either.
> > This is my problem. I know how to Enter vendor bills. But cannot
> > get
> > it to post to the Liab/access pay. Account. Can U help?
> > Thanks,
> > HEIDI 
> > Sent from my Verizon, Samsung Galaxy smartphone
> > 
> 

___
gnucash-u

Re: [GNC] New Australian user questions

[Megan Tilley]

Stephen and Geoff - thank you so much for such comprehensive answers
and yes, I am currently re-reading my Finance Textbooks to refresh my
memory of Double-Entry bookkeeping! The issue, I think, is that Quicken
really dumbed down my comprehension because it handled the double-entry
stuff behind the scenes.

Your responses have alleviated my stress considerably and I am now able to
view my situation much more clearly.

Removing the need to record exchange rates is a great benefit to me and I
believe I confused myself when reading the manual/help guides. Having you
both indicate an easier way is a relief.

I look forward to any other assistance given me under this topic!!!


Thank you again!



Megan Tilley


On Sun, 8 Sept 2024 at 13:40, Megan Tilley  wrote:

> Hi everyone!
>
> You all appear to have a good handle on GnuCash, but I am a brand newbie!!!
>
> My environment is:
> Local Currency: Australian Dollar (AUD)
> Exchange Rates required for:
> == USD
> == GBP (UK)
> == EUR
> == SEK (Sweden)
> - and are usually purchases that I pass through Paypal (no balance in
> Paypal, at all) => buy with AUD and currency conversion made by Paypal into
> seller's currency
> All my investments are AUD
>
> Computer info:
> --- Windows 10 Home version x64-based PC 10.0.19045 Build 19045
> --- apparently Strawberry Perl (5.40.0.1-64bit)
> --- apparently GnuCash Version: 5.6 Build ID: 5.6+(2024-03-30)
> --- and while "Finance::Quote: " appears in my "About GnuCash" help
> window, I can not see the version
>
> I downloaded the "gnucash-5.8.setup" installation executable from the
> Windows component (https://www.gnucash.org/download.phtml).
>
> As I was hoping to initiate the automatic updates for Banking balances,
> stock prices and currency rates, I followed the instructions and ran the
> AqBanking Setup, but nothing happened as I could not get the Help button to
> operate in GC === terminology between the US and Australia is significantly
> different so I could not figure out the corollaries between my
> understanding of Australian banking terms and what appears in the AqBanking
> window (Ids and Bank Codes, etc.)
>
> I moved on to Finance::Quote (F::Q) and followed the instructions to set
> up Quote Retrieval (
> https://www.gnucash.org/docs/v5/C/gnucash-manual/finance-quote.html) in
> the "Procedure 11.3. On Windows" the instructions stated to "run the
> program Install Online Price Retrieval for GnuCash" which I found in my
> installation data under "C:\Program Files
> (x86)\gnucash\bin\install-fq-mods.cmd".
>
> Guidelines indicated a long installation process: 20-30 mins. The first
> run took 45 mins and did not work at all as I interrupted it. The second
> run took 55 mins and terminated with a 'success' message but when I ran the
> module within GC I received a "finance::quote not installed properly"
> message. Apparently I have to uninstall and reinstall the entire package...
>
>
> Question 1: how do I uninstall all of this stuff?
> Question 2: What else do I have to do?
> Question 3: Can I not just reinstall over top of what I have already done?
>
>
> I have used Quicken and Quicken Home & Business for over 25 years, so I am
> very used to that data structure. I spend something and one account goes
> down in value and I acquire an asset - a coat, for example.
> I understand that GC is a double-entry bookkeeping program, each
> transaction has an accompanying transaction in another account. However, I
> am very unsure where in the account register the transaction should be put
> to "buy" the coat = in Quicken it is a Debit (out of my pocket) in the
> Debit column of the Banking account.
>
>
> Question 4: Which perspective should I adopt when looking at a
> transaction? I stand in my account and pay out using the Debit column, or I
> stand in the Coat account and use the debit column (correspondingly, the
> bank account is the credit column)?
>
>
> Further to this last, as I said, I use Paypal as a pass through conversion
> channel- my Aussie bank account is used to pay for an item in a US market
> (NOT an investment/shares/stocks) - say, a 'Reference Book'. I know that I
> have to have 3 entries in a transaction: origin (Aussie Bank account), into
> Paypal as AUD, conversion by Paypal to USD, payment to US company for my
> 'Reference Book'. Referring to Question 4 :-
>
>
> Question 5: which of the columns in the transaction should host my Aussie
> bank? Debit column or Credit Column?
> Question 6: which of the columns should reflect AUD into Paypal?
> Question 7: which of the columns should reflect USD from Paypal to the
> Book company?
> Question 8: which of the columns should reflect the Book company receiving
> my USD?
> Question 9: should I bypass Paypal completely and just use my bank account
> and the Book company?
>
>
> Question 10: how often do I need to update my GC install? - am I notified
> of a new release or do I just watch this channel?
> Question 11: how often do I need to update Strawberry Perl

Re: [GNC] New Australian user questions

[Megan Tilley]

Hi Geoff! Thank you so much for your response and between you and Stephen,
I can see that the majority of my questions have been answered.

I have uninstalled both GC and Strawberry Perl and downloaded the two
source files again from their respective sites.
GC installed quite easily, as it did the first time around.
This time, rather than go through the documentation to install SP, I did
the install from the Strawberry Perl site, which did go a lot faster this
time around.

However, on starting GC up again and moving to the Security Tools/Edit
Security to update one of my Stocks, the Warning message "Warning:
Finance::Quote not installed properly." and the Get Online Quotes is
undetectable.

In scouring the message threads for an inkling of how to install F::Q I did
find a lot of similar problems listed for Apple/Mac users which sadly does
not help me as a Windows user.

I tried a solution suggested on an August 2024 message
https://lists.gnucash.org/pipermail/gnucash-user/2023-August/108274.html

which suggested trying *gnucash-cli* to check if there is an issue ---
Powershell produced this
PS C:\Users\kurri> gnucash-cli --quotes dump asx BHP
Price retrieval failed: Failed to initialize Finance::Quote:
missing_modules Finance::Quote

So I am assuming I need to load F::Q as a separate upload as the "Install
Online Price Retrieval for GnuCash" process did not appear to load it.
It would be great if a search produced a succinct response that addressed
"how to install F::Q in a Windows environment" without segueing into
computer speech using greps and such.

Any pointers you can give me?


-- 
Regards,


Megan Tilley
megan.til...@gmail.com
0409 949 717

---
"He who laughs last probably made a backup."
---



On Tue, 10 Sept 2024 at 10:53, Geoff  wrote:

> Hi Megan
>
> Welcome to the wonderful world of GnuCash!  IMHO it will certainly
> deliver what you are seeking, once you have made the mindshift leap to
> double entry book keeping :--))
>
> Further to Stephen M. Butler's excellent response, here are some
> additional answers.
>
>  > Question 1: how do I uninstall all of this stuff?
> Open the Windows Control Panel, navigate to "Programs and Features",
> scroll to find GnuCash, right click and select "Uninstall" - see
> attached screenshot: gnc_uninstall.jpg
>
>  > Question 2: What else do I have to do?
> When you have uninstalled both GnuCash and Strawberry Perl, reinstall them.
>
>  > Question 3: Can I not just reinstall over top of what I have already
>  > done?
> Yes you can.
>
>  > Question 10: how often do I need to update my GC install?
> It is entirely up to you. Some people like to always be on the very
> latest release, others prefer to minimise change in their IT lives.
> Things to consider before upgrading:
> * Does the new release have useful features?
> * Does the new release fix annoying bugs?
> * Has the new release introduced any new bugs?
>
>  > am I notified of a new release or do I just watch this channel?
> If you are subscribed to this mailing list you will be notified of new
> releases, otherwise check the GnuCash News from time to time:
> https://gnucash.org/news.phtml
>
>  > Question 11: how often do I need to update Strawberry Perl?
> Rarely. Current release is 5.40.1, I am still running 5.30.1 from 2019.
>
>  > and where do I find that?
> https://strawberryperl.com/
>
>  > Question 12: do I need to anything else regularly with respect to GC
> No, just make sure you backup your data regularly and securely.
>
>  > and the 'subroutines' used within it (F::Q, etc.)?
> Yes, because Finance::Quote obtains its data from a myriad of third
> party web sites and APIs, whenever these sources change, Finance::Quote
> may stop working.  We are then reliant on volunteers with the necessary
> skills to donate their time to troubleshoot the problem, come up with a
> fix, and release a new version of Finance::Quote.  There is usually
> discussion on this mailing list when such an event occurs.
> See also https://finance-quote.sourceforge.net/
>
>  > Question 13: how is the update process managed? How do you do an
>  > update to GC? Download and run a new version?
> Correct:
> https://gnucash.org/download.phtml
> https://wiki.gnucash.org/wiki/Installation
> There is generally no need to uninstall before upgrading.
> Note that if you are upgrading from a very old version, it may be
> necessary to do a series of incremental upgrades, for example from 3.x
> to 4.x to 5.x.
>
>  > As I was hoping to initiate the automatic updates for Banking
>  > balances, stock prices and currency rates,
> For prices of securities that are listed on the ASX, I have found the
> "Australia (ASX, ...)" quote source to be reliable - see attached
> screenshot: gnc_security_editor.jpg
>
> Finally, I concur with Stephen's advice re PayPal:
>  > But first, do you really need to handle the exchange rates into those
>  > other currencies? If there is no balance kept in Paypal and it handles
>  > all the currency conversio

Re: [GNC] New Australian user questions

[Megan Tilley]

Geoff - you little beauty bottler!!! YAY! it worked.

I assume you edited the results to the bare minimum in your instructions?

I am glad that my issue could be reproduced but sad that it requires a fix!


I could not decide whether I had to add all 3 installation commands at once
or one at a time and tried first off all 3 at once...

>>> >cpanm install Module::CPANTS::Analyse --force
2 distributions installed

>>> >cpanm install Test::Kwalitee
1 distribution installed

>>> cpanm install Finance::Quote [which I had to start with an
'enter'
24 distributions installed


So, "install Finance::Quote" was different to your results as your example
indicated "1 distribution installed" rather than the  24 distributions I
had.


I used Tools/Security Edit to check that I could select the investments.
No errors reported this time around and the 'Get Online Quotes' was
selectable, which I did, and then Multiple/ASX.
I ran the Get Quotes and there they were!
However, I did receive some error messages as though the stock was not
available on the ASX list to be updated, but that is an issue for another
thread!



Many thanks to you, and to Stephen, as I am now more comfortable using
GnuCash... No doubt you will see me back on the threads with another curly
Australian-based query!
And to R.Losey for their comments.

I am finding it easier to navigate through the morass of memories of
Quicken and translating those memories to my efforts of learning the many
benefits of GnuCash!
Not having to do that currency translation through PayPal is helping
immensely!



Megan in Sydney



On Tue, 10 Sept 2024 at 22:07, Geoff  wrote:

> Hi Megan
>
> Well, this must be frustrating for you.  I did a clean install on a new
> Windows 10 machine, can reproduce this problem, and have a fix for you
> to try.
>
> When I ran the GnuCash powershell script "gnc-fq-update.ps1" to install
> Finance::Quote, it ran for a long time (approximately 1/2 an hour) and
> failed at the end with:
>
> 
> Building and testing Spreadsheet-XLSX-0.18 ... OK
> Successfully installed Spreadsheet-XLSX-0.18
> ! Installing the dependencies failed: Module 'Test::Kwalitee' is not
> installed, Module 'Module::CPANTS::Analyse' is not installed
> ! Bailing out the installation for Finance-Quote-1.62.
> 29 distributions installed
> 
>
> To rectify this, open up a DOS Command prompt and run the following
> three commands:
>
> cpanm install Module::CPANTS::Analyse --force
> cpanm install Test::Kwalitee
> cpanm install Finance::Quote
>
> The output should look something like this:
>
> 
>  >cpanm install Module::CPANTS::Analyse --force
> --> Working on install
> Fetching
> http://www.cpan.org/authors/id/D/DA/DAGOLDEN/install-0.01.tar.gz ... OK
> Configuring install-0.01 ... OK
> Building and testing install-0.01 ... OK
> Successfully reinstalled install-0.01
> --> Working on Module::CPANTS::Analyse
> Fetching
>
> http://www.cpan.org/authors/id/I/IS/ISHIGAKI/Module-CPANTS-Analyse-1.02.tar.gz
> ... OK
> Configuring Module-CPANTS-Analyse-1.02 ... OK
> Building and testing Module-CPANTS-Analyse-1.02 ... FAIL
> ! Testing Module-CPANTS-Analyse-1.02 failed but installing it anyway.
> Successfully installed Module-CPANTS-Analyse-1.02
> 2 distributions installed
>
>  >cpanm install Test::Kwalitee
> install is up to date. (0.01)
> --> Working on Test::Kwalitee
> Fetching
> http://www.cpan.org/authors/id/E/ET/ETHER/Test-Kwalitee-1.28.tar.gz ... OK
> Configuring Test-Kwalitee-1.28 ... OK
> Building and testing Test-Kwalitee-1.28 ... OK
> Successfully installed Test-Kwalitee-1.28
> 1 distribution installed
>
> cpanm install Finance::Quote
> install is up to date. (0.01)
> --> Working on Finance::Quote
> Fetching
> http://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.62.tar.gz
> ... OK
> Configuring Finance-Quote-1.62 ... OK
> Building and testing Finance-Quote-1.62 ... OK
> Successfully installed Finance-Quote-1.62
> 1 distribution installed
> 
>
> Then start up GnuCash and you should now be able to select "Get Online
> Quotes" when you set up a new security - see attached screenshot:
> gnc_fq_asx.jpg
>
>
> Hope this works for you.
>
> Regards
>
> Geoff
> =
>
> On 10/09/2024 3:29 pm, Megan Tilley wrote:
> > Hi Geoff! Thank you so much for your response and between you and
> > Stephen, I can see that the majority of my questions have been answered.
> >
> > I have uninstalled both GC and Strawberry Perl and downloaded the two
> > source files again from their respective sites.
> > GC installed quite easily, as it did the first time around.
> > This time, rather than go through the documentation to install SP, I did
> > the install from the Strawberry Perl site, which did go a lot 

Re: [GNC] need help with Vendor post bill

[Geoff Jankowski via gnucash-user]

Hi Heidi,

You should really use reply all and not individual addresses so that the entire 
thread is visible on the mailing list as others may offer better solutions.

In order to generate the bill you must have created at least one vendor so that 
part looks to be OK. 

 If you have multiple vendors to manage you might want to consider a separate 
sub-account for each under the main Accounts Payable account to enable easier 
tracking of their invoices (bills).

If when you try to post the bill the A/C Payable line is blank and nothing 
comes up when you click on the dropdown list it is because GC is not seeing a 
valid A/C Payable account.

Go to the Accounts listing and find your A/C Payable entry.  Right click and 
select “edit account”.  This will open the dialog box for that account. At the 
bottom, is the box called “Placeholder” ticked?

If it is, this is your problem.  A/C Payable in Placeholder mode does not 
accept entries it just acts as a totaliser of all the sub accounts below it.

If this is the problem you either:

A   Untick it and use that one account as the only A/C Payable account.  
This will force all your payment liabilities into the one account which is not 
good for analysis of individual accounts or for multi currency operations.

Or

B   Set up a sub account under the Placeholder account for each of your 
vendors and make sure that the Placeholder box is not ticked for the sub 
accounts.  They will then appear in the posting dialog box correctly.

Let us know how you get on buy posting your reply to the 
gnucash-user@gnucash.org  mailbox.

Hope this solves your problem.


Geoff Jankowski
+44 20 7100 1092
+44 7770 58 48 38
+33 9 85 20 68 20
+33 6 22 93 00 53







> On 10 Sep 2024, at 15:14, halatch1008  wrote:
> 
> GEOFF,
>  Under Liabilities is sub account Accts.payable in my Chart of Accts.
> HEIDI
> 
> 
> 
> Sent from my Verizon, Samsung Galaxy smartphone
> 
> 
>  Original message 
> From: Geoff Jankowski 
> Date: 9/10/24 6:44 AM (GMT-05:00)
> To: Derek Atkins 
> Cc: Heidi Latch , gnucash-user@gnucash.org
> Subject: Re: [GNC] need help with Vendor post bill
> 
> Heidi,
> 
> Have you set up both your vendor and the accounts payable account ?  I use a 
> separate sub-account payable for each vendor. 
> 
> Geoff
> +33 6 22 93 00 53
> +44 7770 58 48 38
> 
> > On 9 Sep 2024, at 04:30, Derek Atkins  wrote:
> > 
> > Hi,
> > Do you have an account of type A/Payable?
> > And is it the correct currency, that matches your vendor currency?
> > -derek
> > Sent using my mobile device. Please excuse any typos.
> >> On September 8, 2024 19:47:22 Heidi Latch via gnucash-user 
> >>  wrote:
> >> 
> >> When I'm ready to Post my vendor bill, where it says "Do you really want 
> >> to post invoice" It says, post date, due date, description.  Where it says 
> >> "POST TO ACCOUNT",   "Liabilities: Accts Payable" is suppose to default 
> >> coming up.  It is blank. When i push the little arrow, nothing comes up??  
> >> When i try to ignore it "No account selected"comes up. Please help, I 
> >> cannot post any expenses until this gets corrected.
> >> Thanks,
> >> Heidi
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -
> >> 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
> > -
> > 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Regular Expressions in Reports

[Geoff]

Hello Grace

The Transaction Report Options screen has a "Filter" tab that lets you:

(a) Include (or exclude) Accounts by filtering on Account Name using:
(a.1) A simple string of characters (eg "tax").
or
(a.2) A regular expression - see below.

(a) Include (or exclude) Transactions by filtering on Description using:
(a.1) A simple string of characters (eg "tax").
or
(a.2) A regular expression - see below.


GunCash uses the "POSIX" dialect of regular expressions, and this 
document from IBM provides a good overview:


https://www.ibm.com/docs/en/watson-explorer/12.0.x?topic=queries-posix-regular-expression-syntax-examples

Thus:
^Tax means starts with "Tax"
^[Tt]ax means starts with "Tax" or "tax"
taxable$ means ends with "taxable"
202[0-3] means contains 2020, 2021, 2022, or 2023.

Do remember that regular expressions are CaSe sEnSiTiVe!


Hope this helps.

Geoff
=

On 11/09/2024 2:14 am, Grace wrote:

I'm forgetting everything I used to know.

Can someone point me to where I can find out how to filter by regular 
expressions in the transaction report option.


Many thanks,

Grace.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] New Australian user questions

[Geoff]

Hi Megan

Glad to hear you had a successful outcome.

The difference in results is explained by the fact that I ran the 
powershell installation script first - even though it failed at the end, 
it did successfully install most of the necessary modules.  Hence your 
24 vs my 1.


So you are good to go - happy GnuCashing!

Geoff
=

On 11/09/2024 7:56 am, Megan Tilley wrote:

Geoff - you little beauty bottler!!! YAY! it worked.

I assume you edited the results to the bare minimum in your instructions?

I am glad that my issue could be reproduced but sad that it requires a fix!


I could not decide whether I had to add all 3 installation commands at 
once or one at a time and tried first off all 3 at once...


>>> >cpanm install Module::CPANTS::Analyse --force
2 distributions installed

>>> >cpanm install Test::Kwalitee
1 distribution installed

>>> cpanm install Finance::Quote     [which I had to start with an 
'enter'

24 distributions installed


So, "install Finance::Quote" was different to your results as your 
example indicated "1 distribution installed" rather than the  24 
distributions I had.



I used Tools/Security Edit to check that I could select the investments.
No errors reported this time around and the 'Get Online Quotes' was 
selectable, which I did, and then Multiple/ASX.

I ran the Get Quotes and there they were!
However, I did receive some error messages as though the stock was not 
available on the ASX list to be updated, but that is an issue for 
another thread!




Many thanks to you, and to Stephen, as I am now more comfortable using 
GnuCash... No doubt you will see me back on the threads with another 
curly Australian-based query!

And to R.Losey for their comments.

I am finding it easier to navigate through the morass of memories of 
Quicken and translating those memories to my efforts of learning the 
many benefits of GnuCash!
Not having to do that currency translation through PayPal is helping 
immensely!




Megan in Sydney



On Tue, 10 Sept 2024 at 22:07, Geoff > wrote:


Hi Megan

Well, this must be frustrating for you.  I did a clean install on a new
Windows 10 machine, can reproduce this problem, and have a fix for you
to try.

When I ran the GnuCash powershell script "gnc-fq-update.ps1" to install
Finance::Quote, it ran for a long time (approximately 1/2 an hour) and
failed at the end with:


Building and testing Spreadsheet-XLSX-0.18 ... OK
Successfully installed Spreadsheet-XLSX-0.18
! Installing the dependencies failed: Module 'Test::Kwalitee' is not
installed, Module 'Module::CPANTS::Analyse' is not installed
! Bailing out the installation for Finance-Quote-1.62.
29 distributions installed


To rectify this, open up a DOS Command prompt and run the following
three commands:

cpanm install Module::CPANTS::Analyse --force
cpanm install Test::Kwalitee
cpanm install Finance::Quote

The output should look something like this:


  >cpanm install Module::CPANTS::Analyse --force
--> Working on install
Fetching
http://www.cpan.org/authors/id/D/DA/DAGOLDEN/install-0.01.tar.gz

... OK
Configuring install-0.01 ... OK
Building and testing install-0.01 ... OK
Successfully reinstalled install-0.01
--> Working on Module::CPANTS::Analyse
Fetching
http://www.cpan.org/authors/id/I/IS/ISHIGAKI/Module-CPANTS-Analyse-1.02.tar.gz 

... OK
Configuring Module-CPANTS-Analyse-1.02 ... OK
Building and testing Module-CPANTS-Analyse-1.02 ... FAIL
! Testing Module-CPANTS-Analyse-1.02 failed but installing it anyway.
Successfully installed Module-CPANTS-Analyse-1.02
2 distributions installed

  >cpanm install Test::Kwalitee
install is up to date. (0.01)
--> Working on Test::Kwalitee
Fetching
http://www.cpan.org/authors/id/E/ET/ETHER/Test-Kwalitee-1.28.tar.gz
 ... OK
Configuring Test-Kwalitee-1.28 ... OK
Building and testing Test-Kwalitee-1.28 ... OK
Successfully installed Test-Kwalitee-1.28
1 distribution installed

cpanm install Finance::Quote
install is up to date. (0.01)
--> Working on Finance::Quote
Fetching
http://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.62.tar.gz 

... OK
Configuring Finance-Quote-1.62 ... OK
Building and testing Finance-Quote-1.62 ... OK
Successfully installed Finance-Quote-1.62
1 dist

Re: [GNC] Question off-list

[Geoff]

Hi Megan

Please always post to the list.  This is one of the friendliest groups 
of strangers you will never meet, and you won't be flamed for asking.


I don't know how the list membership is managed, but hopefully someone 
else can respond.


Regards

Geoff
=

On 11/09/2024 8:01 am, Megan Tilley wrote:

Hi Geoff - can you answer a list question for me as a user?

I applied for membership to the thread using the 'create an account' 
process with username and password, but I note that because I sent my 
initial message while awaiting acknowledgement of membership, my message 
is still being moderated with the reason "Post by non-member to a 
members-only list"


Will that status ever change? or does every poster regardless of 
membership get the same on their email list?


Thanks!


--
Regards,


Megan Tilley
megan.til...@gmail.com 


---
"He who laughs last probably made a backup."
---


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Workaround for Finance::Quote 1.62 Installation Problem (Windows)

[Geoff]

Folks

I am documenting this workaround for a problem encountered installing 
Finance::Quote.  I have only tested this on Windows, but it should also 
work on other operating systems.


When I ran the GnuCash powershell script "gnc-fq-update.ps1" to install 
Finance::Quote, it ran for quite a long time (approximately 1/2 an hour, 
and this is to be expected) and failed at the end with:



Building and testing Spreadsheet-XLSX-0.18 ... OK
Successfully installed Spreadsheet-XLSX-0.18
! Installing the dependencies failed: Module 'Test::Kwalitee' is not 
installed, Module 'Module::CPANTS::Analyse' is not installed

! Bailing out the installation for Finance-Quote-1.62.
29 distributions installed


To rectify this, open up a Command prompt and run the following three 
commands:


cpanm install Module::CPANTS::Analyse --force
cpanm install Test::Kwalitee
cpanm install Finance::Quote

The output should look something like this:


>cpanm install Module::CPANTS::Analyse --force
--> Working on install
Fetching 
http://www.cpan.org/authors/id/D/DA/DAGOLDEN/install-0.01.tar.gz ... OK

Configuring install-0.01 ... OK
Building and testing install-0.01 ... OK
Successfully reinstalled install-0.01
--> Working on Module::CPANTS::Analyse
Fetching 
http://www.cpan.org/authors/id/I/IS/ISHIGAKI/Module-CPANTS-Analyse-1.02.tar.gz 
... OK

Configuring Module-CPANTS-Analyse-1.02 ... OK
Building and testing Module-CPANTS-Analyse-1.02 ... FAIL
! Testing Module-CPANTS-Analyse-1.02 failed but installing it anyway.
Successfully installed Module-CPANTS-Analyse-1.02
2 distributions installed

>cpanm install Test::Kwalitee
install is up to date. (0.01)
--> Working on Test::Kwalitee
Fetching 
http://www.cpan.org/authors/id/E/ET/ETHER/Test-Kwalitee-1.28.tar.gz ... OK

Configuring Test-Kwalitee-1.28 ... OK
Building and testing Test-Kwalitee-1.28 ... OK
Successfully installed Test-Kwalitee-1.28
1 distribution installed

>cpanm install Finance::Quote
install is up to date. (0.01)
--> Working on Finance::Quote
Fetching 
http://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.62.tar.gz 
... OK

Configuring Finance-Quote-1.62 ... OK
Building and testing Finance-Quote-1.62 ... OK
Successfully installed Finance-Quote-1.62
1 distribution installed



So what does all this gobbledygook actually mean?
GnuCash uses a piece of open source software called "Finance::Quote" to 
get exchange rates and stock/share/security prices.  This software is 
written in a programming language called "perl", and is maintained by a 
separate group of developers unrelated to the GnuCash team.  Such 
anonymous cooperation is what makes the open source software world so 
powerful.  Anyway, one of the software modules that Finance::Quote 
depends upon (Module::CPANTS::Analyse) failed its self tests when it was 
installed.  This workaround (using the perl "cpanm" command) forces it 
to ignore the self tests and install itself anyway.  Doing this then 
enables all the rest of the Finance::Quote dependencies to be installed 
successfully, which in turn means that you can use GnuCash to get 
exchange rates and stock/share/security prices.



Geoff
=
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] need help with Vendor post bill

[sunfish62--- via gnucash-user]

Geoff,

I believe that the business features allow tracking by vendor *without* using 
the multiple accounts you mention. Others might be able to confirm this better 
than I, though. 

⁣David T. ​

On Sep 11, 2024, 3:15 AM, at 3:15 AM, Geoff Jankowski via gnucash-user 
 wrote:
>Hi Heidi,
>
>You should really use reply all and not individual addresses so that
>the entire thread is visible on the mailing list as others may offer
>better solutions.
>
>In order to generate the bill you must have created at least one vendor
>so that part looks to be OK. 
>
>If you have multiple vendors to manage you might want to consider a
>separate sub-account for each under the main Accounts Payable account
>to enable easier tracking of their invoices (bills).
>
>If when you try to post the bill the A/C Payable line is blank and
>nothing comes up when you click on the dropdown list it is because GC
>is not seeing a valid A/C Payable account.
>
>Go to the Accounts listing and find your A/C Payable entry.  Right
>click and select “edit account”.  This will open the dialog box for
>that account. At the bottom, is the box called “Placeholder” ticked?
>
>If it is, this is your problem.  A/C Payable in Placeholder mode does
>not accept entries it just acts as a totaliser of all the sub accounts
>below it.
>
>If this is the problem you either:
>
>A  Untick it and use that one account as the only A/C Payable account. 
>This will force all your payment liabilities into the one account which
>is not good for analysis of individual accounts or for multi currency
>operations.
>
>Or
>
>B  Set up a sub account under the Placeholder account for each of your
>vendors and make sure that the Placeholder box is not ticked for the
>sub accounts.  They will then appear in the posting dialog box
>correctly.
>
>Let us know how you get on buy posting your reply to the
>gnucash-user@gnucash.org  mailbox.
>
>Hope this solves your problem.
>
>
>Geoff Jankowski
>+44 20 7100 1092
>+44 7770 58 48 38
>+33 9 85 20 68 20
>+33 6 22 93 00 53
>
>
>
>
>
>
>
>> On 10 Sep 2024, at 15:14, halatch1008 
>wrote:
>> 
>> GEOFF,
>>  Under Liabilities is sub account Accts.payable in my Chart of Accts.
>> HEIDI
>> 
>> 
>> 
>> Sent from my Verizon, Samsung Galaxy smartphone
>> 
>> 
>>  Original message 
>> From: Geoff Jankowski 
>> Date: 9/10/24 6:44 AM (GMT-05:00)
>> To: Derek Atkins 
>> Cc: Heidi Latch , gnucash-user@gnucash.org
>> Subject: Re: [GNC] need help with Vendor post bill
>> 
>> Heidi,
>> 
>> Have you set up both your vendor and the accounts payable account ? 
>I use a separate sub-account payable for each vendor. 
>> 
>> Geoff
>> +33 6 22 93 00 53
>> +44 7770 58 48 38
>> 
>> > On 9 Sep 2024, at 04:30, Derek Atkins  wrote:
>> > 
>> > Hi,
>> > Do you have an account of type A/Payable?
>> > And is it the correct currency, that matches your vendor currency?
>> > -derek
>> > Sent using my mobile device. Please excuse any typos.
>> >> On September 8, 2024 19:47:22 Heidi Latch via gnucash-user
> wrote:
>> >> 
>> >> When I'm ready to Post my vendor bill, where it says "Do you
>really want to post invoice" It says, post date, due date, description.
>Where it says "POST TO ACCOUNT",   "Liabilities: Accts Payable" is
>suppose to default coming up.  It is blank. When i push the little
>arrow, nothing comes up??  When i try to ignore it "No account
>selected"comes up. Please help, I cannot post any expenses until this
>gets corrected.
>> >> Thanks,
>> >> Heidi
>> >> ___
>> >> gnucash-user mailing list
>> >> gnucash-user@gnucash.org
>> >> To update your subscription preferences or to unsubscribe:
>> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> >> -
>> >> 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
>> > -
>> > 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
>-
>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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.