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 ! Changed so sales orders can have more than one row with the same stock_id. In alter.sql.
24 $ /sales/includes/cart_class.inc
25 /sales/includes/db/sales_credit_db.inc
26 /sales/includes/db/sales_invoice_db.inc
27 /sales/includes/db/sales_order_db.inc
28 /sales/includes/db/cust_trans_details_db.inc
29 /sales/includes/ui/sales_order_ui.inc
30 /sales/includes/ui/sales_credit_ui.inc
31 /sales/credit_note_entry.php
32 /sales/customer_credit_invoice.php
33 /sales/sales_order_entry.php
34 /sales/customer_invoice.php
37 ! New Release 2.0 Pre Alpha
39 # Fixed a release 2 related bug in create_coy.php
40 $ /admin/create_coy.php
41 + An alter.sql file to use for updating databases. Until the update_db.php is ready, you can use the install/update companies
42 and select the companies one by one and upload the alter.sql file to all companies. You can still run the release 2
43 with these databases changes without any new files. They are coming as soon as possible.
44 $ /sql/alter.sql (New file)
45 # Fixed a release 2 related bug. A field in supp_trans_items were declared as integer(11). Changed to VARCHAR(11) in alter.sql
47 $ /purchasing/supplier_trans_gl.php
48 /purchasing/includes/db/invoice_items_db.inc
49 ! Moved variables $no_item_list, $no_customer_list and $no_supplier_list in config.php to company table
50 $ /includes/ui/ui_lists.inc
51 /purchasing/includes/ui/po_ui.inc
52 /sales/includes/ui/sales_order_ui.inc
53 /admin/company_preferences.php
54 /admin/db/company_db.inc
56 + Created 3 new fields in salesman table for provision, break point and provision2. Included in alter.sql.
57 Update sales_people.php.Preparing for a new Salesman report with provision etc. Selected with time range. Should be very good.
58 $ /sales/manage/sales_people.php
59 /includes/ui/ui_input.inc
61 -------------------- 2,0 Pre Alpha - above ----------------------------
62 31-Jan-2008 Janusz Dobrowolski
63 # Minor bugfix in db_import()
64 $ /admin/db/maintenance_db.inc
66 30-Jan-2008 Janusz Dobrowolski
67 # Minor display fix in tax_types.php
68 $ /taxes/tax_types.php
69 ! Format cleanup on some files.
70 $ /gl/includes/gl_db.inc
71 /gl/includes/gl_ui.inc
72 /applications/application.php
76 -------------------- 1.16 Stable Released ----------------------
78 + Added a possibility to replace the normal listboxes for items, customer and/or suppliers with a search box.
79 The listboxes can only hold about 1000 items. New variables in config.php, $no_item_list, $no_customer_list
80 and $no_supplier_list. Default is the normal behavior for all listboxes.
81 $ /includes/ui/ui_lists.inc
82 /sales/includes/ui/sales_orders_ui.inc
83 /purchases/includes/ui/po_ui.inc
84 /themes/default/images/locate.png (New file)
87 + Added ALTER TABLE possibility in db_import. For future releases.
88 $ /admin/db/maintenence_db.inc
90 # Removed warnings 'Call-time pass-by-reference' in /includes/db/connect_db.inc and /includes/ui/ui_lists.inc
91 # Fixed File not found when loading local stylesheet.css (for other languages) in /includes/page/header.inc
92 $ /includes/db/connect_db.inc
93 /includes/ui/ui_lists.inc
94 /includes/page/header.inc
98 # When login screen is displayed after session timeout page content is broken. It
99 is because of NOT using absolute paths in href attribute theme elements.
103 # Minor adjustments in function db_export on line 325
104 $ /admin/db/maintenance_db.inc
107 + Added a variable, $print_invoice_no, in config.php for printing the invoice number instead of invoice reference.
110 # Fixed a bug when exporting database. Exported NULL field values from NO to empty field (from mysql version 5.0.32).
111 Also fixed a unneccessary str_replace when importing sql scripts.
112 ! Changed the PDF presentation to deleting the Javascript cache before presentation.
113 $ /admin/db/maintenance_db.inc
114 /reporting/includes/pdf_report.inc
117 # Still bugs in trial balances and account inquiry on screen when selecting non balance accounts. Fixed.
118 $ /gl/inquiry/gl_trial_balance.php
119 /gl/inquiry/gl_account_inquiry.php
122 # Fixed a bug when voiding a transaction (Journal Entry). An eventually underlying bank transfer was not voided.
123 $ /admin/db/voiding_db.inc
126 # Fixed a bug when adding lines during Payments to suppliers, the supplier was set back to the first.
128 /gl/includes/ui/gl_payment_ui.inc
130 ! Changed $loc_notification to be set to 0 instead of 1.
133 -------------------- 1.15 Stable Released ----------------------
135 + Added email notification to stock location when available stock is below reorder level
137 /sales/includes/db/sales_order_db.inc
139 # Fixed bugs in Open balances when account is not a balance account
140 $ /gl/inquiry/gl_trial_balance.php
141 /gl/inquiry/gl_account_inquiry.php
142 /reporting/rep704.php
143 /reporting/rep708.php
145 -------------------- 1.14 Stable Released ----------------------
147 ! Major change in the installation of modules to also accept an SQL-file for upload.
149 /admin/inst_module.php
150 /admin/db/maintenance_db.inc
153 # The following files were still vulnerable. Fixed
155 /includes/lang/language.php
157 -------------------- 1.13 Stable Released ----------------------
159 + Added optional link for electronic payment on invoices (PayPal).
160 ! Better support for install/update languages.
162 # Fixed a vulnerable item in config.php
166 # We forgot to upload the PO file when installing new language. Used when GETTEXT is not installed on Server.
167 # config.php has been vulnerable. Fixed.
168 $ /admin/inst_lang.php
172 ! Changed Bank Address field from text to textarea (multirows)
173 $ /gl/manage/bank_accounts.php
176 + Added optional link for electronic payment on invoices (PayPal)
177 $ /reporting/reports_main.php
178 /reporting/rep107.php
179 /reporting/includes/report_classes.inc
180 /reporting/includes/pdf_report.inc
181 /reporting/includes/doc_text.inc
182 /reporting/includes/doc_text2.inc
185 # Unnecessary parameter ($db) in check_for_recursive_bom
186 $ /manufacturing/manage/bom_edit.php
189 # Bug in /includes/lang/gettext.php (249) affecting changing language!
190 $ /includes/lang/gettext.php
196 /admin/create_coy.php
197 /reporting/includes/pdf_report.inc
200 + Added a default fiscal year in the en_US-new.sql and start references.
202 ! Changed some specific text strings in en_US.po (E.g. TAX instead of VAT)
203 $ /lang/en_US/LC_MESSAGES/en_US.mo
206 # A bug in Direct Invoicing (wrong Invoice Date) has been fixed.
207 $ /sales/includes/db/sales_order_db.inc
210 # Changed <? in front of 2 files to <?php.
211 $ /purchasing/includes/purchasing_ui.inc
212 /reporting/includes/class.mail.inc
214 -------------------- 1.12 Stable Released ----------------------
216 + Added option to handle Jalali and Islamic Calendars
219 /gl/includes/db/gl_db_trans.inc
220 /includes/date_functions.inc
221 /includes/ui/ui_input.inc
222 /includes/ui/ui_lists.inc
223 /includes/ui/ui_view.inc
224 /purchasing/po_receive_items.php
225 /purchasing/includes/ui/invoice_ui.inc
226 /purchasing/includes/ui/po_ui.inc
227 /reporting/rep705.php
228 /sales/includes/db/sales_order_db.inc
229 /sales/includes/ui/sales_order_ui.inc
232 ! Changed parameters on report Sales Order. Option to print as Quote.
233 $ /reporting/reports_main.php
234 /reporting/rep109.php
235 /reporting/includes/pdf_report.inc
236 /reporting/includes/doctext.inc
237 /reporting/includes/doctext2.inc
240 + Added Budget Entry in General Ledger. Includes Dimensions.
242 /applications/generalledger.php
243 /gl/gl_budget.php (New File!)
244 /gl/includes/db/gl_db_trans.inc
245 /includes/date_functions.inc
246 /reporting/report_classes.inc
248 -------------------- 1.11 Stable Released ----------------------
250 ! Option for using alpha numeric chart of accounts.
252 /gl/manage/gl_accounts.php
253 /gl/includes/db/gl_db_accounts.inc
254 /gl/includes/db/gl_db_bank_trans.inc
255 /gl/includes/db/gl_db_trans.inc
256 /gl/inquiry/gl_trial_balance.inc
257 /admin/db/company_db.inc
258 /inventory/includes/db/items_db.inc
259 /sales/manage/customer_branches.inc
262 # Problems retrieving language texts for poEdit in long javascripts
263 $ /includes/ui/ui_view.inc
266 # Database error when updating more than one item row in Sales Orders.
267 $ /sales/includes/db/sales_order_db.inc
268 # Database error when inserting work order issues. Fixed.
269 $ /manufacturing/includes/db/work_order_issues_db.inc
272 # Multiple tables and JOIN's have syntax changes in MySQL 5.0.12. Need parentheses.
273 $ /includes/db/manufacturing_db.inc
274 /manufacturing/includes/db/work_order_requirements_db.inc
277 # Missing details on Purchase Order when emailing and printing
278 $ /reporting/rep209.php
280 -------------------- 1.1 Stable Released ----------------------
282 + Enabled module addons and all the below bugfixes. No changes in database structure.
283 - Removed /sql/basic.sql (included in the other sql files)
284 - Removed /themes/default/images/left.gif and /themes/default/images/right.gif
285 (not needed anymore).
286 + Addition of update.html
287 $ /admin/inst_module.php (New file!)
288 /applications/customers.php
289 /applications/dimensions.php
290 /applications/generalledger.php
291 /applications/inventory.php
292 /applications/manufacturing.php
293 /applications/setup.php
294 /applications/suppliers.php
297 /modules/inst_modules.php (New folder and new file!)
298 /modules/index.php (New file!)
302 update.html (New file!)
305 # Missing measure of units when printing sales orders
306 # Update of Sales People caused a database error
307 $ /sales/manage/sales_people.php
308 /reporting/rep109.php
311 + The selected menu tab is now shown with same background as hover color.
312 $ config.php (default tab line 77. Change if you want)
313 /includes/page/header.inc
316 # When saving work order entries a lot of debug boxes appeared. Fixed
317 # When clicking on the link, Issue, on work order inquires an empty screen appeared. Fixed
318 # When retrieving work centres id's there was a database error. Fixed by casting string to unsigned
319 $ /includes/db/manufacturing_db.inc
320 /manufacturing/work_order_entry.php
321 /manufacturing/includes/work_order_issue_ui.inc
322 /manufacturing/includes/db/work_order_requirements_db.inc
323 /manufacturing/includes/db/work_orders_quick_db.inc
324 /manufacturing/inquiry/where_used_inquiry.php
327 # Missing Date Picker
328 $ /sales/customer_invoice.php
330 $ /sales/view/view_invoice.php
333 ! New and better Date Picker, better cool theme.
334 $ /includes/ui/ui_input.inc
335 /includes/ui/ui_view.inc
336 /reporting/includes/reports_classes.inc
337 /themes/cool/default.css
339 -------------------- 1.0.1 Stable Released ----------------------
341 ! Release 1.0.1 established on SourceForge, fixing the bugs and including a Date Picker,
342 the changes for selection lists customers/suppliers and the Audit Trail.
345 ! Changed the two selection lists for customers/suppliers in reports to a single one with
347 ! Changed the sort order in these selection lists from id to name.
348 + Added Audit Trail in GL trans. A switch in config.php, $use_audit_trail, must be set to 1.
349 $ /reporting/reports_main.php
350 /reporting/rep101.php
351 /reporting/rep102.php
352 /reporting/rep201.php
353 /reporting/rep202.php
354 /reporting/rep203.php
355 /reporting/rep204.php
356 /reporting/includes/reports_classes.inc
357 /includes/ui/ui_lists.inc
358 /gl/includes/db/gl_db_trans.inc
362 + Date Picker for all date fields.
364 /admin/fiscalyears.php
365 /admin/void_transaction.php
366 /includes/ui/ui_view.inc
367 /includes/ui/ui_input.inc
368 /dimensions/dimension_entry.php
369 /dimensions/inquiry/search_dimensions.php
373 /gl/bank_transfer.php
374 /gl/inquiry/bank_inquiry.php
375 /gl/inquiry/gl_account_inquiry.php
376 /gl/inquiry/gl_trial_balance.php
377 /gl/manage/exchange_rates.php
378 /inventory/adjustments.php
379 /inventory/transfers.php
380 /inventory/inquiry/stock_movements.php
381 /inventory/manage/items.php
382 /manufacturing/work_order_add_finished.php
383 /manufacturing/work_order_entry.php
384 /manufacturing/work_order_issue.php
385 /manufacturing/work_order_release.php
386 /purchasing/supplier_payment.php
387 /purchasing/po_entry_items.php
388 /purchasing/po_receive_items.php
389 /purchasing/supplier_credit.php
390 /purchasing/supplier_credit_grns.php
391 /purchasing/supplier_invoice.php
392 /purchasing/supplier_invoice_grns.php
393 /purchasing/supplier_trans_gl.php
394 /purchasing/includes/ui/po_ui.inc
395 /purchasing/inquity/po_search.php
396 /purchasing/inquiry/po_search_completed.php
397 /purchasing/inquiry/supplier_allocation_inquiry.php
398 /purchasing/inquiry/supplier_inquiry.php
399 /reporting/reports_main.php
400 /reporting/includes/reports_classes.inc
401 /sales/credit_note_entry.php
402 /sales/customer_credit_invoice.php
403 /sales/customer_payments.php
404 /sales/sales_order_entry.php
405 /sales/includes/ui/sales_order_ui.inc
406 /sales/inquiry/customer_allocation_inquiry.php
407 /sales/inquiry/customer_inquiry.php
408 /sales/inquiry/sales_orders_view.php
410 /themes/default/images/cal.gif
411 /themes/default/images/next.gif
412 /themes/default/images/prev.gif
415 # Bug no 1703895, Account numbers are varchars, need quotes, fixed
416 # Bug no 1703891, Reserved MySQL words used as column names, fixed
417 $ /taxes/db/tax_types_db.inc
419 # Bug no 1703888, Apostrophes and other unescaped characters, fixed
420 $ /gl/manage/gl_accounts.php
421 /gl/includes/db/gl_db_accounts.inc
422 /includes/ui/ui_input.inc
425 # Bug no 1702594, Logon Loop, fixed
428 -------------------- 1.0a Stable Released ----------------------
430 ! Release 1.0a established on SourceForge, fixing the bugs.
433 # Bug No 1698214, Creating Items, fixed
434 $ /includes/ui/ui_lists.inc
435 # Bug no 1698216, Item Movements, fixed
436 $ /inventory/manage/items.php
438 -------------------- 1.0 Stable Released ----------------------
440 ! Release 1.0 established on SourceForge.
442 2. Copyright and disclaimer
443 ---------------------------
444 This application is opensource software released under the GPL. Please
445 see source code and the LICENSE file