Vendor balance shows wrong in USD currnecy after payment

Business Central/NAV User Forum
1

Hi ,

Date : 02/02/02 , Currncy code = USd ( exchange rate = 1 $ = 55.05 LCy)

Generl ledger setup - applyn. Rounding precision = 0.00

Example :

I created a Purchinvoice with currecy code USD .

InV amount = 1 $ (Invoice amoutn In LCY = 55.05)

when i check that vendor balance card amount shows = 55.05

03/02/02 Vendor paid that amount 1 $ ( one that date LCY = 55.00)

after i pass the Payment journal vendor balance shows = 0.00

actaully it has to show the balance = .05

what is the wrong .

please clarify my doubt

2

Hi ameen,

please contact a senior in your company and ask for some lessons in accounting. There is nothing wrong with Navision, simply that you don’t understand accounting.

3

The balance is in USD and you had a balance of $1 and paid $1 that must give $0.The difference is posted to the Vendor account but to your gl.

If you want the picture you describe above, then you should register the invoice in LCY 55.05 and manually recalculate the $1 to 55.00 upon payment.

4

Navigate the posted G/L entries for the payment document and you can find out where 0.05 LCY has gone and follow the advise of David.

5

Thanks Sanddep ,

but what i would like to know how it is rounding ?

what aboutt that steups ?

please let me knowthat one.

6

It has nothing to do with rounding. When you’re working with two different exchange rates, then you either win or loose money.

But follow David’s advise! Learn some basic practical accounting.