[Web-erp-users] Version 0.2.0 - First known live installation

[Phil D. <ph...@du...>]

This is the first version that is known to be operational in a live 
environment and necessarily very largely stable.

There are numerous enhancements and a few bug fixes following implementation 
in a $11m AUD company. The database started off at 16 Meg - which was largely 
made up of 4 years sales analysis history. But also 1600 customers and 2500 
branches against these customers. The system is stable and fast on a Duron 
1300 with RAID level 1 on 2 SCSI 10krpm disks 512Meg RAM. 

User reaction has been most favourable compared to the system they were using 
(AccPac) which had become slow and unreliable. The company was averaging 2 
reboots per week on an NT small business server !! ( A 2.4GigHz P4 - 1Gig 
RAM)  Some sales analysis reports were taking close to an hour to run, on 
web-erp - with 2 years more data than AccPac had - this is now taking only 6 
seconds.

It is early days to judge reliability but performance is breathtaking by 
comparison to what they were used to.

Invoices and statements are now creating pdf files using the R&OS 
pdf-php.class which avoids the lisencing issues associated with pdflib. 
pdflib will be phased out as the other scripts are all modified to suit R&OS 
pdf-php.class. The class is included in the distribution (and the helvetica 
fonts) which account for the growth of the archive. Also the MimeMail class 
by Richard Hedges is also included in the distribution for automating the 
mailing of created pdf reports. This class extends php to allow attachment of 
files to mails created.

The change log since version 0.1.10 follows:

P>(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.
<P>(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.
<P>(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.
<P>(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.
<P>(Phil)New field in CustBranch DefaultShipVia that gets updated at the time 
of invoicing (ConfirmDispatch_Invoice.php) if it was modified in an order.
<P>(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
<P>(Phil)Customers.php modified to show AddrInvBranch option
<P>(Phil)Payments.php now retains the bank account from which the amount is 
being paid.
<P>(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.
<P>(Phil)Made select customer select a branch names and codes rather than a 
charge account DebtorNo code.
<P>(Phil)Stopped order lines from being changed to 0 quantity
<P>(Phil)SelectOrderItems.php excludes branches with DiableTrans=1
<P>(Phil)SelectCreditItems.php excludes branches with DiableTrans=1
<P>(Phil)CustomerBranches.php modified to show the new fields for 
DisableTrans, PostAddr1 - 4.
<P>(Phil)GetSalesTransGLCodes.php fixed bugs was not returning codes correctly 
always using 1
<P>(Phil)CustomerAllocations.php and SupplierAllocations.php made a rounding 
tolerance of 0.005 for allocations to be accepted.
<P>(Phil)Fixed bug in SuppPaymentRun.php to only print/process suppliers with 
an amount owing - it was picking up suppliers with debit balances ;(
<P>(Phil)Changed SupplierInquiry.php to retain date from when invoice is held 
or released.
<P>(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.
<P>(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.
<P>(Phil)ConfirmDispatch_invoice.php now has link to new order entry
<P>(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
<P>(Phil)SupplierInquiry.php made the invoices already paid incapable of 
changing status to held when already settled
<P>(Phil)SuppTransGLAnalysis.php made general ledger account select box show 
account code and in account code order
<P>(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.
<P>(Phil)Added DisableTrans on CustBranch table to disable a branch from being 
invoiced or credited to
<P>(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.
<P>(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.
<P>(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.
<P>(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
<P>(Phil) Fixed bug in PDFBankingSummary.php now shows bank account name and 
account number.
<P>(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.
<P>(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.
<P>(Phil) Modified ConfirmDispatch_Invoice.php back to remove selection of 
freight company.
<P>(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.
<P>(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.
<P>(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.
<P>(Phil) Fixed login page in header.inc to test for AccessLevel=="" and check 
for existence of SecurityGroups being an array as it should be.
<P>(Phil) Deleted redundant fonts from the distribution only using helvetica
<P>(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.
<P>(Phil) PrintCustStatements.php and PDFStatementPageHeader.inc now uses R & 
OS class.pdf.php class for creation of pdf statements.

Any feedback - bad or good - always appreciated.

Phil