AL Extension to set manual tax amount on Purchase Invoice

(1) Share

Report

Posted on by CU29062212-0

Hi,

I'm importing, via web services, a bunch of historical PurchaseInvoice data into BC from another accounting system. The data has, for whatever reason, many PurchaseInvoice lines where the tax amount is basically manually entered. So that means the imported data can not be setup to use the built-in tax setups in BC.

There is a process in BC to manually override the tax in the user interface:

https://www.youtube.com/watch?app=desktop&v=zBXttdf0byg

I'm looking to be able to do this using an AL extension and webservice.

The video shows that ultimately the user is modifying the PurchaseLine.Tax% field. I have verified this by inspecting the page and viewing the PurchaseLine table and seeing the resulting value in the "Tax %" column.

The issue is that the "PurchaseLine.Tax %" field can not be added to the UI (it doesn't show up in the "Purchase Invoice > Lines > then "Help" > Inspect Page > Table Fields listing).

I also tried "Settings > Personalize > Lines > Add Field" but the "Tax%" field does not show up there either.

Similarly, in AL Extension code, creating a new extended card for PurchaseLine2 to show the field for "Tax%" results in a compile error:

Curious thing is that the webservices for PurchaseLines like:

https://api.businesscentral.dynamics.com/v2.0/xxxxxxxx/xxxxxxxxxx/ODataV4/Company('xxxxxxxxxxxx')/BLXPurchaseInvoiceLinesV2(xxxxxxxxxxx)

Shows the "taxPercent" field in the JSON results.

However if you try to post to that endpoint then you get an error:

"'POST' requests for 'BLXPurchaseInvoiceLinesV2' of EdmType 'Entity' are not allowed within Dynamics 365 Business Central OData web services."

So, I'm kinda stuck. The field "Tax %" definitely exists on Purchase Line table. But how can I access it and modify it? Ideally through an AL extension.

Thank you for your help with this.

Thanks!

Alex.

All responses (7)

Answers (0)

Suggested answer

YUN ZHU 63,463 Super User on at

Like (0)

Report

AL Extension to set manual tax amount on Purchase Invoice

This is quite complicated. I have experienced similar development before, and the processing of W1 is different from that of US. You can refer to the standard code. The main points are the following three points. If I have time I might discuss this on my blog later.

TempVATAmountLine: Record "VAT Amount Line" temporary;

SalesTaxCalculate: Codeunit "Sales Tax Calculate";
TempSalesTaxAmtLine: Record "Sales Tax Amount Line" temporary;

Thanks

ZHU
CU29062212-0 8 on at

Like (1)

Report

AL Extension to set manual tax amount on Purchase Invoice

Hi YUN ZHU,

Your hint of looking for "VAT %" helped with this. I had been looking for "Tax %", but that is, I guess, the localized field name. Instead I needed to be looking for "VAT %".

Do you know how to write a simple codeunit that accesses the SalesTaxLines to be able to modify the field "Tax Amount":

Thank you.
Suggested answer

YUN ZHU 63,463 Super User on at

Like (0)

Report

AL Extension to set manual tax amount on Purchase Invoice

Can you find this field in the Source Table? For example, in the W1 version, this field is not editable.

Thanks.

ZHU
Suggested answer

gdrenteria 4,607 Super User on at

Like (1)

Report

AL Extension to set manual tax amount on Purchase Invoice

Hi

What message do you get when you position above the field in VSC?
Does that field belong to any extension? Isn't it an "internal" one?

Access Property - Business Central | Microsoft Learn

BR

GR
CU29062212-0 8 on at

Like (0)

Report

AL Extension to set manual tax amount on Purchase Invoice

Hi,

I appreciate the responses, but they don't answer the question. Here is the PageType=API extension:

You can see the "Tax %" field shows as an error in Visual Studio Code. This means the field is not accessible for some reason. Even though the field does exist on the table (see highlighted field in the BC "View Table" screen:

How do I get this field to be accessible as a VSCode extension, or some other way?

Thanks

Alex.
Suggested answer

YUN ZHU 63,463 Super User on at

Like (1)

Report

AL Extension to set manual tax amount on Purchase Invoice

Use Page Extension to add it to the page. If you have the new version, you can try the following method.

Business Central 2023 wave 2 (BC23): Add existing table fields to optimize your pages (Adding Table Fields to Page without Page Extensions)

https://yzhums.com/43183/

In addition, it is usually more convenient to import this data using Configuration Package rather than Web Service.

Microsoft Dynamics 365 Business Central: How to Export and Import Data (Using Configuration Packages)

https://yzhums.com/4286/

Hope this helps.

Thanks.

ZHU
Suggested answer

gdrenteria 4,607 Super User on at

Like (0)

Report

AL Extension to set manual tax amount on Purchase Invoice

Hi

I hope this can help you.

‘PATCH’ requests for ‘ServiceName’ of EdmType ‘Collection’ are not allowed within Dynamics 365 Business Central OData web services | Dynamics 365 Lab (yzhums.com)

Troubleshooting REST API/OData calls - Business Central | Microsoft Learn

BR

GR