Re: [GNC] Custom invoices don't work after upgrade

[Adrien Monteleone]

Just an FYI, the “qof-” ’interface’ will be phased out as development 
progresses on moving to a proper db based application, so I wouldn’t rely on it 
if at all possible. That particular variable/function very well might be a now 
deprecated part of the API. See the roadmap article on the wiki for more info.

Regards,
Adrien

> On Jun 1, 2018, at 1:32 PM, Jordan and Reidun Staudinger 
>  wrote:
> 
> Hi, I have had some pretty decent looking custom invoices set up in GnuCash 
> for a few years now, and I've been quite happy with them. However, after the 
> last update, I now get the following message when I try to load one of the 
> saved invoice reports:
> 
> 
>   An error occurred when processing the template:
> 
>   ERROR: Unbound variable: qof-book-get-slots
>   In ice-9/eval.scm:
> 432: 7 [eval # #]
> 411: 6 [eval # #]
> 386: 5 [eval #)> (() # # # ...)]
> 393: 4 [eval # (() # # # ...)]
>   In unknown file:
>   ?: 3 [memoize-variable-access! # #]
> 
> 
> In order to get the invoices working previously, I had to put custom .css and 
> .scm files in the /usr/share/gnucash/guile-modules/gnucash/report/ folder, 
> which I now see no longer exists. So I did some poking around, and found that 
> the files are now in /usr/share/gnucash/scm/gnucash/report/. They were 
> already there without me adding them. Not sure if this is the reason for the 
> error or not.
> 
> Any help would be greatly appreciated, as this is preventing me from sending 
> invoices to my customers.
> 
> Thanks much, Reidun
> 
> 
> 
> -- 
> BEGIN-ANTISPAM-VOTING-LINKS
> --
> 
> Teach CanIt if this mail (ID 01VRuwM0D) is spam:
> Spam:http://199.217.123.251/canit/b.php?c=s=01VRuwM0D=04379ab31199
> Not spam:http://199.217.123.251/canit/b.php?c=n=01VRuwM0D=04379ab31199
> Forget vote: http://199.217.123.251/canit/b.php?c=f=01VRuwM0D=04379ab31199
> --
> END-ANTISPAM-VOTING-LINKS
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


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

Re: [GNC] Posting sales in multiple currencies (2.6.21)

[Adrien Monteleone]

Just out of curiosity, can you not post a CAD invoice to an A/R account that is 
set for USD?

I would have thought that GnuCash would have done the conversions for you.

Thankfully, I don’t have that problem (yet) but my first inclination would be 
to do just that: maintain MY A/R account in my home currency but invoice 
customers in their home currency. I don’t see why it would be any different 
than any other transaction posted into an account with a different currency 
default. Perhaps I’m misunderstanding something.

But if you can do as I suppose, you could eliminate the complication of extra 
accounts and the placeholder issue and just use the A/R account as normal. 
(save for the conversions done for foreign billing and the conversion on 
several reports)

Regards,
Adrien

> On Jun 1, 2018, at 8:39 AM, Matthew Pounsett  wrote:
> 
> A short aside.. I think there may still be a bug here.
> 
> Even though Assets:Accounts Receivable is set to Placeholder, it gets
> offered as a choice for posting to when I'm posting an invoice... only when
> I try to post to it I get an error that I'm trying to post to a placeholder
> account.  It should probably be excluded from the list of choices.
> 
> I'll add that to the bugtracker.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 


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

Re: [GNC] Custom invoices don't work after upgrade

[Christopher Lam]

Try this one... unfortunately most of the report uses eguile which I can't
understand.
The Gnucash API does change from time to time and usually it'd best to ask
the report creator for an update.

On 2 June 2018 at 07:33, Jordan and Reidun Staudinger <
jordanandrei...@harewaves.net> wrote:

> Here they are. Thanks!
>
> On 06/01/2018 05:11 PM, Christopher Lam wrote:
>
> Could you send these customised invoices as an attachment?
>
> On Sat, 2 Jun 2018, 02:34 Jordan and Reidun Staudinger <
> jordanandrei...@harewaves.net> wrote:
>
>> Hi, I have had some pretty decent looking custom invoices set up in
>> GnuCash for a few years now, and I've been quite happy with them.
>> However, after the last update, I now get the following message when I
>> try to load one of the saved invoice reports:
>>
>>
>> An error occurred when processing the template:
>>
>> ERROR: Unbound variable: qof-book-get-slots
>> In ice-9/eval.scm:
>>   432: 7 [eval # #]
>>   411: 6 [eval # #]
>>   386: 5 [eval #)> (() # # # ...)]
>>   393: 4 [eval # (() # # # ...)]
>> In unknown file:
>> ?: 3 [memoize-variable-access! # #]
>>
>>
>> In order to get the invoices working previously, I had to put custom
>> .css and .scm files in the
>> /usr/share/gnucash/guile-modules/gnucash/report/ folder, which I now see
>> no longer exists. So I did some poking around, and found that the files
>> are now in /usr/share/gnucash/scm/gnucash/report/. They were already
>> there without me adding them. Not sure if this is the reason for the
>> error or not.
>>
>> Any help would be greatly appreciated, as this is preventing me from
>> sending invoices to my customers.
>>
>> Thanks much, Reidun
>>
>>
>>
>> --
>> BEGIN-ANTISPAM-VOTING-LINKS
>> --
>>
>> Teach CanIt if this mail (ID 01VRuwM0D) is spam:
>> Spam:
>> Not spam:
>> Forget vote:
>> --
>> END-ANTISPAM-VOTING-LINKS
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
>
> --
>
> Spam 
> Not spam
> 
> Forget previous vote
> 
>
http://www.w3.org/TR/html4/loose.dtd;>

;;
;; $Author: chris $ $Date: 2009/07/23 10:42:08 $ $Revision: 1.33 $
;; Modified by Dmitry Smirnov   16 Feb 2012
;;
;; This file is a mixture of HTML and Guile --
;; see eguile-gnc.scm for details.
;;
;; This program is free software; you can redistribute it and/or
;; modify it under the terms of the GNU General Public License as
;; published by the Free Software Foundation; either version 2 of the
;; License, or (at your option) any later version.
;;
;; This program is distributed in the hope that it will be useful,
;; but WITHOUT ANY WARRANTY; without even the implied warranty of
;; MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
;; General Public License for more details.
;;
;; You should have received a copy of the GNU General Public License
;; along with this program; if not, write to the Free Software
;; Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA
;; 02111-1307 USA

  (define (display-report opt-invoice owner endowner ownertype)
;; Main function that creates the tax invoice report
(let* (; invoice and company details
   (invoiceid(gncInvoiceGetID opt-invoice))
   (credit-note? (gncInvoiceGetIsCreditNote opt-invoice))
   (book (gncInvoiceGetBook   opt-invoice))
   (postdate (gncInvoiceGetDatePosted opt-invoice))
   (duedate  (gncInvoiceGetDateDueopt-invoice))
   (billingid(gncInvoiceGetBillingID  opt-invoice))
   (notes(gncInvoiceGetNotes  opt-invoice))
   (terms(gncInvoiceGetTerms  opt-invoice))
   (termsdesc(gncBillTermGetDescription terms))
   (lot  (gncInvoiceGetPostedLot  opt-invoice))
   (txn  (gncInvoiceGetPostedTxn  opt-invoice))
   (currency (gncInvoiceGetCurrency   opt-invoice))
   (entries  (gncInvoiceGetEntriesopt-invoice))
   (splits  '())
   (coyname  (gnc:company-info book gnc:*company-name*))
   (coycontact   (gnc:company-info book gnc:*company-contact*))
   (coyaddr  (gnc:company-info book gnc:*company-addy*))

Re: [GNC] Custom invoices don't work after upgrade

[Christopher Lam]

Could you send these customised invoices as an attachment?

On Sat, 2 Jun 2018, 02:34 Jordan and Reidun Staudinger <
jordanandrei...@harewaves.net> wrote:

> Hi, I have had some pretty decent looking custom invoices set up in
> GnuCash for a few years now, and I've been quite happy with them.
> However, after the last update, I now get the following message when I
> try to load one of the saved invoice reports:
>
>
> An error occurred when processing the template:
>
> ERROR: Unbound variable: qof-book-get-slots
> In ice-9/eval.scm:
>   432: 7 [eval # #]
>   411: 6 [eval # #]
>   386: 5 [eval #)> (() # # # ...)]
>   393: 4 [eval # (() # # # ...)]
> In unknown file:
> ?: 3 [memoize-variable-access! # #]
>
>
> In order to get the invoices working previously, I had to put custom
> .css and .scm files in the
> /usr/share/gnucash/guile-modules/gnucash/report/ folder, which I now see
> no longer exists. So I did some poking around, and found that the files
> are now in /usr/share/gnucash/scm/gnucash/report/. They were already
> there without me adding them. Not sure if this is the reason for the
> error or not.
>
> Any help would be greatly appreciated, as this is preventing me from
> sending invoices to my customers.
>
> Thanks much, Reidun
>
>
>
> --
> BEGIN-ANTISPAM-VOTING-LINKS
> --
>
> Teach CanIt if this mail (ID 01VRuwM0D) is spam:
> Spam:
> http://199.217.123.251/canit/b.php?c=s=01VRuwM0D=04379ab31199
> Not spam:
> http://199.217.123.251/canit/b.php?c=n=01VRuwM0D=04379ab31199
> Forget vote:
> http://199.217.123.251/canit/b.php?c=f=01VRuwM0D=04379ab31199
> --
> END-ANTISPAM-VOTING-LINKS
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Replay log file option

[Michael Lewis]

I have lost much data due to GNU crashing. When using file- import-log replay I 
find that when I select the most recent log and open it, the file disappears 
from view and nothing happens! How do I activate it to update the master file? 
I have followed the instructions in the Manual but nothing happens.
Michael Lewis
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Custom invoices don't work after upgrade

[Jordan and Reidun Staudinger]

Hi, I have had some pretty decent looking custom invoices set up in 
GnuCash for a few years now, and I've been quite happy with them. 
However, after the last update, I now get the following message when I 
try to load one of the saved invoice reports:



   An error occurred when processing the template:

   ERROR: Unbound variable: qof-book-get-slots
   In ice-9/eval.scm:
 432: 7 [eval # #]
 411: 6 [eval # #]
 386: 5 [eval #)> (() # # # ...)]
 393: 4 [eval # (() # # # ...)]
   In unknown file:
   ?: 3 [memoize-variable-access! # #]


In order to get the invoices working previously, I had to put custom 
.css and .scm files in the 
/usr/share/gnucash/guile-modules/gnucash/report/ folder, which I now see 
no longer exists. So I did some poking around, and found that the files 
are now in /usr/share/gnucash/scm/gnucash/report/. They were already 
there without me adding them. Not sure if this is the reason for the 
error or not.


Any help would be greatly appreciated, as this is preventing me from 
sending invoices to my customers.


Thanks much, Reidun



--
BEGIN-ANTISPAM-VOTING-LINKS
--

Teach CanIt if this mail (ID 01VRuwM0D) is spam:
Spam:http://199.217.123.251/canit/b.php?c=s=01VRuwM0D=04379ab31199
Not spam:http://199.217.123.251/canit/b.php?c=n=01VRuwM0D=04379ab31199
Forget vote: http://199.217.123.251/canit/b.php?c=f=01VRuwM0D=04379ab31199
--
END-ANTISPAM-VOTING-LINKS

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

Re: [GNC] Posting sales in multiple currencies (2.6.21)

[Geert Janssens]

Op vrijdag 1 juni 2018 15:39:26 CEST schreef Matthew Pounsett:
> A short aside.. I think there may still be a bug here.
> 
> Even though Assets:Accounts Receivable is set to Placeholder, it gets
> offered as a choice for posting to when I'm posting an invoice... only when
> I try to post to it I get an error that I'm trying to post to a placeholder
> account.  It should probably be excluded from the list of choices.
> 
> I'll add that to the bugtracker.

It's probably a usability bug indeed. I don't think AR/AP accounts were ever 
intended to be used as placeholder accounts. You can probably convert the 
account type to Asset for AR and Liability for AP to work around this.

Regards,

Geert


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

Re: [GNC] Posting sales in multiple currencies (2.6.21)

[Matthew Pounsett]

A short aside.. I think there may still be a bug here.

Even though Assets:Accounts Receivable is set to Placeholder, it gets
offered as a choice for posting to when I'm posting an invoice... only when
I try to post to it I get an error that I'm trying to post to a placeholder
account.  It should probably be excluded from the list of choices.

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

Re: [GNC] Posting sales in multiple currencies (2.6.21)

[Matthew Pounsett]

On 1 June 2018 at 09:33, Matthew Pounsett  wrote:

>
>
> Have I missed something?
>
> Apparently I have.. I missed the Currency setting in the customer setup.

The odd thing is that I specifically went and looked for that.  But didn't
find it until after I hit send on the email.
Apologies for inflicting my caffeine deprived morning on everyone's
mailbox.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Posting sales in multiple currencies (2.6.21)

[Matthew Pounsett]

I have clients that get billed in their home currency.  I see what looks
like multiple bugs in handling this in GnuCash, and so I think maybe I'm
doing something wrong.

I have the following accounts in a test file where the default currency is
CAD.  Notes about each account's configuration in parentheses.

Assets:Accounts Receivable  (placeholder, currency CAD)
Assets:Accounts Receivable:CAD (currency CAD)
Assets:Accounts Receivable:USD (currency USD)
Income:Sales (placeholder, currency CAD)
Income:Sales:CAD (currency CAD)
Income:Sales:USD (currency USD)

When I create invoices and post them to accounts receivable in CAD
everything works as expected.

When I create an invoice and the Income Account is in USD, the summary at
the bottom of the dialogue (Total/Subtotal/Tax) is listed as CAD but not
converted.   For example, if I have an item with the income account set to
Income:Sales:USD, quantity 1, unit price 100.00, then the summary at the
bottom shows Total: C$100.00 Subtotal: C$100.00 Tax: C$0.00.

That's the first problem, but not very serious so I was going to just
ignore it.  However, the second problem is bigger... I'm unable to post the
invoice to Assets:Accounts Receivable:USD.

Since I'm billing in USD, and will get paid in USD, and the conversion to
CAD won't happen until (or if) I deposit the payment into my CAD account, I
should be able to track this in USD up until that point, but it doesn't
look like I can.

Have I missed something?

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