Separation of Tax codes and Tax Values

(0) Share

Report

Posted on by Community Member

Hi All,

I Have a Developed a New SSRS Report in Account Receivable Module For a Particular Sales Invoice I Need To Print The Tax Codes With Values.

Please Help me

Thanks

Rajesh

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

RE: Separation of Tax codes and Tax Values

Hi Rajesh,

I didn't understand your question clearly,

your created report using by Query or Dp class?

tax values and codes will fetch from TaxTrans Table.

Thanks,

Was this reply helpful? Yes No
André Arnaud de Cal... 299,349 Super User 2025 Season 2 on at

Like (0)

Report

RE: Separation of Tax codes and Tax Values

Hi Raj,

The default invoice report is looking at form settings. Go to Accounts receivable > Setup > Forms > Form setup. The field who manages this is called 'Sales tax specification'.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Separation of Tax codes and Tax Values

Hi Andre,

I want to print the tax values based on tax codes for a particular sales invoice.

kind regards,

Rajesh

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Separation of Tax codes and Tax Values

Hi Raj,

For a single SalesId may have mutliple Invoices In (CustInvoiceJour).InvoiceId.

here is the sample code for to get the tax code and tax values.

while select taxTrans
where taxTrans.Voucher == custInvoiceJour.LedgerVoucher
&& taxTrans.InventTransId == custInvoiceTrans.InventTransId

Please try this code to get Tax related Information.

This is just a suggestion.

Thanks,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Separation of Tax codes and Tax Values

Hi Suresh,

can you please share the sample code for to split the tax code and tax values.

i want to show each and every tax code in a separate columns in the SSRS Report.

kind regards,

Rajesh

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: Separation of Tax codes and Tax Values

Hi Raj,

Please try this code for your report, it may work for you.

salesReqTmp.VATTaxCode = "";
salesReqTmp.VATAmount = 0;
salesReqTmp.CSTTaxcode = "";
salesReqTmp.CSTTaxAmount = 0;

while select taxTrans
where taxTrans.Voucher == custInvoiceJour.LedgerVoucher
&& taxTrans.InventTransId == custInvoiceTrans.InventTransId
{

if(taxTrans.TaxCode like "VAT*")
{
salesReqTmp.VATTaxCode = taxTrans.TaxCode;
salesReqTmp.VATAmount = this.amountCur(taxTrans);
}
if(taxTrans.TaxCode like "CST*")
{
salesReqTmp.CSTTaxcode = taxTrans.TaxCode;
salesReqTmp.CSTTaxAmount = this.amountCur(Taxtrans);
}
}

This is just a sugestion,

Thanks,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Separation of Tax codes and Tax Values

Hi Suresh,

tax values are splitting separately for particular invoice ID i am able to generate with tax codes and tax values.

thanks for your help.

kind regards,

Rajesh

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Separation of Tax codes and Tax Values

Hi Andre,

thanks for suggesting me.

kind regards,

Rajesh

Was this reply helpful? Yes No

Community site session details

Separation of Tax codes and Tax Values

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Separation of Tax codes and Tax Values

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates