[2026-05-11 02:58:22] [INFO] =========================================== [2026-05-11 02:58:22] [INFO] Quotations Processor Log [2026-05-11 02:58:22] [INFO] Record ID: 000019e1-4f8a-7f87-b895-b486ae9a234a [2026-05-11 02:58:22] [INFO] Table: quotations [2026-05-11 02:58:22] [INFO] Timestamp: 2026-05-11 02:58:22 [2026-05-11 02:58:22] [INFO] =========================================== [2026-05-11 02:58:22] [INFO] ========== START: processQuotationSubmission ========== [2026-05-11 02:58:22] [INFO] Function called for record ID: 000019e1-4f8a-7f87-b895-b486ae9a234a [2026-05-11 02:58:22] [DEBUG] Form data received: {"table":"quotations","tenant_id":"019bb55f-3772-727b-fc11-047156c4c5a4"} [2026-05-11 02:58:22] [INFO] Detected table: quotations (Type: proforma) [2026-05-11 02:58:22] [DEBUG] ID field: quotation_id, Number field: quotation_number [2026-05-11 02:58:22] [DEBUG] STEP 1: Fetching quotation data from database [2026-05-11 02:58:22] [DEBUG] QueryBuilder instance created [2026-05-11 02:58:22] [DEBUG] Database query executed for quotation_id: 000019e1-4f8a-7f87-b895-b486ae9a234a [2026-05-11 02:58:22] [DEBUG] Quotation found successfully [2026-05-11 02:58:22] [INFO] quotation_type from record overrides invoiceType: proforma [2026-05-11 02:58:22] [DEBUG] Using org_id: 019bb55f-3772-727b-fc11-047156c4c5a4 [2026-05-11 02:58:22] [INFO] Fetched quotation data: {"quotation_id":"000019e1-4f8a-7f87-b895-b486ae9a234a","quotation_number":"00008","date":"2026-05-11","customer_id":"000019e1-4f17-7c8d-dc1a-9c29e64aaa76","org_id":"019bb55f-3772-727b-fc11-047156c4c5a4","client_id":null,"line_items":"{\"row_0\": {\"quantity\": \"1\", \"vat_rate\": \"VIP\", \"line_total\": \"2999\", \"product_id\": \"000019da-055a-73cb-6463-84d5a689561e\", \"unit_price\": \"2999.00\", \"vat_amount\": \"333.22\", \"description\": \"SDL-829S POS Machine\", \"line_subtotal\": \"2999\"}, \"row_1\": {\"quantity\": \"1\", \"vat_rate\": \"VIP\", \"line_total\": \"0\", \"product_id\": \"000019d3-e477-7424-c66c-a2256568e523\", \"unit_price\": \"0.00\", \"vat_amount\": \"0\", \"description\": \"Cash Drawer ECD-410H\", \"line_subtotal\": \"0\"}, \"row_2\": {\"quantity\": \"1\", \"vat_rate\": \"VIP\", \"line_total\": \"0\", \"product_id\": \"000019d1-4a75-7f0e-8f8f-9a1f75df9b7f\", \"unit_price\": \"0.00\", \"vat_amount\": \"0\", \"description\": \"Thermal printer\", \"line_subtotal\": \"0\"}, \"row_3\": {\"quantity\": \"1\", \"vat_rate\": \"VIP\", \"line_total\": \"0\", \"product_id\": \"000019d3-e469-7058-3c45-268ec4abe4ea\", \"unit_price\": \"0.00\", \"vat_amount\": \"0\", \"description\": \"Handheld barcode scanner\", \"line_subtotal\": \"0\"}, \"row_4\": {\"quantity\": \"1\", \"vat_rate\": \"VIP\", \"line_total\": \"600\", \"product_id\": \"000019d6-ccb9-7eda-9d07-a84b7bf64782\", \"unit_price\": \"600.00\", \"vat_amount\": \"66.67\", \"description\": \"Yearly cloud hosting and support for Cybex ERP\", \"line_subtotal\": \"600\"}}","note":null,"terms":null,"validity_days":30,"status":"expired","total_amount":"3599.00","tax_amount":"399.89","template_id":null,"sent_at":null,"expires_at":"2026-05-11","accepted_at":null,"rejected_at":null,"rejection_reason":null,"converted_invoice_id":null,"created_by":null,"updated_by":null,"isdeleted":false,"updatedat":"2026-05-11 02:58:22.961877+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":null,"notes_additional":null,"payment_terms_details":null,"quotation_type":"proforma"} [2026-05-11 02:58:22] [DEBUG] STEP 2: Parsing line_items JSON [2026-05-11 02:58:22] [DEBUG] Parsed 5 line items [2026-05-11 02:58:22] [DEBUG] Line items: {"row_0":{"quantity":"1","vat_rate":"VIP","line_total":"2999","product_id":"000019da-055a-73cb-6463-84d5a689561e","unit_price":"2999.00","vat_amount":"333.22","description":"SDL-829S POS Machine","line_subtotal":"2999"},"row_1":{"quantity":"1","vat_rate":"VIP","line_total":"0","product_id":"000019d3-e477-7424-c66c-a2256568e523","unit_price":"0.00","vat_amount":"0","description":"Cash Drawer ECD-410H","line_subtotal":"0"},"row_2":{"quantity":"1","vat_rate":"VIP","line_total":"0","product_id":"000019d1-4a75-7f0e-8f8f-9a1f75df9b7f","unit_price":"0.00","vat_amount":"0","description":"Thermal printer","line_subtotal":"0"},"row_3":{"quantity":"1","vat_rate":"VIP","line_total":"0","product_id":"000019d3-e469-7058-3c45-268ec4abe4ea","unit_price":"0.00","vat_amount":"0","description":"Handheld barcode scanner","line_subtotal":"0"},"row_4":{"quantity":"1","vat_rate":"VIP","line_total":"600","product_id":"000019d6-ccb9-7eda-9d07-a84b7bf64782","unit_price":"600.00","vat_amount":"66.67","description":"Yearly cloud hosting and support for Cybex ERP","line_subtotal":"600"}} [2026-05-11 02:58:22] [DEBUG] STEP 3: Preparing items for TaxCore [2026-05-11 02:58:22] [DEBUG] Processing line item: row_0 -> {"quantity":"1","vat_rate":"VIP","line_total":"2999","product_id":"000019da-055a-73cb-6463-84d5a689561e","unit_price":"2999.00","vat_amount":"333.22","description":"SDL-829S POS Machine","line_subtotal":"2999"} [2026-05-11 02:58:22] [DEBUG] Calculated - Quantity: 1, UnitPrice: 2999, TotalAmount: 2999 [2026-05-11 02:58:22] [DEBUG] Processing line item: row_1 -> {"quantity":"1","vat_rate":"VIP","line_total":"0","product_id":"000019d3-e477-7424-c66c-a2256568e523","unit_price":"0.00","vat_amount":"0","description":"Cash Drawer ECD-410H","line_subtotal":"0"} [2026-05-11 02:58:22] [DEBUG] Calculated - Quantity: 1, UnitPrice: 0, TotalAmount: 0 [2026-05-11 02:58:22] [DEBUG] Processing line item: row_2 -> {"quantity":"1","vat_rate":"VIP","line_total":"0","product_id":"000019d1-4a75-7f0e-8f8f-9a1f75df9b7f","unit_price":"0.00","vat_amount":"0","description":"Thermal printer","line_subtotal":"0"} [2026-05-11 02:58:22] [DEBUG] Calculated - Quantity: 1, UnitPrice: 0, TotalAmount: 0 [2026-05-11 02:58:22] [DEBUG] Processing line item: row_3 -> {"quantity":"1","vat_rate":"VIP","line_total":"0","product_id":"000019d3-e469-7058-3c45-268ec4abe4ea","unit_price":"0.00","vat_amount":"0","description":"Handheld barcode scanner","line_subtotal":"0"} [2026-05-11 02:58:22] [DEBUG] Calculated - Quantity: 1, UnitPrice: 0, TotalAmount: 0 [2026-05-11 02:58:22] [DEBUG] Processing line item: row_4 -> {"quantity":"1","vat_rate":"VIP","line_total":"600","product_id":"000019d6-ccb9-7eda-9d07-a84b7bf64782","unit_price":"600.00","vat_amount":"66.67","description":"Yearly cloud hosting and support for Cybex ERP","line_subtotal":"600"} [2026-05-11 02:58:22] [DEBUG] Calculated - Quantity: 1, UnitPrice: 600, TotalAmount: 600 [2026-05-11 02:58:22] [DEBUG] Prepared 5 items for TaxCore [2026-05-11 02:58:22] [INFO] TaxCore items: [{"name":"SDL-829S POS Machine","quantity":1,"unitPrice":"2999.00","totalAmount":"2999.00","Labels":["G"]},{"name":"Cash Drawer ECD-410H","quantity":1,"unitPrice":"0.00","totalAmount":"0.00","Labels":["G"]},{"name":"Thermal printer","quantity":1,"unitPrice":"0.00","totalAmount":"0.00","Labels":["G"]},{"name":"Handheld barcode scanner","quantity":1,"unitPrice":"0.00","totalAmount":"0.00","Labels":["G"]},{"name":"Yearly cloud hosting and support for Cybex ERP","quantity":1,"unitPrice":"600.00","totalAmount":"600.00","Labels":["G"]}] [2026-05-11 02:58:22] [DEBUG] STEP 4: Preparing payment method as Credit [2026-05-11 02:58:22] [INFO] Payment prepared (Credit): [{"paymentType":"0","amount":3599}] [2026-05-11 02:58:22] [DEBUG] STEP 5: Fetching cashier information [2026-05-11 02:58:22] [DEBUG] User ID from formData: 019bb55f-3772-727b-fc11-047156c4c5a4 [2026-05-11 02:58:22] [DEBUG] Querying users table for user_id: 019bb55f-3772-727b-fc11-047156c4c5a4 [2026-05-11 02:58:22] [INFO] Cashier name found: System [2026-05-11 02:58:22] [DEBUG] STEP 6: Building TaxCore payload [2026-05-11 02:58:22] [DEBUG] Base payload created with type=proforma [2026-05-11 02:58:22] [DEBUG] STEP 7: Adding customer/buyer information [2026-05-11 02:58:22] [DEBUG] Customer ID found: 000019e1-4f17-7c8d-dc1a-9c29e64aaa76 [2026-05-11 02:58:22] [DEBUG] Customer found: {"name":"Lyz proprietary pte ltd","tin":"501640707"} [2026-05-11 02:58:22] [INFO] Buyer TIN added: 501640707 [2026-05-11 02:58:22] [INFO] TaxCore payload prepared: { "items": [ { "name": "SDL-829S POS Machine", "quantity": 1, "unitPrice": "2999.00", "totalAmount": "2999.00", "Labels": [ "G" ] }, { "name": "Cash Drawer ECD-410H", "quantity": 1, "unitPrice": "0.00", "totalAmount": "0.00", "Labels": [ "G" ] }, { "name": "Thermal printer", "quantity": 1, "unitPrice": "0.00", "totalAmount": "0.00", "Labels": [ "G" ] }, { "name": "Handheld barcode scanner", "quantity": 1, "unitPrice": "0.00", "totalAmount": "0.00", "Labels": [ "G" ] }, { "name": "Yearly cloud hosting and support for Cybex ERP", "quantity": 1, "unitPrice": "600.00", "totalAmount": "600.00", "Labels": [ "G" ] } ], "payment": [ { "paymentType": "0", "amount": 3599 } ], "Cashier": "System", "type": "proforma", "invoiceNumber": "00008", "Buyer": { "Name": "Lyz proprietary pte ltd" }, "buyerId": "501640707" } [2026-05-11 02:58:22] [DEBUG] STEP 8: Creating Journal Entry in Finance module [2026-05-11 02:58:22] [INFO] --- createJournalEntry: Starting --- [2026-05-11 02:58:22] [INFO] Is Cancelled/Refund: NO [2026-05-11 02:58:22] [DEBUG] Calculated totals - Subtotal: 3599, Tax: 449.875, Total: 4048.875 [2026-05-11 02:58:22] [DEBUG] Looking for customer-specific AR account for: Lyz proprietary pte ltd [2026-05-11 02:58:22] [INFO] Found customer-specific AR account: 1300-066 - AR - Lyz proprietary pte ltd [2026-05-11 02:58:22] [DEBUG] Found GL accounts - Revenue: 4000, Tax: 2410, Receivables: 1300-066 (AR - Lyz proprietary pte ltd) [2026-05-11 02:58:22] [ERROR] ERROR creating journal entry: Undefined variable $orgId [2026-05-11 02:58:22] [ERROR] Stack trace: #0 /var/www/POS/api/services/QuotationsProcessor.php(632): {closure}() #1 /var/www/POS/api/services/QuotationsProcessor.php(301): App\Services\QuotationsProcessor::createJournalEntry() #2 [internal function]: App\Services\QuotationsProcessor::processQuotationSubmission() #3 /var/www/POS/api/services/workflow_steps/CustomFunctionStep.php(121): call_user_func_array() #4 /var/www/POS/api/services/WorkflowEngine.php(508): App\Services\WorkflowSteps\CustomFunctionStep->execute() #5 /var/www/POS/api/services/WorkflowEngine.php(767): App\Services\WorkflowEngine->executeStep() #6 /var/www/POS/api/services/WorkflowEngine.php(144): App\Services\WorkflowEngine->runSteps() #7 /var/www/POS/api/services/WorkflowEngine.php(177): App\Services\WorkflowEngine->handleEvent() #8 /var/www/POS/api/services/WorkflowEngine.php(189): App\Services\WorkflowEngine->emit() #9 /var/www/POS/api/controllers/GenericController.php(373): App\Services\WorkflowEngine::trigger() #10 /var/www/POS/api/controllers/SyncController.php(202): App\Controllers\GenericController->processWorkflowEvents() #11 /var/www/POS/api/controllers/SyncController.php(214): App\Controllers\GenericController@anonymous->exec() #12 /var/www/POS/api/controllers/SyncController.php(1321): App\Controllers\SyncController->triggerWorkflow() #13 /var/www/POS/api/router.php(272): App\Controllers\SyncController->push() #14 /var/www/POS/api/index.php(32): require_once('...') #15 {main} [2026-05-11 02:58:22] [WARN] WARNING: Journal entry creation failed: Undefined variable $orgId [2026-05-11 02:58:22] [DEBUG] STEP 9: Checking if TaxCore integration is enabled [2026-05-11 02:58:22] [DEBUG] Checking TaxCore integration status for org_id: 019bb55f-3772-727b-fc11-047156c4c5a4 (table: quotations) [2026-05-11 02:58:22] [INFO] Found quotation_taxcore_enabled in orgs.settings: false [2026-05-11 02:58:22] [INFO] TaxCore integration enabled: NO [2026-05-11 02:58:22] [INFO] TaxCore integration is disabled - skipping TaxCore submission [2026-05-11 02:58:22] [INFO] TaxCore call completed successfully [2026-05-11 02:58:22] [INFO] TaxCore response: { "skipped": true, "reason": "TaxCore integration disabled for this organization", "invoiceNumber": null } [2026-05-11 02:58:22] [DEBUG] STEP 10: Updating quotations record with TaxCore and Journal Entry details [2026-05-11 02:58:22] [DEBUG] Update data prepared: {"quotation_id":"000019e1-4f8a-7f87-b895-b486ae9a234a"} [2026-05-11 02:58:23] [INFO] Quotations record updated successfully [2026-05-11 02:58:23] [INFO] Skipping sales_receipts insert - TaxCore disabled or submission failed [2026-05-11 02:58:23] [DEBUG] STEP 12: Saving audit file to storage [2026-05-11 02:58:23] [DEBUG] Storage file path: /var/www/POS/storage/quotations/quotation_000019e1-4f8a-7f87-b895-b486ae9a234a_2026-05-11_02-58-23.json [2026-05-11 02:58:23] [INFO] Audit file saved successfully to: /var/www/POS/storage/quotations/quotation_000019e1-4f8a-7f87-b895-b486ae9a234a_2026-05-11_02-58-23.json [2026-05-11 02:58:23] [DEBUG] STEP 13: Preparing final result [2026-05-11 02:58:23] [INFO] ========== SUCCESS: Process completed ========== [2026-05-11 02:58:23] [INFO] Final result: {"success":true,"message":"Quotations processed successfully (TaxCore disabled)","record_id":"000019e1-4f8a-7f87-b895-b486ae9a234a","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-05-11 02:58:23","saved_to":"\/var\/www\/POS\/storage\/quotations\/quotation_000019e1-4f8a-7f87-b895-b486ae9a234a_2026-05-11_02-58-23.json","log_file":"\/var\/www\/POS\/storage\/quotations\/logs\/quotation_000019e1-4f8a-7f87-b895-b486ae9a234a_2026-05-11_02-58-22.log"}