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

(0) Share

Report

Posted on by MYGz

2,059

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)

Suggested answer

André Arnaud de Cal... 299,349 Super User 2025 Season 2 on at

Like (1)

Report

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

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
MYGz 2,059 on at

Like (0)

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

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
André Arnaud de Cal... 299,349 Super User 2025 Season 2 on at

Like (0)

Report

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

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,059 on at

Like (0)

Report

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

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
MYGz 2,059 on at

Like (0)

Report

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

Hello Andre,

This is the error I'm getting:

Was this reply helpful? Yes No
Verified answer

MYGz 2,059 on at

Like (0)

Report

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

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