web

You’re offline. This is a read only version of the page.

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Mahmood Ali963 20 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Mahmood Ali963 20 on at

Like (1)

Report
Copy link

Link copied!

Thanks!

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#2

Sagar Suman 2 Super User 2026 Season 1

#2

Alexey Lekanov 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans