Print Sales Tax Code and Sales Tax Amount in the Lines in Free Text Invoice

(0) Share

Report

Posted on by MYGz

2,295

Hello,

I want to print Sales Tax Code and Sales Tax Amount in the Free Text Invoice Report Lines.

Is it possible out of the Box? Or will have to extend the DP class? Is there any blog on how to achieve it writing the extension?

Appreciate any tips.

Best Regards,

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

MYGz 2,295 on at

Like (0)

Report
Copy link

Link copied!

This is resolved,

The error was with model referencing. 1 model was missing in the reference. Fixing which, the tax started calculating.

More details here:

community.dynamics.com/.../the-name-taxdirection-does-not-denote-a-class-a-table-or-an-extended-data-type

Was this reply helpful? Yes No
MYGz 2,295 on at

Like (0)

Report
Copy link

Link copied!

Hello Andre,

This is the error I'm getting:

Was this reply helpful? Yes No
MYGz 2,295 on at

Like (0)

Report
Copy link

Link copied!

I'll post the error later as I'm trying something different.

In the FreeTextInvoiceDP there's a boolean called isTaxAmountVisible and same is there in the Dataset. Where can I set it to Yes? I don't see it's being used in the FreeTextInvoiceDP anywhere. I have selected the field in the report to check.

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

Like (0)

Report
Copy link

Link copied!

Hi MYGz,

What exactly do you mean with "getting Tax Direction error"? Can you elaborate on that? Did you try to add some extension logic to the DP?

Was this reply helpful? Yes No
MYGz 2,295 on at

Like (0)

Report
Copy link

Link copied!
Hello Andre,

Thanks for the reply.

I made these changes,

1. GL > GL Parameters > Sales Tax > Calculation Method > Line

2. Tax > Sales Tax Code > Print Code > VAT15% (Print Code)

3. AR > Setup > Forms Setup > General > Sales Tax Specification > "Registration and Company Currency"

After these changes the Sales Tax Code is coming on the Line. But Sales Tax Amount is still not coming. I tried all the Tax column in the FreeTextInvoiceDS ie TaxAmount, TaxBaseAmount etc. But the value is not coming.

I'm getting Tax Direction error while try to manually populate the FreeTextInvoiceTmp,

_tax = Tax::calcTaxAmount(_custInvoiceTrans.TaxGroup,_custInvoiceTrans.TaxItemGroup,_custInvoiceJour.InvoiceDate,_custInvoiceTrans.CurrencyCode,_custInvoiceTrans.lineAmountInclTax(),TaxModuleType::FreeTxtInvoice);

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 302,035 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi MYGz,

There is documentation available from Microsoft: Customize through extension and overlayering - Finance & Operations | Dynamics 365 | Microsoft Docs

At least the DP contains logic for a Tax summary per Sales tax code and a sales tax code per line. Not sure if the tax amounts are part of the standard DP, but using the documentation, you should be able to extend it.

Was this reply helpful? Yes No