PhreeBooks Release 1.2

// 2007-09-13 Change log, release 1.1 to Release 1.2
/doc/manual/ch01-Introduction/04-02-Rev1p2.html (this file)
/doc/manual/ch01-Introduction/04-RevHistory.html
/includes/version.php

// *************************** sql statements ***************************//
// sql statements are rolled into the base release and incorporated into the updater script for automatic db update
/modules/install/sql/current/tables.sql
DELETE - /modules/install/sql/current/install_data.sql
/modules/install/updater.php

// 2007-09-21
ALTER TABLE shipping_log ADD actual_date DATE NOT NULL DEFAULT '0000-00-00' AFTER deliver_date;

// 2007-10-04 - add configuration values for telephone1 and email address fields
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ( 'Account Telephone 1 Field Required', 'ADDRESS_BOOK_TELEPHONE1_REQUIRED', '0', 'Whether or not to require telephone 1 field to be entered in accounts setup (vendors, customers, employees)', '7', '7', NULL , '2007-10-04 00:00:00', NULL , 'cfg_keyed_select_option(array(0 => ''false'', 1=> ''true''),' ), ( 'Account Email Address Field Required', 'ADDRESS_BOOK_EMAIL_REQUIRED', '0', 'Whether or not to require the email address field to be entered in accounts setup (vendors, customers, employees)', '7', '8', NULL , '2006-10-04 00:00:00', NULL , 'cfg_keyed_select_option(array(0 => ''false'', 1=> ''true''),' );

// change inventory_assy_list table type to innoDB
ALTER TABLE inventory_assy_list ENGINE = innodb
ALTER TABLE journal_main DROP recur_times;
ALTER TABLE journal_main CHANGE recur_remain recur_id INT( 11 ) NULL DEFAULT NULL;

$db->Execute("ALTER TABLE " . TABLE_INVENTORY_HISTORY . " DROP usage_id");
CREATE TABLE inventory_cogs_usage (
id INT(11) NOT NULL auto_increment,
journal_main_id INT(11) NOT NULL,
qty FLOAT NOT NULL,
inventory_history_id INT(11) NOT NULL,
PRIMARY KEY (id),
INDEX (journal_main_id, inventory_history_id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT = 'Relates inventory usage with inventory purchase history';

CREATE TABLE inventory_ms_list (
id int(11) NOT NULL auto_increment,
sku varchar(15) NOT NULL,
attr_name_0 varchar(16) NULL,
attr_name_1 varchar(16) NULL,
attr_0 varchar(255) NULL,
attr_1 varchar(255) NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB CHARSET=latin1 COMMENT = 'Holds inventory master stock attribute information';

DROP TABLE address_format;
ALTER TABLE zones DROP countries_iso_code_2, DROP zone_country_id;
ALTER TABLE zones DROP INDEX countries_iso_code_2;

// *************************** code changes ***************************//

// 2007-09-17 Improve storage/recall of payment methods
// 2007-09-18 Added default value to banking deposits and payments ID field, fixed language field hard coded english
/modules/services/payment/language/en_us/modules/moneyorder.php
/modules/services/payment/modules/moneyorder.php
/modules/banking/forms/bills_detail.php
/modules/banking/classes/banking.php
/modules/banking/functions/banking.php
/modules/banking/bills.php
/modules/banking/popup_bills.php
/modules/banking/popup.php
/modules/banking/javascript/banking.js
/modules/banking/language/en_us/language.php
/modules/gen_ledger/language/en_us/language.php
/modules/orders/invoice_mgr.php

// 2007-09-17 Fix Nova merchant to use new Virtual Merchant Service (Drop ViaKLIX)
DELETE - /modules/services/payment/modules/cc.php - not used (needed to be tied to a merchant)
DELETE - /modules/services/payment/language/en_us/modules/cc.php - not used
DELETE - /modules/services/payment/modules/nova.php - obsolete (nova has updated to Virtual Merchant)
DELETE - /modules/services/payment/language/en_us/modules/nova.php - not used
/modules/services/payment/modules/nova_xml.php
/modules/services/payment/language/en_us/modules/nova_xml.php

// 2007-09-18 Added short name to entry builder for forms to save space, USPS include bug
/modules/reportwriter/classes/entry_builder.php
/modules/services/shipping/modules/usps.php
/modules/services/shipping/language/en_us/modules/usps.php
/modules/services/shipping/modules/fedex.php
/modules/services/shipping/language/en_us/modules/fedex.php

// 2007-09-19 Fixed bug where ship address id is not set when direct entry orders are made with the ship address update box not checked.
/modules/orders/classes/orders.php

// 2007-09-20 bug in FedEx label request when a contact name is present
/modules/services/shipping/modules/fedex.php
/modules/services/shipping/ship_mgr/fedex.php

// 2007-09-20 Added UPS ship manger functionality
/modules/services/label_mgr_ups.php
/modules/services/shipping/language/en_us/language.php
/modules/services/shipping/language/en_us/modules/ups.php
/modules/services/shipping/ship_mgr/ups.php
/modules/services/shipping/modules/ups.php
/modules/services/popup_tracking.php
/modules/services/label_viewer.php
/modules/services/label_viewer_image.php

// 2007-09-25 Bug in chart of accounts for non-numeric account numbers
// 2007-09-26 - Fix bug in loading security for setup choices
/modules/setup/classes/chart_of_accounts.php
/modules/setup/popup_setup.php
/modules/setup/classes/countries.php
/modules/setup/classes/currency.php
/modules/setup/classes/departments.php
/modules/setup/classes/dept_types.php
/modules/setup/classes/inv_tabs.php
/modules/setup/classes/tax_auths.php
/modules/setup/classes/tax_rates.php
/modules/setup/classes/zones.php

// 2007-10-01 - Fix bug in unchecking paid field if an invoice is re-posted. Added notification for paid invoices.
// 2007-10-04 - Added condition for secondary sort on purchase_invoice_id if sorting by post date.
/modules/orders/orders.php
/modules/orders/forms/orders_detail.php
/modules/orders/functions/orders.php
/modules/orders/popup.php
/modules/orders/language/en_us/language.php
/themes/default/css/stylesheet.css
/modules/orders/javascript/orders.js

// 2007-10-01 - bug in import beginning balances not handling thousands separator properly
/modules/gen_ledger/classes/beg_balances_imp.php

// 2007-10-01 - bug in security settings not allowing entry due to no privileges
/modules/setup/setup.php
/modules/setup/popup_setup.php

// 2007-10-02 - fixed bug where non-stock SKU types were passing through COGS with no action except adding to cogs_owed table
// 2007-10-03 - Added auto-increment to payment reference number payments in all cases (i.e. consecutive checks)
// 2007-10-04 - Added update to unit_cost for inventory item during assembly
// 2007-10-10 - fixed bug recalculating assembly when purchase/receive was reposted.
/modules/gen_ledger/classes/gen_ledger.php

//2007-10-02 - Added column in Sales and purchases when opening posted orders toshow SO/PO number
/modules/orders/popup.php

// 2007-10-03 - Moved bank deposit slips to banking tab from general ledger
/modules/reportwriter/language/en_us/language.php

// 2007-10-03 - Fixed form builder when no date field is needed
/modules/reportwriter/form_generator.php

// 2007-10-04 - Added user configuration setting for email required and telephone1 required
// 2007-10-04 - Pre-loaded gl account on line item based on vendor selected from their default information
/modules/orders/forms/orders_detail.php
/modules/accounts/forms/accounts_detail.php
/modules/accounts/functions/accounts.php
/modules/accounts/accounts.php
/modules/accounts/popup.php
/modules/install/updater.php
/modules/setup/configuration.php

// 2007-10-04 - added check for stock and inactive flag when posting orders
/modules/orders/orders.php
/modules/inventory/popup.php

// 2007-10-05 - fixed bug in inventory assemblies erasing BOM during save when items have been sold
// 2007-10-08 - Added capability to change SKU (rolls change throughout db and history)
// 2007-10-08 - Added click to edit anywhere in inventory row
// 2007-10-10 - Fixed sorting order on assembly open window
/modules/inventory/inventory.php
/modules/inventory/popup_assy.php
/modules/inventory/forms/inventory_detail.php
/modules/inventory/forms/inventory_main.php
/modules/inventory/language/en_us/language.php

// 2007-10-09 - increased number of so and po open list length
/modules/general/boxes/so_status.php
/modules/general/boxes/po_status.php

// 2007-10-09 - fixed bug restricting deleting shipping and billing addresses
/modules/accounts/accounts.php
/modules/accounts/forms/accounts_detail.php
/modules/accounts/functions/accounts.php

// 2007-10-09 - change link to help file non-ssl for all cases.
/includes/header.php

// 2007-10-10 - Added site search (needs more work)
/modules/general/language/en_us/language.php
/includes/menu_navigation.php
/includes/security_tokens.php
/includes/filenames.php
/modules/general/search.php
/modules/general/forms/search_detail.php

// 2007-10-10 - fix bug in inventory adjustments and assemblies when editing causes main id to re-set and messes up inventory history and re-posts.
/modules/inventory/assemblies.php
/modules/inventory/adjustments.php

// 2007-10-11 - fixed defines for control panael modules to allow for languages other than english
/index.php
/modules/general/boxes/personal_links.php
/modules/general/language/en_us/boxes/personal_links.php
/modules/general/boxes/po_status.php
/modules/general/language/en_us/boxes/po_status.php
/modules/general/boxes/so_status.php
/modules/general/language/en_us/boxes/so_status.php
/modules/general/boxes/todays_sales.php
/modules/general/language/en_us/boxes/todays_sales.php

/********************************** SVN UPDATE 10/12/2007 **************************************************/

// 2007-10-12 - fixed language for sort headings
/modules/general/functions/html_functions.php
/modules/general/language/en_us/language.php

// 2007-10-12 - Added ability to make direct payments (Point of Purchase) by Purchae/Receive with payment icon direct to bills payment
// 2007-10-12 - Fix reload of orders is an error due to no customer/vendor ID
/modules/orders/orders.php
/modules/orders/javascript/orders.js
/modules/orders/forms/orders_detail.php
/modules/banking/bills.php

// 2007-10-12 - Added ability to copy users information to a new user account.
/modules/general/users.php
/modules/general/forms/users_main.php
/modules/general/language/en_us/language.php

// 2007-10-12 - changed listing on control panel to primary name from SO/PO number
/modules/general/boxes/po_status.php
/modules/general/boxes/so_status.php

// 2007-10-15 - Replaced (real) with $currencies->clean_value for various number formating compatibility.
// 2007-10-26 - Fixed bug adding shipping addresses to existing accounts
/modules/banking/classes/banking.php
/modules/banking/bills.php
/modules/gen_ledger/beg_balances.php
/modules/gen_ledger/classes/gen_ledger.php
/modules/inventory/fields.php
/modules/inventory/inventory.php
/modules/orders/orders.php

// added a few tables when purging journal entries
/modules/gen_ledger/utilities.php

// fixed import inventory beginning balance bug rolling inventory history
/modules/gen_ledger/classes/beg_balances_imp.php

// 2007-10-15 - Added functionality for Customer Payments (Returns) and Vendor Receipts (Refunds)
/includes/security_tokens.php
/includes/menu_navigation.php
/modules/general/language/en_us/language.php
/modules/banking/bills.php
/modules/banking/language/en_us/language.php
/modules/banking/forms/bills_detail.php
/modules/banking/popup.php
/modules/banking/javascript/banking.js
/modules/banking/functions/banking.php
/modules/orders/orders.php
/modules/orders/classes/orders.php

// 2007-10-15 - re write inventory adjust (not handling re-post properly)
DELETE - /modules/inventory/classes/inventory.php
/modules/inventory/adjustments.php

// 2007-10-15 - fixed price sheet manager direct entry not holding selection chioce
/modules/inventory/popup_price_mgr.php
/modules/services/pricesheets/forms/forms_edit.php
/modules/services/price_sheets.php

// 2007-10-15 - Added ability to remove image from inventory sku
/modules/inventory/inventory.php
/modules/inventory/forms/inventory_detail.php

// 2007-10-16 - Add recur operation to orders functions
/includes/filenames.php
/modules/orders/recur.php
/modules/orders/orders.php
/modules/orders/popup.php
/modules/orders/classes/orders.php
/modules/orders/functions/orders.php
/modules/orders/forms/orders_detail.php
/modules/orders/javascript/orders.js
/modules/orders/language/en_us/language.php
/modules/general/classes/toolbar.php
/modules/gen_ledger/classes/gen_ledger.php
/modules/general/language/en_us/language.php

// 2007-10-17 - Add master stock capability
/modules/inventory/inventory.php
/modules/inventory/language/en_us/language.php
/modules/inventory/forms/inventory_id.php
/modules/inventory/forms/inventory_main.php
/modules/inventory/forms/inventory_detail.php
/modules/inventory/functions/inventory.php
/includes/database_tables.php
/modules/install/updater.php
/modules/install/sql/current/tables.sql

// 2007-10-19 - fixed inventory adjustment popup to display number of adjustments
/modules/inventory/popup_adj.php

// 2007-10-19 - fixed bug when assembling a positive number when qty in stock is negative and total will still be less than zero
/modules/inventory/assemblies.php

// 2007-10-22 - fixed bug in cost of good sold calculation not calculated correct (restructured operation) - NOT BACKWARD COMPATIBLE
/modules/install/updater.php
/modules/gen_ledger/classes/gen_ledger.php
/modules/install/sql/current/tables.sql
/includes/database_tables.php
/modules/gen_ledger/classes/beg_balances_imp.php
/modules/inventory/assemblies.php
/modules/gen_ledger/utilities.php

// 2007-10-24 - fixed error in search when entering sript
/modules/general/forms/search_detail.php

// 2007-10-25 - RE-wrote database tables installation script to use php modifyable setting (for language translation)
/modules/install/updater.php
/modules/install/sql/current/tables.sql
/modules/install/includes/modules/pages/database_setup/header_php.php
/modules/install/includes/languages/en_us/chart_of_accounts_types_list.php
/modules/install/includes/languages/en_us/config_data.php
/modules/install/includes/languages/en_us/countries_list.php
/modules/install/includes/languages/en_us/currencies_list.php
/modules/install/includes/languages/en_us/import_export_list.php
/modules/install/report_list.php
/includes/database_tables.php

// 2007-10-26 - Code cleanup
/modules/services/payment/modules/cod.php
/modules/services/payment/modules/freecharger.php
/modules/services/payment/modules/moneyorder.php
/modules/setup/classes/zones.php

/********************************** SVN UPDATE 10/26/2007 **************************************************/

// 2007-10-29 - Restructured installation to allow for language translations of pre-configured settings
DELETE - /modules/install/sql/current/install_data.sql
/modules/install/includes/modules/pages/database_setup/header_php.php
/modules/install/includes/modules/pages/admin_setup/header_php.php
/modules/install/includes/templates/template_default/templates/admin_setup_default.php
/modules/install/sql/current/tables.sql
/modules/install/includes/languages/en_us/chart_of_accounts_types_list.php
/modules/install/includes/languages/en_us/config_data.php
/modules/install/includes/languages/en_us/countries_list.php
/modules/install/includes/languages/en_us/currencies_list.php
/modules/install/includes/languages/en_us/import_export_list.php
/modules/install/includes/languages/en_us/state_province_list.php
/modules/install/report_list.php
/includes/application_top.php
/my_files/reports/GeneralLedgerTrialBalance.rpt.txt