Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0027078 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| design defect | [Modules] Remittance | major | always | 2014-07-15 12:55 | 2014-12-31 08:39 | |||
| Reporter | psanjuan | View Status | public | |||||
| Assigned To | Sandrahuguet | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 58e46b163a90 | ||||
| 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 | |||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | ||||||||
| Regression introduced in release | ||||||||
| Summary | 0027078: Remittance module does not properly manage temporary Cash VAT posting into fnal VAT posting. | |||||||
| Description | Remittance module does not properly manage temporary Cash VAT posting into "final" VAT posting, in the case of including either a sales or purchase Invoice in a remittance. | |||||||
| Steps To Reproduce | Go to purchase invoice and create a new invoice for a vendor who has a remittance type payment method, such as "Cuaderno 34". This vendor has also to be a CASH VAT vendor. Complete and post the invoice. Posting will look like: (Spanish/ EUR General Ledger) Debit: (60000) Compras 3750 Debit: (47200T) IVA soportado Temporal 650 Credit: (40000) Proveedores 4400 Let's say that invoice due date is 31-10-2014 Go to Remittance window and create a new remittance. Enter below data: Remittance Type: Cuaderno 34 Expected date: 31-10-2014 Name: Payment remittance Press "Select Orders or Invoices". In this new window select the INVOICE previously created Press Process. Realize that the tab Lines includes now the invoice to be paid through the remittance. Press Process and then post. Posting will look like: Debit: (40000) Proveedores 4400 Credit: (40100) Proveedores efectos comerciales a pagar 4400 Go to Settle/Protest Remittances window and select the remittance previously created in the field Remittance. Press search. Remittance is shown. Enter 15-11-2014 as "Accounting Date" and press Settle. Go to Remittance window, "Settled" tab and post the settled remittance. Posting would look like: Debit: (40100) Proveedores efectos comeciales a pagar 4400 Credit: (57200) Bancos 4400 | |||||||
| Proposed Solution | Temporary VAT should be move to final VAT when a remittance line is post to the ledger as settled in the "Remittance" window, "Settled" tab, at the accounting date entered by the end user in the "Settle/Protest Remittance" window. That accounting date should be reflected in the Cash VAT tab of the corresponding invoice. Therefore in our example, correct settle remittance posting should be Debit: (40100) Proveedores efectos comeciales a pagar 4400 Debit: (47200) IVA soportado 650 Credit: (57200) Bancos 4400 Credit: (47200T) IVA soportado Temporal 650 Important remarks: (1) same kind of posting also applies to remittances including sales invoices, therefore settle remittance posting should be (in the case of a remittance for discount): Debit: (57200) Bancos 982 Debit: (47700T) IVA repercutido temporal 47.40 Credit: (43110) Efectos comerciales descontados 982 Credit: (47700) IVA repercutido 47.40 A remittance for discount creates two payments, one is the discount payment (status: payment made), this one can be posted; and the other one is the remittance payment (status: settled in remittance) which can not be posted. The posting of the first one (discount payment) will look like: Debit: (55500) Partidas pendientes de aplicación 1240 Credit: (52080) Deudas por efectos descontandos 1240 Discount payment posting does not imply any Cash VAT posting to VAT posting. (2) same kind of posting also applies to remittances including sales invoices, therefore settle remittance posting should be (in the case of a remittance NOT for discount): Debit: (52080) Deudas por efectos descontados 982 Debit: (47700T) IVA repercutido temporal 47.40 Credit: (43120) Efectos comerciales en gestión de cobro 982 Credit: (47700) IVA repercutido 47.40 (3) In the case of a remittance including either a sales or a purchase order, there should not be any Cash VAT posting to VAT posting, because this kind of posting only makes sense while a purchase or sales INVOICE including cash vat rates is being paid as settled in a remittance. (4) In the case of a remittance including either a sales or a purchase invoice which have been partially pre-paid, Cash VAT posting to VAT posting needs to be just for the part of the invoice do NOT paid (pre-paid) that is now being settled/paid. (5) A remittance (payment in or payment out remittance type) can include more than one invoice/order which can be merged into a single payment remittance. (6) A remittance (payment in or payment out remittance type) can include payments. Only if that payment has not being posted so far it would make sense to manage temporary Cash VAT posting into VAT posting. See some examples in the excel file attached. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  Remesas_CASHVAT_Issue 27078.ods [^] (43,532 bytes) 2014-10-09 14:51 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0070535) psanjuan (manager) 2014-09-30 09:00 |
Another ticket related 30564 |
|
(0070612) psanjuan (manager) 2014-10-01 16:09 edited on: 2014-10-01 16:36 |
test plan: - payment in/our remittances including invoices with cash vat taxes together with no cash vat taxes (such as tax exempt). - payment in/out remittances including more than one cash vat invoice - payment in/out remittances including more than one cash vat invoice, single payment. - payment in remittance for discount, including more than one cash vat invoice - payment in/out remittance, including orders (total payment) - payment in/out remittance, including orders (partial payment) - payment in/out remittance, including invoice (partial payment) - payment in/out remittance, including invoice and order (partial payment) - payment in/out remittance, including payments no posted - payment in/out remittance unpost and reactivate |
|
(0070680) hgbot (developer) 2014-10-03 10:56 |
Repository: erp/mods/org.openbravo.module.remittance Changeset: 921150d7f0e4a01e6fe764bf5f0341a9372b26e3 Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> Date: Fri Oct 03 10:38:31 2014 +0200 URL: http://code.openbravo.com/erp/mods/org.openbravo.module.remittance/rev/921150d7f0e4a01e6fe764bf5f0341a9372b26e3 [^] Fixed issue 27078: Cash VAT support in Remittance posting Added Cash VAT for remittance accounting posting. When a Settled remittance is posted, the accounting process moved the VAT amount from the temporary account to the final one in case the associated payment is linked to a cash vat invoice. This process works for normal remittances or remittances for discount, regardless the Single Payment flag is set or not. --- M src-db/database/sourcedata/AD_MODULE.xml M src/org/openbravo/module/remittance/ad_forms/DocREMRemittanceCancel.java --- |
|
(0070681) hgbot (developer) 2014-10-03 10:56 |
Repository: erp/mods/org.openbravo.module.remittance Changeset: e49b0d2637317d075a2badacd8e5a7997f50f710 Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> Date: Fri Oct 03 10:38:31 2014 +0200 URL: http://code.openbravo.com/erp/mods/org.openbravo.module.remittance/rev/e49b0d2637317d075a2badacd8e5a7997f50f710 [^] Fixed issue 27078: Cash VAT support in Remittance posting Added Cash VAT for remittance accounting posting. When a Settled remittance is posted, the accounting process moved the VAT amount from the temporary account to the final one in case the associated payment is linked to a cash vat invoice. This process works for normal remittances or remittances for discount, regardless the Single Payment flag is set or not. --- M src-db/database/sourcedata/AD_MODULE.xml M src/org/openbravo/module/remittance/ad_forms/DocREMRemittanceCancel.java --- |
|
(0070682) vmromanos (manager) 2014-10-03 10:57 |
Published versions 3.1.16 and 3.2.8 in test status |
|
(0070732) hgbot (developer) 2014-10-06 10:57 |
Repository: erp/mods/org.openbravo.module.remittance Changeset: bf89ba6efdb892b8771be97323aaf592dfbda313 Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> Date: Mon Oct 06 10:40:08 2014 +0200 URL: http://code.openbravo.com/erp/mods/org.openbravo.module.remittance/rev/bf89ba6efdb892b8771be97323aaf592dfbda313 [^] Fixed issue 27078: Added prepayment support In case the payment is a prepayment, no Cash VAT posting is reflected when posting a Settle remittance --- M src-db/database/sourcedata/AD_MODULE.xml M src/org/openbravo/module/remittance/ad_forms/DocREMRemittanceCancel.java --- |
|
(0070733) hgbot (developer) 2014-10-06 10:58 |
Repository: erp/mods/org.openbravo.module.remittance Changeset: 58e46b163a9035587ddc2621a42c44be15a4154e Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> Date: Mon Oct 06 10:40:08 2014 +0200 URL: http://code.openbravo.com/erp/mods/org.openbravo.module.remittance/rev/58e46b163a9035587ddc2621a42c44be15a4154e [^] Fixed issue 27078: Added prepayment support In case the payment is a prepayment, no Cash VAT posting is reflected when posting a Settle remittance --- M src-db/database/sourcedata/AD_MODULE.xml M src/org/openbravo/module/remittance/ad_forms/DocREMRemittanceCancel.java --- |
|
(0070734) vmromanos (manager) 2014-10-06 10:58 |
Canceled versions 3.1.16 and 3.2.8 in test status. Published versions 3.1.17 and 3.2.9 in test status |
|
(0070793) psanjuan (manager) 2014-10-08 08:56 |
fixed and working. See excel sheet attached as it contains the test cases executed. |
|
(0072870) psanjuan (manager) 2014-12-30 09:56 |
Issue re-opened as this is not working now in 3.0PR14Q3.4 |
|
(0073284) psanjuan (manager) 2014-12-31 08:35 edited on: 2014-12-31 08:36 |
Issue closed as it should not have been re-opened due to the regression found, but a new issue needs to be entered. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2014-07-15 12:55 | psanjuan | New Issue | |
| 2014-07-15 12:55 | psanjuan | Assigned To | => psanjuan |
| 2014-07-21 12:45 | psanjuan | Summary | Remittance for discount does not manage Cash VAT info properly => Remittance and Remittance for discount does not manage Cash VAT info properly |
| 2014-07-21 12:45 | psanjuan | Description Updated | View Revisions |
| 2014-07-21 12:47 | psanjuan | Summary | Remittance and Remittance for discount does not manage Cash VAT info properly => Remittance and Remittance for discount does not manage Cash VAT info properly, therefore Cash VAT posting is not happening |
| 2014-07-21 12:47 | psanjuan | Description Updated | View Revisions |
| 2014-07-21 13:01 | psanjuan | Summary | Remittance and Remittance for discount does not manage Cash VAT info properly, therefore Cash VAT posting is not happening => Remittancefor discount does not manage Cash VAT info properly |
| 2014-07-21 13:01 | psanjuan | Description Updated | View Revisions |
| 2014-07-21 13:42 | psanjuan | Summary | Remittancefor discount does not manage Cash VAT info properly => Remittance module does not properly manage Cash VAT posting |
| 2014-07-21 13:42 | psanjuan | Description Updated | View Revisions |
| 2014-07-24 12:51 | psanjuan | Proposed Solution updated | |
| 2014-07-24 12:52 | psanjuan | Proposed Solution updated | |
| 2014-09-30 09:00 | psanjuan | Note Added: 0070535 | |
| 2014-10-01 15:30 | psanjuan | Summary | Remittance module does not properly manage Cash VAT posting => Remittance module does not properly manage temporary Cash VAT posting to VAT posting |
| 2014-10-01 15:30 | psanjuan | Description Updated | View Revisions |
| 2014-10-01 15:30 | psanjuan | Steps to Reproduce Updated | View Revisions |
| 2014-10-01 15:38 | psanjuan | Steps to Reproduce Updated | View Revisions |
| 2014-10-01 15:52 | psanjuan | Steps to Reproduce Updated | View Revisions |
| 2014-10-01 15:52 | psanjuan | Proposed Solution updated | |
| 2014-10-01 15:55 | psanjuan | Proposed Solution updated | |
| 2014-10-01 15:59 | psanjuan | Proposed Solution updated | |
| 2014-10-01 16:09 | psanjuan | Note Added: 0070612 | |
| 2014-10-01 16:09 | psanjuan | Proposed Solution updated | |
| 2014-10-01 16:09 | psanjuan | Note Edited: 0070612 | View Revisions |
| 2014-10-01 16:22 | psanjuan | Summary | Remittance module does not properly manage temporary Cash VAT posting to VAT posting => Remittance module does not properly manage temporary Cash VAT posting into fnal VAT posting. |
| 2014-10-01 16:22 | psanjuan | Description Updated | View Revisions |
| 2014-10-01 16:22 | psanjuan | Steps to Reproduce Updated | View Revisions |
| 2014-10-01 16:22 | psanjuan | Proposed Solution updated | |
| 2014-10-01 16:32 | psanjuan | Steps to Reproduce Updated | View Revisions |
| 2014-10-01 16:32 | psanjuan | Proposed Solution updated | |
| 2014-10-01 16:36 | psanjuan | Note Edited: 0070612 | View Revisions |
| 2014-10-01 16:36 | psanjuan | Note Edited: 0070612 | View Revisions |
| 2014-10-01 16:37 | psanjuan | File Added: Remesas_CASHVAT_Issue 27078.ods | |
| 2014-10-01 16:37 | psanjuan | Proposed Solution updated | |
| 2014-10-01 16:42 | psanjuan | Proposed Solution updated | |
| 2014-10-03 10:04 | vmromanos | Status | new => scheduled |
| 2014-10-03 10:04 | vmromanos | Assigned To | psanjuan => vmromanos |
| 2014-10-03 10:04 | vmromanos | fix_in_branch | => pi |
| 2014-10-03 10:56 | hgbot | Checkin | |
| 2014-10-03 10:56 | hgbot | Note Added: 0070680 | |
| 2014-10-03 10:56 | hgbot | Status | scheduled => resolved |
| 2014-10-03 10:56 | hgbot | Resolution | open => fixed |
| 2014-10-03 10:56 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/mods/org.openbravo.module.remittance/rev/921150d7f0e4a01e6fe764bf5f0341a9372b26e3 [^] |
| 2014-10-03 10:56 | hgbot | Checkin | |
| 2014-10-03 10:56 | hgbot | Note Added: 0070681 | |
| 2014-10-03 10:56 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/mods/org.openbravo.module.remittance/rev/921150d7f0e4a01e6fe764bf5f0341a9372b26e3 [^] => http://code.openbravo.com/erp/mods/org.openbravo.module.remittance/rev/e49b0d2637317d075a2badacd8e5a7997f50f710 [^] |
| 2014-10-03 10:57 | vmromanos | Note Added: 0070682 | |
| 2014-10-06 10:26 | psanjuan | File Deleted: Remesas_CASHVAT_Issue 27078.ods | |
| 2014-10-06 10:57 | hgbot | Checkin | |
| 2014-10-06 10:57 | hgbot | Note Added: 0070732 | |
| 2014-10-06 10:57 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/mods/org.openbravo.module.remittance/rev/e49b0d2637317d075a2badacd8e5a7997f50f710 [^] => http://code.openbravo.com/erp/mods/org.openbravo.module.remittance/rev/bf89ba6efdb892b8771be97323aaf592dfbda313 [^] |
| 2014-10-06 10:58 | hgbot | Checkin | |
| 2014-10-06 10:58 | hgbot | Note Added: 0070733 | |
| 2014-10-06 10:58 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/mods/org.openbravo.module.remittance/rev/bf89ba6efdb892b8771be97323aaf592dfbda313 [^] => http://code.openbravo.com/erp/mods/org.openbravo.module.remittance/rev/58e46b163a9035587ddc2621a42c44be15a4154e [^] |
| 2014-10-06 10:58 | vmromanos | Note Added: 0070734 | |
| 2014-10-08 08:56 | psanjuan | Note Added: 0070793 | |
| 2014-10-08 08:58 | psanjuan | File Added: Remesas_CASHVAT_Issue 27078.ods | |
| 2014-10-08 08:59 | psanjuan | Status | resolved => closed |
| 2014-10-08 08:59 | psanjuan | fix_in_branch | pi => |
| 2014-10-09 14:50 | psanjuan | File Deleted: Remesas_CASHVAT_Issue 27078.ods | |
| 2014-10-09 14:51 | psanjuan | File Added: Remesas_CASHVAT_Issue 27078.ods | |
| 2014-12-30 09:56 | psanjuan | Note Added: 0072870 | |
| 2014-12-30 09:56 | psanjuan | Assigned To | vmromanos => Sandrahuguet |
| 2014-12-30 09:56 | psanjuan | Status | closed => new |
| 2014-12-31 08:35 | psanjuan | Note Added: 0073284 | |
| 2014-12-31 08:36 | psanjuan | Note Edited: 0073284 | View Revisions |
| 2014-12-31 08:36 | psanjuan | Status | new => scheduled |
| 2014-12-31 08:37 | psanjuan | Status | scheduled => resolved |
| 2014-12-31 08:39 | psanjuan | Status | resolved => closed |
| 2015-01-07 14:10 | ngarcia | Relationship added | related to 0028533 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |