1. Change of the date: When importing via excel, some original date change to a completely different one:
ORIGINAL DATE | DATE "BUG"
14/09/2020 -> 02/09/2021
23/03/2020 -> 11/03/2021
16/06/2020 -> 04/06/2021 x2
30/01/2020 -> 06/01/2022 x4
20/02/2020 -> 08/02/2021
31/03/2020 -> 07/03/2022 x2
31/12/2020 -> 07/12/2022 x7
18/12/2020 -> 06/12/2021
21/09/2020 -> 09/09/2021
17/09/2020 -> 05/09/2021
13/07/2020 -> 01/07/2021
14/02/2020 -> 02/02/2021
19/10/2020 -> 07/10/2021 x3
20/07/2020 -> 08/07/2021 x3
Note: x... represents the ammount of times that this happened with the same date.
2. Re-opened projects
When re-opening projects, I cannot import data stating that the project is mandatory, in this case I need to do it manually even though the project after re-opened it shows in the dropdownlist
3. Closed invoices sometimes needed recipient and invoice contact mandatorily for some reason.
4. Invoice lines is missing, with this everything needs to be manual, in this case I had 150+ invoice lines to add, imagine the work.
1) Which dates are these ?
2) Just setting "idle" to 0 won't be enough. It status is still on idle status, first operation on project (for instanc eneeded for consolidating data) will set back idle to 1
3) Please give mode detail. We cannot analyse with so little detail. "some"=> which, "sometines"=>when ?
4) Missing from what ?
1. When I want to import new data I go to import data -> client invoices and these dates represent the date field (the left dates are the ones that I import, and on the right are the ones that change to that one for some reason with x amount of times that have happened).
2. Will take a better look at that then.
3. I've made a quick test, the fields that is asking it's not marked as mandatory (sub red line) -> 
but when the status is cancelled it doesn't let me import/create.
1. Be sure that date format is the same as you own display date format. If you have any doubt, enter dates as YYYY-MM-DD
3. Fields may become mandatory because of status.
1. With dates 200+ records where added in the following format: DD-MM-YYYY, they seemed to get in ok, despite the few that I stated.
2. Got it, everything seems alright.
1. DD-MM-YYYY is not a valid date format DD/MM/YYYY or YYYY-MM-DD are.
Moreover if your dates are stores as DD/MM/YYYY but you expect format as MM/DD/YYYY, you'll get issues on dates befor 12th of each month as it wxill invert MM and DD.
If day of the month is over 12th, the system will auto-reverse DD and MM and will get what you expect..