Using POSper/User guide
- 1 Using POSper
- 2 Reports
- 3 Errors
Choose the sales window from the left hand menu options.
Using a Barcode Scanner
Simply scan the barcode. Each item scanned which has an entry in the stock table will add an entry to the sales ticket. When all of the items have been scanned, press the equals '=' sign on the screen and the payment options dialog will appear. The dialog has options for cash, cheque, ticket, card, and free. Choose the relevant option e.g. cash and type in the amount handed over by the customer. POSper will calculate the change. Press the printer button to print the receipt and open the till. Press OK to complete the transaction and return to the sales screen.
Using a Keyboard or the On Screen Keypad
This functions much as the barcode scanner does. Simply type in the barcode number and POSper will lookup the barcode item in the stock table. Then when return on the keyboard or the button with the barcode symbol on the screen is pressed, the item will be added to the sales ticket.
Using the Catalog
POSper maintains a catalog of current stock items, if icons have been added in the stock management screen they are displayed on the bottom right of the sales screen using images loaded into the database at the time of the stock update. If the images are not added to the stock items, the default icon is used.
To use these icons to make a sales transaction, select the category the stock item is in. Type in the number of items to be sold on the on screen keypad, press the multiply button '*' and only then choose the item itself from the catalog window. If only one item is to be sold, don't bother with the number or the multiply button, simply press the item's screen icon. The required number of items will be added to the sales ticket. When all of the items are added, complete the transaction as per the barcode scanner.
Selling General items which don't have barcodes/stock entries
Previously add a "General Item" entry to the stock database with an icon and with £0.00 as the price. When selling such an item, choose the general item from the catalog to add the item to the sales ticket. Then select the "General Item" on the sales ticket and press the pencil button to change the price and number of units being sold.
If you need reports that are not available in POSper you'll have to make your own. But don't worry. It's not hard.
- 1) Gather info about your database from POSper's sidebar: System:Configuration>Database. You'll need all the information under the Database heading, including the password. (Btw, you'll have to create another username if you intend to have POSper open at the same time as when you run reports.)
- 2) What kind of report do you want? The easiest way, believe it or not, is to use the command line.
- 3) What do you want to be on the report?
You can change out any of the SELECT statements below for ones from here.
Reporting from the Command Line
[note: remember SQL is case sensitive...even in windows...]
For postgres installations:
To run in Windows, save this as filename.bat and simply double-click it:
"c:\Program Files\PostgreSQL\8.1\bin\psql.exe" -U username -d posper -c "SELECT * FROM stockdiary;"
To create a file that you can import into (for example) excel, add this to the end:
For MySql installations:
mysql -u username -p --execute="SELECT * FROM stockdiary;" posper
You'll need to replace "username" with a real username and "posper" with the database name (posper is default). You will be prompted for a password after you hit enter.
Extremely Easy. Once the server connection has been added, go to tools, Query Tool. You simply need to paste the query into the box.
Making Printable Reports with iReports
Download iReports here: http://sourceforge.net/projects/ireport/
After completing a sale you get a message box and this error: (with or without the psql/postgresql words)
net.adrianromero.data.loader.DataException: org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint "tickets_pkey"
There are sales stored in the database with the same ticket ID that the ticket you are trying to save (pressing =).
If the result of:
select max(TICKETID) FROM TICKETS
is greater than:
SELECT last_value from ticketsnum
SELECT setval('ticketsnum', (select max(TICKETID) FROM TICKETS))
if the result of:
SELECT max(TICKETID) FROM TICKETS
is greater than:
SELECT ID FROM TICKETSNUM
UPDATE TICKETSNUM set ID = (select max(TICKETID) FROM TICKETS)