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&; ------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
