On Sat, Oct 4, 2014 at 2:26 PM, Erik Huelsmann <ehu...@gmail.com> wrote:
> Hi Stephen,
>
>
> On Sat, Oct 4, 2014 at 10:28 PM, Stephen Winnall <st...@winnall.ch> wrote:
>
>> I have my database (PostgreSQL 9.3) on one Ubuntu 14.04 machine and my
>> LedgerSMB 1.4.2 on another Ubuntu 14.04 machine. I updated LSMB from 1.3.33
>> (I think) via 1.3.44, 1.4.0 and 1.4.1.
>>
>> My database contains a small number of entries going back 3 or four years
>> (mainly GL). The language is German (Switzerland).
>>
>> Problem 1)
>> My books are closed after a year-end. I tried to reopen them. My browser
>> says:
>>
>> Error!
>>
>> Access Denied
>> More information has been reported in the error logs at LedgerSMB.pm line
>> 775.
>>
>> dbversion: 1.4.2, company: my-company
>>
>> I get the following error in my PostgreSQL log:
>>
>> 2014-10-04 20:05:51 GMT ERROR: permission denied for sequence
>> account_checkpoint_id_seq
>>
>
> Ok. Dealing with this one should not be too hard. If you log into your
> database with psql, you should execute the following command:
>
> grant USAGE, SELECT, UPDATE on account_checkpoint_id_seq to public;
>
I have a patch committed for 1.4.4, to grant this to the yearend_run role.
>
>
>
>> 2014-10-04 20:05:51 GMT CONTEXT: SQL statement "INSERT INTO
>> account_checkpoint (end_date, account_id, amount, debits,
>> credits)
>> SELECT in_end_date, COALESCE(a.chart_id, cp.account_id),
>> COALESCE(SUM (a.amount),0) + coalesce(MAX
>> (cp.amount), 0),
>> COALESCE(SUM (CASE WHEN (a.amount < 0) THEN a.amount
>> ELSE 0 END), 0) +
>> COALESCE( MIN (cp.debits), 0),
>> COALESCE(SUM (CASE WHEN (a.amount > 0) THEN a.amount
>> ELSE 0 END), 0) +
>> COALESCE( MAX (cp.credits), 0)
>> FROM
>> (SELECT * FROM acc_trans WHERE transdate <= in_end_date
>> AND
>> transdate > COALESCE(cp_date, '1200-01-01')) a
>> FULL OUTER JOIN (
>> select account_id, end_date, amount, debits,
>> credits
>> from account_checkpoint
>> WHERE end_date = cp_date
>> ) cp on (a.chart_id = cp.account_id)
>> group by COALESCE(a.chart_id, cp.account_id)"
>> PL/pgSQL function eoy_create_checkpoint(date) line 27 at SQL
>> statement
>> SQL function "eoy__reopen_books_at" statement 2
>> 2014-10-04 20:05:51 GMT STATEMENT: SELECT * FROM
>> "public"."eoy__reopen_books_at"('2011-10-01')
>>
>> (Yes, I know it says 2011…)
>>
>> Problem 2)
>> When I try to add a new journal entry to GL, the form comes up without a
>> pre-generated reference number although System > Settings shows sensible
>> “Next in Sequence” values.
>>
>
> That's correct. 1.4 changed behaviour from 1.3 in the sense that if you
> don't set a sequence value, the next value is inserted into the ledger. In
> 1.3, you could update the GL entry page 5 times and the GL sequence number
> would get increased by 5. Due to this new behaviour, that's no longer the
> case.
>
That would happen if you deleted the reference and hit update. The larger
issue was that it made gapless numbering a lot more problematic because
abandoned transactions would create gaps even if not even saved.
The original reason for the behavior in 1.3 was that 1.2 redirected to a
new blank screen so folks wouldn't know the references of the transactions
entered. But then we changed this behavior so it wasn't applicable any
more so we reverted back tot he way we did things before.
>
> Myself, I usually keep a database for experimenting - a copy from the
> production database. If you have something similar, you could try my
> suggestions there first.
>
>
> --
> Bye,
>
> Erik.
>
> http://efficito.com -- Hosted accounting and ERP.
> Robust and Flexible. No vendor lock-in.
>
>
> ------------------------------------------------------------------------------
> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>
> http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
> _______________________________________________
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users