Sales Tax Collected report

Josetxo

Hello,

NAV v4.0 SP1 database, Spanish version.

We are using it for US based company, and we have set up the Sales Tax functionality for the US. It works well, as far as I know.
But now we are facing a problem with the report "Sales Tax Collected": in version 4, it reads records from Table 254 ("VAT Entry"), that holds only records that have a Tax amount.
The thing is that we need to include those tax-exempt records in the report as well. This version of Navision is not recording them in the table (#254) on which this report is based.

I have tried to set the customer to "Tax Liable" and the tax % to 0, as suggested in another thread in this forum, but with no success.

Have you faced this problem before? How could I get those records and include them in the Sales Tax Collected report?

Many thanks in advance.

Josetxo

Hello,

I'll reply myself, just in case somebody can give me a little clue on where does NAV (in which codeunit) write into table 254 when a sales order is posted and the invoice registered.

Is there any tool I can use for that purpose - to see where the table 254 is modified, or a record inserted on it?

Alex_Chow

Yes, this is common and can be addressed setting up the Tax Area Code with 0 taxes.

There's something wrong with your setup.

Josetxo

Thank you for your reply.

I have created a "NOTAX" area with 0 taxes as suggested but the problem still remains.

As I may have set the Sales Tax incorrectly, do you know if there is any difference in the way Navision populates Table 254 (VAT Entry) in the US and in the Spanish versions? So I can focus my effort in setting up the Sales Taxes correctly.

Regards.

Alex_Chow

The sales tax module works the same way. It's a standard feature in the WW version.

There are only a few fields added for the US version for the sales tax tables.

Josetxo

Hello again,

we have found a workaround that seems to be OK; but I'd like to share it with you just to check if it makes sense or it can be dangerous.

We have reviewed the Sales Tax settings and, in the Tax Detail, we have kept the Tax Below Minimum field value to 0.00, but set the Tax Above Maximum field value to 0.01.
This way, now, when the CodeUnit 398 makes this comprobation:

((TaxDetail."Tax Below Maximum" <> 0) OR (TaxDetail."Tax Above Maximum" <> 0))

it makes an insert in the TMPTaxDetail table, that seems to be the source for Table 254. Now a line (or more, depending on the number of jurisdictions) are generated in the VAT Entry table, as desired.

It seems to work well. Do you see any danger on this workaround?

Thanks.

Alex_Chow

Writing your own code to insert into any ledger entry tables is generally a bad idea...

Josetxo

I have made no changes in the code, i have only set up the tax maximum to 0.01 instead of 0.00
Is it correct?

Alex_Chow

Won't that cause a problem with your A/R when your invoices are always off by 0.01?

Josetxo

I think not: "Tax above Maximum" field help says: If you haven't entered an amount in the Maximum Amount/Qty. field (in Tax Detail table) , any value in this field will be ignored by the program.

The field has no value in any record, so it should not affect Sales Tax calculation.