fetch two table records together and add them as one record ,how ?
V551070.Select
V551070.Fetch Next
While SV File_IO_Status is equal to CO SUCCESS
If VA rpt_GL is greater than or equal to PO StartDate And VA rpt_GL is less than or equal to PO EndDate
VA rpt_TotalAmount = [VA rpt_TransactionAmount]+[VA rpt_CheckAmount]
If VA rpt_TotalAmount is greater than or equal to <Zero>
VA rpt_TotalDebit = VA rpt_TotalAmount
VA rpt_TotalAmount = "0"
Else
VA rpt_TotalCredit = VA rpt_TotalAmount
VA rpt_TotalAmount = "0"
End If
End If
V551070.Fetch Next
End While
RV Credit2 = VA rpt_TotalCredit
RV Debit2 = VA rpt_TotalDebit