[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Reverse Receipts Error - Required Input Not Provided
- Subject: Reverse Receipts Error - Required Input Not Provided
- From: "Nick Prater" <..hidden..>
- Date: Tue, 25 Sep 2012 19:36:14 +0100 (BST)
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.
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=create_batch&batch_type=receipt_reversal&module=vouchers.pl&
[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=create_batch&batch_type=receipt_reversal&module=vouchers.pl&
[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=create_batch&batch_type=receipt_reversal&module=vouchers.pl&
[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=create_batch&batch_type=receipt_reversal&module=vouchers.pl&
[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=create_batch&batch_type=receipt_reversal&module=vouchers.pl&
[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=create_batch&batch_type=receipt_reversal&module=vouchers.pl&
[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=create_batch&batch_type=receipt_reversal&module=vouchers.pl&
[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=create_batch&batch_type=receipt_reversal&module=vouchers.pl&