webERP Change Log

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 with

all hard coded odd and even line colours now use a and a from the theme's css - various scripts now have fields highlighted showing the field where and input error was detected - stocks.php suppliers.php, customers.php etc.

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 fixed CompanyPreferences.php had exchange diff account field twice!

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

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

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

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

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

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

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

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

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

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

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

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

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

Version 2.9b

23rd December 2004

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

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

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

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

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

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

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

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

8/11/04 Steve - SelectCustomer.php gettextified

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

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

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

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

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

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

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

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

Version 2.9a - Mk II

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

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

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

Version 2.9a - Mk I

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

12/9/04 SuppliersAtPeriodEnd.php gettextified

12/9/04 Hani - DebtorsAtPeriodEnd.php gettextified

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

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

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

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

8/9/04 Areas.php gettextified

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Version 2.9

17th July 2004

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

17/5/04 StockMoves remove field BundleID

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Version 2.8

26 February 2004

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

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

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

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

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

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

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

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

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

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

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

15/2/04 CustomerInquiry icons reduced in size.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

28/1/04 Could not modify currencies - fixed

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

Version 2.7

14 January 2004

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Version 2.6

15 December 2003

14/12/03 Significant updates to the manual

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

Version 0.2.4 1st October 2003

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

Version 0.2.3 13th September 2003

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

Version 0.2.2 10th September 2003

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

Phil 10/9/03 Tidy up BOMInquiry.php

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Version 0.2.0 26th July 2003

(Phil)PDFOrderPageHeader.inc and PrintCustOrder.php now refer to the pre-printed stationery versions. These will have to be modified to suit the client. A packing slip format that is headed up is included in the distribution called PDFOrderPageHeader_generic.inc and PrintCustOrder_generic.php - may be better to have another link to this from the order.

(Phil)CostUpdate.php now allows definition of two page security variables one that allows costs to be viewed and another that allows modifications to costs.

(Phil)Prices.php now allows definition of two page security variables one that allows prices to be viewed and another that allows modifications to prices.

(Phil)PO_OrderItems.php now has a button to lookup the purchase price of an item from the purchasing data this was automatic from the part search but where a code was entered directly, there was no lookup.

(Phil)New field in CustBranch DefaultShipVia that gets updated at the time of invoicing (ConfirmDispatch_Invoice.php) if it was modified in an order.

(Phil)PrintCustTrans.php and PDFTransPageHeader.inc modified to print the branch postal address instead of the head office address where the flag InvAddrBranch is set to 1

(Phil)Customers.php modified to show AddrInvBranch option

(Phil)Payments.php now retains the bank account from which the amount is being paid.

(Phil)Fixed bug in SelectCompletedOrders.php was not showing the delivery dates and qty delivered due to earlier changes to the DefineCartClass.inc calls to additem now given correct params.

(Phil)Made select customer select a branch names and codes rather than a charge account DebtorNo code.

(Phil)Stopped order lines from being changed to 0 quantity

(Phil)SelectOrderItems.php excludes branches with DiableTrans=1

(Phil)SelectCreditItems.php excludes branches with DiableTrans=1

(Phil)CustomerBranches.php modified to show the new fields for DisableTrans, PostAddr1 - 4.

(Phil)GetSalesTransGLCodes.php fixed bugs was not returning codes correctly always using 1

(Phil)CustomerAllocations.php and SupplierAllocations.php made a rounding tolerance of 0.005 for allocations to be accepted.

(Phil)Fixed bug in SuppPaymentRun.php to only print/process suppliers with an amount owing - it was picking up suppliers with debit balances ;(

(Phil)Changed SupplierInquiry.php to retain date from when invoice is held or released.

(Phil)Changed SelectOrderItems.php (again :( ) to avoid showing the last quick entry item as selected. unset($_GET["Edit"]) at the end of the quick entry code.

(Phil)Fixed bugs in SupplierInvoice.php and SupplierCredit.php that crashed the entry if the tax method was changed without a manual entry being applied new button to change tax calculation method.

(Phil)ConfirmDispatch_invoice.php now has link to new order entry

(Phil)CustomerAllocations.php fixed a bug that was number_format ing an already previously number_format ed field to display 1 where number_format had inserted a comma - ie where the figure for yet to allocate was > 999 the system displayed 1

(Phil)SupplierInquiry.php made the invoices already paid incapable of changing status to held when already settled

(Phil)SuppTransGLAnalysis.php made general ledger account select box show account code and in account code order

(Phil)Made SelectOrderItems.php search only branches - a branch is required to invoice/credit it makes sense to select the branch rather than the customer and then the branch. The customer is implicit in the branch selection. Also use flag DisableTrans to ensure that only those current branches are allowed invoicing.

(Phil)Added DisableTrans on CustBranch table to disable a branch from being invoiced or credited to

(Phil)Added a new field AddrInvBranch to DebtorsMaster to enable invoices to be addressed to the branch postal address. To cover the situation where branch invoices must be sent to the branch not the charged customer.

(Phil)Fixed OrderItems.php to show menu for navigation - sorry Sherif! Also, now centres order comments below. Invoice numbers used to invoice the order are appended to the comments from ConfirmDispatch_Invoice.php.

(Phil)Fixed bugs in SelectSalesOrder.php was not using $_POST variables for SearchParts also was only searching parts with a sales order - need to show all parts then return orders for that part - no orders returned if no orders for the part selected.

(Phil) SelectOrderItems.php now uses LIMIT as per SelectProduct.php to limit the number of parts returned on as per the config directive $Maximum_Number_Of_Parts_To_Show

(Phil) Fixed bug in PDFBankingSummary.php now shows bank account name and account number.

(Phil) Modified - SelectProduct.php to have an 'All' stock categories search to find an item where the user may not know what category its in or user doesn't need to enter the category cos she knows the code.

(Phil) Modified - the PrintCustOrder.php and PDFOrderPageHeader.inc to use php-pdf class and default for pre-printed stationery. Pre-printed 2 part stationery is necessary to record notes of storemen. This will require modification for the client's own stationery. Copied the labelled up scripts to PrintCustOrder_generic.php and PDFOrderPageHeader.inc these still require PDFlib installed on the server.

(Phil) Modified ConfirmDispatch_Invoice.php back to remove selection of freight company.

(Phil) Modified delivery details to allow selection of a freight company and to allow entry of a freight cost to charge - which can be either calculated by the system or entered manually.

(Phil) Made new directive in config.php $DefaultPriceList this is used if the price cannot be determined first by reference to the customers salestype and currency.

(Phil) Modifications to SelectOrderItems.php GetPrice function to use the $DefaultPriceList if fails using the customer salestype/price list. This minimises input in other sales type prices to only those prices which are special to the customer.

(Phil) Fixed login page in header.inc to test for AccessLevel=="" and check for existence of SecurityGroups being an array as it should be.

(Phil) Deleted redundant fonts from the distribution only using helvetica

(Phil) PrintCustTrans.php corrections to format of InvText printing and select box for Credit Notes or Invoices to allow correct parameter to be sent for printing a credit note - was not showing charge branch.

(Phil) PrintCustStatements.php and PDFStatementPageHeader.inc now uses R & OS class.pdf.php class for creation of pdf statements.

Version 0.1.10 6 July 2003

(phil) modified PrintCustTrans.php and PDFTransPageHeader.inc to use the R&OS class.pdf.php requires new file PDFStarter_ros.inc

(Phil) config.php deleted DefaultFont - now in Sherif's style-sheet.

(Phil) moved $ModuleList array of module descriptions to config.php now used in WWW_Users for defining access as well as index.php

(Phil) WWW_Users.php modified to allow modules shown on a users menu to be defined and modified.

(Phil) WWW_Users table addded ModulesAllowed char(20) to hold a comma seperated list of modules allowed to access defined in the same order as $ModuleList array

(Phil) config.php now has a $version variable also referred to in header.inc

(Phil) Added scripts class.pdf.php for the pdf-php class by R & OS http://www.ros.co.nz/pdf - this will allow pdf creation without pdflib module compiled or enabled in php. PDF report scripts are yet to be modified. The /fonts directory contains the fonts distributed with the class.

(Sherif) New AutoStocks.php - allows automated adding of a range inventory items. under development.

(Sherif) New lang folder to contain localizable language string files. (contains en.inc so far) for future development

(Sherif) ConfirmDispatch_Invoice.php - freight calculations only on $DoFreightCalc flag. (Phil) Also added field to select freight company (shipper) manually.

(Sherif) CustomerInquiry.php - display InvText, HTML cleanup of table header

(Sherif) CustomerTransInquiry.php - display InvText, HTML cleanup of table header

(Sherif) DefineCartClass.php - add storing of $FreightCost (see SelectOrderItems.php)

(Sherif) DeliveryDetails.php - add missing fields that weren't being saved/loaded, freight cals only on $DoFreightCalc flag

(Sherif) HeaderTitle.inc - add option to hide menu (useful when previwing orders/invoices/recepits,etc)

(Sherif) index.php - Initial module enabling/disabling - not yet used another field in the user set up should determine the modules available. Also added link to AutoStocks.php disabled as an incomplete feature currently.

(Sherif) OrderDetails.php - hide menu on display of this page

(Sherif) PDFOrderPageHeader.inc - misc arrangement

(Sherif) PDFStatementPageHeader.inc - misc arrangement

(Sherif) PDFTransPageHeader.inc - misc arrangement, rename "A.B.N Number" to "Tax Authority"

(Sherif) PDFTransPageHeader_A4_Portrait.inc - rename "A.B.N Number" to "Tax Authority"

(Sherif) PO_Header.php - HTML cleanup, use tableheader style

(Sherif) PO_Items.php - disable shipment calculation and display on incomplete features flag

(Sherif) PO_PDFOrderPageHeader.inc - add viewing-only mark - was not merged last time i think.

(Sherif) PrintCustTrans.php - get and display DelAdd4, rename "A.B.N Number" to "Tax Authority", "GST" to "Tax"

(Sherif) PrintCustTrans_A4_Portrait.php - rename "A.B.N Number" to "Tax Authority"

(Sherif) SelectCompletedOrder.php - HTML cleanup, use tableheader style

(Sherif) SelectCreditItems.php - open preview in a new window

(Sherif) SelectOrderItems.php - store $FreightCost in session with other vars, HTML cleanup,

(Sherif) SelectProduct.php - hiding of commands for dummy items, use tableheader style in table

(Sherif) SelectSupplier.php - get Address4 for Suppliers, use tableheader style in table

(Sherif) StockCostUpdate.php - add saving of LastCost in StockMaster

(Sherif) StockMovements.php - HTML cleanup, use tableheader style, open preview/print in new window

(Sherif) StockStatus.php - HTML cleanup, use tableheader style

(Sherif) StockUsage.php - HTML cleanup, use tableheader style

(Sherif) SupplierInvoice.php - hide 'Enter Against Shipment' button for incomplete features flag

(Sherif) web-erp.css - add tableheader class to standardize table headers

Version 0.1.9 30 June 2003

PrintCustTrans.php and PDFTransPageHeader.inc (phil) credit note printing printed branch in middle of company details. Wasn't printing at all on re-print - now fixed.

ConfirmDispatch_Invoice.php (Sherif) HTML cleanup

Prices.php (Sherif) HTML cleanup

Credit_Invoice.php (Sherif) HTML cleanup

DeliveryDetails.php (Sherif) HTML cleanup

SelectCreditItems.php (Sherif) HTML cleanup, edit percentage as 0-100 not 0.0-1.0 (phil) fixed bug caused by additional parameters required for add_items which uses the same Cart class as SelectOrderItems.php following changes to the class required to highlight lines on order with quantity greater than stock (phil)

SelectCustomer.php (Sherif) HTML cleanup

Added new script PO_SelectCompletedPurchOrder.php to show completed purchase order details (Sherif)

Added new script Currencies.php to enter or amend currencies and rates (Sherif)

Added web-erp.css (Sherif)

BOMs.php (Sherif) HTML cleanup, moved table display to function

CustomerInquiry.php (Sherif) remove hard-coded date string

Credit_Invoice.php (Sherif) remove hard-coded date string and display the tax rate

SelectOrderItems.php (Sherif) removed ability to select a customer without a branch, entry of discounts now 0-100 not 0-1 as before.

SelectSalesOrder.php (Sherif) HTML cleanup

ConfirmDispatch_Invoice.php (Sherif) print invoice opens a new window. HTML cleanup of unused FONT tags and fix recalculation of tax on update. (phil) Fix GL trans created in functional currency not customer currency as before

BOMs.php (Sherif) changed text from "effective from" to "effective after"

PDFBOMListingPageHeader.inc (Sherif) effective from -> effective after

DeliveryDetails.php (Sherif) print sales order in a separate window

PO_Items.php (Sherif) HTML cleanup of table headers, fix for deleting items

SupplierInvoice.php (Sherif) HTML cleanup - make table headers as strings, display tax rate and authority

SuppInvGRNs.php (Sherif) HTML cleanup, put table headers in strings

header.inc $allow_demo_mode to display demo login or not depending on setting in config.php. Also, use a template and make a little prettier :)

config.php (Sherif) added $allow_demo_mode to display demo login or not, also added $OverReceiveProportion used in receiving purchase orders.

GoodsReceived.php (Sherif) added check $OverReceiveProportion to control receipt of quantities larger than on a purchase order

StockUsage.php (Sherif) no stock usage for dummy, assembly or kitset items

SelectProduct.php (phil) modified to disable the link to allow stock usage or stock status inquiries for dummy, kitset or assemblies (Sherif) HTML cleanup added link to PO_SelectCompletedPurchOrder.php

SelectSalesOrder.php (Sherif) print sales order opens a new window

PO_Header.php (Sherif) UI fix

PO_Items.php (Sherif) cleaner way of deleting items to fix bugs in editing after creating order.

CustomerBranches.php (Sherif) Check if there are any users that refer to this branch code before delete

Customers.php (Sherif) change discounts to be entered as real percent 0-100 instead of 0.0-1.0

DefinePOClass.php (Sherif) on delete of items, mark as deleted don't remove so we can compare later for changes

DefineSuppTransClass.php (Sherif) fixed Shipment constructor name

Payments.php (Sherif) for supplier payments, link back to same supplier to avoid re-selecting supplier code (phil) show GL account code in select box, check valid GL code for Bank accounts available for selection.

PO_PDFOrderPageHeader.inc (Sherif) add viewing-only mode misc re-arrangements for obstructing objects

PO_PDFPurchOrder.php (Sherif) add mode to "view only". for completed purchase orders.

StockCostUpdate.php (Sherif) check whether the selected stock id actually exists before action

StockMovements.php (Sherif) HTML cleanup

Stocks.php (Sherif) $hide_incomplete_features for Controlled field

SupplierCredit.php (Sherif) HTML cleanup, use $DefaultDateFormat for date display, syntax fixes for Shipments (phil) change to buttons for links to gl analysis, shipment entry and entry vs GRNs to avoid additional update step to store entries made in this screen to session.

SupplierInquiry.php (Sherif) added display of transaction description

SuppShiptChgs.php (Sherif) syntax fix

SuppCreditGRNs.php (Sherif) HTML cleanup - Currency on new line

ShiptsList.php (Sherif) fix table string display - was shifted one column (phil) changed to set $PageSecurity before header.inc included.

CompanyPreferences.php (Sherif) syntax fix in UPDATE sql clause missed closing quote.

index.php (Sherif) add link to the new currencies page, HTML cleanup of bad FONT codes, changed to black category text for better contrast, added link to query completed purchase orders.

Logout.php (Sherif) add company name, logo and link back to login

PO_SelectPurchOrder.php print opens in a separate window

Prices.php HTML cleanup - changed heading to Currency prices for item code.

SelectCustomer.php (Sherif) HTML cleanup - bigger font for customer name and code, changed text of link to modify sales orders - implicit that only outstanding orders can be modified!

SelectSupplier.php (Sherif) Display the supplier name as well as the code

StockAdjustments.php (Sherif) check that the stock item exists before action and link to stock movements on new line

StockReorderLevel.php (Sherif) HTML cleanup - put item code and description on a new line

StockStatus.php (Sherif) HTML cleanup - removed unecessary tags

StockTransfers.php (Sherif) Check that the stock item is valid before action

TaxAuthorities.php (Sherif) check if there are suppliers using this tax authority before delete

SelectOrderItems.php (Phil) now shows order lines where there is insufficient stock on hand at the location in red. Also modified price logic into a seperate function that gets the price specific to the customer if set up otherwise returns the defualt price for the sales type and currency of the customer otherwise 0.

GLTrialBalance.php (Phil) now shows a link to the account inquiry page for the last period in the range selected

WWW_Users.php (Phil) now checks that the customer code and branch code are valid before accepting the user details input

GLTrialBalance.php (Phil) now shows subtotals by account group.

CustomerReceipt.php (Phil) now checks for a valid GL account on bank account as Payments.php - also now shows account number in select box when entering a gl receipt.

Payments.php (Phil) now checks to see that the bank account has a valid GL account defined for it. It was possible to enter payments to a non-existant GL account! Also, account code shows in select box for gl code.

Payments.php (Phil) ensure that the company default currency is selected by default

CustomerReceipt.php (Phil) check to see that there are entries in the receipt batch before processing

header.inc (Phil) checked for AccessLevel==0 no longer appropriate sends user back to login screen - access level inquiries only

Version 0.1.8 22 June 2003

MailInventoryReport.php script similar to MailSalesReport.php to enable automated email of inventory report

MailSalesReport.php script added - largely a copy of SaleAnalysis_UserDefined.php. This new script runs a user defined sales analysis report and mails it to an email account. This script has no PageSecurity nor any output - it creates a file then emails it as an attachement to the address(es) specified in the script. It is meant to be run from cron using wget to email a sales report periodically to staff concerned.

GetSalesTransGLCodes.inc now looks for SalesType, Area match for finding a GL code match before using the default.

SelectProduct.php - added a transactions column to the actions applicable on selection of an item with links to perform stock adjustments or stock location transfers.

PO_Header.php - changed the link to the line items to be a button that diverts to the PO_Items.php only after updating the session variables for changes in the form data. Needs META refresh in the browser - most have this

SupplierInvoice.php - changed links to enter invoice amounts against goods received, against shipments and against gl to buttons and made the page redirect after updating the session variables with the posted data in the form. Changes could be lost without hitting update. This method avoids the need for the update button - which has now gone.

SupplierCredit.php was not using the default date format for transaction dates.

Stocks.php check for stock on hand when changing to assembly or kitset or dummy. Also check for sales orders or purchase orders when changing to assembly kitset or dummy. Also check for BOM when changing to buy or dummy.

SQL_CommonFunctions.php GetCompanyRecord function excluding the fields now removed from this table.

CompanyPreference.php reflecting the changes in the companies table below

Companies table modified - removed default bank account and bank act number field from companies table. Multiple bank accounts can now be defined seperately.

Companies table modified removed credit check flag - always checked now

Companies table modified removed check stock flag

Modified all scripts to have the variable $PageSecurity also config.php to allow definition of security by user group this mechanism allows for much finer control of who has access to what.

Modified GLTrialBalance.php to retain periods selected as a starting point for when entering a new period range

Modified Stocks.php to always convert stock codes to upper case.

SelectOrderItems.php - orders for kitset items that explode the BOM into its components to order were doubling in quantity for each component in the BOM - now fixed.

SelectOrderItems.php - selection of parts to order would not show assembly parts since no stock location records for these parts - no stock is maintained for them. No longer show stock on hand in the location nearest the customer in the part search.

Shippers.php fixed to allow editing of shippers - link was malformed.

GLJournal.php modified to retain processing date after an entry is deleted.

New script Z_RePostGLFromPeriod.php reposts all GLTrans from a selected period.

New format invoice A4 landscape PDF.

New script GLAccountInquiry.php called from SelectGLAccount.php allows listing of the transactions for a specified account. The transaction type and number shows with a link to the detail of the individual transaction ie "drill down" to the lowest level of the transaction.

New script InventoryPlanning.php allows listing of the current stock status, QOH, Purchase orders outstanding and sales orders outstanding together with the recent history of stock movements and suggests an order quantity based on a number of periods stock to hold.

Logout link shown on header destroys any session data - a user requested this function - can't see why it is necessary but hey!

New script BOMListing.php allows listing of bills of material defined for a specified range of items.

New script InventoryValuation.php allows listing stock items with a quantity !=0 by location and stock category.

Stocks.php after updating an item the user is returned to a new select item screen (SelectProduct.php?NewSearch=True)

SalesPeople.php - checked so that cannot have zero length salesperson code.

Dropped redundant tables Hedges, TempMRP, StandingJournals (standing journals can be created live at any time since user can post forward and backwards at will).

Version 0.1.7 May 16 2003

Costed BOM inquiry script - thanks Al Adcock.

Modified Customers.php to always convert customer codes to upper case.

Modified CustomerBranches.php to always convert branch codes to upper case.

Modified StockCategories.php to always convert stock category codes to upper case.

Modified Areas.php to always convert area codes to upper case.

Modified PrintStatments.php to always convert customer from code and customer to codes to upper case.

Modified SelectCustomer.php to always convert entries in either keywords or customer code extract to upper case.

Modified SelectOrderItems.php to always convert search entries in either keywords or customer code extracts to upper case.

MOdified SelectSupplier.php to always convert entries in either keywords or supplier code extract to upper case.

Modified Suppliers.php to always convert the supplier code to upper case.

Modified SalesTypes.php to always convert the sales type code to upper case.

Modified SalesPeople.php to always convert the salesperson code to upper case.

Modified SelectProduct.php to always convert the keywords or product code extract to upper case.

Modified Locations.php to clear form variables for adding new locations and after updates to existing locations being modified. Made location codes always upper case.

Some prawn changed the access rights of demonstration user so that one could only get into the order entry and account status screens. Made an admin user that has the rights to add or delete new users - prohibiting such destructive folks from malicious tricks in the sourceforge demo system.

Modified SelectOrderItems.php to place the cancel whole order button away from the main entry - field testing showed that it was too easy to delete the order by hitting enter when the focus was on this button.

New script to print bank reconciliation based on current gl balance of the bank account, showing bank payments not yet presented and deposits not yet cleared to arrive at a calculated bank statement balance. Links back to matching receipts and matching payments script. Also new link on index.php under GL inquiries.

Added a link in index.php to allow re-prints of deposit listings produced from entry of receipts.

New script for matching deposits and payments against bank statements, for the purposes of reconciling to bank statements. The script does double duty for matching deposits and payments, but must be called with either Receipts or Payments. Added appropriate links to this script in index.php one for Deposits matching and one for Payment Matching.

Bug fix to GLTrialBalance.php the DefaultPeriodTo was not picking up the last defined period less one as was intended.

Dropped the tables ClearedPayments and ClearedReceipts - amount cleared against banktrans now recorded inside the one banktrans table

General Ledger Journal entry form created. New journal class defintion to hold the transaction before committing to the DB. Reversing journals entered on same form by changing journal type to reversing, default is normal. Prohibited journal entries directly to bank accounts since no banktrans record would be created for matching off statements. Bank gl transactions must be entered as either a payment or a receipt.

Removed facility to be able to modify the cost data for the part in the inventory item maintenance form since this did not create the necessary GL journal if integrated stock journals are active. Cost changes must be effected through the dedicated form for this purpose.

Entry of a payment to a general ledger act already defined as a bank account (be it a different bank account or the same bank account as the payment is from) now creates the necessary banktrans record for the receipt into the other (or same) bank account.

Entry of a receipt to a general ledger act defined as a bank account now creates the necessary banktrans record for the payment from the other bank account as above.

Version 0.1.6 22 Mar 03

Fixed bug in SelectProduct.php script that overstated stock on hand.Sadly I couldn't figure a way to show the sales order demand and resolve this problem so the selection of parts no longer shows current sales order demand.

Additional error trapping to check that a stock location is not a default stock location for an existing customer branch before allowing deletion.Also, an additional error trap to check that the default_shipper in config.php cannot be deleted from the shipper maintenance form Further error trap to check that shipping companies that have debtortrans records (ie invoices created using them) cannot be deleted.

Version 0.1.5

User created with Access level less than or equal to 10 and with a customer code and branch code selected will be able to view only the account details for the customer code selected with invoice reprints - only for the customers transactions. Such users can also enter orders for the customer code and branch defined against them as well. This allows customers to be given access to the system to view only their own details.

Deleted PrintInvoice.php superseeded by PrintCustTrans.php which deals with credits and invoices

logicworks.ini file changed name and all references to in other files to config.php to avoid displaying sensitive info in the config file over the net ... duh! Thanks Ryan Fox!

Sales Types - field to say if the sales type updates stock or not has been removed. This was a carry over from some old logic that was superseeded.

It was possible to add a sales type with a blank sales type code - now corrected

Editing of a sales type was not possible - fixed.

Version 0.1.4

23 Feb 03

New page GLTrialBalance.php to show a trial balance with movements for a month and a period

GLPostings.inc to effect updates to ChartDetails for GLTrans created

New variable in config.php to define the company's year end

ConfirmDispatch_Invoice.php - changed date format of date of dispatch field to refer to the $DefaultDateFormat invoices commited with dates in US format became 00/00/0000. Now corrected.

ChartDetails table - BFwd and BFwdBudget fields created.

GLTrans table - removed reversal flag - reversing journals now create the reversal in the following period at the time of entry no flag is necessary since the open period system with no rollovers requires creation of reversals at the time. Also, dropped field ShiptRef - transactions now created in seperate tablef

Payment.php - was not unsetting the fields when a new GL analysis line was added to the payment.

Periods table - LastDateInPeriod field changed from DateTime to Date.

Version 0.1.3

1 Feb 03

Payments.php insert of BankTrans record now records Currency and TransNo and Type correctly.

Allocation of supplier payments and credits - creating GL entries and exchange diffs. Made SuppAllocs table mirror CustAllocs refering to the TransID rather than the Type and TransNo as previously. SupplierAllocations.php and links from SupplierInquiry.php

Changed DateFunctions.inc to use the global DefaultDateFormat variable in config.php to determine format of dates required. Changed demo default to US format 'm/d/Y'

SelectOrderItems.php can now select items with no prices set up for them - including kits Customer special prices now comes up as a seperate item in the search - the system will show the normal price part as well as the special price one. SelectProduct.php removed the link to special customer prices in the case of a kit set parts.

BOM.php - BOM Maintnenance - Effective dates were modified by the code to be in SQL format on submit and appeared corrupt on the next viewing. Fixed. Effective dates were not displayed in accordance with DefaultDateFormat - fixed. Now check to ensure components cannot be on the BOM more than once. Pass db handle by reference to check recursion function to eliminate errors.

BOM table modified EffectiveTo and EffectiveAfter to be Date fields not DateTime as was.

Shippers.php - Shipping company maintenance - deletion of shipping companies failed - fixed.

Prices.php - should not be able to enter prices against a kit since a kit is exploded into its components.

SelectProduct.php - dont show prices link for kitset products.

Modified PDF_TranPageHeader.inc to refer to YPos rather than hard code vertical coordinates for credit notes so that alternate paper sizes can be accomodated. Fixed invoices 20 Jan forgot credit notes.

Created SuppCreditGRNs.php - this page allows selection of goods received records for entering supplier credits against. Similar to the SuppInvGRNs.php but shows all goods received records after a specified date. The invoice entry page only shows goods received records that are yet to be fully invoiced. The credit note needs to show all goods received records.

Now have SupplierCredit.php working creating GL entries as appropriate and shipment charge records etc.

Version 0.1.2

20 Jan 03

Modified PDF_TranPageHeader.inc to refer to YPos rather than hard code vertical coordinates so that alternate paper sizes can be accomodated. (only fixed invoices - credit notes fixed 28th Jan 03)

Noted that pdf reports for Purchase orders did not print in Konqueror but worked fine in Netscape and Opera 6.1 No modifications - bug in Konqueror

SupplierInvoice.php - stopped the script trying to update shipment 0 even though no shipment defined.

WWW_Users table now has page size field varchar(20) was char(2) to allow proper description of page size. There was a mismatch between PDFStarter.inc switch statements and the stored values in WWW_Users table. Also modified WWW_Users.php to allow selection of other page sizes.

SelectProduct.php now checks for the existence of any stock categories before proceding and insists on some beng set up showing a link to the StockCategories.php script.

CustomerBranches.php: Check for existence of Sales Types, Sales Areas and Stock Locations before allowing input of branches with a null items in these fields.

SalesAnalReptCols.php: Bug in sales analysis column definitions BudgetOrActual field was used the opposite way in creating reports script SalesAnalysis_UserDefined.php. Modified the select box BudgetOrActual to be 1 for Budget and 0 for Actual (NOT budget). Also modified so that the returned 1 or 0 interpreted correctly on display of the column details from the printf statement.

Version 0.1.1

11 Jan 03

Release of initial file set warts and all.