logo dolibarr Modificar fecha de los pagos especiales en DolibarrLet's see how to change the date of the special payments made in our Dolibarr. This can be useful when you have selected an incorrect date and the system no longer lets us modify it to meet future payments.

This situation gave me when you pay income tax in 2015 and made the statement in the first 20 days of January 2016. When registering payment in January Dolibarr account reports that income tax payment as payment in 2016 and not as the last quarter of 2015 should be right.

Thanks to an idea of ​​a Forero Dolibarr consisting put the date of the last day of 2015, I could make some tests and I managed to keep the payment record in the last quarter of 2015 and also maintain the actual date when I made payment in January of 2016. I did as follows.

The idea is to put the payment the payment date when real estate made the payment. And in the value date put the December 31, 2015 for reports that record as the quarter last year and part of 2015 taxes.

Pay day = Actual date of entry into hacienda

Value date = Last day of the previous year

If we are wrong to introduce payment and the system does not let us change it, we must go to the DB and launch some SQL statements. Let us see step by example.

Here is the payment to date of January 9, 2016, the day the procedure was done with hacienda. If we click on Personal Income Tax on the menu of the Left within the module Financial will see that the report records it as payment of income tax made in January 2016. It really is incorrect since the tax for the year 2015 (regardless of what we have paid in the first 20 days of the subsequent quarter).

dolibarr modificar fecha de pagos especiales 01 Modificar fecha de los pagos especiales en Dolibarr

payment made

Seeking BBDD found the resgistro is stored in the table llx_ecotax and wherein two dates, one in datep column and another column in the DATEV saved. The datep column is the date of payment Y the DATEV column is the value date.

dolibarr modificar fecha de pagos especiales 02 Modificar fecha de los pagos especiales en Dolibarr

SQL for payments BBDD

As discussed earlier, the date that interests us is change value date. We run an UPDATE statement on the record indicating that the value date is the December 31, 2015.

dolibarr modificar fecha de pagos especiales 03 Modificar fecha de los pagos especiales en Dolibarr

Execution UPDATE

With this modification we see that the payment date It has been modified. although it appears pay day It is not a misprint.

dolibarr modificar fecha de pagos especiales 04 Modificar fecha de los pagos especiales en Dolibarr

payment made

dolibarr modificar fecha de pagos especiales 05 Modificar fecha de los pagos especiales en Dolibarr

Income Tax Report 2015

If we consult the log detail from the application itself, we see that we have changed the value date, Although the interface see that makes payment date. So I say it looks like a misprint but it is not.

dolibarr modificar fecha de pagos especiales 06 Modificar fecha de los pagos especiales en Dolibarr

Payment detail with the corrected dates

And that's it. So this way we have registered in our Dolibarr ERP / CRM Special properly in the correct quarter and maintaining the correct date of when payments made payments.

Keep updated your ERP / CRM Dolibarr

logo dolibarr Modificar fecha de los pagos especiales en Dolibarr

 

  • Upgrade your Dolibarr without complications or risks to the latest version.
  • Keep your data safe. I perform backup before performing the process.
  • all information is migrated without losing anything.
  • Escríbeme y te daré presupuesto personalizado sin compromiso pulsando el siguiente botón:

Quiero saber más sobre cómo Actualizar Dolibarr

 

Dime qué te ha parecido el artículo...

rating off Modificar fecha de los pagos especiales en Dolibarrrating off Modificar fecha de los pagos especiales en Dolibarrrating off Modificar fecha de los pagos especiales en Dolibarrrating off Modificar fecha de los pagos especiales en Dolibarrrating off Modificar fecha de los pagos especiales en Dolibarr (Ninguna valoración todavía)
loading Modificar fecha de los pagos especiales en DolibarrCargando…
Advertisements

Use of cookies

This site uses cookies for you to have the best user experience. If you continue to browse you are giving your consent to the acceptance of the above cookies and acceptance of our cookies policy, Click the link for more information.

OK
Notice of cookies

Veo que te gusta mi Blog...

Si te ha parecido interesante este artículo, no esperes a suscribirte a mi blog. Cuando vuelva a escribir otro seguro que te interesará y no desearás no haberte enterado. Puedes suscribirte con total tranquilidad de que no recibirás spam. Lo odio igual que tu. Solo quiero que aprendas cosas nuevas y te sientas agusto con mis artículos. ¡Gracias!

Thank you for subscribing!

Pin it on Pinterest

Share This

Share

Share this with your friends!