Openbravo Issue Tracking System - Openbravo ERP
It is fine that Openbravo does not allow to reactivate a payment in/out of a sales/purchase invoice, because payment in/out information is now included in the VAT books (issued and received invoice books).
What needs to be improved is the error message which now is:
ERROR: update or delete on table "c_invoicetax_cashvat" violates foreign key constraint "obirb_invbline_cinvtaxcvat_fk" on table "obirb_invbookline" Detail: Key (c_invoicetax_cashvat_id)=(41E8CB9147684C9F8A4DE6F254293703) is still referenced from table "obirb_invbookline".
Make sure that you have install and applied below modules:
Cash VAT Spain Taxes
Invoice Register Books
Configuración de los Libros Facturas 2014
Configuración de los Libros Facturas 2014 IVA de Caja
Navigate to the purchase invoice window and create a new purchase invoice for any product. This purchase invoice can be dated on January 2014 for instance.
Make sure that the VAT tax rate selected is a CASH VAT rate.
Complete and Post the invoice
Add a payment of that invoice dated on February 2014. Post the payment.
Navigate to the Invoice Register Book window and create a new one for F&B España
the name of the book could be "Libro de facturas recibidas Enero 2014", select
"Libro de Facturas Recibidas 2014" and 2014 year, and Jan-14 as from period to period.
Create the book and realize that the purchase invoice just created is in the book and no information is filled in the columns:
payment/collection date
amount paid/collected
payment method
and bank
Create a new book for F&B España, this time for February period.
the name of the book could be "Libro de facturas recibidas Febrero 2014", select "Libro de Facturas Recibidas 2014" and 2014 year, and Feb-14 as from period to period.
Create the book and realize that the purchase invoice just created is in the book together with the payment information in below columns:
payment/collection date
amount paid/collected
payment method
and bank
Go back to the payment out window and get the payment unposted.
Try now to reactivate it.
You will get the error, which is fine but it should be a more intuitive error.
This error will not be shown whenever the invoice line and therefore the payment information is removed from February Invoice Received book.
"It is not possible to reactive a payment which is included in an Invoice Register Book. Please remove the payment information from the book by removing the invoice lines linked to the payment from the corresponding book.
Note that whenever you create the same book once again, the corresponding invoice lines will be included once again in the book together with the payment information if the invoice is paid/collected"
| related to | design defect | 0026492 | closed | vmromanos | Localization Pack: Spain | Payment information should be shown only in one line in the Invoice Register Books. |
error_reactivate_paymentIn.png (109,574) 2014-03-25 14:16https://issues.openbravo.com/file_download.php?file_id=6773&type=bug
error_reactivate_paymentout.png (135,232) 2014-03-25 14:17https://issues.openbravo.com/file_download.php?file_id=6774&type=bug