Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Serious Payments.php reciprocal issue
12-11-2012, 07:23 PM, (This post was last modified: 12-11-2012, 08:16 PM by ronwong.)
#7
RE: Serious Payments.php reciprocal issue
I am using latest version. Is your base currency USD? is there any one not using USD as base currency?
Can I post out one example which I post

see below: My base is SGD, and I enter an invoice in MYR, 1SGD = 2.5MYR so I usually key in 2.5xxx where need to:

This is a supplier expense of MYR95.64, and it converts to SGD39.25 so exchange rate is 2.4366879

To keep it simple I will use this rate for invoice entry as well as payment so there should be NO exchange diff.

[Image: imagehfc.jpg]

The first 2 lines were posted by ERP, showing 233.04 in accounts payable, which can be derived as MYR95.64 X 2.4366879, (WHY??), MYR95.64 / 2.4366879 = SGD39.25 which is what we need. The cash on hand side is correct! so it does NOT balance already.

The other 4 lines, 2 lines came in when I allocate the payment, and the other 2 is when I see the ex diff, I reverse the payment.

[Image: imagelzdq.jpg]

This allocation page shows it used 0.41039xxx (WHY?) didn't we put it as 2.4366879??

[Image: imagesbk.jpg]

The Purchase invoice is perfect, as above, its just the payment and allocation that is giving all the problems...
In another Invoice and payment where my supplier invoice is USD, my ERP base currency is SGD, but I have another USD account, and I use that account to pay that invoice:

The USD value us 467 and converted to SGD is 570.48. The first 2 entries came in with the payment, ok, fine, GL displayed in base currency, when I allocate the payment, the other 2 lines comes in, are these looking fine? they don't look like they are displaying correctly to me even though they seems to be balanced.


Accounts Payable - 570.48 EXPRESSOA-Paypal No
Special Accounts 570.48 EXPRESSOA-Paypal No
Purchases Exchange Gains/Losses 0.00 Exch diff No
Accounts Payable - -570.48 Exch Diff No
Total 570.48 570.48
Reply


Messages In This Thread
RE: Serious Payments.php reciprocal issue - by ronwong - 12-11-2012, 07:23 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)