[Ledger-smb-devel] Empty LedgerSMB directories?

2012-01-08 Thread Robert James Clay
Something else I've found while working on the Debian packaging for LedgerSMB are some empty directories that end up in the binary package. What I'd like is clarification of the usage, if any, of the following directories ("ledgersmb" = /usr/share/ledgersmb/, from v1.3.9): ledgersmb/scripts/cust

[Ledger-smb-devel] Packaging LedgerSMB

2012-01-08 Thread Robert James Clay
On Thu, 2011-09-29 at 02:44 -0400, Raphael Hertzog wrote: > On Wed, 28 Sep 2011, Philippe Clérié wrote: > > Speaking of which, why aren't we using perl Makefile.PL ? It's a Perl > > program, and the command is used for the generic install? > > I can't answer your question as I have not worked on

Re: [Ledger-smb-devel] Errors in the Shipping/Receiving function (1.3.9)

2012-01-08 Thread Erik Huelsmann
Hi Nigel, >>> I've started testing 1.3.9 using our company work flows and seem to be >>> seeing errors in the shipping and receiving module >>> >>> 1. Shipping->Ship invokes the Order Entry->Consolidate function >> >> Looking into this one. > > I looked and found the issue. Committed the fix too.

Re: [Ledger-smb-devel] Errors in the Shipping/Receiving function (1.3.9)

2012-01-08 Thread Erik Huelsmann
Hi Nigel, >> I've started testing 1.3.9 using our company work flows and seem to be >> seeing errors in the shipping and receiving module >> >> 1. Shipping->Ship invokes the Order Entry->Consolidate function > > Looking into this one. I looked and found the issue. Committed the fix too. As the ot

Re: [Ledger-smb-devel] Errors in the Shipping/Receiving function (1.3.9)

2012-01-08 Thread Erik Huelsmann
Hi Nigel, On Fri, Dec 30, 2011 at 1:08 AM, Nigel Titley wrote: > Folks, > > I've started testing 1.3.9 using our company work flows and seem to be > seeing errors in the shipping and receiving module > > 1. Shipping->Ship invokes the Order Entry->Consolidate function Looking into this one. > 2.

Re: [Ledger-smb-devel] Another bug in Receiving module (1.3.9)

2012-01-08 Thread Erik Huelsmann
Hi Nigel, On Sun, Jan 8, 2012 at 9:40 PM, Erik Huelsmann wrote: > Hi Nigel, > > On Fri, Dec 30, 2011 at 1:12 AM, Nigel Titley wrote: >> The Shipping->Receive screen has no report selection drop downs. The >> print button is present but when clicked gives >> >> Error! >> >> Select txt, postscript

Re: [Ledger-smb-devel] Another bug in Receiving module (1.3.9)

2012-01-08 Thread Erik Huelsmann
Hi Nigel, On Fri, Dec 30, 2011 at 1:12 AM, Nigel Titley wrote: > The Shipping->Receive screen has no report selection drop downs. The > print button is present but when clicked gives > > Error! > > Select txt, postscript or PDF! My company isn't correctly set up to test this, but does this patch

Re: [Ledger-smb-devel] reserve entity_class myEntity

2012-01-08 Thread Erik Huelsmann
Hi Herman, On Thu, Dec 22, 2011 at 6:10 PM, herman vierendeels wrote: > Hello, > > I would like to reserve new class in entity_class. > Namely , myEntity, meaning my own company. So i can stock much more > info about me than is possible now in defaults table. > > Can i do this by adapting  sql/Pg

Re: [Ledger-smb-devel] Records in AR table with NULL amount field

2012-01-08 Thread Erik Huelsmann
On Fri, Dec 23, 2011 at 12:24 AM, Chris Travers wrote: > On Thu, Dec 22, 2011 at 2:19 PM, Erik Huelsmann wrote: >> Hi all, >> >> As part of my efforts to establish that my LSMB database hasn't been >> damaged by the multi-currency problems that we found and fixed in >> 1.3.10, I'm looking at the

Re: [Ledger-smb-devel] More conservative screen-width use in Payments screen?

2012-01-08 Thread Erik Huelsmann
Hi Herman, > As i see it , you would like to use shorter names. e.g 'Amount Due' -> 'Due' > But why not use  locale/po/en.po to get shorter names? > e.g. > msgid "Amount Due" > msgstr "Due" > > msgid  'Due' is nearly intranslatable without context. It could be > 'Amount Due','Date Due' etc. Thank

[Ledger-smb-devel] Proposed way forward wrt reversal of older FX transactions

2012-01-08 Thread Erik Huelsmann
In one of my mails of december 2011 I mentioned we have a problem with the reversal of payments to foreign currency AR and AP transactions. The problem is that the amount in the original currency isn't recorded anywhere. Instead, the FX amount is calculated dynamically (everytime it's required) usi

Re: [Ledger-smb-devel] Refactored Payment.sql::payment_bulk_post()

2012-01-08 Thread Erik Huelsmann
> So, if I understand correctly, you're referring to this PostgreSQL > FAQ: > http://wiki.postgresql.org/wiki/FAQ#Why_do_I_get_.22relation_with_OID_.23.23.23.23.23_does_not_exist.22_errors_when_accessing_temporary_tables_in_PL.2FPgSQL_functions.3F If what the FAQ says is true, the function below

Re: [Ledger-smb-devel] Refactored Payment.sql::payment_bulk_post()

2012-01-08 Thread Erik Huelsmann
Hi Chris, > The execute statements are necessary because PLPGSQL caches query > plans, meaning that repeat runs of the function will generate errors > in the same session unless EXECUTE is used. > > I will be back in Jakarta tomorrow and will be resuming normal work schedule. Great! I had some ti

Re: [Ledger-smb-devel] Refactored Payment.sql::payment_bulk_post()

2012-01-08 Thread Chris Travers
Hi; The execute statements are necessary because PLPGSQL caches query plans, meaning that repeat runs of the function will generate errors in the same session unless EXECUTE is used. I will be back in Jakarta tomorrow and will be resuming normal work schedule. Best Wishes, Chris Travers ---

[Ledger-smb-devel] Refactored Payment.sql::payment_bulk_post()

2012-01-08 Thread Erik Huelsmann
Hi Chris, others, In my pursuit of posting the correct FX effects (gains/losses) when creating payments, I'm looking at payment_bulk_post(). However, the function is too obfuscated to look at. Before I continue, I'd like to factor out all the EXECUTE statements, so that the new function becomes