VAT Statement Line - Column amount calculation

Business Central/NAV
1

Hello to everyone,
I used Business Central, and added two new fields on VAT Entry table: TOTAL = Base + Amount, TOTAL UNREALIZED = Unrealized Amount + Unrealized Base,
and on VAT Statement table field “Amount Type” (Enum) I aded two new values (Total, Total Unrealized), like on picture:

image
image1407×615 38.7 KB

Now, I wanted to calculate VAT Statement for records where I selected Total or Total Unrealized, and store calculation result into “Column Amount” filed on VAT Statement Line, but if I click on Preview action I don’t get any value.
image
image844×581 22.5 KB

Do you know how to calculate new values and store into that field on VAT Statement Line?
P.S.: I see that event “OnBeforeOpenPageVATEntryTotaling” from “VAT Statement Preview Line” page do calculation, but I don’t know the way how to input new values.

2

You should not have ‘unrealised’ values in your VAT statement report.
‘Unrealised’ means the values are NOT to be in VAT statement until they are realised.
When you select ‘Unrealised’ in VAT set-up, you are indicating to the system that you want to report VAT based on cash VAT accounting.

3

Haris,

Why did you add those fields? VAT Statements calculate perfectly and without issue. I have created them for several UK customers of mine and never needed such a change. Are all the VAT Posting Groups and Setup correct and Customer, Vendor, Items, and Chart of Accounts properly setup? I can send you over pics of my setup but I would remove this.

Thanks,
Steve