View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Invoice / credit note - ProjeQtOr
 
 

Invoice / credit note

More
20 Mar 2023 15:36 #1 by loicr
Invoice / credit note was created by loicr
Dear,

How can we andle "credit note" in oposite of "invoice" with our supplier or customer ?
Now, we are making negative "customer or supplier" invoice / order because we don't find other solution but it generate lot of trouble in sql code and logs ... but it is ok in definitive :)

Can you give us a solution ? or open invoice or order amount for beeing negative ( the simple way for us ) ?

Thanks
LR

In log, we have a lot of  :Exception-[22003] SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'billSum' at row 1
2023-03-20 08:47:18.321 ***** ERROR ***** [V10.2.3] For query : update planningelement set billSum='-19200.00' where id=2030
2023-03-20 08:47:18.322 ***** ERROR ***** [V10.2.3] Strack trace :
2023-03-20 08:47:18.322 ***** ERROR ***** [V10.2.3] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1854]
2023-03-20 08:47:18.322 ***** ERROR ***** [V10.2.3] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1308]
2023-03-20 08:47:18.322 ***** ERROR ***** [V10.2.3] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1107]
2023-03-20 08:47:18.322 ***** ERROR ***** [V10.2.3] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/PlanningElement.php:1185]
2023-03-20 08:47:18.322 ***** ERROR ***** [V10.2.3] #4 PlanningElement->simpleSave called at [/var/www/projeqtor/model/PlanningElement.php:2907]
2023-03-20 08:47:18.322 ***** ERROR ***** [V10.2.3] #5 PlanningElement->updateCA called at [/var/www/projeqtor/model/BillMain.php:452]
2023-03-20 08:47:18.322 ***** ERROR ***** [V10.2.3] #6 BillMain->save called at [/var/www/projeqtor/model/BillLine.php:494]
2023-03-20 08:47:18.322 ***** ERROR ***** [V10.2.3] #7 BillLine->save called at [/var/www/projeqtor/model/Importable.php:498]
2023-03-20 08:47:18.322 ***** ERROR ***** [V10.2.3] #8 Importable->import called at [/var/www/projeqtor/model/Cron.php:725]
2023-03-20 08:47:18.323 ***** ERROR ***** [V10.2.3] #9 Cron->checkImport called at [/var/www/projeqtor/model/Cron.php:499]
2023-03-20 08:47:18.323 ***** ERROR ***** [V10.2.3] #10 Cron->run called at [/var/www/projeqtor/tool/cronRun.php:33]
2023-03-20 08:47:20.073 ***** ERROR ***** [V10.2.3] Exception-[22003] SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'billSum' at row 1
2023-03-20 08:47:20.073 ***** ERROR ***** [V10.2.3] For query : update planningelement set billSum='-44985.50' where id=2221
2023-03-20 08:47:20.073 ***** ERROR ***** [V10.2.3] Strack trace :
2023-03-20 08:47:20.073 ***** ERROR ***** [V10.2.3] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1854]
2023-03-20 08:47:20.074 ***** ERROR ***** [V10.2.3] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1308]
2023-03-20 08:47:20.074 ***** ERROR ***** [V10.2.3] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1107]
2023-03-20 08:47:20.074 ***** ERROR ***** [V10.2.3] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/PlanningElement.php:1185]
2023-03-20 08:47:20.074 ***** ERROR ***** [V10.2.3] #4 PlanningElement->simpleSave called at [/var/www/projeqtor/model/PlanningElement.php:2907]
2023-03-20 08:47:20.074 ***** ERROR ***** [V10.2.3] #5 PlanningElement->updateCA called at [/var/www/projeqtor/model/BillMain.php:452]
2023-03-20 08:47:20.074 ***** ERROR ***** [V10.2.3] #6 BillMain->save called at [/var/www/projeqtor/model/BillLine.php:494]
2023-03-20 08:47:20.074 ***** ERROR ***** [V10.2.3] #7 BillLine->save called at [/var/www/projeqtor/model/Importable.php:498]
2023-03-20 08:47:20.074 ***** ERROR ***** [V10.2.3] #8 Importable->import called at [/var/www/projeqtor/model/Cron.php:725]
2023-03-20 08:47:20.074 ***** ERROR ***** [V10.2.3] #9 Cron->checkImport called at [/var/www/projeqtor/model/Cron.php:499]
2023-03-20 08:47:20.074 ***** ERROR ***** [V10.2.3] #10 Cron->run called at [/var/www/projeqtor/tool/cronRun.php:33]
2023-03-20 08:47:20.862 ***** ERROR ***** [V10.2.3] Exception-[22003] SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'billSum' at row 1
2023-03-20 08:47:20.862 ***** ERROR ***** [V10.2.3] For query : update planningelement set billSum='-44985.50' where id=2221
2023-03-20 08:47:20.862 ***** ERROR ***** [V10.2.3] Strack trace :
2023-03-20 08:47:20.862 ***** ERROR ***** [V10.2.3] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1854]
2023-03-20 08:47:20.862 ***** ERROR ***** [V10.2.3] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1308]
2023-03-20 08:47:20.862 ***** ERROR ***** [V10.2.3] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1107]
2023-03-20 08:47:20.863 ***** ERROR ***** [V10.2.3] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/PlanningElement.php:1185]
2023-03-20 08:47:20.863 ***** ERROR ***** [V10.2.3] #4 PlanningElement->simpleSave called at [/var/www/projeqtor/model/PlanningElement.php:2907]
2023-03-20 08:47:20.863 ***** ERROR ***** [V10.2.3] #5 PlanningElement->updateCA called at [/var/www/projeqtor/model/BillMain.php:452]
2023-03-20 08:47:20.863 ***** ERROR ***** [V10.2.3] #6 BillMain->save called at [/var/www/projeqtor/model/BillLine.php:494]
2023-03-20 08:47:20.863 ***** ERROR ***** [V10.2.3] #7 BillLine->save called at [/var/www/projeqtor/model/Importable.php:498]
2023-03-20 08:47:20.864 ***** ERROR ***** [V10.2.3] #8 Importable->import called at [/var/www/projeqtor/model/Cron.php:725]
2023-03-20 08:47:20.864 ***** ERROR ***** [V10.2.3] #9 Cron->checkImport called at [/var/www/projeqtor/model/Cron.php:499]
2023-03-20 08:47:20.864 ***** ERROR ***** [V10.2.3] #10 Cron->run called at [/var/www/projeqtor/tool/cronRun.php:33]
2023-03-20 08:47:24.168 ***** ERROR ***** [V10.2.3] Exception-[22003] SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'billSum' at row 1
2023-03-20 08:47:24.168 ***** ERROR ***** [V10.2.3] For query : update planningelement set billSum='-19200.00' where id=2030
2023-03-20 08:47:24.168 ***** ERROR ***** [V10.2.3] Strack trace :
2023-03-20 08:47:24.168 ***** ERROR ***** [V10.2.3] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1854]
2023-03-20 08:47:24.168 ***** ERROR ***** [V10.2.3] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1308]
2023-03-20 08:47:24.168 ***** ERROR ***** [V10.2.3] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1107]
2023-03-20 08:47:24.169 ***** ERROR ***** [V10.2.3] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/PlanningElement.php:1185]
2023-03-20 08:47:24.169 ***** ERROR ***** [V10.2.3] #4 PlanningElement->simpleSave called at [/var/www/projeqtor/model/PlanningElement.php:2907]
2023-03-20 08:47:24.169 ***** ERROR ***** [V10.2.3] #5 PlanningElement->updateCA called at [/var/www/projeqtor/model/BillMain.php:452]
2023-03-20 08:47:24.169 ***** ERROR ***** [V10.2.3] #6 BillMain->save called at [/var/www/projeqtor/model/BillLine.php:494]
2023-03-20 08:47:24.169 ***** ERROR ***** [V10.2.3] #7 BillLine->save called at [/var/www/projeqtor/model/Importable.php:498]
2023-03-20 08:47:24.169 ***** ERROR ***** [V10.2.3] #8 Importable->import called at [/var/www/projeqtor/model/Cron.php:725]
2023-03-20 08:47:24.169 ***** ERROR ***** [V10.2.3] #9 Cron->checkImport called at [/var/www/projeqtor/model/Cron.php:499]
2023-03-20 08:47:24.169 ***** ERROR ***** [V10.2.3] #10 Cron->run called at [/var/www/projeqtor/tool/cronRun.php:33]
2023-03-20 08:47:32.840 ***** ERROR ***** [V10.2.3] Exception-[22003] SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'billSum' at row 1
2023-03-20 08:47:32.840 ***** ERROR ***** [V10.2.3] For query : update planningelement set billSum='-100.00' where id=4495
2023-03-20 08:47:32.840 ***** ERROR ***** [V10.2.3] Strack trace :
2023-03-20 08:47:32.841 ***** ERROR ***** [V10.2.3] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1854]
2023-03-20 08:47:32.841 ***** ERROR ***** [V10.2.3] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1308]
2023-03-20 08:47:32.841 ***** ERROR ***** [V10.2.3] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1107]
2023-03-20 08:47:32.841 ***** ERROR ***** [V10.2.3] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/PlanningElement.php:1185]
2023-03-20 08:47:32.841 ***** ERROR ***** [V10.2.3] #4 PlanningElement->simpleSave called at [/var/www/projeqtor/model/PlanningElement.php:2907]
2023-03-20 08:47:32.841 ***** ERROR ***** [V10.2.3] #5 PlanningElement->updateCA called at [/var/www/projeqtor/model/BillMain.php:452]
2023-03-20 08:47:32.841 ***** ERROR ***** [V10.2.3] #6 BillMain->save called at [/var/www/projeqtor/model/BillLine.php:494]
2023-03-20 08:47:32.841 ***** ERROR ***** [V10.2.3] #7 BillLine->save called at [/var/www/projeqtor/model/Importable.php:498]
2023-03-20 08:47:32.841 ***** ERROR ***** [V10.2.3] #8 Importable->import called at [/var/www/projeqtor/model/Cron.php:725]
2023-03-20 08:47:32.841 ***** ERROR ***** [V10.2.3] #9 Cron->checkImport called at [/var/www/projeqtor/model/Cron.php:499]
2023-03-20 08:47:32.841 ***** ERROR ***** [V10.2.3] #10 Cron->run called at [/var/www/projeqtor/tool/cronRun.php:33]
2023-03-20 08:47:33.023 ***** ERROR ***** [V10.2.3] Exception-[22003] SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'billSum' at row 1
2023-03-20 08:47:33.024 ***** ERROR ***** [V10.2.3] For query : update planningelement set billSum='-100.00' where id=4495
2023-03-20 08:47:33.024 ***** ERROR ***** [V10.2.3] Strack trace :
2023-03-20 08:47:33.024 ***** ERROR ***** [V10.2.3] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1854]
2023-03-20 08:47:33.024 ***** ERROR ***** [V10.2.3] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1308]
2023-03-20 08:47:33.024 ***** ERROR ***** [V10.2.3] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:1107]
2023-03-20 08:47:33.024 ***** ERROR ***** [V10.2.3] #3 SqlElement->saveForced called at [/var/www/projeqtor/model/PlanningElement.php:1185]
2023-03-20 08:47:33.024 ***** ERROR ***** [V10.2.3] #4 PlanningElement->simpleSave called at [/var/www/projeqtor/model/PlanningElement.php:2907]
2023-03-20 08:47:33.024 ***** ERROR ***** [V10.2.3] #5 PlanningElement->updateCA called at [/var/www/projeqtor/model/BillMain.php:452]
2023-03-20 08:47:33.024 ***** ERROR ***** [V10.2.3] #6 BillMain->save called at [/var/www/projeqtor/model/BillLine.php:494]
2023-03-20 08:47:33.025 ***** ERROR ***** [V10.2.3] #7 BillLine->save called at [/var/www/projeqtor/model/Importable.php:498]
2023-03-20 08:47:33.025 ***** ERROR ***** [V10.2.3] #8 Importable->import called at [/var/www/projeqtor/model/Cron.php:725]
2023-03-20 08:47:33.025 ***** ERROR ***** [V10.2.3] #9 Cron->checkImport called at [/var/www/projeqtor/model/Cron.php:499]
2023-03-20 08:47:33.025 ***** ERROR ***** [V10.2.3] #10 Cron->run called at [/var/www/projeqtor/tool/cronRun.php:33]
2023-03-20 08:47:35.956 ===== TRACE ===== Import OK : file billline_20230319_210008.csv imported with no error [ Number of 'billline' imported : 165 ]
 

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

Moderators: babynusprotion
Time to create page: 0.039 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.