[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Reverse Receipts Error - Required Input Not Provided



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&;