[2026-09-03 15:59:38] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-02","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":null} [2026-09-03 15:59:38] live.INFO: Opening stock calculation - including all transactions {"date":"2026-09-02"} [2026-09-03 15:59:38] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-09-02')"} [2026-09-03 15:59:38] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-02') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-09-02'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 15:59:38] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147619325.83960000","is_opening":true,"date":"2026-09-02"} [2026-09-03 15:59:38] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":null} [2026-09-03 15:59:38] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 15:59:38] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 15:59:38] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147619325.83960000","is_opening":false,"date":"2026-09-03"} [2026-09-03 15:59:45] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2025-12-31","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 15:59:45] live.INFO: Opening stock calculation - including all transactions {"date":"2025-12-31"} [2026-09-03 15:59:45] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2025-12-31')"} [2026-09-03 15:59:45] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2025-12-31') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2025-12-31'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 15:59:45] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"58869373.22080000","is_opening":true,"date":"2025-12-31"} [2026-09-03 15:59:45] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-12-31","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 15:59:45] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-12-31' (includes all types except purchase_order)"} [2026-09-03 15:59:45] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-12-31') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-12-31'","bindings":["purchase_order",8]} [2026-09-03 15:59:45] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147619325.83960000","is_opening":false,"date":"2026-12-31"} [2026-09-03 15:59:47] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2025-12-31","location_id":null,"is_opening":true,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 15:59:47] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 15:59:47] live.INFO: Opening stock calculation - including all transactions {"date":"2025-12-31"} [2026-09-03 15:59:47] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2025-12-31')"} [2026-09-03 15:59:47] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2025-12-31') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2025-12-31'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 15:59:47] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"79279760.00000000","is_opening":true,"date":"2025-12-31"} [2026-09-03 15:59:47] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-12-31","location_id":null,"is_opening":false,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 15:59:47] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 15:59:47] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-12-31' (includes all types except purchase_order)"} [2026-09-03 15:59:47] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-12-31') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-12-31'","bindings":["purchase_order",8]} [2026-09-03 15:59:47] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149109333.00000000","is_opening":false,"date":"2026-12-31"} [2026-09-03 16:00:10] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-08-27","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:00:10] live.INFO: Opening stock calculation - including all transactions {"date":"2026-08-27"} [2026-09-03 16:00:10] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-08-27')"} [2026-09-03 16:00:10] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-08-27') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-08-27'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:00:10] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147090575.23960000","is_opening":true,"date":"2026-08-27"} [2026-09-03 16:00:10] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:00:10] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:00:10] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:00:10] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147619325.83960000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:00:10] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-08-27","location_id":null,"is_opening":true,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:00:10] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:00:10] live.INFO: Opening stock calculation - including all transactions {"date":"2026-08-27"} [2026-09-03 16:00:10] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-08-27')"} [2026-09-03 16:00:10] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-08-27') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-08-27'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:00:10] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149070733.00000000","is_opening":true,"date":"2026-08-27"} [2026-09-03 16:00:10] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:00:10] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:00:10] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:00:10] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:00:10] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149109333.00000000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:00:46] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2025-08-31","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:00:46] live.INFO: Opening stock calculation - including all transactions {"date":"2025-08-31"} [2026-09-03 16:00:46] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2025-08-31')"} [2026-09-03 16:00:46] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2025-08-31') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2025-08-31'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:00:46] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"58869373.22080000","is_opening":true,"date":"2025-08-31"} [2026-09-03 16:00:46] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2025-09-30","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:00:46] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2025-09-30' (includes all types except purchase_order)"} [2026-09-03 16:00:46] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2025-09-30') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2025-09-30'","bindings":["purchase_order",8]} [2026-09-03 16:00:46] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":0,"is_opening":false,"date":"2025-09-30"} [2026-09-03 16:00:46] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2025-08-31","location_id":null,"is_opening":true,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:00:46] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:00:46] live.INFO: Opening stock calculation - including all transactions {"date":"2025-08-31"} [2026-09-03 16:00:46] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2025-08-31')"} [2026-09-03 16:00:46] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2025-08-31') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2025-08-31'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:00:46] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"79279760.00000000","is_opening":true,"date":"2025-08-31"} [2026-09-03 16:00:46] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2025-09-30","location_id":null,"is_opening":false,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:00:46] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:00:46] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2025-09-30' (includes all types except purchase_order)"} [2026-09-03 16:00:46] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2025-09-30') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2025-09-30'","bindings":["purchase_order",8]} [2026-09-03 16:00:46] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":0,"is_opening":false,"date":"2025-09-30"} [2026-09-03 16:01:01] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-08-27","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:01:01] live.INFO: Opening stock calculation - including all transactions {"date":"2026-08-27"} [2026-09-03 16:01:01] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-08-27')"} [2026-09-03 16:01:01] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-08-27') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-08-27'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:01:01] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147090575.23960000","is_opening":true,"date":"2026-08-27"} [2026-09-03 16:01:01] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:01:01] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:01:01] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:01:01] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147619325.83960000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:01:02] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-08-27","location_id":null,"is_opening":true,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:01:02] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:01:02] live.INFO: Opening stock calculation - including all transactions {"date":"2026-08-27"} [2026-09-03 16:01:02] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-08-27')"} [2026-09-03 16:01:02] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-08-27') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-08-27'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:01:02] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149070733.00000000","is_opening":true,"date":"2026-08-27"} [2026-09-03 16:01:02] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:01:02] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:01:02] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:01:02] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:01:02] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149109333.00000000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:04:37] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-02","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:04:37] live.INFO: Opening stock calculation - including all transactions {"date":"2026-09-02"} [2026-09-03 16:04:37] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-09-02')"} [2026-09-03 16:04:37] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-02') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-09-02'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:04:37] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147619325.83960000","is_opening":true,"date":"2026-09-02"} [2026-09-03 16:04:37] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:04:37] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:04:37] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:04:37] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147619325.83960000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:04:37] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-02","location_id":null,"is_opening":true,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:04:37] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:04:37] live.INFO: Opening stock calculation - including all transactions {"date":"2026-09-02"} [2026-09-03 16:04:37] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-09-02')"} [2026-09-03 16:04:37] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-02') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-09-02'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:04:37] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149109333.00000000","is_opening":true,"date":"2026-09-02"} [2026-09-03 16:04:37] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:04:37] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:04:37] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:04:37] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:04:37] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149109333.00000000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:05:40] live.ERROR: Failed to send error alert email: Failed to authenticate on SMTP server with username "support@risetsystems.com" using the following authenticators: "LOGIN", "PLAIN". Authenticator "LOGIN" returned "Expected response code "235" but got code "535", with message "535 Incorrect authentication data".". Authenticator "PLAIN" returned "Expected response code "235" but got code "535", with message "535 Incorrect authentication data".". [2026-09-03 16:06:14] live.INFO: Purchases array from request {"purchases":[{"product_id":"201","variation_id":"206","quantity":"100","product_unit_id":"1","sub_unit_id":"1","pp_without_discount":"56.00","discount_percent":"0.00","purchase_price":"56.00","purchase_line_tax_id":null,"item_tax":"0.00","purchase_price_inc_tax":"56.00","profit_percent":"19.64","default_sell_price":"67.00","lot_number":null,"mfg_date":null,"exp_date":null,"imei_numbers":"[]","imei_count":"0"}],"purchases_json":"[{\"product_id\":\"201\",\"variation_id\":\"206\",\"quantity\":\"100\",\"product_unit_id\":\"1\",\"sub_unit_id\":\"1\",\"pp_without_discount\":\"56.00\",\"discount_percent\":\"0.00\",\"purchase_price\":\"56.00\",\"purchase_line_tax_id\":null,\"item_tax\":\"0.00\",\"purchase_price_inc_tax\":\"56.00\",\"profit_percent\":\"19.64\",\"default_sell_price\":\"67.00\",\"lot_number\":null,\"mfg_date\":null,\"exp_date\":null,\"imei_numbers\":\"[]\",\"imei_count\":\"0\"}]"} [2026-09-03 16:06:14] live.WARNING: Digitax stock update skipped: Missing item_id for product_id 201 [2026-09-03 16:06:14] live.INFO: Purchase lines created {"transaction_id":1789,"purchase_lines_count":1,"purchase_lines":[{"id":1565,"transaction_id":1789,"product_id":201,"variation_id":206,"quantity":100.0,"secondary_unit_quantity":"0.0000","pp_without_discount":"56.0000","discount_percent":"0.00","purchase_price":"56.0000","purchase_price_inc_tax":"56.0000","item_tax":"0.0000","tax_id":null,"purchase_requisition_line_id":null,"purchase_order_line_id":null,"quantity_sold":"0.0000","quantity_adjusted":"0.0000","quantity_returned":"0.0000","po_quantity_purchased":"0.0000","mfg_quantity_used":"0.0000","mfg_date":null,"exp_date":null,"lot_number":null,"sub_unit_id":null,"created_at":"2026-09-03T13:06:14.000000Z","updated_at":"2026-09-03T13:06:14.000000Z"}]} [2026-09-03 16:06:14] live.INFO: Processing purchase row - 0 {"row_index":0,"product_id":"201","variation_id":"206","quantity":"100","has_imei":true,"imei_raw":"[]","purchase_data_keys":["product_id","variation_id","quantity","product_unit_id","sub_unit_id","pp_without_discount","discount_percent","purchase_price","purchase_line_tax_id","item_tax","purchase_price_inc_tax","profit_percent","default_sell_price","lot_number","mfg_date","exp_date","imei_numbers","imei_count"]} [2026-09-03 16:06:14] live.INFO: IMEI Data - Parsed for row 0 {"row_index":0,"imei_count":0,"imei_data":[],"imei_json":"[]"} [2026-09-03 16:06:14] live.INFO: IMEI data is empty or invalid for row 0 {"imeiData":[]} [2026-09-03 16:06:14] live.INFO: M-Pesa sale evaluation {"is_mpesa_sale_raw":false,"is_valid_mpesa_sale":false,"payment_method_input":"cash","mpesa_transaction_id":null,"transaction_id":1789} [2026-09-03 16:06:14] live.INFO: Purchase created successfully with IMEI data {"transaction_id":1789,"ref_no":"PO2026/0191","final_total":5600.0} [2026-09-03 16:06:23] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2025-12-31","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:06:23] live.INFO: Opening stock calculation - including all transactions {"date":"2025-12-31"} [2026-09-03 16:06:23] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2025-12-31')"} [2026-09-03 16:06:23] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2025-12-31') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2025-12-31'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:06:23] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"58869373.22080000","is_opening":true,"date":"2025-12-31"} [2026-09-03 16:06:23] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-12-31","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:06:23] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-12-31' (includes all types except purchase_order)"} [2026-09-03 16:06:23] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-12-31') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-12-31'","bindings":["purchase_order",8]} [2026-09-03 16:06:23] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147624925.83960000","is_opening":false,"date":"2026-12-31"} [2026-09-03 16:06:24] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2025-12-31","location_id":null,"is_opening":true,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:06:24] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:06:24] live.INFO: Opening stock calculation - including all transactions {"date":"2025-12-31"} [2026-09-03 16:06:24] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2025-12-31')"} [2026-09-03 16:06:24] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2025-12-31') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2025-12-31'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:06:24] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"79279760.00000000","is_opening":true,"date":"2025-12-31"} [2026-09-03 16:06:24] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-12-31","location_id":null,"is_opening":false,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:06:24] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:06:24] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-12-31' (includes all types except purchase_order)"} [2026-09-03 16:06:24] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-12-31') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-12-31'","bindings":["purchase_order",8]} [2026-09-03 16:06:24] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149116033.00000000","is_opening":false,"date":"2026-12-31"} [2026-09-03 16:06:28] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-02","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:06:28] live.INFO: Opening stock calculation - including all transactions {"date":"2026-09-02"} [2026-09-03 16:06:28] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-09-02')"} [2026-09-03 16:06:28] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-02') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-09-02'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:06:28] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147619325.83960000","is_opening":true,"date":"2026-09-02"} [2026-09-03 16:06:28] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:06:28] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:06:28] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:06:28] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147624925.83960000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:06:29] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-02","location_id":null,"is_opening":true,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:06:29] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:06:29] live.INFO: Opening stock calculation - including all transactions {"date":"2026-09-02"} [2026-09-03 16:06:29] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-09-02')"} [2026-09-03 16:06:29] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-02') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-09-02'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:06:29] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149109333.00000000","is_opening":true,"date":"2026-09-02"} [2026-09-03 16:06:29] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:06:29] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:06:29] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:06:29] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:06:29] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149116033.00000000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:07:32] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-08-27","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:07:32] live.INFO: Opening stock calculation - including all transactions {"date":"2026-08-27"} [2026-09-03 16:07:32] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-08-27')"} [2026-09-03 16:07:32] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-08-27') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-08-27'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:07:32] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147090575.23960000","is_opening":true,"date":"2026-08-27"} [2026-09-03 16:07:32] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:07:32] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:07:32] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:07:32] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147624925.83960000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:07:32] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-08-27","location_id":null,"is_opening":true,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:07:32] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:07:32] live.INFO: Opening stock calculation - including all transactions {"date":"2026-08-27"} [2026-09-03 16:07:32] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-08-27')"} [2026-09-03 16:07:32] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-08-27') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-08-27'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:07:32] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149070733.00000000","is_opening":true,"date":"2026-08-27"} [2026-09-03 16:07:32] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:07:32] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:07:32] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:07:32] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:07:32] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149116033.00000000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:07:51] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-02","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:07:51] live.INFO: Opening stock calculation - including all transactions {"date":"2026-09-02"} [2026-09-03 16:07:51] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-09-02')"} [2026-09-03 16:07:51] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-02') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-09-02'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:07:51] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147619325.83960000","is_opening":true,"date":"2026-09-02"} [2026-09-03 16:07:51] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:07:51] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:07:51] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:07:51] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147624925.83960000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:07:52] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-02","location_id":null,"is_opening":true,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:07:52] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:07:52] live.INFO: Opening stock calculation - including all transactions {"date":"2026-09-02"} [2026-09-03 16:07:52] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-09-02')"} [2026-09-03 16:07:52] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-02') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-09-02'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:07:52] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149109333.00000000","is_opening":true,"date":"2026-09-02"} [2026-09-03 16:07:52] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:07:52] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:07:52] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:07:52] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:07:52] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149116033.00000000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:08:01] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-08-27","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:08:01] live.INFO: Opening stock calculation - including all transactions {"date":"2026-08-27"} [2026-09-03 16:08:01] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-08-27')"} [2026-09-03 16:08:01] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-08-27') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-08-27'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:08:01] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147090575.23960000","is_opening":true,"date":"2026-08-27"} [2026-09-03 16:08:01] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:08:01] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:08:01] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:08:01] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147624925.83960000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:08:02] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-08-27","location_id":null,"is_opening":true,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:08:02] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:08:02] live.INFO: Opening stock calculation - including all transactions {"date":"2026-08-27"} [2026-09-03 16:08:02] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-08-27')"} [2026-09-03 16:08:02] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-08-27') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-08-27'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:08:02] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149070733.00000000","is_opening":true,"date":"2026-08-27"} [2026-09-03 16:08:02] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:08:02] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:08:02] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:08:02] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:08:02] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149116033.00000000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:11:16] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-02","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:11:16] live.INFO: Opening stock calculation - including all transactions {"date":"2026-09-02"} [2026-09-03 16:11:16] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-09-02')"} [2026-09-03 16:11:16] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-02') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-09-02'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:11:16] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147619325.83960000","is_opening":true,"date":"2026-09-02"} [2026-09-03 16:11:16] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:11:16] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:11:16] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:11:16] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147624925.83960000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:11:17] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-02","location_id":null,"is_opening":true,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:11:17] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:11:17] live.INFO: Opening stock calculation - including all transactions {"date":"2026-09-02"} [2026-09-03 16:11:17] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-09-02')"} [2026-09-03 16:11:17] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-02') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-09-02'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:11:17] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149109333.00000000","is_opening":true,"date":"2026-09-02"} [2026-09-03 16:11:17] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:11:17] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:11:17] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:11:17] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:11:17] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149116033.00000000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:11:28] live.INFO: filterProduct method called {"business_id":8,"search_term":"milk","location_id":"9","not_for_selling":"0","price_group_id":"0","product_types":[],"search_fields":["name","sku","lot"],"check_qty":false,"search_type":"like"} [2026-09-03 16:11:28] live.DEBUG: Initial query built with joins {"has_location":true} [2026-09-03 16:11:28] live.DEBUG: Filtering by not_for_selling {"not_for_selling":"0"} [2026-09-03 16:11:28] live.DEBUG: Joining purchase_lines for lot number search [2026-09-03 16:11:28] live.DEBUG: Applying search filters {"search_term":"milk","search_type":"like","search_fields":["name","sku","lot"]} [2026-09-03 16:11:28] live.DEBUG: LIKE search conditions applied {"fields":["name","sku","lot"]} [2026-09-03 16:11:28] live.DEBUG: Applying location filter {"location_id":"9"} [2026-09-03 16:11:28] live.DEBUG: Added lot number fields to select [2026-09-03 16:11:28] live.INFO: filterProduct completed successfully {"result_count":2,"business_id":8,"search_term":"milk"} [2026-09-03 16:11:33] live.ERROR: Failed to send error alert email: Failed to authenticate on SMTP server with username "support@risetsystems.com" using the following authenticators: "LOGIN", "PLAIN". Authenticator "LOGIN" returned "Expected response code "235" but got code "535", with message "535 Incorrect authentication data".". Authenticator "PLAIN" returned "Expected response code "235" but got code "535", with message "535 Incorrect authentication data".". [2026-09-03 16:11:39] live.INFO: Product Row Debug - RELOADED {"product_id":285,"product_name":"Milk Fresh","discount_allowed":false,"has_global_discount":false,"global_discount_type":"fixed","global_discount_amount":0,"discounts_count":0,"discounts":[],"base_price":50.0,"discounts_json":"[]","multiplier":1,"unit_prices":{"11":{"unit_id":11,"unit_name":"Ltr","unit_price":null,"multiplier":1,"has_price":false}},"has_price_group":false,"price_group_id":null} [2026-09-03 16:11:53] live.INFO: Credit Limit Check Started {"contact_id":"94","status":"final","final_total":"4000.00","is_credit_sale":"0","exclude_transaction_id":null} [2026-09-03 16:11:53] live.DEBUG: Payment Calculation {"final_total":4000.0,"curr_total_payment":4000.0,"is_credit_sale":false,"payment_count":1} [2026-09-03 16:11:53] live.INFO: Credit Limit Check Skipped - Fully Paid {"final_total":4000.0,"curr_total_payment":4000.0} [2026-09-03 16:11:53] live.INFO: mpesa_transaction_id value: NULL [2026-09-03 16:11:53] live.INFO: is_mpesa_sale value: true [2026-09-03 16:11:53] live.INFO: M-Pesa sale evaluation {"is_mpesa_sale_raw":true,"is_valid_mpesa_sale":false,"payment_method_input":"cash","mpesa_transaction_id":null,"transaction_id":1790} [2026-09-03 16:11:53] live.INFO: Journal Entry Case: FULL CASH PAYMENT {"transaction_id":1790,"final_total":4000.0,"amount_paid":4000.0,"balance_due":0} [2026-09-03 16:11:53] live.INFO: Journal Entries Inserted Successfully {"transaction_id":1790,"entries":[{"transaction_id":1790,"created_by_id":21,"transaction_number":"TRX-6a9972198feff6.07906909","payment_detail_id":1279,"location_id":"9","currency_id":133,"transaction_type":"sell","date":"2026-09-03","month":9,"year":2026,"active":1,"reversed":0,"reversible":1,"manual_entry":1,"created_at":"2026-09-03 16:11:53","updated_at":"2026-09-03 16:11:53","chart_of_account_id":23,"debit":null,"credit":4000.0},{"transaction_id":1790,"created_by_id":21,"transaction_number":"TRX-6a9972198feff6.07906909","payment_detail_id":1279,"location_id":"9","currency_id":133,"transaction_type":"sell","date":"2026-09-03","month":9,"year":2026,"active":1,"reversed":0,"reversible":1,"manual_entry":1,"created_at":"2026-09-03 16:11:53","updated_at":"2026-09-03 16:11:53","chart_of_account_id":27,"debit":4000.0,"credit":null}]} [2026-09-03 16:11:53] live.INFO: ETIMS: Customer details retrieved {"transaction_id":1790,"contact_id":94,"customer_name":"Walk-In Customer","has_tin":false,"has_digitax_id":false} [2026-09-03 16:11:53] live.ERROR: ETIMS: Missing item_id for product {"product_id":285} [2026-09-03 16:11:53] live.ERROR: ETIMS: No valid items to submit after filtering [2026-09-03 16:11:53] live.WARNING: ETIMS WAIT: Timed out after 2 attempts for transaction ID: 1790 [2026-09-03 16:12:08] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2025-12-31","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:12:08] live.INFO: Opening stock calculation - including all transactions {"date":"2025-12-31"} [2026-09-03 16:12:08] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2025-12-31')"} [2026-09-03 16:12:08] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2025-12-31') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2025-12-31'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:12:08] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"58869373.22080000","is_opening":true,"date":"2025-12-31"} [2026-09-03 16:12:08] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-12-31","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:12:08] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-12-31' (includes all types except purchase_order)"} [2026-09-03 16:12:08] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-12-31') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-12-31'","bindings":["purchase_order",8]} [2026-09-03 16:12:08] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147624925.83960000","is_opening":false,"date":"2026-12-31"} [2026-09-03 16:12:10] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2025-12-31","location_id":null,"is_opening":true,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:12:10] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:12:10] live.INFO: Opening stock calculation - including all transactions {"date":"2025-12-31"} [2026-09-03 16:12:10] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2025-12-31')"} [2026-09-03 16:12:10] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2025-12-31') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2025-12-31'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:12:10] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"79279760.00000000","is_opening":true,"date":"2025-12-31"} [2026-09-03 16:12:10] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-12-31","location_id":null,"is_opening":false,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:12:10] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:12:10] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-12-31' (includes all types except purchase_order)"} [2026-09-03 16:12:10] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-12-31') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-12-31'","bindings":["purchase_order",8]} [2026-09-03 16:12:10] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149116033.00000000","is_opening":false,"date":"2026-12-31"} [2026-09-03 16:12:14] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-01","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:12:14] live.INFO: Opening stock calculation - including all transactions {"date":"2026-09-01"} [2026-09-03 16:12:14] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-09-01')"} [2026-09-03 16:12:14] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-01') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-09-01'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:12:14] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147619325.83960000","is_opening":true,"date":"2026-09-01"} [2026-09-03 16:12:14] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-02","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:12:14] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-02' (includes all types except purchase_order)"} [2026-09-03 16:12:14] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-02') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-02'","bindings":["purchase_order",8]} [2026-09-03 16:12:14] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147619325.83960000","is_opening":false,"date":"2026-09-02"} [2026-09-03 16:12:15] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-01","location_id":null,"is_opening":true,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:12:15] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:12:15] live.INFO: Opening stock calculation - including all transactions {"date":"2026-09-01"} [2026-09-03 16:12:15] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-09-01')"} [2026-09-03 16:12:15] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-01') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-09-01'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:12:15] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149109333.00000000","is_opening":true,"date":"2026-09-01"} [2026-09-03 16:12:15] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-02","location_id":null,"is_opening":false,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:12:15] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:12:15] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-02' (includes all types except purchase_order)"} [2026-09-03 16:12:15] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-02') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-02'","bindings":["purchase_order",8]} [2026-09-03 16:12:15] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149109333.00000000","is_opening":false,"date":"2026-09-02"} [2026-09-03 16:12:17] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-02","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:12:17] live.INFO: Opening stock calculation - including all transactions {"date":"2026-09-02"} [2026-09-03 16:12:17] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-09-02')"} [2026-09-03 16:12:17] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-02') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-09-02'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:12:17] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147619325.83960000","is_opening":true,"date":"2026-09-02"} [2026-09-03 16:12:17] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":"all"} [2026-09-03 16:12:17] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:12:17] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:12:17] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"147624925.83960000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:12:17] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-02","location_id":null,"is_opening":true,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:12:17] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:12:17] live.INFO: Opening stock calculation - including all transactions {"date":"2026-09-02"} [2026-09-03 16:12:17] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-09-02')"} [2026-09-03 16:12:17] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-02') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-09-02'))","bindings":["purchase_order",8,"opening_stock","opening_stock"]} [2026-09-03 16:12:17] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149109333.00000000","is_opening":true,"date":"2026-09-02"} [2026-09-03 16:12:17] live.INFO: === getOpeningClosingStock START === {"business_id":8,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":true,"filters":"all","permitted_locations":null} [2026-09-03 16:12:17] live.DEBUG: Using sale price instead of purchase price {"price_query_part":"v.sell_price_inc_tax"} [2026-09-03 16:12:17] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:12:17] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * v.sell_price_inc_tax ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",8]} [2026-09-03 16:12:17] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"149116033.00000000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:25:33] live.INFO: === getOpeningClosingStock START === {"business_id":43,"date":"2026-09-02","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":null} [2026-09-03 16:25:33] live.INFO: Opening stock calculation - including all transactions {"date":"2026-09-02"} [2026-09-03 16:25:33] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-09-02')"} [2026-09-03 16:25:33] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-02') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-09-02'))","bindings":["purchase_order",43,"opening_stock","opening_stock"]} [2026-09-03 16:25:33] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"5993257.40800000","is_opening":true,"date":"2026-09-02"} [2026-09-03 16:25:33] live.INFO: === getOpeningClosingStock START === {"business_id":43,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":null} [2026-09-03 16:25:33] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:25:33] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",43]} [2026-09-03 16:25:33] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"5993257.40800000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:25:35] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 16:26:03] live.INFO: === getOpeningClosingStock START === {"business_id":43,"date":"2026-09-02","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":null} [2026-09-03 16:26:03] live.INFO: Opening stock calculation - including all transactions {"date":"2026-09-02"} [2026-09-03 16:26:03] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-09-02')"} [2026-09-03 16:26:03] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-02') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-09-02'))","bindings":["purchase_order",43,"opening_stock","opening_stock"]} [2026-09-03 16:26:03] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"5993257.40800000","is_opening":true,"date":"2026-09-02"} [2026-09-03 16:26:03] live.INFO: === getOpeningClosingStock START === {"business_id":43,"date":"2026-09-03","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":null} [2026-09-03 16:26:03] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-03' (includes all types except purchase_order)"} [2026-09-03 16:26:03] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-03') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-03'","bindings":["purchase_order",43]} [2026-09-03 16:26:03] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"5993257.40800000","is_opening":false,"date":"2026-09-03"} [2026-09-03 16:26:05] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 16:26:07] live.INFO: === getOpeningClosingStock START === {"business_id":43,"date":"2026-08-31","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":null} [2026-09-03 16:26:07] live.INFO: Opening stock calculation - including all transactions {"date":"2026-08-31"} [2026-09-03 16:26:07] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-08-31')"} [2026-09-03 16:26:07] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-08-31') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-08-31'))","bindings":["purchase_order",43,"opening_stock","opening_stock"]} [2026-09-03 16:26:07] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"5993257.40800000","is_opening":true,"date":"2026-08-31"} [2026-09-03 16:26:07] live.INFO: === getOpeningClosingStock START === {"business_id":43,"date":"2026-09-30","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":null} [2026-09-03 16:26:07] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-30' (includes all types except purchase_order)"} [2026-09-03 16:26:07] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-30') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-30'","bindings":["purchase_order",43]} [2026-09-03 16:26:07] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"5993257.40800000","is_opening":false,"date":"2026-09-30"} [2026-09-03 16:26:09] live.INFO: === getOpeningClosingStock START === {"business_id":43,"date":"2026-08-31","location_id":null,"is_opening":true,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":null} [2026-09-03 16:26:09] live.INFO: Opening stock calculation - including all transactions {"date":"2026-08-31"} [2026-09-03 16:26:09] live.INFO: Applied opening stock condition {"condition":"purchase.type = 'opening_stock' OR (purchase.type != 'opening_stock' AND date(transaction_date) <= '2026-08-31')"} [2026-09-03 16:26:09] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-08-31') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and (`purchase`.`type` = ? or (`purchase`.`type` != ? and date(transaction_date) <= '2026-08-31'))","bindings":["purchase_order",43,"opening_stock","opening_stock"]} [2026-09-03 16:26:09] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"5993257.40800000","is_opening":true,"date":"2026-08-31"} [2026-09-03 16:26:09] live.INFO: === getOpeningClosingStock START === {"business_id":43,"date":"2026-09-30","location_id":null,"is_opening":false,"by_sale_price":false,"filters":{"user_id":null},"permitted_locations":null} [2026-09-03 16:26:09] live.INFO: Applied closing stock condition {"condition":"date(transaction_date) <= '2026-09-30' (includes all types except purchase_order)"} [2026-09-03 16:26:09] live.DEBUG: Final SQL Query {"sql":"select SUM((purchase_lines.quantity - purchase_lines.quantity_returned - purchase_lines.quantity_adjusted - (SELECT COALESCE(SUM(tspl.quantity - tspl.qty_returned), 0) FROM transaction_sell_lines_purchase_lines AS tspl JOIN transaction_sell_lines as tsl ON tspl.sell_line_id=tsl.id JOIN transactions as sale ON tsl.transaction_id=sale.id WHERE tspl.purchase_line_id = purchase_lines.id AND date(sale.transaction_date) <= '2026-09-30') ) * (purchase_lines.purchase_price + COALESCE(purchase_lines.item_tax, 0)) ) as stock from `purchase_lines` inner join `transactions` as `purchase` on `purchase_lines`.`transaction_id` = `purchase`.`id` left join `variations` as `v` on `v`.`id` = `purchase_lines`.`variation_id` left join `products` as `p` on `p`.`id` = `purchase_lines`.`product_id` where `purchase`.`type` != ? and `purchase`.`business_id` = ? and date(transaction_date) <= '2026-09-30'","bindings":["purchase_order",43]} [2026-09-03 16:26:09] live.INFO: === getOpeningClosingStock RESULT === {"calculated_stock":"5993257.40800000","is_opening":false,"date":"2026-09-30"} [2026-09-03 16:26:11] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 16:26:18] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 16:36:21] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 16:46:25] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 16:56:25] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 17:06:25] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 17:16:25] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 17:26:25] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 17:37:00] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 17:46:48] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 17:57:00] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 18:07:00] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 18:16:58] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 18:27:23] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 18:37:01] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 18:46:48] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 18:57:01] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 19:07:04] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 19:16:48] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 19:26:48] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 19:37:01] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 19:46:48] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 19:57:01] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 20:07:01] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 20:17:01] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 20:27:01] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 20:37:02] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 20:47:02] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 20:54:23] live.ERROR: Failed to send error alert email: Failed to authenticate on SMTP server with username "support@risetsystems.com" using the following authenticators: "LOGIN", "PLAIN". Authenticator "LOGIN" returned "Expected response code "235" but got code "535", with message "535 Incorrect authentication data".". Authenticator "PLAIN" returned "Expected response code "235" but got code "535", with message "535 Incorrect authentication data".". [2026-09-03 20:57:02] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 21:07:02] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 21:17:02] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 21:27:02] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 21:37:02] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 21:47:02] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 21:57:01] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 22:07:02] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 22:17:02] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 22:27:02] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 22:37:01] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 22:46:57] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 22:56:47] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 23:07:01] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 23:17:01] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 23:26:48] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 23:37:01] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 23:46:47] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43} [2026-09-03 23:56:47] live.INFO: Offline not allowed - triggering cleanup {"user_id":293,"business_id":43}