Hi,
Can anyone organised my below x++ code, I am new to x++ & would like to get TRN in SalesInvoiceDP as i can achieve it using below but would like to optimize it.
select * from custable
where custable.AccountNum==salesTable.InvoiceAccount;
select *From dirpartytable
where dirpartytable.RecId==custable.Party;
select *From dirpartylocation
where dirpartylocation.Party==dirpartytable.RecId && dirpartylocation.IsPrimary==1;
select RegistrationNumber from taxregistration
where taxregistration.DirPartyLocation == dirPartyLocation.RecId && taxregistration.ValidTo>=today();
Thanks in advance.
Regards
Mahmood
*This post is locked for comments
Thanks!
Hi Crispin,
Thank you very much! it works.
salesInvoiceHeaderFooterTmp.LHGCustTRN = TaxRegistration::getTaxRegistrationNumberFromCust(_custInvoiceJour.OrderAccount,_custInvoiceJour.InvoiceDate,TaxRegistrationType::findByType("UAE TRN").recid);
Can you please tell me if any such method available for vendor also.
Thanks
Mahmood
André Arnaud de Cal...
292,162
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156