On Tue, Sep 25, 2012 at 11:36 AM, Nick Prater
<..hidden..> wrote:
I am trying to reverse a receipt and am getting a message:
"Error! Required input not provided"
I am using ledgersmb 1.3.22, installed from tarball.
I go to Cash->Vouchers->Reverse Receipts.
I am then prompted to "Create New Batch".
There are three fields displayed: "Batch Number" and "Batch Description"
are already filled in, for "Batch Date" I enter "2012-09-25", then click
"Continue".
The message "Error! Required input not provided" then appears.
The apache error log mentions:
ERROR: null value in column "batch_class_id" violates not-null constraint.
Sounds like a menu problem. I will look into this today.
Best Wishes,
Chris Travers
I'd appreciate any help or advice you're able to offer in resolving this.
More log output is included below.
Many thanks
Nick
-- apache error log output below --
[Tue Sep 25 18:58:01 2012] [error] [client 127.0.0.1] 2012/09/25 18:58:01
- ERROR - LedgerSMB::dberror LedgerSMB.pm (1098) -- Logging SQL State
23502, error 7, string ERROR: null value in column "batch_class_id"
violates not-null constraint, referer:
http://localhost/ledgersmb/vouchers.pl?login=nprater&action="">
[Tue Sep 25 18:58:01 2012] [error] [client 127.0.0.1] CONTEXT: SQL
statement "INSERT INTO , referer:
http://localhost/ledgersmb/vouchers.pl?login=nprater&action="">
[Tue Sep 25 18:58:01 2012] [error] [client 127.0.0.1] \t\tbatch
(batch_class_id, default_date, description, control_code,, referer:
http://localhost/ledgersmb/vouchers.pl?login=nprater&action="">
[Tue Sep 25 18:58:01 2012] [error] [client 127.0.0.1] \t\t\tcreated_by),
referer:
http://localhost/ledgersmb/vouchers.pl?login=nprater&action="">
[Tue Sep 25 18:58:01 2012] [error] [client 127.0.0.1] \tVALUES ((SELECT id
FROM batch_class WHERE class = in_batch_class),, referer:
http://localhost/ledgersmb/vouchers.pl?login=nprater&action="">
[Tue Sep 25 18:58:01 2012] [error] [client 127.0.0.1] \t\tin_batch_date,
in_description, in_batch_number, , referer:
http://localhost/ledgersmb/vouchers.pl?login=nprater&action="">
[Tue Sep 25 18:58:01 2012] [error] [client 127.0.0.1] \t\t\t(select
entity_id FROM users WHERE username = session_user))", referer:
http://localhost/ledgersmb/vouchers.pl?login=nprater&action="">
[Tue Sep 25 18:58:01 2012] [error] [client 127.0.0.1] PL/pgSQL function
"batch_create" line 3 at SQL statement, referer:
http://localhost/ledgersmb/vouchers.pl?login=nprater&action="">
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users