Re: [GNC-dev] xml for Romanian e-invoice

2024-01-18 Thread Frank H. Ellenberger
Am 10.01.24 um 22:28 schrieb John Ralls: On Jan 10, 2024, at 12:50 PM, Mihai DEMIAN wrote: Hello, My name is Mihai Demian, I am Romanian and I am one of many who has to implement the e-invoice system within six months. I tried to look at the sources for GC but I did not make any sense

Re: [GNC-dev] xml for Romanian e-invoice

2024-01-10 Thread John Ralls
> On Jan 10, 2024, at 12:50 PM, Mihai DEMIAN wrote: > > Hello, > > My name is Mihai Demian, I am Romanian and I am one of many who has to > implement the e-invoice system within six months. > I tried to look at the sources for GC but I did not make any sense of most of

Re: [GNC-dev] Easy and Tax Invoice Reports

2022-11-09 Thread john
Dr. Micajkova, Ah, I see where you're going. You can file an enhancement request, see https://wiki.gnucash.org/wiki/Enhancement_Requests, to add those rows to the options of the Tax Invoice Report. You probably also want the Date and Description columns. Neither the Easy Invoice nor

Re: [GNC-dev] Fwd: Easy and Tax Invoice Reports — translation to mk

2022-11-09 Thread Vesna Micajkova
Hello Frank! Thank you for your reply. I understand, but even if it was not your intention you made it possible to translate almost the whole invoice content through that report. The possibility to create and print an in invoice on a native language is very important for every enterprise

Re: [GNC-dev] Fwd: Easy and Tax Invoice Reports — translation to mk

2022-11-08 Thread Frank H. Ellenberger
. Until now no government was unsatisfied by the standard terms "Invoice Date" and "Due Date". That is the reason that they are not adjustable there. Regards Frank Am 08.11.22 um 11:30 schrieb Frank H. Ellenberger: Just forwarding to the list to

Re: [GNC-dev] Easy and Tax Invoice Reports

2022-11-08 Thread john
al Message- > From: john [mailto:jra...@ceridwen.us] > Sent: Monday, November 7, 2022 6:32 PM > To: Vesna Micajkova > Cc: gnucash-devel@gnucash.org > Subject: Re: [GNC-dev] Easy and Tax Invoice Reports > > > >> On Nov 7, 2022, at 12:28 AM, Vesna Micajkova >

[GNC-dev] Fwd: Easy and Tax Invoice Reports — translation to mk

2022-11-08 Thread Frank H. Ellenberger
Just forwarding to the list to keep others informed … Weitergeleitete Nachricht Betreff: RE: [GNC-dev] Easy and Tax Invoice Reports — translation to mk Datum: Tue, 8 Nov 2022 08:44:32 +0100 Von: Vesna Micajkova An: 'Frank H. Ellenberger' Hello Frank! Thank you very much

Re: [GNC-dev] Easy and Tax Invoice Reports — translation to mk

2022-11-07 Thread Frank H. Ellenberger
exploring the opportunities for this program usage by enterprises in my country since there is no translation in Macedonian language yet. So, I was looking for possibility of completely translation of invoice and find out that there is no opportunity for translating the following strings: Invoice Date

Re: [GNC-dev] Easy and Tax Invoice Reports

2022-11-07 Thread john
th > its features. I am exploring the opportunities for this program usage by > enterprises in my country since there is no translation in Macedonian > language yet. So, I was looking for possibility of completely translation of > invoice and find out that there is no opportunity for translating

[GNC-dev] FW: Easy and Tax Invoice Reports

2022-11-07 Thread Vesna Micajkova
there is no translation in Macedonian language yet. So, I was looking for possibility of completely translation of invoice and find out that there is no opportunity for translating the following strings: Invoice Date and Due Date. If those strings can be added to Easy and Tax Invoice Reports options the invoices

Re: [GNC-dev] Fetching invoice tax list and general business information in python

2022-10-12 Thread Michael or Penny Novack
On 10/12/2022 6:41 AM, Tim van Osch wrote: Hey everyone, I would like to render my invoice using the python bindings but I am having two issues. The main issue I am having is getting the tax values of an invoice per tax table. Something like this: *VAT 21% *€152.00 *VAT 6%*€23.00

[GNC-dev] Fetching invoice tax list and general business information in python

2022-10-12 Thread Tim van Osch
Hey everyone, I would like to render my invoice using the python bindings but I am having two issues. The main issue I am having is getting the tax values of an invoice per tax table. Something like this: *VAT 21% *€152.00 *VAT 6%*€23.00 I found the method: Invoice.GetTotalTaxList

[GNC-dev] Eesti keel - estonian translation; was: change column headers on invoice?

2020-09-11 Thread Frank H. Ellenberger
Hi Siim, thanks to your contribution, GnuCash 4.2 will have a basic estonian translation. We would appreciate, if you would continue the work. Regards Frank Am 29.08.20 um 08:33 schrieb Frank H. Ellenberger: > Hi Siim, > > Am 28.08.20 um 09:40 schrieb Siim Sellis: >> Where’s the po file, that

Re: [GNC-dev] change column headers on invoice?

2020-08-29 Thread Frank H. Ellenberger
adetud: *neljapäev, 27. august 2020 15:58 > *Adressaat: *Siim Sellis <mailto:haukaf...@gmail.com> > *Koopia: *gnucash-devel@gnucash.org <mailto:gnucash-devel@gnucash.org> > *Teema: *Re: [GNC-dev] change column headers on invoice? > > Hello Siim, > > Am 2

Re: [GNC-dev] change column headers on invoice?

2020-08-27 Thread Frank H. Ellenberger
Hello Siim, Am 27.08.20 um 13:04 schrieb Siim Sellis: >Hi! > >Is there an easy way to change the text on printable invoice? I would >like to translate the column headers, Date, Due date, Net price, Tax, >Total price and Amount due fields, that appear on pr

[GNC-dev] change column headers on invoice?

2020-08-27 Thread Siim Sellis
Hi! Is there an easy way to change the text on printable invoice? I would like to translate the column headers, Date, Due date, Net price, Tax, Total price and Amount due fields, that appear on printable invoice, to Estonian language. I believe there is no Estonian version

Re: [GNC-dev] gnucash maint: [new-owner-report] invoice->payments displays lot links

2019-12-24 Thread Christopher Lam
e bug report as it's easier to track there. > > Regards, > > Geert > > Op dinsdag 24 december 2019 09:25:11 CET schreef Christopher Lam: > > Oops the HTML file doesn't show the outstanding invoice. Pressed SEND too > > quick. > > > > On Tue, 24 Dec 2019 at 08:22,

Re: [GNC-dev] gnucash maint: [new-owner-report] invoice->payments displays lot links

2019-12-24 Thread Geert Janssens
: > Oops the HTML file doesn't show the outstanding invoice. Pressed SEND too > quick. > > On Tue, 24 Dec 2019 at 08:22, Christopher Lam > > wrote: > > I'd forgotten to fix the commit message before push. I've added proper > > commit message on the github web interface.

Re: [GNC-dev] gnucash maint: [new-owner-report] invoice->payments displays lot links

2019-12-24 Thread Christopher Lam
Oops the HTML file doesn't show the outstanding invoice. Pressed SEND too quick. On Tue, 24 Dec 2019 at 08:22, Christopher Lam wrote: > I'd forgotten to fix the commit message before push. I've added proper > commit message on the github web interface. > > I think I've managed to m

Re: [GNC-dev] gnucash maint: [new-owner-report] invoice->payments displays lot links

2019-12-24 Thread Christopher Lam
I'd forgotten to fix the commit message before push. I've added proper commit message on the github web interface. I think I've managed to make a decent new-owner-report now. invoice->lot->splits whereby split->parent is TXN-TYPE-LINK are now queried differently to TXN-TYPE-PAYMENT. T

Re: [GNC-dev] gnucash maint: [new-owner-report] invoice->payments displays lot links

2019-12-24 Thread Geert Janssens
Op dinsdag 24 december 2019 04:57:43 CET schreef Christopher Lam: > - TXN-TYPE-LINK lot-splits are rendered as a generic 'Offset > Documents' link to lot-link splits. This helps link invoice to the > link transaction to locate the corresponding credit-note. It is not >

Re: [GNC-dev] gnucash maint: Change Invoice Entries in dialog-invoice.glade

2019-12-23 Thread Geert Janssens
cab9d06b6c6aab9dac2b1 > Author: Robert Fewell <14ubo...@gmail.com> > Date: Mon Dec 23 16:21:47 2019 + > > Change Invoice Entries in dialog-invoice.glade > > Change 'Invoice Entries' to just 'Entries' which can be used for all > types Invoice, Bills and Vouc

Re: [GNC-dev] [GNC] How to apply Over Payments or Pre-Payments to a Different Invoice

2019-07-10 Thread Christopher Lam
cludes bugfix to show 'running owed balance' after > debits/credits. > > Unsure how much detail to potentially show. I'd vote default none, option > for simple detail (invoice->paid? / payment->invoice-list), and allow > maximum detail for troubleshooting (invoice->payme

Re: [GNC-dev] [GNC] How to apply Over Payments or Pre-Payments to a Different Invoice

2019-07-10 Thread Christopher Lam
how much detail to potentially show. I'd vote default none, option for simple detail (invoice->paid? / payment->invoice-list), and allow maximum detail for troubleshooting (invoice->payments-list, payment->invoices-list). IMHO There's a lot of capability hidden in business features, and

Re: [GNC-dev] [GNC] How to apply Over Payments or Pre-Payments to a Different Invoice

2019-07-10 Thread Adrien Monteleone
Nice! Does this work for invoices not assigned a ‘job’? (I might have to tackle my own bug report on that one as my first, it is a source of confusion) I think the second report example is cleaner, by the way. And while I don’t use multi-currency AR/AP, I can certainly see the ability to pull

Re: [GNC-dev] [GNC] How to apply Over Payments or Pre-Payments to a Different Invoice

2019-07-10 Thread Christopher Lam
On Wed, 10 Jul 2019 at 14:30, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > (snip) > > *Unfortunately, the Customer Report doesn’t match up invoices to payments*, > it is just a straight time-line of debits and credits. (you can sort of > match them up if you utilize the notes and

Re: [GNC-dev] Python bindings: Exception when calling GetDatePosted on unposted invoice

2019-02-06 Thread Frank Oltmanns
t; >Regards, > >Geert > >Op woensdag 6 februari 2019 19:19:57 CET schreef Frank Oltmanns: >> Dear all, >> >> I'm using the python bindings from GnuCash 3.3 (debian package from >sid). >> When calling GetDatePosted() on an unposted invoice a get the

Re: [GNC-dev] Python bindings: Exception when calling GetDatePosted on unposted invoice

2019-02-06 Thread Geert Janssens
from sid). > When calling GetDatePosted() on an unposted invoice a get the following > exception: > ValueError: month must be in 1..12 > > This function is used in the example scripts that are part of GnuCash > (gnucash_simple.py). In this example the exception is not caught but

[GNC-dev] Python bindings: Exception when calling GetDatePosted on unposted invoice

2019-02-06 Thread Frank Oltmanns
Dear all, I'm using the python bindings from GnuCash 3.3 (debian package from sid). When calling GetDatePosted() on an unposted invoice a get the following exception: ValueError: month must be in 1..12 This function is used in the example scripts that are part of GnuCash (gnucash_simple.py

Re: [GNC-dev] Tax Invoice Heading in GNC 3.2

2018-08-05 Thread nor via gnucash-devel
Thanks for replynor - nor -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-Dev-f1435356.html ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] Tax Invoice Heading in GNC 3.2

2018-08-05 Thread Geert Janssens
Op zondag 5 augustus 2018 10:14:31 CEST schreef nor via gnucash-devel: > Hello,Ref. report Tax Invoice.Under Heading 1, I cannot change the "report > title". It always stays as "Customer Invoice". Rest of the items are > editable as required. Please see snap shot bel

[GNC-dev] Tax Invoice Heading in GNC 3.2

2018-08-05 Thread nor via gnucash-devel
Hello,Ref. report Tax Invoice.Under Heading 1, I cannot change the "report title". It always stays as "Customer Invoice". Rest of the items are editable as required. Please see snap shot below, <http://gnucash.1415818.n4.nabble.com/file/t375966/Tax_Invoice.jpg> This is n

Re: [GNC-dev] New invoice date opened shows 01/01/1970, possibly other places

2018-04-14 Thread Geert Janssens
ing at the time64 number this starts of correct, i.e. today's value. > > At some point this function gets called 'gnc_invoice_update_window' and on > line 1766 we have > > time = gncInvoiceGetDateOpened (invoice); > > and time is 9223372036854775807 which is INT64_MAX

[GNC-dev] New invoice date opened shows 01/01/1970, possibly other places

2018-04-14 Thread Robert Fewell
ets called 'gnc_invoice_update_window' and on line 1766 we have time = gncInvoiceGetDateOpened (invoice); and time is 9223372036854775807 which is INT64_MAX which is what is returned for null invoice following that we have... if (!time) { gnc_date_edit_set_time (GNC_DATE_EDIT (iw->opene

Re: Invoice/Bill structure

2018-01-11 Thread Derek Atkins
They are both used if you use chargebacks. -derek On Thu, January 11, 2018 12:55 pm, R. Victor Klassen wrote: > I’ve been poking around in the SQL for invoices/bills, and > > Inquiring mind(s) wish to know: > > Why, in an “Entry” is there both an invoice (text) and a bill (text

Re: Invoice/Bill structure

2018-01-11 Thread Geert Janssens
Op donderdag 11 januari 2018 18:55:46 CET schreef R. Victor Klassen: > I’ve been poking around in the SQL for invoices/bills, and > > Inquiring mind(s) wish to know: > > Why, in an “Entry” is there both an invoice (text) and a bill (text) field, > only one of which is ever use

Invoice/Bill structure

2018-01-11 Thread R. Victor Klassen
I’ve been poking around in the SQL for invoices/bills, and Inquiring mind(s) wish to know: Why, in an “Entry” is there both an invoice (text) and a bill (text) field, only one of which is ever used, and i_price_num/denom and b_price_num/denom fields, only one (pair) of which is ever used

Re: dialog-invoice

2017-09-02 Thread Robert Fewell
gt; wrote: > > > I have noticed some invalid casts which trace back to dialog-invoice but > > not sure what has changed, so here is what I have found... > > > > Looking at a local pre gtk3/master dialog-invoice.glade, you have > > page_terms_menu being a G

Re: dialog-invoice

2017-09-02 Thread Mike Evans
On Sat, 2 Sep 2017 13:42:56 +0100 Robert Fewell <14ubo...@gmail.com> wrote: > I have noticed some invalid casts which trace back to dialog-invoice but > not sure what has changed, so here is what I have found... > > Looking at a local pre gtk3/master dialog-invoi

dialog-invoice

2017-09-02 Thread Robert Fewell
I have noticed some invalid casts which trace back to dialog-invoice but not sure what has changed, so here is what I have found... Looking at a local pre gtk3/master dialog-invoice.glade, you have page_terms_menu being a GtkEntry and dialog_terms_menu being a GtkComboBox with no Entry. Looking

Re: Missing invoice in Business->Customer->Find Invoice

2017-08-02 Thread Derek Atkins
Hi, First, this is a user question, not a developer question -- so should have been asked on gnucash-user. I've re-directed this there. Eric Wheeler <gnucash-de...@lists.ewheeler.net> writes: > Hello all, > > We have an invoice that cannot be found in the "Business->Cu

Missing invoice in Business->Customer->Find Invoice

2017-08-01 Thread Eric Wheeler
Hello all, We have an invoice that cannot be found in the "Business->Customer->Find Invoice" dialog, neither by invoice number nor by customer name. However, both the post and payment do show up in "Accounts Receivable" and I can find the invoice if I do Reports-

PDF output not always wrapping long invoice lines

2017-03-15 Thread Eric Wheeler
Hello all, We found a strange bug that we are able to reproduce, but inconsistently: We use the "taxinvoice.eguile.scm" tax invoice template and are able to reproduce the problem with an unmodified version. See the these PDFs for the working and broken versions: https://mx.ew

customizing invoice report

2015-03-02 Thread Wendy Wong
Hi there. are there any ways to customize invoice format? I would like to show the item gross amount, discount percentage, discount dollars and net. In addition, tax is not applicable. Even though I choose not to display tax on each line, the total tax still shows up. Thanks Wendy Wong

Re: Crash paying invoice

2014-05-05 Thread Mike Alexander
--On May 5, 2014 12:11:32 AM -0400 John Ralls jra...@ceridwen.us wrote: Turned out not to be so hard after all, there's just an extra level of indirection required. Fixed in edd85fa. Thanks for fixing it. It seems to work fine for me now. Mike

Re: Crash paying invoice

2014-05-04 Thread John Ralls
On May 4, 2014, at 1:38 AM, John Ralls jra...@ceridwen.us wrote: On May 3, 2014, at 9:03 PM, Mike Alexander m...@umich.edu wrote: Something in private-kvp branch that was merged in a day or two ago seems to have broken part of the business features. If I try to pay an invoice

Crash paying invoice

2014-05-03 Thread Mike Alexander
Something in private-kvp branch that was merged in a day or two ago seems to have broken part of the business features. If I try to pay an invoice for a customer I get a crash in the code that creates the payment window. The top of the stack is * thread #1: tid = 0x81af3a

Re: Crash paying invoice

2014-05-03 Thread John Ralls
On May 3, 2014, at 9:03 PM, Mike Alexander m...@umich.edu wrote: Something in private-kvp branch that was merged in a day or two ago seems to have broken part of the business features. If I try to pay an invoice for a customer I get a crash in the code that creates the payment window

Re: Import Invoice Entries by Database Trigger

2014-03-13 Thread Allen S. Rout
. Invoices are among the more complicated processes in GnuCash and so the most likely to screw up your database if you go outside of the API. Good luck and don't test on your production data! I'm scripting invoice entry for our Hackerspace, In Production, if you can call a hackerspace that. Adrian

Import Invoice Entries by Database Trigger

2014-03-12 Thread Adrian Hodson
Hello, I am using Partkeepr for inventory and Gnucash on the same Mysql server instance. I plan for customers to sign off on an initial invoice from Gnucash. A Partkeepr Materials List ID will be identical to the Gnucash Invoice number. I would like to create a database trigger on Partkeeper

Re: Import Invoice Entries by Database Trigger

2014-03-12 Thread John Ralls
On Mar 12, 2014, at 3:47 AM, Adrian Hodson no.bicycle.subscripti...@gmail.com wrote: Hello, I am using Partkeepr for inventory and Gnucash on the same Mysql server instance. I plan for customers to sign off on an initial invoice from Gnucash. A Partkeepr Materials List ID

Re: Import Invoice Entries by Database Trigger

2014-03-12 Thread John Ralls
for inventory and Gnucash on the same Mysql server instance. I plan for customers to sign off on an initial invoice from Gnucash. A Partkeepr Materials List ID will be identical to the Gnucash Invoice number. I would like to create a database trigger on Partkeeper that inserts Materials

Re: New bill creates a new invoice

2014-02-18 Thread Derek Atkins
Hi, Cristian Marchi cr...@libero.it writes: Thanks Geert, [1] is surely the same problem I reported when it's clear that there is a difference between customer and vendor jobs. In fact, I was expecting only a unique job definition to which you can link customer (generally one) and vendors.

Re: New bill creates a new invoice

2014-02-17 Thread Geert Janssens
On Saturday 15 February 2014 21:14:56 Cristian Marchi wrote: Il 15/02/2014 17:58, Geert Janssens ha scritto: [1] https://bugzilla.gnome.org/show_bug.cgi?id=625505 Thanks Geert, [1] is surely the same problem I reported when it's clear that there is a difference between customer and

New bill creates a new invoice

2014-02-15 Thread Cristian Marchi
pressing ok I'm presented with the Edit Invoice tab. Is it intended or should I open a bug report? PS Ubuntu 13.10 64bit with GC 2.6.1 and git Thanks Cristian ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman

Re: New bill creates a new invoice

2014-02-15 Thread Geert Janssens
the Vendor-New Bill and I enter the Vendor name AND the job, after pressing ok I'm presented with the Edit Invoice tab. Is it intended or should I open a bug report? PS Ubuntu 13.10 64bit with GC 2.6.1 and git Hi Cristian, I had to experiment a bit before I could reproduce this. There is indeed

Re: New bill creates a new invoice

2014-02-15 Thread Cristian Marchi
see the Edit Bill tab. If instead I select the Vendor-New Bill and I enter the Vendor name AND the job, after pressing ok I'm presented with the Edit Invoice tab. Is it intended or should I open a bug report? PS Ubuntu 13.10 64bit with GC 2.6.1 and git Hi Cristian, I had to experiment a bit

Re: r23751 - gnucash/trunk/src/business/business-gnome - Posting an invoice doesn't un-hide some widgets.

2014-01-24 Thread Geert Janssens
On Friday 24 January 2014 08:36:22 Mike Evans wrote: Author: mikee Date: 2014-01-24 08:36:22 -0500 (Fri, 24 Jan 2014) New Revision: 23751 Trac: http://svn.gnucash.org/trac/changeset/23751 Modified: gnucash/trunk/src/business/business-gnome/dialog-invoice.c Log: Posting an invoice

Re: cmd line: import of transactions and invoice data

2014-01-01 Thread Emmanuel Florent
First of all I wish to the Gnucash community a very good year 2014, could it be just as it ended the previous year: brilliant ! Secondly a big applause for latest release ! So here is my solution, a wrapper: -load xml from somewhere, -open gnucash, -do work -close gnucash -save Gc xml to db.

Re: cmd line: import of transactions and invoice data

2014-01-01 Thread John Ralls
On Jan 1, 2014, at 2:04 AM, Emmanuel Florent emmanuel.flor...@gmail.com wrote: First of all I wish to the Gnucash community a very good year 2014, could it be just as it ended the previous year: brilliant ! Secondly a big applause for latest release ! So here is my solution, a wrapper:

Re: cmd line: import of transactions and invoice data

2014-01-01 Thread Graham Leggett
On 01 Jan 2014, at 7:25 PM, John Ralls jra...@ceridwen.us wrote: Gnucash *probably* writes things to the XML file in the same order that they were read in just because we use linked lists for just about everything internally, but there's no guarantee of that and it might well create

cmd line: import of transactions and invoice data

2013-12-31 Thread Jannick
I am currently looking into using gnucash on a command line basis. Are there - if any - command line instructions to import (1) transactions and (2) invoice data (example file shipped with the latest 29.12.2013 version). Many thanks and have a great 2014! J

Re: cmd line: import of transactions and invoice data

2013-12-31 Thread Derek Atkins
Hi, On Tue, December 31, 2013 9:59 am, Jannick wrote: I am currently looking into using gnucash on a command line basis. Are there - if any - command line instructions to import (1) transactions and (2) invoice data (example file shipped with the latest 29.12.2013 version). Many thanks

Re: cmd line: import of transactions and invoice data

2013-12-31 Thread Geert Janssens
On Tuesday 31 December 2013 10:34:41 Derek Atkins wrote: Hi, On Tue, December 31, 2013 9:59 am, Jannick wrote: I am currently looking into using gnucash on a command line basis. Are there - if any - command line instructions to import (1) transactions and (2) invoice data (example file

Re: cmd line: import of transactions and invoice data

2013-12-31 Thread Jannick
to import (1) transactions and (2) invoice data (example file shipped with the latest 29.12.2013 version). Many thanks and have a great 2014! J. Sorry, no. GnuCash is a GUI tool. There is no command line interface. -derek to add to this, if your gnucash version has

Re: cmd line: import of transactions and invoice data

2013-12-31 Thread Emmanuel Florent
Coming from another (back-)end: Do you know if someone has gone down the implementation route to import data into the MySQL db? Is that right that Gnucash empty all the tables in db then rewrite them so the db bridge is not possible in your case ? EF ... Many thanks again. J.

Re: cmd line: import of transactions and invoice data

2013-12-31 Thread John Ralls
line basis. Are there - if any - command line instructions to import (1) transactions and (2) invoice data (example file shipped with the latest 29.12.2013 version). Many thanks and have a great 2014! J. Sorry, no. GnuCash is a GUI tool. There is no command line interface. -derek

Re: cmd line: import of transactions and invoice data

2013-12-31 Thread John Ralls
On Dec 31, 2013, at 8:36 AM, Emmanuel Florent emmanuel.flor...@gmail.com wrote: Coming from another (back-)end: Do you know if someone has gone down the implementation route to import data into the MySQL db? Is that right that Gnucash empty all the tables in db then rewrite them so the

Re: cmd line: import of transactions and invoice data

2013-12-31 Thread Jannick
Derek Atkins derek at ihtfp.com writes: Hi, On Tue, December 31, 2013 11:36 am, Emmanuel Florent wrote: Coming from another (back-)end: Do you know if someone has gone down the implementation route to import data into the MySQL db? Is that right that Gnucash empty all the tables in db

Re: cmd line: import of transactions and invoice data

2013-12-31 Thread John Ralls
On Dec 31, 2013, at 11:50 AM, Jannick jannick.n...@gmail.com wrote: Derek Atkins derek at ihtfp.com writes: Hi, On Tue, December 31, 2013 11:36 am, Emmanuel Florent wrote: Coming from another (back-)end: Do you know if someone has gone down the implementation route to import data into

Re: cmd line: import of transactions and invoice data

2013-12-31 Thread Jannick
John Ralls jralls at ceridwen.us writes: It updates the database after any change to the in-memory data. At least we think it does, but we don’t yet have complete test coverage to be sure that we haven’t missed something in our audits. John, this is very helpful. There might be two options:

Re: Invoice text change help needed

2013-03-15 Thread sales
Hi there, I am trying to use your software for our accounting purpose. Trying to edit the default text THANK YOU FOR YOUR PATRONAGE appears in the invoice. I am interested to add our bank details etc. in that place so customers can use these bank details to remit funds to us. I tried

Re: GnuCash Tax Invoice for Australia (Bug 695610)

2013-03-14 Thread Geert Janssens
Op 13-03-13 20:50, Liz schreef: I did ask for a separate AU Tax Invoice and posted my version on the bugtracker. At that time the work was being done on the editable Invoice with multiple items to edit.My invoice was not accepted because of the new complex structure being created. I have

Re: GnuCash Tax Invoice for Australia (Bug 695610)

2013-03-13 Thread Liz
Please accept this patch to provide a working AU Tax Invoice without having to change several defaults. The result from Bug 67008 still requires work to produce a legally valid invoice for Australia, and we do need this to work out of the box for ordinary Australian users. I was unhappy again

Re: GnuCash Tax Invoice for Australia (Bug 695610)

2013-03-13 Thread Geert Janssens
Op 13-03-13 12:02, Liz schreef: Please accept this patch to provide a working AU Tax Invoice without having to change several defaults. The result from Bug 67008 still requires work to produce a legally valid invoice for Australia, and we do need this to work out of the box for ordinary

GnuCash Tax Invoice for Australia (Bug 695610)

2013-03-11 Thread alphamega
with patches committed: https://bugzilla.gnome.org/show_bug.cgi?id=670008 Another invoice template was supplied in response to this bug report in April 2012: https://bugzilla.gnome.org/show_bug.cgi?id=585101 And this guy gave up completely! https://bugzilla.gnome.org/show_bug.cgi?id=402670 Anyway, I

Re: Invoice Importer

2012-08-20 Thread reubano
Mike Evans wrote On Sat, 3 Mar 2012 03:55:26 -0800 (PST) reubano lt;reubano@gt; wrote: I have successfully imported invoices but now there is a problem. After restarting gnucash, the invoices no longer show up in the Find Invoice... druid. Searching for all posted invoices only shows

Re: Invoice Importer

2012-08-20 Thread Derek Atkins
reubano reub...@gmail.com writes: Mike Evans wrote On Sat, 3 Mar 2012 03:55:26 -0800 (PST) reubano lt;reubano@gt; wrote: I have successfully imported invoices but now there is a problem. After restarting gnucash, the invoices no longer show up in the Find Invoice... druid. Searching

Re: Invoice Importer

2012-08-20 Thread Reuben Cummings
up in the Find Invoice... druid. Searching for all posted invoices only shows invoices not entered with the importer. Note: this only occurs after restarting gnucash. Before restarting, the newly imported invoices show up in the search results. Imported invoices are not posted by default. Did

Re: Invoice Importer

2012-08-20 Thread Derek Atkins
Hi, Reuben Cummings reub...@gmail.com writes: The post/restart/not-showing is completely different. Are you using a SQL backend or XML? And how do you start gnucash? -derek sqlite backend and I start gnucash by opening Gnucash.app not by opening the .gnucash files. Okay. What happens

Re: Invoice Importer

2012-08-20 Thread Mike Evans
invoices but now there is a problem. After restarting gnucash, the invoices no longer show up in the Find Invoice... druid. Searching for all posted invoices only shows invoices not entered with the importer. Note: this only occurs after restarting gnucash. Before restarting, the newly imported

Re: Invoice Importer

2012-08-20 Thread reubano
imported invoices but now there is a problem. After restarting gnucash, the invoices no longer show up in the Find Invoice... druid. Searching for all posted invoices only shows invoices not entered with the importer. Note: this only occurs after restarting gnucash. Before restarting

Re: Invoice Importer

2012-08-20 Thread reubano
imported invoices but now there is a problem. After restarting gnucash, the invoices no longer show up in the Find Invoice... druid. Searching for all posted invoices only shows invoices not entered with the importer. Note: this only occurs after restarting gnucash. Before restarting

Re: r22233 - gnucash/trunk/src/report/business-reports - Bug 341048 - RFE: Printable Invoice should allow display of Job Name

2012-06-25 Thread Derek Atkins
Mike Evans mi...@code.gnucash.org writes: -(define invoice-report-guid 5123a759ceb9483abf2182d01c140e8d) +(define invoice-report-guid 5223a759ceb9483abf2182d01c140e8d) I don't think there is any need to change the GUID of the report here. And in fact it might break more things than it would

Re: r22233 - gnucash/trunk/src/report/business-reports - Bug 341048 - RFE: Printable Invoice should allow display of Job Name

2012-06-25 Thread Mike Evans
On Mon, 25 Jun 2012 12:56:07 -0400 Derek Atkins warl...@mit.edu wrote: Mike Evans mi...@code.gnucash.org writes: -(define invoice-report-guid 5123a759ceb9483abf2182d01c140e8d) +(define invoice-report-guid 5223a759ceb9483abf2182d01c140e8d) I don't think there is any need to change

Re: Invoice Importer

2012-04-02 Thread Derek Atkins
? Because entries.invoices isn't null. Even the orphan entries have an invoice guid. It just that these guids are not present in the invoices table. Oh, so the issue is that there was an Invoice that was created in RAM but never committed. I see. That could never happen through the GUI

Re: Invoice Importer

2012-04-02 Thread Mike Evans
... the orphan entries. Really? Why can't you just do: SELECT ... FROM entries where entries.invoice IS NULL? Because entries.invoices isn't null. Even the orphan entries have an invoice guid. It just that these guids are not present in the invoices table. Oh, so the issue

Re: Invoice Importer

2012-04-02 Thread Derek Atkins
Mike Evans mi...@saxicola.idps.co.uk writes: This, I think, was caused when the importer skipped alternate rows in the invoice entries. I has since, I hope, been fixed. This is also one reason we say that trunk is unstable and could destroy your data ;) Mike E -derek -- Derek

Re: Invoice Importer

2012-03-28 Thread Reuben Cummings
instead of database tables. Yes, I wasn't questioning John's response, just letting you know what I'm not using the API. This refers to the invoice field of the entries database table, i.e., entries.invoice. So you mean the gncEntryGetInvoice() result? I'll have to assume we are talking about

Re: Invoice Importer

2012-03-27 Thread Derek Atkins
. Umm, let's ignore the database and talk about the GnuCash objects, please? You shouldn't be modifying the database, you should be using the GnuCash APIs to enter your data. In particular I don't understand what you mean by invoices from the entries table, This refers to the invoice field

Re: Invoice Importer

2012-03-27 Thread Reuben Cummings
module to work. See my post at http://gnucash.1415818.n4.nabble.com/python-binding-error-on-macports-td4441220.html In particular I don't understand what you mean by invoices from the entries table, This refers to the invoice field of the entries database table, i.e., entries.invoice. So you

Re: Invoice Importer

2012-03-27 Thread Derek Atkins
to work. See my post at http://gnucash.1415818.n4.nabble.com/python-binding-error-on-macports-td4441220.html As I believe was pointed out by John, this is a MacPorts issue. Still, for terminology it would still help to use Object terminology instead of database tables. This refers to the invoice

Re: Invoice Importer

2012-03-26 Thread Reuben Cummings
by the fields entries.invoice = invoice.guid. In particular I don't understand what you mean by invoices from the entries table, This refers to the invoice field of the entries database table, i.e., entries.invoice. and I don't understand what you mean by [entries] were never entered

Re: Invoice Importer

2012-03-24 Thread reubano
figured it out. The invoices from the entries table were never entered into the invoices table. I wrote a script to match the invoices with the transaction guids and insert them into the invoices table. -- View this message in context: http://gnucash.1415818.n4.nabble.com/Invoice-Importer

Re: Invoice Importer

2012-03-11 Thread Reuben Cummings
On Wed, Mar 7, 2012 at 6:51 PM, Reuben Cummings reub...@gmail.com wrote: On Sun, Mar 4, 2012 at 1:29 PM, Mike Evans mi...@saxicola.idps.co.uk wrote: On Sat, 3 Mar 2012 03:55:26 -0800 (PST) reubano reub...@gmail.com wrote: gnucash-2.4.10 built from source (applied row-skipping patch) with

Re: Invoice Importer

2012-03-07 Thread Reuben Cummings
On Sun, Mar 4, 2012 at 1:29 PM, Mike Evans mi...@saxicola.idps.co.uk wrote: On Sat, 3 Mar 2012 03:55:26 -0800 (PST) reubano reub...@gmail.com wrote: gnucash-2.4.10 built from source (applied row-skipping patch) with MacPorts 2.0.3 on MacOSX 10.7.2 The patch has now been applied to 2.4

Re: Invoice Importer

2012-03-05 Thread Derek Atkins
Mike Evans mi...@saxicola.idps.co.uk writes: On Sat, 3 Mar 2012 03:55:26 -0800 (PST) reubano reub...@gmail.com wrote: I have successfully imported invoices but now there is a problem. After restarting gnucash, the invoices no longer show up in the Find Invoice... druid. Searching for all

Re: Invoice Importer

2012-03-04 Thread Mike Evans
On Sat, 3 Mar 2012 03:55:26 -0800 (PST) reubano reub...@gmail.com wrote: I have successfully imported invoices but now there is a problem. After restarting gnucash, the invoices no longer show up in the Find Invoice... druid. Searching for all posted invoices only shows invoices not entered

Re: Invoice Importer

2012-03-03 Thread reubano
I have successfully imported invoices but now there is a problem. After restarting gnucash, the invoices no longer show up in the Find Invoice... druid. Searching for all posted invoices only shows invoices not entered with the importer. Note: this only occurs after restarting gnucash. Before

Re: Invoice Importer

2012-02-21 Thread Reuben Cummings
importing invoices, I get the error ROW DELETED, VENDOR_DOES_NOT_EXIST: id=1. Since 'id' is the invoice number, I don't understand the error. I even changed the invoice number to match the id of an existing vendor and still get the same error. Field 1 = invoice number. Field 3 vendor

  1   2   3   4   5   >