web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Exist Join Query
Microsoft Dynamics AX (Archived)

Exist Join Query

(0) ShareShare
ReportReport
Posted on by AX 2012 r3 2,426

Good Morning,

i am using this join Query then i am getting data.

But i need is to use Exists join.

update_recordset ISPLSalesRegisterGSTReportTmp
setting gstinnumber = taxRegsistartionNumbers_IN.RegistrationNumber
join Name,RecId from dirPartyTable
join party,RecId,Location from dirPartyLocation where dirPartyLocation.Party == dirPartyTable.RecId && dirPartyLocation.IsPrimary == NoYes::Yes
join RecId from logisticsLocation where logisticsLocation.RecId == dirPartyLocation.location && logisticsLocation.ispostaladdress == NoYes::Yes
join RecId,GSTIN from taxInformation_IN where taxInformation_IN.RegistrationLocation == logisticsLocation.RecId && taxInformation_IN.IsPrimary == NoYes::Yes
join RecId,RegistrationNumber from taxRegsistartionNumbers_IN where taxRegsistartionNumbers_IN.RecId == taxInformation_IN.GSTIN
exists join custTable
where custTable.Party == dirPartyTable.RecId
&& custTable.AccountNum == ISPLSalesRegisterGSTReportTmp.InvoiceAccount;

Relation is as follows

i inserted all invoices then their Order accounts will also be inserted

 1)ISPLSalesRegisterGSTReportTmp.InvoiceAccount == custTable.AccountNum

2)custTable.Party  == dirPartyLocation.Party &&  dirPartyLocation.IsPrimary == NoYes::Yes

3)logisticsLocation.RecId == dirPartyLocation.location && logisticsLocation.ispostaladdress == NoYes::Yes

4)taxInformation_IN where taxInformation_IN.RegistrationLocation == logisticsLocation.RecId && taxInformation_IN.IsPrimary == NoYes::Yes

 5)taxRegsistartionNumbers_IN where taxRegsistartionNumbers_IN.RecId == taxInformation_IN.GSTIN

in taxRegsistartionNumbers_IN  Registration number field i need

 

How can i achieve this.

Please help me .

Regards.

Have a great day.

*This post is locked for comments

I have the same question (0)
  • Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at

    Hi,

    Could you explain about your business requirement.

  • AX 2012 r3 Profile Picture
    AX 2012 r3 2,426 on at

    Hi,

    Chaitanya

    i am going to fetch Customer Master GSTIN Number which is located in Customer --> Address --> Tax Information Tab

    So,i have Customer Number ISPLSalesRegisterGSTReportTmp.InvoiceAccount

    i am joining link.

    This GSTIN Number is present in table taxRegsistartionNumbers_IN.RegistrationNumber

    So,this was the requirement .

    Regards.

    Have a great day.

  • Verified answer
    AX 2012 r3 Profile Picture
    AX 2012 r3 2,426 on at

    I have done this.

    This is the Query

    This Link Helped Me

    http://www.microsoftdynamicsax365.com/update_recordset-gstin-number/

     

    This might help some one in future.

    Regards.

    Have a great day.

  • B K Sharma Profile Picture
    B K Sharma 737 on at

    Hi,

    If your are looking for Sales Order - Customer gstin number than you can use this code

    _SalesOrderInvoiceTmp.CustomerGSTRegNum        = TaxInformation_IN::find(salesLine_IN.CustomerTaxInformation).getTaxRegistrationNumbersTable(TaxType_IN::GST).RegistrationNumber;

    Thanks

  • AX 2012 r3 Profile Picture
    AX 2012 r3 2,426 on at

    Hi Sharma,

    I am Updating At a time.

    yes i am also taking from sales order only.

    Inserted Customer numbers and Updating their GSTIN Numbers.

    Regards.

    Have a great day.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 10

#2
Harisgillani Profile Picture

Harisgillani 4

#2
dserp Profile Picture

dserp 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans