Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Missing ChequeNo in Payments.php?
12-11-2018, 12:06 AM, (This post was last modified: 12-11-2018, 12:15 AM by VortecCPI.)
#1
Missing ChequeNo in Payments.php?
On or about line 530 we are not inserting ChequeNo into the BankTrans table:

PHP Code:
                    $SQL "INSERT INTO banktrans (
                                transno,
                                type,
                                bankact,
                                ref,
                                exrate,
                                functionalexrate,
                                transdate,
                                banktranstype,
                                amount,
                                currcode
                            ) VALUES ('" 
.
                                
$ReceiptTransNo "',
                                2,'" 
.
                                
$PaymentItem->GLCode "','" .
                                
'@' $TransNo ' ' _('Act Transfer From') .' '$_SESSION['PaymentDetail'.$identifier]->Account ' - ' $PaymentItem->Narrative "','" .
                                
$ExRate "','" .
                                
$TrfToBankExRate "','" .
                                
FormatDateForSQL($_SESSION['PaymentDetail'.$identifier]->DatePaid) . "','" .
                                
$_SESSION['PaymentDetail'.$identifier]->Paymenttype "','" .
                                
$PaymentItem->Amount "','" .
                                
$_SESSION['PaymentDetail'.$identifier]->Currency .
                            
"')"

Should this not be:

PHP Code:
                    $SQL "INSERT INTO banktrans (
                                transno,
                                type,
                                bankact,
                                ref,
                                exrate,
                                functionalexrate,
                                transdate,
                                banktranstype,
                                amount,
                                currcode,
                                chequeno
                            ) VALUES ('" 
.
                                
$ReceiptTransNo "',
                                2,'" 
.
                                
$PaymentItem->GLCode "','" .
                                
'@' $TransNo ' ' _('Act Transfer From') .' '$_SESSION['PaymentDetail'.$identifier]->Account ' - ' $PaymentItem->Narrative "','" .
                                
$ExRate "','" .
                                
$TrfToBankExRate "','" .
                                
FormatDateForSQL($_SESSION['PaymentDetail'.$identifier]->DatePaid) . "','" .
                                
$_SESSION['PaymentDetail'.$identifier]->Paymenttype "','" .
                                
$PaymentItem->Amount "','" .
                                
$_SESSION['PaymentDetail'.$identifier]->Currency "','" .
                                
$PaymentItem->Cheque .
                            
"')"

Also... How are we reconciling the parent Cheque Number with those in the individual child GL entries? The parent Cheque Number can not be blank so is it assumed it must match one of those in the child GL entries?
https://www.linkedin.com/in/eclipsepaulbecker
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)