3 * @package FrontAccounting
4 * @copyright (C) 2005 - 2007 FrontAccounting
5 * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
6 * FrontAccounting is Free Software
11 This is a changelog for FrontAccounting All releases.
23 ! Minor change in menu and function in view_print_transaction.php
24 $ /admin/view_print_transaction.php
25 /application/setup.php
26 + Preparing for print of single documents
27 $ /reporting/includes/reporting.inc
28 ! Removing 'out' field in table tax_types
31 /taxes/db/tax_types_db.inc
34 + Added file, update_db.php, for updating company databases from an SQL script.
35 $ update_db.php (New file)
39 + Added Report, Salesman Listing, rep106.php.
40 $ /reporting/reports_main.php
43 06-Feb-2008 Janusz Dobrowolski
44 + Separation of customer invoice issue and goods delivery.
45 + Batch invoicing for more than one delivery
46 # Corrected inadequate shipping tax calculations.
47 ! Default debugging status changed to off.
49 /taxes/db/tax_groups_db.inc
50 /admin/db/voiding_db.inc
51 /applications/customers.php
52 /includes/systypes.inc
54 /includes/ui/ui_controls.inc
55 /includes/ui/ui_lists.inc
56 /includes/ui/ui_view.inc
57 /inventory/inquiry/stock_status.php
63 /reporting/reports_main.php
64 /reporting/includes/doctext.inc
65 /reporting/includes/doctext2.inc
66 /reporting/includes/form_types.inc
67 /reporting/includes/pdf_report.inc
68 /reporting/includes/reports_classes.inc
69 /sales/customer_credit_invoice.php
70 /sales/customer_invoice.php
71 /sales/sales_order_entry.php
72 /sales/customer_delivery.php
73 /sales/includes/db/sales_delivery_db.inc
74 /sales/includes/ui/print_invoice.inc
75 /sales/includes/cart_class.inc
76 /sales/includes/sales_db.inc
77 /sales/includes/db/cust_trans_db.inc
78 /sales/includes/db/cust_trans_details_db.inc
79 /sales/includes/db/sales_credit_db.inc
80 /sales/includes/db/sales_invoice_db.inc
81 /sales/includes/db/sales_order_db.inc
82 /sales/includes/ui/sales_order_ui.inc
83 /sales/inquiry/customer_allocation_inquiry.php
84 /sales/inquiry/customer_inquiry.php
85 /sales/inquiry/sales_orders_view.php
86 /sales/inquiry/sales_deliveries_view.php
87 /sales/view/view_dispatch.php
88 /sales/view/view_invoice.php
89 /sales/view/view_sales_order.php
94 ! Changed so sales orders can have more than one row with the same stock_id. In alter.sql.
95 $ /sales/includes/cart_class.inc
96 /sales/includes/db/sales_credit_db.inc
97 /sales/includes/db/sales_invoice_db.inc
98 /sales/includes/db/sales_order_db.inc
99 /sales/includes/db/cust_trans_details_db.inc
100 /sales/includes/ui/sales_order_ui.inc
101 /sales/includes/ui/sales_credit_ui.inc
102 /sales/credit_note_entry.php
103 /sales/customer_credit_invoice.php
104 /sales/sales_order_entry.php
105 /sales/customer_invoice.php
108 ! New Release 2.0 Pre Alpha
110 # Fixed a release 2 related bug in create_coy.php
111 $ /admin/create_coy.php
112 + An alter.sql file to use for updating databases. Until the update_db.php is ready, you can use the install/update companies
113 and select the companies one by one and upload the alter.sql file to all companies. You can still run the release 2
114 with these databases changes without any new files. They are coming as soon as possible.
115 $ /sql/alter.sql (New file)
116 # Fixed a release 2 related bug. A field in supp_trans_items were declared as integer(11). Changed to VARCHAR(11) in alter.sql
118 $ /purchasing/supplier_trans_gl.php
119 /purchasing/includes/db/invoice_items_db.inc
120 ! Moved variables $no_item_list, $no_customer_list and $no_supplier_list in config.php to company table
121 $ /includes/ui/ui_lists.inc
122 /purchasing/includes/ui/po_ui.inc
123 /sales/includes/ui/sales_order_ui.inc
124 /admin/company_preferences.php
125 /admin/db/company_db.inc
127 + Created 3 new fields in salesman table for provision, break point and provision2. Included in alter.sql.
128 Update sales_people.php.Preparing for a new Salesman report with provision etc. Selected with time range. Should be very good.
129 $ /sales/manage/sales_people.php
130 /includes/ui/ui_input.inc
132 -------------------- 2,0 Pre Alpha - above ----------------------------
133 31-Jan-2008 Janusz Dobrowolski
134 # Minor bugfix in db_import()
135 $ /admin/db/maintenance_db.inc
137 30-Jan-2008 Janusz Dobrowolski
138 # Minor display fix in tax_types.php
139 $ /taxes/tax_types.php
140 ! Format cleanup on some files.
141 $ /gl/includes/gl_db.inc
142 /gl/includes/gl_ui.inc
143 /applications/application.php
147 -------------------- 1.16 Stable Released ----------------------
149 + Added a possibility to replace the normal listboxes for items, customer and/or suppliers with a search box.
150 The listboxes can only hold about 1000 items. New variables in config.php, $no_item_list, $no_customer_list
151 and $no_supplier_list. Default is the normal behavior for all listboxes.
152 $ /includes/ui/ui_lists.inc
153 /sales/includes/ui/sales_orders_ui.inc
154 /purchases/includes/ui/po_ui.inc
155 /themes/default/images/locate.png (New file)
158 + Added ALTER TABLE possibility in db_import. For future releases.
159 $ /admin/db/maintenence_db.inc
161 # Removed warnings 'Call-time pass-by-reference' in /includes/db/connect_db.inc and /includes/ui/ui_lists.inc
162 # Fixed File not found when loading local stylesheet.css (for other languages) in /includes/page/header.inc
163 $ /includes/db/connect_db.inc
164 /includes/ui/ui_lists.inc
165 /includes/page/header.inc
169 # When login screen is displayed after session timeout page content is broken. It
170 is because of NOT using absolute paths in href attribute theme elements.
174 # Minor adjustments in function db_export on line 325
175 $ /admin/db/maintenance_db.inc
178 + Added a variable, $print_invoice_no, in config.php for printing the invoice number instead of invoice reference.
181 # Fixed a bug when exporting database. Exported NULL field values from NO to empty field (from mysql version 5.0.32).
182 Also fixed a unneccessary str_replace when importing sql scripts.
183 ! Changed the PDF presentation to deleting the Javascript cache before presentation.
184 $ /admin/db/maintenance_db.inc
185 /reporting/includes/pdf_report.inc
188 # Still bugs in trial balances and account inquiry on screen when selecting non balance accounts. Fixed.
189 $ /gl/inquiry/gl_trial_balance.php
190 /gl/inquiry/gl_account_inquiry.php
193 # Fixed a bug when voiding a transaction (Journal Entry). An eventually underlying bank transfer was not voided.
194 $ /admin/db/voiding_db.inc
197 # Fixed a bug when adding lines during Payments to suppliers, the supplier was set back to the first.
199 /gl/includes/ui/gl_payment_ui.inc
201 ! Changed $loc_notification to be set to 0 instead of 1.
204 -------------------- 1.15 Stable Released ----------------------
206 + Added email notification to stock location when available stock is below reorder level
208 /sales/includes/db/sales_order_db.inc
210 # Fixed bugs in Open balances when account is not a balance account
211 $ /gl/inquiry/gl_trial_balance.php
212 /gl/inquiry/gl_account_inquiry.php
213 /reporting/rep704.php
214 /reporting/rep708.php
216 -------------------- 1.14 Stable Released ----------------------
218 ! Major change in the installation of modules to also accept an SQL-file for upload.
220 /admin/inst_module.php
221 /admin/db/maintenance_db.inc
224 # The following files were still vulnerable. Fixed
226 /includes/lang/language.php
228 -------------------- 1.13 Stable Released ----------------------
230 + Added optional link for electronic payment on invoices (PayPal).
231 ! Better support for install/update languages.
233 # Fixed a vulnerable item in config.php
237 # We forgot to upload the PO file when installing new language. Used when GETTEXT is not installed on Server.
238 # config.php has been vulnerable. Fixed.
239 $ /admin/inst_lang.php
243 ! Changed Bank Address field from text to textarea (multirows)
244 $ /gl/manage/bank_accounts.php
247 + Added optional link for electronic payment on invoices (PayPal)
248 $ /reporting/reports_main.php
249 /reporting/rep107.php
250 /reporting/includes/report_classes.inc
251 /reporting/includes/pdf_report.inc
252 /reporting/includes/doc_text.inc
253 /reporting/includes/doc_text2.inc
256 # Unnecessary parameter ($db) in check_for_recursive_bom
257 $ /manufacturing/manage/bom_edit.php
260 # Bug in /includes/lang/gettext.php (249) affecting changing language!
261 $ /includes/lang/gettext.php
267 /admin/create_coy.php
268 /reporting/includes/pdf_report.inc
271 + Added a default fiscal year in the en_US-new.sql and start references.
273 ! Changed some specific text strings in en_US.po (E.g. TAX instead of VAT)
274 $ /lang/en_US/LC_MESSAGES/en_US.mo
277 # A bug in Direct Invoicing (wrong Invoice Date) has been fixed.
278 $ /sales/includes/db/sales_order_db.inc
281 # Changed <? in front of 2 files to <?php.
282 $ /purchasing/includes/purchasing_ui.inc
283 /reporting/includes/class.mail.inc
285 -------------------- 1.12 Stable Released ----------------------
287 + Added option to handle Jalali and Islamic Calendars
290 /gl/includes/db/gl_db_trans.inc
291 /includes/date_functions.inc
292 /includes/ui/ui_input.inc
293 /includes/ui/ui_lists.inc
294 /includes/ui/ui_view.inc
295 /purchasing/po_receive_items.php
296 /purchasing/includes/ui/invoice_ui.inc
297 /purchasing/includes/ui/po_ui.inc
298 /reporting/rep705.php
299 /sales/includes/db/sales_order_db.inc
300 /sales/includes/ui/sales_order_ui.inc
303 ! Changed parameters on report Sales Order. Option to print as Quote.
304 $ /reporting/reports_main.php
305 /reporting/rep109.php
306 /reporting/includes/pdf_report.inc
307 /reporting/includes/doctext.inc
308 /reporting/includes/doctext2.inc
311 + Added Budget Entry in General Ledger. Includes Dimensions.
313 /applications/generalledger.php
314 /gl/gl_budget.php (New File!)
315 /gl/includes/db/gl_db_trans.inc
316 /includes/date_functions.inc
317 /reporting/report_classes.inc
319 -------------------- 1.11 Stable Released ----------------------
321 ! Option for using alpha numeric chart of accounts.
323 /gl/manage/gl_accounts.php
324 /gl/includes/db/gl_db_accounts.inc
325 /gl/includes/db/gl_db_bank_trans.inc
326 /gl/includes/db/gl_db_trans.inc
327 /gl/inquiry/gl_trial_balance.inc
328 /admin/db/company_db.inc
329 /inventory/includes/db/items_db.inc
330 /sales/manage/customer_branches.inc
333 # Problems retrieving language texts for poEdit in long javascripts
334 $ /includes/ui/ui_view.inc
337 # Database error when updating more than one item row in Sales Orders.
338 $ /sales/includes/db/sales_order_db.inc
339 # Database error when inserting work order issues. Fixed.
340 $ /manufacturing/includes/db/work_order_issues_db.inc
343 # Multiple tables and JOIN's have syntax changes in MySQL 5.0.12. Need parentheses.
344 $ /includes/db/manufacturing_db.inc
345 /manufacturing/includes/db/work_order_requirements_db.inc
348 # Missing details on Purchase Order when emailing and printing
349 $ /reporting/rep209.php
351 -------------------- 1.1 Stable Released ----------------------
353 + Enabled module addons and all the below bugfixes. No changes in database structure.
354 - Removed /sql/basic.sql (included in the other sql files)
355 - Removed /themes/default/images/left.gif and /themes/default/images/right.gif
356 (not needed anymore).
357 + Addition of update.html
358 $ /admin/inst_module.php (New file!)
359 /applications/customers.php
360 /applications/dimensions.php
361 /applications/generalledger.php
362 /applications/inventory.php
363 /applications/manufacturing.php
364 /applications/setup.php
365 /applications/suppliers.php
368 /modules/inst_modules.php (New folder and new file!)
369 /modules/index.php (New file!)
373 update.html (New file!)
376 # Missing measure of units when printing sales orders
377 # Update of Sales People caused a database error
378 $ /sales/manage/sales_people.php
379 /reporting/rep109.php
382 + The selected menu tab is now shown with same background as hover color.
383 $ config.php (default tab line 77. Change if you want)
384 /includes/page/header.inc
387 # When saving work order entries a lot of debug boxes appeared. Fixed
388 # When clicking on the link, Issue, on work order inquires an empty screen appeared. Fixed
389 # When retrieving work centres id's there was a database error. Fixed by casting string to unsigned
390 $ /includes/db/manufacturing_db.inc
391 /manufacturing/work_order_entry.php
392 /manufacturing/includes/work_order_issue_ui.inc
393 /manufacturing/includes/db/work_order_requirements_db.inc
394 /manufacturing/includes/db/work_orders_quick_db.inc
395 /manufacturing/inquiry/where_used_inquiry.php
398 # Missing Date Picker
399 $ /sales/customer_invoice.php
401 $ /sales/view/view_invoice.php
404 ! New and better Date Picker, better cool theme.
405 $ /includes/ui/ui_input.inc
406 /includes/ui/ui_view.inc
407 /reporting/includes/reports_classes.inc
408 /themes/cool/default.css
410 -------------------- 1.0.1 Stable Released ----------------------
412 ! Release 1.0.1 established on SourceForge, fixing the bugs and including a Date Picker,
413 the changes for selection lists customers/suppliers and the Audit Trail.
416 ! Changed the two selection lists for customers/suppliers in reports to a single one with
418 ! Changed the sort order in these selection lists from id to name.
419 + Added Audit Trail in GL trans. A switch in config.php, $use_audit_trail, must be set to 1.
420 $ /reporting/reports_main.php
421 /reporting/rep101.php
422 /reporting/rep102.php
423 /reporting/rep201.php
424 /reporting/rep202.php
425 /reporting/rep203.php
426 /reporting/rep204.php
427 /reporting/includes/reports_classes.inc
428 /includes/ui/ui_lists.inc
429 /gl/includes/db/gl_db_trans.inc
433 + Date Picker for all date fields.
435 /admin/fiscalyears.php
436 /admin/void_transaction.php
437 /includes/ui/ui_view.inc
438 /includes/ui/ui_input.inc
439 /dimensions/dimension_entry.php
440 /dimensions/inquiry/search_dimensions.php
444 /gl/bank_transfer.php
445 /gl/inquiry/bank_inquiry.php
446 /gl/inquiry/gl_account_inquiry.php
447 /gl/inquiry/gl_trial_balance.php
448 /gl/manage/exchange_rates.php
449 /inventory/adjustments.php
450 /inventory/transfers.php
451 /inventory/inquiry/stock_movements.php
452 /inventory/manage/items.php
453 /manufacturing/work_order_add_finished.php
454 /manufacturing/work_order_entry.php
455 /manufacturing/work_order_issue.php
456 /manufacturing/work_order_release.php
457 /purchasing/supplier_payment.php
458 /purchasing/po_entry_items.php
459 /purchasing/po_receive_items.php
460 /purchasing/supplier_credit.php
461 /purchasing/supplier_credit_grns.php
462 /purchasing/supplier_invoice.php
463 /purchasing/supplier_invoice_grns.php
464 /purchasing/supplier_trans_gl.php
465 /purchasing/includes/ui/po_ui.inc
466 /purchasing/inquity/po_search.php
467 /purchasing/inquiry/po_search_completed.php
468 /purchasing/inquiry/supplier_allocation_inquiry.php
469 /purchasing/inquiry/supplier_inquiry.php
470 /reporting/reports_main.php
471 /reporting/includes/reports_classes.inc
472 /sales/credit_note_entry.php
473 /sales/customer_credit_invoice.php
474 /sales/customer_payments.php
475 /sales/sales_order_entry.php
476 /sales/includes/ui/sales_order_ui.inc
477 /sales/inquiry/customer_allocation_inquiry.php
478 /sales/inquiry/customer_inquiry.php
479 /sales/inquiry/sales_orders_view.php
481 /themes/default/images/cal.gif
482 /themes/default/images/next.gif
483 /themes/default/images/prev.gif
486 # Bug no 1703895, Account numbers are varchars, need quotes, fixed
487 # Bug no 1703891, Reserved MySQL words used as column names, fixed
488 $ /taxes/db/tax_types_db.inc
490 # Bug no 1703888, Apostrophes and other unescaped characters, fixed
491 $ /gl/manage/gl_accounts.php
492 /gl/includes/db/gl_db_accounts.inc
493 /includes/ui/ui_input.inc
496 # Bug no 1702594, Logon Loop, fixed
499 -------------------- 1.0a Stable Released ----------------------
501 ! Release 1.0a established on SourceForge, fixing the bugs.
504 # Bug No 1698214, Creating Items, fixed
505 $ /includes/ui/ui_lists.inc
506 # Bug no 1698216, Item Movements, fixed
507 $ /inventory/manage/items.php
509 -------------------- 1.0 Stable Released ----------------------
511 ! Release 1.0 established on SourceForge.
513 2. Copyright and disclaimer
514 ---------------------------
515 This application is opensource software released under the GPL. Please
516 see source code and the LICENSE file