Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0033341Openbravo ERP09. Financial managementpublic2016-06-23 14:272016-06-30 13:02
psanjuan 
vmromanos 
urgentmajoralways
closedfixed 
20Professional Appliance
 
3.0PR16Q3 
aferraz
Core
No
0033341: Invoice prepayment accounting needs to support Cash VAT in the case of managing more than one General Ledger configuration
Invoice prepayment accounting needs to support Cash VAT in the case of managing more than one General Ledger configuration
Create a purchase invoice for Bebidas Alegres.
Make sure that purchase invoice is set as Cash VAT = Yes.

Set as purchase invoice date for instance 23-06-2016.
Add any product, make sure a Cash VAT tax is used.

Complete and Post the invoice.

Posting would look like:
136.00 (60000) Compras mercaderias - DEBIT
28.56 (47200T) HP IVA soportado transitorio - DEBIT
164.25 (40000) Proveedores - CREDIT

Go to Add payment and add a payment of the invoice dated on a prior date, for instance 01/05/2016.

Post the payment. Posting would look like:

01-05-2016 (payment date)

164.56 (40700) Anticipos a proveedores - DEBIT
164.56 (57200) Bancos - CREDIT

23-06-2016

164.56 (40009) Proveedores - DEBIT
164.56 (40700) Anticipos a proveedores - CREDIT
   
Correct posting should have been:


01-05-2016 (payment date)

164.56 (40700) Anticipos a proveedores - DEBIT
164.56 (57200) Bancos - CREDIT
28.56 (47200) HP IVA soportado - DEBIT
28.56 (47200T) HP IVA soportado transitorio - CREDIT

23-06-2016

164.56 (40000) Proveedores - DEBIT
164.56 (40700) Anticipos a proveedores - CREDIT


We need to take into account also partial invoice prepayments. Please check this posting seems to be already happening for F&B International Group. See image attached.
No tags attached.
duplicate of defect 00291363.0PR15Q3 closed AtulOpenbravo Wrong entry when posting prepayment against invoice using credit 
related to defect 0033354 closed vmromanos No correct Cash VAT posting for the payment in case of more than one General Ledger assigned to the Organization. 
png issue33341_Euro.png (44,944) 2016-06-23 15:19
https://issues.openbravo.com/file_download.php?file_id=9571&type=bug
png

png issue33341_Dollar.png (37,238) 2016-06-23 15:19
https://issues.openbravo.com/file_download.php?file_id=9572&type=bug
png
Issue History
2016-06-23 14:27psanjuanNew Issue
2016-06-23 14:27psanjuanAssigned To => Triage Finance
2016-06-23 14:27psanjuanModules => Core
2016-06-23 14:27psanjuanTriggers an Emergency Pack => No
2016-06-23 14:31psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=12466#r12466
2016-06-23 15:11psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=12467#r12467
2016-06-23 15:16psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=12468#r12468
2016-06-23 15:16psanjuanProposed Solution updated
2016-06-23 15:17psanjuanProposed Solution updated
2016-06-23 15:19psanjuanFile Added: issue33341_Euro.png
2016-06-23 15:19psanjuanFile Added: issue33341_Dollar.png
2016-06-23 15:31psanjuanSummaryInvoice prepayment accounting needs to support Cash VAT => Invoice prepayment accounting needs to support Cash VAT in the case of managing more than one General Ledger configuration
2016-06-23 15:31psanjuanDescription Updatedbug_revision_view_page.php?rev_id=12470#r12470
2016-06-23 15:31psanjuanProposed Solution updated
2016-06-24 13:40psanjuanRelationship addedrelated to 0033354
2016-06-27 18:17psanjuanNote Added: 0087994
2016-06-27 18:27psanjuanNote Edited: 0087994bug_revision_view_page.php?bugnote_id=0087994#r12532
2016-06-27 18:32psanjuanNote Edited: 0087994bug_revision_view_page.php?bugnote_id=0087994#r12534
2016-06-27 18:33psanjuanNote Added: 0087995
2016-06-27 18:35psanjuanNote Edited: 0087995bug_revision_view_page.php?bugnote_id=0087995#r12537
2016-06-27 18:36psanjuanNote Edited: 0087994bug_revision_view_page.php?bugnote_id=0087994#r12538
2016-06-28 10:12aferrazAssigned ToTriage Finance => vmromanos
2016-06-28 10:13aferrazReview Assigned To => aferraz
2016-06-28 10:13aferrazNote Added: 0088016
2016-06-28 10:13aferrazStatusnew => closed
2016-06-28 10:13aferrazResolutionopen => fixed
2016-06-28 10:13aferrazFixed in Version => 3.0PR16Q3
2016-06-30 13:02psanjuanRelationship addedduplicate of 0029136
2016-06-30 13:04vmromanosNote Deleted: 0088016
2016-06-30 13:05psanjuanNote Edited: 0087995bug_revision_view_page.php?bugnote_id=0087995#r12557

Notes
(0087994)
psanjuan   
2016-06-27 18:17   
(edited on: 2016-06-27 18:36)
Test Plan 1

Invoice prepayment.

Create a purchase invoice for F&B, Bebidas Alegres BP.
Make sure it is set as Cash VAT = Yes.
Invoice date 30-06-2016.
Add any line.
Make sure a Cash VAT tax is used.
Complete the invoice. Post it.
 
Invoice posting will look like:

30-06-2016

For F&B España EURO
1156.00 (60000) Compras - CREDIT
242.76 (47200T) HP IVA soportado transitorio CREDIT
1398.76 (40700) Proveedores - DEBIT

For F&B International Group Dollar
1260.04 (5360) Product Expense - CREDIT
264.61 (4710T) Tax Expense transitory CREDIT
1524.65 (2110) Account Payables - DEBIT

Add a payment for the invoice dated on before invoice date, for instance 27-06-2016

Check that payment posting looks like:

F&B España GL Euro

27-06-2016
1398.76 (40700) Anticipo proveedores DEBIT
242.76 (47200) HP IVA soportado DEBIT
1398.76 (57200) Bancos CREDIT
242.76 (47200T) HP IVA soportado transitorio CREDIT

30-06-2016
1398.76 (40000) Proveedores - DEBIT
1398.76 (40700) Anticipo proveedores - CREDIT

For F&B International Group Dollar

27-06-2016
1524.65 (1410) Vendor Prepayment DEBIT
264.61 (7410) Tax Expense DEBIT
1524.65 (1140) Check In-Transfer CREDIT
264.61 (7410T) Tax Expense transitory CREDIT

30-06-2016
1524.65 (2110) Account Payables - DEBIT
1524.65 (1410) Vendor Prepayment - CREDIT


Test Plan 2.-


Invoice partial prepayment.

Create a purchase invoice for F&B España, Bebidas Alegres BP dated on 30-06-2016. Set it as Cash VAT.
Add any line. Make sure a Cash VAT tax rate is used.
Complete and Post the invoice.

Add a partial prepayment of 1000.00 €, for instance, dated on 27-06-2016.
Post the payment.

Check that payment posting looks like:

F&B España GL Euro

27-06-2016
1000.00 (40700) Anticipo proveedores DEBIT
173.55 (47200) HP IVA soportado DEBIT
1000.00 (57200) Bancos CREDIT
173.55 (47200T) HP IVA soportado transitorio CREDIT

30-06-2016
1000.00 (40000) Proveedores - DEBIT
1000.00 (40700) Anticipo proveedores - CREDIT

For F&B International Group Dollar

27-06-2016 - June exchange rate (EUR to $) = 1.09
1090.00 (1410) Vendor Prepayment DEBIT
189.17 (7410) Tax Expense DEBIT
1090.00 (1140) Check In-Transfer CREDIT
189.17 (7410T) Tax Expense transitory CREDIT

30-06-2016 - June exchange rate (EUR to $) = 1.09
1090.00 (2110) Account Payables - DEBIT
1090.00 (1410) Vendor Prepayment - CREDIT

Add a second payment to the invoice dated on 01-08-2016, for the rest (i.e. .e. 645.60 €)

Post the payment. Payment posting will look like:

F&B España GL Euro
01-08-2016
645.60 (40000) Proveedores DEBIT
112.05 (47200) HP IVA soportado DEBIT
645.60 (57200) Bancos CREDIT
112.05 (47200T) HP IVA soportado transitory CREDIT

For F&B International Group Dollar
01-08-2016 - exchange rate (EUR to $) changed from 1.09 (June exchange rate) to 1.05 (August exchange rate).

703.70 (645.60*1.09) (2110) Account Payables DEBIT
117.65 (112.05*1.05) (7410) Tax Expense DEBIT
4.48 [(112.05*1.09)- (112.05*1.05)] (8251) Bank Revaluation loss DEBIT
677.88 (645.60*1.05) (1140) Check In-Transfer CREDIT
122.13 (112.05*1.09) (7410T) Tax Expense Transitory CREDIT
25.82 [(645.60*1.09)- (645.60*1.05)] (8050) Bank Revaluation gain CREDIT

Repeat same test as above for Sales cycle and also for F&B US org which has only one General Ledger related.

(0087995)
psanjuan   
2016-06-27 18:33   
(edited on: 2016-06-30 13:05)
Test Plan above verified.

This issue was fixed with 29136 fix, as this issue is a duplicate of issue 29136