Re: [Ledger-smb-devel] 1.3: 1099 reports?

2011-12-30 Thread Chris Travers
On Fri, Dec 30, 2011 at 10:13 PM, John Locke wrote: >  id  |           role_name            | acl_type | node_id > -++--+- >  560 | lsmb_freelockco__tax_form_save | allow    |     226 > (1 row) Is that role granted to your user? Best Wishes. Ch

Re: [Ledger-smb-devel] 1.3: 1099 reports?

2011-12-30 Thread John Locke
id | role_name| acl_type | node_id -++--+- 560 | lsmb_freelockco__tax_form_save | allow| 226 (1 row) On 12/30/2011 07:43 PM, Chris Travers wrote: > Ok, so anything when you: > > select * from menu_acl where node_

Re: [Ledger-smb-devel] 1.3: 1099 reports?

2011-12-30 Thread Chris Travers
Ok, so anything when you: select * from menu_acl where node_id = 226 On Fri, Dec 30, 2011 at 11:14 AM, John Locke wrote: > Attached... > > I can find the item in the menu, and I can create a report -- which is > just a label and a country and a checkbox for making it default. But no > data shows

Re: [Ledger-smb-devel] Possible Add-on?

2011-12-30 Thread Chris Travers
On Fri, Dec 30, 2011 at 9:41 AM, Chris Bennett wrote: > What I have developed for my business, which is newconstruction and > remodeling, started as a database of products, vendors selling those > products, customers and the actual job sites, which a customer may have > several, such as home an

Re: [Ledger-smb-devel] Error when upgrading 1.2 db to 1.3 db

2011-12-30 Thread Chris Travers
Check the /tmp/ledgersmb/dblog_stderr for the error. Best Wishes, Chris Travers -- Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure

Re: [Ledger-smb-devel] Error when upgrading 1.2 db to 1.3 db

2011-12-30 Thread Nigel Titley
On 30/12/11 23:36, Nigel Titley wrote: > On 30/12/11 23:03, ehu...@gmail.com wrote: >> Hi nigel, >> >> this is a known issue: your server doesn't have the postgresql contribs or >> they didn't get imported in your db. If you use setup.pl, be sure the path >> in ledgersmb.conf points to the right

Re: [Ledger-smb-devel] Error when upgrading 1.2 db to 1.3 db

2011-12-30 Thread Nigel Titley
On 30/12/11 23:03, ehu...@gmail.com wrote: > Hi nigel, > > this is a known issue: your server doesn't have the postgresql contribs or > they didn't get imported in your db. If you use setup.pl, be sure the path in > ledgersmb.conf points to the right dir (9.0 or below). I have postgresql contri

Re: [Ledger-smb-devel] Error when upgrading 1.2 db to 1.3 db

2011-12-30 Thread ehu...@gmail.com
Hi nigel, this is a known issue: your server doesn't have the postgresql contribs or they didn't get imported in your db. If you use setup.pl, be sure the path in ledgersmb.conf points to the right dir (9.0 or below). Hth, erik. Sent from my Nokia phone -Original Message- From: Nigel

Re: [Ledger-smb-devel] Error when upgrading 1.2 db to 1.3 db

2011-12-30 Thread Nigel Titley
On 30/12/11 22:49, Nigel Titley wrote: > Testing the upgrade 1.2 to 1.3 functionality I get the following error > > Error! > > 42883:ERROR: function public.person__list_salutations() does not exist > LINE 1: SELECT * FROM "public"."person__list_salutations"() ^ HINT: No > function matches the giv

[Ledger-smb-devel] Error when upgrading 1.2 db to 1.3 db

2011-12-30 Thread Nigel Titley
Testing the upgrade 1.2 to 1.3 functionality I get the following error Error! 42883:ERROR: function public.person__list_salutations() does not exist LINE 1: SELECT * FROM "public"."person__list_salutations"() ^ HINT: No function matches the given name and argument types. You might need to add exp

Re: [Ledger-smb-devel] Multicurrency issue, concerns, and proposed longer-term direction.

2011-12-30 Thread Erik Huelsmann
On Fri, Dec 30, 2011 at 3:10 PM, Erik Huelsmann wrote: > Hi Chris, > >> We have been having a slight multicurrency issue with payments that we >> do not believe can be adequately resolved inside a stable branch. >> Fortunately this issue is not severe and it may be able to be possible >> to create

Re: [Ledger-smb-devel] Bug in Contact editor

2011-12-30 Thread Nigel Titley
On 30/12/11 19:30, Erik Huelsmann wrote: > Hi Nigel, > > Great! We've been using LSMB 1.3 in production since before 1.3.0. On > average, we're really happy, although there are some smaller issues > we're still finding. Having others comb through the app as well really > helps and benefits us all.

Re: [Ledger-smb-devel] Possible Add-on?

2011-12-30 Thread Erik Huelsmann
Hi Chris, On Fri, Dec 30, 2011 at 6:41 PM, Chris Bennett wrote: > What I have developed for my business, which is newconstruction and > remodeling, started as a database of products, vendors selling those > products, customers and the actual job sites, which a customer may have > several, such

Re: [Ledger-smb-devel] Bug in Contact editor

2011-12-30 Thread Erik Huelsmann
Hi Nigel, > I've started my staff off on testing 1.3 with the aim of bringing it > into production service by year end (31st March 2012). The following bug > and feature request come out of that program Great! We've been using LSMB 1.3 in production since before 1.3.0. On average, we're really ha

Re: [Ledger-smb-devel] 1.3: 1099 reports?

2011-12-30 Thread John Locke
Attached... I can find the item in the menu, and I can create a report -- which is just a label and a country and a checkbox for making it default. But no data shows up, and I don't understand what the checkbox is for or how to get data into this report. Also, on the menu_friendly view, when I fi

[Ledger-smb-devel] Possible Add-on?

2011-12-30 Thread Chris Bennett
What I have developed for my business, which is newconstruction and remodeling, started as a database of products, vendors selling those products, customers and the actual job sites, which a customer may have several, such as home and business. For me, I found entering updates and new data very

[Ledger-smb-devel] Bug in Contact editor

2011-12-30 Thread Nigel Titley
I've started my staff off on testing 1.3 with the aim of bringing it into production service by year end (31st March 2012). The following bug and feature request come out of that program Bug: When editing contact information the Description field is not populated with the existing information and

Re: [Ledger-smb-devel] OpenBSD and 1.3

2011-12-30 Thread Chris Bennett
On Thu, Dec 29, 2011 at 02:48:49PM +0100, H?vard S?rli wrote: > On 29. des. 2011 08:38, Chris Travers wrote: > > Did you want me to copy it? Or just link to it? > > I can copy it / link it my self, but it was more as a question to Chris > Benett if he would like to contribute it as an article. >

Re: [Ledger-smb-devel] Multicurrency issue, concerns, and proposed longer-term direction.

2011-12-30 Thread Chris Travers
On Fri, Dec 30, 2011 at 2:33 AM, Pete Houston wrote: > On Thu, Dec 29, 2011 at 04:41:47PM -0800, Chris Travers wrote: >> My recommendation at present is to do as follows: >> >> 1)  Add a user-configurable threshold setting (and make it default to >> 0.005) for paid in full payments. >> 2)  Either

Re: [Ledger-smb-devel] Multicurrency issue, concerns, and proposed longer-term direction.

2011-12-30 Thread Michael Richardson
> "Chris" == Chris Travers writes: Chris> default to 0.005) for paid in full payments. 2) Either Chris> accept there could be a few cents of drift in AR/AP or create Chris> an SQL script to correct this if we need to. The script sounds good to me, as long as it's called "Superma

Re: [Ledger-smb-devel] Multicurrency issue, concerns, and proposed longer-term direction.

2011-12-30 Thread Erik Huelsmann
Hi Chris, > We have been having a slight multicurrency issue with payments that we > do not believe can be adequately resolved inside a stable branch. > Fortunately this issue is not severe and it may be able to be possible > to create a periodic job to fix the problem. > The issue is that the wa

Re: [Ledger-smb-devel] 1.3: 1099 reports?

2011-12-30 Thread Nigel Titley
On 30/12/11 07:09, John Locke wrote: > Not seeing anything here... Maybe I'm dense, but I'm finding the whole > tax form thing really confusing. I do see checkboxes on line items on AP > transactions, but... > > What is a "Tax Form" in LSMB? How does it relate to a tax? How do I get > numbers to s

Re: [Ledger-smb-devel] Multicurrency issue, concerns, and proposed longer-term direction.

2011-12-30 Thread Nigel Titley
On 30/12/11 10:33, Pete Houston wrote: > On Thu, Dec 29, 2011 at 04:41:47PM -0800, Chris Travers wrote: >> My recommendation at present is to do as follows: >> >> 1) Add a user-configurable threshold setting (and make it default to >> 0.005) for paid in full payments. >> 2) Either accept there co

Re: [Ledger-smb-devel] Multicurrency issue, concerns, and proposed longer-term direction.

2011-12-30 Thread Pete Houston
On Thu, Dec 29, 2011 at 04:41:47PM -0800, Chris Travers wrote: > My recommendation at present is to do as follows: > > 1) Add a user-configurable threshold setting (and make it default to > 0.005) for paid in full payments. > 2) Either accept there could be a few cents of drift in AR/AP or > cre

Re: [Ledger-smb-devel] 1.3: 1099 reports?

2011-12-30 Thread Chris Travers
Can you attach a dump of what's in the menu_friendly view? Best Wishes, Chris Travers -- Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, s