Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0033341
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2016-06-23 14:272016-06-30 13:02
ReporterpsanjuanView Statuspublic 
Assigned Tovmromanos 
PriorityurgentResolutionfixedFixed in Version3.0PR16Q3
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionProfessional ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Review Assigned Toaferraz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0033341: Invoice prepayment accounting needs to support Cash VAT in the case of managing more than one General Ledger configuration

DescriptionInvoice prepayment accounting needs to support Cash VAT in the case of managing more than one General Ledger configuration
Steps To ReproduceCreate 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
   
Proposed SolutionCorrect 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.
TagsNo tags attached.
Attached Filespng file icon issue33341_Euro.png [^] (44,944 bytes) 2016-06-23 15:19


png file icon issue33341_Dollar.png [^] (37,238 bytes) 2016-06-23 15:19

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of defect 00291363.0PR15Q3 closedAtulOpenbravo Wrong entry when posting prepayment against invoice using credit 
related to defect 0033354 closedvmromanos No correct Cash VAT posting for the payment in case of more than one General Ledger assigned to the Organization. 

-  Notes
(0087994)
psanjuan (manager)
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 (manager)
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

- Issue History
Date Modified Username Field Change
2016-06-23 14:27 psanjuan New Issue
2016-06-23 14:27 psanjuan Assigned To => Triage Finance
2016-06-23 14:27 psanjuan Modules => Core
2016-06-23 14:27 psanjuan Triggers an Emergency Pack => No
2016-06-23 14:31 psanjuan Steps to Reproduce Updated View Revisions
2016-06-23 15:11 psanjuan Steps to Reproduce Updated View Revisions
2016-06-23 15:16 psanjuan Steps to Reproduce Updated View Revisions
2016-06-23 15:16 psanjuan Proposed Solution updated
2016-06-23 15:17 psanjuan Proposed Solution updated
2016-06-23 15:19 psanjuan File Added: issue33341_Euro.png
2016-06-23 15:19 psanjuan File Added: issue33341_Dollar.png
2016-06-23 15:31 psanjuan Summary Invoice 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:31 psanjuan Description Updated View Revisions
2016-06-23 15:31 psanjuan Proposed Solution updated
2016-06-24 13:40 psanjuan Relationship added related to 0033354
2016-06-27 18:17 psanjuan Note Added: 0087994
2016-06-27 18:27 psanjuan Note Edited: 0087994 View Revisions
2016-06-27 18:32 psanjuan Note Edited: 0087994 View Revisions
2016-06-27 18:33 psanjuan Note Added: 0087995
2016-06-27 18:35 psanjuan Note Edited: 0087995 View Revisions
2016-06-27 18:36 psanjuan Note Edited: 0087994 View Revisions
2016-06-28 10:12 aferraz Assigned To Triage Finance => vmromanos
2016-06-28 10:13 aferraz Review Assigned To => aferraz
2016-06-28 10:13 aferraz Note Added: 0088016
2016-06-28 10:13 aferraz Status new => closed
2016-06-28 10:13 aferraz Resolution open => fixed
2016-06-28 10:13 aferraz Fixed in Version => 3.0PR16Q3
2016-06-30 13:02 psanjuan Relationship added duplicate of 0029136
2016-06-30 13:04 vmromanos Note Deleted: 0088016
2016-06-30 13:05 psanjuan Note Edited: 0087995 View Revisions

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker