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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0028527
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2015-01-07 10:042017-05-29 13:45
ReporterpsanjuanView Statuspublic 
Assigned ToTriage Finance 
PriorityurgentResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6
OS VersionUbuntu 8.04.1Database version11.1.0.6.0Ant version1.7.0
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0028527: Wrong accounting in case of posting a payment related to a Cash VAT sales invoice for which new lines have been added.

DescriptionWrong accounting in case of posting a payment related to a Cash VAT sales invoice for which new lines have been added.
Steps To ReproduceMake sure that F&B España is set as a Cash VAT organization.
Navigate to Organization window, search by F&B España and select below two parameters in "Information" tab:
Cash VAT
Double Cash Criteria.

Go to sales order window and create a new one for "Hoteles Buenas Noches" dated on 07/01/2015. Change invoice terms to "Inmediate".

Go to Lines and select below two products:
Agua sin Gas 1L - Ordered quantity 1.500 units. Change Tax to Entregas IVA 4% IVA de Caja".

Vino Rosado 0.75L - Ordered quantity 1.500 units.

Book the order.

Add a prepayment of the order of an amount of 3200,00 € by using "Add Payment" process button.

Go to Sales Invoice window and create a new one for "Hoteles Buenas Noches" by using "Create Lines From" process button. Select the order just created.

Realize that a prepayment amount = 3.200 is shown at the top of the sales invoice header.

Navigate to Lines and add two new lines:
Limonada 0.5L - Invoiced Quantity = 800 units
Vino Blanco 0.75L - Invoiced Quantity = 800 units

Complete the invoice.

Navigate to Tax tab - select "Entregas IVA 21% IVA de Caja" and realize that tax amount shown under Cash VAT sub-tab is 483.88 (17.23% VAT paid due to prepayment)
Navigate to Tax tab - select "Entregas IVA 4% IVA de Caja" and realize that tax amount shown under Cash VAT sub-tab is 15.82 (17.23% VAT paid due to prepayment)

Post the invoice. Posting looks like:

Debit: (43000) Clientes 15.368.13
Debit: (43800) Anticipos 3.200.00
Credit: (70000) Venta 15.668.00
Credit: (47700T) HP Iva repercutido temporal 2.400.43
Credit: (47700) HP IVA repercutido 499.70 (483.88 + 15.82)

Add a new partial payment by using "Add payment " process button. Pay now 12.000.00 €

Navigate to Payment Plan tab and realize that a new payment has been created that has two lines:
First line does have a received amount = 5.962.88
Second line does have a received amount = 6.037.12
total of 12.000.00

Navigate to Tax tab - select "Entregas IVA 21% IVA de Caja" and realize that tax amount shown under Cash VAT sub-tab is:
901.75 + 912.99 = 1814.74

Navigate to Tax tab - select "Entregas IVA 4% IVA de Caja" and realize that tax amount shown under Cash VAT sub-tab is:
29.48 + 29.84 = 49.32

Go now to payment in window and post the new payment. Posting looks like:

Debit: (55500) Partidas pendientes aplicación 12.000.00
Debit: (47700T) HP IVA repercutido temporal 942.83 (912.99 + 29.84)
Credit: (43000) Clientes 12.000.00
Credit: (47700) HP IVA repercutido 942.83 (912.99 + 29.84)




Proposed SolutionAbove posting is not correct as it only takes one of the payment plan detail lines created:

Correct posting should take into account all payment detail lines as it should be:

Debit: (55500) Partidas pendientes aplicación 12.000.00
Debit: (47700T) HP IVA repercutido temporal 1863.97 (1814.74 + 49.23)
Credit: (43000) Clientes 12.000.00
Credit: (47700) HP IVA repercutido 1863.97 (1814.74 + 49.23)
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00275803.0PR15Q1 closedSandrahuguet Wrong journal entries when you void a sales invoice under some circumstances 
related to defect 0037206 scheduledcollazoandy4 Wrong outstanding amount after voiding a partial prepaid sales invoice 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2015-01-07 10:04 psanjuan New Issue
2015-01-07 10:04 psanjuan Assigned To => dmiguelez
2015-01-07 10:04 psanjuan Modules => Core
2015-01-07 10:04 psanjuan Triggers an Emergency Pack => No
2015-01-07 10:07 psanjuan Relationship added related to 0027580
2015-01-07 10:25 psanjuan Steps to Reproduce Updated View Revisions
2015-01-07 10:26 psanjuan Steps to Reproduce Updated View Revisions
2015-01-07 10:45 psanjuan Steps to Reproduce Updated View Revisions
2015-01-07 10:45 psanjuan Proposed Solution updated
2015-01-07 10:45 psanjuan Assigned To dmiguelez => Sandrahuguet
2017-05-29 13:45 Sandrahuguet Assigned To Sandrahuguet => Triage Finance
2017-11-02 08:18 AtulOpenbravo Relationship added related to 0037206


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker