Re: [GNC] Gnucash Python Issue

2024-09-01 Thread Robin Chattopadhyay
Robin Chattopadhyay wrote: > Hi- > > After building/installing 5.8 from source, I noticed an issue with my > Python scripts that were working with 5.3 that I also built from source. > > When running gnucash from the command line or in an interactive session of > Python, I

[GNC] Gnucash Python Issue

2024-08-31 Thread Robin Chattopadhyay
Hi- After building/installing 5.8 from source, I noticed an issue with my Python scripts that were working with 5.3 that I also built from source. When running gnucash from the command line or in an interactive session of Python, I get this when trying 'import gnucash' python 3.10.12 (main, Jul

Re: [GNC] Sub-Accounting (Was: Problem with missing balance in a parent account **FINAL POST**)

2022-10-11 Thread Robin Chattopadhyay
iple institutions, > and require an entirely different view to be superimposed on the simple > tree structure accounts in GnuCash represent. The tree structure is > GnuCash is tremendously flexible, but doesn't provide for multiple views. > > -Original Message- > From

Re: [GNC] Problem with missing balance in a parent account

2022-10-09 Thread Robin Chattopadhyay
I have a substantially similar arrangement with sub-accounts under a checking account. And I also use v4.12 under Ubuntu 22.04 LTS. I suspect there are a couple of things going on: 1) When you click the Open button on the placeholder account, nothing shows up. If you want to see the consolidated b

Re: [GNC] Advancing scheduled transactions

2021-12-30 Thread Robin Chattopadhyay
This was my thought also. If you don't want the scheduled transaction to be created in advance every month, then leave it set to zero. When you do want to create early, change the create-in-advance value to a large enough value that it will create today, run the scheduled transactions, and then ad

Re: [GNC] Decimal Precision Entering Mutual Fund Transactions

2021-10-24 Thread Robin Chattopadhyay
I have created Bug #798352 https://bugs.gnucash.org/show_bug.cgi?id=798352 Thanks, Robin On Sun, Oct 24, 2021 at 4:47 PM John Ralls wrote: > > > > On Oct 24, 2021, at 2:24 PM, Robin Chattopadhyay > wrote: > > > > Hi all- > > > > SETUP: > > V

[GNC] Decimal Precision Entering Mutual Fund Transactions

2021-10-24 Thread Robin Chattopadhyay
Hi all- SETUP: Version 4.8 (plus the commit to fix Bug 798327) OS: Ubuntu 20.04 LTS SCENARIO: My wife recently started a new job where the 401k provider maintains the mutual fund positions at nine decimal places (and the price is two decimal places precision). I set up the security with the fract

Re: [GNC] OFX Import with Investment Transactions

2021-10-03 Thread Robin Chattopadhyay
er habit from Quicken as it was known to corrupt files). > > This may not be the answer you are looking for but hope this helps a bit. > > Kalpesh... > > -- > > Message: 2 > Date: Sat, 2 Oct 2021 10:58:44 -0500 > From: Robin Chattopadhyay &g

Re: [GNC] OFX Import with Investment Transactions

2021-10-02 Thread Robin Chattopadhyay
rk or not? > If not, then we'll need to check whether the FITID of the new imported > transactions somehow have been used before in the previously imported > transactions. To see that, you'd need to pick one that was not imported > (looking at the OFX file), get its FITID

Re: [GNC] Scheduled transactions do not appear in the register until is pressed

2021-10-02 Thread Robin Chattopadhyay
I interpreted the question differently. If you leave a register open from a prior session, it seems like the register view doesn't refresh and display newly created transactions until you perform some sort of other action that triggers a refresh. That's the experience *I* thought Glenn was describ

[GNC] OFX Import with Investment Transactions

2021-10-02 Thread Robin Chattopadhyay
Ubuntu 20.04 LTS (VMWare virtual machine in case that matters) Gnucash 4.8 libofx 0.9.15 I tried importing an OFX file from my 401K provider this morning and I got a message box that said it had imported 2 transactions for a single security in the file and there were no additional transactions to

Re: [GNC] Scheduled Transaction Posting Order

2021-10-01 Thread Robin Chattopadhyay
oll happen the day before (think day of > week) the allowance. > > On Fri, Oct 1, 2021, 14:32 Stan Brown wrote: > > > > > On 2021-10-01 14:01, Robin Chattopadhyay wrote: > > > Is there a way to control the posting order of scheduled transactions? > > > > >

[GNC] Scheduled Transaction Posting Order

2021-10-01 Thread Robin Chattopadhyay
Is there a way to control the posting order of scheduled transactions? For example, I have scheduled transaction A that runs every two weeks (payroll) and scheduled transaction B (kids' allowance) that runs every week. For the bank account side of the transaction, it would be nice if the deposit

Re: [GNC] Set up GnuCash to track monthly net income considering taxes and pension fund contributions

2021-09-25 Thread Robin Chattopadhyay
You can achieve the ad-hoc nature of a templated transaction by setting the frequency of the scheduled transaction to 'Once'. Set up your scheduled transaction, set the frequency to 'Once', run the scheduled transactions/Since Last Run option, fill in the variables, then proceed. The next time yo

Re: [GNC] Python Error

2021-07-19 Thread Robin Chattopadhyay
*older* libraries causing the wrong code to be loaded. > > -derek > > On Mon, July 19, 2021 8:42 am, Robin Chattopadhyay wrote: > > I should have mentioned that. > > > > I built from source with "cmake -DCMAKE_INSTALL_PREFIX=/usr/local > > -DWITH_AQBANKING=OFF -

Re: [GNC] Python Error

2021-07-19 Thread Robin Chattopadhyay
> you > include the switch "-DWITH_PYTHON=ON" in the cmake command when building? > > David Cousens > > On Sun, 2021-07-18 at 17:29 -0500, Robin Chattopadhyay wrote: > > Ubuntu 20.04 LTS > > Gnucash 4.6 > > > > After upgrading to 4.6 my Pyth

[GNC] Python Error

2021-07-18 Thread Robin Chattopadhyay
Ubuntu 20.04 LTS Gnucash 4.6 After upgrading to 4.6 my Python script broke and I'm not sure what to do to fix it. It's failing at "import gnucash" with: Traceback (most recent call last): File "/home/robin/.local/lib/python3.8/site-packages/gnucash/gnucash_core_c.py", line 14, in swig_import_h

Re: [GNC] gnucash-cli --quotes get

2021-05-27 Thread Robin Chattopadhyay
It’s probably possible, but getting the script this far is at the far frontier of my Python abilities. Plus, for my purposes, I’m only interested in the market closing price so I only run the script once per day, Tues-Sat. I don’t need an intraday level of granularity. Cheers, Robin On Thu, May

Re: [GNC] gnucash-cli --quotes get

2021-05-17 Thread Robin Chattopadhyay
Here's the file; I think the attachment should pass through, the input CSV has no headers and comma separated values in order below: Example: Mnemonic, Price, Price Date (-mm-dd), Namespace, Currency Code "94986H103",62.8194,2021-05-14,"401K","USD" It works for me, in lines 10-12, you can adj

Re: [GNC] gnucash-cli --quotes get

2021-05-17 Thread Robin Chattopadhyay
I have a Python script that I've created that takes in a CSV file and loads the prices into Gnucash. I would be willing to share it; I know it works with the SQLite backend, I haven't tested it with any other backend. Robin On Mon, May 17, 2021 at 6:59 AM mike823 wrote: > I might do it. I am lo

Re: [GNC] Autofill Oddity

2021-04-08 Thread Robin Chattopadhyay
wrote: > Apparently the feature to filter accounts described by Robin is something > that I do not see in release 3.8. Is that described somewhere in the Help > manual? > > On Thu, Apr 8, 2021 at 1:42 PM Robin Chattopadhyay > wrote: > >> This happens to me under Ubun

Re: [GNC] Autofill Oddity

2021-04-08 Thread Robin Chattopadhyay
This happens to me under Ubuntu 20.04 LTS as well (Under several Gnucash versions up to 4.4, it started around the time the feature to filter accounts was introduced instead of the previous way of starting at the top of the tree). I have worked around this by clicking the drop-down arrow in the Tr

Re: [GNC] Confused Entering A Refund To Credit Card Account

2021-03-30 Thread Robin Chattopadhyay
There’s another, even easier IMO, option to select the Reverse Transaction option. That will duplicate the transaction and flip the amounts at the same time. Robin On Tue, Mar 30, 2021 at 10:57 AM Cam Ellison wrote: > On 2021-03-30 8:43 a.m., Jack Frillman via gnucash-user wrote: > > > > I'm tr

Re: [GNC] Investment Portfolio Report + Parent Cash Amount

2021-03-23 Thread Robin Chattopadhyay
controlling how parent account totals are included. On Tue, Mar 23, 2021 at 11:03 AM Jack Frillman wrote: > Not sure I follow you. I'm not looking to restructure anything just to > consolidate information onto one report. > > On 3/22/21 10:58 PM, Robin Chattopadhyay wrote: > >

Re: [GNC] Investment Portfolio Report + Parent Cash Amount

2021-03-22 Thread Robin Chattopadhyay
You can simply create a generic asset account and set the commodity to US Dollars (since it's an IRA). It would have the same parent as the other securities. I name those accounts "Cash/Cash Equivalents" in my setup. If the cash is invested in a money market mutual fund, you could also set the com

Re: [GNC] Mystery per-security Opening Balances accounts appearing

2021-03-17 Thread Robin Chattopadhyay
I've been meaning to ask about this behavior too. I *think* it started sometime between version 4.1 and 4.4. It seems to me to happen when creating -- or editing -- an account that has a non-currency commodity. As Geoff said, it's a minor nuisance and I just delete the extra accounts when they appe

Re: [GNC] New scheduled transaction--error message--I'm stumped

2021-01-30 Thread Robin Chattopadhyay
In the template transaction tab, I’ve found that I have to put the cursor on a blank line (i.e. save the template transaction) before saving the overall scheduled transaction. Robin On Sat, Jan 30, 2021 at 1:15 AM randix wrote: > So I'm running Windows 10 Pro, GnuCash Version: 4.4 > Build ID:

Re: [GNC] Representing fund restructure in Gnucash

2021-01-22 Thread Robin Chattopadhyay
Hi Peter- This is also how I have done similar transactions (and in-kind transfers to a new broker). One thing to note is that this method will also create a new price record in the price database. So I also go into the price editor and remove that extra, invalid price. On Fri, Jan 22, 2021 at 3:

Re: [GNC] Command Line Report Options

2020-07-18 Thread Robin Chattopadhyay
; > outputs the following into gst.csv > > "from","01/04/20" > "to","30/06/20" > "Gross Sales",220.0 > "Net Sales",200.0 > "Tax on Sales",20.0 > "Gross Purchases",110.0 > "Net Purchases&quo

[GNC] Command Line Report Options

2020-07-17 Thread Robin Chattopadhyay
In the release notes and the help page, the documentation lists 'export-type' as an option and the example cites html as an export type option. Are there any other supported options? I tried 'pdf' and 'PDF' and neither of those worked. From the release notes: • A new separate executable, g

Re: [GNC] Finance::Quote enters previous day's price as today's

2020-06-23 Thread Robin Chattopadhyay
Dave R. is correct to call out the timing as a source of the issue. Just to add some additional background, I work in the financial services industry and a component part of my team's work is to ingest prices from 200+ mutual fund companies, covering tens of thousands of mutual fund prices. The b

Re: [GNC] Cash Flow with Split Transaction

2020-05-17 Thread Robin Chattopadhyay
I solve for this problem by using a suspense account. Set up an asset account. On each payday, record your gross pay as a debit, all of your various taxes, with holdings, etc. as credits, with one or more final credit(s) to the suspense account to cover your net pay. You can now run a cash flow

Re: [GNC] Proposed change of "U+R" and "R" in the Import main matcher.

2019-08-05 Thread Robin Chattopadhyay
+1 On Mon, Aug 5, 2019 at 7:53 PM David Cousens wrote: > I have raised bugs in the > code(https://bugs.gnucash.org/show_bug.cgi?id=797338) and documentation > (https://bugs.gnucash.org/show_bug.cgi?id=797337) proposing changing the > "U+R" and "R" tags in the import main matcher to "U+C" and "C"

Re: [GNC] Import Price from CSV Bug? (Robin Chattopadhyay)

2019-07-07 Thread Robin Chattopadhyay
On Sun, Jul 7, 2019 at 3:42 PM Geert Janssens wrote: > Op zaterdag 6 juli 2019 23:06:56 CEST schreef Robin Chattopadhyay: > > Hi Art- > > > > I found this Bug that was fixed in 3.6 that is the source of the new > > Namespace requirement. https://bugs.gnucash

Re: [GNC] Import Price from CSV Bug? (Robin Chattopadhyay)

2019-07-06 Thread Robin Chattopadhyay
no problems before Namespace was introduced? Will the program > remember my Namespace selection, or will have have to manually edit > the csv file each week, when I update my prices? > > Can anyone find where the procedure is documented? > > Thank you, > Art > > >

[GNC] Import Price from CSV Bug?

2019-07-04 Thread Robin Chattopadhyay
Hi all- I have been using the Import Price from CSV function successfully up through and including v3.5 (both Ubuntu 18.04 and Linux Mint 19). I have set my input file/mapping to: - CUSIP --> Commodity From - Shares --> None - Market Value --> None - Price --> Amount - Date --> Da

Re: [GNC] Building from source

2019-05-07 Thread Robin Chattopadhyay
Never mind... Sorry, I should have tried harder to find a solution. I had a problem with the guile installation. Once I fixed that, re-compiled and re-installed, the messages went away. Thanks, Robin On Tue, May 7, 2019 at 12:26 PM Robin Chattopadhyay wrote: > Hi- > > I am atte

[GNC] Building from source

2019-05-07 Thread Robin Chattopadhyay
Hi- I am attempting to build from source on a new machine (a backup machine) and I keep running into this when I run gnucash from terminal: ;;; WARNING: loading compiled file /usr/local/lib/gnucash/scm/ccache/2.0/fin.go failed: ;;; ERROR: In procedure make_objcode_from_file: bad header on object

[GNC] Add Price Quotes

2018-06-02 Thread Robin Chattopadhyay
Hi- Using GC 3.1 with SQLite backend on Linux Mint 18.3... When running "gnucash --add-price-quotes ~/Documents/file.gnucash", the prices are loaded but the process doesn't appear to terminate. The trace file doesn't having anything other than MESSG or INFO entries. I only notice because I'm ge

Re: [GNC] Editing Scheduled Transaction

2018-05-19 Thread Robin Chattopadhyay
Dave- I experimented a bit more based on your findings. Additional steps to recreate: Create new SX; close GnuCash; re-open GnuCash. Edit SX template transaction. I tried: *Create SX; edit template. Editing allowed *Create SX; Run SX; edit template. Editing allowed *Create SX; Run SX; Close/re-

Re: [GNC] Editing Scheduled Transaction

2018-05-18 Thread Robin Chattopadhyay
ot;submit" twice somehow and made two, and I've closed the second > one. > > Regards, > John Ralls > > > > On May 18, 2018, at 2:38 PM, Robin Chattopadhyay > wrote: > > > > Done. Thanks. > > > > https://bugzilla.gnome.org/show_bug.cgi?id=796

Re: [GNC] Editing Scheduled Transaction

2018-05-18 Thread Robin Chattopadhyay
e > bugzilla > > Thanks, > > Geert > > Op vrijdag 18 mei 2018 14:19:27 CEST schreef Robin Chattopadhyay: > > On Thu, May 17, 2018 at 9:29 PM Adrien Monteleone < > > > > adrien.montele...@lusfiber.net> wrote: > > > You said the work around is to delete a

Re: [GNC] Editing Scheduled Transaction

2018-05-18 Thread Robin Chattopadhyay
to see how it behaves. I > also haven’t yet had a need to edit any of them. > > Regards, > Adrien > > > On May 17, 2018, at 9:02 PM, Robin Chattopadhyay > wrote: > > > > Hi- > > > > Using GC 3.1 on Mint 18.3. > > > > I've come acro

[GNC] Editing Scheduled Transaction

2018-05-17 Thread Robin Chattopadhyay
Hi- Using GC 3.1 on Mint 18.3. I've come across something that seems like a bug, but I thought I would check here first because I didn't see an open bug already. Under Edit Scheduled Transaction, click Template Transaction, attempt to edit a value in any field of the transaction then move focus

[GNC] Date Fields

2018-04-29 Thread Robin Chattopadhyay
I use SQLite to create some basic reporting from gnucash and I noticed that after upgrading from 2.6.x to 3.0/3.1 several of the date fields are now stored in two different formats: Transactions entered in the file under 2.6.x are: mmddhhmmss while dates entered in the file under 3.0/3/1 are y

[GNC] Reconcile Window Vertical Scroll Bar

2018-04-28 Thread Robin Chattopadhyay
When the reconcile window is open, as I move the mouse to check the 'R' box and the pointer approaches the checkbox, the vertical scroll bar doubles in width and nearly covers up the checkbox. This makes it difficult to click the checkbox and I end up clicking the scroll bar instead. As the point

Re: Finance::Quote for EE Savings Bonds

2018-03-24 Thread Robin Chattopadhyay
n Mon, Feb 19, 2018 at 7:39 PM, Robin Chattopadhyay wrote: > Ken- > > Thank you so much! This worked great. > > For the record, I: > * Saved the file to ~/perl5/lib/perl5/Finance/Quote/ > * Edited ~/perl5/lib/perl5/Finance/Quote.pm to add USBonds to the Modules > section aro

Re: Account Report/Register Report

2018-03-08 Thread Robin Chattopadhyay
says it, this is for my own performance tracking, not tax reporting). On Wed, Mar 7, 2018 at 7:56 AM, Wm via gnucash-user < gnucash-user@gnucash.org> wrote: > On 06/03/2018 01:25, Robin Chattopadhyay wrote: > >> Hi- >> >> Using Linux Mint 18.3, Gnucash 2.6.19... >&

Account Report/Register Report

2018-03-05 Thread Robin Chattopadhyay
Hi- Using Linux Mint 18.3, Gnucash 2.6.19... There's a report I like to use called Account Report. You can get to it after opening a register. I use this report to see what gnc has as the cost basis for an investment. Because of the way my 401(k) provider calculates cost basis, I have found that

Re: Finance::Quote for EE Savings Bonds

2018-02-19 Thread Robin Chattopadhyay
Ken- Thank you so much! This worked great. For the record, I: * Saved the file to ~/perl5/lib/perl5/Finance/Quote/ * Edited ~/perl5/lib/perl5/Finance/Quote.pm to add USFedBonds to the Modules section around Line 180. The one thing I'll have to change is that up to now, I've been holding the EE S

Re: Switching from Windows to Mint

2018-02-11 Thread Robin Chattopadhyay
Hello again! I appear to have solved my own issues. I had a number of dependencies missing in addition to what's listed in the wiki: * libdbd-sqlite3 * libofx-dev * libgoffice-0.8 * libgtk2.0-dev On Sun, Feb 11, 2018 at 12:05 PM, Robin Chattopadhyay wrote: > Hi all- > > I

Switching from Windows to Mint

2018-02-11 Thread Robin Chattopadhyay
Hi all- I've been using GnuCash for years on various versions of Windows, but I got a new computer and decided to make the leap to Linux. I'm using Mint 18.3 and I'm having trouble building from source. I've been following the steps in the wiki. (I tried the distribution, but it doesn't have the

Finance::Quote for EE Savings Bonds

2018-01-31 Thread Robin Chattopadhyay
Ken- Were you able to get quotes for EE Savings bonds? I can't figure out how to determine the CUSIP for these. (I figured out how to find CUSIPs at treasurydirect.gov but it doesn't seem to have savings bond CUSIPs.) Robin On Sun, Jan 28, 2018 at 2:46 PM, farleykj wrote: > So, after trying d