Let'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).
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.
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.
With this modification we see that the payment date It has been modified. although it appears pay day It is not a misprint.
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.
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
- 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.
- Write me and I will give personalized quote (Contact)