SALES TAX SETTLEMENT

(0) Share

Report

Posted on by Dexin

452

Guys,

I encounter the issue below when i post the sales tax settlement

I was setup the tax authority with the vendor account tag in

However, when i run the sales tax settlement system prompt me the error below.

Anyone can advice

System prompt imbalance sales tax posting

Sales tax authority setup with valid vendor account

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Hi,

Can you check the vendor setup if the vendor has group and posting profile account is enabled?

Was this reply helpful? Yes No
Dexin 452 on at

Like (0)

Report

The vendor account is working fine.

I able to post transaction to the vendor account

Below the the vend_trans records

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Hi,

Your error states, there is no value in reporting currency, can you check your reporting currency setup and rates?

Was this reply helpful? Yes No
Dexin 452 on at

Like (0)

Report

I did not use reporting currency.

I only maintain accounting currency.

I can see my reporting currency field and reporting currency exchange rate was grey off

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (0)

Report

Can you please check Sql if you can where there are decimals that have more than 2 digit value.

Was this reply helpful? Yes No
Dexin 452 on at

Like (1)

Report

I found all the currencies setup with 2 decimal points only.

Was this reply helpful? Yes No
Verified answer

BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (0)

Report

Can you please check from sql for accounting currency amounts from taxtrans table. You may not see from the form.

Was this reply helpful? Yes No
Dexin 452 on at

Like (0)

Report

Oh yes.....thanks for your advice. Appreciate so much.

it was due to taxtrans contained 4 decimals.

How can i set the taxtrans in 2 decimal point?

Is there a standard setup

Was this reply helpful? Yes No
BillurSamdancioglu 19,703 Most Valuable Professional on at

Like (0)

Report

No and this may be a huge problem. This is probably because of a development. Can you please check generaljournalaccountentry table for the same field?

Was this reply helpful? Yes No