[2026-03-30 21:01:20] [INFO] =========================================== [2026-03-30 21:01:20] [INFO] Quotations Processor Log [2026-03-30 21:01:20] [INFO] Record ID: 8feea1aa-4a01-4db3-9fec-22d8eebadcb3 [2026-03-30 21:01:20] [INFO] Table: quotations [2026-03-30 21:01:20] [INFO] Timestamp: 2026-03-30 21:01:20 [2026-03-30 21:01:20] [INFO] =========================================== [2026-03-30 21:01:20] [INFO] ========== START: processQuotationSubmission ========== [2026-03-30 21:01:20] [INFO] Function called for record ID: 8feea1aa-4a01-4db3-9fec-22d8eebadcb3 [2026-03-30 21:01:20] [DEBUG] Form data received: {"table":"quotations","tenant_id":"019bafe2-05ad-7b4a-c449-ebcb1b933597"} [2026-03-30 21:01:20] [INFO] Detected table: quotations (Type: proforma) [2026-03-30 21:01:20] [DEBUG] ID field: quotation_id, Number field: quotation_number [2026-03-30 21:01:20] [DEBUG] STEP 1: Fetching quotation data from database [2026-03-30 21:01:20] [DEBUG] QueryBuilder instance created [2026-03-30 21:01:20] [DEBUG] Database query executed for quotation_id: 8feea1aa-4a01-4db3-9fec-22d8eebadcb3 [2026-03-30 21:01:20] [DEBUG] Quotation found successfully [2026-03-30 21:01:20] [INFO] quotation_type from record overrides invoiceType: proforma [2026-03-30 21:01:20] [DEBUG] Using org_id: 019bafe2-05ad-7b4a-c449-ebcb1b933597 [2026-03-30 21:01:20] [INFO] Fetched quotation data: {"quotation_id":"8feea1aa-4a01-4db3-9fec-22d8eebadcb3","quotation_number":"00059","date":"2026-03-31","customer_id":"019bd469-55c7-797f-8c3e-94e75563ce82","org_id":"019bafe2-05ad-7b4a-c449-ebcb1b933597","client_id":null,"line_items":"[{\"quantity\": \"15\", \"vat_rate\": \"12.5\", \"line_total\": \"590.63\", \"product_id\": \"019bedb5-d4a9-7f24-9675-32d1a6308c43\", \"unit_price\": \"35\", \"vat_amount\": \"65.63\", \"description\": \"Mahimahi Fillets\", \"line_subtotal\": \"525\"}, {\"quantity\": \"20\", \"vat_rate\": \"12.5\", \"line_total\": \"888.75\", \"product_id\": \"019c8784-b5e3-7ce0-a28f-9c375ac62530\", \"unit_price\": \"39.50\", \"vat_amount\": \"98.75\", \"description\": \"Snapper Fillets\", \"line_subtotal\": \"790\"}]","note":null,"terms":null,"validity_days":30,"status":"draft","total_amount":"0.00","tax_amount":"0.00","template_id":null,"sent_at":null,"expires_at":"2026-04-30","accepted_at":null,"rejected_at":null,"rejection_reason":null,"converted_invoice_id":null,"created_by":null,"updated_by":null,"isdeleted":false,"updatedat":"2026-03-30 21:01:20.543683+00","taxcore_submission_id":null,"taxcore_submission_id_fk":null,"taxcore_receipt_data":null,"taxcore_submitted_at":null,"taxcore_verification_url":null,"taxcore_qr_code":null,"journal_entry_id":null,"converted_to_invoice_id":null,"po_number":"PO 112351","notes_additional":null,"payment_terms_details":null,"quotation_type":"proforma"} [2026-03-30 21:01:20] [DEBUG] STEP 2: Parsing line_items JSON [2026-03-30 21:01:20] [DEBUG] Parsed 2 line items [2026-03-30 21:01:20] [DEBUG] Line items: [{"quantity":"15","vat_rate":"12.5","line_total":"590.63","product_id":"019bedb5-d4a9-7f24-9675-32d1a6308c43","unit_price":"35","vat_amount":"65.63","description":"Mahimahi Fillets","line_subtotal":"525"},{"quantity":"20","vat_rate":"12.5","line_total":"888.75","product_id":"019c8784-b5e3-7ce0-a28f-9c375ac62530","unit_price":"39.50","vat_amount":"98.75","description":"Snapper Fillets","line_subtotal":"790"}] [2026-03-30 21:01:20] [DEBUG] STEP 3: Preparing items for TaxCore [2026-03-30 21:01:20] [DEBUG] Processing line item: 0 -> {"quantity":"15","vat_rate":"12.5","line_total":"590.63","product_id":"019bedb5-d4a9-7f24-9675-32d1a6308c43","unit_price":"35","vat_amount":"65.63","description":"Mahimahi Fillets","line_subtotal":"525"} [2026-03-30 21:01:20] [DEBUG] Calculated - Quantity: 15, UnitPrice: 35, TotalAmount: 525 [2026-03-30 21:01:20] [DEBUG] Processing line item: 1 -> {"quantity":"20","vat_rate":"12.5","line_total":"888.75","product_id":"019c8784-b5e3-7ce0-a28f-9c375ac62530","unit_price":"39.50","vat_amount":"98.75","description":"Snapper Fillets","line_subtotal":"790"} [2026-03-30 21:01:20] [DEBUG] Calculated - Quantity: 20, UnitPrice: 39.5, TotalAmount: 790 [2026-03-30 21:01:20] [DEBUG] Prepared 2 items for TaxCore [2026-03-30 21:01:20] [INFO] TaxCore items: [{"name":"Mahimahi Fillets","quantity":15,"unitPrice":"35.00","totalAmount":"525.00","Labels":["G"]},{"name":"Snapper Fillets","quantity":20,"unitPrice":"39.50","totalAmount":"790.00","Labels":["G"]}] [2026-03-30 21:01:20] [DEBUG] STEP 4: Preparing payment method as Credit [2026-03-30 21:01:20] [INFO] Payment prepared (Credit): [{"paymentType":"0","amount":0}] [2026-03-30 21:01:20] [DEBUG] STEP 5: Fetching cashier information [2026-03-30 21:01:20] [DEBUG] User ID from formData: 019bafe2-05ad-7b4a-c449-ebcb1b933597 [2026-03-30 21:01:20] [DEBUG] Querying users table for user_id: 019bafe2-05ad-7b4a-c449-ebcb1b933597 [2026-03-30 21:01:20] [INFO] Cashier name found: System [2026-03-30 21:01:20] [DEBUG] STEP 6: Building TaxCore payload [2026-03-30 21:01:20] [DEBUG] Base payload created with type=proforma [2026-03-30 21:01:20] [DEBUG] STEP 7: Adding customer/buyer information [2026-03-30 21:01:20] [DEBUG] Customer ID found: 019bd469-55c7-797f-8c3e-94e75563ce82 [2026-03-30 21:01:20] [DEBUG] Customer found: {"name":"Tokoriki Island Resort","tin":"11"} [2026-03-30 21:01:20] [INFO] Buyer TIN added: 11 [2026-03-30 21:01:20] [INFO] TaxCore payload prepared: { "items": [ { "name": "Mahimahi Fillets", "quantity": 15, "unitPrice": "35.00", "totalAmount": "525.00", "Labels": [ "G" ] }, { "name": "Snapper Fillets", "quantity": 20, "unitPrice": "39.50", "totalAmount": "790.00", "Labels": [ "G" ] } ], "payment": [ { "paymentType": "0", "amount": 0 } ], "Cashier": "System", "type": "proforma", "invoiceNumber": "00059", "Buyer": { "Name": "Tokoriki Island Resort" }, "buyerId": "11" } [2026-03-30 21:01:20] [DEBUG] STEP 8: Creating Journal Entry in Finance module [2026-03-30 21:01:20] [INFO] --- createJournalEntry: Starting --- [2026-03-30 21:01:20] [INFO] Is Cancelled/Refund: NO [2026-03-30 21:01:20] [DEBUG] Calculated totals - Subtotal: 1315, Tax: 164.375, Total: 1479.375 [2026-03-30 21:01:20] [DEBUG] Looking for customer-specific AR account for: Tokoriki Island Resort [2026-03-30 21:01:20] [INFO] Found customer-specific AR account: 1300-004 - AR - Tokoriki Island Resort [2026-03-30 21:01:20] [DEBUG] Found GL accounts - Revenue: 4000, Tax: 2410, Receivables: 1300-004 (AR - Tokoriki Island Resort) [2026-03-30 21:01:20] [DEBUG] Journal entry header prepared: {"id":"8289662f-6045-46ae-9803-4664e50ec398","entry_date":"2026-03-31","description":"Quotation 00059","reference":"00059","source_module":"quotations","source_id":"8feea1aa-4a01-4db3-9fec-22d8eebadcb3","total_debits":1479.375,"total_credits":1479.375,"status":"posted","is_balanced":true,"created_by":null,"org_id":null,"posted_at":"2026-03-30 21:01:20","posted_by":null} [2026-03-30 21:01:20] [INFO] Journal entry header created: 8289662f-6045-46ae-9803-4664e50ec398 [2026-03-30 21:01:20] [DEBUG] Prepared 3 journal lines [2026-03-30 21:01:20] [ERROR] ERROR creating journal entry: SQL Error: SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "org_id" of relation "gl_account_balances" violates not-null constraint DETAIL: Failing row contains (019bd469-55d2-7bc1-bad2-882f2b155068, null, 1479.38, 0.00, 1479.38, 2026-03-30 21:01:20.57935+00, 2026-03-31, 1, 2026-03-30 21:01:20.57935+00, 2026-03-30 21:01:20.57935+00, 019d408d-1345-7988-a6ea-3d7987a1a904). CONTEXT: SQL statement "INSERT INTO gl_account_balances ( account_id, org_id, total_debits, total_credits, current_balance, last_updated, last_entry_date, transaction_count, updated_at ) VALUES ( v_account_id, v_org_id, v_total_debits, v_total_credits, v_new_balance, CURRENT_TIMESTAMP, v_last_entry_date, v_transaction_count, CURRENT_TIMESTAMP ) ON CONFLICT (account_id, org_id) DO UPDATE SET total_debits = EXCLUDED.total_debits, total_credits = EXCLUDED.total_credits, current_balance = EXCLUDED.current_balance, last_updated = EXCLUDED.last_updated, last_entry_date = EXCLUDED.last_entry_date, transaction_count = EXCLUDED.transaction_count, updated_at = EXCLUDED.updated_at" PL/pgSQL function update_account_balance() line 49 at SQL statement | Query: INSERT INTO "gl_journal_lines" ("id", "journal_entry_id", "account_id", "memo", "debit", "credit", "org_id") VALUES (?, ?, ?, ?, ?, ?, ?) RETURNING id [2026-03-30 21:01:20] [ERROR] Stack trace: #0 /var/www/POS/api/utils/DB.php(231): Core\DB->runQuery() #1 /var/www/POS/api/utils/QueryBuilder.php(466): Core\DB->insert() #2 /var/www/POS/api/services/QuotationsProcessor.php(720): Core\QueryBuilder->insert() #3 /var/www/POS/api/services/QuotationsProcessor.php(301): App\Services\QuotationsProcessor::createJournalEntry() #4 [internal function]: App\Services\QuotationsProcessor::processQuotationSubmission() #5 /var/www/POS/api/services/workflow_steps/CustomFunctionStep.php(121): call_user_func_array() #6 /var/www/POS/api/services/WorkflowEngine.php(507): App\Services\WorkflowSteps\CustomFunctionStep->execute() #7 /var/www/POS/api/services/WorkflowEngine.php(766): App\Services\WorkflowEngine->executeStep() #8 /var/www/POS/api/services/WorkflowEngine.php(143): App\Services\WorkflowEngine->runSteps() #9 /var/www/POS/api/services/WorkflowEngine.php(176): App\Services\WorkflowEngine->handleEvent() #10 /var/www/POS/api/services/WorkflowEngine.php(188): App\Services\WorkflowEngine->emit() #11 /var/www/POS/api/controllers/GenericController.php(373): App\Services\WorkflowEngine::trigger() #12 /var/www/POS/api/controllers/SyncController.php(202): App\Controllers\GenericController->processWorkflowEvents() #13 /var/www/POS/api/controllers/SyncController.php(214): App\Controllers\GenericController@anonymous->exec() #14 /var/www/POS/api/controllers/SyncController.php(1308): App\Controllers\SyncController->triggerWorkflow() #15 /var/www/POS/api/router.php(226): App\Controllers\SyncController->push() #16 /var/www/POS/api/index.php(32): require_once('...') #17 {main} [2026-03-30 21:01:20] [WARN] WARNING: Journal entry creation failed: SQL Error: SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "org_id" of relation "gl_account_balances" violates not-null constraint DETAIL: Failing row contains (019bd469-55d2-7bc1-bad2-882f2b155068, null, 1479.38, 0.00, 1479.38, 2026-03-30 21:01:20.57935+00, 2026-03-31, 1, 2026-03-30 21:01:20.57935+00, 2026-03-30 21:01:20.57935+00, 019d408d-1345-7988-a6ea-3d7987a1a904). CONTEXT: SQL statement "INSERT INTO gl_account_balances ( account_id, org_id, total_debits, total_credits, current_balance, last_updated, last_entry_date, transaction_count, updated_at ) VALUES ( v_account_id, v_org_id, v_total_debits, v_total_credits, v_new_balance, CURRENT_TIMESTAMP, v_last_entry_date, v_transaction_count, CURRENT_TIMESTAMP ) ON CONFLICT (account_id, org_id) DO UPDATE SET total_debits = EXCLUDED.total_debits, total_credits = EXCLUDED.total_credits, current_balance = EXCLUDED.current_balance, last_updated = EXCLUDED.last_updated, last_entry_date = EXCLUDED.last_entry_date, transaction_count = EXCLUDED.transaction_count, updated_at = EXCLUDED.updated_at" PL/pgSQL function update_account_balance() line 49 at SQL statement | Query: INSERT INTO "gl_journal_lines" ("id", "journal_entry_id", "account_id", "memo", "debit", "credit", "org_id") VALUES (?, ?, ?, ?, ?, ?, ?) RETURNING id [2026-03-30 21:01:20] [DEBUG] STEP 9: Checking if TaxCore integration is enabled [2026-03-30 21:01:20] [DEBUG] Checking TaxCore integration status for org_id: 019bafe2-05ad-7b4a-c449-ebcb1b933597 (table: quotations) [2026-03-30 21:01:20] [INFO] TIN found, TaxCore could be enabled but no explicit setting - defaulting to false for safety [2026-03-30 21:01:20] [INFO] No TaxCore configuration found for org_id: 019bafe2-05ad-7b4a-c449-ebcb1b933597, defaulting to disabled [2026-03-30 21:01:20] [INFO] TaxCore integration enabled: NO [2026-03-30 21:01:20] [INFO] TaxCore integration is disabled - skipping TaxCore submission [2026-03-30 21:01:20] [INFO] TaxCore call completed successfully [2026-03-30 21:01:20] [INFO] TaxCore response: { "skipped": true, "reason": "TaxCore integration disabled for this organization", "invoiceNumber": null } [2026-03-30 21:01:20] [DEBUG] STEP 10: Updating quotations record with TaxCore and Journal Entry details [2026-03-30 21:01:20] [DEBUG] Update data prepared: {"quotation_id":"8feea1aa-4a01-4db3-9fec-22d8eebadcb3"} [2026-03-30 21:01:20] [INFO] Quotations record updated successfully [2026-03-30 21:01:20] [INFO] Skipping sales_receipts insert - TaxCore disabled or submission failed [2026-03-30 21:01:20] [DEBUG] STEP 12: Saving audit file to storage [2026-03-30 21:01:20] [DEBUG] Storage file path: /var/www/POS/storage/quotations/quotation_8feea1aa-4a01-4db3-9fec-22d8eebadcb3_2026-03-30_21-01-20.json [2026-03-30 21:01:20] [INFO] Audit file saved successfully to: /var/www/POS/storage/quotations/quotation_8feea1aa-4a01-4db3-9fec-22d8eebadcb3_2026-03-30_21-01-20.json [2026-03-30 21:01:20] [DEBUG] STEP 13: Preparing final result [2026-03-30 21:01:20] [INFO] ========== SUCCESS: Process completed ========== [2026-03-30 21:01:20] [INFO] Final result: {"success":true,"message":"Quotations processed successfully (TaxCore disabled)","record_id":"8feea1aa-4a01-4db3-9fec-22d8eebadcb3","table":"quotations","invoice_type":"proforma","taxcore_enabled":false,"journal_entry_id":null,"journal_entry_number":null,"taxcore_invoice_number":null,"taxcore_verification_url":null,"taxcore_skipped":true,"processed_at":"2026-03-30 21:01:20","saved_to":"\/var\/www\/POS\/storage\/quotations\/quotation_8feea1aa-4a01-4db3-9fec-22d8eebadcb3_2026-03-30_21-01-20.json","log_file":"\/var\/www\/POS\/storage\/quotations\/logs\/quotation_8feea1aa-4a01-4db3-9fec-22d8eebadcb3_2026-03-30_21-01-20.log"} [2026-03-30 21:01:20] [INFO] =========================================== [2026-03-30 21:01:20] [INFO] Quotations Processor Log [2026-03-30 21:01:20] [INFO] Record ID: 8feea1aa-4a01-4db3-9fec-22d8eebadcb3 [2026-03-30 21:01:20] [INFO] Table: quotations [2026-03-30 21:01:20] [INFO] Timestamp: 2026-03-30 21:01:20 [2026-03-30 21:01:20] [INFO] =========================================== [2026-03-30 21:01:20] [INFO] ========== START: processQuotationSubmission ========== [2026-03-30 21:01:20] [INFO] Function called for record ID: 8feea1aa-4a01-4db3-9fec-22d8eebadcb3 [2026-03-30 21:01:20] [DEBUG] Form data received: {"table":"quotations","tenant_id":"019bafe2-05ad-7b4a-c449-ebcb1b933597"} [2026-03-30 21:01:20] [INFO] Detected table: quotations (Type: proforma) [2026-03-30 21:01:20] [DEBUG] ID field: quotation_id, Number field: quotation_number [2026-03-30 21:01:20] [DEBUG] STEP 1: Fetching quotation data from database [2026-03-30 21:01:20] [DEBUG] QueryBuilder instance created [2026-03-30 21:01:20] [DEBUG] Database query executed for quotation_id: 8feea1aa-4a01-4db3-9fec-22d8eebadcb3 [2026-03-30 21:01:20] [DEBUG] Quotation found successfully [2026-03-30 21:01:20] [INFO] quotation_type from record overrides invoiceType: proforma [2026-03-30 21:01:20] [DEBUG] Using org_id: 019bafe2-05ad-7b4a-c449-ebcb1b933597 [2026-03-30 21:01:20] [INFO] Fetched quotation data: {"quotation_id":"8feea1aa-4a01-4db3-9fec-22d8eebadcb3","quotation_number":"00059","date":"2026-03-31","customer_id":"019bd469-55c7-797f-8c3e-94e75563ce82","org_id":"019bafe2-05ad-7b4a-c449-ebcb1b933597","client_id":null,"line_items":"[{\"quantity\": \"15\", \"vat_rate\": \"12.5\", \"line_total\": \"590.63\", \"product_id\": \"019bedb5-d4a9-7f24-9675-32d1a6308c43\", \"unit_price\": \"35\", \"vat_amount\": \"65.63\", \"description\": \"Mahimahi Fillets\", \"line_subtotal\": \"525\"}, {\"quantity\": \"20\", \"vat_rate\": \"12.5\", \"line_total\": \"888.75\", \"product_id\": \"019c8784-b5e3-7ce0-a28f-9c375ac62530\", \"unit_price\": \"39.50\", \"vat_amount\": \"98.75\", \"description\": \"Snapper Fillets\", \"line_subtotal\": \"790\"}]","note":null,"terms":null,"validity_days":30,"status":"draft","total_amount":"0.00","tax_amount":"0.00","template_id":null,"sent_at":null,"expires_at":"2026-04-30","accepted_at":null,"rejected_at":null,"rejection_reason":null,"converted_invoice_id":null,"created_by":null,"updated_by":null,"isdeleted":false,"updatedat":"2026-03-30 21:01:20.583512+00","taxcore_submission_id":null,"taxcore_submission_id_fk":null,"taxcore_receipt_data":null,"taxcore_submitted_at":null,"taxcore_verification_url":null,"taxcore_qr_code":null,"journal_entry_id":null,"converted_to_invoice_id":null,"po_number":"PO 112351","notes_additional":null,"payment_terms_details":null,"quotation_type":"proforma"} [2026-03-30 21:01:20] [DEBUG] STEP 2: Parsing line_items JSON [2026-03-30 21:01:20] [DEBUG] Parsed 2 line items [2026-03-30 21:01:20] [DEBUG] Line items: [{"quantity":"15","vat_rate":"12.5","line_total":"590.63","product_id":"019bedb5-d4a9-7f24-9675-32d1a6308c43","unit_price":"35","vat_amount":"65.63","description":"Mahimahi Fillets","line_subtotal":"525"},{"quantity":"20","vat_rate":"12.5","line_total":"888.75","product_id":"019c8784-b5e3-7ce0-a28f-9c375ac62530","unit_price":"39.50","vat_amount":"98.75","description":"Snapper Fillets","line_subtotal":"790"}] [2026-03-30 21:01:20] [DEBUG] STEP 3: Preparing items for TaxCore [2026-03-30 21:01:20] [DEBUG] Processing line item: 0 -> {"quantity":"15","vat_rate":"12.5","line_total":"590.63","product_id":"019bedb5-d4a9-7f24-9675-32d1a6308c43","unit_price":"35","vat_amount":"65.63","description":"Mahimahi Fillets","line_subtotal":"525"} [2026-03-30 21:01:20] [DEBUG] Calculated - Quantity: 15, UnitPrice: 35, TotalAmount: 525 [2026-03-30 21:01:20] [DEBUG] Processing line item: 1 -> {"quantity":"20","vat_rate":"12.5","line_total":"888.75","product_id":"019c8784-b5e3-7ce0-a28f-9c375ac62530","unit_price":"39.50","vat_amount":"98.75","description":"Snapper Fillets","line_subtotal":"790"} [2026-03-30 21:01:20] [DEBUG] Calculated - Quantity: 20, UnitPrice: 39.5, TotalAmount: 790 [2026-03-30 21:01:20] [DEBUG] Prepared 2 items for TaxCore [2026-03-30 21:01:20] [INFO] TaxCore items: [{"name":"Mahimahi Fillets","quantity":15,"unitPrice":"35.00","totalAmount":"525.00","Labels":["G"]},{"name":"Snapper Fillets","quantity":20,"unitPrice":"39.50","totalAmount":"790.00","Labels":["G"]}] [2026-03-30 21:01:20] [DEBUG] STEP 4: Preparing payment method as Credit [2026-03-30 21:01:20] [INFO] Payment prepared (Credit): [{"paymentType":"0","amount":0}] [2026-03-30 21:01:20] [DEBUG] STEP 5: Fetching cashier information [2026-03-30 21:01:20] [DEBUG] User ID from formData: 019bafe2-05ad-7b4a-c449-ebcb1b933597 [2026-03-30 21:01:20] [DEBUG] Querying users table for user_id: 019bafe2-05ad-7b4a-c449-ebcb1b933597 [2026-03-30 21:01:20] [INFO] Cashier name found: System [2026-03-30 21:01:20] [DEBUG] STEP 6: Building TaxCore payload [2026-03-30 21:01:20] [DEBUG] Base payload created with type=proforma [2026-03-30 21:01:20] [DEBUG] STEP 7: Adding customer/buyer information [2026-03-30 21:01:20] [DEBUG] Customer ID found: 019bd469-55c7-797f-8c3e-94e75563ce82 [2026-03-30 21:01:20] [DEBUG] Customer found: {"name":"Tokoriki Island Resort","tin":"11"} [2026-03-30 21:01:20] [INFO] Buyer TIN added: 11 [2026-03-30 21:01:20] [INFO] TaxCore payload prepared: { "items": [ { "name": "Mahimahi Fillets", "quantity": 15, "unitPrice": "35.00", "totalAmount": "525.00", "Labels": [ "G" ] }, { "name": "Snapper Fillets", "quantity": 20, "unitPrice": "39.50", "totalAmount": "790.00", "Labels": [ "G" ] } ], "payment": [ { "paymentType": "0", "amount": 0 } ], "Cashier": "System", "type": "proforma", "invoiceNumber": "00059", "Buyer": { "Name": "Tokoriki Island Resort" }, "buyerId": "11" } [2026-03-30 21:01:20] [DEBUG] STEP 8: Creating Journal Entry in Finance module [2026-03-30 21:01:20] [INFO] --- createJournalEntry: Starting --- [2026-03-30 21:01:20] [INFO] Is Cancelled/Refund: NO [2026-03-30 21:01:20] [DEBUG] Calculated totals - Subtotal: 1315, Tax: 164.375, Total: 1479.375 [2026-03-30 21:01:20] [DEBUG] Looking for customer-specific AR account for: Tokoriki Island Resort [2026-03-30 21:01:20] [INFO] Found customer-specific AR account: 1300-004 - AR - Tokoriki Island Resort [2026-03-30 21:01:20] [DEBUG] Found GL accounts - Revenue: 4000, Tax: 2410, Receivables: 1300-004 (AR - Tokoriki Island Resort) [2026-03-30 21:01:20] [DEBUG] Journal entry header prepared: {"id":"04f5e14b-4552-44eb-877e-d6b4ff10f45c","entry_date":"2026-03-31","description":"Quotation 00059","reference":"00059","source_module":"quotations","source_id":"8feea1aa-4a01-4db3-9fec-22d8eebadcb3","total_debits":1479.375,"total_credits":1479.375,"status":"posted","is_balanced":true,"created_by":null,"org_id":null,"posted_at":"2026-03-30 21:01:20","posted_by":null} [2026-03-30 21:01:20] [ERROR] ERROR creating journal entry: SQL Error: SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint "idx_journal_entries_unique_source" DETAIL: Key (source_module, source_id)=(quotations, 8feea1aa-4a01-4db3-9fec-22d8eebadcb3) already exists. | Query: INSERT INTO "gl_journal_entries" ("id", "entry_date", "description", "reference", "source_module", "source_id", "total_debits", "total_credits", "status", "is_balanced", "created_by", "org_id", "posted_at", "posted_by", "branch_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING id [2026-03-30 21:01:20] [ERROR] Stack trace: #0 /var/www/POS/api/utils/DB.php(231): Core\DB->runQuery() #1 /var/www/POS/api/utils/QueryBuilder.php(466): Core\DB->insert() #2 /var/www/POS/api/services/QuotationsProcessor.php(640): Core\QueryBuilder->insert() #3 /var/www/POS/api/services/QuotationsProcessor.php(301): App\Services\QuotationsProcessor::createJournalEntry() #4 [internal function]: App\Services\QuotationsProcessor::processQuotationSubmission() #5 /var/www/POS/api/services/workflow_steps/CustomFunctionStep.php(121): call_user_func_array() #6 /var/www/POS/api/services/WorkflowEngine.php(507): App\Services\WorkflowSteps\CustomFunctionStep->execute() #7 /var/www/POS/api/services/WorkflowEngine.php(766): App\Services\WorkflowEngine->executeStep() #8 /var/www/POS/api/services/WorkflowEngine.php(143): App\Services\WorkflowEngine->runSteps() #9 /var/www/POS/api/services/WorkflowEngine.php(176): App\Services\WorkflowEngine->handleEvent() #10 /var/www/POS/api/services/WorkflowEngine.php(188): App\Services\WorkflowEngine->emit() #11 /var/www/POS/api/controllers/GenericController.php(373): App\Services\WorkflowEngine::trigger() #12 /var/www/POS/api/controllers/SyncController.php(202): App\Controllers\GenericController->processWorkflowEvents() #13 /var/www/POS/api/controllers/SyncController.php(214): App\Controllers\GenericController@anonymous->exec() #14 /var/www/POS/api/controllers/SyncController.php(1308): App\Controllers\SyncController->triggerWorkflow() #15 /var/www/POS/api/router.php(226): App\Controllers\SyncController->push() #16 /var/www/POS/api/index.php(32): require_once('...') #17 {main} [2026-03-30 21:01:20] [WARN] WARNING: Journal entry creation failed: SQL Error: SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint "idx_journal_entries_unique_source" DETAIL: Key (source_module, source_id)=(quotations, 8feea1aa-4a01-4db3-9fec-22d8eebadcb3) already exists. | Query: INSERT INTO "gl_journal_entries" ("id", "entry_date", "description", "reference", "source_module", "source_id", "total_debits", "total_credits", "status", "is_balanced", "created_by", "org_id", "posted_at", "posted_by", "branch_id") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING id [2026-03-30 21:01:20] [DEBUG] STEP 9: Checking if TaxCore integration is enabled [2026-03-30 21:01:20] [DEBUG] Checking TaxCore integration status for org_id: 019bafe2-05ad-7b4a-c449-ebcb1b933597 (table: quotations) [2026-03-30 21:01:20] [INFO] TIN found, TaxCore could be enabled but no explicit setting - defaulting to false for safety [2026-03-30 21:01:20] [INFO] No TaxCore configuration found for org_id: 019bafe2-05ad-7b4a-c449-ebcb1b933597, defaulting to disabled [2026-03-30 21:01:20] [INFO] TaxCore integration enabled: NO [2026-03-30 21:01:20] [INFO] TaxCore integration is disabled - skipping TaxCore submission [2026-03-30 21:01:20] [INFO] TaxCore call completed successfully [2026-03-30 21:01:20] [INFO] TaxCore response: { "skipped": true, "reason": "TaxCore integration disabled for this organization", "invoiceNumber": null } [2026-03-30 21:01:20] [DEBUG] STEP 10: Updating quotations record with TaxCore and Journal Entry details [2026-03-30 21:01:20] [DEBUG] Update data prepared: {"quotation_id":"8feea1aa-4a01-4db3-9fec-22d8eebadcb3"} [2026-03-30 21:01:20] [INFO] Quotations record updated successfully [2026-03-30 21:01:20] [INFO] Skipping sales_receipts insert - TaxCore disabled or submission failed [2026-03-30 21:01:20] [DEBUG] STEP 12: Saving audit file to storage [2026-03-30 21:01:20] [DEBUG] Storage file path: /var/www/POS/storage/quotations/quotation_8feea1aa-4a01-4db3-9fec-22d8eebadcb3_2026-03-30_21-01-20.json [2026-03-30 21:01:20] [INFO] Audit file saved successfully to: /var/www/POS/storage/quotations/quotation_8feea1aa-4a01-4db3-9fec-22d8eebadcb3_2026-03-30_21-01-20.json [2026-03-30 21:01:20] [DEBUG] STEP 13: Preparing final result [2026-03-30 21:01:20] [INFO] ========== SUCCESS: Process completed ========== [2026-03-30 21:01:20] [INFO] Final result: {"success":true,"message":"Quotations processed successfully (TaxCore disabled)","record_id":"8feea1aa-4a01-4db3-9fec-22d8eebadcb3","table":"quotations","invoice_type":"proforma","taxcore_enabled":false,"journal_entry_id":null,"journal_entry_number":null,"taxcore_invoice_number":null,"taxcore_verification_url":null,"taxcore_skipped":true,"processed_at":"2026-03-30 21:01:20","saved_to":"\/var\/www\/POS\/storage\/quotations\/quotation_8feea1aa-4a01-4db3-9fec-22d8eebadcb3_2026-03-30_21-01-20.json","log_file":"\/var\/www\/POS\/storage\/quotations\/logs\/quotation_8feea1aa-4a01-4db3-9fec-22d8eebadcb3_2026-03-30_21-01-20.log"}