opensourcepos / opensourcepos Goto Github PK

Instead of exporting to excel I would love to get the low inventory via email. Is this possible

I noticed that when I go into reports and try to edit a receiving, it does not work.
I think it has something to do with the fact that there is no invoice number and I get the error that there is a duplicate entry for invoice number...

Original issue from http://sourceforge.net/p/opensourcepos/support-requests/75

Generating barcode presently creates a barcode which gives the item_id and name from table/database ospos_items.

1. I want to change the item_id to item_number. In other words I would like the barcode when scanned to give the upc number not the item id.
2. I would like to add the price (unit_price) to the barcode. I have not been able to find where I need to change/add this information. Pls help!
   (Ori: MClark)

Are you fork from

http://sourceforge.net/projects/opensourcepos

I want to check new update from there.

use ESC/POS commands to send commands direct to the printer, which is connected to the server. It can be used https://github.com/mike42/escpos-php

It allows for send of image, text, barcode, cutting function and etc, allowing to talk natively with the printer. Note that required the printer connected direct to the server, or printer on network .

I think it would be awesome addition for the Php POS program, and would make it perfect for my use and many others uses.

Hopefully feature get added, and sorry for my English.

If a language line is missing, then CI_Lang::line returns FALSE and writes a line to the error log.
This way sometimes there isn't displayed anything, which can look strange. Wouldn't it be better if at least the name of the quiered language line (the $line-value) was returned?
Or first the english language line, if it is not set, then take the $line-value...
Since this is handled by the CI_Lang-Class which is part of codeigniter I think it is not so good to change that file, but how could that be done? I see MY_Language extends Lang, but that is not CI_Lang, so it is something else, isn't it?

Hi,
I made a sale. It generated the sale_id. I also added a customer.

1.While returning I typed the full sale_id - POS 1
it wasn't able to show the result in the auto-complete.

1. I searched with customer's name. It wasn't able to show anything.

This might be the reason -
in auto-complete we format the result for row[1]...But from backend we only send the sale id or customer name. Following piece of code might be the issue...

function get_search_suggestions($search,$limit=25)
{
    $suggestions = array();

    if (!$this->sale_lib->is_valid_receipt($search)) {
        $this->db->distinct();
        $this->db->select('first_name, last_name, invoice_number, sale_time');
        $this->db->select("DATE_FORMAT( sale_time, '%d-%m-%Y' ) AS sale_date", FALSE);
        $this->db->select("sales.sale_id AS sale_id");
        $this->db->from('sales');
        $this->db->join('people', 'people.person_id = sales.customer_id', 'left');
        $this->db->where("( last_name LIKE '%" . $search . "%' OR ".
                "first_name LIKE '%" . $search . "%' OR " .
                "CONCAT( first_name, last_name ))");
        $this->db->order_by('last_name', "asc");

        foreach($this->db->get()->result_array() as $result)
        {
            $suggestions[]="POS ".$result[ 'sale_id' ].'|'.$result[ 'first_name' ].' '.$result[ 'last_name' ]; ///////////// changed to concatenate id
        }

    } else {
        $suggestions[]=$search.'|'.$search; ///////////changed to concatenate id
    }
    return $suggestions;
}

Is this a bug...??? Or I am doing something wrong...I am not testing with barcode scanner...That's why I entered the full sale_id manually...

Since there is no longer a private message function, I'm not sure what is the appropriate way to do this, but we have deployed opensourcepos as part of larger veterinary practice management solution and we need some extra muscle for enhancing and applying updates. Please contact me for additional details.

Issue copied from [opensourcepos:support-requests] #79
Payment type needs to be added to payment report.

Gift card auto increment is not working past the number 10. It stays on 10 after that value is reached. I also noticed after going into phpmyadmin and deleting the gift cards and starting over that the gift card number selected to edit shows the gift card_id in the Gift card edit screen and not the gift card number.

In the Item Tab :

• I have a list of different items
• I click on the "edit" link to edit one of them
• I change one of its value (anything works)
  ==> All the items are duplicated and show my changed item !!

If I refresh the page, everything returns to normal : the list of different items is displayed correctly and my item value has been changed.

PS : When I have time, I'll have a look at it :-)

The logic to check for access to a specific module does not work correctly. I get "You do not have permission to access the module named Sales (items)"

It seems that the join is not right in module.php
$this->db->join('permissions','permissions.permission_id=modules.module_id');

Sir, I want custom search options means cetagories search,and custom search in sales register like item search.. Would you help me like that system?

We would like to upload a simple .jpg or .png file to the sales. We are a security company and we have inital cad drawings of the site location and where their cameras are going to be placed.

Could be this performed?

I noticed that I cannot give a user only the permission to sell products. Because if I do, then if that user wants to sell something, an error is produced in stock_locations-model::get_default_location_id().
If I grant the user permission only to the different stock-locations but not to the whole items-module, the module items is not listed in the menu, but if you just type in the url /items the user has full access to the items module and can edit/delete and everything...

It would be nice to choose in the config if one wants a dot or komma as a decimal point and if there should be a thousands separator. In Indonesia where 100,000.00 Rp are about 10US$ , so the thousand separator is very important.

I have a large no. of items list in excel.

I imported excel sheet but there was no indication/notification of items being importing or finishing excel import indication.

Can you please explain to me the field "receiving quantity" in version 2.3.1?
It is a third field... different from "Quantity Stock" and "Reorder Level".
I have reviewed how it operates, for example I added an item with 2 quantity
and sold those two items yet the "receiving quantity" field still shows 2.
It is almost as if it is acting as a record of the last amount received? I
am not quite sure. It is not impacted by selling product. Thanks so much!

As some options in the setting/configuration are not self-explanatory it would be great to have a small tooltip which explains it...

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Quantity stock show zero on edit an item even quantity is greater than zero.

No. of Quantity is not picking up in the edit item form.

Hello,
We are just starting to use your POS for our inventory and sales management. We LOVE everything you currently have and really want to roll this out for full use with our employees. We are a security camera company that sells and leases our cameras out.

I have a couple of requests and would like to donate to aid to their completion:

1. In your sales, can you have Estimate, Sales, and Return (i.e. for customer estimates that we can then go back, edit if necessary, and then change to a sale once its made?) For reporting have these estimates show up under the customers, so we know who has had a quote and we can complete sale by meeting up with customer again.

I think as of now, we can utilize the sale and return function for our leased equipment. But i have a problem with my returns. I have reduced the description of the item as it was previously giving me an error when I completed a sale, but when I tried to return the item, it would not let me edit and complete the transaction as it gave me the error that it was too long again.
http://tcf-s.com/stk/index.php/sales/edit_item/1

2.Can you filter by Category in Sales to a customer? We have to have each of our categories filled in our excel sheet, i.e. NVR, CAMERA, HARDWARE, SOFTWARE before completing to customer. Is there a way to populate the categories so we know we have items from each selection?

I changed the currency symbol in app config but it wasn't effecting and still showing '$'.
After going through the code I found this in (application\helpers\currency_helper.php):

$currency_symbol = $CI->config->item('currency_symbol') ? $CI->config->item('currency_symbol') : '$';
$currency_symbol = $currency_symbol == '$' && $escape ? '$' : '$';

I think this causing the symbol to make it always '$'.
So I commented the second line and currency symbol changes in the app everywhere.

if a user is logged in and then instead of logging out clicks the x on the title thereby closing the page,
anyone else can get into the program without putting in a username and password just by clicking the 'go' button on the login screen

Hey,
I noticed when return a sale item then the items are not showing in the drop down list like displaying in the sale on typing partial name or item no.

Can you guide me how to fix ?

Regards,

Sorting Gift card number does not work.
You have to give permission for stock under Item not to get #55 error.
Are you going to implement a barcode print feature?

i found out that when exporting the low inventory report all items will be seen,
can you make additional column for exporting name as "suppliers" so that if a user wants to sort the items by suppliers
just like what you did in your items section if put a category in search bar all items in that category can be seen.
sort: suppliers, items(category)
additional column: suppliers

I thought it would be great to see what value all the stuff I have in stock has at the moment.
Therefore it would be good to add one report. With a small form before where I can choose which stock location and if I want to include negative-stock levels or not.
I would be happy to do that, but unfortunately I don't really understand the reports-controller...

By the way: do you prefer to have issues postet here on github or on sourceforge?

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

1. If you do a blank search, it shows up each item twice...If you enter some character then it shows correctly...
2. When you select an item, it shows up the id in the input field..It should show the name instead...

i would like to know is there any function to bulk create new item with serial number without enter the same item information.

The scenario apply to mobile phones where by i hv 1 model with different EMEI each phone. Pls advice

I noticed that when I receive items, of course, after the receiving the quantity is higher according to the receiving.
If I now go into reports and choose Detailed Reports->Receivings and click on the receiving's ID and click "delete entire sale", the receiving gets deleted, but the quantity of the products which were received does not change...
So when I make a mistake in a receiving, notice it, and delete it, I have to manually change the quantity which can be difficult if I don't write down the quantity which was received...
Or is there a different way to delete receivings?

Same with sales: If I delete a sale through the Sales-Report, the quantity stays the same as if the item was sold...

Am I the only one experiencing this problem, I must check all the categories (items, items_stocks & sales, sales_stocks) before I can perform the sales.

How to make sales without checking the item and item_stocks

Thanks

I'm trying to submit a product, but firstable it shows me a php error that says:
Undefined property: stdClass::$category
Filename: items/form.php
Line Number: 38

second: even though it shows that problem, I can fill out the fields, but I can't submit the form, It actually verifies the fields (if I did't complete it properlly ) but It doesn't allow me to submit it.

Can you help mee! please!

Hello sir. Hope you will fine with your health and business
Sir, it is possible, make a system like Categories have different sub categories and all items have same item number.....

last two import statements are incorrect, should be:

ALTER TABLE ospos_customers
ADD COLUMN company_name varchar(255) DEFAULT NULL;

ALTER TABLE ospos_giftcards
MODIFY person_id int(10) DEFAULT NULL;

Ospos 2.3.1 , in the Items menu List of Item can be sorted using Location filtering but in version 2.3.2 Items cannot be filtered based on the location selection.

Could you give a guideline how to fix it Or is it already being fixed ? Appreciate your help.

Thank You
Digantos

Congratulations for the work, i am translating the language file in Italian and i have almost completed all but i can not translate the dates (month-day), i found the files in system/language but when i translate them nothing changes and remain in English. Can you explain how to complete the translation and for the change of date format (d / m / Y). Thank You

Thanks to this great app, very useful. Is it possible to use bootstrap for frontend? If it is possible, what things do i have to consider to not break the app. thanks in advance.

On popular request I will consider to implement a customer debt function. This is quite a big new feature and thus will require a couple of hours programming.

Just to keep myself motivated I would like to ask people to offer donations (just post to this issue), and if the add up of all individuals reaches $300 I will do the implementation.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Hello jekkos,
Just downloaded the ospos-master 2.3.2 and tried it out, noticed that employees with access to only the sales module, can delete sales through the overview feature!?

Secondly, in the items module, when a different location is selected, items and their quantities don't change to selected location.

Keep up the amazing work.

Hi, i would like to report a stored XSS vulnerability inside de open source POS application. I tested the sourceforge code and found the following list of vulnerable parameter:

-Customer > last name, first name, phone number
-ALL > welcome
-list of items > UPC/EAN/ISBN, item name, category
-item kits > item kit name, item kit description
-suppliers > company name, last name, first name, phone number
-items receiving > select supplier search, item name
-receivings receipt > item name, employee name, payment type
-sales register > item name, select customer search
-sales receipt > employee, item
-list of employees > lastname, first name, phone number.
-when creating item> category list
-gift card> customer list
-store config> company name, stock, company address, company phone

I also tested a couple of fields on the github code and the issue is present

to replicate the issue just enter on the fields mentioned. please let me know if you need more information.

Arturo Rodriguez
Security Consultant

I found this post:
http://www.cartbooks.com/frontaccounting-point-of-sale/
Mentioning FrontAccounting and PHP OpenSource POS integration.
But I couldn't able to find any working module.

Is there any solution available ?

When I create a new item and do not select an image, it does not work.
Does it maybe has something to do with the fact, that _handle_image_upload() is always called and that there is no check whether $_FILES['item_image'] is empty or not?
Or is something with my setup wrong?

Often my prices change for some stuff I buy.
Therefore it would be cool to be able to change the price of a product when receiving it.
If I still have items in stock, an average price shall be calculated.

Jekkos,

Can you contact me. Sorry could not find your email. [email protected] Curtis referred me to you. Fee based development for a specific industry.

You can delete this issue.

Thanks

Hi Jekkos

Seems flash chart is not working in android. Does it support Android OR is there any work around ?

Thank You
Digantos

Hi, the problem is in the helper to_currency in the line 7

$currency_symbol = $currency_symbol == '$' && $escape ? '$' : '$';

because always the symbol is $ instead the configured.

At "New item modal form"

....

Receiving quantity:
[ A PHP Error was encountered

Severity: Notice

Message: Undefined property: stdClass::$receiving_quantity

Filename: items/form.php

Line Number: 143 ]

How can resolve it ?

When create new item, I noticed that is a check box for item with serial number but there is no place to input the serial. During the sales, when the item is selected, it require to input serial number.

Am I missing certain steps to input the serial number or the serial number is for information purpose only and not for detail stock tracking?

Is it possible to have further discount on subtotal value after tax?

This project is awesome. But for some reason, when selecting Sales->Register Mode->(Return), and double clicking on "Find/Scan Item OR Receipt" entry box, it doesn't display the list of my items, it does when in 'Sale' mode