Finance | Project Operations, Human Resources, ...

Tax rate field in Sales Invoice report

(0) Share

Report

Posted on by D365FO DEV

406

Hello everyone, i am trying to add the tax rate to my sales invoice report. so i need to map the value to show on my report.

so here i will show u my extension in the data provider class, i have created a field Ex_TaxRate to map the field TaxValue from the taxTrans table. but for some reasons, the field is coming blank on the report

I have the same question (0)

All responses (18)

Answers (0)

Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Hi Mounir, Please try the code in this thread

community.dynamics.com/.../d365-get-sales-tax-values-of-sales-order-per-line-in-x

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report

hi

can u show me how to add it based on the field i created and when to add it?

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Please share the path for this Posted Sales Tax form. I can see other dialogs for tax on sales order.

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report

to get the path for this sales tax for, u need to select a sales order -> invoice(action pane)

->posted sales tax --> options --> record info --> show all fields.

Was this reply helpful? Yes No
Abhi 120 on at

Like (0)

Report

Hi MounirDev,

Debug it. check to see if the table is select.

Thanks,

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report

i debugged, only the salesinvoicetmp is showing data while taxtrans and custinvoicetrans is not showing data

Was this reply helpful? Yes No
Abhi 120 on at

Like (0)

Report

Hi MounirDev,

Check in SSMS having record in custinvoicetrans for "Select custinvoiceTrans where custinvoicetrans.recid == journalRecid (salesinvoicetmp.journalrecid)".

Thanks,

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report

custinvoice trans is not getting data

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Please check this thread

community.dynamics.com/.../741651

In SalesInvoiceTmp, JournalRecId field is linked with custinvoicejour table, not custInvoiceTrans.

There is a standard field for TaxAmount in SalesInvoiceTmp, if you comment your code, isn't the standard logic working?

Was this reply helpful? Yes No
Abhi 120 on at

Like (0)

Report

Hi MounirDev,

In above figure, custinvoiceJour is in relation with salesinvoicetmp, not with custinvoicetrans table.

Thanks,

Was this reply helpful? Yes No