i want to display the company related information like vat,cst ,pan no of company in sales order confirm ssrs report.
how to do this.
*This post is locked for comments
Add the fields in the temp table, insert the value in the RDP class process report method, refresh the report dataset and display the newly added fields in the report design.
To get the tax number, you can use this code
info(strFmt('%1', CompanyInfo::find().CoRegNum));
Try this method for other fields.
Hi Srinivas,
As far as I can see, AX is already displaying the Company Tax Registration Number on the Sales order confirmation report. The field is CompanyInfo.CoRegNum, and can be found at Org Admin -> Setup -> Organisation -> Legal entities -> 'Tax registration' fast tab -> 'Tax registration number'.
I am not familiar with the other numbers you need.
Hii Ravi,
You can find Company related information in company info table.
You can use this method also.
Companyinfo::find().coregnum;
For VAT,cst and pan no you may need to change the company.By changing the company you can find those
fields.
you can create this fields in temptable and retrieve your data in RDP class , finally add this field to design
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Tocauer 4
AlissonGodoy 2
Community Member 2