News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Customer TAX Registrat...

Microsoft Dynamics AX (Archived)

Customer TAX Registration Number X++ Code

(0) Share

Report

Report

Posted on by Mahmood Ali963

20

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

All responses Img

All responses (2)

Answers Img

Answers (0)

Mahmood Ali963 20 on at

Like (1)

Report

RE: Customer TAX Registration Number X++ Code

Thanks!
Mahmood Ali963 20 on at

Like (1)

Report

RE: Customer TAX Registration Number X++ Code

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans