Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Serious Payments.php reciprocal issue
12-10-2012, 02:46 PM
Post: #1
Serious Payments.php reciprocal issue
I am repeating this from nabbles, but I think this is a serious flaw that needs to be fixed for anyone that has foreign currency suppliers.

for a simple transaction, my base currency is SGD, so rate is 1SGD to 0.623926

the account payable in USD is 1579.78 and the chequing account DR 2532, the 2 extra lines below of exchange difference is due to it reciprocating the wrong way, causing a big difference.

03/09/2012 September 2012 Accounts Payable - 1,579.78 03/09/2012 September 2012 Cheque Accounts 2,532.00
03/09/2012 September 2012 Purchases Exchange Gains/Losses 911.60 Exch diff
03/09/2012 September 2012 Accounts Payable - 1,579.78 Exch Diff
Total 3,443.60 3,443.60


Earlier, exsonQu, you sent a "patch" file, but it will show something if posting the same entries like:

03/09/2012 September 2012 Accounts Payable - 1,579.78 03/09/2012 September 2012 Cheque Accounts 5,064.00
Total 1,579.78 1,579.78

so it seems correct, but there are still some strange numbers.

it is only the payment.php, posting the forex invoices are fine, just paying them will screw it up.
Find all posts by this user
Quote this message in a reply
12-10-2012, 05:44 PM
Post: #2
RE: Serious Payments.php reciprocal issue
Sorry I don't really follow Ron - perhaps the formatting is lost somehow. Could you explain to me how to repeat the issue you are seeing?

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
12-11-2012, 10:18 AM
Post: #3
RE: Serious Payments.php reciprocal issue
In the above example, my erp is set is sgd, i have a supplier who is set in usd. When i enter a supplier invoice is is shown in usd, and there is a rate locked in back to base currency. All these are ok. So the above my usd suppliier invoice values usd1579.78

The problem comes when i make payment with payment.php to this supplier from my sgd account. By right, if i choose the same ex rate, for example above 0.623926 for invoice and payment, there is no ex diff gain or loss and the payment leg should go in as usd1579.98 and my cash account should dr sgd2532, but it somehow consistently will post a ricipocal and fill up the rest as a exchange difference.
Find all posts by this user
Quote this message in a reply
12-11-2012, 11:21 AM
Post: #4
RE: Serious Payments.php reciprocal issue
It is a key assumption (and in the manual) that currency values must be expressed as the number of the foreign currency to purchase one of the local currency. So my understanding of the SGD - is that it is worth around 0.8184 USD - this is the rate you should have for USD in your system. If you have a rate of 1.2218 USD = 1 SGD then this will be the cause of the problem.

As you say a very serious flaw indeed. I will go and test.

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
12-11-2012, 05:02 PM
Post: #5
RE: Serious Payments.php reciprocal issue
i know... my rates at all places are 1SGD = 0.8xxxx USD, so all the numbers are 0.8xxxx
I have double checked that previously as you highlighted it in October when I first brought out the issue. Now, I entered all the foreign currency supplier invoices all ok but holding back all the payments, because each payment I enter screw up the GL big time.
Find all posts by this user
Quote this message in a reply
12-11-2012, 06:03 PM
Post: #6
RE: Serious Payments.php reciprocal issue
We use multicurrency daily with suppliers and did not find this issue, funny.

Which webERP version are you using?

Regards,
Pak Ricard
Find all posts by this user
Quote this message in a reply
12-11-2012, 07:23 PM (This post was last modified: 12-11-2012 08:16 PM by ronwong.)
Post: #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
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)