Lemon Changelog

What's new in Lemon 0.9.3 RC1

May 24, 2010
  • BUGFIX : AddTax feature is adding the tax to the total amount. ***IMPORTANT FIX***
  • BUGFIX : Product Editor now calculates the right compound tax for groups. ***IMPORTANT FIX***
  • BUGFIX : Added DISCOUNTS (offers) capability for Special Orders ***IMPORTANT FIX***
  • This fixes also discounts considedered in tax calculation for
  • Special Orders. Also fixes the taxes calculation for Special Orders.
  • BUGFIX : SpecialOrders/Custom Products (extra ticket) notes printing fixed.
  • BUGFIX : SpecialOrders/Custom Products when completing order the tax is ***IMPORTANT FIX***
  • not calculated.
  • BUGFIX : SpecialOrders/Custom Products when incrementing/decrementing it ***IMPORTANT FIX***
  • the discount and total for the item is not calculated properly.
  • BUGFIX : When selling Custom Products and adding more than one, the client is the same
  • for all custom products, its not allowed to change the client
  • and delivery date when adding another custom product.
  • BUGFIX : Adding fix_roles.sql script to fix the roles on database. Run this on 0.9.2 or older databases.
  • BUGFIX : Crash when using the Products Table View by default.
  • BUGFIX : Squeeze Freezes when adding a new user, under certain conditions. May influence kernel version.
  • This bug is related to /dev/random. Now hash function uses /dev/urandom,
  • and the mouse need to be moved during the 'add user' action.
  • BUGFIX : Unable to delete offers. This bug was present on older versions but with the Products table.
  • This is Related to QSqlTableModel class. To fix it, an own delete method was coded.
  • BUGFIX : Offers Editor's validate method (date,amount,product) fixed.
  • BUGFIX : Undefined values for balanceId and totalTax in the transaction table, only for purchases.
  • BUGFIX : When editing a group in squeeze, the available products to add to the group, shows the
  • group products and raw products in the source products list.
  • BUGFIX : Some transactions (tickets) were hidden in the "Reprint ticket" function.
  • BUGFIX : On Special Order Editor, when selecting items from left list and adding to the right list
  • and having some in the right list, the price is not calculated as it should be.
  • IMPROVEMENT : Product Editor now allows ZERO tax for products that need to be this way (tax free products).
  • IMPROVEMENT : Increased refresh time for the model views (all tables on Squeeze), they refresh every
  • 2 minutes instead of 5 seconds.
  • IMPROVEMENT : Special Orders delivery date now is printed in the format: 'Mon 21 May, 4:30 PM'.
  • IMPROVEMENT : Special Orders are now allowed to be marked as delivering on the same day.
  • IMPROVEMENT : Now special Orders notes are up to 800 characters long.
  • IMPROVEMENT : Some important fields (group elements, items in transactions...) are expanded to 1000 chars,
  • and other to 255 from lower values.
  • IMPROVEMENT : Removed empty transactions from the Resume Sale selector. This empty transaction (only one)
  • is the one created at lemon start, it will be deleted on lemon exit.
  • IMPROVEMENT : A lower limit for payment set to 1.00 in the Special Order Editor.
  • IMPROVEMENT : The taxes and price for groups are calculated when needed by lemon. To report the correct tax and price.
  • IMPROVEMENT : A splitter between the products grid and the purchase list in lemon. To allow resize them.
  • IMPROVEMENT : Ticket Redesign to improve readability.
  • UPDATE : Some translations where updated (de,es,fr).

New in Lemon 0.9.2 (Mar 15, 2010)

  • BUGFIX Hidden first and last values for profit and sales plots on squeeze.
  • BUGFIX When using date change feature, it seems that the transaction was not completed sucessfully.
  • BUGFIX On the search panel, the RAW products where excluded but still counted on the result.
  • BUGFIX Groups dont get all its taxes from the elements, if the group tax is not set correctly on creation, it will not have a correct one.
  • BUGFIX When changing configuration, now lemon requests a new transaction and balance.
  • BUGFIX Missing settings-check for drawer openning.
  • IMPROVEMENT Fixing and improved CSS style sheet. Updated CSS, improving method on lemon to load the correct file for login window.
  • UPDATE Updating PDF documentation.

New in Lemon 0.9.1 (Feb 10, 2010)

  • BUGFIX : Allow to sell more items than in the stock.
  • BUGFIX : Comments on lemon_mysql.sql script where fixed.
  • Improvement : Refreshed the splash screen and loginBackground images. Created new ones on other resolutions.
  • Improvement : Updated Spanish Translation. Added Feature: Sales Taxes are shown on screen and printed on tickets.
  • Script to upgrade from 0.9 database to 0.9.1 [ fix_0.9.sql ]

New in Lemon 0.9 (Jan 24, 2010)

  • BUGFIX: The weird crash is gone.
  • BUGFIX: Availability check when incrementing a product on the list
  • BUGFIX: Invalid Transaction's providerid caused not to be shown on squeeze. Fixed with the db script (fix and new)
  • BUGFIX: Added a check for payment amount. The user by mistake can enter a barcode there.
  • BUGFIX: Security procedures reviewd and improved. Some bugs caused malfunction of low security mode.
  • BUGFIX: Product code input not accepted when qty starts with 0, for example 0.5x123456 .
  • BUGFIX: Pie chart removed and replaced by a plot and labels.
  • BUGFIX: Balance do not force login. Now balance = login. A balance does the balance and force login.
  • Improvement: Allow to remove items from the purchase list (check-in).
  • Improvement: Disable Drawer openning when using a CUPS driver printer. CUPS-printer can open it each time it prints.
  • Improvement: Print Client name and id on ticket when a client is selected.
  • Improvement: Cash-in/Cash-out needs authorization (ask for password when not in a low security mode).
  • Improvement: Squeeze has a populated menu bar. Removed the left buttons-menu, replaced by toolbar buttons.
  • Improvement: Some dialogs where redesigned. Product Editor...
  • Improvement: Some new fancy message ballons, floating bars and dialogs were added. They are animated.
  • Improvement: Added cash-out/cash-in information on printed balances.
  • Improvement: A shortcut key '+' is added to the product code inputbox for going to payment amount inputbox.
  • Added Feature: Correcting Stock. This is to track stock changes. On product editor, in order to change stockqty, it must be corrected.
  • Added Feature: Printing using CUPS printers. Now tickets looks elegant on thermal printers. Two modes for this: big and small.
  • Added Feature: LOGS on Administrative task. This are keept on database.
  • Added Feature: User ROLES. Now is possible to have many administrators and supervisors.
  • Added Feature: Added a config option for the ticket time on screen. it also can be closed by pressing 'ESC' key.
  • Added Feature: New kind of products: Raw Products, Group Products. Raw are for custom/special orders.
  • Added feature: Product GROUOPS/PACKS. An article can be a group, its stockqty is not used for anything, instead its contents stockqty.
  • Added feature: Special Orders. Custom Products to be 'manufactured'. Like a cake or a custom computer..
  • If a special order is completely paid when ordering, when completing the order [delivered] it will not generate a ticket.
  • Added feature: On Special Orders, the order is printed in addintion to the ticket.
  • Added feature: The user can change Special Order's status.
  • Added feature: New Printed Reports on Squeeze: Balances, Sales, End of day, General end of day, End of month, Low stock products, Sold out products.
  • Added Feature: Ticket Messages based on the date.
  • Added Feature: New way of applying a discount. Occassional discount: this cannot coexists with client discount (client discount will be ignored)
  • Added Feature: Lock Screen. To let the user take breaks.
  • Added Feature: Suspend and Resume sales. To let the user start a new sale without loosing the current sale.
  • Added Feature: Some config options in lemon are saved on database to share it with squeeze.
  • Added Feature: A config option to do not print GROUP contents on the ticket.

New in Lemon 0.8 (May 21, 2009)

  • Lemon:
  • Bug fix : Do not ask admin password for product deletion from buy list was not working. fixed. Reported by Vitali Kari.
  • Bug fixed: Crash when doing some change at configuration. This crash is weird. It appears kubuntu 8.10 with kde 4.1.4 is not affected.
  • Fixed by not applying settings related to database. So a restart for lemon is requiered after a configuration change.
  • Bug fixed: Cancelling tickets with non-empty buy list crash lemon. Now also the transaction number is reused when cancelling a not completed sale.
  • Bug fixed: Discount amount bad calculated after the 'localeForPrinting' and new entering mode (10x1001101) stuff!
  • Bug fixed: Qty on printed/saved tickets is rounded, because used int instead of double field for qty in TicketLineInfo.
  • Bug Fix : Missing update disc and discmoney on transactions when discount for client. http://apps.sourceforge.net/trac/lemonpos/ticket/56
  • Bug Fix : Profit calculation fixed when using client discount. http://apps.sourceforge.net/trac/lemonpos/ticket/56
  • Added feature: View cash available in drawer.
  • Added feature: Printed End of day report (or exportable to PDF).
  • Added feature: You can choose: Printed big receipt (on normal printers, A4,Letter.. papers) or small tickets as before.
  • Added feature: Cash-In To deposit money into the drawer -need more change-.
  • Added feature: Adding a progressive search in a combobox in the grid-view-filter-by-name. Contributed by Biel Frontera.
  • Added feature: Adding a progressive search in the search panel.
  • Improvement : Adding alert for cashout exceding amount in cash drawer and missing reason.
  • Improvements : Adding a configuration option for balances printing.
  • Improvements : Now ticket Cancellation works. http://apps.sourceforge.net/trac/lemonpos/ticket/4
  • Improvement : Allow ZERO on due. Save a negative profit. This is a requested feature : http://apps.sourceforge.net/trac/lemonpos/ticket/52
  • Change : Allow enter ZERO money in drawer at startOperations.
  • Change : Changing Branch stuff to Store Address and Phone for storing that data -or other-. Data used in the printed reports.
  • Squeeze:
  • Bug Fix : Product editor closes when pressing enter in the code inputbox, allowing creation of empty products. Bug reported by Vitali Kari.
  • Bug Fix : Remove all offers when deleting a product with more than one offer.
  • Improvement : Changed label of new product dialog from "Stock Qty" to "Purchase Qty".
  • Added feature: 3 new filters for transactions (show only sales, show only purchases, show only changes and returns).
  • Added feature: Configuration option to select which product view is used (list/grid).
  • Added feature: Export data to csv file (products,clients,users,balances,transactions...) -Code by Biel Frontera-

New in Lemon 0.7.3 (Apr 5, 2009)

  • Bug fix : Do not ask admin password for product deletion from buy list was not working. fixed. Reported by Vitali Kari.
  • Change : Allow enter ZERO money in drawer at startOperations.
  • Bug Fix : Product editor closes when pressing enter in the code inputbox, allowing creation of empty products. Bug reported by Vitali Kari.

New in Lemon 0.7.2 (Mar 31, 2009)

  • Added 3 new filter for transactions: only sells, only purchases, only returns/changes
  • Fixed a bug related to purhcases/returns transactions. Transactions with non-existent clientid were hidden from squeeze.
  • Added german translation, thanks to Vitali Kari. - Partially pt_BR translation.

New in Lemon 0.7.1 (Mar 24, 2009)

  • Bug Fix : A missing insert at the upgrade script. This fixes the disapearing newly created products. Created a fix script for 0.7 version [fix_0.7.sql]

New in Lemon 0.7 (Mar 10, 2009)

  • An error in the lemon_mysql.sql script was fixed.
  • The database name was changed from 'lemondb' to 'lemontest'
  • The SVN has not been affected.
  • There were also new features and other bugfixes.

New in Lemon 0.6.1 (Feb 3, 2009)

  • Fixing ids for transaction states, and code related.
  • Hotest new stuff:
  • Qick-View Plot reports [Welcome screen Quick Information]. Just information on sales, profit, most sold products and low stock.
  • Transactions and Balances table viewer (Without filters).
  • General
  • Introducing the new azahar class to provide all database access.
  • Code cleaning completed (generating the new azahar class).
  • New offers system, with date start and date end.
  • Created three new icons (categories, offers, price-checker).
  • Low security mode.
  • Azahar code improved (removed some for/while unnecessary loops, some missing values when updating data). Thanks to Biel Frontera from Spain, whom found the bugs and sent me the patches.
  • Adding terminalnumber field for balances.
  • Squeeze:
  • BUG FIX: Newly created categories not appearing in products filter's combobox.
  • BUG FIX: Categories now can be deleted.
  • New filters for products (offers dates by diferent ways).
  • Graphic bar for discounted percentage of a product at the offers' table view.
  • A purchase action, to check-in stock purchases.
  • Qick-View Plot/pie-chart reports [Welcome screen Qick Information]. Just information on sales, profit, most sold products and low stock.
  • This may have some bugs (in fact, it has).
  • Added login.
  • Added style support.
  • Implemented a new left menu bar.
  • Changed the way to insert a category.
  • Changed the way to insert a weight or measure.
  • Spanish Translation (es.po) Updated.
  • Low Stock Alert min and max values (used for piechart for now).
  • Added one more filter for Products (almost sold-out items).
  • Added viewing product list as grid/table at your option. This for better view when filtering.
  • Added basic Transactions table-viewer (just a list with transactions, with filters)
  • Added basic Balances table-viewer (just a list with balances, no filters yet)
  • Lemon:
  • BUG FIX: now lemon stores sold units and date last sold at each sale.
  • BUG FIX: A workaround for the oxygen bug for login/password dialog.
  • BUG FIX: automatic showGridView button' checked state is now working as expected.
  • BUG FIX: ticket# validator When cancelling a ticket let enter no other than 0's.
  • BUG FIX: Disabled action "Start Operation" even if action is cancelled by te user. This prevented to start operations.
  • BUG FIX: An issue was detected when testing with KDE 4.2, ticket dialog was not shown.
  • Spanish Translation (es.po) updated.
  • Improved loginwindow appearance, changed password dialog background.
  • Improved login background, including lemon version.
  • Added and themed a Price Checker for consulting product prices without adding to the list.
  • Low Stock Alert min and max values (used at search)
  • Low security mode (do not ask passwords).
  • Saving balances on quit.
  • Saving terminal number of each balance.
  • Adding a configuration option for the time showing the ticket dialog on screen.
  • Database:
  • Removed old sample data.
  • Added database creation script to the instalation, installed in /usr/share/apps/lemon/
  • or /usr/local/share/apps/lemon/ depending on your system and configuration;
  • This will help ubuntu package's users
  • Added terminalnum flied to balances table (of course to database creation script).
  • Adding new tables to save strings for pay-types, transactions-types, transactions-states.
  • Adding an upgrade script, to upgrade your database from 0.5 to 0.6 version of lemon POS.

New in Lemon 0.6 (Jan 30, 2009)

  • Hotest new stuff:
  • Qick-View Plot reports [Welcome screen Quick Information]. Just information on sales, profit, most sold products and low stock.
  • Transactions and Balances table viewer (Without filters).
  • General:
  • Introducing the new azahar class to provide all database access.
  • Code cleaning completed (generating the new azahar class).
  • New offers system, with date start and date end.
  • Created three new icons (categories, offers, price-checker).
  • Low security mode.
  • Azahar code improved (removed some for/while unnecessary loops, some missing values when updating data). Thanks to Biel Frontera from Spain, whom found the bugs and sent me the patches.
  • Adding terminalnumber field for balances.
  • Squeeze:
  • BUG FIX: Newly created categories not appearing in products filter's combobox.
  • BUG FIX: Categories now can be deleted.
  • New filters for products (offers dates by diferent ways).
  • Graphic bar for discounted percentage of a product at the offers' table view.
  • A purchase action, to check-in stock purchases.
  • Qick-View Plot/pie-chart reports [Welcome screen Qick Information]. Just information on sales, profit, most sold products and low stock.
  • This may have some bugs (in fact, it has).
  • Added login.
  • Added style support.
  • Implemented a new left menu bar.
  • Changed the way to insert a category.
  • Changed the way to insert a weight or measure.
  • Spanish Translation (es.po) Updated.
  • Low Stock Alert min and max values (used for piechart for now).
  • Added one more filter for Products (almost sold-out items).
  • Added viewing product list as grid/table at your option. This for better view when filtering.
  • Added basic Transactions table-viewer (just a list with transactions, with filters)
  • Added basic Balances table-viewer (just a list with balances, no filters yet)
  • Lemon:
  • BUG FIX: now lemon stores sold units and date last sold at each sale.
  • BUG FIX: A workaround for the oxygen bug for login/password dialog.
  • BUG FIX: automatic showGridView button' checked state is now working as expected.
  • BUG FIX: ticket# validator When cancelling a ticket let enter no other than 0's.
  • BUG FIX: Disabled action "Start Operation" even if action is cancelled by te user. This prevented to start operations.
  • BUG FIX: An issue was detected when testing with KDE 4.2, ticket dialog was not shown.
  • Spanish Translation (es.po) updated.
  • Improved loginwindow appearance, changed password dialog background.
  • Improved login background, including lemon version.
  • Added and themed a Price Checker for consulting product prices without adding to the list.
  • Low Stock Alert min and max values (used at search)
  • Low security mode (do not ask passwords).
  • Saving balances on quit.
  • Saving terminal number of each balance.
  • Adding a configuration option for the time showing the ticket dialog on screen.
  • Database:
  • Removed old sample data.
  • Added database creation script to the instalation, installed in /usr/share/apps/lemon/
  • or /usr/local/share/apps/lemon/ depending on your system and configuration;
  • This will help ubuntu package's users
  • Added terminalnum flied to balances table (of course to database creation script).
  • Adding new tables to save strings for pay-types, transactions-types, transactions-states.
  • Adding an upgrade script, to upgrade your database from 0.5 to 0.6 version of lemon POS.