/chronique/doc/Change.log

Large files files are truncated, but you can click here to view the full file

webERP Change Log

7/1/12 Release 4.06.6

7/1/12 Phil: José Roberge (robergej) reported that purchase invoice tax on tax was not being processed correctly although it was appearing on the supplier invoice during entry of the invoice the processing was not calculating the tax on tax. Fixed SupplierInvoice.php
7/1/12 Phil: Brian May reported that was unable to add completed (fully received) lines off a purchase order against a shipment. Removed trap to allow completed (fully received) lines to be added.
5/1/12 Phil: Brian May reported issues with entering shipments discovered parameter DecimalPlaces missed off adding line to shipment also quotation error in entering shipment ETA date.

3/1/12 Release 4.06.5

30/12/11 Phil: install/index.php now checks for the existence of config.php before attempting to run the installation script
29/12/11 Phil: includes/SelectOrderItems_intoCart.inc and includes/DefineCartClass.php fix line numbers for order lines

28/12/11 Release 4.06.4

28/12/11 Phil: SelectCreditItems.php SelectOrderItems.php CounterSales.php includes/DefineCartClass.php fixes for ExistingOrder . $identifier
27/12/11 Phil: PDFStockLocTransfer.php now has include('includes/session.inc') above the title. Fixes to allow manual entry.

22/12/11 Release 4.06.3

22/12/11 Phil: Fix to install/save.php to use mysqli_connect_error to report the connection error
22/12/11 Phil: Shipments.php was not retaining vessel and voyage
20/12/11 Phil: StockLocTransfer.php can now import a csv of items to transfer and each line can be checked to remove if required,
20/12/11 Phil: Fix StockTransfers.php missing brackets around calculation in parameter passed to SQL
15/12/11 Phil: Fix to UpgradeDatabase.php the button to perform the upgrade was missing for older versions where the version was not stored in the DB.
15/12/11 Phil: SalesGraph.php was trying to set background colour to 'selection' changed to white
15/12/11 Vitaly Shevkunov: Shipments.php fixed missing quote in html
14/12/11 Tim Schofield: check_syntax.sh Script for checking syntax of all php scripts in webERP
13/12/11 Vitaly Shevkunov: Z_ChangeStockCode.php fixed call to DB_error_no had missing ($db) - also turned off FOREIGN KEY CHECKS before updating the BOM.
13/12/11 Exson: Fix SelectOrderItems.php and DeliveryDetails.php for where an order is modified while another order is being created in a different tab of the browser - $_SESSION['ExistingOrder'] now modified to $_SESSION['ExistingOrder' .$identifier] as suggested by Tim
13/12/11 Phil: Fixed other scripts affected and send $identifier to add_to_cart and remove_from_cart functions
11/12/11 Phil: SupplierInvoice.php attempts to post back any cost variances where there is no stock left to apportion the variances to - posting back to stockmoves (so the DailySales.php and other sales inquiry scripts reflect the appropriate GP) and the salesanalysis tables
11/12/11 Phil: DailySalesInquiry.php removed incorrect call to establish new cart object??
10/12/11 Brian May: ConfirmDispatch_Invoice.php corrected SQL that was not calculating the difference to go to the orderdeliverydifferences log in parenthesis first before casting/concatenating to string for the SQL.

3/12/11 Release 4.06.2

2/12/11 Phil: Added indian_number_format for specific unusal number formatting 00,00,000.00 for India and apparently South Asian countries. Kicks in for en_IN.utf8 and hi_IN.utf8
27/11/11 Phil: Removed a load of DB_escape_string() calls as no longer required now the entire $_POST and $_GET array are DB_escape_string()'ed
27/11/11 Tim: PrintCustTransPortrait.php added bank account code
27/11/11 Tim: GLTagProfit_Loss Gross Profit calculation error was = COGS - fixed
26/11/11 Phil: SupplierInvoice.php attempt to update salesanalysis cost if goods sold prior to purchase invoice being entered
26/11/11 Phil: Added missing images to aguapop theme - for customer inquiry
26/11/11 Phil: ConfirmDispatchControlledInvoice.php now uses $identifier in session variable name to ensure uniqueness
26/11/11 Phil: PcAssignCashToTab.php removed unecssary DB_escape_string() calls
26/11/11 Phil: StockCostUpdate.php fix link to StockStatus.php
23/11/11 Phil: UserSettings.php - now only checks password if != ''
22/11/11 Phil: StockCategories number_formatting of minumum and maximum values of stock category properties
22/11/11 Felix Lim: StockSerialItems.php closing quote typo.
21/11/11 Phil: UserSettings.php now checks for at least 5 character passwords WWW_Users.php CustLoginSetup.php and SupplierLoginSetup.php now also check for 4 character userids
21/11/11 Felix Lim: WWW_users.php malfomed <input type="hidden" - with no closing >
20/11/11 Phil: Shipments.php now only allows purchase order items to be added to a shipment where the shipment is authorised. Completed, rejected, cancelled orders no longer show.
20/11/11 Phil: Shipments.php now shows quantities to the number of decimal places defined in the stock master and amounts in the currency of the purchase order.
20/11/11 Phil: PO_Header.php purchase orders cannot be cancelled now if they are on a shipment - need to remove from the shipment first

19/11/11 Release 4.06RC3 - 4.06.1

19/11/11 Phil: SupplierAllocations.php fixes for number_formatting
19/11/11 Phil: CounterSales.php fixes as made to SelectOrderItems.php for discount/price - also AmountPaid not run through filter_number_format on display only when the value is used.
19/11/11 Phil: Fixes to SelectOrderItems.php and associated scripts to prevent issues with discount entry and price modifications
19/11/11 Phil: ConfirmDispatch_Invoice.php and ConfirmDispatchControlled_Invoice.php now use $idenfier in the $SESSION name to avoid $_SESSION conflicts.
19/11/11 Phil: MiscFunctions.php filter_number_format now checks for several . in numbers and removes all exlcuding the last to ensure SQL compliant numbers returned.
16/11/11 Phil: Prices_Customer.php sql error had neglected to include currencies table to get the number of decimalplaces to show
16/11/11 Phil: reportwriter/WriteReport.inc modified to use OutputD function in class.pdf.inc
15/11/11 Phil: includes/LanguageSetup.php was not including LanguagesArray.php in reportwriter as PathPrefix was not prepended
14/11/11 Don Grames: AgedDebtors.php now ignores balances with an absolute value of < 0.005
14/11/11 Dafydd Crosby: Allow serialised perishible items to have expiration dates.

13/11/11 Release 4.06RC2

12/11/11 Phil: Purchase order Order_Value in includes/DefinePOClass.php now only looks at the value of lines left on the order after deleted lines
12/11/11 Phil: Removed old Numbers to words class code - this code was not in keeping with the rest of the system and not PHP 5 compatible anyway. Replaced with a much simpler function. This code is only used for pre-printed cheques - so it is in that script only. The new function may not effective for other languages but will be easily adapted as needed. The PrintCheque.php script needs to be modified specifically for the business stationery.
10/11/11 Phil: added a function in includes/SQL_CommonFunctions.inc EnsureGLTransBalance that looks at the gltrans entries for a given transaction type and type number and if the total is not zero and less than 0.05 it fudges the largest gltrans record to make the gltrans balance in total - added to ConfirmDispatch_Invoice.php Credit_Invoice.php SelectCreditItems.php CounterSales.php Payments.php CustomerReceipt.php
10/11/11 Phil: includes/DateFunctions.inc fixed GetPeriod function to create new period when just one month ahead of last period - worried about this can't see how it could have been like this so long without a bug report?
10/11/11 Phil: includes/LanguageSetup.php now sets LC_NUMERIC locale category after LC_ALL to ensure SQL compliant calculations
8/11/11 Phil: includes/GetConfig.php no longer casts the VersionNumber to a double - issue highlighted by Tim
8/11/11 Felix Lim: includes/InputSerialItems.php and InputSerialItemsKeyed.php now sends $identifier
8/11/11 Phil: CustomerReceipt.php now shows entries made with decimal places of the currency being entered
8/11/11 Phil: fixed bugs reported by Ron Wong and Don SelectSupplier.php sql error missed "s" off suppliers and CustomerReceipt.php - had not populated new class variable (property) of CurrDecimalPlaces

6/11/11 Release 4.06RC1

30/10/11 Exson: Modification to Stocks.php to avoid losing PanSize and ShrinkFactor
30/10/11 Phil: Made it so a saleman cannot be deleted if a user is setup referring only to this salesperson
29/10/11 High-Tech Bridge SA Security Research Lab <advisory@htbridge.ch> - sanitising $_SERVER['PHP_SELF'] and unquoted sql in reportwriter/FormMaker.php and reportwriter/ReportMaker.php
15/10/11 Phil: Tried to get correct characters for each language's thousands separator and decimal point in includes/LanguagesArray.php
15/10/11 Phil: Updated PHPplot to 5.5.0
15/10/11 Fred Schuettler aguapop - theme
8/10/11 Ricard: PcExpenses.php PcAuthorizeExpense.php now uses GL tags
8/10/11 Phil: SelectSalesOrder.php now allows for creation of purchase orders for the components of assembly items on sales orders.
29/9/11 Ricard: added new query critera to AuditTrail.php to look for text in query strings to enable searching for updates/inserts/deletes relating to a specified customer or item code etc
22/9/11 Exson: fixed the bug in GLAccountReport.php for typename from the right table (systypes) in SQL and change locale_number_format for multinational.
17/9/11 Phil: Added WindowsLocale element to LanguagesArray.php and modified UserSettings.php and WWW_Users.php to use the new array definition. Also modified includes/LanguageSetup.php to use the windows locale string in the LanguagesArray as required for proper setting of the locale under windows.
17/9/11 Felix Lim: added serialised field into PrintCustTransPortrait.php to reinstate possiblity for printing serialised items on invoice - not possible in landscape version (PrintCustTrans.php)
12/9/11-31/10/11 Phil/Exson/Tom: Change all scripts to allow display and input of numbers in the format of the selected users locale 
5/9/11 Phil: Fixed supplier payment exchange rate ... was being calculated incorrectly from functional exchange rate and the exchange rate between the currency of the bank account and currency of payment.
5/9/11 Phil: GLTransInquiry posted was not retrieved correctly - now fixed
4/9/11 Phil: Removed the stock code from form entities in SelectOrderItems.php and PO_Items.php to prevent issues with some characters in stock codes as suggested by Tim
4/9/11 Marcos Skambraks: SelectOrderItems.php and CounterSales.php removed incorrect !== comparisons sh/been != comparisons
4/9/11 Marcos Skambraks: modified tcpdf.php to just send the pdf header - was causing issues with apache fastcgi module
3/9/11 Ricard: Changed SelectProduct.php to show just current prices
3/9/11 Phil: Changed SelectCustomer to use %% around each parameter to use just a single SQL statement rather than several which ignored other inputs - as suggested by Marcos Skambraks
2/9/11 Phil: Made locale_number_format() as per Tim's instruction that displays numbers in the format of the locale in includes/LanguageSetup.php and replaced all occurrences of locale_number_format() with locale_number_format()
2/9/11 Warren Olds: scaling of image in GetStockImage.php
31/8/11 Ricard: StockAdjustments.php now sends an email to the inventory manager on the creation of manual stock adjustments. The inventory manager email is defined in SystemParameters.php - leaving the email address blank will stop any emails from being created.
29/8/11 Ricard: Updated lastcostupdate in StockCostUpdate.php
29/8/11 Phil: Reinstated stockmaster.lastcostupdate field - added update to lastcostupdate in WorkOrderReceive.php
27/8/11 Phil: WorkOrderIssue.php now allows issue of 0 cost items to the work order - in the event that customer supplied product needs to be included in a work order and the quantities maintained for accountability to the customer
26/8/11 Pablo Martin: Fixed bugs in ConnectDB_mysql.inc in DB_Txn_Commit and DB_Txn_Begin was using msql functions not mysql functions!!
23/8/11 Phil: Added BuyerName to Delivery Details and the cart class
23/8/11 Ricard: PDFPrintLabel Does Not display discontinued items and now allows printing of future price labels
21/8/11 Phil: Fixed bug that duplicated purchase order items when more than one item was added to an existing purchase order
21/8/11 Phil: BackupDatabase.php Delete link now deletes any backup files in the company directory in case any were left there before - as this is a serious security issue if files are left on the web-server
19/8/11 Phil: Fixed bug in Stocks.php should have used Date($_SESSION['DefaultDateFormat']) instead of Date('Y-m-d') inside GetPeriod function as pointed out by Ricard
16/8/11 Tim: SelectCustomer.php fixed selection of customer where the first one was selected needed /to kick off count at 0.
19/8/11 Phil: Remove redundant field stockmaster.lastcurcostdate
19/8/11 Ricard: Fine tuning formatting PDFStockNegatives.php
19/8/11 Carlos Urbieta Cabrera: security.png image was missing now added
14/8/11 Phil: SystemParameters.php default ProhibitPostingsBefore to 1900-01-01 when no default is currently set - can cause errors at the moment as defaults to the latest period if not previously set.
14/8/11 Phil: Stocks.php now does a journal for any work in progress on a change of category where the new category has a different GL account for WIP - and bug fixes as per Ricard
12/8/11 Phil: Backed out changes on 7/8 that prevented SelectProduct.php transaction links - now only purchase order links blocked if an item is obsolete
12/8/11 Phil: CounterSales.php apply discountmatrix fixes
11/8/11 Phil: GoodsReceived.php now has checkbox to flag the order line as complete - even though the quantity delivered might be short of the order quantity.
11/8/11 Phil: PO_Items.php link to complete uncompleted lines - status of order is changed to complete is all lines are completed
10/8/11 Phil: POReport.php added link to detail purchase order inquiry
10/8/11 Phil: PO_SelectPurchOrder.php and outstanding purchase order searches now show the delivery date (from the purchase order header) line items may have different delivery dates.
10/8/11 Phil: Stocks.php changing the stock category to one with a different stock account now creates a journal (if stock is linked to GL) to move the cost of the stock from the old GL account to the new GL account
7/8/11 Phil: SelectProduct.php now disables transactions on items flagged as obsolete (discontinued). /Also obsolete items are shown as such in the selection list - suggested by Klaus (opto)
7/8/11 Ricard: Corrected INNER JOIN ON clause in sql used in InventoryQuantities.php script
7/8/11 Klaus: Added docuwiki links to WikiLinks function in MiscFunctions.php and allow Docuwiki option in SystemParameters.php
6/8/11 Ricard: SalesInquiry.php fix wording of labels to be more consistent with the rest of webERP
6/8/11 Phil: PO_Items.php now has checkbox to select items that have purchasing data entered for the supplier ordering from - as per Klaus's (opto) suggestion
6/8/11 Exson: Added leadtime to the link from SelectProduct.php so that delivery dates used when creating purchase orders make sense
4/8/11 Phil: Fix GP Percent reported when discounts updated by discount matrix
4/8/11 Phil: Make PO_SelectOSPurchOrder.php behave similarly to SelectPurchOrder.php (for inquiries) where the order number is the link that takes you to the order
4/8/11 Ricard: SalesInquiry.php now shows net sales after discounts
31/7/11 Phil: PO_Header.php - was not updating when update hit as reported by Klaus(opto)
31/7/11 Phil: BackupDatabase.php script
30/7/11 Phil: SelectCreditItems.php made it so if several sessions creating a credit note they no longer over-write each other.
30/7/11 Ricard: POItems.php now checks for return of more than 1 purchasing data from the supplier and takes the newest record

27/7/11 Version 4.05

27/7/11 includes/LanguageSetup.php now checks for existence of LC_MESSAGES (it doesn't exist on windows servers) and uses LC_ALL as the fall back only
27/7/11 Fixed quoting in PDFSuppTransListing.php, StockReorderLevel.php WhereUsedInquiry.php Z_ReverseSuppPaymentRun.php
26/7/11 SalesCategories.php fixed display of active categories - this script is not used by webERP - only by Mo Kelly's joomla cart application

24/7/11 Version 4.04.5

24/7/11 Phil: CustomerBranches.php check for existance of Shippers and TaxGroups
24/7/11 Phil: CustLoginSetup.php and SuppLoginSetup can no longer edit user accounts - only add 
24/7/11 Phil: Updated Hungarian/German/Portuguese/Japanese translations from launchpad.
22/7/11 Phil: Make link from SelectCustomer.php to CounterSales.php so that sales together with payment can be entered directly against a selected customer.
22/7/11 Phil: Change SelectCreditItems.php and SelectCustomer.php to select customer and branch using form variables in the same way as SelectOrderItems.php to avoid difficulties with spaces and hyphens - and to be consistent.
17/7/11 Phil: error in taxes GL posting SelectCreditItems.php
9/7/11 Phil/Beth Lesko: Comments not wrapping correctly on quotations - fixed landscape quotation
8/7/11 Phil: Remove duplication of checking for illegal characters - use the same function in MiscFunctions.php ContainsIllegalCharacters in Currencies and the utility scripts Z_ChangeBranchCode.php and Z_ImportStockCodes.php
8/7/11 Phil: Change all strstr occurrences to use multi-byte function mb_strstr
8/7/11 Phil: Trap codes with decimal point "." in them in the IllegalCharacters function
8/7/11 Phil: Fix discount matrix calculations on order entry and amendment
5/7/11 Phil: Amend menu to use PDFStockLocTransfer.php to reprint transfer list - as reported by Ron Wong
3/7/11 Phil: changed all strpos to mb_strpos
3/7/11 Phil: changed all strtoupper to mb_strtoupper
3/7/11 Phil: changed all substr to mb_substr
3/7/11 Phil: changed all <br> to <br />
3/7/11 Phil: changed all strlen to mb_strlen to resolve the issue with multi-byte strlen issues as UTF-8 is a multi-byte character encoding system
3/7/11 Pablo Martin: WorkOrderCosting.php extra comma in SQL after decimalplaces field - now removed
29/6/11 Phil: Bank account to allow default for invoice in currency and also a fall back default to show on invoice where no default for the currency. Modified BankAccounts.php and PrintCustTrans.php (Landscape only) to show the pertinent bank account given the currency of the invoice
28/6/11 Phil: Make assembly items explode into components on packing slips PrintCustOrder_generic.php
28/6/11 Exson: MRPDemands.php links missing ? now fixed - script fixed for quoting variable name CamelCasing
27/6/11 Exson: MRP.php fixed modulus arithmetic that prevented suggesting production quantities where the quantity was less than 1 - the calculation using PanSize should round up to the nearest whole unit to manufacture
26/6/11 Phil: Fixed reference to $_POST['StockID'] in WorkOrderCosting.php when updating the new weighted average cost
26/6/11 Phil: Went back to no number_formatting on PurchData.php
26/6/11 Phil: Went back to no number_formatting on PO_Items.php price and quantity - Brian May still reporting issues
25/6/11 Phil: Made PO_PDFPurchOrder.php have the description of the order item run over several lines where it exceeds the width of the space allowed for it
22/6/11 Phil: Added message to AccountGroups.php to show that child account groups cannot have changes to their account section, their profit and loss or balance sheet and sequence in TB as these properties belong only to parent account groups and are inherited by the kids
23/6/11 Phil: SelectOrderItems.php includes/DefineCartClass.php repaired credit checks 
19/6/11 Phil: Credit_Invoice.php typos in quoting changes preventing posting credits on write offs also sql on gl account selection for write off
18/6/11 Phil: Made up a includes/LanguagesArray.php to contain a list of languages and the translated name of the language - updated WWW_Users.php and UserSettings.php and CustLoginSetup.php to use this array - so the selection of a language uses the language name rather than the locale codes
14/6/11 Phil: Added email to custcontacts and updated AddCustomerContacts.php SelectCustomer.php and Customers.php
13/6/11 Phil: Birthdays (xhtml/indenting/quoting/casing/decimalplaces) for Areas.php, BOMInquiry.php, BOMS.php, BankAccounts.php, BankMatching.php, COGSGLPosting.php, CompanyPreferences.php, ConfirmDispatch_Invoice.php StockLocTransfer.php

12/6/11 Version 4.04.4

12/6/11 Phil: Customers.php included telephone and email from the first branch found - removed as could be confusing. Customer contact information is stored in CustomerContacts and custbranch table
12/6/11 Phil: SupplierCredit.php variables containing value case consistency
9/6/11 Phil: Prices.php now updates the end date of a price when a new default (no end date) price is added
9/6/11 Ricard: PcExpensesTypeTab.php deletion question message fixed as does not delete any expenses set up with this expense type
9/6/11 Daniel Richert: includes/LanguageSetup.php changed to set $Locale = setlocale (LC_MESSAGES, $_SESSION['Language']); as using LC_ALL over-rides numeric and we need decimal points as . - commas stuff things up
9/6/11 Ricard: Added new field current to salesman table to flag if the salesman is currently still on the team or not - modified WWW_Users.php and CustomerBranches to only allow selection of current salesfolk
7/6/11 Phil: EmailCustTrans.php missing closing quote off input hidden InvOrCredit value
6/6/11 Phil: Currencies table included 2 x in SQL for getting invoice details in Credit_Invoice.php
6/6/11 Phil: AddSerialItems.php from Stock Adjustment was not picking up single entries because of error in for loop condition fixed
5/6/11 Phil: BankMatching typo pprintf fixed

3/6/11 Version 4.04.3 Release

2/6/11 Phil: ConfirmDispatchControlled_Invoice.php type include/InputSerialItems.php
2/6/11 Phil: modified build script to include audittrail table in weberp-new.sql and weberpdemo.sql - excluded by mistake
2/6/11 Phil: UpgradeDatabase.php manual upgrades from 3.11.x 4.01 and 4.02 now fixed! Brian May's report
31/5/11 Phil: GetConfig.php amended so that an earlier version without the emailsettings table does not choke before getting to the UpgradeDatabase.php option - reported by Brian May

30/5/11 Version 4.04.2 Release

30/5/11 Phil: Invoicing of serial items was not happening using includes/OutputSerialItems.php script not includes/InputSerialItems.php script
30/5/11 Phil: StockSerialItems.php closing td> tag was missing /
30/5/11 Phil: InputSerialItemsFile.php was looking for a hard coded reports dir now used $_SESSION['reports_dir']
30/5/11 Phil: GetConfig.php checks for existence of the decimalplaces field in currencies and inserts it before attemtpting to run the company SQL...
30/5/11 Phil: PcExpensesTypeTab.php could not delete Expenses lost TabType value fixed
30/5/11 Phil: PriceByCost.php now only makes a new price if the price is actually changed!!

29/5/11 Version 4.04.1 Release

29/5/11 Phil: PricesByCost.php made it so the existing prices had end dates set as yesterday and new prices created from today
29/5/11 Phil: TopItems.php fixed sequence and birthday to script and PDFTopItems.php script
28/5/11 Phil: Could not set controlled item batches/serial numbers on ConfirmDispatch_Invoice.php
28/5/11 Ricard: PO_SelectOSPurchOrder.php was showing select location with gaps between locations - no slash before <option> fixed
28/5/11 Ricard: added new field assigner to petty cash module and changes to PcTabs.php and PcAssignCashToTab.php
28/5/11 Ricard: PcAssignCashToTab.php quoted the $Days integer parameter to the INTERVAL function incorrectly now fixed
28/5/11 Ricard: reported bug on deletion of PcExpensesTypeTab - incorrectly formed URL and parameters added ?
28/5/11 Ricard: reported mismatch of fields scripts pagesecurity changed to int(11) from tinyint as other tables all refer to as int(11)
28/5/11 R2-G: reported alignment issue with link and button on SuppTransGLAnalysis now fixed
28/5/11 Ricard: MRPShortages now has an option to report excesses too
28/5/11 Ricard: Fix sql to take quotes out of literals in upgrade script. PDFPrintLabels fix sql to get current price.
28/5/11 Phil: Reported by Daniel Brewer Fix SelectSalesOrder.php creation of PO with excluding redundant fields in purchorderdetails that were taken out.
28/5/11 Exson: UpdateCurrencyRateDaily was set to 1 when the option to enable it was clicked - should have been set to today's date in SystemParameters - fixed. Now no error reported bu ConvertSQLDate function when user enables update currencies daily.

26/5/11 Version 4.04 Release

26/5/11 Ricard: require securitytoken 9 to allow user to see purchasing data in SelectProduct.php
26/5/11 Phil: SelectProduct.php fix item image display in centre under item transactions
25/5/11 Phil: New Sales Inquiry scripts by sales type/price list by category and top sellers
24/5/11 Phil: Updated from launchpad translations those that had changed from 18/4/11 including Viatnamese, Albanian, Russian, Spanish
23/5/11 Tim: Remove SystemCheck.php and code standards changes(launchpad 4711-4718)
23/5/11 Tim: Make link from SelectProduct.php to place purchase orders factor in the lead time into the delivery date in the purchase order (launchpad 4710)
23/5/11 Exson: fix PaymentMethods could not add new - comma missing in INSERT SQL
20/5/11 Phil: SuppAllocs.php DefineSuppAllocClass.php made display appropriate decimal places to currency of supplier
19/5/11 Phil: SuppInvGRNs.php made display appropriate decimal places to currency of supplier invoice
19/5/11 Phil: SuppTransGLAnalysis.php made display appropriate decimal places to currency of supplier invoice also added an edit option and fixed narrative that was not coming through into GLtrans - also modified DefineSuppTransClass.php to hold the CurrDecimalPlaces variable
16/5/11 Phil: Bug in quantity on purchase order in SelectOrderItems.php added correct join syntax
16/5/11 Phil: Added upgrade from 4.03.7 to UpgradeDatabase.php
15/5/11 Phil: Z_ChangeStockCode.php modified to test if MRP tables exist before doing the updates - turned off error trapping on these queries as the error trapping is done in the script
15/5/11 Tim: FixedAssetCategories prior to deletion of a category check for existing assets in the category failed due to typo in SQL - fixed
14/5/11 Tim: StockTransfer now checks for negative stock before allowing transfer - launchpad changes to 4691
14/5/11 Phil: CustomerInquiry.php now shows the currency decimal places
3/5/11 Phil: Locations.php fix table hidden POST variable quotes mismatch - also mismatch between number of parameters in printf output
2/5/11 Phil: Make order entry show the currency decimal places for amounts and totals also in invoicing SelectOrderItems.php and ConfirmDispatch_Invoice.php
2/5/11 Phil: Fix PO_PDFPurchOrder.php to allow emailing but email option not to appear on printed/emailed orders
1/5/11 Tim PageSecurity.php fix bug that prevented updates to Security Token for a particular script.
1/5/11 Phil: Many scripts quoting changes single quotes for strings double quotes for xhtml variables
1/5/11  Phil: SecuirtyTokens allow deletion of tokens if no scripts using it
28/4/11 Tim: add facility to select an account group to limit GL acccounts returned as options to post payments to
28/4/11 Tim: new SecurityTokens script
28/4/11 Phil: Fix Secunia reported vulnerability by checking for dodgy characters in CompanyNameField - then matched to a real directory on the web-server

18/4/11 - Version 4.03.8 Release

18/4/11 Phil: Update zh_HK.utf8, pt_BR.utf8, fa_IR.utf8 from launchpad translations
18/4/11 Phil: Changed PurchData.php back to now have free form text entry of unit of measure - as suggested by Brian May - think it works better this way
18/4/11 Phil: Removed redundant fields that are not used anywhere from DefinePOClass and the various function to add lines to purchase orders and to update purhcase order lines - netweight, cuft, kgs, itemno, total_quantity etc. all this data can be retrieved without duplication in purchorderdetails
17/4/11 Phil: Reworked PrintCustTrans.php landscape invoice removing reliance on xml. No longer have the ability to use the form designer to manipulate the position of fields on the invoice. The form designer invoice could not print multiple page invoices
16/4/11 Phil: Tim's changes in launchpad fork to 4663 - xhtml syntax fixes
15/4/11 Phil: Copy Exson's traditional Chinese back to zh_HK.utf8
11/4/11 Ricard: new pcAuthorizeExpenses.php that shows the current balance of the tab to the authorizer. Before the authorizer did not see this information.
11/4/11 Tim: StockLocTransfer.php added $_POST['LinesCounter'] -= 10;
11/4/11 Tim/Phil: Use PHP 5 specific scandir to sort languages into alphabetic order for UserSettings and WWW_Users language selection
10/4/11 Tim: AddCustomerContacts.php use single field rather than * in SQL>
10/4/11 Tim: GLAccountInquiry.php  show None if no tag selected
10/4/11 Tim : PDFPrintLabel.php javascript fix
10/4/11 Tim: Add perishable to StockTransfer.php and PDFStockTransfer
10/4/11 Tim: PDFPeriodStockTransListing - new report to print off stock transactions of a specified type for a selected period>/p>
10/4/11 Tim: PDFStockTransListing.php option to print off transactions by inventory location
10/4/11 Tim: Stocks.php - more logical use of $New and $_POST['New']
10/4/11 Tim: Payments.php PaymentMethods.php Add new field userpreprintedstationery to payment methods to determine whether to print cheques
5/4/11 Tim: includes/LanguageSetup.php - discovered solution to Turkish character set problem!!
5/4/11 Phil: couple of is_date functions left over from experiment to see if changing fixed Turkish - now removed from SupplierInvoice.php and PDFOrdersInvoiced.php
5/4/11 Phil: SuppCreditGRNs was not showing old GRNs and no way to input an older date
31/3/11 Phil:Fix link  to create purchase order from purchasing data link on SelectProduct.php - thanks Brian May for pointing out the bug
31/3/11 Phil: Updated all tranlations from the launchpad site
31/3/11 Tim: Fix to make languages display immediately on change - session.inc moved includes/LanguageSetup.php down
30/3/11 Tim: New ReprintGRN.php script takes a purchase order and allows any line received to have GRN(s) reprinted
29/3/11 Phil: checking for unquoted SQL and for SQL where literals quoted with double quotes rather than single - double quotes are not ANSI compatible - so making the SQL more ANSI compatible by doing this as suggested by Tim. Many many scripts involved will take a week or so
<p />
27/3/11 - Version 4.03.5 Release

27/3/11: Phil: fixed SQL upgrade script to add the Z_ChangeSupplierCode.php script is added to the scripts table
27/3/11: Phil: fixed some SQL for ansi compatibility I had changed in error - would affect users running strict mode ansi
27/3/11: Phil: at Brian May's suggestion added conversion factor to item look up in PO_Items.php - also ensured quantity entry no longer trapped for commas and commas removed from numbers before committing. Also trapped for committing purchase orders with no lines

26/3/11 - Version 4.03 Release

26/3/11: Phil: added some error trapping to codes of pcTabTypes 
24/3/11: Phil: rework PDFStockTransfer.php remove a few round trips to DB and added facility to be able to select a transfer number to reprint - added to main menu
24/3/11: James wertthey@yahoo.com Added small image in middle of SelectProduct.php
19/3/11: Phil: added country to packing slips 
18/3/11: Marcos Garcia Trejo: Added Z_ChangeSupplierCode.php 
18/3/11: Ricard: add orderby transdate to DailyBankTransactions.php
18/3/11: Phil: check for Customers.php CustomerBranches.php and Stocks.php  now traps codes containing spaces - as well as other illegal characters
15/3/11: Phil: PricesByCost.php - made it update prices where there is already a price starting on today's date
15/3/11: Phil: SelectOrderItems.php customer selection now done using a hidden $_POST rather than parsing debtorno hyphen branchcode.
15/3/11: Phil: Locations.php new field for CounterSales branch code - instead of parsing it from a single field with a hyphen in it. CounterSales.php now uses the new field for customer branch
14/3/11: Phil: SelectSalesOrder.php now lists with sales order value denominated in functional currency with total of listed outstadning sales orders (or quotations) shown at the bottom of the listing
12/3/11: Tim: Now allow space in codes 
12/3/11: SelectSalesOrder.php now allows any number of sales orders to be selected and purchase orders placed for the aggregate of items on the selected sales orders
12/3/11: SuppPriceList.php removed a round trip to DB to get currency - fixed function to get pdf to new TCPDF Output 
12/3/11: Exson: fix all htmlentities to use ENTQUOTES, 'UTF-8' option so other character sets work with it
10/3/11: Phil: fix pagination of PrintCustOrder_generic.php - second copy was not restarting page numbers
10/3/11: Tims: launchpad fixes brought in MRP.php fix for table charset utf8 so joins work correctly; typeo in PO_Header preventing purchasing data being retrieved ($result not $Result); correct sql on searching for customer in SelectCreditItems.php; StockStatus.php pricing history bug resolved (4450); StockQuantityByDate.php now allowed to show for all categories - enclosed 'All' in gettext
8/3/11: Tim/Phil: PO_Items.php in committing an order detail the assetid of 'Not an Asset' was being inserted to an integer field. Modified $_POST['AssetID'] to = 0 if it was 'Not an Asset' as advised by Tim
8/3/11: Phil: fix SalesAnalysis reports for TCPDF as reported by Joe Zhou
5/3/11: Kovács Attila: fix to Stocks.php to use ANSI GROUP BY for aggregate functions SQL
5/3/11: Kovács Attila: fix to LanguageSetup.php to use utf-8 not ISO-8859-1. Phil hardcoded UTF-8 now as no dynamic changing of character set required all translations are utf-8
3/3/11: Exson/Baran/Phil fix to customer login to ensure that other customers orders are not displayed when searching by customer ref or order no
3/3/11: Tim launchpad mods to revision 4441 including change to allow supplier currency to be changed if there are no transactions already against the supplier.  Ensure credit note session variable is unset before attempting to create a new credit note from the supplier form. Tim's work to add perisable expiry dates to the serial items logic - affects quite a few scripts. Headings to stock check script even if no quantity is shown. Portrait quotations. Not included change to default delivery date to the date the customer requested - left to be the current day's date. Not included Tim's unit pricing work .. yet launchpad revisions 4442-4447 inclusive
27/2/11: Phil/Tim/Peter launchpad added category option for MRPShortages.php links with matching quotes in WorkOrderEntry
27/2/11: Phil: StockUsage.php now totals usage each month even in months where there was none - average now includes months with no usage
27/2/11: Phil: fix units deletion issue reported by Exson in UnitsOfMeasure.php script - checked for none existant units field in contracts table - removed the check
22/2/11: Phil: fix PDFTopItems.php for changed variable names - now using CamelCase tried to rework to conform
22/2/11: Phil: remove options for PDFLanguage that are not unique in WWW_Users.php - make it default to the users settings in the SESSION for UserSettings.php
18/2/11: Phil/Don Change PageSecurity array variable name to PageSecurityArray - caused problems with conflict with PageSecurity variable where register_globals = on; 
18/2/11: Phil: PO_Items.php make locale_number_format variables turn back into numbers for > 1000
16/2/11: Phil: FixedAssetItems.php now checks for location before allowing additions
16/2/11: Phil: Company preferences - changed wording of stock integration at cost removed the word standard as suggested by Exson
16/2/11: Phil: SelectCreditItems.php formating/conventions lower case html and CreditInvoice.php
15/2/11: Phil: Make invoicing warn the user when no taxes are defined for a tax group - i.e. there is a configuration error with taxes
<p />
15/2/11 Release 4.03RC2
<p />
15/2/11: Phil UpgradeDatabase.php fix to upgrade from 4.01RC1 !!
15/2/11: Phil PrintCustTrans.php and PrintCustTransPortrait.php htmlspecialchars_decode($narrative) - conversion at the time of committing to DB needs to be unconverted. Also in ConfirmDispatch_Invoice.php
15/2/11: Phil SelectCustomer.php removed showing blank message when $msg was empty 
<p />
13/2/11 Release 4.03RC1
<p />
13/2/11:Phil GoodsReceivedControlled InputSerialItems and friends - now uses session identifier to ensure uniqueness is several people entering stock receipts
13/2/11:Phil Contracts.php SelectOrderItems.php customer selection mechanism reworked - was causing issues in Contracts as noted by DK Shukla
8/2/11: Tim Rework CounterSales.php so that it is now possible to sell items that have sales/purchasing tax
8/2/11: Phil Fix InventoryPlanning and InventoryPlanningPrefSupplier to only show sales order demand - excluding quotations. Also fixed for conversionfactor as now all purchase order quantities are in our normal stock units
8/2/11: Phil Fix incorrect layout of narrative on multiple lines of PDFQuotation.php as reported by Ricard Andreu
8/2/11: Tim/Ricard StockLocTransfer.php can now transfer the same amount as on hand in the location - previously checked to see that the transfer was less than the quantity on hand (when checking for negative stock)
8/2/11: Tim Payments.php  and javascripts/MiscFunctions.js corrections to javascript
8/2/11: Phil PDFGrn.php turns out preview is used from the form modification script doh!  Over simplificaton reversed to reinstate preview mode
6/2/11: Otandeka Removed debug prnMsg in FixedAssetDepreciation
5/2/11: Phil SystemParameters.php new option to AutoAuthorisePO when the user has authority to do so
5/2/11: Phil PO_Items.php fixed non-existant variables on Enter nominal line. Added option to automatically authorise when user is an authoriser as well as a creator
5/2/11: Phil PDFGrn.php rewrote - preview never used - simplified
4/2/11: Tim CostUpdate.php allow cost update with appropriate permissions token 10 hard coded
4/2/11: Phil SelectCustomer.php rejig selection options in more logical way. Used non-specific SQL to search by any part of the address
2/2/11: Phil PDFTopItems.php and TopItems.php removed mysql specific SQL 
30/1/11: Phil GoodsReceived.php  rework for supplier units and conversion factor etc now in PO class
30/1/11: Phil PDFGrn.php  rework for supplier units and conversion factor etc now in PO class
30/1/11:Exson changed PDFLowGP report remove % from gettext string
29/1/11:Tim fix reportwriter with tcpdf using parent::__construct rather than $this->Cpdf( 
24/1/11:Phil Depreciation fixes - SelectAsset by description fix
23/1/11:Peter Otandeka: PDFTopItems.php  SQL quoting fixes
23/1/11: Phil Fix Depreciation posting and dates of end of periods
23/1/11:Phil changed back references throughout several MRP scripts from is_date to Is_Date - as Is_Date is used throughout the code and much bigger job to change all references to is_date
20/1/11: Tim changed back addinfo calls to addInfo on PDF reports - Zhigio originally thought to be an issue with Turkish utf-8 pdfs but turned out to be a red herring. class.pdf call changed back to addInfo too - most of calls had not been changed to lower case info
20/1/11: Tim changed PricesBasedOnMarkUp to have end date day before new prices effective from
20/1/11: Phil FixedAssetRegister.php FixedAssetDepreciation.php fixes 
19/1/11: Phil modified GLBudgets.php to allow entry of last years budget too
17/1/11: Phil More purchasing work removing redundant queries rationalising code - new layout with supplier units
15/1/11: Tim removed MX record check from IsEmail function in includes/MiscFunctions.php
15/1/11: Tim/Peter Otandeka SQL quoting a whole bunch of scripts - changing single quotes to doubles - didn't apply ones where no variables required quoting
14/1/11: Phil install scripts modified to copy over FormDesigns under the new company directory created
14/1/11: Phil Updates to manual for security and supplier invoice entry
13/1/11:Phil PO_Items.php remove redundant code, setup entry of lines in supplier units
13/1/11:Tim Z_ChangeCustomerCode.php now has foreign key checks defeated when deleting the old customer record and custbranch record 
13/1/11:Phil SupplierInvoice.php and SupplierCredit.php now check to ensure the total of contracts fixed asset charges goods received charges, shipment charges and GL charges are at least equal to the amount of the invoice or credit. It was possible when GL interface turned off to get strange results
12/1/11:Phil DailyBankTransactions.php made it so a range of dates can be selected but defaults to just today
11/1/11:Phil Fix choice of portrait or landscape invoices - fix landscape default form layout. Fix portrait invoice logo position
11/1/11:Phil Fix customer transaction inquiries to show correct links where user is not authorised for credit notes or GL inquiries
11/1/11:Phil SupplierCredit.php and SupplierInvoice.php recalculate price variance to post differences on fixed asset additions correctly
11/1/11:Phil PO_PDFPurchOrder.php - fixed for coding conventions removed uneccessary sql calls
11/1/11: Murray Collingwood: Emailing invoices was writing the pdf file twice  - once with fwrite and once with the TCPDF output function with the option 'F'
8/1/11 Ricard Andreu: Z_ChangeCustomerCode.php added typeid field that made change customer code fail. Also corrected typo for foreign key checking side stepping for Z_ChangeBranchCode.php
5/1/11 Phil: Bug fixes AssetLocationTransfer and Supplier Contacts
4/1/11 Paul T: Bug# 3151192 - insert underscore for superglobal.
5/1/11 Phil: Bug fixes AssetLocationTransfer and Supplier Contacts
4/1/11 Phil: Start rework of purchase order scripts ... again.
4/1/11 Phil: Select Purchase orders now defaults to just pending and authorised/printed - other statii are options
1/1/11 Phil: Upgrade script make capable of upgrades from any earlier version - and email a backup to the user. Deleted DBUpgradeNumber config variable now use the VersionNumber already there
31/12/10 Tim: Tidy up of CounterSales.php - CamelCasing, quoting SQL, closing slashes in xhtml tags
29/12/10 Phil: Reverted to single SQL upgrade file per release - but retaining Tim's upgrade mechanism if the DBUpgradeNumber is out of date. Removed pseudo SQL language required for upgrade script and the 52 update files - just applies plain vanilla SQL from the scripts required
29/12/10 Tim: DB upgrade mechanism with separate pseudo SQL for each database change in a separate file + 52 files of updates since 3.11.4
21/12/10 Phil : Reworked PDFPrintLabels.php to conform to standards and corrected SQL for prices
21/12/10 Ricard Andreu: PDFPrintLabels.php was not checking for end date of prices - fixed
19/12/10 Phil: SelectOrderItems.php ConfirmDispatch_Invoice.php add code to handle asset disposals.
14/12/10 Phil: modify purchasing scripts for coding conventions/readability
11/12/10 Phil: Have populated the new field stockcheckdate in stockcheckfreeze and modified PDFStockCheckComparison to use this field when posting the GL - stockmoves need to be on the current day otherwise historical balances will all need to be updated. But narrative shows the date of the stock check for which the adjustment is being made
9/12/10 James Murray: highlighted a bug in SupplierInvoice.php (and also in SupplierCredit.php) where the due date of the invoice/credit was not calculated correctly based on the terms - it was picking up the current date rather than the invoice/credit date. Now fixed
8/12/10 James Murray: fixed bug in SuppPaymentRun.php - was not showing anything as the test to see if there was anything to see was using a non-existant result set!
3/12/10 Matt Elbrecht : Estonian translation
30/11/10 Phil: Changed table structure of new fixedassettrans and modified upgrade script - those who already ran that bit will need to change the table again. Modified fixed asset scripts again. New fixed assets manual
28/11/10 Exson: CreditStatus.php - Fix bug in sql statement
28/11/10 Tim: OutstandingGRNs.php - Only show when the invoiced qty is less than the GRN qty
28/11/10 Phil: All fixed asset scripts SupplierInvoice.php SupplierCredit.php SuppFixedAssetChgs.php - adding fixed assets directly from invoice charges - and reversing additions with credit notes. Also FixedAssetRegister.php report to print PDF or export CSV of fixed assets now includes date range depreciation and b/fwd cost b/fwd accum depn and c/fwd cost and accum depn - and NBV
28/11/10 James Murray: unset session in ConnectDB_mysqli.inc and ConnectDB_mysql.inc when the login fails
27/11/10 Phil: install/index.php check for critical requirements before allowing install to proceed
27/11/10 Phil: includes/DefinePOClass.php change variable to camel case also PO_Header.php PO_Items.php PO_ReadInOrder.inc GoodsReceived.php - scope for error needs lots of testing please
27/11/10 Phil: PurchData - fix MinOrderQty error trapping with appropriate text and default to 1
27/11/10 Phil: SupplierInvoice.php removed check on weighted average costing to reverse GRN suspense posting and set cost to zero - this was defeating the price variance calculation and the proper valuation of stock. Also took out of the calculations the conversionfactor - will need to alter goods received code to ensure only our units recorded in quantity received.
26/11/10 Tim: upgrade3.11.1-4.00.sql - Add default date for stockcheckdate field in stockcheckfreeze table
26/11/10 Otandeka: CounterSales.php - Fix bug in counter sales script.
24/11/10 Phil: GoodsReceived.php - modified to insert fixedassettrans and to post nominal POs to fixed asset cost account from fixedassetcategories.costact
23/11/10 Pak Ricard: MRP.php and MRPShortages.php fixed temporary tables to use utf-8 - code failed without probably depends on mysql server settings
21/11/10 Phil:Rewritten FixedAssetJournal.php - renamed FixedAssetDepreciation.php
20/11/10 Phil: Rewritten FixedAssetItems.php FixedAssetCategories.php and modified FixedAssetLocations.php to use the new structure
18/11/10 Tim: upgrade3.11.1-4.00.sql - Fix sql syntax errors brought in on recent changes.
14/11/10 Phil: SelectAsset.php script reworked SelectAssetType.php script now deleted
08/11/10 Exson: Z_ImportStocks.php - Bug fixes.
06/11/10 Phil: ShiptChgs.php - made a check to ensure a shipment reference entered manully actually exists before it is added - otherwise a nasty error occurs on commital of the invoice
06/11/10 Paul T: InputSerialItemsSequential.php - Bug# 3080130 - Add new FormID to form. (and minor cleanup)
06/11/10 Tim: ReorderLevelLocation.php - Remove fixed assets from selections
06/11/10 Tim: ReorderLevel.php - Remove fixed assets from selections
06/11/10 Tim: InventoryQuantities.php - Remove fixed assets from selections
06/11/10 Tim: Selectproduct.php - Remove fixed assets from selections
06/11/10 Tim: InventoryValuation.php - Ensure fixed assets dont get shown in valuation report
06/11/10 Tim: FixedAssetItems.php - Fixed typo preventing Item code being shown
06/11/10 Phil: StockCategory.php FixedAssetCategory.php attempt to add validation to depreciation rates by extending the stock category property logic with new fields for numericvalue, minimumvalue and maximumvalue. Then adding the depreciation rate percentage property to expect numeric values with a minimum of 0 and maximum of 100. 
05/11/10 Tim: PurchData.php. Converted field name to lower case for consistency
05/11/10 Tim: SelectProduct.php. Change the standard order quantities to agree with Minimum order qty
05/11/10 Tim: PurchData.php. Make the Minimum order quantity field numeric only
05/11/10 Poul Bjerre-Jensen: SelectProduct.php,PurchData.php. Add in Minimum order quantity to Purchasing data
02/11/10 Tim: SelectCustomer.php. Correction to work with debtors that have a - in the code
31/10/10 Tim: SuppTransGLAnalysis.php. Minor bug fixes
31/10/10 Tim: SuppTransGLAnalysis.php. Force the user to select a GL account code instaed of defaulting to first on the list
31/10/10 Tim: CustomerReceipt.php. Force the user to select a GL account code and a Bank Account instaed of defaulting to first on the list
29/10/10 Tim: index.php. If CustomerReceipt selected from the GL menu then go to GL receipts else customer receipts
29/10/10 Tim: Payments.php. Force the user to select a GL account code and a Bank Account instaed of defaulting to first on the list
29/10/10 Tim: GLJournal.php. Force the user to select a GL account code instaed of defaulting to first on the list
28/10/10 Tim: Fix bug # 3017709. When bulk transfers are received for controlled items serial numbers are required
28/10/10 Tim: PcExpensesTypeTab.php - SQL quoting corrections and layout changes and improvements
28/10/10 Tim: PcTabs.php - SQL quoting corrections and layout changes and improvements
28/10/10 Tim: PcTypeTabs.php - SQL quoting corrections and layout changes and improvements
27/10/10 Tim: PcReportTab.php - SQL quoting corrections and layout changes and improvements
27/10/10 Tim: PcClaimExpensesFromTab.php - SQL quoting corrections and layout changes and improvements
27/10/10 Tim: class.pdf.php - Fix bug in html_entity_decode() function call
27/10/10 d.k shukla: ManualPurchaseOrdering.html - Improvements to purchase ordering manual
27/10/10 Tim: WorkOrderEntry.php - When the quantities are changed, then the correct quantities are updated, and the date picker chooses the correct date.
27/10/10 Tim: header.inc - Correct for non asc…