Hello,
V 12.4.0.
The same error again, ProjeQtOr ask for planned Date and planned amount for expense, even if there are in file or ask for real Amount and Real Date.
I try this :
export 2 expenses from ProjeQtOr with EVERY fields (see attachment
)
THEN : import these 2 expenses, without modifying export file.
So, the result is :
WHY an error on line 1, no real amount in import file ????
I change the file, removing id for creating new expenses :
WHY error on planned date and planned amount while the are reading and report on result screen ???? NOTE that value 0 for real amount with tax, appearing in import with id doesn't appear anymore...
New change : i set the tax rate and planned tax amount (changing plannedamount = planned amount with tax / 1,20 and tax rate set to 20).
Always the same error :
LAST TRY :
removing planned amount and date (removing column in csv file) and it works (but i need to set the amount and date manualy).
Not a good way to insert the almost 350 expenses i want to insert...
very blocking and can't find a way to progress...
Regards,
FOUND THE BUG !!!
My ProjeQtOr is set to enter value for amount in TTC and not HT.
Then, while import, TTC value is not computed and amount is set to 0 each time...
Changing enter mode to HT will make import OK.
So, enter mode is not well used in control() function in Expense.php file (in model).
Regards,
Another unexpented behavior :
if i use date prévue and montant prévu in csv file (for french import), i got the message "vous devez entrer à la fois la date et le montant prévu", even if the fields are well recognized (there are not grey in import result).
If i change there name with plannedAmount and expensePlannedDate, then import is correct.
Regards,
What name shall I use to import tax rate ? I tried a lot but could not find one functional