0037155: Wrong transaction's accounting entry when working with multicurrency doubtful debt

Openbravo Issue Tracking System - Openbravo ERP
View Issue Details

ID	Project	Category	View Status	Date Submitted	Last Update
0037155	Openbravo ERP	Z. Others	public	2017-10-24 12:29	2018-01-03 12:38

Reporter	maite
Assigned To	AtulOpenbravo
Priority	urgent	Severity	major	Reproducibility	always
Status	closed	Resolution	fixed
Platform		OS	5	OS Version
Product Version
Target Version		Fixed in Version	3.0PR18Q1
Merge Request Status
Review Assigned To	dmiguelez
OBNetwork customer	OBPS
Web browser
Modules	Advanced Payables and Receivables Mngmt
Support ticket	49077
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency Pack	No

Summary	0037155: Wrong transaction's accounting entry when working with multicurrency doubtful debt
Description	Not properly conversion is being done so account "Currency balancing" is used
Steps To Reproduce	0. Enable Doubtful Debt functionality by creating Preference with Attribute 'Doubtful_Debt_Visibility' and Value 'Y' 1. Access Business Partner Category window and define Accounting for "Customer - Tier 2" and accounts: Doubtful Debt Account Bad Debt Expense Account Bad Debt Revenue Account and Allowance for Bad Debts Account. 2. Define new "Conversion Rate" between MXN and USD with Multiplied by=2 3. Create Price List for * organization, MXN currency and Sales Price list=Y. Add any pricelist version. Add product price "Lager Beer" with price 20 4. Register Sales Invoice for "F&B US, Inc." organization, "Moon Light Restaurants, Co." business partner and "Mexican pricelist". 5. Add line for defined product, qty=1. Process invoice and post it. Realize that "1130 - Accounts Receivable" is affected with balance 40 6. Create "Doubtful Debt Run" record for "F&B US, Inc." organization, "Moon Light Restaurants, Co." business partner. Run "Select Doubtful Debt" and select previous invoice. Process 7. Access "Doubtful Debt" window and post record. Realize that balance is properly converted to 40 8. Access Financial Account "Bank - Account 1 - USD" and configure "Wire Transfer" payment method as "Receive Payment in Multiple currencies" 9. Register Payment in for "F&B US, Inc." organization, "Moon Light Restaurants, Co." business partner, Payment Date= invoice's date +1 day, "Wire Transfer" payment method, "Amount=20", "MXN" currency, "Exchange Rate=2.5". Run "Add details" process and select previous invoice. Process payment and register financial account transaction in same step 10. Navigate to Financial Account and Post transaction document. Realize that "Currency balancing" account is used because balance has not been converted (it is 20 when it should be 40, so if you current check balance of doubtful debt accounts you can see that it is not 0)
Proposed Solution
Additional Information
Tags	No tags attached.
Relationships
Attached Files

Issue History
Date Modified	Username	Field	Change
2017-10-24 12:29	maite	New Issue
2017-10-24 12:29	maite	Assigned To	=> Triage Finance
2017-10-24 12:29	maite	OBNetwork customer	=> Yes
2017-10-24 12:29	maite	Modules	=> Advanced Payables and Receivables Mngmt
2017-10-24 12:29	maite	Support ticket	=> 49077
2017-10-24 12:29	maite	Resolution time	=> 1510614000
2017-10-24 12:29	maite	Triggers an Emergency Pack	=> No
2017-10-24 12:31	maite	Issue Monitored: networkb
2017-10-25 08:28	dmiguelez	Assigned To	Triage Finance => AtulOpenbravo
2017-10-26 21:04	AtulOpenbravo	Status	new => scheduled
2017-10-27 10:34	AtulOpenbravo	Note Added: 0100097
2017-10-27 10:45	AtulOpenbravo	Note Added: 0100098
2017-11-03 11:44	dmiguelez	Note Added: 0100245
2017-11-06 09:07	hgbot	Checkin
2017-11-06 09:07	hgbot	Note Added: 0100274
2017-11-06 09:07	hgbot	Status	scheduled => resolved
2017-11-06 09:07	hgbot	Resolution	open => fixed
2017-11-06 09:07	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/c4adf2ef35194d79f4c18d905ad4d37c07c6afcd [^]
2017-11-06 09:07	hgbot	Checkin
2017-11-06 09:07	hgbot	Note Added: 0100275
2017-11-06 09:08	dmiguelez	Review Assigned To	=> dmiguelez
2017-11-06 09:08	dmiguelez	Note Added: 0100276
2017-11-06 09:08	dmiguelez	Status	resolved => closed
2017-11-06 16:05	dmiguelez	Fixed in Version	=> 3.0PR18Q1
2018-01-03 12:38	hudsonbot	Checkin
2018-01-03 12:38	hudsonbot	Note Added: 0101372
2018-01-03 12:38	hudsonbot	Checkin
2018-01-03 12:38	hudsonbot	Note Added: 0101373

Notes

Test Plan

- Enable Doubtful Debt functionality by creating Preference with Attribute 'Doubtful_Debt_Visibility' and Value 'Y'
- Access Business Partner Category window and define Accounting for "Customer - Tier 2" and accounts:
   - Doubtful Debt Account
   - Bad Debt Expense Account
   - Bad Debt Revenue Account
   - Allowance for Bad Debts Account.

- Define new "Conversion Rate" between MXN and USD with Multiplied by=2
- Create Price List for * organization, MXN currency and Sales Price list=Y. -
- Add any pricelist version. Add product price "Lager Beer" with price 20
- Register Sales Invoice for "F&B US, Inc." organization, "Moon Light Restaurants, Co." business partner and "Mexican pricelist".
- Add line for defined product, qty=1. Process invoice and post it. Realize that "1130 - Accounts Receivable" is affected with balance 40
- Create "Doubtful Debt Run" record for "F&B US, Inc." organization, "Moon Light Restaurants, Co." business partner. Run "Select Doubtful Debt" and select previous invoice. Process
- Access "Doubtful Debt" window and post record. Realize that balance is properly converted to 40
- Access Financial Account "Bank - Account 1 - USD" and configure "Wire Transfer" payment method,
  set "Receive Payment in Multiple currencies" = Yes,
  set Upon Receipt use = Blank
  set Upon Deposit use = Blank
  set Upon Reconciliation use = Deposited Payment Account.
  set Upon Payment use = Blank
  set Upon Withdrawal use = Blank
  set Upon Reconciliation use = Withdrawn Payment Account.
- Register Payment in for "F&B US, Inc." organization, "Moon Light Restaurants, Co." business parter, Payment Date= invoice's date +1 day, "Wire Transfer" payment method, "Amount=20", "MXN" currency, "Exchange Rate=2.5". Run "Add details" process and select previous invoice. Process payment and register financial account transaction in same step
- Navigate to Financial Account, Bank Statement tab create a header with name Test 37155.
- Create line for Moon Light Restaurants, Co. business partner and amount in = 40. Process bank statement.
- In Financial Account, click Match Statement button, realize that previous bank statement line and payment is matched automatically.
- Click on Reconcile All and navigate to reconciliation tab, select record created in previous step.
- Post reconciliation.
- Realize that Doubt Debt Account is posted with credit amount 40, Allowance for Bad Debt Acct Debited with amount 40, Bad Debt Revenue Acct is credited with amount 40. All these amounts are properly converted.

Test Plan

- Enable Doubtful Debt functionality by creating Preference with Attribute 'Doubtful_Debt_Visibility' and Value 'Y'
- Access Business Partner Category window and define Accounting for "Customer - Tier 2" and accounts:
   - Doubtful Debt Account
   - Bad Debt Expense Account
   - Bad Debt Revenue Account
   - Allowance for Bad Debts Account.

- Define new "Conversion Rate" between MXN and USD with Multiplied by=2
- Create Price List for * organization, MXN currency and Sales Price list=Y. -
- Add any pricelist version. Add product price "Lager Beer" with price 20
- Register Sales Invoice for "F&B US, Inc." organization, "Moon Light Restaurants, Co." business partner and "Mexican pricelist".
- Add line for defined product, qty=1. Process invoice and post it. Realize that "1130 - Accounts Receivable" is affected with balance 40
- Create "Doubtful Debt Run" record for "F&B US, Inc." organization, "Moon Light Restaurants, Co." business partner. Run "Select Doubtful Debt" and select previous invoice. Process
- Access "Doubtful Debt" window and post record. Realize that balance is properly converted to 40
- Access Financial Account "Bank - Account 1 - USD" and configure "Wire Transfer" payment method,
  set "Receive Payment in Multiple currencies" = Yes,
  set Upon Receipt use = Cleared Payment Account
  set Upon Deposit use = Blank
  set Upon Reconciliation use = Blank
  set Upon Payment use = Cleared Payment Account
  set Upon Withdrawal use = Blank
  set Upon Reconciliation use = Withdrawn Payment Account.
- Register Payment in for "F&B US, Inc." organization, "Moon Light Restaurants, Co." business parter, Payment Date= invoice's date +1 day, "Wire Transfer" payment method, "Amount=20", "MXN" currency, "Exchange Rate=2.5". Run "Add details" process and select previous invoice. Process payment and register financial account transaction in same step
- Post payment.
- Realize that Doubt Debt Account is posted with credit amount 40, Allowance for Bad Debt Acct Debited with amount 40, Bad Debt Revenue Acct is credited with amount 40. All these amounts are properly converted.