Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Batch Printout Bug
09-08-2016, 10:09 PM,
#1
Batch Printout Bug
Hi,
I posted the following entries using the "Bank Accounts Receipt Entry".
The reason was that the tax office netted out the 300 due to me with the 29 due to them.

Batch Date Banked GL Code Amount
6 23.08.2016 1250-30 - Income Tax Receivable - Communal 300.00
6 23.08.2016 2250-30 - Income Tax Payable - Communal -29.00
6 23.08.2016 2250-30 - Income Tax Payable - Communal 29.00
6 23.08.2016 9100-30 - Income Tax Provision-Communal -29.00

The book entries are OK and the GL account show the proper balance, but when I tried to print the receipt for the batch, I noted that the 2 negative entries were not reported (see attachment).

Any way to fix this?
Thanks,
George


Attached Files Thumbnail(s)
   
Reply
09-08-2016, 10:21 PM,
#2
RE: Batch Printout Bug
Hi George, you are correct. The SQL at line 116 of PDFBankingSummary.php should read:

$SQL = "SELECT narrative,
amount
FROM gltrans
WHERE gltrans.typeno='" . $_POST['BatchNo'] . "'
AND gltrans.type=12
AND gltrans.account !='" . $myrow['bankact'] . "'
AND gltrans.account !='" . $_SESSION['CompanyRecord']['debtorsact'] . "'";

Changing this and re-running for that batch should work

Thanks
Tim
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)