JPVideo

Application for video rental management for VAT payers and non-payers. EAN8 / EAN13 barcode reader can be connected. The application can also be run on a local network. The program is not hardware-intensive and runs under W98, WMe, W2000, WXP. A very reliable MSSQL server is used for data storage...

Features of the application:

• Evidence of customers, entering - editing of customers, printing of customer reports, printing of customer cards, overview and printing of video rental history, sorting, searching and filtering of customers, import and export to Excel.
• Video entry - video editing, print video reports, review customer history, sort, search and filter video, import and export to Excel.
• Lending, Lending-Dialog, can be operated very quickly with just a few keys, barcode scanner can be used, mouse control is also possible. Thanks to the history of the borrowed video, the program can notify that the customer has already borrowed the video in question. It is possible to set a limit on the number of videos that a customer can have at one time. Discounts for renting multiple videos at once (e.g. every 5th video free within one rental), loyalty (e.g. every 10th video free). See settings...
• Returns, Returns-Dialog, the controls are similar to the Rent function. There are two ways to return a video:
  Enter the customer number / customer name, the program will find all videos that the customer has rented.
  Or enter a video number / video title, the program will find the customer who has that video borrowed and offer to return other videos if necessary.
• Printing of documents, possibility of printing in A5 or A4 format, with or without copy.
• Complete borrowing history, both in terms of "customer had/has borrowed videos" and "video had/has been borrowed by these customers"
.
• Evidence of rental and return documents, possibility of additional printing of documents, sorting, searching and filtering of individual documents.
• Video rental and printing settings.
• SQL console - any select over the database can be exported to Excel (creating reports as desired), database editing using SQL commands.
• Graphical representation of sales statistics (from-to, weekly, monthly, yearly).
• Discounts, quantity and loyalty discounts.
• Customers can be classified into four groups: restricted lending, lending against deposit, unrestricted lending, VIP customer.
• Logging into the program, each user (operator) can be assigned his own rights for certain operations.
• Backup, the program has its own simple data backup and restore function.