20/6/06 Steve PDFSalesAnalysis lowercasing missed a few field names now corrected Cols ColNo etc. Various scripts added rounding

8/6/06 Z_ChangeBranchCode.php fixed sql for taxauthority to taxgroupid and some typos

8/6/06 GLAccounts.php fixed to allow deletions of a GL account where there are no postings to it. chartdetail records also deleted.

8/6/06 Steve K SpecialOrder.php - Location code not inserted correctly double up of contact ... lower casing errors fixed.

31/5/06 index.php link to PDFDIFOT.php delivery in full on time report

31/5/06 added Steve Ks PrintCustTransPortrait.php option added new config variable and changed the SystemParameters.php script to allow the variable to be switched. Changed all scripts that call PrintCustTrans.php to look at the new session variable before printing

30/5/06 Steve K - 'lots of changes' - ConfirmDispatchInvoice changes to
from

, format of customer name, moved link to sales orders to top. - CustEDISetup.php added link to customers form - CustomerAllocations.php added customer code to table display - fixed sql date format - Customers.php modifications to display and wording of strings - DeliveryDetails.php link back to sales order moved - wording changed to New Order - FreightCosts.php now allows selection of tax category - part of improved handling of tax on freight costs - GLAccounts.php removed tabindex statements - index.php - changed wording of links - reduced verbosity - POHeader.php has link back to outstanding purchase orders - POItems.php has link at top back to header - SelectOSPurchOrder.php new order link - PrintCustOrder_generic.php added debtorno - SelectCustomer.php now has search on phone no - SelectOrderItems.php customer selection based on phone - reduced wording of links - SelectProduct.php moved around submenu - changed wording of links - SelectSalesOrder.php shows if printed or not and links to print if not printed - SelectSupplier.php now orders by supplier name not supplier id - StockCostUpdate.php now checks for existence of the item whose cost is changed! - includes/header.inc changed name of shortcut links to customers items suppliers

16/5/06 Harald Ringehahn includes/ConstructSQLForUserDefinedSalesReport.inc not using 'Not Used" rather than _('Not Used')

16/5/06 Harald Ringehahn includes/PDFSalesAnalysis.inc ColNo and colNo should be colno fixed lower casing.

2/5/06 Matthew Sibson EDIProcessOrders.php quotation marks and semi colon. PDFLowGP.php missing bracket on if. Z_DeleteInvoice.php missing = and } sh/be ]. reportwriter/WriteForm.inc was testing for numerical month numbers fixed to text for month strings.

25/4/06 Ditesh Kumar includes/DBConnect_mysql.inc now uses mysql_real_escape_string rather than mysql_escape_string the former takes into account the character set in use.

25/4/06 Suren Nadu includes PDFTransPageHeader.inc - was printing address line 3 twice changed to print line 6 correctly

25/4/06 Steve K ConfirmDispatch_Invoice.php wording of error message had superfluous "the"

25/4/06 Steve K Z_MakeNewCompany has the restriction to 10 character company codes removed and option to create DB is optional with a checkbox now.

25/4/06 SelectSupplier, SelectOrderItems SelectCustomer now have selections ordered by supplier/customer code

25/4/06 Steve K - SalesAnalRepts.php fixed Not Used translations and comparison test to always use the non-translated Not Used and display the Not Used translation

25/4/06 Steve K - SelectItemsInto Cart.in fixed case of $myrow['DiscountCategory']

25/4/06 Steve K - SelectCreditItems.php includes/DefineCartClass.inc CreditInvoice.php SelectOrderItems.php fixes for garbled line numbers

3/4/06 Greg Morehead - CustomerAllocations.php missing $_SESSION['DefaultDateFormat'] for FormatDateForSQL statement.

2/4/06 Steve SalesAnalRepts.php no VALUE in Select OPTION statement

31/3/06 Jesse Peterson - indexed serialno in stockserialmoves and stockserialitems for performance reasons in larger dbs

30/3/06 Harald Ringehahn - includes/GetSalesTransGLCodes.inc error in SQL extra comma removed

29/3/06 Jesse Peterson/Kyle Sasser StockAdjustment.php unset the Adjustment session variable on entry of an incorrect item code to avoid problems as reported by Kyle.

29/3/06 Neil Williams CompanyPreferences.php now reloads session variables after an update.

22/3/06 Harald Ringehahn GLAccounts.php fixed incorrect call to _() function inside prnMsg function call and added TABINDEX to sequence focus on tabs

16/3/06 Ditesh Kumar - reversed order of period selection to show latest periods first.

16/3/06 Marcos Garcia - footer.inc now displays time in the locale of the language selected.

23/2/06 Danie - ReportMaker.php - Fixed small warning log about $DefaultReports not existing when there are no reports

23/2/06 Ditesh - GetSalesTransGLCodes.inc - Patched to check for area='AN', stkcat='ANY', salestype=$salestype

23/2/06 Danie - StockCostUpdate.php - Fixed dodgy update which might corrupt with delayed posting, now check/get the cost on post

23/2/06 Steve - ConfirmDispatch_Invoice.php - Fixed broken url

22/2/06 Danie - Z_DataExport.php - Fixed CSV Export, to adhere closer to CSV protocol, Fixed TaxLevel to TaxCatId

22/2/06 Danie - Stocks.php - Fix Part descriptions so it displays when description contains html entities

22/2/06 Danie - SelectProduct.php - Time and Uppercase the StockCode and StockID fields, makes finding the product easier.

22/2/06 SelectOrderItems.php - added number formating to price display

22/2/06 Danie - PurchData.php Trim Supplier Description as spacing sometimes mess up the reports when it ends with newlines.

22/2/06 Ditesh - GLAccountInquiry.php Modified to show order based on Transaction Date.

22/2/06 Steve Credit_Invoice.php : Wrong Name Descriptor ->LineNo used Chaned to ->LineNumber.

3/2/06 Steve GLAccounts.php missing opening bracket in prnMsg call - removed extra quotes in StockCategories.php Areas.php was checking for 50 character area description but field only 25 in db

1/2/06 Z_Upgrade3.01-3.02.php now checks to see if its been run already and exits nicely if it has

1/2/06 GLJournal.php SystemParameters.php new config parameter to prohibit entering GL journals directly to control accounts.

1/2/06 Jesse Credit_Invoice.php - nasty bug on return of items used invoice number rather than the order number to update the salesorderdetails

1/2/06 Jesse ConfirmDispatch_Invoice.php and ConfirmDispatch_InvoiceControlled.php corrections for serial items

31/1/06 Greg Morehead Made the wiki links more generic and possible to have other wikis link to webERP.

28/1/06 Joerg Aldinger fixed messages in GLAccounts.php also added DB_escape_string to sql queries

28/1/06 Greg Morehead - PDFOrdersInvoices.php - did not deal with multiple lines of the same item correctly - now adds these order lines together

28/1/06 Muz - ConfirmDispatch_Invoice.php made quantity input field wider to accomodate larger decimal places and quantities.

28/1/06 Muz upgrade_3.01-3.02.sql didn't have a line to insert the new SO_AllowSameItemMultipleTimes variable into the config table

25/1/06 session.inc now DB_escape_string() posted characters into the login text boxes

22/1/06 Clay Mokus CreditItemsControlled.php moved session.inc above call to _()

22/1/06 Finjon Kiang login.php required reference to the character set in the Content Type tag.

22/1/06 Finjon Kiang htmlentities calls in SalesCategories.php now have reference to the character set

22/1/06 Finjon Kiang phpgettext required PathPrefix correction in LagnuageSetup.php

29/12/05 Bug in SalesGLPostings.php could not add or delete records freely - removed checks and added warnings.

20/12/05 Added links to wacko wiki site based on new config options for WackoWiki - the links don't show if integration is disabled and WikiPath from SelectProduct SelectCustomer and SelectSupplier. Requires an install of wacko wiki on the same web-server http://wackowiki.com/WackoDownload/InEnglish?v=xlv

12/12/05 Dave - new form creator options for use with his report builder - most files in the reportwriter subdirectory changed - new sql to allow 5 tables in the query

12/12/05 New delivery performance report PDFDIFOT.php (Delivery In Full On Time - DIFOT) compares order requested delivery date against the date the invoice is prepared - assumed to be the same as the date of dispatch - the number of days that it is acceptable to dispatch product is entered at run time.

9/12/05 Obscure bug in GetPrice.inc - if special prices set up for a salestype/customer combo but not default price set up for the salestype then the special price is picked up for customers belonging to the sales type even though it is specific to a different customer! - now fixed

9/12/05 Danie - StockLocTransfers.php -now checks for positive stock in the location before allowing a transfer.

6/12/05 Updated the webERP php-gettext to the latest version 1.05

3/12/05 Jo� - WWW_Users.php now options to set theme and language before user logs in. Previously had to be set from the user settings when the user logged in themselves now the sysadmin can change them. Changed locale setting to LC_ALL then changed the LC_NUMERIC back to en_GB.

21/11/05 Dave Premo - report writer tool - allows adding reports on any web erp data and formating thereof provided some knowledge of the tables etc. Export to PDF, CSV - import and export of reports too. New directory for the files reportwriter as well as changes to session.inc, header.inc, config.php, footer.inc

16/11/05 Tech Nossomy Credit status - tidied up consistency of wording "Disallow invoices". Also used white and black in .css files instead of #FFFFFF and #000000 respectively

Version 3.04

15 November 2005

15/11/05 Fixed bug in adding new chart details in the function includes/DateFunctions.inc - GetPeriod for all chartdetails not already setup - this was not happening for periods created before the current period only for subsequent periods.

13/11/05 Ed - PaymentTerms.php now checks for payment terms less than 360 days following invoice 99 days was considered too restrictive.

11/11/05 PrintCustTrans.php during translation couldnt translate "Tax" not in _('') function.

9/11/05 Increased the length of the bank account to 30 varchar was text already in pg

8/11/05 Briain - SelectCustomer.php SelectSupplier now have buttons to show all - with the paging the user is protected from massive downloads over dialup.

7/11/05 TaxGroups.php changed to prohibit the same tax group name, automatically enter calculation orders to prevent problems with the same ordered tax authorities. Changed messages when updated and inserted tax groups to show the name of the tax group updated/inserted. Fine tuning all suggested by Steve K.

7/11/05 CustomerBranches.php now displays the name of the taxgroup rather than the id!

6/11/05 Briain - DateFunctions.inc MonthAndYearFromSQLDate fixed for locale using strftime

6/11/05 Briain - fixed CustWhereAlloc - string 'Type' not in _('') function

6/11/05 emdeex - fixed SalesGraph sh/been SalesFolkResult not StockCatsResult and default $_POST['SalesmanCode']

6/11/05 Fixed bug in SuppInvGRNs.php - nominal purchase order items could not be invoiced since the GL code was lost (it wasn't retrieved in the selectable list of outstanding GRNs)

5/11/05 Removed references to css/images/bg.gif in includes/login.php and logout.php

3/11/05 Reported by Ed@unixmania SupplierContacts.php extra ? sh/be an & in the URL string

31/10/05 Translation.txt transferred to a new section in the manual

31/10/05 SalesGraph.php script allows printing various sales graphs by stock category, rep, sales area, item and customer linked from index.php

30/10/05 Steve/Phil Translating document depreciated and a chapter added to the manual to cover translations and the use of the online translation facilities.

29/10/05 Clay pointed out that DB_escape_string() was not used in places it should be in Suppliers.php - now fixed - also checking for apostrophes was not working corrected.

29/10/05 Steve - updates to ManualContents.php, DevelopmentStrucutre, Introduction and Requirements

27/10/05 PO_Items.php removed the references to contracts as per Clay Mokus advice - and fixed error trapping code not to check contracts on 30/10/05

24/10/05 header.inc now sends a header with the charset if headers not already sent - this will work for 90% of scripts that need to know the charset will fail for any output from ConnectDB_XXX scripts.

23/10/05 PDFStarter_ros.inc changed to PDFStarter.php accross the board

23/10/05 included the Olivier Plathey CDI font files for Chinese, Japanese and Korean - with the appropriate fonts installed with the local version of Acrobat Reader these allow pdfs to be created in the Big5 (Chinese), SJIS (Japanese) and UHC (Korean) fonts. Modifications necessary to class.pdf.php to include the appropriate files depending on the locale - eg if the locale is zh_CN - then the Chinese fonts are included and selected.

22/10/05 Ed includes/DefineReceiptClass.php:38: - ($this->Items[$RcptID]->$amount + $this->Items[$RcptID]->$discount) fixed

19/10/05 Jason Jaques missing ' (quote) at the beginning of line 206 of the file StockLocTransferReceive.php

17/10/05 Tony G - bug in translations lost on SelectOrderItems.php and SelectCreditItems.php - actually turned out to be in includes/DefineCartClass.inc _() function defined displaced gettext class scripts.

11/10/05 Greg Morehead - fix to ConfirmDispatch_Invoice.php $_SESSION['Items']->$Orig_OrderDate = $myrow['orddate'];

11/10/05 Greg Morehead - removed references to BrAddX which was not defined in the cart class and changed to DelAddX - not sure how this had worked

9/10/05 Hindra Joshua - addJpegFromFile - changes on 1/1/05 fixed the height and should have focused on the width - the logos are now scaled based on the widths by setting the height argument to 0.

9/10/05 Exchange rate on entering receipts was not checking the correct variable for the currencydefault - now corrected

Version 3.03

1 October 2005

1/10/05 Shipments.php script class was not initiated before the session started so lost the session data each time!

1/10/05 Hindra Joshua pointed out bug - freight cost in order entry not carried through to ConfirmDispatch_Invoice.php

1/10/05 Hindra Joshua pointed out bug - Fixed all logo to PDFs by defaulting the last argument to resize images in proportion

1/10/05 Hindra Joshua pointed out bug - Check to ensure that ex rate other than 1 entered for receipts in FX.

1/10/05 Re-wrote tax report to take account of new tax structure

1/10/05 SupplierInvoice.php and SupplierCredit.php - was not posting tax correctly some GL journals created were out of balance.

29/9/05 Afan Ottenheimer/Miguel de Benito Delgado - Added phplot and an example graph for the usage of stock - new script StockUsageGraph.php

25/9/05 Dave Premo - 2 additional addresses to the address fields on the databases from the current braddress1-4 structure to a braddress1-6 structure. This will allow more uniform database entry and expanded fields needed for future upgrades in shipping and reporting.

17/9/05 Hindra Joshua suggestion - onclick confirm javascript function added to provide a double check on critical deletes and updates accross the system - stocks.php customers.php, custbranches.php, price updates, salestrans delete, selectorderitems.php cancel order - delete a line, creditiems.php delete line cancel the credit note etc

Version 3.02

4th September 2005

4/9/05 Fixed bugs in ReverseGRN.php quotation marks around narrative in a few spots

4/9/05 Fixed bugs in GoodsReceived.php was not allowing update of quantity in a batch/lot where more of the same lot received. Thanks for pointing this out Lior

3/9/05 Suren Naidu - PDF Profit and Loss Account option

3/9/05 Fixed to COGSGLPostings.php and SalesGLPostings.php

3/9/05 made Customers.php META REFESH into Branches.php after adding a new billing address to ensure that a branch is added

3/9/05 Glen Rice - fixed bugs on Z_DeleteCreditNote.php and GLAccountInquiry.php

1/9/05 Steve - default chart of accounts changed to suit Canada/US

1/9/05 TaxProvinces.php script added - to maintain the dispatch tax provinces

30/8/05 TaxCategories.php script added - to maintain the item levels at which taxes are charged

22/8/05 Suren Naidu - PDF Trial balance modifications to GLTrialBalance.php and new script includes/PDFGLTrialBalancePageHeader.inc

22/8/05 Clay Mockus - SelectOrderItems.php bug in the stock code search showing the % in the stock code field after a search fixed.

17/8/05 Colin bug fixes - Stocks.php - double check for existence before adding a new one, includes/Add_SerialItems.php bogus echo $sql GoodsReceivedControlled.php SuppTransGLAnal.php removed link to Contracts - not coded yet!

14/8/05 Suren Naidu option to print balance sheet as a pdf

14/8/05 Ricardo Pedroso - tidy up company login - remove session variable for incorrect company login

9/8/05 SystemParameters.php - now able to set part pics directory and reports directories correctly - bug in rc1

8/8/05 Suren Naidu - ConfirmDispatch_Invoice.php - assembly items with multiples of a single component were not extended by the quantity in calcualting the standard cost of the assembly - fixed

1/4/05-6/8/05 Tax changes to allow multiple taxes per line and compounding taxes on previous taxes - this now allows Canadian and some European taxes to be accomodated. Implemented for invoices, credit notes in AR and AP. New tax groups - allocated to suppliers and customer branches for the basis for the taxes that will apply to invoices in conjunction with the location where the goods/services are provided from - the dispatch tax province - on the stock location record. Tax calculations show on the transaction entry screen but only the totals show on invoices. All the transaction entry work is done - reporting still to be done. Largely as per specs worked on by Danie and Steve

6/8/05 Suren Naidu - Payments.php sql quotation marks error in narrative fixed

23/7/05 Tom Fox - PO_Header.php was printing existing purchase orders as at todays date rather than the date at which it was initiated - fixed

15/7/05 Z_PriceChanges.php lowercased to work with new db

13/7/05 SupplierBalsAtPeriodEnd.php was not taking into account FX diffs that had been realised after the year end. Same for DebtorBalsAtPeriodEnd.php

13/7/05 RecurringOrders templates set to recurr quarterly were only recurring 3 times per annum - now fixed

10/7/05 Added Z_MakeNewCompany.php and modified the rest of the system to allow alternative company login - includes/login.php defaulting to $DefaultCompany in config.php. Also now reading part_pics from a new directory companies/{Company Abbreviation}/part_pics reports and EDI files also kept under the company directory. The new Z_MakeNewCompany.php creates a new database from the sql/mysql/weberp-new.sql or sql/pg/weberp-new.psql depending on which $dbType is set in config.php. The idea for this was prompted by the work done by EDO and ITWorx on behalf of EDO - that was contributed by EDO.

7/7/05 Scott Rosa bug in includes/PDFSalesAnalysis.inc - $columnno should be $ColumnNo

3/7/05 Chris Bice modified StockStatus.php to show bin locations of items for managed locations. Also added BinStockStatus.php

30/6/05 Chris Bice/Jake Stride Locations.php now has flag for warehouse management

30/6/05 Jake Stride postgres upgrade script for 3.01 - 3.02 and Z_Upgrade_3.01-3.02.php to renumber salesorderdetail lines as required

30/6/05 SupplierInvoice.php SupplierCredit.php now allow for entry of multiple taxes

30/6/05 GLAccountInquiry.php checks for entry of period range now

30/6/05 Murray PO_PDFOrderPageHeader.inc changed "THIS IN NOT AN ORDER" to "THIS IS NOT AN ORDER"

30/6/05 SupplierAllocations.php Exch Diff was not in quotes in sql statement - fixed.

Version 3.01 - Bug Fix release

23rd April 2005

5/6/05 Gunnar Rikardsson PO_Header.php Line 218: gettext function missing for 'Reset' Line 363: gettext function missing for 'Deliver to'

5/6/05 Gunnar Rikardsson PO_Items.php Line 777: gettext function missing for 'Leave blank if NOT a stock order' Line 809: gettext function for 'Enter Line' Line 359: If(isset($_POST['UpdateLine']) AND $_POST['UpdateLine']=='Update Line'){ changed to If(isset($_POST['UpdateLine'])){ Line 329: If($_POST['Delete']=='Delete'){ replaced with If($_POST['Delete']){

5/6/05 Gunnar Rikardsson Prices_Customer.php Line 192: gettext function missing for 'All Branches'

5/6/05 Gunnar Rikardsson SalesGLPostings.php Line 167: gettext function missing for 'Discount Account'

5/6/05 Gunnar Rikardsson Stocks.php Line 293: Changed success message to standard formatting with prnMsg function for consistent "look and feel"

5/6/05 Gunnar Rikardsson PurchData.php Line 206: gettext function missing for 'Yes' Line 209: gettext function missing for 'No'

5/6/05 Gunnar Rikardsson StockCheck.php Line 333: gettext function missing for 'Show system quantity on sheets' Line 342: gettext function missing for 'Only print items with non zero quantities'

5/6/05 Gunnar Rikardsson includes/PO_PDFOrderPageHeader.inc Line 114: misspelling: Initator -> Initiator

5/6/05 WorkCentres.php error in sql accountGroup sb/been accountgroup

4/6/05 ConfirmDispatch_Invoice.php includes/DefineCartClass.php - mods to allow mulitple taxes

8/5/05 Shipments.php DefineShipmentClass.php moved below session.inc - fixed bug could not initiate new shipments

8/5/05 SystemParameters.php - Bug Year end December was not working correctly fixed

8/5/05 Gunnar Rikardsson - gettextification bug fixes for Stocks.php StockTransfers.php BankMatching.php StockCounts.php SalesPeople.php PaymentMethods.php GLAccounts.php GLProfit_Loss.php

7/5/05 Braian Gomez - php-gettext included to enable gettext translations using only php no reliance on gettext and locales for translations

3/5/05 Scott Rosa - bug in includes/ContructSQLForUserDefinedSalesAnalysis.inc - custbranch join should be on both debtorno and branch code

1/5/05 Braian Gomez - bug fixes www_users.php passwords using the crypt function and defaults the language and DisplayRecordsMax. DB error messages now attempt to put a page header - DB_connect_mysql.inc and DB_connect_psql.inc

1/5/05 Gunnar Rikardsson gettextification SystemParameters.php

1/5/05 WWW_Users.php DisplayMaxRecords was not using the config variable DefaultDisplayRecordsMax to default the number of records on a display .. the db was set to default to 0 - search functions failing. Now fixed.

30/4/05 re-released 3.00 with corrected DB

29/4/05 db had language field in www_users char(2) sh/be char(5)

Version 3.0

23rd April 2005

13/4/05 David Hawke - fixed pdf printing bug error in addTextWrap - leading spaces not handled

11/4/05 Fix credit check code of 7/4/05 - buggy and fixed again 14/4/05 Tan Hock Chye noted bug where no transactions

9/4/05 Danie: Areas.php - Fix handling of empty fields and make opperation compatible with rest of system.

9/4/05 Danie: Shippers.php - Fix handling of empty fields and make opperation compatible with rest of system.

9/4/05 Danie: StockCategories.php - Fix handling of empty fields and make opperation compatible with rest of system.

9/4/05 Danie: DiscountCategories - Fix automatic use of 0 value should be empty string.

9/4/05 Danie: FreightCosts.php - Fix default values, change "do while" to "while" loop so an empty record is not displayed, also conformity.

9/4/05 Danie: Locations.php - Fix conformity and Error generated after error report.

9/4/05 Danie: SalesTypes.php - Fix conformity and Error generated after error report.

9/4/05 Danie: BankAccounts.php - Fix conformity and Error generated after error report.

9/4/05 Danie: CompanyPreferences - Add account code to display of account names

7/4/05 Added a check to SelectOrderItems_IntoCart.inc and to SelectOrderItems.php to check credit limits - new parameter in SystemParameters and the config table to set the level of credit limit checking to not checked, warn only or prohibit sales. Calculation of credit available in SQL_CommonFunctions.inc

7/4/05 Changed fpdf.php output method/function to send a string by default - this preserves the way the ros code was written - and was causing issues with the headers/filenames

31/3/05 Scott Rosa - Blind packing notes - system parameter to default all customer branches to blind - ie not to show the company and logo of the webERP company dispatching the product - useful for where the webERP system is dispatching to customers' of customers. Changes to SelectOrderItems.php DefineCartClass.php and DeliveryDetails.php to allow the default to be overridden and CustomerBranches.php to allow entry of the setting.

31/3/05 Defaulted new users to see all modules on screen - WWW_Users.php

31/3/05 Made new system parameter to set the PackNoteFormat - this ensures that the link to print the packing slip uses the correct script - the pre-printed stationery template script or the laser packing slip script.

27/3/05 Added a new configuration variable DB_Maintenance and DB_Maintenance_LastRun. This variable is checked in session.inc to see if it is set to maintain the DB using a new function in the DB specific include DB_Connect_XXXXX.inc (where XXXX is the $dbtype) - there is a new function in these files called DB_Maintenance($Conn) that runs the routines necessary to keep the DB on top form. pg needs regular vacuums to run optimally. Changes also in SystemParameters.php to allow the variable to be set.

26/3/05 Bug fix Lyndsay Roger - StockAdjustments.php could not enter quantity and part code for a stock adjustment without being asked to enter the quantity again ... fixed

25/3/05 Added a new config HTTPS_Only variable that requires a https connection in session.inc before allowing the page as suggested by Jesse Peterson

25/3/05 Z_DeleteSalesTrans.php fixed lower caseing of sql and trucate statements not liked by pg

25/3/05 Recurring sales orders new scripts for SelectRecurringSalesOrder.php RecurringSalesOrder.php and RecurringSalesOrdersProcess.php for selection, modification and processing of recurring sales orders.

11/03/05 Scott Rosa - Auto DebtorNo - Added a variable to config table and modified Customers.php to control the assignment
of the DebtorNo to be either manually assigned by the user (the current weberp default)
or automatically assigned by the system. The only automatic numbering scheme available
right now is sequential, numeric with the value being pulled from the systypes table type 500

11/3/05 Changed SystemParameters.php to enable the new AutoDebtorNo to be set in the DB - changed validation to allow debtorno to be set automatically.

5/3/05 Danie - changes to Stock.php to use the image manipulation features and changed Z_GetStockImage.php to GetStockImage.php

5/3/05 Danie - Added SalesCategories.php also table salescat and salescatprod for POS/Shopping integration

26/2/05 Jesse - changed ALT references to TITLE - TITLE needs to be used for the pop up text to appear as per html spec. ALT just for when images turned off.

26/2/05 Addedd Janusz Dobrowlski/ David Lao wrapper includes/class.pdf.php for R&OS pdf class to use FPDF class by Olivier PLATHEY in place of R&OS pdf.php class which is not good at alternative fonts/character sets.

23/2/05 Links to Danie's new scripts in Z_index.php

23/2/05 Danie - Z_DataExport.php allows export of various data as csv files

23/2/05 Danie - session.inc, config.php, WWW_Users.php, UserSettings.php passwords now have a choice of md5, sha1 or plain text depending on setting in config.php - default is sha1

23/2/05 Danie - Z_GetStockImage.php image manipluation script

21/2/05 New script to print quotations PDFQuotation.php includes/PDFQuotationPageHeader.inc

20/2/05 Modification to DeliveryDetails.php to allow flagging of sales orders as quotations. Also modification to select outstanding orders to allow viewing of quotations

18/2/05 Bug fixes - on BankMatching.php, GLAccountInquiry.php integrity checking against wrong chartdetail record, lower casing errors in some Z scripts - Dick Stins, StockCostUpdate.php - OverheadCost added twice

17/2/05 maximum execution time now as a config.php parameter defaults to 2 mins - 120 seconds

9/2/05 Customer login SelectCompletedOrder.php now shows just the orders for the customer without resort to a new script

9/2/05 Scott Rosa - Discount Category logic was not applied on quick entry - bug corrected

4/2/05 DB_escape_string function added to ConnectDB_xxx.inc database specific scripts and also modifications to Stocks.php Customers.php Currencies.php DeliveryDetails.php CustomerBranches.php to use this function on insert and updates as necessary.

4/2/05 db now stores sha1 hash of the password in the database rather than the password itself

29/1/05 Negative stocks report

25/1/05 Danie new config SystemParamters.php form for entry of config paramters - 99% of all config now in this form. Full description of the purpose of each parameter shown on the form

24/1/05 Janusz Dobrowolski fixed CompanyPreferences.php had exchange diff account field twice!

24/1/05 "Ori Solomon" - Upload of part pictures code in Stocks.php

23/1/05 Danie units of measure now a table and array created from table new script for maintenance

23/1/05 Danie payment and receipt types arrays moved to a table from config.php new include for payments and receipts

22/1/05 Update manual to reflect new security definitions interface changes no longer use config.php

20/1/05 StockCheck sheets now have option not to show system counts for counting blind ie so bogus count data can not be made up by counters!!

20/1/05 Steve modifications to Z_poAdmin.php and other language translation utility scripts of Kitch's to use the user's language that they currently have set

20/1/05 Danie - Moved Security setup to the db from config.php new tables for securityroles securitygroups securitytokens in db. New script WWW_Access to define roles and permissions.

11/1/05 Steve - check of sql changes quite a number of bug fixes resulting from change to lower case.

4/1/05 changing all SQL that used IF to CASE to enable more universal database compatibility

3/1/05 changing all LastInsertID to add the necessary parameters to enable PG compatibility

2/1/05 changing all INTERVAL to use the DB specific function and new DB_Connect_postgres (Danie) and DB_Connect_mysql

19/1/05 Danie - Moved Account Sections to the db from config.php new table in db

26-30/12/04 Khattak/Phil lower case all sql and array elements of returns from DB_fetch_array to enable compatibility with postgres

Version 2.9b

23rd December 2004

23/12/04 Steve - new LanguageSetup.php using 5 character language_country codes wrinkles in multi-language fixed - testing with Polish from Janusz Dobrowolski the first language to be translated into. Lots of bug fixes

22/11/04-20/12/04 - Large changes throughout to ensure consistent use of prnMsg function of Jesse and to use the DB_query function with ErrMsg and DbgMsg parameters and to ensure all strings are enclosed in the gettext function

18/12/04 AgedDebtors.php uses CASE instead of IF to ensure ANSI SQL used.

18/12/04 modified Z_poEditLangModule.php to check for new strings each time and to write a fresh .mo file after completing and edit

15/11/04 Kitch - new scripts to enable administration of language files and directories

22/11/04 GoodsReceived.php bug on receiving nominal items - value of CurrentStandardCost not set for nominal items - now fixed

8-22/11/04 Large amounts of gettext work too much to record here - most scripts re-worked some

8/11/04 Vitaliy - entering purchase orders now allows selection of all GRNs on a Purchase order in one hit or selected lines using checkboxes - much neater selection of all lines to be invoiced in one go. Gettextified this script - SuppInvGRNs.php

8/11/04 Steve - SelectCustomer.php gettextified

6/11/04 SelectOrderItems.php bug in customer login order entry

4/11/04 PO_PDFPurchOrder.php now prints the suppliers description for the item on the PO.

4/11/04 bug fixes Bob CustomerReceipt.php price_customer.php

31/10/04 SelectCreditItems.php Steve gettextified - index.php html fixes Steve

31/10/04 UserSettings.php fixed title =_(...) after include session.inc

31/10/04 footer.inc Jesse - new web site reference and link, also fix copy; Steve

31/10/04 PurchData.php fix hyphens in strings not minus signs - Bob

31/10/04 PrintCustOrder.php PrintCustOrder_generic.php PrintCustStatements.php PO_OrderDetails.php PO_PDFPurchOrder.php and associated includes/XXXXPageHeader.inc files gettextified Jesse

Version 2.9a - Mk II

30/10/04 PageSize errors caused with register globals off. Used new variable PaperSize - Vitaliy

30/10/04 fixed AgedDebtors.php and CustTransInquiry.php

30/10/04 added correct icons to css directories - Steve/Chris

Version 2.9a - Mk I

24/10/04 Focus on SelectCustomer, SelectOrderItems, SelectProduct, SelectSupplier all default to the code entry. Previosuly required a click in the field now already in the field

24/10/04 gettextified SalesAnalysis_UserDefined.php, SelectSalesOrder.php, SelectSupplier.php, TaxAuthorityRates.php, WWW_Users.php, WhereUsedInquiry.php, Z_ChangeBranchCode.php, Z_UploadForm.php, Z_UploadResult.php

22/10/04 session.inc / login.php - Chris bad password now goes straight to another try. Also, bad permission for a script code improved Chris

22/10/04 bg.gif - Steve's much reduced graphic - great performance increase on login. Biggest graphic in system was the first login page ?!

17/10/04 Gettextified PDFBankingSummary.php, PDFChequeListing.php, SalesGLPostings.php, SalesPeople.php, SalesTypes.php

17/10/04 Gettextified PurchData.php, ReverseGRN.php - Steve

14/10/04 Gettextified Prices.php,Prices_Customer.php - Steve

14/10/04 Gettextified PDFCustomerList.php PDFPriceList.php, PDFStockCheckComparison.php, PDFStockLocTransfer.php Jesse

14/10/04 Bug fixes GLTransInquiry.php Steve - $rootpath in single quotes, $title above include session.inc

14/10/04 Bug fixes DateFunctions.inc, SQL_CommonFunctions.inc Jesse - proper use of DB_query, prnMsg

12/10/04 StockTransfer.php serialised now works, gettextified: GLTrialBalance - Jake, GLAccountInquiry - Jake, Payments - Steve, PaymentTerms Steve PO_SelectOSPurchOrder.php Steve PeriodsInquiry.php Steve PO_SelectPurchOrder Steve

29/9/04 StockCostUpdate.php gettextified - fixed bug that would not allow update with zero stock on hand

29/9/04 New reports OrderStatus.php and OrderStatusPageHeader.inc allow reporting on orders, back orders by location and stock category for a specified date range.

29/9/04 SelectOrderItems_IntoCart.php now traps for obsolete items and a check to see if prohibit sales of items where the cost is zero if the new config.php variable $AllowSalesOfZeroCostItems is set to false.

23/9/04 gettextification - FTP_RadioBeacon.php, EmailCustTrans.php, FreightCosts.php

22/9/04 gettextification - EDIMessageFormat.php EDIProcessOrders.php EDISendInvoices.php BOMInquiry.php BOMListing.php

22/9/04 Steve - gettextification - InventoryValuation.php Locations.php Logout.php MailInventoryValuation.php MailSalesReport.php

21/9/04 Jake - gettextification - GLJournal.php GLProfit_Loss.php GLBalanceSheet.php GLCodesInquiry.php GLTransInquiry.php

19/9/04 ConfirmDispatch_Invoice.php now checks to ensure there is a quantity to be invoiced on at least one line

19/9/04 Stocks.php gettextified - DB_query changes also check no stock on hand before alteration to controlled and not dummy/assembly/kitset

19/9/04 Jesse - ConfirmDispatch_Invoice.php ConfirmDispatchControlled_Invoice.php CreditItemsControlled.php GoodReceivedControlled.php ConnectDB.inc DefineSerialItems.php InputSerialItemsFile.php - more extensive modifications too InputSerialItemsKeyed.php, InputSerialItems.php StockAdjustmentsControlled.php StockAdjustments.php StockTransfers.php StockTransfersControlled.php all above gettextified and rationalisation of code in InputSerialItems.php includes

19/9/04 TaxAuthorities.php gettextification - TaxID in taxauthorities table made auto increment

12/9/04 SuppliersAtPeriodEnd.php gettextified

12/9/04 Hani - DebtorsAtPeriodEnd.php gettextified

12/9/04 Credit_Invoice.php gettextified - fixed bug where TaxRate was not recorded on StockMoves correctly

19/9/04 Tax.php and PDFTaxPageHeader.inc reporting GST/VAT

12/9/04 GLPostings.inc was not adding new chart details when an account had been added - fixed

10/9/04 Steve - BOM.php, BankMatching.php, BankReconciliation.php gettextified

8/9/04 Areas.php gettextified

6/9/04 Victor - CustomerReceipt.php CustomerTransInquiry.php gettextified

5/9/04 Jesse - GoodsReceived.php GoodsReceivedControlled.php InputSerialItems.php InputSerialItemsKeyed.php InputSerialItemsFile.php gettextified and some polish

5/9/04 AgedDebtors.php/PDFAgedDebtorsPageHeader.inc AgedSuppliers.php PDFAgedSuppliersPageHeader.inc all gettextified

1/9/04 AccountGroups.php getextified, Customers.php gettextified (Victor)

1/9/04 footer.inc now has date/time displayed before copyright notice.

1/9/04 PrintCustTrans.php now prints the Payment Terms on invoices and credit notes as contributed by Steve Ball

1/9/04 New script by Chris Bice StockQuantityByDate.php that shows the quantity on hand at any historical date selected for all items in a selected stock category

30/8/04 Fixed SalesPeople.php, CreditStatus.php Salestypes.php display issues on editing.

30/8/04 PO_Header.php fixed sequence of order deletion details then order header to allow for foreign key constraints. Thanks Victor! Also setup strings for multi-language and using DB_query error reporting.

28/8/04 PDFDeliveryDifferences.php had a few bugs in the sql fixed

28/8/04 Steve - PDFChequeListing.php PrintCustTrans.php PDFStockCheckComparison.php SuppPaymentRun.php all had display errors fixed.

28/8/04 PO_PDFPurchOrder.php purchase order printing corrected.

28/8/04 Steve - new script UserSettings.php linked from the user name on header.inc to allow setting of the theme, language and max number of records to display. Changes to session.inc to accomodate changing theme and language.

28/8/04 Theme, Language and DisplayRecordsMax are now fields in WWW_Users

28/8/04 Steve - Minor changes to theme default.css files

28/8/04 Steve - SelectCustomer.php SelectProduct.php SelectSupplier.php all modified to allow paging where a large result set is returned

25/8/04 SelectCreditItems.php now allows text line entries with each line of the credit note

23/8/04 SelectOrderItems.php SelectCreditItems.php strrpos works differently in PHP 5 changed to use strpos

14/8/04 Changed ConfirmDispatch_Invoice.php to allow entry of consignment reference also changed PrintCustTrans.php and PDFPrintCustTransPageHeader.inc to print out the narrative on sales order lines and the consignment number

14/8/04 Changed SelectOrderItems.php to allow entry of narrative and update narrative entries also show warning when quick entries not processed.

14/8/04 Changed DefineCartClass.inc to have a Narrative variable in LineItems and a Consignment variable in the header

14/8/04 Added Narrative field to SalesOrderDetails and StockMoves for adding a narrative about each line on an invoice

14/8/04 Added Consignment field to DebtorTrans for adding a Consigment Note (UPS or other freight company) reference against each delivery/invoice

14/8/04 Help system now has disabled editing for HelpType A or S where the user does not have system set up access

13/8/04 Bug in ConfirmOrderInvoice.php used $SESSION['CustomerID'] should be using $_SESSION['Items']->DebtorNo to avoid situations where another instance of the browser looks up a customer and changes $_SESSION['CustomerID'] half way through invoicing.

10/8/04 Fixed bugs in PDFCustomerList.php, Help.php (couldn't edit a help record!), index.php left a html comment without an opening bracket.

9/8/04 Extreme make-over MkII! - Included Steve Kaill's index.php and css/default.css. These changes make the menus columnar and has a cleaner look to the main menu. Also, includes/header.inc now with company name, user name and database and shortcut keys to quick menu options.

8/8/04 New Customer listing report PDFCustomerList.php with options to print for selected areas and sales folks, also customers below or above a certain level of activity since a specified date.

1/8/04 New scripts for reconciliation of GL for debtor and creditor balances as at the end of a prior period. DebtorsAtPeriodEnd.php includes/PDFDebtorBalsPageHeader.inc SupplierBalsAtPeriodEnd.php includes/PDFSupplierBalsPageHeader.inc

Version 2.9

17th July 2004

Upgrade script 2.8 - 2.9 is necessary to be applied against a 2.8 database - unfortunately I was over zealous with the foreign keys and made up one for StockID in ShipmentCharges - this needs to be dropped but the name of this key is generated by Innodb so I cannot create a script to ditch it!! You will need to remove this yourself - otherwise you will not be able to create shipment charges. Using the new db scripts will of course generate dbs without this foreign key.

15/7/04 Polishing Credit_Invoice.php SelectCreditItems.php using new DB_query function for error messages and checking all working with controlled items.

11/7/04 Jesse serial items input from file added - fixed inconsistencies with other scripts.

7/7/04 header.inc now has a link to a Help.php page Help.php added and new tables Help and Scripts. Help contains the context sensitive help referenced to the script - which is where the scripts table comes in. It contains all the scripts in the system with an overview of what the script does. The new Help script retrieves records from the Help table relevant to the PageID, the PageID is determined from the filename looked up against the Scripts table. Users can add new help and edit or delete help. A little shy on data for the help table!!

19/6/04 GLBalanceSheet.php displays a html balance sheet for any period end.

17/6/04 AccountGroups now uses an array for Section in accounts defined in config.php $Sections array. This array also used in GLProfit_Loss.php

17/6/04 GLProfit_Loss.php added - index.php modified to add a link to this script

8/6/04 DefineCartClass.inc updates to DB new parameters for delete, remove, add to cart class - changes to SelectIntoCartClass and other scripts to pass appropriate variables rather than rely on SESSION['ExistingOrder']. Also DecimalPlaces field added to order data in add_to_cart.

8/6/04 Updates to SelectOrderItems.php now uses new DB_query error message/debug message parameters

8/6/04 SelectCreditItems.php now uses Quantity not QtyDispatched - bug corrected.

5/6/04 New script StockSerialItems.php shows the stock status of serial or controlled items - the total shown should tie up with the StockStatus total quantities on hand.

29/5/04 New script StockTransfersControlled.php allows input of serial items for stock transfers.

29/5/04 New script StockAdjustmentsControlled.php allows input of serial items for stock adjustments.

29/5/04 StockStatus.php, StockMovements.php StockLocMovements.php, StockUsage.php now all use the new decimalplaces field of the stock master to display quantities.

25/5/04 BOMs.php modified to use Jesse DB_query function with error messages and Debug messages

25/5/04 Stocks.php now checks and stops the mbflag change to assembly or kitset when the item is a component in a bill.

25/5/04 ConfirmDispatch_Invoice.php updates and inserts for serialised/controlled items.

24/5/04 ConfirmDispatch_Invoice.php ConfirmDispatchControlled_Invoice.php DefineSerialItems.php mods for controlled batch numbers and serial number input.

21/5/04 GoodsReceived.php and GoodsReceivedControlled.php now allows for receiving controlled and controlled/serialised items.

17/5/04 StockMoves remove field BundleID

17/5/04 StockCheck.php now only prints stock sheets for items committed to the stockcheckfreeze table. Behaviour of this script was counter intuitive. Deletion of existing entries deleted all locations stock of the same range of categories - now corrected.

17/5/04 Added DecimalPlaces tinyint default 0 to StockMaster - this determines the number of decimal places to show for the stock item in all places where the item is displayed. Yet to update displaing throughout the system.

12/5/04 DeliveryDetails.php SelectOrderItems.php DefineCartClass.php - deleting lines off an existing order was not working correctly. It was possible to delete completed order lines off an order in changing an outstanding order line. Bad bug corrected.

5/5/04 Added new tables for Serialised stuff StockSerialItems StockSerialMoves. Alterations to StockMaster for Serialised and DecimalPlaces - for displaying items with different decimal places

5/5/04 Added includes/MiscFunctions.php for Jesse. Stocks.php script modified for Serialised and DecimalPlaces

29/4/04 StockLocTransferReceive.php to receive quantities set up to transfer from StockLocTransfer.php. Deletes the temporary table data holding the transfered items on creation of the stock movements necessary.

28/4/04 RePostGL scripts added updating of ChartDetails.BFwdBudget field.

28/4/04 SelectProduct.php added link to the part picture as suggested by Alan Beard.

25/4/04 StockLocTransfer.php - contributed by Chris Bice, creates a transfer from one location to another without creating the transaction but records the transfer in a pending transfers file. Also PDFStockTransfer.php and includes/PDFStockLocTransferPageHeader.inc creates the transfer paperwork. new table LocTransfers also required - in upgrade script.

25/4/04 GLAccountInquiry.php modifications as contributed by Dirk Eversmann incorporated - now allows multiple periods to be selected and shows the transactions for the whole range of periods between the highest and lowest. Also the movement for each period. B/fwd balances and c/fwd balances only shown where the account is a balance sheet account. GL account is now selectable from a list rather than selecting as per customer or supplier - unlikely to be the same volume of GL accounts hence overhead of downloading all GL accounts over dial up (for the list) is deemed an acceptable compromise.

22/4/04 PO_SelectOSPurchOrder.php made the location default properly to the users default location.

22/4/04 Links for CurrencySuppliersBalances.php and CurrencyDebtorsBalances.php re-instated on Z_index.php - these scripts are for reconciling the creditors and debtors control accounts.

22/4/04 bug fix in GoodsReceived.php - cost differences where std cost changed was not working correctly all cost was going to price variance rather than stock!! Serious bug.... now rectified.

18/4/04 index.php now uses extra column where many options under one heading

18/4/04 New scripts StockLocStatus.php - inquiry script that shows all stock items status in the selected category. StockLocMovements.php - inquiry script that shows all movements in the selected location and date range - default only one month - this script can return a lot of data and is a mistake to run over dial up on a business with many stock movemnts. Thanks to Chris Bice for these scripts. Also added links from index.php -

2/4/04 config.php now over-rides php.ini to ensure tht NOTICES turned off.

30/3/04 Z_ChangeStockCode, Z_ChangeDebtorCode, Z_ChangeBranchCode all required mods to work correctly with Foreign key checks in place.

30/3/04 Stocks.php now prohibits stock codes containing a point .

30/3/04 SelectOrderItems search products now defaults to stock category 'All'

27/3/04 GoodsReceived.php now takes account of changed standard cost at between bookings in of stock - unbalanced GL journals corrected. (this was wrong - fixed 22/4/04)

16/3/04 Various scripts changed variables that are not initiated first to avoid NOTICES where NOTICES are enabled in php.ini - still a long way to go here

16/3/04 All scripts now have a comment for CVS version number - Dick Stins suggestion

16/3/04 Fixed bug on new system where sales and COGS GL posting tables not set up - auto create a default GL account - foreign key could give problem if account groups modified so now auto creates a sales account group first - thanks Dick Stins

14/3/04 Added new tables for EDI_ORDERS_Segs and EDI_ORDERS_SegGroups that hold the defined segments for the EANCOM EDI ORDERS message and the segment groups info.

14/3/04 AccountGroups.php modified to disallow & or ' - also fixed class='tableheader' as per css.

14/3/04 GLAccounts.php modified to check for related records in BankAccounts and TaxAuthorities to avoid data integrity issues. Foriegn Keys added as necessary - in the upgrade2.8-2.9.sql script

Version 2.8

26 February 2004

26/2/04 TaxAuthorityRates.php script for modifying tax rates for defined tax authorities/tax levels

24/2/04 fixes to sales analysis reports with only one level of grouping - also error in ReportColumns storeage of datatype Select corrected.

22/2/04 EDIMessageFormat script to set up invoice format only so far

21/2/04 Foreign key defintions accross the board for all relations in all tables as necessary added to upgrade script 2.7-2.8

16/2/04 Referential integrity checks in Locations.php for changes in TaxAuthority to ensure existance of necessary records in TaxAuthLevels

16/2/04 Referential integrity checks in Stocks.php for changes in TaxLevel to ensure exist in TaxAuthLevels

16/2/04 Referential integrity checks in TaxAuthorities for deletions or additions of tax authorities to ensure that records exist (or are deleted) when Tax Authorities are added or deleted.

16/2/04 Customers now default the currency of new customer.

16/2/04 Suppliers now default the currency and clears input from last insertion on each addition.

15/2/04 Location maintenance form modified to allow specification of the dispatch TaxAuthority.

15/2/04 Tax Authorities maintenance form modified no tax rate any more.

15/2/04 CustomerInquiry icons reduced in size.

12/2/04 Upgrade sql file create 2.7 - 2.8 to add new tables and modify existing ones as necessary.

12/2/04 SupplierInvoice.php and SupplierCredit.php modified to use the new tax configuration - gets tax rate from DefaultTaxLevel in config.php and TaxAuthority in Suppliers table.

12/2/04 EmailCustTrans.php that runs PrintCustTrans.php with appropriate get paramters to send the transation off to the customer branch email address - or the user can over-ride with another email address.

11/2/04 Email invoices or credits link set up from CustomerInquiry.php

11/2/04 Credit_Invoice.php get tax rate per the new tax structure record tax rate against each line of the credit note

11/2/04 New variable in config.php DefaultTaxLevel used in AP and for freight tax calcs by default

10/2/04 modified Z_changeStockCode.php to not use a transaction - some of the tables were not transactional tables anyway. Also Z_ChangeCustomerCode.php same treatment.

10/2/04 new script Z_ChangeBranchCode.php changes the branch code for a selected customer and customer branch code - all occurrences in SalesAnalysis pricing, debtorTrans, CustBranch, SalesOrders etc changed

9/2/04 Modifications to SelectCreditItems.php to get tax rate per the new tax structure record tax rate against each line of the credit note

8/2/04 New function in SQL_CommonFunctions.inc to get the tax rate from the Level and TaxAuthority

8/2/04 Modification to ConfirmDispatch_Invoice.php to get tax rate and be user modifiable by line of the invoice

7/2/04 TaxLevel field added to Stocks.php master maintenance form.

7/2/04 EDISendInvoices.php script added to create EDI INVOIC messages for all customers with EDIInvoice set to 1 and DEbtorTrans EDISent field=0. Creates and sends EDI message in the method set up against the customer EDI set up. Linked in Z_index.php only - script should be run from Cron really - but debugging output for testing if run in browser.

6/2/04 EDI configuration variables applicable company wide in config.php

6/2/04 DateFunctions.inc new function SQLDateToEDI - takes an SQL date and converts it to EANCOM 102 format date

6/2/04 SelectCustomer.php new link to CustEDISetup.php

6/2/04 New field in StockMaster TaxLevel (TinyInt) this field indicates the level of tax applicable to the item. The rate of tax is determined by reference to the TaxAuthLevels table which is a matrix of TaxAuthorities and Levels of tax applicable.

6/2/04 new table TaxAuthLevels this is to enable tax rate depending on product

6/2/04 new field in StockMoves TaxRate float this records the rate used in the transaction

6/2/04 CustEDISetup.php new script to maintain the EDI parameters of the customer - the new fields in DebtorsMaster table.

6/2/04 PrintCustTrans.php now has option to print or not EDI Invoices - defaults to no print

6/2/04 new field in DebtorTrans for EDISent TinyInt - indexed. Required to figure out if the transmission of EDI invoices or credits are duplicates or originals.

1/2/04 new table for EDIMessageFormat for outgoing message definition by partner outgoing message is either INVOIC DebtorNo is expected or ORDERS - SupplierID is expected

1/2/04 new table for EDIItemMapping for the cross reference table of part codes of suppliers or customers for EDI translations for orders or invoices.

1/2/04 new field in CustBranch for CustBranchCode - the customers internal code for the branch - required for edi mapping purposes. Modified CustomerBranches.php to allow the field to be maintained.

1/2/04 New field in www_users for blocked tinyint this field is set to 1 when there have been too many login attempts. Modifications to session.inc to fail login if the account is blocked and to update the database when login attempt are exceeded. - Dick Stins suggestion.

28/1/04 DiscountCode in DebtorsMaster left off by mistake in last release - fixed.

28/1/04 Subject and from of email purchase order was incorrect.

28/1/04 Could not modify currencies - fixed

28/1/04 using zip format archive (compression is not as good) for 2.7 and on to increase compatability.

Version 2.7

14 January 2004

12/1/04 New scripts for PDFDeliveryDifferences.php and includes/DeliveryDiffercesPageHeader.inc to report order lines which werent delivered with the first drop of an order for whatever reason - a performance management measure.

11/1/04 DiscountCategories script to allow updates to stock master and see other items in the discount category.

11/1/04 Shipments written up in the manual. Discount Matrix written up in the manual.

11/1/04 SelectOrderItems.php modified for discount matrix lookups - DefineCartClass.inc now holds DiscountCategory for each line item on the order

11/1/04 DB changes modifications to DiscountMatrix table - new field StockMaster DiscountCategory increase length of barcode to 50 characters.

11/1/04 SelectSupplier options now tablularised as per SelectProduct.php

11/1/04 Shipt_Select.php new script to select shipment called alone or from SelectSupplier.php links to Shipments.php - to modify shipment, ShipmentCosting.php to view the costing and close to close the shipment record variances and do the GL journals.

9/1/04 SelectCredititems.php correction to sql on goods written off assembly item stock movement going out had an extra comman by mistake.

9/1/04 PrintCustStatement.php bug fix for page numbering.

8/1/04 New ShipmentCosting.php script when passed a SelectedShipment shows the current costing for the items on the shipment - also shows old closed costings.

8/1/04 ShipmentCharges table now has a field for StockID to store charges specific to a particular line item of a shipment. General shipment charges leave this field blank.

6/1/04 ShiptCharges.php now allows entry against shipments that are not from the same supplier eg frieght charges from a freight company can be entered against a differnt supplier's shipment as it should be!

6/1/04 Shipment sql changed in SupplierInvoice.php to Value not amount for ShipmentCharges - no updates to Accum value field in Shipments since can accumulate from ShiptCharges. AccumValue field dropped from Shipments table.

6/1/04 New Shipments.php script to allow definition of a shipment from purchase order items to the same supplier and into the same location

24/12/03 Added a 'professional' theme css directory to show how a different look can be acheived by editing the css script - login css is unchanged

24/12/03 class='tableheader' references updated throughout all scripts - I think?

24/12/03 Credit_Invoice.php and SelectCreditItems.php now use in line editing of lines rather than clicking the link to make it available to modify a line. This is a usability enhancement allowing several items to be modified on screen without sucessive round trips to the server for page updates. Deleting a line from a credit is now only a one click operation rather than a two click previously. Overhead saving, usability improved.

21/12/03 InventoryPlanning.php and header changed to use pdf.php class by R&OS - this is the last conversion PDFLIB is NO LONGER REQUIRED! PDFStarter.inc removed

21/12/03 PDFPaymentRun.php, header and footer changed to use pdf.php class by R&OS

16/12/03 SelectCreditItems.php bug in salesanalysis insert new record on Overcharge type credit note QtyDispatched should be Quantity.

16/12/03 SelectOrderItems.php made so that price/quantity/discount can be modified as displayed rather than hitting select to bring up the line for editing.

16/12/03 DeliveryDetails.php made to have button to modify line items and save any entries made on the form first using META refresh - taken off the select link on the order summary.

Version 2.6

15 December 2003

14/12/03 Significant updates to the manual

14/12/03 SelectCreditItems.php now has a credit type that allows an overcharge to be reversed without crediting the entire invoice then re-invoicing it as per Credit_Invoice.php page.

14/12/03 $QuickEntries variable in config.php now used by SelectCreditItems and SelectOrderItems to determine how many quick entry fields to show for credit notes and order entry.

14/12/03 fixed double process of last item on quick entry fields on order entry SelectOrderItems.php

8/12/03 StockCheck.php now creates pdf using R & OS pdf.php class.

5/12/03 StockStatus.php now includes demand for components of assemblies ie if the item is a component of an assembly the demand for the parent as extended by the Bill of Material quantity is included in the reported demand. The same modification in InventoryPlanning.php report.

5/12/03 CustomerAllocations.php and includes/DefineCustAllocsClass.php now include the credits and receipts as a line - without any opportunity for allocating but for informational purposes. - Client request.

5/12/03 PO_Items.php didn't retain the quantity when a supplier price was looked up - fixed.

5/12/03 Stock check system implemented with a modification to print stock check sheets to also create a stock check data - update stock check data or print stock sheets only. Also, new scripts for StockCounts.php for entry of stock counts and PDFStockCheckComparison.php to report the difference and/or create adjustments for all items requiring an adjustment based on the counts and the stock check data quantities. New tables for StockCounts and StockCheckFreeze created.

5/12/03 Z_PriceChanges.php has several utilities to modify pricing set up by sales type/customer specials.

5/12/03 PrintCustStatements.php now has a config.php option to print settled transactions where they were settled in the last month. Previously this was the default. Could save printing and sending many statements which have zero balances if this option ( $Show_Settled_LastMonth ) is set to 0.

5/12/03 PDFPriceList.php allows various options for making a pdf of the price lists or part of a price list.

30/11/03 InventoryPlanning.php and StockUsage.php updated to avoid counting in hidden stock movements arising from pricing credits - no real physical stock movement only there for the credit line.

27/11/03 Z_ChangeCustomerCode.php allows a customer code to be changed and modifies the code in all tables as necessary.

27/11/03 Credit_Invoice.php now has a credit type that allows an overcharge to be reversed without crediting the entire invoice then re-invoicing it.

27/11/03 StockMovements.php now only shows movements that are not hidden

25/11/03 SpecialOrder.php created to allow one off indented items to be entered by selecting a supplier and a customer then entering the cost and selling price of the items with a description and stock category for GL coding.

25/11/03 Changed fields defaulting to '' to blank - these fields actually stored '' not an empty string as expected. SalesAnalysis table fields and Prices DebtorNo and BranchCode fields. Also, changed datetime fields to date where time is not appropriate to store.

13/11/03 SalesAnalysis_UserDefined.php broken up and ConstructSQLForUserDefinedSalesReport.inc for the SQL section and PDFSalesAnalysis.inc for the report construction section. The SalesAnalysis_UserDefined.php now uses these as includes as do the MailSalesReport.php and MailSalesReport_csv.php

13/11/03 SalesAnalysis_UserDefined.php now prints totals for calculated columns in correct value format as specified

13/11/03 SalesAnalysis_UserDefined.php now creates Sql for numerator col x or divided by a constant. Also new field in ReportColumns for Constant. SalesAnalReptCols.php has new field input for the constant.

13/11/03 PrintCustStatements.php now settles transactions that should have allocated == the amount of the trans.

11/11/03 GLPostings.inc now checks for and creates ChartDetails records where none existed even though they should have existed.

30/11/03 PDFChequeListing.php now fixed include("includes/htmlMimeMail.php") so that reports do indeed get mailed! Also moved receipients of this report variable to config.php

Phil 27/10/03 BOMListing.php and includes/PDFBOMListingPageHeader.inc modified to use R & OS pdf.php class

Phil 27/10/03 AgedSuppliers.php and includes/PDFAgedSuppliersPageHeader.inc modified to use R & OS pdf.php class also supressed settled transactions and transactions with less than a cent unsettled from showing on a detailed report.

Phil 27/10/03 AgedDebtors.php and includes/PDFAgedDebtorsPageHeader.inc modified to use R & OS pdf.php class.

Phil 27/10/03 Credit_invoice.php cost now taken off sales analysis was adding cost when crediting in error.

Phil 26/10/03 ReverseGRNs.php was not creating GL postings fixed was testing for journal amount using StdUnit Cost sh/be StdCostUnit.

Phil 20/10/03 Goods received were not recording the GRNBatch to cross reference to the stock movement transaction (in GoodsReceived.php) New field added to GRNs - GRNBatch. Also, was not refering to GRN batch in SuppInvGRN.php to cross reference the batch returned on entry of the goods received batch - normally written on the packing slip by the person booking the goods in.

Phil 17/10/03 PrintCustStatements.php some fine tuning to layout - pagination when end of Settled Transactions and space before new page for footer.

Phil 16/10/03 Changed AgedSuppliers.php and includes/PDFAgedSuppliersPageHeader.inc to use the R & OS pdf.php class instead of pdflib.

Phil 15/10/03 New script PO_OrderDetails.php heavily modified from Open Accounting to show purchase order details instead of re-print of order - also shows qty received and actual price charged as modified from SupplierInvoice.php entry. Linked from PO_SelectCompletedOrder.php. Changed name to PO_SelectPurchOrder.php (can be any PO now not just completed). index.php and SelectSupplier.php links also modified for script name changes

Phil 13/10/03 PDFChequeListing.php first payment in the range was missing - now fixed.

Phil 13/10/03 SupplierInvoice.php/SupplierCredit.php fixed date retention - rounding of tax and GRN entries - table headers use class='tableheader'

Phil 13/10/03 ConfirmDispatch_Invoice.php fixed assembly items stock movements not being created after NewQOH modification

Phil 13/10/03 PO_Header.php and PO_Items.php now show the order number as the page header if its an order being modified

Phil 13/10/03 SelectSupplier.php now has menu item for Outstanding Purchase Orders and Completed Purchase Orders

Phil 13/10/03 PO_SelectCompletedPurchOrder.php now accepts order number entry and queries correctly

Phil 13/10/03 SupplierContacts.php fixed now updates where spaces in contact name

Phil 12/10/03 PO_SelectPurchOrder.php fixed table headers using class=tableheader

Phil 12/10/03 PO_SelectCompletedPurchOrder.php fixed table headers using class=tableheader

Phil 12/10/03 PO_PDFPurchOrder.php and includes/PO_PDFOrderPageHeader.inc now print in A4_Landscape with delivery dates and order total in currency of supplier

Phil 12/10/03 PO_Items.php now checks for StockID existence where a code is entered.

Phil 12/10/03 GoodsReceived.php narrative now adds StockID

Phil 12/10/03 SupplierInvoice.php rounding fixed.

Phil 12/10/03 ReverseGRN.php finsihed added to SelectSupplier.php menu

Phil 8/10/03 New script to create a csv file of stock quantities added StockQties_csv.php added to index.php

Phil 7/10/03 BOMInquiry.php now links the component codes back to SelectProduct.php

Phil 7/10/03 CreditInvoice.php was not updating NewQOH - now corrected.

Phil 7/10/03 Allow other pages to call SelectProduct.php with StockID to show the options available for the item code sent $_POST['Select'] = $_GET['StockID']

Phil 7/10/03 SelectProduct.php tidy display when only one item returned from search

Phil 5/10/03 OutstandingGRNs.php from and to criteria were not used by the SQL and no defaults - totals out of alignment with detail lines. Now fixed.

Phil 5/10/03 GoodsReceived.php was not creating GL entries correctly at the standard cost due to setting the standard cost inside the for each loop have to use full vble name not the for each vble. Now fixed.

Phil 1/10/03 PDFChequeListing.php fixed includes paths and link from index.php

Sherif 1/10/03 WhereUsedInquiry.php ex Open Accounting modified and linked to from index.php and SelectProduct.php

Phil 27/9/03 SupplierInvoice.php and SupplierCredit.php rounding of amounts posted to minimise allocation and GL cents issues also no GL postings for tax when tax is 0

Phil 27/9/03 PO_Header.php same problem as below when hit enter line items.

Phil 27/9/03 Stocks.php when submit hit refreshes to new search - used to fall over when https because hard coded http

Phil 27/9/03 SupplierAllocations.php fixed footer.inc now down the bottom!

Phil 27/9/03 PO_Header.php fixed cancel order to delete purchorderdetails not purchaseorderdetails as previously.

Phil 27/9/03 PO_SelectPurchOrder.php Entering order number to search was ineffective - now fixed.

Phil 22/9/03 A not unrelated fix script that re-applies current costs against sales analysis records. Z_ReApplyCostToSA.php for a specified period.

Phil 22/9/03 Fixed Credit_Invoice.php was adding cost to sales analysis records sh/been taking off cost!!

Phil 19/9/03 Fixed includes paths for Credit_invoice.php/InventoryValuation thanks Al

Phil 19/9/03 SelectOrderItems removed extra AND in stock search SQL - thanks Al.

Phil 14/9/03 New config.php variable $PO_AllowSameItemMultipleTimes and effected in PO_Items.php

Phil 14/9/03 InventoryValuation.php SQL_CommonFunctions.inc now in includes corrected path

Phil 13/9/03 Increased the length of all email fields in the database and scripts affected WWW_Users.php CustBranches.php SupplierContacts.php

Phil 13/9/03 Increased the length of TaxRates in TaxAuthorities.php and the database

Phil 13/9/03 Fixed bug that prevented GL payments from being entered

Phil 13/9/03 Fixed bugs caused from re-structure of files all class definitions in includes forgot to modify some of the supplier transactions scripts - quite a few !!

Phil 12/9/03 modified PDFStarter_ros.inc/session.inc/PrintCustTrans.php/PrintCustOrder.php to have save_session_path($SaveSessionPath) for load balancing web servers. Re-instated variable $SaveSessionPath in Config.php

Phil 12/9/03 modified session.inc to include ConnectDB.inc from includes

Phil 10/9/03 BOMs.php fixed search bug that only showed items that had a quantity on sales orders

Phil 10/9/03 Tidy up BOMInquiry.php

Phil 8/9/03 Reorganisation of remaining included files into includes all Define class files and class.pdf.php and htmlMimeMail.php files modifications to all files included from.

Phil 8/9/03 index.php customer login was not initiating a NewOrder with call to SelectOrderItems.php fixed

Phil 8/9/03 SelectOrderItems.php new cart was defined after using Items->DebtorNo so was lost on extranet login customer order.

Phil 8/9/03 AgedDebtors.php now detail report now only shows transactions not fully allocated - fixed bug.

Phil 8/9/03 CustTransInquiry.php corrected links to css/theme/images/

Phil 8/9/03 Added .tableheader section to css/theme/default.css - used by sherif on tables to remove need for and html throughout all table headings

Phil 8/9/03 Modified CustAllocations.php ended the table and center of html so the footer comes out at the end!! Also used $TableHeader variable for repeated headings - modified to use .tableheader css

Phil 8/9/03 Modified SalesAnalysis_UserDefined to find the page header.inc under includes directory

Phil 8/9/03 Modified SelectProduct.php to always show the selection criteria options - was a wasted click/round trip to server previously.

Phil 2/9/03 Modified SelectOrderItems.php ConfirmDispatch_Invoice.php SelectCreditItems.php DeliveryDetails.php to move references to DefineCartClass.php to includes

Phil 2/9/03 SupplierInvoice.php SupplierCredit.php references to DefineSuppTransClass.php moved to includes

Phil 2/9/03 Payments.php now dissallows 0 payments DefinePaymentsClass.php moved to includes directory

Phil 2/9/03 StockCostUpdate.php reverted back to the latest version with Shane's mods.

Phil 2/9/03 CustomerAllocations.php reverted back to the latest version with Shane's mods. Also, moved DefinedCustAllocsClass.php to includes directory

Phil 2/9/03 PrintCustTrans.php references to images/logo.jpg back to logo.jpg

Phil 2/9/03 GoodsReceived.php default delivery quantity to 2 dp as per rest of system - would be good to set this with the stock item master how many decimal places to display and take this number as the number of dp to display.

Phil 2/9/03 PO_PDFPurchOrder.php PO_PDFPageHeader.inc put back to later version that allows emailing and R & OS php-pdf class.

Phil 2/9/03 removed images directory didn't think necessary for one image.

Phil 2/9/03 Bug fixes following re-structure, PO_SelectPurchOrder.php extra bracket

Phil 1/9/03 Bug fixes following re-structure, re-added link to stock check sheets in index.php. Updated PDFBankingSummary.php to new R & OS version.

Phil 1/9/03 Allowed dates other than the calculated earliest dispatch date to be entered for the invoice date in Confirm_DispatchInvoice.php and also more flexible dating of orders in DeliveryDetails.php - to allow retrospective entry of an order already delivered.

Phil 1/9/03 MailSalesReport_csv.php automated mailing of csv sales analysis report bugs ironed out and new structure for includes modified.

(Shane Barnaby) 31/08/03 Renamed header.inc to session.inc to reflect pages function, which is to provide a common page for global includes and authenticate users. All references throughout the site modified to from HeaderTitle.inc to includes/header.inc and header.inc to includes/session.inc

(Shane Barnaby)31/08/03 Renamed HeaderTitle.inc to header.inc. The purpose of header.inc is to create the common HTML header used throughout the site.

(Shane Barnaby)31/08/03 Created footer.inc. Every page throughout the site that closed out the HTML with has been replaced with the footer.inc

(Shane Barnaby)31/08/03 Moved all includes to includes directory. All references to these include files have been updated.

(Shane Barnaby)31/08/03 Created css directory and moved all images to the default directory within css. This allows for the support of themes.

(Shane Barnaby)31/08/03 Removed all references to style from the config.php and added the $theme variable.

Shane 31/8/03 Removed web-erp.css all style now under the css directory/theme

Shane 31/8/03 Extensive mods to index.php to reflect the theme defined under css - currently only default theme set up but other directories under css can be set up and referred to from the variable in config.php

Phil 30/8/03 - PO_Items.php where a part code is entered it now checks that a part entered exists in the database before allowing it to be added to the order - bug fix.

Chris 30/8/03 - SelectOrderItems.php checks for existence of the picture file before attempting to display it if no picture then displays "NO PICTURE"

Phil 28/8/03 - META refresh statments referring to http could equally be (and more likely) https so made these more generic in SupplierCredit.php and SupplierInvoice.php. Link to OutstandingGRNs.php in index.php under AP reports.

Phil 28/8/03 - OutstandingGRNs.php and PDFOstdgGRNsPageHeader.inc R &OS code pdf-php reports added to show the value of goods received not yet entered against purchase invoices for the purposes of reconciling the goods received suspense account

Phil 28/8/03 - Modified InventoryValuation.php and PDFInventoryValnPageHeader.inc to use R &OS php-pdf class

Phil 20/8/03 - SelectOrderItems.php now shows sales type of the customer.

Phil 20/8/03 - GetPrice.inc now shows a warning if a zero price is returned.

Phil 20/8/03 - SalesAnalysis_UserDefined.php now used R & OS and accepts 4 levels of grouping allowing more complex reports.

Phil 20/8/03 - GetPrice.inc bug fixed now gets SalesType, DebtorNo, BranchCode price, then SalesType,DebtorNo, then SalesType, the default price list price.

Phil 19/8/03 - mods to ConfirmDispatch_Invoice.php, StockAdjustments.php, StockTransfers.php, SelectCreditItems.php, GoodsReceived.php to insert the new qty on hand in the stock movement records created by these scripts and StockMovements.php to show the quantity on hand after each "movement" (?).

Phil 19/8/03 - introduced a new field to StockMoves table NewQOH this records the new qty on hand after a stock movement

Phil 18/8/03 - CustWhereAlloc.php shows how an invoice was paid ie the allocations that were made against it.

Phil 18/8/03 - Z_CheckAllocs.php checks integrity of allocations

Phil 18/8/03 - CustAllocations.php now includes previous allocations that settled a transaction (fixed bug)

Phil 11/8/03 - PrintCustOrder_generic.php and PDFOrderPageHeader_generic.php now uses php-pdf by R & OS - for A4 Landscape packing slips - prints two copies one headed office copy the other customer copy. PrintCustOrder.php also allows re-prints on laser stationery with a link to PrintCustOrder_generic/.php. Also prints logo and company info.

Phil 10/8/03 - CustomerBranches.php now also shows branch code./

Phil 10/8/03 - SelectCustomer.php looks at customers codes/names not branches - fixed bug that didn't allow a customer to be selected for adding branches when none defined initially.

Phil 10/8/03 - Prices_Customer.php now allows many prices to be defined for specific branches. Prices defined not refering to a branch will be the customer default for all branches without a specific price defined.

Phil 10/8/03 - GetPrice.inc function changed to expect BranchCode. SelectOrderItems_IntoCart.inc also modified to send branch code when this function called from both SelectOrderItems.php and SelectCreditItems.php

Phil 10/8/03 - Added new field to Prices table BranchCode Varchar(10) so that pricing can be set specific to a branch of a customer.

Phil 10/8/03 - SelectOrderItems.php. DeliveryDetails.php DefineCartClass.php, SelectCreditItems.php changed references to $_SESSION['CustomerID'] to a new class variable Cart->DebtorNo so that another page open in the browser could not interfere with the order being entered in the same session.

Phil 7/8/03 - SupplierInvoice.php now checks for pre-existing supplier invoice of the same reference before allowing entry

Phil 7/8/03 - Install instructions modified to warn users of php.ini setting for session.auto_start sh/be =0

Phil 7/8/03 - Payments.php now deals with supplier discount received correctly. Also adds supplier code to narrative of GL postings and bank transactions.

Phil 6/8/03 - SupplierAllocations.php added check box to allocate whole trans and total allocated recalculation before submission of processing.

Phil 6/8/03 - DefineSuppAllocsClass.php was not allowing existing allocations to show - fixed.

Phil 6/8/03 - PO_PDFOrderPageHeader.inc changed $_GET['OrderNo'] to $OrderNo - order number not printing on purchase orders.

Phil 4/8/03 - CustomerAllocations.php fixed it so that settled transactions now show on the allocation screen where there was an allocation against the transaction from the receipt or credit note being allocated!

Phil 4/8/03 - CustomerInquiry.php fixed so negative receipts don't have allocation link and real ones do.

(Phil)StockCostUpdate.php no longer creates a zero GLTrans where there is no quantity of stock on hand.

(Phil)CustomerAllocations.php no longer shows unsettled negative receipts to allocate against. Also, settles transactions where the allocated amount = the amount of the transaction - there was a bug. New checkbox to tick off allocated transactions to get total exactly right and minimise keying (and input errors).Also, a button to recalculate the allocation total rather than report an error when attempting to process the allocation.

(Phil)CustomerInquiry.php modified not to allow allocations of a negative receipt. Allocations must be from credit notes and positive receipts only. Negative receipts show as available to allocate to.

(Phil)SelectCreditItems.php modified to ensure that a credit note could not be entered twice by hitting refresh. Whilst the CreditItems session variable was unset hitting refresh was entering a credit note for the tax value of the field posted for tax. This is now trapped with a check at the start of the page for an unset(SESSION['CreditItems']) and POST["ProcessCredit"].

(Phil)PO_PDFPurchOrder.php modified to go straight through to print the order if ViewingOnly==1

(Phil)Z_CheckDebtorsControl.php shows the debtors control account for the period selected to compare against the aged balance listing in local currency to prove data integrity - needs editing to modify the period to check.

(Phil)PDFBankingSummary.php modified to use PHP-PDF class by R & OS and now in a prettier tabular format

(Phil)PO_PDFPurchOrder.php and PO_PDFPageHeader.inc modified to use R & OS PHP-PDF class. Also now allows selection of a supplier contact to email the order to rather than print it then fax it as was the traditional method.

(Phil)New scripts for StockCheck.php and PDFStockCheckPageHeader.inc pdflib based stock sheets print outs.