AS
Asked
Hey!
When i try to submit the invoice in POS Module section i am getting white page, don't get print receipt and also there's no error from server :(
One more issue in Report section Daily Sale and Daily Purchase, both show same report (Daily sale)
When i try to submit the invoice in POS Module section i am getting white page, don't get print receipt and also there's no error from server :(
One more issue in Report section Daily Sale and Daily Purchase, both show same report (Daily sale)
- MSAnsweredHello,
Please check your server error logs and let me know the error details so that I can suggest. The blank pages are caused due to 500 error and the error details from log would be helpful to know the cause.
There is no daily/monthly purchase report. The calendar can only show the day/month profit report only.
Thank you - ASAnsweredERROR - 2020-09-15 16:11:25 --> Severity: Warning --> Division by zero C:\xampp\htdocs\khalil_mobile\app\models\Site.php 72
ERROR - 2020-09-15 16:11:25 --> Severity: Warning --> Division by zero C:\xampp\htdocs\khalil_mobile\app\models\Site.php 72
ERROR - 2020-09-15 16:11:25 --> Query error: Unknown column 'NAN' in 'field list' - Invalid query: INSERT INTO `sma_costing` (`date`, `product_id`, `sale_item_id`, `purchase_id`, `purchase_item_id`, `quantity`, `purchase_net_unit_cost`, `purchase_unit_cost`, `sale_net_unit_price`, `sale_unit_price`, `quantity_balance`, `inventory`, `option_id`, `sale_id`) VALUES ('2020-09-15', '121', 1656, NULL, '1985', '-52.0000', '0.0000', NAN, '19.00', '19.00', 0, 1, NULL, 134)
ERROR - 2020-09-15 16:11:25 --> An errors has been occurred while adding the sale (Add:Pos_model.php) - ASAnsweredAfter updating from 3.4.37 to 3.4.40 still same issue,
Log file report,
<?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>
ERROR - 2020-09-16 14:18:31 --> Severity: Warning --> Division by zero C:\xampp\htdocs\khalil_mobile\app\models\Site.php 72
ERROR - 2020-09-16 14:18:31 --> Severity: Warning --> Division by zero C:\xampp\htdocs\khalil_mobile\app\models\Site.php 72
ERROR - 2020-09-16 14:18:31 --> Query error: Unknown column 'NAN' in 'field list' - Invalid query: INSERT INTO `sma_costing` (`date`, `product_id`, `sale_item_id`, `purchase_id`, `purchase_item_id`, `quantity`, `purchase_net_unit_cost`, `purchase_unit_cost`, `sale_net_unit_price`, `sale_unit_price`, `quantity_balance`, `inventory`, `option_id`, `sale_id`) VALUES ('2020-09-16', '121', 1663, NULL, '1985', '-52.0000', '0.0000', NAN, '19.00', '19.00', 0, 1, NULL, 135)
ERROR - 2020-09-16 14:18:31 --> An errors has been occurred while adding the sale (Add:Pos_model.php) - MSAnsweredHello,
There is such column :( I am not sure why are you having that in query. Is it new install or what?
Can you perform fresh install and test? - ASAnswered**[Mian Saleem](/u/saleem)** The issue is in "purchase_unit_cost" column value "NAN", i clear the stock of the product which arise this issue and again purchase them, after the issue resolve. but this is not the solid solution, it's again and again will happen.
I have notice the issue arise when i made quantity adjusment with some products. - MSAnsweredHello,
Can you please let me know the step to reproduce it?
Thank you - ASAnsweredSure!
I have made a purchase of incorrect product, after purchase i made adjustment of that product (subtract quantity) in adjusment section. After when i made a sale in POS of that product the issue arise.
i clear the qunatity in again purchase, the issue resolve. - MSAnsweredThank you for letting me know the details. I will check this before next update.
- Login to Reply