GM
Asked
Hi sir,
1) When Over selling enabled in settings system, Add new purchases triggers wrong quantity for existing product quantity.
2) When i want to edit/modify an item in existing purchase called A, a majority of items that in that purchase list became “0” Quantity in product list. For example, i uploaded a CSV file of 500 items purchased last week. Yesterday, i open that purchase A, then i updated quantity for product called "mouse" from that purchase. Result: The quantity of 393 other items became “0”. this happen multiple time with me. It is very frustrating when you work with production. After one month from purchase A entry, my customer want to return some items in the purchase A. If i edit the purchase, some products will became with 0 quantity.
3) How to show suspended sales to all users, not only admin. Can you please tell me the line of code to modify.
4) Bill order receipt have no reference number.
5)How to save all bill orders generated in SMA like saved suspended sales
6) What means "Full" "partial" in count stock feature
7) What means "set average cost" in product list top menu
Thanks you for you support
1) When Over selling enabled in settings system, Add new purchases triggers wrong quantity for existing product quantity.
2) When i want to edit/modify an item in existing purchase called A, a majority of items that in that purchase list became “0” Quantity in product list. For example, i uploaded a CSV file of 500 items purchased last week. Yesterday, i open that purchase A, then i updated quantity for product called "mouse" from that purchase. Result: The quantity of 393 other items became “0”. this happen multiple time with me. It is very frustrating when you work with production. After one month from purchase A entry, my customer want to return some items in the purchase A. If i edit the purchase, some products will became with 0 quantity.
3) How to show suspended sales to all users, not only admin. Can you please tell me the line of code to modify.
4) Bill order receipt have no reference number.
5)How to save all bill orders generated in SMA like saved suspended sales
6) What means "Full" "partial" in count stock feature
7) What means "set average cost" in product list top menu
Thanks you for you support
- MSAnsweredHello,
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 - GMAnsweredHello, 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 - MSAnsweredHello,
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 - GMAnsweredHello Mian Saleem, i really appreciate you help. Very happy to your assistance. Thanks you very much for helping your customers
- GMAnsweredHello, 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.
ThanksAttachments - MSAnsweredPlease take the screenshot modified code? Thanks
- GMAnsweredHello Mian Saleem,
NEW and OLD source codes both attached
Thanks you for heliping us.Attachments - MSAnsweredYou can try to edit the `fetch_bills` method of `app/models/admin/Pos_model.php` and comment first 3 lines. Thank you
- Login to Reply