vat adjustment excel addin

(0) Share

Report

Posted on by Community Member

Hi,

This is a simple query regarding adjusting VAT in the General Journal. Below you have a journal where the VAT is adjusted on one line.

This was done as you know by clicking on VAT and then adjustment

Problem is I can't seem to find an "adjusted vat amount" field in the General Ledger Line Entry Excel-addin. There isn't one in the table to add the field so I am trying to add a new table and field.

I thought Retailtransactions tax line would work but it didn't "publish" the new "adjusted vat amount" into D365. Would you know how I can get the "adjusted VAT amount" field in the excel addin for General Ledger Line Entry as this would allow me to make adjustments to VAT amounts in bulk where required rather than having the system automatically calculate 20% and then manually changing each line in D365.

Hope that makes sense.

Thanks,

Maz

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

André Arnaud de Cal... 301,158 Super User 2025 Season 2 on at

Like (0)

Report

Hi Maz,

This is as far as I have seen not possible with standard data entities. It would require an extension or a new data entity. What makes the VAT change every line? Is the VAT% incorrect?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi andre, this is because sometimes a vendor will send an invoice with a slightly different VAT amount added to the net of their cost e.g. £100 net with £19.99 Vat added rather than £20 (which would then have to be reflected in the General Ledger Line Entry with the account type being supplier and the offset account being the ledger but the automatic vat of 20%/£20 would need to be manually adjusted to £19.99). This all assumes that someone in my company wants to process a manual invoice outside the purchase ledger

As far as extensions go, would it not be possible to find the VAT table that contains that "adjusted vat amount" field and add it to the Excel addin? I'm just not sure how to process bulk vat amount changes without having to manually correct each line within D365.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,158 Super User 2025 Season 2 on at

Like (0)

Report

Hi Maz,

The details for Tax corrections are stored in the table TaxWorkRegulation. It would be possible to include this table. It would require some x++ logic to get the details filled correctly. This is valid for both a virtual field or add the table as datasource on the entity.

Adding some extensions would decrease performance of an existing entity. So, probably, you can better create a new one for this purpose and have the original available for other journal imports which would require some more performance.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi MKHAN123,

Agree with Andre that the standard Excel addin does not have a field available for that.

Irrespective of that, I wonder why your colleagues post vendor invoices via an Excel upload into GL journals?

Is this your normal invoicing process or an exception?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi ludwig, my colleagues want this as an exception for a specific supplier and I agree they should not be processing invoices in this manner. I'll close this thread and speak to the microsoft partner about the customized template that includes the taxworkregulation table.

Thanks

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

thanks for this informaiton

Was this reply helpful? Yes No