View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Error importing project expense - Page 2 - ProjeQtOr
 

[SOLVED] Error importing project expense

More
25 Sep 2025 13:12 #7 by jmmbb
I get this error on log :

2025-09-25 12:59:26.224 ===== TRACE ===== [1] => Import line n° 4
2025-09-25 12:59:26.226 ..... SCRIPT .... [1] 80.241.9.27 UserMain::getVisibleProjects(limitToActiveProjects=1)
2025-09-25 12:59:26.229 ..... SCRIPT .... [1] 80.241.9.27 UserMain::getVisibleProjects(limitToActiveProjects=1)
2025-09-25 12:59:26.229 ..... SCRIPT .... [1] 80.241.9.27 securityGetAccessRightYesNo ( menuName=menuProjectExpense, accessType=create, obj=ProjectExpense #, user=User #1)
2025-09-25 12:59:26.230 ..... SCRIPT .... [1] 80.241.9.27 securityGetAccessRight(menuName=menuProjectExpense, accessType=create, obj=ProjectExpense #, user=User #1)
2025-09-25 12:59:26.230 ..... SCRIPT .... [1] 80.241.9.27 getAccessControlRights(obj=ProjectExpense #)
2025-09-25 12:59:26.230 ..... SCRIPT .... [1] 80.241.9.27 UserMain::getVisibleProjects(limitToActiveProjects=1)
2025-09-25 12:59:26.231 ***** ERROR ***** [V12.1.2] [1] Error on SqlElement to get 'availableTransferedAmount' for Class 'Budget' : field 'availableTransferedAmount' not found in Database on table budget

Please Log in or Create an account to join the conversation.

More
25 Sep 2025 13:30 - 25 Sep 2025 13:32 #8 by jmmbb
I try on another instance (test) installed from scratch (V12.1.2).
I get the same error :
 

Note that expensePlannedDate and plannedAmount are recognized (it set the column with english name to avoid traduction error and they are correctly translated during import).

Not VAT ou exVAT find in field list...
 
Attachments:
Last edit: 25 Sep 2025 13:32 by jmmbb.

Please Log in or Create an account to join the conversation.

More
25 Sep 2025 13:40 #9 by jmmbb
I use the full example for import (in my production instance, fields VAT and VAT amount are hidden by screen customization so they don't appear on list for import.

It work.

So perhaps it will be convenient to show even hidden fields in import example to avoid missing them.

Regards,

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.162 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.