Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Again : error impor...
 
Notifications
Clear all

Again : error importing project expense

4 Posts
2 Users
0 Reactions
489 Views
jmmbb
(@jmmbb)
Posts: 561
Contributor
Topic starter
 
[#10039]

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,
 


 
Posted : 21 Jan 2026 16H01
jmmbb
(@jmmbb)
Posts: 561
Contributor
Topic starter
 

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,


 
Posted : 21 Jan 2026 17H13
jmmbb
(@jmmbb)
Posts: 561
Contributor
Topic starter
 

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,


 
Posted : 26 Jan 2026 12H47
(@fsobel)
Posts: 20
Active Member
 

What name shall I use to import tax rate ? I tried a lot but could not find one functional


 
Posted : 07 Jul 2026 17H29
Share:

Scroll to Top