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 + Added Report, Salesman Listing, rep106.php.
24 $ /reporting/reports_main.php
27 06-Feb-2008 Janusz Dobrowolski
28 + Separation of customer invoice issue and goods delivery.
29 + Batch invoicing for more than one delivery
30 # Corrected inadequate shipping tax calculations.
31 ! Default debugging status changed to off.
33 /taxes/db/tax_groups_db.inc
34 /admin/db/voiding_db.inc
35 /applications/customers.php
36 /includes/systypes.inc
38 /includes/ui/ui_controls.inc
39 /includes/ui/ui_lists.inc
40 /includes/ui/ui_view.inc
41 /inventory/inquiry/stock_status.php
47 /reporting/reports_main.php
48 /reporting/includes/doctext.inc
49 /reporting/includes/doctext2.inc
50 /reporting/includes/form_types.inc
51 /reporting/includes/pdf_report.inc
52 /reporting/includes/reports_classes.inc
53 /sales/customer_credit_invoice.php
54 /sales/customer_invoice.php
55 /sales/sales_order_entry.php
56 /sales/customer_delivery.php
57 /sales/includes/db/sales_delivery_db.inc
58 /sales/includes/ui/print_invoice.inc
59 /sales/includes/cart_class.inc
60 /sales/includes/sales_db.inc
61 /sales/includes/db/cust_trans_db.inc
62 /sales/includes/db/cust_trans_details_db.inc
63 /sales/includes/db/sales_credit_db.inc
64 /sales/includes/db/sales_invoice_db.inc
65 /sales/includes/db/sales_order_db.inc
66 /sales/includes/ui/sales_order_ui.inc
67 /sales/inquiry/customer_allocation_inquiry.php
68 /sales/inquiry/customer_inquiry.php
69 /sales/inquiry/sales_orders_view.php
70 /sales/inquiry/sales_deliveries_view.php
71 /sales/view/view_dispatch.php
72 /sales/view/view_invoice.php
73 /sales/view/view_sales_order.php
78 ! Changed so sales orders can have more than one row with the same stock_id. In alter.sql.
79 $ /sales/includes/cart_class.inc
80 /sales/includes/db/sales_credit_db.inc
81 /sales/includes/db/sales_invoice_db.inc
82 /sales/includes/db/sales_order_db.inc
83 /sales/includes/db/cust_trans_details_db.inc
84 /sales/includes/ui/sales_order_ui.inc
85 /sales/includes/ui/sales_credit_ui.inc
86 /sales/credit_note_entry.php
87 /sales/customer_credit_invoice.php
88 /sales/sales_order_entry.php
89 /sales/customer_invoice.php
92 ! New Release 2.0 Pre Alpha
94 # Fixed a release 2 related bug in create_coy.php
95 $ /admin/create_coy.php
96 + An alter.sql file to use for updating databases. Until the update_db.php is ready, you can use the install/update companies
97 and select the companies one by one and upload the alter.sql file to all companies. You can still run the release 2
98 with these databases changes without any new files. They are coming as soon as possible.
99 $ /sql/alter.sql (New file)
100 # Fixed a release 2 related bug. A field in supp_trans_items were declared as integer(11). Changed to VARCHAR(11) in alter.sql
102 $ /purchasing/supplier_trans_gl.php
103 /purchasing/includes/db/invoice_items_db.inc
104 ! Moved variables $no_item_list, $no_customer_list and $no_supplier_list in config.php to company table
105 $ /includes/ui/ui_lists.inc
106 /purchasing/includes/ui/po_ui.inc
107 /sales/includes/ui/sales_order_ui.inc
108 /admin/company_preferences.php
109 /admin/db/company_db.inc
111 + Created 3 new fields in salesman table for provision, break point and provision2. Included in alter.sql.
112 Update sales_people.php.Preparing for a new Salesman report with provision etc. Selected with time range. Should be very good.
113 $ /sales/manage/sales_people.php
114 /includes/ui/ui_input.inc
116 -------------------- 2,0 Pre Alpha - above ----------------------------
117 31-Jan-2008 Janusz Dobrowolski
118 # Minor bugfix in db_import()
119 $ /admin/db/maintenance_db.inc
121 30-Jan-2008 Janusz Dobrowolski
122 # Minor display fix in tax_types.php
123 $ /taxes/tax_types.php
124 ! Format cleanup on some files.
125 $ /gl/includes/gl_db.inc
126 /gl/includes/gl_ui.inc
127 /applications/application.php
131 -------------------- 1.16 Stable Released ----------------------
133 + Added a possibility to replace the normal listboxes for items, customer and/or suppliers with a search box.
134 The listboxes can only hold about 1000 items. New variables in config.php, $no_item_list, $no_customer_list
135 and $no_supplier_list. Default is the normal behavior for all listboxes.
136 $ /includes/ui/ui_lists.inc
137 /sales/includes/ui/sales_orders_ui.inc
138 /purchases/includes/ui/po_ui.inc
139 /themes/default/images/locate.png (New file)
142 + Added ALTER TABLE possibility in db_import. For future releases.
143 $ /admin/db/maintenence_db.inc
145 # Removed warnings 'Call-time pass-by-reference' in /includes/db/connect_db.inc and /includes/ui/ui_lists.inc
146 # Fixed File not found when loading local stylesheet.css (for other languages) in /includes/page/header.inc
147 $ /includes/db/connect_db.inc
148 /includes/ui/ui_lists.inc
149 /includes/page/header.inc
153 # When login screen is displayed after session timeout page content is broken. It
154 is because of NOT using absolute paths in href attribute theme elements.
158 # Minor adjustments in function db_export on line 325
159 $ /admin/db/maintenance_db.inc
162 + Added a variable, $print_invoice_no, in config.php for printing the invoice number instead of invoice reference.
165 # Fixed a bug when exporting database. Exported NULL field values from NO to empty field (from mysql version 5.0.32).
166 Also fixed a unneccessary str_replace when importing sql scripts.
167 ! Changed the PDF presentation to deleting the Javascript cache before presentation.
168 $ /admin/db/maintenance_db.inc
169 /reporting/includes/pdf_report.inc
172 # Still bugs in trial balances and account inquiry on screen when selecting non balance accounts. Fixed.
173 $ /gl/inquiry/gl_trial_balance.php
174 /gl/inquiry/gl_account_inquiry.php
177 # Fixed a bug when voiding a transaction (Journal Entry). An eventually underlying bank transfer was not voided.
178 $ /admin/db/voiding_db.inc
181 # Fixed a bug when adding lines during Payments to suppliers, the supplier was set back to the first.
183 /gl/includes/ui/gl_payment_ui.inc
185 ! Changed $loc_notification to be set to 0 instead of 1.
188 -------------------- 1.15 Stable Released ----------------------
190 + Added email notification to stock location when available stock is below reorder level
192 /sales/includes/db/sales_order_db.inc
194 # Fixed bugs in Open balances when account is not a balance account
195 $ /gl/inquiry/gl_trial_balance.php
196 /gl/inquiry/gl_account_inquiry.php
197 /reporting/rep704.php
198 /reporting/rep708.php
200 -------------------- 1.14 Stable Released ----------------------
202 ! Major change in the installation of modules to also accept an SQL-file for upload.
204 /admin/inst_module.php
205 /admin/db/maintenance_db.inc
208 # The following files were still vulnerable. Fixed
210 /includes/lang/language.php
212 -------------------- 1.13 Stable Released ----------------------
214 + Added optional link for electronic payment on invoices (PayPal).
215 ! Better support for install/update languages.
217 # Fixed a vulnerable item in config.php
221 # We forgot to upload the PO file when installing new language. Used when GETTEXT is not installed on Server.
222 # config.php has been vulnerable. Fixed.
223 $ /admin/inst_lang.php
227 ! Changed Bank Address field from text to textarea (multirows)
228 $ /gl/manage/bank_accounts.php
231 + Added optional link for electronic payment on invoices (PayPal)
232 $ /reporting/reports_main.php
233 /reporting/rep107.php
234 /reporting/includes/report_classes.inc
235 /reporting/includes/pdf_report.inc
236 /reporting/includes/doc_text.inc
237 /reporting/includes/doc_text2.inc
240 # Unnecessary parameter ($db) in check_for_recursive_bom
241 $ /manufacturing/manage/bom_edit.php
244 # Bug in /includes/lang/gettext.php (249) affecting changing language!
245 $ /includes/lang/gettext.php
251 /admin/create_coy.php
252 /reporting/includes/pdf_report.inc
255 + Added a default fiscal year in the en_US-new.sql and start references.
257 ! Changed some specific text strings in en_US.po (E.g. TAX instead of VAT)
258 $ /lang/en_US/LC_MESSAGES/en_US.mo
261 # A bug in Direct Invoicing (wrong Invoice Date) has been fixed.
262 $ /sales/includes/db/sales_order_db.inc
265 # Changed <? in front of 2 files to <?php.
266 $ /purchasing/includes/purchasing_ui.inc
267 /reporting/includes/class.mail.inc
269 -------------------- 1.12 Stable Released ----------------------
271 + Added option to handle Jalali and Islamic Calendars
274 /gl/includes/db/gl_db_trans.inc
275 /includes/date_functions.inc
276 /includes/ui/ui_input.inc
277 /includes/ui/ui_lists.inc
278 /includes/ui/ui_view.inc
279 /purchasing/po_receive_items.php
280 /purchasing/includes/ui/invoice_ui.inc
281 /purchasing/includes/ui/po_ui.inc
282 /reporting/rep705.php
283 /sales/includes/db/sales_order_db.inc
284 /sales/includes/ui/sales_order_ui.inc
287 ! Changed parameters on report Sales Order. Option to print as Quote.
288 $ /reporting/reports_main.php
289 /reporting/rep109.php
290 /reporting/includes/pdf_report.inc
291 /reporting/includes/doctext.inc
292 /reporting/includes/doctext2.inc
295 + Added Budget Entry in General Ledger. Includes Dimensions.
297 /applications/generalledger.php
298 /gl/gl_budget.php (New File!)
299 /gl/includes/db/gl_db_trans.inc
300 /includes/date_functions.inc
301 /reporting/report_classes.inc
303 -------------------- 1.11 Stable Released ----------------------
305 ! Option for using alpha numeric chart of accounts.
307 /gl/manage/gl_accounts.php
308 /gl/includes/db/gl_db_accounts.inc
309 /gl/includes/db/gl_db_bank_trans.inc
310 /gl/includes/db/gl_db_trans.inc
311 /gl/inquiry/gl_trial_balance.inc
312 /admin/db/company_db.inc
313 /inventory/includes/db/items_db.inc
314 /sales/manage/customer_branches.inc
317 # Problems retrieving language texts for poEdit in long javascripts
318 $ /includes/ui/ui_view.inc
321 # Database error when updating more than one item row in Sales Orders.
322 $ /sales/includes/db/sales_order_db.inc
323 # Database error when inserting work order issues. Fixed.
324 $ /manufacturing/includes/db/work_order_issues_db.inc
327 # Multiple tables and JOIN's have syntax changes in MySQL 5.0.12. Need parentheses.
328 $ /includes/db/manufacturing_db.inc
329 /manufacturing/includes/db/work_order_requirements_db.inc
332 # Missing details on Purchase Order when emailing and printing
333 $ /reporting/rep209.php
335 -------------------- 1.1 Stable Released ----------------------
337 + Enabled module addons and all the below bugfixes. No changes in database structure.
338 - Removed /sql/basic.sql (included in the other sql files)
339 - Removed /themes/default/images/left.gif and /themes/default/images/right.gif
340 (not needed anymore).
341 + Addition of update.html
342 $ /admin/inst_module.php (New file!)
343 /applications/customers.php
344 /applications/dimensions.php
345 /applications/generalledger.php
346 /applications/inventory.php
347 /applications/manufacturing.php
348 /applications/setup.php
349 /applications/suppliers.php
352 /modules/inst_modules.php (New folder and new file!)
353 /modules/index.php (New file!)
357 update.html (New file!)
360 # Missing measure of units when printing sales orders
361 # Update of Sales People caused a database error
362 $ /sales/manage/sales_people.php
363 /reporting/rep109.php
366 + The selected menu tab is now shown with same background as hover color.
367 $ config.php (default tab line 77. Change if you want)
368 /includes/page/header.inc
371 # When saving work order entries a lot of debug boxes appeared. Fixed
372 # When clicking on the link, Issue, on work order inquires an empty screen appeared. Fixed
373 # When retrieving work centres id's there was a database error. Fixed by casting string to unsigned
374 $ /includes/db/manufacturing_db.inc
375 /manufacturing/work_order_entry.php
376 /manufacturing/includes/work_order_issue_ui.inc
377 /manufacturing/includes/db/work_order_requirements_db.inc
378 /manufacturing/includes/db/work_orders_quick_db.inc
379 /manufacturing/inquiry/where_used_inquiry.php
382 # Missing Date Picker
383 $ /sales/customer_invoice.php
385 $ /sales/view/view_invoice.php
388 ! New and better Date Picker, better cool theme.
389 $ /includes/ui/ui_input.inc
390 /includes/ui/ui_view.inc
391 /reporting/includes/reports_classes.inc
392 /themes/cool/default.css
394 -------------------- 1.0.1 Stable Released ----------------------
396 ! Release 1.0.1 established on SourceForge, fixing the bugs and including a Date Picker,
397 the changes for selection lists customers/suppliers and the Audit Trail.
400 ! Changed the two selection lists for customers/suppliers in reports to a single one with
402 ! Changed the sort order in these selection lists from id to name.
403 + Added Audit Trail in GL trans. A switch in config.php, $use_audit_trail, must be set to 1.
404 $ /reporting/reports_main.php
405 /reporting/rep101.php
406 /reporting/rep102.php
407 /reporting/rep201.php
408 /reporting/rep202.php
409 /reporting/rep203.php
410 /reporting/rep204.php
411 /reporting/includes/reports_classes.inc
412 /includes/ui/ui_lists.inc
413 /gl/includes/db/gl_db_trans.inc
417 + Date Picker for all date fields.
419 /admin/fiscalyears.php
420 /admin/void_transaction.php
421 /includes/ui/ui_view.inc
422 /includes/ui/ui_input.inc
423 /dimensions/dimension_entry.php
424 /dimensions/inquiry/search_dimensions.php
428 /gl/bank_transfer.php
429 /gl/inquiry/bank_inquiry.php
430 /gl/inquiry/gl_account_inquiry.php
431 /gl/inquiry/gl_trial_balance.php
432 /gl/manage/exchange_rates.php
433 /inventory/adjustments.php
434 /inventory/transfers.php
435 /inventory/inquiry/stock_movements.php
436 /inventory/manage/items.php
437 /manufacturing/work_order_add_finished.php
438 /manufacturing/work_order_entry.php
439 /manufacturing/work_order_issue.php
440 /manufacturing/work_order_release.php
441 /purchasing/supplier_payment.php
442 /purchasing/po_entry_items.php
443 /purchasing/po_receive_items.php
444 /purchasing/supplier_credit.php
445 /purchasing/supplier_credit_grns.php
446 /purchasing/supplier_invoice.php
447 /purchasing/supplier_invoice_grns.php
448 /purchasing/supplier_trans_gl.php
449 /purchasing/includes/ui/po_ui.inc
450 /purchasing/inquity/po_search.php
451 /purchasing/inquiry/po_search_completed.php
452 /purchasing/inquiry/supplier_allocation_inquiry.php
453 /purchasing/inquiry/supplier_inquiry.php
454 /reporting/reports_main.php
455 /reporting/includes/reports_classes.inc
456 /sales/credit_note_entry.php
457 /sales/customer_credit_invoice.php
458 /sales/customer_payments.php
459 /sales/sales_order_entry.php
460 /sales/includes/ui/sales_order_ui.inc
461 /sales/inquiry/customer_allocation_inquiry.php
462 /sales/inquiry/customer_inquiry.php
463 /sales/inquiry/sales_orders_view.php
465 /themes/default/images/cal.gif
466 /themes/default/images/next.gif
467 /themes/default/images/prev.gif
470 # Bug no 1703895, Account numbers are varchars, need quotes, fixed
471 # Bug no 1703891, Reserved MySQL words used as column names, fixed
472 $ /taxes/db/tax_types_db.inc
474 # Bug no 1703888, Apostrophes and other unescaped characters, fixed
475 $ /gl/manage/gl_accounts.php
476 /gl/includes/db/gl_db_accounts.inc
477 /includes/ui/ui_input.inc
480 # Bug no 1702594, Logon Loop, fixed
483 -------------------- 1.0a Stable Released ----------------------
485 ! Release 1.0a established on SourceForge, fixing the bugs.
488 # Bug No 1698214, Creating Items, fixed
489 $ /includes/ui/ui_lists.inc
490 # Bug no 1698216, Item Movements, fixed
491 $ /inventory/manage/items.php
493 -------------------- 1.0 Stable Released ----------------------
495 ! Release 1.0 established on SourceForge.
497 2. Copyright and disclaimer
498 ---------------------------
499 This application is opensource software released under the GPL. Please
500 see source code and the LICENSE file