webERP Change Log
06/2/09 Bogdan Stanciu: session.inc - xhtml compatability work.
06/2/09 Tim: PDFStockLocTransferHeader.inc - Correct layout problems
06/2/09 Bogdan Stanciu: ConnectDB_mysql.inc and ConnectDB_mysqli.inc - xhtml compatability work.
06/2/09 Bogdan Stanciu: AccountGroups.php - xhtml compatability work.
06/2/09 Tim: PDFStockLocTransfer.php - Correct layout problems and uninitialised variable assignments
06/2/09 Tim: StockLocTransfer.php - Add javascript and other UI improvements, and default control, and correctly initialise variables
06/2/09 Tim: StockLocTransferReceive.php - Add javascript and other UI improvements, and default control, and correctly initialise variables
06/2/09 Tim: WWW_Users.php - Correctly show default theme in selection
05/2/09 Tim: Update default.css for image border
05/2/09 Tim: PDFGrnHeader.php - Correctly Assign Logo variable.
05/2/09 Bogdan Stanciu: header.inc - Correct html for xhtml compatability
05/2/09 Bogdan Stanciu: footer.inc - Correct html for xhtml compatability
05/2/09 Bogdan Stanciu: MiscFunctions.js - Add externalLinks() function for xhtml compatability
05/2/09 Bogdan Stanciu: AccountGroups.php - xhtml compatability work.
04/2/09 Tim: WhereUsedInquiry.php - Add javascript and other UI improvements, and default control
04/2/09 Tim: GoodsReceived.php - Add javascript and other UI improvements, and default control
04/2/09 Tim: DefinePOClass.php - Remove unnecessary variable declarations
04/2/09 Tim: PO_SelectOSPurchOrder.php - Add javascript and other UI improvements, and default control
04/2/09 Tim: BOMs.php - Add javascript and other UI improvements, and default control
04/2/09 Tim: WorkCentres.php - Add javascript and other UI improvements, and default control
04/2/09 Tim: BOMListing.php - Add javascript and other UI improvements, and default control
04/2/09 Murray: small changes for better theme support
04/2/09 Tim: CustomerReceipt.php - Correct bugs in variable default assignments
03/2/09 Tim: BOMInquiry.php - Add javascript and other UI improvements, and default control
03/2/09 Tim: SelectWorkOrder.php - Add javascript to check input form, and default control
03/2/09 Tim: WorkOrderEntry.php - Add javascript to check input form, and default control
03/2/09 Tim: GLTags.php - Add default control
03/2/09 Tim: GLBudgets.php - Add javascript to check input form, and default control
03/2/09 Tim: MiscFunctions.js - Add function to select the default control for the form
03/2/09 Tim: GLJournal.php - Add default control selection
02/2/09 Tim: GLAccounts.php - Add javascript to check input form, and default control
02/2/09 Tim: AccountSections.php - Add javascript to check input form, and default control
02/2/09 Tim: AccountGroups.php - Add javascript to check input form, and default control
02/2/09 Tim: Tax.php - Correct typos in variable names
02/2/09 Tim: GLBalanceSheet.php - Default balance date to current period and ensure that all variables are initialised
02/2/09 Tim: GLProfit_Loss.php - Correctly show From and to dates and ensure that all variables are initialised
02/2/09 Tim: PDFChequeListing.php - Add javascript to check valid dates
02/2/09 Tim: SelectGLAccount.php - Improve user interface, and add in javascript code
02/2/09 Tim: GLTrialBalance.php - Correctly show From and to dates
01/2/09 Tim: Z_Upgrade_3.09-3.10.php - Add upgrade script
01/2/09 Tim: SelectSupplier.php - Correct uninitialised variables
01/2/09 Tim: GLJournal.php - Correct uninitialised variables
01/2/09 Tim: Payments.php - Add javascript functionality
01/2/09 Tim: CustomerReceipt.php - Add javascript functionality
01/2/09 Tim: BankMatching.php - Add javascript functionality
01/2/09 Tim: MiscFunctions.js - Allow for negative signs in numeric input fields
01/2/09 Tim: INSTALL.txt - Add instructions for renaming config file
01/2/09 Tim: api_workorders.php - Correct date verification calls
01/2/09 Tim: api_stockcategories.php - Add StockCatPropertyList() function and correct return values in other functions
01/2/09 Tim: api_salestypes.php - Add InsertSalesType() function and correct return values in other functions
30/1/09 Tim: PDFDIFOT.php - Remove superfluous line break.
30/1/09 Murray: Added htmlspecialchars_decode support for <5.1 PHP versions. Fixed up geocode support.
28/1/09 Murray: Added CSS classes to other themes to support better page titles and help fields.
27/1/09 Max (mxph): InputSerialItemsKeyed.php - Jump to first serial number field, to enable bar code scanner to work.
27/1/09 Bogdan Stanciu: CustomerTypes.php - Correct sql statement
27/1/09 Murray: More jelly theme support, adds some CSS compatibilty support
26/1/09 Bogdan Stanciu: DebtorsAtPeriodEnd.php - Correct header string
26/1/09 Bogdan Stanciu: Add_SerialItems.php - Correct typo in variable name.
26/1/09 Tim: SystemCheck.php - Add mysql character set inquiry
25/1/09 Tim: Stocks.php - Correctly initialise variables
25/1/09 Tim: PDFStockTransferHeader.php - Initialise $XPos variable to zero
25/1/09 Tim: StockTransfers.php - Correct missing values for $ErrMsg and $DbgMsg
25/1/09 Tim: PO_SelectPurchOrder.php - Correctly initialise $_POST['StockLocation'] for all possibilities
25/1/09 Tim: SelectProduct.php - Initialise variable $Its_A_Labour_Item
25/1/09 Tim: SelectProduct.php - Correct typo in variable name $DbgMsg
25/1/09 Tim: CustomerBranches.php - Ensure all variables are initialised
25/1/09 Tim: AddCustomerContacts.php - Correctly initialise $_GET['delete']
25/1/09 Tim: Customers.php - Correctly initialise $ID, $Edit and $_POST['New']
25/1/09 Tim: GLAccountInquiry.php - Correctly initialise $ShowIntegrityReport and $_POST['tag']
25/1/09 Tim: GLTransInquiry.php - Correctly initialise counter variable $j
25/1/09 Tim: PrintCustTrans.php - Correct typo in variable name
25/1/09 Tim: SelectCustomer.php - Ensure that $_SESSION['CustomerID'] is initialised
25/1/09 Tim: SelectOrderItems.php - Ensure that $_POST['part_' . $i] is initialised
25/1/09 Tim: SelectOrderItems.php - Correctly find location name
25/1/09 Tim: footer.inc - Correctly initialise $_SERVER['HTTPS']
24/1/09 Ashish Shukla: Changes to WorkOrderCosting.php
23/1/09 Tim: Corrections to api functions
23/1/09 Tim: PrintCustTransPortrait.php - Check that payment.jpg exists before trying to print it
21/1/09 Tim: PDFTransPageHeader.inc - correctly decode html special characters
21/1/09 Murray: Add jelly theme which adds more icon support and some minor UI improvements.
17/1/09 Klaus Wulff: Store the logo in a session variable, and search for the logo selecting a default if none present.
16/1/09 Tim: Correct the default date format in GetPeriod call.
14/1/09 Phil: Show terms on SelectOrderItems.php - make Location on SelectOrderItems.php use Cart class $_SESSION variable LocationName - rather than ugly hack that had crept in somehow.
13/1/09 CW: Update to gel theme from CW
13/1/09 Ashish Shukla: Script to copy a bom - Z_CopyBOM.php
13/1/09 Tim: Correctly show sourceforge logo in footer
13/1/09 Pablo Martin: geocode, add map width and height variable to selectcustomer and selectsupplier.
12/1/09 Pablo Martin: Fix typing error in WorkOrderCosting.php.
12/1/09 Klaus Wulff: Payments.php - Fix strings not in correct gettext format, as per Klaus Wulff
12/1/09 Klaus Wulff: Changes to PaymentTerms.php to fix errors in variable checks.
12/1/09 Klaus Wulff: Changes to footer.inc to show the day of the week in the correct language, and to search for logo.
12/1/09 Klaus Wulff: Fix CompanyPreferences for when GLAccounts dont exist
10/1/09 Tim: Add api documentation page to manual.
10/1/09 Tim: Change area column in salesanalysis table to be 3 characters long
10/1/09 Tim: Update work orders api.
6/1/09 Tim: Correct bug in SelectOrderItems.php preventing all order lines from being modified
6/1/09 Tim: Add purchase order number to GRN
6/1/09 Tim: MiscFunctions.js - Remove spaces at end of file
6/1/09 Tim: api_salesareas.php - Add VerifyAreaCodeDoesntExist() function
6/1/09 Tim: api_debtortransactions.php - Correction to GetSalesGLPosting function
6/1/09 Tim: Addition to mysql update script to correct salesglpostings definition
29/12/08 Tim: PO_Items.php - Correct lookup price bug when editing an item
26/12/08 Tim: StockLocStatus.php - Show status even when qty is zero
26/12/08 Tim: Correct session timeout problem
24/12/08 Tim: Index.php - New menu item for adding purchase order
24/12/08 Tim: Corrections for updating GL tags
24/12/08 Tim: GLJournal.php - Improvements to journal entry
24/12/08 Tim: GLBudget.php - Improvements to budget update
24/12/08 Tim: Update api for salesman and sales area functions
18/12/08 Murray: UI updates to SelectProduct to match Customer/Supplier select screens.
18/12/08 Murray: Customer Inquiry and Supplier Inquiry UI updates to match each others screen layout
17/12/08 Murray: PDF Append, fix Stocks to append correct '0' state, allow Invoice printing to accept either '0' or 'none' state
17/12/08 Murray: Sales Orders, fix searching for Order Items, display of correct selected method
17/12/08 Murray: Sales Orders, clean up display of order entry, rename "Customer No." to "Customer Code"
17/12/08 Murray: SelectSupplier, modified to match UI of SelectCustomer
16/12/08 Murray: CRM related: Configurations settings allows choice of extended Supplier Data or Customer Data
16/12/08 Murray: SelectCustomer, code changes to match code standards, cleanup
14/12/08 Murray: CRM related: SelectCustomer extended customer info available
14/12/08 Murray: CRM related: SelectCustomer now can add notes, add group notes, add contacts
4/12/08 Tim: Login.php Select default company in login list
4/12/08 Tim: Improve and reduce javascript functions
4/12/08 Tim: New api functions to retrieve webERP settings
4/12/08 CW: New theme called gel
28/11/08 Murray: CRM related: SelectCustomer.php now has export of customers via CSV format
24/11/08 Murray: CRM related: SelectCustomer.php now has search by Customer Type
24/11/08 CW: css/default/default.css links now have white background was possible to lose text on blue background with on hover
24/11/08 CW: includes/ConnectDB_mysql.inc - fix transaction abstraction calls to mysql_query - $Conn after SQL
15/11/08 Tim: Correct bug in WorkOrderIssue.php stopping the updating of stockserialitems for batched items.
14/11/08 Tim: Add GetBatches() function to api
14/11/08 Tim: Add batch control to WorkOrderIssue() api function
13/11/08 Tim: Improvements to JavaScript functions and UI improvements in GLJournal.php
12/11/08 Abhijit: Correct the discount percentage check in api_salesorders.php
11/11/08 Matt Taylor: Added Z_ImportStocks.php; Database transactions in ConnectDB_mysql.inc and ConnectDB_mysqli.inc;
11/11/08 Tim/Moxx consulting: Change UI of GLJournal.php, and add javascript checking
10/11/08 Ashish Shukla: Correct LineItem Due Date is incorrect in SelectOrderItems.php
10/11/08 Tim: DeliveryDetails.php - Fix to Correctly bring forward Deliverto name
10/11/08 Tim: Create WorkOrderReceive() function in api
7/11/08 Tim: Improve error checking in WorkOrderIssue() function
5/11/08 Murray: typo mods to UI to make it easier to use, adjustments to PDFGrn.php
4/11/08 Tim: PO_Items.php - Change to prevent no stock form being repeated
4/11/08 Tim: Alter api function to return work order number when work order first inserted
4/11/08 Tim: GetConfig.php - Fix to ensure Default price list is read as a string
4/11/08 Tim: Create WorkOrderIssue() function in the api.
4/11/08 Mike Appolonia: PDFStockCheckComparison.php - correct parsing error bug. Remove extra close bracket.
4/11/08 Tim: api function to create a works order
3/11/08 Tim: Create api for purchasing data
3/11/08 Tim: api_stock.php - Use sql transaction for inserting stock item
2/11/08 Tim: Add api function to do stock adjustments
2/11/08 Tim: api_stock.php and api_xml-rpc - Alter GetStockBalance() and GetStockReorderLevel() to return an array by location
2/11/08 Tim: config.php - Correct timezone settings
2/11/08 Phil: modifications to PurchData.php to allow entry of a date when the price was entered as sponsored by Ricard Andreu
1/11/08 Tim: CustomerAllocations.php - Correct bug giving incorrect figure in left to allocate
1/11/08 Tim: Correct bug in ModifySupplier() function
1/11/08 Tim: Update index.php to include link to GL Tags
1/11/08 Phil: Add new script to update or insert prices based on standard/WA costs or preferred supplier costs for stock category/currency/sales type of the users selection - work sponsored by Ricard Andreu
31/10/08 Tim: Add reorder level functions to the api
30/10/08 Phil: added back the reports directory under companies/weberp - required for StockQties_cvs.php. Fixed StockQties_cvs.php for companies directory structure and trapped non-existent directory -error opening file.
29/10/08 Tim: Update api for SearchSuppliers() function.
29/10/08 Tim: Update api for GetSupplier() function.
29/10/08 Tim: Update api for inserting and modifying suppliers
29/10/08 Tim: Manual page for api function documentation
28/10/08 Tim: Add api function to get tax rate used for stock item
25/10/08 Tim: Add categorydescription to GetStockCategoryList() api function
25/10/08 Tim: SuppCreditGRNs.php - Correct bug in Add_GRN_To_Trans() function call
25/10/08 Tim: api_glaccounts.php - Add account name to account list function
25/10/08 Tim: CustomerAllocations.php - Correct bug where incorrect transaction number was shown
25/10/08 Tim: SelectCustomer.php - Add link to customer allocations
25/10/08 Tim: CustomerAllocations.php - Correct link back to Select Customers screen.
25/10/08 Tim: Correct strings in api_errorcodes.php to facilitate localisation.
24/10/08 Tim: Add api functions for lookup of general ledger accounts
24/10/08 Tim: Add api functions for stock categories
24/10/08 Tim: api_salesorders.php - Add additional checks to modify order lines function
24/10/08 Tim: PO_Items.php - Change sql to conform to mysql strict mode.
23/10/08 Ashish Shukla: Correction to StockLocStatus.php to take work orders in progress into consideration
23/10/08 Tim: Update api for GetCustomerBranch() function
23/10/08 Tim: DeliveryDetails.php - Change sql to conform to mysql strict mode, and updates to correctly bring forward delivery details.
22/10/08 Tim: api_stock.php - Add function to get stock outstanding on purchase orders
22/10/08 Tim: api_stock.php - Add function to get allocated stock
21/10/08 Tim: api_customers.php - Correct bug in sql checking for AutoDebtorNo
21/10/08 Tim: PO_Items.php - Correctly show $rootpath in href links
21/10/08 Tim: PO_Items.php - Correct bugs when updating an order and clean up code to align with coding standards
20/10/08 Tim: Add function to api to retrieve a sales price
20/10/08 Tim: Correct bugs in api function SetStockPrice().
20/10/08 Ashish Shukla: Correct WorkOrderCosting.php
19/10/08 Tim: Ensure chartdetails is correctly updated on creation of a new GL account
18/10/08 Tim: Add api function to set a sales price for a stock item
18/10/08 Tim: Add api functions to query customertypes table
18/10/08 Tim: Add api functions to query taxgroups table
17/10/08 Tim: Add api functions to query salesman table
17/10/08 Tim: Add api functions to query sales area table
16/10/08 Joe: Updated manual for the current units of measure setup
16/10/08 Tim: Update api_customers.php for new database field
16/10/08 Tim: Update api_branches.php for new database fields
16/10/08 Tim: Update database scripts for customer type.
16/10/08 Tim: Remove duplicated error code in api_errorcodes.php
15/10/08 Murray: CRM related: Add Customer Type to debtors, with maintenance UI
15/10/08 Tim: Add api functions to query shippers table
15/10/08 Tim: Add api functions to query stock location table
15/10/08 Tim: Correct bug in DeliveryDetails.php for when branch name contained an apostraphe and clean up code to conform with coding requirements
14/10/08 Tim: Correct sql in ModifySalesOrderLine to send orderline number
14/10/08 Tim: ModifySalesOrderLine: Multiply discount percent by 100 and check that it is below 100 before insertion
14/10/08 Tim: Correct ModifySalesOrderLine function to call VerifyUnitPrice() instead of VerifyQuotation()
14/10/08 Tim: InsertSalesOrderLine: Multiply discount percent by 100 and check that it is below 100 before insertion
14/10/08 Tim: Correct function InsertSalesOrderLine, change VerifyDiscountPercent() to VerifyNarrative().
14/10/08 Tim: Correct InsertSalesOrderLine function to call VerifyUnitPrice() instead of VerifyQuotation()
14/10/08 Tim: Correct sql in select query in InsertOrderHeader function
14/10/08 Tim: SalesTypes.php - Force value of default session price list as soon as first entry is made
13/10/08 Tim: Fixed bug in GLAccountInquiry.php
13/10/08 Murray: mods to allow append PDF function to Portrait invoices.
12/10/08 Tim: Z_ImportChartOfAccounts.php - Bug fixes
12/10/08 Tim: Z_ImportGLAccountGroups.php - Script for importing Account Groups
12/10/08 Tim: Z_ImportGLAccountSections.php - Script for importing Account Sections
12/10/08 Tim: Bug fixes in api
12/10/08 Tim: New api call to create a GL account group
11/10/08 Tim: New api call to create a GL account section
11/10/08 Tim: Z_ImportChartOfAccounts.php - script that takes a csv file and uploads the general ledger accounts.
11/10/08 Tim: New api call to create a GL account code
9/10/08 Tim: Stock transfer note.
9/10/08 Murray: Geocode, updated to respect map_host parameter
8/10/08 Tim: Add the ability to print goods received notes to GoodsReceived.php
8/10/08 Tim: SQL additions for geocode updates
8/10/08 Tim: GLAccountInquiry.php - Allow selection by GL tag as well as account code
8/10/08 Tim: api_customers.php - Update api to deal with automatic numbering of debtors
8/10/08 Tim: Update GeocodeSetup.php to activate hyperlinks and format text for gettext
8/10/08 Tim: Fix bug in CustomerBranches.php
7/10/08 Tim: Correct bug in CustomerBranches.php. Missing }.
7/10/08 Murray: Add geocoding and mapping (experimental) to suppliers and customers, default is disabled. Options under Setup - Configuration Settings/Geocode Setup.
6/10/08 Tim: Remove vtiger integration from CustomerBranches.php
6/10/08 Tim: Remove vtiger integration from SelectOrderItems.php
6/10/08 Tim: Remove vtiger integration database fields
6/10/08 Tim: SystemParameters - Remove vtiger integration config option.
6/10/08 Tim: Change ISO to iso for xhtml compatability
5/10/08 Tim: Update api to enable modifying of sales order headers and order lines.
5/10/08 Tim: Update api to enable sales order lines to be inserted
5/10/08 Tim: Update api to enable sales order headers to be inserted
5/10/08 Tim: Correct sql scripts to show AUD to AUD exchange rate correctly
2/10/08 Tim: Correct bug in call to Update_Cart_Item() function
30/9/08 Tim: Change api to correct bugs in credit note transaction
29/9/08 Tim: Allow ProhibitPostingsBefore variable to be outside of currently created periods
29/9/08 Tim: Correct bug in GetPeriod()
29/9/08 Tim: Re-write of GetPeriod() in DateFunctions.php function to eliminate chartdetails errors
29/9/08 Murray: Updated index and Supplier Balance reports to provide consistant UI text labels.
28/9/08 Tim: Remove redundant error from GLJournal.php, CustomerReceipt.php and Payments.php
26/9/08 Tim: Correct sql bug in Suppliers.php
26/9/08 Tim: Update DefineJournalClass.php, DefinePaymentClass.php and DefineReceiptClass.php to allow selection of a GL Tag.
26/9/08 Tim: Update Payments.php to allow selection of a GL Tag.
26/9/08 Tim: Update CustomerReceipt.php to allow selection of a GL Tag.
26/9/08 Tim: Update GLJournal.php to allow selection of a GL Tag.
25/9/08 Ashish Shukla: Fixed bug to correctly show tax ref in Suppiers.php
25/9/08 Nicholas Lee: Added links to work order status and costing from issue and receipt scripts also links to issue and receive from status and costing scripts
24/9/08 Tim: New script to create and edit GL tags.
24/9/08 Tim: Add database tables to allow general ledger transaction tagging.
23/9/08 Tim: Change the initial user from demo to admin, and revisethe install instrcutions.
23/9/08 Tim: Check to see if user name has entries in the audittrail table, and refuse delete with a user friendly message.
22/9/08 Tim: Update html header to enforce strict XHTML syntax
22/9/08 Tim: Remove redundant check on prohibit journals before date.
21/9/08 Anthon Pang: Correct typo in INSTALL.txt
18/9/08 Tim: Z_ImportPartCodes.php to allow mass import of part codes from a csv file
18/9/08 Tim: Array of error descriptions and bug fix to api
13/9/08 Phil: Modified BOM.php, SelectProduct.php Stocks.php StockCategories.php WorkOrderIssues.php WorkOrderReceipts.php These changes allow entry of labour type stock categories - the stock categories script now allows selection of a profit and loss account for the recovery account (was the stock account). Items created (in Stocks.php) must be service/labour items - these can then be added to BOMs in the BOM.php script. Issues of such components will credit the recovery account and debit the WIP account. These items can also be set to auto-issue on receipt of finished items from work orders.
13/9/08 Phil: SelectProduct.php now displays just the default price in the local currency. Displaying all prices could result in overload on the screen - without showing specific debtors/branches/currencies the other prices are meaningless anyway.
12/9/08 Murray: update SelectOrderItems UI to provide more helpful text labels. Update index.php to provide more consistant UI text labels for Bank Account options.
11/9/08 Andres Amaya: Correct bug in PDFAgedDebtorsPageHeader.inc when salesman code is selected
11/9/08 Tim: Add option in StockTransfers.php to search on part code or description
10/9/08 Tim: Add field for suppliers tax reference
10/9/08 KStan: Insert link back to SelectProduct.php on successful insert of new strock item
09/9/08 Tim: Fixed colour scheme problem
09/9/08 Björn Paulsen: Fixed bug in PDFStockLocTransferHeader.inc for translation error, and improved layout.
09/9/08 Ashish Shukla: Fixed bug in AuditTrauil.php where the field value contains a comma, as per Ashish Shukla
09/9/08 Thomas Pulina: Correct typo in Payments.php
09/9/08 Tim: Correct bug in MiscFunctions.php for when default currency is not in the ECB list
08/9/08 Nichlas Lee: Change to show company logo, and to ensure the sourceforge logo is correctly shown when using https and IE
08/9/08 Tim: Corrected Add_SerialItems.php to show correct path to StockSerialItemResearch.php
08/9/08 Tim: Updated weberp-new.sql and weberp-demo.sql to create initial periods.
07/9/08 Tim: Correct bug in FormMaker.php that prevented images being shown in forms.
07/9/08 Ashish Shukla: Correct stock location problem in PO_Header.php.
07/9/08 Tim: Change Z_ChangeStockCode.php to alter the stockitemproperties table.
27/8/08 Thomas Pulina: Modified SelectProducts and PO Header to allow quick link to PO from Inventory Item
15/8/08 Andres Amaya: Correctly show controls for Category properties
12/8/08 Arnold Ligtvoet: Modifications and improvements to Quotation PDF form
21/7/08 Harald Ringehahn: Fixed non-gettext strings in customers.php and customerbranches.php
19/7/08 Stuart Sheldon: Changed RecurringSalesOrders.php and RecurringSalesOrdersProcess.php to use GetNextTransNo().
9/7/08 Tim: Update api to enable posting of simple invoices and credits
9/7/08 Murray: update Tax PDF report, sort by date, add missing headings to columns.
8/7/08 Tim: Correct date checking bug in api_stock.php
7/7/08 Tim: Correct MiscFunctions.php for divide by zero errors in Currency function.
4/7/08 Phil: Fixed bug in PaymentTerms.php that prevented addition of new terms because "day number must exist"
29/6/08 Harald Ringehahn: Z_SalesIntegrityCheck.php string missed gettextification and single quote space fixed. (Phil) This script extensively edited to conform to webERP coding conventions - single quotes, { at end of conditional statements not next line, SQL broken up on keywords, gettext strings not including trailing spaces.
01/7/08 Tim: Provide option to create a new supplier from the select supplier screen
30/6/08 Tim: Add api functionality for stock items enabling stock balances to be retrieved by a remote application
29/6/08 Harald Ringehan: Z_SalesIntegrityCheck.php string missed gettextification and single quote space fixed. (Phil) This script extensively edited to conform to webERP coding conventions - single quotes, { at end of conditional statements not next line, SQL broken up on keywords, gettext strings not including trailing spaces.
28/6/08 Tim: Add api functionality for stock items, allowing stock items to be created, modified, retrieved and searched from a remote application
28/6/08 Mox Consulting as reworked to latest version (Phil) multiple customer contacts faciltiy on customer.php
Version 3.09
27 June 2008
27/6/08 Phil: Now checks qoh of autoissue components on receiving items against a work order when CheckNegativeStock is enabled
24/6/08 Murray: Typo changes to Payments.php to simplify supplier receipts.
21/6/08 Tim: Add systype 40 for work orders.
18/6/08 Tim: SelectOrderItems. Changed too show carriage returns correctly in line narrative
17/6/08 Tim: Correct default options on Stocks.php
17/6/08 Murray: Added first version SystemCheck.php
13/6/08 Tim: Correct CustomerBranches.php to enable branch deletion
13/6/08 Ap Muthu: Correct corrupt messages.mo
13/6/08 Ap Muthu: Correct missing table in weberp-demo.sql
13/6/08 Ap Muthu: Correct typos in weberp-new.sql,weberp-demo.sql and GetConfig.php
12/6/08 Murray: minor changes to text labels of UI.
08/6/08 Tim: DeliveryDetails.php - Correct delivery address details and bug not allowing branch info to be returned.
26/5/08 Tim: PaymentMethods.php - Improve error handling..
26/5/08 Tim: PaymentTerms.php - Improve error handling..
26/5/08 Tim: SalesPeople.php - Improve error handling..
26/5/08 Tim: SalesTypes.php - Improve error handling..
26/5/08 Tim: Shippers.php - Improve error handling..
26/5/08 Tim: api_branches and api_errorcodes. Improvements to api.
22/5/08 Tim: WWW_Users.php: Update to only change the used language when the users own profile is being changed.
08/5/08 Tim: Selectproduct.php: Fix bug preventing page goto from working
08/5/08 Tim: Stocks.php: Correctly show line breaks in Long Description
05/5/08 Tim: Correct the display of the company name in CustomerReceipt.php when special characters have been used.
05/5/08 Tim: Correct bug in CustomerReceipt.php where batch narrative text was lost, and add in a cancel button for when customer is wrongly selected.
03/5/08 Tim: Fixed bug in CustomerAllocations that corrupted table when reallocated amount equalled originally allocated amount
30/4/08 Tim: Fixed bug in DeliveryDetails.php, to correctly show names and addresses with apostropges.
29/4/08 Tim: Fixed bug in CustomerAllocations, debug info left in from previous fix.
28/4/08 Phil: Fixed bug that showed date of GL entries twice on GLTransInquiry.php and munted format of table - attempted to put formating of the script back to webERP conventions
28/4/08 Muz: Add labels to CustomerInquiry.php links Allocation /View GL Entries etc
27/4/08 Tim: Add api for customer branches.
27/4/08 Tim: Put all api error codes in one file.
26/4/08 Muz: Correct path to preview icon in Customerinquiry.php
26/4/08 Tim: Update Credit_invoice.php to correctly mark the credit note as settled
20/4/08 Tim: Improvements to api.
18/4/08 Tim: Improvements to api.
16/4/08 Tim: Correcting problem in displaying old allocations.
16/4/08 Tim: Updated Customers.php and CustomerBranches.php to correctly show branch details when escaped characters are used.
16/4/08 Tim: Change to PrintCustTrans.php to take into account pdf attachments.
14/4/08 Tim: Add currency searches and other improvements to api
13/4/08 Tim: Added xml-rpc and php interfaces to the api.
12/4/08 Tim: Correction for CustomerAllocations.php to correctly do part allocations.
12/4/08 Tim: Update fpdf_tpl.php to the latest version.
12/4/08 Tim: Correct bug in SupplierInvoice.php preventing another supplier invoice being entered directly.
10/4/08 Tim: Add file fpdi/fpdf_tpl.php required for attaching pdf files to invoices
10/4/08 Harald Ringehan: ConnectDB_mysql.inc and other db abrastraction scripts used htmlspecialchars instead of htmlentities to prevent XSS attacks inside DB_escape_string function - this leaves accented characters alone and doesn't disturb translations. Bug spotted as a result of Umlauts on command buttons failing to work.
08/4/08 Tim: Correct DB_last_insert_id bug in ConnectDB_mysql.inc and ConnectDB_mysqli.inc
06/4/08 Muz: Changes to make options clearer
06/4/08 Tim: Test whether StockID is set before seeing if part already exists.
06/4/08 Tim: Update currency exchange rates when default currency is changed.
30/3/08 Tim: Bring in the xmlrpc libraries.
29/3/08 Mo: Improve error messaging in ConnectDB.inc and ConnectDB_mysql.inc and ConnectDB_mysqli.inc
29/3/08 Renier: Improvements to Z_CheckDebtorsControl.php
29/3/08 Renier: Added Z_SalesIntegrityCheck.php
29/3/08 Renier: Improved layout and added drill down to GLTansInquiry.php
29/3/08 Tim: Correct behaviour of quick entry items.
25/3/08 Tim: CustomerBranches.php Correct default delivery days field
25/3/08 Tim: SupplierInvoice.php Move unsetting of session variables, to show correct message per emdeex
25/3/08 Tim: Altered comments on api_customers.php
24/3/08 Tim: Added first draft of api_customers.php
22/3/08 Tim: Removed the default charset from the database definitions.
22/3/08 Tim: Altered the Connect_DB scripts to correctly show quotes in DB_escape_string.
22/3/08 Tim: Completed sweep of code to remove unnecessay DB_escape_strings, remove unneceassry Class="tableheader" statements, and put the row colouring into the css file.
12/3/08 Tim: to side step SQL injection and cross scripting attacks modified session.inc to DB_escape_string for all elements of $_POST and $_GET - the DB_escape_string functions are now redundant inside scripts so started to remove these in a sweep of all code.
11/3/08 Renier DuPlessis/Phil: Currencies.php now has link to show a graph of recent exchange rate fluctations and spiced up with a flag of the appropriate country of the currency.
10/3/08 Tim: complete sweep of the code to replace all occurrences of
10/3/08 Renier DuPlessis/Tim: Reworked CustomerAllocations.php - typos and tidy up
1/3/08 Phil: New config variable SystemParameters.php session.inc modifications to allow exchange rates to be updated daily from the European Central Bank on the first user login of the day. The manual option is still available for those who cover exchange rate risk. Updates to the manual added a section on currency maintenance.
29/2/08 Phil: Currencies.php MiscFunctions.php now has a function to get exchange rates from ecb (European Central Bank) published daily as XML file that is parsed to retrieve the current day's spot rates are shown against the current currencies table rates.
25/2/08 Phil/Harald Ringehahn - modified the link to the manual in header.inc such that for locales other than en_?? the manual is sought under locale/xx_XX/LC_MESSAGES/Manual/ManualContents.php - Harald's is the first translation we have of the manual into German and it can now be added to the German translation archive.
16/2/08 Phil: BankAccounts.php Payments.php and CustomerReceipt.php DefinePaymentClass DefinedReceiptClass BankReconciliation.php all modified to allow for multi-currency bank accounts ) Manual updates to Bank Accounts and Bank Payments.
01/2/08 Tim: Fix problem in SelectOrderItems.php re keywords appearing wrongly
23/1/08 Tim: Fix problem with call to javascript function in Stocks.php
23/1/08 Tim: Improve Selectproduct.php to show more information about product state.
15/1/08 Tim: Change Customers.php and Suppliers.php to accept apostrophes and accented characters in addresses.
15/1/08 Tim: BOM Cost rollup updates to force cost rollup on insertions and deletions.
15/1/08 Tim: Change last insert functions to work with audit trail.
13/1/08 Phil: Sales Analysis Manual examples and some rework for Creating a New System
12/1/08 Tim: Correct bug in Date functions.
12/11/08 Tim: Sales orders now obtain next transaction number from GetNextTransNo function changed in DeliveryDetails.php
12/11/08 Tim: New field in stockmaster for perishable available if the item is controlled - changes to Stocks.php to accomodate
10/1/08 Tim: Lock tables to avoid concurrency problems when getting next transaction numbers as reported on the list
1/1/08 Tim Schofield: New Factor company maintenance and ability to set up factor comapnies against suppliers >>>>>>> 1.143
17/11/07 Damian Lee: Improvements to Inventory valuation report bringing in the units identifier
13/11/07 Tim: AuditTrail.php script added with changes in DB_query to add records to the audit trail for all inserts, updates and deletes. The Audit Trail script allows the user to inquire on this data for a range of dates and tables being modified - with field names parsed into nice screen output.
Version 3.08
7 November 2007
3/11/07 Peter Moulding: mysqli support new/(i)mporved mysql db functions for mysql >4.1 - can now have $dbtype='mysqli'; in config.php provided appropriate mysqli library available to php
3/11/07 Tim: GLBudgets.php added to allow development/review and entry of GL budgets.
3/11/07 Renier du Plessis: Witih certain versions of PHP or PEAR in debug mode I have experienced the following error notices: "Only variable references should be returned by reference" I recommend the atached FIX for htmlMimeMail.php
24/10/07 rent a coder - sponsored by Chris - SelectOrderItems.php now allows entry of line items by entry of a quantity in the item browse mode
24/10/07 DateFunctions.inc GetPeriod function now checks for date format of ProhibitPostingsBefore and sets up a default of one year ago if a null date
9/10/07 DefineCartClass - now defaults poline='' and itemdue = '' for credit notes
7/10/07 Tim Schofield : Bug fixes in Freight cost calculation.
5/10/07 Tim Schofield : Amend table headers in OrderDetails.php
5/10/07 Bjorn Paulsen : Bug fix in PDFOrdersInvoiced.php
5/10/07 Tim Schofield : Remove CartClass references
1/10/07 Tim Schofield : include errors in WorkOrderReceive.php
29/9/07 Tim Schofield : Correct calculation of costs for GL entries
25/9/07 Anthony C : Show additional item properties in Select Item mode
25/9/07 Jan Hendrik Rust : Update javascript for product category changes
25/9/07 SystemParameters.php now has new parameter to ProhibitNegativeStocks - new config added to DB.
25/9/07 ConfirmDispatch_Invoice.php now checks stock balances after the order invoiced before processing it and reports back nasty message if stock will go negative.
25/9/07 GoodsReceived.php now checks stock balances after the receipt of stock is processed for negative receipts of stock and it reports back a nasty message if stock will go negative.
25/9/07 StockAdjustment.php now checks the stock balance after the adjustment to see if it would go negative, if so it reports back a nasty message and prevents the adjustment.
25/9/07 WorkOrderIssue.php now checks the stock balance after the issue to see if it would go negative, if so it reports back a nasty message and prevents the issue.
21/9/07 Tim Schofield : Correct date conversion for statements with only settled items on.
20/9/07 Tim Schofield : Changes to SystemParameters.php for Y-M-D date format
20/9/07 Tim Schofield : DateFunctions.inc now allows Date Format option Y-m-d as required by Scandanavian countries
14/9/07 Tim Schofield : Alter sql for serial item issues, and sql bug fixes
13/9/07 Tim Schofield : Correct bugs in the issuing of serialised components
12/9/07 report_runner.php MailSalesReport.php and MailSalesCSV.php now added DatabaseName variable
11/9/07 Tim Schofield : Various bug fixes in SelectOrderItems.php
10/9/07 Tim Schofield : Bug fixes in SelectOrderItems.php
08/9/07 Tim Schofield : Update Stocks.php for javascript update of stock category changes
07/9/07 Tim Schofield : Update Z_poAdmin.php for new options
07/9/07 Tim Schofield : Improvements to translation scripts
06/9/07 Tim Schofield : Remove non ascii characters in OrderDetails.php
30/8/07 Tim Schofield : Corrections to language scripts
30/8/07 sunshine33777 : Fix HTML error in PO_PDFPurchOrder.php
27/8/07 Tim Schofield : Correct javascript in login.php
25/8/07 Tim Schofield : Replace corrupted .mo file
25/8/07 Tim Schofield : Correct sql in SupplierInvoice.php to agree with ansi standard
23/8/07 Tim Schofield : Bug fix in SalesTypes.php
23/8/07 Tim Schofield : If default price list doesnt exist, then update config for it
23/8/07 Mo Kelly : Modify Customer.php to add parameter to determine if customer PO lines are collected during quick entry of sales oreders
23/8/07 Mo Kelly : Modify DefineCartClass.php to incule PO line data and line item due dates.
23/8/07 Mo Kelly : Modify SelectOrderItems.php to allow the entry of due dates and corresponding customer PO Line by sales order line if parameter is set in the debtormaster to collect this field. Also to caluculate and use default delivery date by line item.
23/8/07 Mo Kelly : Modify SelectOrderItems_IntoCart.inc to include PO line data and line item due dates
23/8/07 Mo Kelly : Modify PDFDIFOT.php to calculate on time deliveries using the line item due date when available
Version 3.071
13 August 2007
13/8/07 StockCostUpdate.php added input type=hidden MaterialCost to allow MaterialCost for Manufacturing items to be correctly defaulted on update of labour and overhead costs
13/8/07 StockCategories.php moved the submit enter button outside of the code for if a category is selected. Button was not shown and prevented adding a new stock category. A show stopper bug!
Version 3.07
2 August 2007
8/8/07 StockCostUpdate.php changed function call to match function in SQL_CommonFunctions.inc for GL update and the cost roll up parent changed to Parent
5/8/07 Added new tables stockcatproperties and stockitemproperties and modified Stocks.php and StockCategories.php to allow setup of category properties. These properties create input options against the stock item in Stocks.php for recording specific information relating to the category of items.
Version 3.06
2 August 2007
Version 3.06rc3
29 July 2007
29/7/07 Tim Schofield : Amend SelectWorkOrder.php to allow work order status inquiry.
29/7/07 Tim Schofield : Create WorkOrderStatus.php.
27/7/07 Tim Schofield : Alter GLProfit_Loss.php to show headings correctly.
26/7/07 Tim Schofield : Correction to sql/SQL_CommonFunctions.inc to move stock rollup functions into inc file, and show gl transactions when bom structure alters material cost
25/7/07 Tim Schofield : Correct syntax of sql in WorkOrderReceive.php.
25/7/07 Tim Schofield : Correct BOMs.php and StockCostUpdate.php to correctly show gl transactions, on Standard Cost roll up.
25/7/07 Tim Schofield : Change WorkOrderCosting.php so that requirements are shown correctly.
25/7/07 Tim Schofield : Change WorkOrderReceive.php to enable a works order to be viewed when previous works order with sames product has been closed.
23/7/07 Lindsay GetStockImage.php changed $filepath = $_SESSION['part_pics_dir'] . $pathsep;
23/7/07 salesmancode selections removed from wwww_users.php
22/7/07 Tim Schofield : Alter GLTrialBalance.php to show headings correctly.
19/7/07 Tim Schofield : Addition to BOMs.php to roll up standard material costs into the parent items when a BOM structure is altered.
19/7/07 Tim Schofield : Addition to StockCostUpdate.php to roll up standard material costs into the parent items when a material cost is altered.
19/7/07 Tim Schofield : No StockID being selected in SelectProduct.php
Version 3.06rc2
18 July 2007
18/7/07 Tim Schofield : Correct error in SelectProduct.php, and sql/upgrade3.05-3.06.sql preventing sales price from being displayed.
15/7/07 Tim Schofield : Correct includes error in OutstandinfGRGs.php, StockCheck.php, SupplierBalsAtPeriodEnd.php, and Tax.php
14/7/07 Tim Schofield : Correct bug in SystemParameters.php preventing config updates in.
23/6/07 PriceLists and several other pdf reports failed to include session.inc in the script
23/6/07 Lindsay Harris $$ error in PO_DetailItems.php
23/6/07 PurchData added 3 dp for the suppliers price - we don't currently have settings for dp by currency which would be good.
23/6/07 Added column in WOIssues.php to show the quantity already issued against requried quantities
Version 3.06rc1
20 June 2007
18/6/07 WorkOrderCosting.php added - shows variances by item with option to close the work order and take variances to GL (if integration to Stock enabled)
17/6/07 SelectProduct.php and StockStatus.php now shows demand including works order component requirements and also the quantity on open work orders yet to be received
13/6/07 WorkOrderIssues.php added to CVS - sponsored manufacturing work by Tariq Farooqi and Lindsay Harris
12/6/07 BOMs script re-worked matrice and arbore variables to create multi-dimensional array directly with english variable names.
12/6/07 Locations script now checks for bom records referring to the location before allowing deletion
12/6/07 Stocks.php script now deletes prices for the item before deleting the item itself.
2/6/07 Added WorkOrderEntry.php with new work order tables to add work orders with multiple outputs. Can change quantity required and required by dates. Also added SelectWorkOrder.php to allow selection and modification of a work order - from the work order number or by item, location and status open or closed. Sponsored by Lindsay Harris and Tariq
27/5/07 GLTrialBalance and GLProfit_Loss now use the parentgroup heirarchical account groups with nested sub-groups of accounts
20/5/07 Rob Wolf - SilverWolf theme added
20/5/07 SelectProduct.php now shows summary data about the item selected total qty on hand, ordered, purchasing data, unit of measure etc.
20/5/07 New salesman login option that allows selection of a salesman - these logins are restricted to selecting only customers who have branches allocated to the selected salesman.
20/5/07 BOM now shows quantity on hand of components - sponsored by Manny Neri Dutch Precision
7/5/07 Wayne McDougall - includes/Login.php checks for magic_quotes_gpc and issues a warning if they are enabled.
3/5/07 Updated installation instructions to recommend magic quotes off. Added .htaccess file for the main directory to default magic quotes for those web-servers that support .htaccess files.
6/5/07 Wayne McDougall - footer.inc / InventoryPlanning.php use strftime to get locale specific dates rather than gettext translation
1/5/07 Wayne McDougall - footer.inc nows uses phpgettext for date/time translation, and the webserver locale date/time if no translation is available
1/5/07 Wayne McDougall - Use DefaultDateFormat in all PDF report headings
1/5/07 Wayne McDougall - InventoryPlanning.php now supports translation of abbreviated month names in the page headers
30/4/07 Wayne McDougall - StockStatus.php now displays a summarised sales pricing history for the selected customer (if any). When called from SelectOrderItems.php, shows the sales pricing history for the customer whose order is being entered.
30/4/07 StockLocTransferReceive.php now has an option to delete the balance of a transfer if the quantity received is less than the amount recorded as dispatched.
30/4/07 Portrait invoice now shows serial numbers/lot numbers and qty for controlled items sold. Work sponsored by Tip Top Tips Sarl
26/4/07 CustomerReceipt fixed bug where a GL receipt and a customer negative receipt (or vice versa) resulted in a zero batch that did not have the correct GL entries created for it - result TB out of balance and debtors control out of balance with list of balances.
26/4/07 Wayne McDougall - using the new Special Instructions field held against the branch record - CustomerBranches now allows entry and editing of the field. DeliveryDetails shows the messasge as does SelectOrderItems. Credit message only appears once now instead of for each line where the credit limit is exceeded.
20/2/07 CustomerBranches.php - removed ? syntax for comparison and assignment of GET values
20/2/07 Took out the default credit limit when a 0 credit limit is entered. If the user enters 0 then a zero credit limit is set.
20/2/07 ShipmentCosting bug with multiple lines of the same item on the shipment (albethey different POs) caused incorrect costings.
15/2/07 Danie optimised GLPostings.inc for postgres - thinks mysql performance will be even better too - sorting postings by account and doing one post for each period/account combination
12/2/07 SelectSalesOrder.php fails with postgres printpackingslip needs to be in the group by now fixed
12/2/07 Tax Categories now uses a cross join to be more ansi sql friendly - failed with postgres otherwise
12/2/07 Wayne McDougall - OrderDetails.php is not honouring the Landscape/Portrait config switch for invoice printing - now fixed.
12/2/07 Errol Livingston - Locations.php was checking for existence of worksorders in a non-existant table before allowing deletion!
9/2/07 Wayne McDougall - bug fix on width of terms in PrintCustTransPortrait.php
6/2/07 emdeex - PaymentAllocations.php and modifications to SupplierInquiry to allow viewing of where a payment made was allocated.
6/2/07 Ditesh - taken out references to session_register in several files - historical code no longer necessary implicit in $_SESSION
3/2/07 Wayne McDougall - bug fix in Z_CreateNewCompany.php the checkbox to create the new DB was incorrectly coded and would not have worked. Also SystemParameters.php the WikiPath variable was defined twice - this should not have caused issues in practise.
30/1/07 AccountGroups.php now allows hierarchical account groups GLTrialBalance.php now shows account groups within the new hierachy.
18/1/07 SpecialOrder.php now checks for customer hold reasons to ensure the customer is not on hold prior to placing the order so there is a warning if there is some credit issues
18/1/07 InventoryValuation.php now shows the quantitiy total for each product group which may or may not be meaningful
16/1/07 Gilles Deacur - added page offset buttons at the bottom of SelectSupplier SelectCustomer SelectProduct and added an account code to the GLTransInquiry script
Version 3.05
2 January 2007
2/1/07 Got webERP logo showing on footer.inc in report writer scripts. Updated copyright to change year on title.
2/1/07 Fixed bad bug that didn't post freight on Credit_Invoice.php script!!! This resulted in control account out of balance issues.
2/1/07 Added upgrade script that applies DB changes and does the data conversions for the user - now just have to run the script.
30/11/06 DB_connect_mysql and DB_connect_psql added a DB_show_tables function to abstract this one in the report writer.
29/11/06 BOMs.php removed dependency on mysql num rows and mysl_fetch_array functions and used abstraction functions as per the rest of the application. Modifications to consistency of braces use of prnMsg. Bug fixes as per Till
27/11/06 Upgrade script for 3.04-3.05 for postgres.
18/11/06 Now check on login that the company entered at login has a companies/directory defined to avoid logins to incorrect companies - bug noted by Alan Jones
24/10/06 added the directory Numbers to contain the PEAR module Numbers_to_Words that is a multi-language class. There is one modification required to avoid the dependency on PEAR's raiseerror function - this now refers to the webERP prnMsg function - otherwise updates to this module can be imported as necessary. Needs some testing with other Locales to check translation. It is only used in the PrintChecks.php script.
27/9/06 includes/LanguageSetup.php now uses the path prefix for the bindtextdomain statement\ - multi-lang would not have worked with report writer scripts
27/9/06 Shipt_Select.php now modified SQL per bug report <>'' doesn't work on integers with postgres.
17/9/06 PO_Header.php now have a button to update the delivery address based on the selection of the stock location
17/9/06 ShipmentCosting.php - added code to deal with weighted average costing - similar to SupplierInvoice.php below. Also now checks when closing to make sure that all the purchase order line stock receipts are invoiced before allowing to be closed. Also completes the purchorderdetails and updates the purchase order line quantity to be the quantity received to avoid the possibility of receiving additional stock against this line
16/9/06 SupplierInvoice.php GoodsReceived.php added a field to grns table to allow the standard cost at the time of receiving to be recorded in the GRN record rather than the purchorderdetails table - this allows for multiple receipts against a purchase order to be at different costs - required for average costing. SupplierInvoice.php now has code to deal with average costing GL entries and cost updates. Also deals with where the invoice is for a quantity more than is left in stock now - writes off the variance on the shortfall. GoodsReceived now tracks the weighted average of all receipts of a purchase order line so that the quantity received multiplied by the stdcostunit = sum of all cost received against the line.
16/9/06 New script Z_Upgrade_3.04-3.05.php required to bring cost data over to the grn records to fit with the new schema of allowing different drops of stock received to be booked in at different costs. Previously
13/9/06 Renier du Plessis polish-up of SalesTypes.php
11/9/06 DateFunctions.inc modified GetPeriod function to check for dates prior to the new ProhibitPostingsBefore parameter - postings get made in the period following this date now. Also SystemParameters.php script modified to allow selection of a period end to set ProhibitPostingsBefore
7/9/06 SupplierInvoice.php was not updating purchaseorderdetails quantities correctly due to errors in the supplier transaction class - the podetailitem was populated with the orderno!! Modified the SuppInvGRNs script to work with purchase orders and added the orderno to the supptrans class script
7/9/06 Shipments.php script modified to ensure that the shipment is created before purchorderdetails added to it
6/9/06 Fixed bug in SelectCreditItems.php and Credit_Invoice.php for "Write off Stock" type credits A warning is displayed: and no process button is available.
30/8/06 Fixed to GetStockImage.php and scripts that call it to display stock images correctly
22/8/06 Dave fixed and improved reportwriter scripts drop down list for field selection and over-ride with entry of calculated field SQL
22/8/06 Dumitru Popa new BOMs.php script that shows the full context of parents and children for multi-level BOMs.
19/7/06 saras chithra PO_OrderDetails.php link refered to sales orders sh/be purchase orders
19/7/06 ConfirmDispatch_Invoice.php updates to salesorderdetails did not work correctly for orders with multiple lines of the same item.
12/7/06 Z_RePostGLFromPeriod.php did not work correctly from periods into the business since bfwd balances were zeroed rather than using the previously bfwd balance - now fixed.
11/7/06 SupplierTransInquiry.php allows supplier transactions to be listed with GL transactions created for each.
11/7/06 Alan J report_runner.php now allows command line arguments to run reports using the php interpreter directly.
10/7/06 Alan J ConnectDB.inc - now allows for the DatabaseName to be set in hard code for scripts that do not require a login - in particular automated reports.
5/7/06 SpecialOrder.php was not creating multiple line orders correctly - needed to have orderlineno in SQL to add salesorderdetails records
4/7/06 SupplierInvoice.php made manual entry of taxes work correctly now takes values at time of processing the invoice previously they were not updated before posting
4/7/06 Credit_Invoice.php removed taxrate from stockmoves sql insert statement on stock write off option
27/6/06 jesse - includes/Add_SerialItems.php : + changed some spacing & line breaks for readability + Added checks for Serialised items to be sure they have Qty of either 1 or 0, plus links to SerialResearchTool when there are problems + Added ReValidation option (necessary for current attempts at Manufacture Items scripts) - AgedDebtors.php : added option to pull only Debtors who have a Branch assigned to the selected SalesPerson - ConfirmDispatch_Invoice.php : make Tran Date field size=15 to match others and look more uniform - CreditItemsControlled.php : + Ln14-19 - better checks to be sure you are returned to the proper Credit page + Ln ~66 - remove the AddBatches code - it was not necessary because it exists and is called in the Add_SerialItems code - CustomerBranches.php + Display Total Enabled/Disabled Branches below list + Ln449,450 - quote the Hidden Input Values + Ln459 - add code to collect New BranceCode, Debtor Name, and Debtor Address to prepopulate when creating 1st Branch - Customers.php + Ln176 - Correct text: "entry of invoice" -> "entry of customer branch" + Ln235 - typo: Custmomer -> Customer + Ln569 - Capitalization TYPe -> TYPE - CustomerTransInquiry : Added feature to view ALL transactions - DateFunctions.php : Remove extra line at bottom - reportwriter/admin/defaults.php : Add option to have Range/All w/ Range as default. - includes/DefineCartClass.php : in "remove_from_cart()", added functionality to help clear outstanding Sales Orders - includes/DefineSerialItems.php : removed validation check and moved to Add_SerialItems.php - DeliveryDetails.php : removed high-ascii char @ Ln124 - footer.inc : Ln24: make chosen time format display, Ln34 : make © always be current year - GLTrialBalance.php : ~Ln60: make the From & To periods select something near where we are at in time - GoodsReceived.php : Better handling on Serial vs Controlled items when updating/inserting - GoodsReceivedControlled.php : $LocationOut should be set to the PO Location - index.php : Added Link for StockSerialItemResearch.php - includes/InputSerialItems.php : Quoted some Hidden Inputs, added a few onClicks() to make navigation easier, added a missing , and removed redundant code. - includes/InputSerialItemsFile.php : Improved file handling, fixed display problems when it had to exit() - includes/MiscFunctions.php : added pre_var_dump() function - very handy for in-page debugging, especially of array/objects - OrderDetails.php : added code to look for Invoices for an order and create links to the Printed PDF version of it - includes/PDFAgedDebtorsPageHeader.inc : additions to allow printing of AgedDebtors for a single Sales Person - POItems.php : + moved header include - it would break if you hit the page with no PO in session + added code to allow PO_AllowSameItemMultipleTimes to work + added extra link back to PO_Header + when no Image, changed "n/a" to "No Image" so it can be translated - PO_PDFPurchOrder.php + Added ability to print the PO with or without prices listed - reportwriter/admin/RCFunctions.php: Ln610: fixed MIME type check on file so ImportReport would work - reportwriter/ReportMaker.php : Ln382: defaulted "To" value to "From" value for ranges so a range can more easily cover a single entity like an Order # or PO# w/ details - reportwriter/forms/ReportsList.html : added padding to list to make it look nicer - SelectCompletedOrder.php : Allow search by Customer Reference - SelectCreditItems.php : + Ln284: frist -> first , + Ln441,596: getting real strict on checking equalities, even after all the strtouppers. + Ln472,626: basically same reason as 441 + Ln968: fix to stop reports of missing images in webserver error logs - SelectOrderItems.php + Ln123: Set the Order # since we have it + Ln201: add back in comment and standard(?) formatting + Ln295: Allow the CustCode search to check BranchCode too + Ln512: extra space in " name" + Ln832: error moved into DefineCartClass.php + Lns986 - 1029 : add options to show previous quantities delivered and links to delete/clear the line as needed (in conjunction w/ DefineCartClass.php above too) + Ln1131: fix to stop reports of missing images in webserver error logs - includes/SelectOrderItems_IntoCart.inc + Around Ln75, if it was an existing order, the 2nd SQL call would overwrite the $myrow var and cause problems later. Renamed the out $myrow to $myItemRow + Ln113: removed duplicate "CreditAvailable -=" statement and another high-ascii A - StockCounts.php : Added code to allow entered counts to be more easily viewed and removed. - StockSerialItemResearch.php : refinements. Allow fuzzy searching (sql LIKE), display the SN b/c of that, and correct the SQL used to pull records (would display dupes when same SN had been in more than 1 warehouse) + sql/mysql/upgrade3.04-3.05.sql : put Ln319 - 324 in more natural order and added col names for config inserts + UserSettings.php : italics on the password message, made the email field display larger + reportwriter/WriteReport.inc : quotes filename in CVS download so files w/ spaces in name will work - Several DB_escapes_string()s + ConfirmDispatch_Invoice.php, CustomerReceipt.php, StockAdjustments.php - Several trim()s & strtoupper()s on StockIds, Order #, PO #, & various Search Parameters + BOMInquiry.php, includes/DefineCartClass.php, DiscountCategories.php, GetStockImage.php, POItems.php, PO_SelectOSPurchOrder.php, PrintCustTrans.php, SelectCreditItems.php, SelectCustomers.php + SelectOrderItems.php, SelectProduct.php, SelectSalesOrder, StockAdjustments.php, StockCostUpdate.php, StockLockStatus.php, StockReorderLevel.php, StockSerialItems.php, StockTransfers.php + StockUsageGraph.php, WhereUsedInquiry.php - Spacing + CustomerAllocations.php, includes/PO_ReadOrderIn.php, StockAdjustments.php + sql/pg/upgrade3.04-3.05.psql (Ln322),
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 24/1/05 "Ori Solomon" 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 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
Version 2.5
27 October 2003
Purely for marketing purposes and reflecting the fact that the system is becoming mature. Version numbering changed to lose the 0. before 2.5
Version 0.2.4
1st October 2003
Version 0.2.3
13th September 2003
Version 0.2.2
10th September 2003