Hi. I'm adding extra information on CustAgingReport and it's using insert_recordset to copy data into temporary table. I added fields from CustTable and it's working fine.
The problem is getting a value from method. I tried assigning the value to variable first but obviously it will return empty value.
Please help correct my approach. Thank You.
CustTable tmpCustTable;
Phone contactNo;
contactNo = tmpCustTable.phone();
INSERT_RECORDSET custAgingReportTmp
(AccountNum, Name, CustAccount, Txt, Currency, CustGroup, BillingClassification, Balance, ContactNo, SortOrder, SalesGroup, CreditMax, CreditMaxCust, SegmentId, PaymTermId)
SELECT
AccountNum, Name, AccountNum, Txt, CurrencyCode, GroupId, BillingClassification, balance, contactNo
FROM tmpAccountSum
JOIN SortOrder
FROM custVendTransAging
WHERE tmpAccountSum.AccountNum == custVendTransAging.AccountNum
JOIN SalesGroup, CreditMax, CreditMaxCust, SegmentId, PaymTermId
FROM tmpCustTable
WHERE tmpCustTable.AccountNum == tmpAccountSum.AccountNum;
