Hello,

1. Oversold quantity will be adjusted on purchase. Please test it on live demo and if there is any issue, let me know the step to reproduce it.

2. That might be due to max_input_vars please increase the value in php config. You can refer to FAQ Why some products are missing from order when I add 100+ products? in docs for more info.

3. You can modify the getSuspendedSales method of app/models/admin/Pos_model.php

4. The reference will only be for suspended sales. If sale is not suspended there won't be any reference for order/bill but after submit for sale only.

5. There is no such option as the data stay on the local machine only. Suspend or submit sends it to the server.

6. As the term says, full mean for all the products while partial means for few.

7. Overselling could cause the cost to -ve. If that happens, you can use the set average cost to recalculate the avg_cost of product with current available stock.

Thank you

Hello, thanks you for your reactivity.

3. Which values i have to modify in getSuspendedSales method:

public function getSuspendedSales($user_id = null)
{
if (!$user_id) {
$user_id = $this->session->userdata('user_id');
}
$q = $this->db->get_where('suspended_bills', ['created_by' => $user_id]);
if ($q->num_rows() > 0) {
foreach (($q->result()) as $row) {
$data[] = $row;
}

7. What means oversellging could cause the cost to "-ve" ?

Thanks

Hello,

Instead of $this->db->get_where('suspended_bills', ['created_by' => $user_id]); you can get all by $this->db->get('suspended_bills');

Not only overselling but any method could result in -ve stock. If you add purchase for 10 and sell 8 then edit the purchase to change the quantity to 5 The stock will be -3 and there might be other scenarios too.

Thank you

Hello Mian Saleem, i really appreciate you help. Very happy to your assistance. Thanks you very much for helping your customers

Hello, i modified source code as you said,

Currently, only owner can see all suspended sales from all users.

but normal user can't see all suspended sales. Each user see only his suspended sales, not others users suspended sales nor owner suspended sales.

I would like to let normal user to see all suspended sales in whole system.

I talk about the attached windows.

Thanks

Please take the screenshot modified code? Thanks

Hello Mian Saleem,

NEW and OLD source codes both attached

Thanks you for heliping us.

You can try to edit the fetch_bills method of app/models/admin/Pos_model.php and comment first 3 lines. Thank you