Hi Martin,
Thanks for the response. Then could you please let me know how to get below insert method done without loosing records.
My requirement is to add Employee responsible to the Customer Aging Report. There was no error when use just join, without outer. But it drops customers without employee responsible from the report. If allow nulls is not an option, could you please let me know how to get this fixed?
Thanks,
Dumindu
insert_recordset custAgingReportTmp
(Balance01, Balance02, Balance03, Balance04, Balance05, Balance06, Balance07,
Balance01cur, Balance02cur, Balance03cur, Balance04cur, Balance05cur, Balance06cur, Balance07cur,
TransDate, InvoiceId, Voucher, AccountNum, Name, CustAccount, Txt, Currency, CustGroup, BillingClassification,
AsOfDate, HeadingAccount, HeadingName, HeadingDate, Heading1, Heading2DateValue, Heading2,
Heading3, Heading4, Heading5, Heading6, Heading7DateValue, Heading7, Heading8, Heading9,
Heading10, Heading11, Heading12, Heading13, Heading14, HeadingAgingBucketDescription02,
HeadingAgingBucketDescription03, HeadingAgingBucketDescription04, HeadingAgingBucketDescription05,
HeadingAgingBucketDescription06, HeadingAgingBucketDescription07, Balance, SortOrder, AMS_EmpRes)
select
Balance01, Balance07, Balance06, Balance05, Balance04, Balance03, Balance02,
Balance01cur, Balance07cur, Balance06cur, Balance05cur, Balance04cur, Balance03cur, Balance02cur,
TransDate, InvoiceId, Voucher, AccountNum, Name, AccountNum, Txt, CurrencyCode, GroupId, BillingClassification,
asOfDate, headingAccount, headingName, headingDate, heading01, heading02, heading07Text,
heading03, heading04, heading05, heading06, heading07, heading02Text, heading011, heading03,
heading031, heading041, heading051, heading061, heading061, headingAgingBucketDescription02,
headingAgingBucketDescription03, headingAgingBucketDescription04, headingAgingBucketDescription05,
headingAgingBucketDescription06, headingAgingBucketDescription07, balance
from tmpAccountSum
join SortOrder
from custVendTransAging
where tmpAccountSum.AccountNum == custVendTransAging.AccountNum
outer join AMS_tmpCustTable where AMS_tmpCustTable.AccountNum == custVendTransAging.AccountNum
outer join AMS_tmpHCMWORKER where AMS_tmpHCMWORKER.recid == AMS_tmpCustTable.MainContactWorker
outer join NAME from AMS_tmpDirPartyTable where AMS_tmpDirPartyTable.recid == AMS_tmpHCMWORKER.PERSON;
