hi,
i need to create payment voucher report.the report will generate after post the journal . i need to display the transaction date and invoice no from vendtrans table. so i tried to join vendtrans and vendsettlement.but when i generate the report, no data from that field.
i wrote the code as below:
while select vendTrans
join VendSettlement
where vendSettlement.AccountNum == vendTrans.AccountNum
&& vendSettlement.TransCompany == vendTrans.dataAreaId
&& vendSettlement.TransRecId == vendTrans.RecId
join VendInvoiceJour
where VendInvoiceJour.InvoiceAccount == vendTable.AccountNum
&& VendInvoiceJour.LedgerVoucher == VendTrans.voucher
&& VendInvoiceJour.InvoiceDate == VendTrans.TransDate
join vendtransopen
where vendtransopen.AccountNum == vendTrans.AccountNum
&& vendtransopen.RefRecId == vendTrans.RecId
{
gTmpPaymDocu.Invoice = vendTrans.Invoice;
gTmpPaymDocu.VendTransTransDate = vendTrans.TransDate;
gTmpPaymDocu.insert();
}
---end of code
Thanks
*This post is locked for comments
I have the same question (0)
