Skip to main content

Posts

Showing posts with the label party location

Query to get Tax Registration Number by party Name in Ax 2012

This is the Query to get Tax Registration Number by party Name in Ax 2012. Intermediate table for DirPartyTable and taxRegistration is DirPartyLocation and registrationNumber is the field to get value of tax registration Number. DirPartyTable DirPartyTable; DirPartyLocation DirPartyLocation; taxRegistration taxRegistration; select * from DirPartyTable where DirPartyTable.Name == "TestName"; select * from DirPartyLocation where DirPartyLocation.Party == dirPartyTable.RecId; select registrationNumber from taxRegistration where taxRegistration.DirPartyLocation == dirPartyLocation.RecId; info(strFmt("reg %1",taxRegistration.RegistrationNumber));