Question: Pos Module White Page After Submit

Pos Module White Page After Submit

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

AS

Alam Khan Bin Shamsul

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)
  • MS

    Mian Saleem

    Answered
    Hello,

    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
  • AS

    Alam Khan Bin Shamsul

    Answered
    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 --> 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)
  • AS

    Alam Khan Bin Shamsul

    Answered
    After 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)
  • MS

    Mian Saleem

    Answered
    Hello,

    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?
  • AS

    Alam Khan Bin Shamsul

    Answered
    **[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.
  • MS

    Mian Saleem

    Answered
    Hello,

    Can you please let me know the step to reproduce it?

    Thank you
  • AS

    Alam Khan Bin Shamsul

    Answered
    Sure!
    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.
  • MS

    Mian Saleem

    Answered
    Thank you for letting me know the details. I will check this before next update.
  • Login to Reply