Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0028527 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2015-01-07 10:04 | 2017-05-29 13:45 | |||||||
| Reporter | psanjuan | View Status | public | |||||||||
| Assigned To | Triage Omni OMS | |||||||||||
| Priority | urgent | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Linux 32 bit | Database | Oracle | Java version | 1.6 | |||||||
| OS Version | Ubuntu 8.04.1 | Database version | 11.1.0.6.0 | Ant version | 1.7.0 | |||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0028527: Wrong accounting in case of posting a payment related to a Cash VAT sales invoice for which new lines have been added. | |||||||||||
| Description | Wrong accounting in case of posting a payment related to a Cash VAT sales invoice for which new lines have been added. | |||||||||||
| Steps To Reproduce | Make 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 Solution | Above 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) | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |