I'm seeking some advice as to what direction to take to accomplish this task, would really appreciate some suggestions.
In my POS software (still in development), I have a "Products" table, much like the one in Alpha Spots. In our store, we have certain products that are physically counted twice per day to confirm our "quantity on hand" according to the POS software.
Currently, Quickbooks POS is being used, and the process is:
1) Freeze a department in "QB POS" by exporting it to Excel, this is done because the quantity on hand is constantly changing dues to ongoing sale, but when exported to Excel, the numbers become stagnant.
2) The inventory personnel then physically goes through the store counting the products from the frozen department and reconcile the results. this then confirms the amount sold from the amount stolen or otherwise missing.
In my POS app, I would like to eliminate the use of Excel completely, by somehow taking a snapshot of the products table at the specified intervals, which would be at the beginning of each shift. The user layout for this should show each product, the date and time of the snapshot and has a field for entering the results of the count, then the software should indicates if the quantities reconsile evenly, or if there is products missing or overs.
I have absolutely no idea on how to go about accomplishing this task at the moment.
Any suggestions guys?
In my POS software (still in development), I have a "Products" table, much like the one in Alpha Spots. In our store, we have certain products that are physically counted twice per day to confirm our "quantity on hand" according to the POS software.
Currently, Quickbooks POS is being used, and the process is:
1) Freeze a department in "QB POS" by exporting it to Excel, this is done because the quantity on hand is constantly changing dues to ongoing sale, but when exported to Excel, the numbers become stagnant.
2) The inventory personnel then physically goes through the store counting the products from the frozen department and reconcile the results. this then confirms the amount sold from the amount stolen or otherwise missing.
In my POS app, I would like to eliminate the use of Excel completely, by somehow taking a snapshot of the products table at the specified intervals, which would be at the beginning of each shift. The user layout for this should show each product, the date and time of the snapshot and has a field for entering the results of the count, then the software should indicates if the quantities reconsile evenly, or if there is products missing or overs.
I have absolutely no idea on how to go about accomplishing this task at the moment.
Any suggestions guys?
Comment