Openbravo Issue Tracking System - Openbravo ERP | |||||||||||||||||||
| View Issue Details | |||||||||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||||||||||||
| 0028527 | Openbravo ERP | 09. Financial management | public | 2015-01-07 10:04 | 2017-05-29 13:45 | ||||||||||||||
| Reporter | psanjuan | ||||||||||||||||||
| Assigned To | Triage Omni OMS | ||||||||||||||||||
| Priority | urgent | Severity | major | Reproducibility | always | ||||||||||||||
| Status | new | Resolution | open | ||||||||||||||||
| Platform | OS | 20 | OS Version | Ubuntu 8.04.1 | |||||||||||||||
| Product Version | |||||||||||||||||||
| Target Version | Fixed in Version | ||||||||||||||||||
| Merge Request Status | |||||||||||||||||||
| Review Assigned To | |||||||||||||||||||
| OBNetwork customer | |||||||||||||||||||
| Web browser | |||||||||||||||||||
| Modules | Core | ||||||||||||||||||
| Support ticket | |||||||||||||||||||
| 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) | ||||||||||||||||||
| Additional Information | |||||||||||||||||||
| Tags | No tags attached. | ||||||||||||||||||
| Relationships |
| ||||||||||||||||||
| Attached Files | |||||||||||||||||||
| 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 | bug_revision_view_page.php?rev_id=7389#r7389 | ||||||||||||||||
| 2015-01-07 10:26 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=7390#r7390 | ||||||||||||||||
| 2015-01-07 10:45 | psanjuan | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=7391#r7391 | ||||||||||||||||
| 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 | ||||||||||||||||
| There are no notes attached to this issue. |