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 ]