Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0016220Openbravo ERP09. Financial managementpublic2011-03-10 18:352011-04-09 00:00
psarobe 
eduardo_Argal 
urgentmajoralways
closedfixed 
5
pi 
3.0RC6 
Core
No
0016220: Accounting seems not to work properly under the following scenario: Vendor credit payment
Some journal entries only have one line in the US COA but with the Spanish COA uses the account "Cuenta de cuadre"

See steps:
Using F&B US, Inc

First of all you enter a Payment Out with the amount that the vendor already told you that you have to pay. Go to Payment Out screen and create a new record:
Organization = F&B US, Inc.,
Paying To = Happy Drinks, Inc.,
Payment Method = Wire Transfer,
Paying From = USD - US Bank - Account 1
Amount = 0.00,
Generated Credit = 546.77,
Save
Click Add Payment Details. Do not select any orders or invoices, but select the option Leave this amount to be used later.
lick Process and OK and the message process completed successfully should appear. This means that there is an outstanding amount of 546.77USD with Vendor Happy Drinks, Inc.
Let's assume that timed passed by and in the meantime you received purchase invoices from the vendor. You enter them into the application using the Purchase Invoice screen and creating a new record:
[Header]
Organization = F&B US, Inc.
Transaction Document = US AP Invoice
Business Partner = Happy Drinks, Inc.
Payment Method = Wire Transfer
Payment Terms = 30 days
[Lines]
Product = Rosé Wine
Invoiced Quantity = 100
back in [Header]
Verify that the Total Gross Amount is 401.25 USD.
Complete the invoice.
There were no discounts applied, so the Total Gross Amount should still be 401.25 USD.
Go to the Purchase Invoice screen and create a new record:
[Header]
Organization
= F&B US, Inc.
Transaction Document = US AP Invoice
Business Partner = Happy Drinks, Inc.
Payment Method = Wire Transfer
Payment Terms = 30 days
[Lines]
Product = Ale Beer
Invoiced Quantity' = 100
back in [Header]
Verify that the Total Gross Amount is 145.52 USD.
Complete the invoice.
There were no discounts applied, so the Total Gross Amount is still 145.52 USD.
The total of these purchase invoices is 401.25 + 145.52 = 546.77 USD, exactly the amount that you had already paid.
Now execute the payment of the 2 purchase invoices by go to Payment Out and create a new record:
Organization = F&B US, Inc.
Paying To = Happy Drinks, Inc.
Payment Method = Wire Transfer
Paying From = USD - US Bank - Account 1
Save record
Click Add Payment Details:
Available credit of 546.77 USD appears on the pop up screen
Select the checkbox Use Available Credit and select the two purchase invoices
The 'Total' is exactly 546.77.
Click 'Process' and 'OK'
The Status of the Payment Out has been changed to Payment Made

Note:In order to post the transaction in the financial account you have to change the configuration for "wire transfer" in the US Bank account 1

See the screenshot of the journal entries for UScoa and SPAINcoa
No tags attached.
png UScoa.PNG (31,374) 2011-03-10 18:35
https://issues.openbravo.com/file_download.php?file_id=3649&type=bug
png

png SPAINcoa.PNG (35,153) 2011-03-10 18:36
https://issues.openbravo.com/file_download.php?file_id=3650&type=bug
png
Issue History
2011-03-10 18:35psarobeNew Issue
2011-03-10 18:35psarobeAssigned To => eduardo_Argal
2011-03-10 18:35psarobeModules => Core
2011-03-10 18:35psarobeFile Added: UScoa.PNG
2011-03-10 18:36psarobeFile Added: SPAINcoa.PNG
2011-03-10 18:36psarobeStatusnew => scheduled
2011-03-10 18:36psarobefix_in_branch => pi
2011-03-11 11:11hgbotCheckin
2011-03-11 11:11hgbotNote Added: 0034750
2011-03-11 11:11hgbotStatusscheduled => resolved
2011-03-11 11:11hgbotResolutionopen => fixed
2011-03-11 11:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5b814ef509db54a43289415246bfcaf9ae4e18fb [^]
2011-04-08 11:58miruritaNote Added: 0035759
2011-04-08 11:58miruritaStatusresolved => closed
2011-04-09 00:00anonymoussf_bug_id0 => 3281267

Notes
(0034750)
hgbot   
2011-03-11 11:11   
Repository: erp/devel/pi
Changeset: 5b814ef509db54a43289415246bfcaf9ae4e18fb
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Fri Mar 11 11:12:55 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/5b814ef509db54a43289415246bfcaf9ae4e18fb [^]

Fixes bug 0016220, fixes bug 0016221

---
M src/org/openbravo/erpCommon/ad_forms/AcctServer.java
M src/org/openbravo/erpCommon/ad_forms/Fact.java
---
(0035759)
mirurita   
2011-04-08 11:58   
Verified.
Balanced posting.