CHANGELOG.txt

   1 /**
   2 * @version $Id$
   3 * @package FrontAccounting
   4 * @copyright (C) 2005 - 2008 FrontAccounting
   5 * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
   6 * FrontAccounting is Free Software
   7 */
   8
   9 1. Changelog
  10 ------------
  11 This is a changelog for FrontAccounting All releases.
  12
  13 Legend:
  14
  15 # -> Bug Fix
  16 + -> Addition
  17 ! -> Change
  18 - -> Removed
  19 ! -> Note
  20 $ -> Affected files
  21
  22 27-Mar-2008 Janusz Dobrowolski
  23 + Automatic first field focus on page start, focus order preserved between form updates
  24 $  /gl/inquiry/gl_account_inquiry.php
  25    /includes/page/footer.inc
  26    /includes/ui/ui_controls.inc
  27    /includes/ui/ui_input.inc
  28    /includes/ui/ui_lists.inc
  29    /includes/ui/ui_view.inc
  30    /js/inserts.js
  31    /sales/sales_order_entry.php
  32    /ales/credit_note_entry.php
  33    /ales/includes/ui/sales_credit_ui.inc
  34    /sales/includes/ui/sales_order_ui.inc
  35 + Data picker omitted in keyboard tabbing sequence (FF,IE, not old mozilla)
  36 $  /includes/ui/ui_input.inc
  37 ! Javascript recalcAccount() superseded by class='combo' behaviour binding
  38 $  /gl/gl_deposit.php
  39    /gl/gl_journal.php
  40    /gl/gl_payment.php
  41    /gl/includes/ui/gl_deposit_ui.inc
  42    /gl/includes/ui/gl_journal_ui.inc
  43    /gl/includes/ui/gl_payment_ui.inc
  44    /includes/ui/ui_view.inc
  45    /purchasing/po_entry_items.php
  46    /purchasing/includes/ui/po_ui.inc
  47    /sales/sales_order_entry.php
  48    /sales/includes/ui/sales_credit_ui.inc
  49    /sales/includes/ui/sales_order_ui.inc
  50    /js/inserts.js
  51 ! get_js_set_focus moved from ui_view (this is only standalone form).
  52    /update_db.php
  53 # Fixed debit/credit entry check
  54 $  /gl/gl_journal.php
  55 # Restored GET/POST security check on path_to_root
  56 $  /config.php
  57
  58 26-Mar-2008 Janusz Dobrowolski
  59 # Bug fixes in purchase module related to tax structure changes.
  60 $  /purchasing/includes/supp_trans_class.inc
  61    /purchasing/includes/db/invoice_db.inc
  62    /purchasing/includes/db/invoice_items_db.inc
  63    /purchasing/includes/ui/invoice_ui.inc
  64    /reporting/rep105.php
  65
  66 25-Mar-2008 Janusz Dobrowolski
  67 ! Per company pdf, backup and graphics directories in 'company' dir.
  68 $  /company (new dir)
  69    /company/0 (new dir)
  70    /company/0/images/ (new dir)
  71    /company/0/images/102.jpg    (moved from inventory/manage/image)
  72    /company/0/images/103.jpg    (moved from inventory/manage/image)
  73    /company/0/images/104.jpg    (moved from inventory/manage/image)
  74    /company/0/images/logo_frontaccounting.jpg   (moved from themes/default/images)
  75    /company/0/images/logo_frontaccounting.png   (moved from themes/default/images)
  76    /admin/backups.php
  77    /admin/create_coy.php
  78    /admin/db/maintenance_db.inc
  79    /install/index.php
  80    /reporting/rep102.php
  81    /reporting/rep104.php
  82    /reporting/rep202.php
  83    /reporting/rep303.php
  84    /reporting/rep706.php
  85    /reporting/rep707.php
  86    /reporting/includes/pdf_report.inc
  87    /inventory/manage/items.php
  88
  89 + jscript component caching (enables browser caching and future compression)
  90 $  /includes/session.inc
  91    /includes/main.inc
  92    /includes/page/header.inc
  93    /includes/ui/ui_view.inc
  94    /admin/display_prefs.php
  95    /config.php
  96
  97 - Removed obsolete file
  98 $  /sales/includes/ui/print_invoice.inc
  99
 100 21-Mar-2008 Janusz Dobrowolski
 101 ! Total Allocation/Left to Allocate update without page submit.
 102 $  /includes/ui/ui_view.inc
 103    /purchasing/allocations/supplier_allocate.php
 104    /sales/allocations/customer_allocate.php
 105 # Fixed unvisable under IE editbutton
 106 $  /themes/aqua/default.css
 107    /themes/cool/default.css
 108    /themes/default/default.css
 109
 110 20-Mar-2008 Janusz Dobrowolski
 111 # Excluding delivery notes from Customer Balances, removed warnings.
 112 $  /reporting/rep101.php
 113 # Divide by zero fix on order_price==0 in new supplier invoice
 114 $  /purchasing/supplier_invoice_grns.php
 115 # Database bug fix in new customer entry
 116 $  /sales/manage/customers.php
 117 # Small bug fix (warnings) in is_date() function.
 118 $  /includes/date_functions.inc
 119
 120 18-Mar-2008 Janusz Dobrowolski
 121 # Line items editor uses POST method - no disappearing shippment info.
 122 $  /sales/credit_note_entry.php
 123    /sales/sales_order_entry.php
 124    /sales/includes/ui/sales_credit_ui.inc
 125    /sales/includes/ui/sales_order_ui.inc
 126 + Added edit_button_cell() function
 127 $  /includes/ui/ui_controls.inc
 128 + Helper function for finding indexed submit $_POST vars.
 129 $  /includes/ui/ui_input.inc
 130 + New class .editbutton for buttons. Default view is link alike.
 131 $  /themes/aqua/default.css
 132    /themes/cool/default.css
 133    /themes/default/default.css
 134
 135 17-Mar-2008 Janusz Dobrowolski
 136 # Added rounding when needed to avoid document non cosistent documents.
 137 $  /includes/banking.inc
 138    /purchasing/supplier_credit_grns.php
 139    /purchasing/supplier_invoice_grns.php
 140    /purchasing/includes/supp_trans_class.inc
 141    /purchasing/includes/ui/invoice_ui.inc
 142    /purchasing/includes/ui/po_ui.inc
 143    /reporting/rep107.php
 144    /reporting/rep109.php
 145    /reporting/rep110.php
 146    /reporting/rep209.php
 147    /sales/includes/cart_class.inc
 148    /sales/includes/ui/sales_credit_ui.inc
 149    /sales/includes/ui/sales_order_ui.inc
 150    /sales/view/view_credit.php
 151    /sales/view/view_dispatch.php
 152    /sales/view/view_invoice.php
 153    /sales/view/view_sales_order.php
 154    /taxes/tax_calc.inc
 155 # Sign bug for customer transactions
 156 $  /reporting/rep709.php
 157 # Include file conflict fix
 158 $ /purchasing/includes/ui/invoice_ui.inc
 159   /gl/manage/bank_accounts.php
 160   /manufacturing/inquiry/where_used_inquiry.php
 161   /purchasing/manage/suppliers.php
 162
 163 16-Mar-2008 Janusz Dobrowolski
 164 + Added javascript add-on for unobtrusive apply javascript handlers to html elements.
 165 $  /js/behaviour.js
 166    /js/inserts.js
 167 + Added javascript source collecting functions
 168 $  /includes/main.inc
 169 ! Moved check_page_security(); for safe start in case of broken wa_current_user var.
 170 + Added global js code collecting arrays  $js_lib, $js_static
 171 $  /includes/session.inc
 172 ! Changed get_js_user num to add_js_user_num; extended for percent/qty/price formatting
 173 $  /includes/ui/ui_view.inc
 174 + Added including javascript source colections from $js_lib, $js_static; conditional display for ajax calls
 175 $  /includes/page/footer.inc
 176    /includes/page/header.inc
 177 ! Added including of data_checks.inc
 178 $  /includes/ui.inc
 179 + User side percent/exrate/qty/price input formatting via onblur handler.
 180 $  /admin/gl_setup.php
 181    /gl/gl_budget.php
 182    /gl/manage/exchange_rates.php
 183    /includes/ui/ui_input.inc
 184    /inventory/purchasing_data.php
 185    /inventory/reorder_level.php
 186    /inventory/includes/item_adjustments_ui.inc
 187    /inventory/includes/stock_transfers_ui.inc
 188    /manufacturing/work_order_entry.php
 189    /manufacturing/manage/bom_edit.php
 190    /purchasing/po_entry_items.php
 191    /purchasing/po_receive_items.php
 192    /purchasing/supplier_credit.php
 193    /purchasing/supplier_credit_grns.php
 194    /purchasing/supplier_invoice_grns.php
 195    /purchasing/supplier_trans_gl.php
 196    /purchasing/allocations/supplier_allocate.php
 197    /purchasing/includes/ui/po_ui.inc
 198    /sales/customer_delivery.php
 199    /sales/customer_invoice.php
 200    /sales/allocations/customer_allocate.php
 201    /sales/includes/ui/sales_credit_ui.inc
 202    /sales/includes/ui/sales_order_ui.inc
 203    /taxes/tax_groups.php
 204    /taxes/tax_types.php
 205
 206 14-Mar-2008 Janusz Dobrowolski
 207  + All forms fixed to accept user native numeric format.
 208  $ /admin/gl_setup.php
 209    /gl/bank_transfer.php
 210    /gl/gl_budget.php
 211    /gl/gl_deposit.php
 212    /gl/gl_journal.php
 213    /gl/gl_payment.php
 214    /gl/includes/db/gl_db_banking.inc
 215    /gl/includes/ui/gl_deposit_ui.inc
 216    /gl/includes/ui/gl_journal_ui.inc
 217    /gl/includes/ui/gl_payment_ui.inc
 218    /gl/manage/exchange_rates.php
 219    /inventory/adjustments.php
 220    /inventory/cost_update.php
 221    /inventory/prices.php
 222    /inventory/purchasing_data.php
 223    /inventory/reorder_level.php
 224    /inventory/transfers.php
 225    /inventory/includes/item_adjustments_ui.inc
 226    /inventory/includes/stock_transfers_ui.inc
 227    /inventory/manage/item_units.php
 228    /manufacturing/work_order_entry.php
 229    /manufacturing/inquiry/where_used_inquiry.php
 230    /manufacturing/manage/bom_edit.php
 231    /purchasing/po_entry_items.php
 232    /purchasing/po_receive_items.php
 233    /purchasing/supplier_credit_grns.php
 234    /purchasing/supplier_invoice_grns.php
 235    /purchasing/supplier_payment.php
 236    /purchasing/supplier_trans_gl.php
 237    /purchasing/allocations/supplier_allocate.php
 238    /purchasing/includes/ui/po_ui.inc
 239    /purchasing/inquiry/po_search.php
 240    /sales/credit_note_entry.php
 241    /sales/customer_credit_invoice.php
 242    /sales/customer_delivery.php
 243    /sales/customer_invoice.php
 244    /sales/customer_payments.php
 245    /sales/sales_order_entry.php
 246    /sales/allocations/customer_allocate.php
 247    /sales/includes/ui/sales_credit_ui.inc
 248    /sales/includes/ui/sales_order_ui.inc
 249    /sales/manage/customers.php
 250    /sales/manage/sales_people.php
 251    /sales/view/view_credit.php
 252    /sales/view/view_dispatch.php
 253    /sales/view/view_invoice.php
 254    /sales/view/view_receipt.php
 255    /sales/view/view_sales_order.php
 256    /taxes/item_tax_types.php
 257    /taxes/tax_groups.php
 258    /taxes/tax_types.php
 259  + User format functions for percent/price/exrate amounts display.
 260  $ /includes/current_user.inc
 261  + Input checking functions for numeric input fields in user native format
 262  $ /includes/data_checks.inc
 263  + Numeric input fields in user native format
 264  $ /includes/ui/ui_input.inc
 265  + Javascript function for conversion to/from user native numeric format.
 266  $ /includes/ui/ui_view.inc
 267  + New class amount for numeric input
 268  $ /themes/aqua/default.css
 269    /themes/cool/default.css
 270    /themes/default/default.css
 271  # Removed warning on adding component
 272    /manufacturing/manage/bom_edit.php
 273  # Quantity display correction
 274    /manufacturing/inquiry/where_used_inquiry.php
 275  # Fixed add_customer_trans() call
 276    /gl/includes/db/gl_db_banking.inc
 277
 278 12-Mar-2008 Joe Hung
 279  + Added update of Units of Measure and converting of deptor_trans records from release 1.XX
 280  - Removed default insertion of Units of Measure. Not neccessary.
 281  $ /sql/alter.sql
 282    /admin/db/maintenance_db.inc (added support for update)
 283
 284 11-Mar-2008 Janusz Dobrowolski
 285  + Table of measure moved into new table item_units
 286  ! Removed $themes[] from config.php, theme list based on directory structure
 287  $ /config.php
 288    /includes/ui/ui_lists.inc
 289    /applications/inventory.php
 290    /inventory/includes/inventory_db.inc
 291    /inventory/includes/db/items_units_db.inc
 292    /inventory/manage/item_units.php
 293    /inventory/manage/items.php
 294    /sql/alter.sql
 295
 296 11-Mar-2008 Joe Hunt
 297  # Small fix for alignment of date and due date label fields in customer_invoice.php and customer_delivery.php
 298  $ /sales/customer_invoice.php
 299    /sales/customer_delivery.php
 300
 301 10-Mar-2008 Joe Hunt
 302  # Small fix for Template Invoice in sales_order_entry.php on line 363 (duedate for Invoice).
 303  $ /sales/sales_order_entry.php
 304
 305 10-Mar-2008 Janusz Dobrowolski
 306  + Added price list selector to sales entry (debtor_master gives only default one)
 307  + Added optional submit_on_change parameter to sales ui lists
 308  $ /includes/ui/ui_lists.inc
 309    /sales/sales_order_entry.php
 310    /sales/includes/ui/sales_credit_ui.inc
 311    /sales/includes/ui/sales_order_ui.inc
 312  # Additional PHP5 fixes, do_clone superseded by local ? : constructs
 313  $ /sales/includes/cart_class.inc
 314    /includes/ui/ui_view.inc
 315    /sales/includes/sales_db.inc
 316  # Fixed bogus sales_type lists in edition mode
 317  $ /sales/customer_delivery.php
 318    /sales/customer_invoice.php
 319  # Smaller fixes, cart_class.sales_type name change
 320  $ /sales/includes/ui/sales_credit_db.inc
 321    /sales/credit_note_entry.php
 322    /sales/customer_credit_invoice.php
 323    /sales/includes/cart_class.inc
 324    /sales/includes/db/sales_credit_db.inc
 325    /sales/includes/db/sales_delivery_db.inc
 326    /sales/includes/db/sales_invoice_db.inc
 327    /sales/includes/db/sales_order_db.inc
 328    /sales/includes/ui/sales_credit_ui.inc
 329  # One another pmWiki name conflict removed
 330  $ /admin/display_prefs.php
 331
 332 09-Mar-2008 Joe Hunt
 333  - Removed redundant form_types functions and the file /reporting/includes/form_types.inc. Removed table form_items
 334  $ /dimensions/includes/dimensions_db.inc
 335    /gl/includes/db/gl_db_banking.inc
 336    /includes/main.inc
 337    /inventory/includes/db/items_adjust_db.inc
 338    /manufacturing/includes/db/work_order_issues_db.inc
 339    /manufacturing/includes/db/work_order_produce_items_db.inc
 340    /manufacturing/includes/db/work_orders_db.inc
 341    /manufacturing/includes/db/work_orders_quick_db.inc
 342    /purchasing/includes/db/grn_db.inc
 343    /purchasing/includes/db/po_db.inc
 344    /purchasing/includes/db/supp_payment_db.inc
 345    /reporting/includes/form_types.inc (File removed)
 346    /sales/includes/db/sales_delivery_db.inc
 347    /sales/includes/db/sales_invoice_db.inc
 348    /sales/includes/db/sales_order_db.inc
 349    /sql/alter.sql
 350  # Bug in calculating exchange rates in Reports Supplier Balances and Customer Balances
 351  $ /reporting/rep101.php
 352    /reporting/rep201.php
 353  # clone replacement do_clone() for both PHP 4 and PHP 5.
 354  $ /includes/ui/ui_view.inc (at the very bottom)
 355    /sales/includes/cart_class.inc
 356
 357 07-Mar-2008 Janusz Dobrowolski
 358  ! Changed name tax type uniqueness constraint to (name, rate)
 359  $ /includes/ui/ui_lists.inc
 360    /taxes/items_tax_types.php
 361  ! Tax included option moved from tax_group to sales_types table
 362  $ includes/ui/ui_view.inc
 363    /purchasing/includes/ui/invoice_ui.inc
 364    /taxes/tax_calc.inc
 365    /taxes/tax_groups.php
 366    /taxes/db/tax_groups_db.inc
 367    /sql/alter.sql
 368  # Final rewriting of sales module, a lot of bugfixes.
 369  + Template delivery/invoicing
 370  + Concurrent document editing control on sql level
 371  + Most of sales documents are now editable
 372  + Some links to print documents after entry
 373  ! Changed javascript helper function for customer allocations
 374  $ /applications/customers.php
 375    /includes/ui/ui_input.inc
 376    /reporting/rep107.php
 377    /reporting/rep109.php
 378    /reporting/rep110.php
 379    /sales/credit_note_entry.php
 380    /sales/customer_credit_invoice.php
 381    /sales/customer_delivery.php
 382    /sales/customer_invoice.php
 383    /sales/customer_payments.php
 384    /sales/sales_order_entry.php
 385    /sales/allocations/customer_allocate.php
 386    /sales/allocations/customer_allocation_main.php
 387    /sales/includes/cart_class.inc
 388    /sales/includes/sales_db.inc
 389    /sales/includes/sales_ui.inc
 390    /sales/includes/db/cust_trans_db.inc
 391    /sales/includes/db/cust_trans_details_db.inc
 392    /sales/includes/db/custalloc_db.inc
 393    /sales/includes/db/customers_db.inc
 394    /sales/includes/db/payment_db.inc
 395    /sales/includes/db/sales_credit_db.inc
 396    /sales/includes/db/sales_delivery_db.inc
 397    /sales/includes/db/sales_invoice_db.inc
 398    /sales/includes/db/sales_order_db.inc
 399    /sales/includes/db/sales_types_db.inc
 400    /sales/includes/ui/print_invoice.inc
 401    /sales/includes/ui/sales_credit_ui.inc
 402    /sales/includes/ui/sales_order_ui.inc
 403    /sales/inquiry/customer_allocation_inquiry.php
 404    /sales/inquiry/customer_inquiry.php
 405    /sales/inquiry/sales_deliveries_view.php
 406    /sales/inquiry/sales_orders_view.php
 407    /sales/manage/credit_status.php
 408    /sales/manage/sales_types.php
 409    /sales/view/view_credit.php
 410    /sales/view/view_dispatch.php
 411    /sales/view/view_invoice.php
 412    /sales/view/view_receipt.php
 413    /sales/view/view_sales_order.php
 414 # Removed function name conflict with wiki help system
 415    /includes/lang/language.php
 416
 417 06-Mar-2008 Janusz Dobrowolski
 418  + Wiki help links integration
 419  $ /config.php
 420    /includes/page/header.inc
 421    /includes/lang/language.php
 422  + Optional debuging with xdebug module
 423  $ /index.php
 424    /includes/db/connect_db.inc
 425  ! Concurrent edition fix
 426  $  /includes/systypes.inc
 427  # Table header fix
 428  $  /manufacturing/manage/bom_edit.php
 429  # Menu layout fixes
 430  $ /themes/aqua/renderer.php
 431    /themes/cool/renderer.php
 432    /themes/default/renderer.php
 433  # Removed warning about nonexistent $_GET variable
 434  $ /dimensions/inquiry/search_dimensions.php
 435  # MySQL 3.xx CAST bug fix
 436  $ /includes/db/manufacturing_db.inc
 437    /manufacturing/includes/db/work_order_requirements_db.inc
 438    /manufacturing/inquiry/where_used_inquiry.php
 439
 440 04-Mar-2008 Joe Hunt
 441  ! Changed so that average item material price is automatic updated whenever a PO Delivery is received.
 442    Changed so that a Bill of Materiel, Parent's material price, is automatic updated from underlying items.
 443  $ /inventory/cost_update.php
 444    /purchasing/includes/db/grn_db.inc and
 445    /manufacturing/manage/bom_edit.php.
 446    /manufacturing/includes/db/work_orders_db.inc
 447    /manufacturing/includes/db/work_orders_quick_db.inc
 448    /manufacturing/work_order_entry.php
 449
 450 21-Feb-2008 Joe Hunt
 451  + Added Print for documents in /admin/view_print_transaction.php (according to our new routines).
 452  $ /admin/view_print_transaction.php
 453    /applications/setup.php
 454
 455 17-Feb-2008 Joe Hunt
 456  ! Minor change in menu and function in view_print_transaction.php
 457  $ /admin/view_print_transaction.php
 458    /application/setup.php
 459  + Preparing for print of single documents
 460  $ /reporting/includes/reporting.inc
 461  ! Removing 'out' field in table tax_types
 462  $ /sql/alter.sql
 463    /taxes/tax_types.php
 464    /taxes/db/tax_types_db.inc
 465  + Added 2 functions in ui_input.inc, button and button_cell
 466    /includes/ui/ui_input.inc
 467
 468 11-Feb-2008 Joe Hunt
 469  + Added file, update_db.php, for updating company databases from an SQL script.
 470  $ update_db.php (New file)
 471    update.html
 472
 473 06-Fef-2008 Joe Hunt
 474  + Added Report, Salesman Listing, rep106.php.
 475  $ /reporting/reports_main.php
 476    /reporting/rep106.php
 477
 478 06-Feb-2008 Janusz Dobrowolski
 479  + Separation of customer invoice issue and goods delivery.
 480  + Batch invoicing for more than one delivery
 481  # Corrected inadequate shipping tax calculations.
 482  ! Default debugging status changed to off.
 483  $ /taxes/tax_calc.inc
 484    /taxes/db/tax_groups_db.inc
 485    /admin/db/voiding_db.inc
 486    /applications/customers.php
 487    /includes/systypes.inc
 488    /includes/types.inc
 489    /includes/ui/ui_controls.inc
 490    /includes/ui/ui_lists.inc
 491    /includes/ui/ui_view.inc
 492    /inventory/inquiry/stock_status.php
 493    /reporting/rep105.php
 494    /reporting/rep107.php
 495    /reporting/rep109.php
 496    /reporting/rep110.php
 497    /reporting/rep209.php
 498    /reporting/reports_main.php
 499    /reporting/includes/doctext.inc
 500    /reporting/includes/doctext2.inc
 501    /reporting/includes/form_types.inc
 502    /reporting/includes/pdf_report.inc
 503    /reporting/includes/reports_classes.inc
 504    /sales/customer_credit_invoice.php
 505    /sales/customer_invoice.php
 506    /sales/sales_order_entry.php
 507    /sales/customer_delivery.php
 508    /sales/includes/db/sales_delivery_db.inc
 509    /sales/includes/ui/print_invoice.inc
 510    /sales/includes/cart_class.inc
 511    /sales/includes/sales_db.inc
 512    /sales/includes/db/cust_trans_db.inc
 513    /sales/includes/db/cust_trans_details_db.inc
 514    /sales/includes/db/sales_credit_db.inc
 515    /sales/includes/db/sales_invoice_db.inc
 516    /sales/includes/db/sales_order_db.inc
 517    /sales/includes/ui/sales_order_ui.inc
 518    /sales/inquiry/customer_allocation_inquiry.php
 519    /sales/inquiry/customer_inquiry.php
 520    /sales/inquiry/sales_orders_view.php
 521    /sales/inquiry/sales_deliveries_view.php
 522    /sales/view/view_dispatch.php
 523    /sales/view/view_invoice.php
 524    /sales/view/view_sales_order.php
 525    /sql/alter.sql
 526    config.php
 527
 528 01-Feb-2008 Joe Hunt
 529  ! Changed so sales orders can have more than one row with the same stock_id. In alter.sql.
 530  $ /sales/includes/cart_class.inc
 531    /sales/includes/db/sales_credit_db.inc
 532    /sales/includes/db/sales_invoice_db.inc
 533    /sales/includes/db/sales_order_db.inc
 534    /sales/includes/db/cust_trans_details_db.inc
 535    /sales/includes/ui/sales_order_ui.inc
 536    /sales/includes/ui/sales_credit_ui.inc
 537    /sales/credit_note_entry.php
 538    /sales/customer_credit_invoice.php
 539    /sales/sales_order_entry.php
 540    /sales/customer_invoice.php
 541
 542 31-Jan-2008 Joe Hunt
 543  ! New Release 2.0 Pre Alpha
 544  $ config.php
 545  # Fixed a release 2 related bug in create_coy.php
 546  $ /admin/create_coy.php
 547  + An alter.sql file to use for updating databases. Until the update_db.php is ready, you can use the install/update companies
 548    and select the companies one by one and upload the alter.sql file to all companies. You can still run the release 2
 549    with these databases changes without any new files. They are coming as soon as possible.
 550  $ /sql/alter.sql (New file)
 551  # Fixed a release 2 related bug. A field in supp_trans_items were declared as integer(11). Changed to VARCHAR(11) in alter.sql
 552    and 2 related files
 553  $ /purchasing/supplier_trans_gl.php
 554    /purchasing/includes/db/invoice_items_db.inc
 555  ! Moved variables $no_item_list, $no_customer_list and $no_supplier_list in config.php to company table
 556  $ /includes/ui/ui_lists.inc
 557    /purchasing/includes/ui/po_ui.inc
 558    /sales/includes/ui/sales_order_ui.inc
 559    /admin/company_preferences.php
 560    /admin/db/company_db.inc
 561    config.php
 562  + Created 3 new fields in salesman table for provision, break point and provision2. Included in alter.sql.
 563    Update sales_people.php.Preparing for a new Salesman report with provision etc. Selected with time range. Should be very good.
 564  $ /sales/manage/sales_people.php
 565    /includes/ui/ui_input.inc
 566
 567 -------------------- 2,0 Pre Alpha - above ----------------------------
 568 31-Jan-2008 Janusz Dobrowolski
 569  # Minor bugfix in db_import()
 570  $ /admin/db/maintenance_db.inc
 571
 572 30-Jan-2008 Janusz Dobrowolski
 573  # Minor display fix in tax_types.php
 574  $ /taxes/tax_types.php
 575  ! Format cleanup on some files.
 576  $ /gl/includes/gl_db.inc
 577    /gl/includes/gl_ui.inc
 578    /applications/application.php
 579    frontaccounting.php
 580    index.php
 581
 582 -------------------- 1.16 Stable Released ----------------------
 583 28-Jan-2008 Joe Hunt
 584  + Added a possibility to replace the normal listboxes for items, customer and/or suppliers with a search box.
 585    The listboxes can only hold about 1000 items. New variables in config.php, $no_item_list, $no_customer_list
 586    and $no_supplier_list. Default is the normal behavior for all listboxes.
 587  $ /includes/ui/ui_lists.inc
 588    /sales/includes/ui/sales_orders_ui.inc
 589    /purchases/includes/ui/po_ui.inc
 590    /themes/default/images/locate.png (New file)
 591    config.php
 592
 593  + Added ALTER TABLE possibility in db_import. For future releases.
 594  $ /admin/db/maintenence_db.inc
 595
 596  # Removed warnings 'Call-time pass-by-reference' in /includes/db/connect_db.inc and /includes/ui/ui_lists.inc
 597  # Fixed File not found when loading local stylesheet.css (for other languages) in /includes/page/header.inc
 598  $ /includes/db/connect_db.inc
 599    /includes/ui/ui_lists.inc
 600    /includes/page/header.inc
 601    /access/login.php
 602
 603 16-Jan-2008 Joe Hunt
 604  # When login screen is displayed after session timeout page content is broken. It
 605    is because of NOT using absolute paths in href attribute theme elements.
 606  $ /access/login.php
 607
 608 30-Dec-2007 Joe Hunt
 609  # Minor adjustments in function db_export on line 325
 610  $ /admin/db/maintenance_db.inc
 611
 612 29-Dec-2007 Joe Hunt
 613  + Added a variable, $print_invoice_no, in config.php for printing the invoice number instead of invoice reference.
 614  $ config.php
 615
 616  # Fixed a bug when exporting database. Exported NULL field values from NO to empty field (from mysql version 5.0.32).
 617    Also fixed a unneccessary str_replace when importing sql scripts.
 618  ! Changed the PDF presentation to deleting the Javascript cache before presentation.
 619  $ /admin/db/maintenance_db.inc
 620    /reporting/includes/pdf_report.inc
 621
 622 13-Dec-2007 Joe Hunt
 623  # Still bugs in trial balances and account inquiry on screen when selecting non balance accounts. Fixed.
 624  $ /gl/inquiry/gl_trial_balance.php
 625    /gl/inquiry/gl_account_inquiry.php
 626
 627 13-Dec-2007 Joe Hunt
 628  # Fixed a bug when voiding a transaction (Journal Entry). An eventually underlying bank transfer was not voided.
 629  $ /admin/db/voiding_db.inc
 630
 631 06-Dec-2007 Joe Hunt
 632  # Fixed a bug when adding lines during Payments to suppliers, the supplier was set back to the first.
 633  $ /gl/gl_payment.php
 634    /gl/includes/ui/gl_payment_ui.inc
 635
 636  ! Changed $loc_notification to be set to 0 instead of 1.
 637  $ config.php
 638
 639 -------------------- 1.15 Stable Released ----------------------
 640 05-Dec-2007 Joe Hunt
 641  + Added email notification to stock location when available stock is below reorder level
 642  $ config.php
 643    /sales/includes/db/sales_order_db.inc
 644
 645  # Fixed bugs in Open balances when account is not a balance account
 646  $ /gl/inquiry/gl_trial_balance.php
 647    /gl/inquiry/gl_account_inquiry.php
 648    /reporting/rep704.php
 649    /reporting/rep708.php
 650
 651 -------------------- 1.14 Stable Released ----------------------
 652 01-Oct-2007 Joe Hunt
 653  ! Major change in the installation of modules to also accept an SQL-file for upload.
 654  $ config.php
 655    /admin/inst_module.php
 656    /admin/db/maintenance_db.inc
 657
 658 30-Sep-2007 Joe Hunt
 659  # The following files were still vulnerable. Fixed
 660  $ /access/login.php
 661    /includes/lang/language.php
 662
 663 -------------------- 1.13 Stable Released ----------------------
 664 14-Sep-2007 Joe Hunt
 665  + Added optional link for electronic payment on invoices (PayPal).
 666  ! Better support for install/update languages.
 667  ! Minor adjustments
 668  # Fixed a vulnerable item in config.php
 669  $ config.php
 670
 671 14-Sep-2007 Joe Hunt
 672  # We forgot to upload the PO file when installing new language. Used when GETTEXT is not installed on Server.
 673  # config.php has been vulnerable. Fixed.
 674  $ /admin/inst_lang.php
 675  $ config.php
 676
 677 10-Sep-2007 Joe Hunt
 678  ! Changed Bank Address field from text to textarea (multirows)
 679  $ /gl/manage/bank_accounts.php
 680
 681 06-Sep-2007 Joe Hunt
 682  + Added optional link for electronic payment on invoices (PayPal)
 683  $ /reporting/reports_main.php
 684    /reporting/rep107.php
 685    /reporting/includes/report_classes.inc
 686    /reporting/includes/pdf_report.inc
 687    /reporting/includes/doc_text.inc
 688    /reporting/includes/doc_text2.inc
 689
 690 23-Aug-2007 Joe Hunt
 691  # Unnecessary parameter ($db) in check_for_recursive_bom
 692  $ /manufacturing/manage/bom_edit.php
 693
 694 21-Aug-2007 Joe Hunt
 695  # Bug in /includes/lang/gettext.php (249) affecting changing language!
 696  $ /includes/lang/gettext.php
 697
 698 08-Aug-2007 Joe Hunt
 699  # Minor adjustments
 700  $ config.php
 701    /access/login.php
 702    /admin/create_coy.php
 703    /reporting/includes/pdf_report.inc
 704
 705 04-Aug-2007 Joe Hunt
 706  + Added a default fiscal year in the en_US-new.sql and start references.
 707  $ /sql/en_US-new.sql
 708  ! Changed some specific text strings in en_US.po (E.g. TAX instead of VAT)
 709  $ /lang/en_US/LC_MESSAGES/en_US.mo
 710
 711 03-Aug-2007 Joe Hunt
 712  # A bug in Direct Invoicing (wrong Invoice Date) has been fixed.
 713  $ /sales/includes/db/sales_order_db.inc
 714
 715 23-Jul-2007 Joe Hunt
 716  # Changed <? in front of 2 files to <?php.
 717  $ /purchasing/includes/purchasing_ui.inc
 718    /reporting/includes/class.mail.inc
 719
 720 -------------------- 1.12 Stable Released ----------------------
 721 21-Jul-2007 Joe Hunt
 722  + Added option to handle Jalali and Islamic Calendars
 723  ! Minor adjustments
 724  $ config.php
 725    /gl/includes/db/gl_db_trans.inc
 726    /includes/date_functions.inc
 727    /includes/ui/ui_input.inc
 728    /includes/ui/ui_lists.inc
 729    /includes/ui/ui_view.inc
 730    /purchasing/po_receive_items.php
 731    /purchasing/includes/ui/invoice_ui.inc
 732    /purchasing/includes/ui/po_ui.inc
 733    /reporting/rep705.php
 734    /sales/includes/db/sales_order_db.inc
 735    /sales/includes/ui/sales_order_ui.inc
 736
 737 20-Jul-2007 Joe Hunt
 738  ! Changed parameters on report Sales Order. Option to print as Quote.
 739  $ /reporting/reports_main.php
 740    /reporting/rep109.php
 741    /reporting/includes/pdf_report.inc
 742    /reporting/includes/doctext.inc
 743    /reporting/includes/doctext2.inc
 744
 745 19-Jul-2007 Joe Hunt
 746  + Added Budget Entry in General Ledger. Includes Dimensions.
 747  $ config.php
 748    /applications/generalledger.php
 749    /gl/gl_budget.php (New File!)
 750    /gl/includes/db/gl_db_trans.inc
 751    /includes/date_functions.inc
 752    /reporting/report_classes.inc
 753
 754 -------------------- 1.11 Stable Released ----------------------
 755 04-Jul-2007 Joe Hunt
 756  ! Option for using alpha numeric chart of accounts.
 757  $ config.php
 758    /gl/manage/gl_accounts.php
 759    /gl/includes/db/gl_db_accounts.inc
 760    /gl/includes/db/gl_db_bank_trans.inc
 761    /gl/includes/db/gl_db_trans.inc
 762    /gl/inquiry/gl_trial_balance.inc
 763    /admin/db/company_db.inc
 764    /inventory/includes/db/items_db.inc
 765    /sales/manage/customer_branches.inc
 766
 767 04-Jul-2007 Joe Hunt
 768  # Problems retrieving language texts for poEdit in long javascripts
 769  $ /includes/ui/ui_view.inc
 770
 771 04-May-2007 Joe Hunt
 772  # Database error when updating more than one item row in Sales Orders.
 773  $ /sales/includes/db/sales_order_db.inc
 774  # Database error when inserting work order issues. Fixed.
 775  $ /manufacturing/includes/db/work_order_issues_db.inc
 776
 777 03-May-2007 Joe Hunt
 778  # Multiple tables and JOIN's have syntax changes in MySQL 5.0.12. Need parentheses.
 779  $ /includes/db/manufacturing_db.inc
 780    /manufacturing/includes/db/work_order_requirements_db.inc
 781
 782 02-May-2007 Joe Hunt
 783  # Missing details on Purchase Order when emailing and printing
 784  $ /reporting/rep209.php
 785
 786 -------------------- 1.1 Stable Released ----------------------
 787 02-May-2007 Joe Hunt
 788  + Enabled module addons and all the below bugfixes. No changes in database structure.
 789  - Removed /sql/basic.sql (included in the other sql files)
 790  - Removed /themes/default/images/left.gif and /themes/default/images/right.gif
 791    (not needed anymore).
 792  + Addition of update.html
 793  $ /admin/inst_module.php (New file!)
 794    /applications/customers.php
 795    /applications/dimensions.php
 796    /applications/generalledger.php
 797    /applications/inventory.php
 798    /applications/manufacturing.php
 799    /applications/setup.php
 800    /applications/suppliers.php
 801    /install/index.php
 802    /install/save.php
 803    /modules/inst_modules.php (New folder and new file!)
 804    /modules/index.php (New file!)
 805    /sql/en_US-demo.sql
 806    /sql/en_US-new.sql
 807    install.html
 808    update.html (New file!)
 809
 810 01-May-2007 Joe Hunt
 811  # Missing measure of units when printing sales orders
 812  # Update of Sales People caused a database error
 813  $ /sales/manage/sales_people.php
 814    /reporting/rep109.php
 815
 816 30-Apr-2007 Joe Hunt
 817  + The selected menu tab is now shown with same background as hover color.
 818  $ config.php (default tab line 77. Change if you want)
 819    /includes/page/header.inc
 820
 821 28-Apr-2007 Joe Hunt
 822  # When saving work order entries a lot of debug boxes appeared. Fixed
 823  # When clicking on the link, Issue, on work order inquires an empty screen appeared. Fixed
 824  # When retrieving work centres id's there was a database error. Fixed by casting string to unsigned
 825  $ /includes/db/manufacturing_db.inc
 826    /manufacturing/work_order_entry.php
 827    /manufacturing/includes/work_order_issue_ui.inc
 828    /manufacturing/includes/db/work_order_requirements_db.inc
 829    /manufacturing/includes/db/work_orders_quick_db.inc
 830    /manufacturing/inquiry/where_used_inquiry.php
 831
 832 25-Apr-2007 Joe Hunt
 833  # Missing Date Picker
 834  $ /sales/customer_invoice.php
 835  # No JS popup window
 836  $ /sales/view/view_invoice.php
 837
 838 24-Apr-2007 Joe Hunt
 839  ! New and better Date Picker, better cool theme.
 840  $ /includes/ui/ui_input.inc
 841    /includes/ui/ui_view.inc
 842    /reporting/includes/reports_classes.inc
 843    /themes/cool/default.css
 844
 845 -------------------- 1.0.1 Stable Released ----------------------
 846 23-Apr-2007 Joe Hunt
 847  ! Release 1.0.1 established on SourceForge, fixing the bugs and including a Date Picker,
 848    the changes for selection lists customers/suppliers and the Audit Trail.
 849
 850 22-Apr-2007 Joe Hunt
 851  ! Changed the two selection lists for customers/suppliers in reports to a single one with
 852    No Filter
 853  ! Changed the sort order in these selection lists from id to name.
 854  + Added Audit Trail in GL trans. A switch in config.php, $use_audit_trail, must be set to 1.
 855  $ /reporting/reports_main.php
 856    /reporting/rep101.php
 857    /reporting/rep102.php
 858    /reporting/rep201.php
 859    /reporting/rep202.php
 860    /reporting/rep203.php
 861    /reporting/rep204.php
 862    /reporting/includes/reports_classes.inc
 863    /includes/ui/ui_lists.inc
 864    /gl/includes/db/gl_db_trans.inc
 865    config.php
 866
 867 22-Apr-2007 Joe Hunt
 868  + Date Picker for all date fields.
 869  $ config.php
 870    /admin/fiscalyears.php
 871    /admin/void_transaction.php
 872    /includes/ui/ui_view.inc
 873    /includes/ui/ui_input.inc
 874    /dimensions/dimension_entry.php
 875    /dimensions/inquiry/search_dimensions.php
 876    /gl/gl_journal.php
 877    /gl/gl_deposit.php
 878    /gl/gl_payment.php
 879    /gl/bank_transfer.php
 880    /gl/inquiry/bank_inquiry.php
 881    /gl/inquiry/gl_account_inquiry.php
 882    /gl/inquiry/gl_trial_balance.php
 883    /gl/manage/exchange_rates.php
 884    /inventory/adjustments.php
 885    /inventory/transfers.php
 886    /inventory/inquiry/stock_movements.php
 887    /inventory/manage/items.php
 888    /manufacturing/work_order_add_finished.php
 889    /manufacturing/work_order_entry.php
 890    /manufacturing/work_order_issue.php
 891    /manufacturing/work_order_release.php
 892    /purchasing/supplier_payment.php
 893    /purchasing/po_entry_items.php
 894    /purchasing/po_receive_items.php
 895    /purchasing/supplier_credit.php
 896    /purchasing/supplier_credit_grns.php
 897    /purchasing/supplier_invoice.php
 898    /purchasing/supplier_invoice_grns.php
 899    /purchasing/supplier_trans_gl.php
 900    /purchasing/includes/ui/po_ui.inc
 901    /purchasing/inquity/po_search.php
 902    /purchasing/inquiry/po_search_completed.php
 903    /purchasing/inquiry/supplier_allocation_inquiry.php
 904    /purchasing/inquiry/supplier_inquiry.php
 905    /reporting/reports_main.php
 906    /reporting/includes/reports_classes.inc
 907    /sales/credit_note_entry.php
 908    /sales/customer_credit_invoice.php
 909    /sales/customer_payments.php
 910    /sales/sales_order_entry.php
 911    /sales/includes/ui/sales_order_ui.inc
 912    /sales/inquiry/customer_allocation_inquiry.php
 913    /sales/inquiry/customer_inquiry.php
 914    /sales/inquiry/sales_orders_view.php
 915    New image files:
 916    /themes/default/images/cal.gif
 917    /themes/default/images/next.gif
 918    /themes/default/images/prev.gif
 919
 920 19-Apr-2007 Joe Hunt
 921  # Bug no 1703895, Account numbers are varchars, need quotes, fixed
 922  # Bug no 1703891, Reserved MySQL words used as column names, fixed
 923  $ /taxes/db/tax_types_db.inc
 924
 925  # Bug no 1703888, Apostrophes and other unescaped characters, fixed
 926  $ /gl/manage/gl_accounts.php
 927    /gl/includes/db/gl_db_accounts.inc
 928    /includes/ui/ui_input.inc
 929
 930 18-Apr-2007 Joe Hunt
 931  # Bug no 1702594, Logon Loop, fixed
 932  $ config.php
 933
 934 -------------------- 1.0a Stable Released ----------------------
 935 10-Apr-2007 Joe Hunt
 936  ! Release 1.0a established on SourceForge, fixing the bugs.
 937
 938 11-Apr-2007 Joe Hunt
 939  # Bug No 1698214, Creating Items, fixed
 940  $ /includes/ui/ui_lists.inc
 941  # Bug no 1698216, Item Movements, fixed
 942  $ /inventory/manage/items.php
 943
 944 -------------------- 1.0 Stable Released ----------------------
 945 10-Apr-2007 Joe Hunt
 946  ! Release 1.0 established on SourceForge.
 947
 948 2. Copyright and disclaimer
 949 ---------------------------
 950 This application is opensource software released under the GPL.  Please
 951 see source code and the LICENSE file