0027078: Remittance module does not properly manage temporary Cash VAT posting into fnal VAT posting.

Openbravo Issue Tracking System - Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0027078

Modules

Remittance

public

2014-07-15 12:55

2014-12-31 08:39

Reporter

psanjuan

Assigned To

Sandrahuguet

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Ubuntu 8.04.1

Product Version

Target Version

Fixed in Version

Merge Request Status

Regression date

Regression introduced by commit

Regression level

Review Assigned To

Support ticket

OBNetwork customer

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.

Additional Information

Tags

No tags attached.

Relationships

related to

defect

0028533

closed

Sandrahuguet

Remittance module does not properly manage temporary Cash VAT posting into fnal VAT posting

Attached Files

Remesas_CASHVAT_Issue 27078.ods (43,532) 2014-10-09 14:51
https://issues.openbravo.com/file_download.php?file_id=7333&type=bug

Issue History

Date Modified

Username

Field

Change

2014-07-15 12:55