[WebERP-developers] Fwd: Re: Performance 4.11.3

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

Hi Bob,

Yes, I thought of that and figured that the audit trail maintenance 
really a part of the DB maintenance routine, so I've moved it inside 
that section. Now session.inc has been carved up and the DB checks, 
GetConfig, the exchange rate stuff has all been put into the user login 
script and is only ever checked on login. Previously it was trying to 
purge every page which was  a bit silly as your experience highlighted. 
I've also added an index to transactiondate as the query should not take 
that long and it was a mistake to query on transactiondate without 
having an index to play with.

The shipment default quantity to the balance of the order could be a 
useful addition (I am not sold on it though - I expect most would be 
happy for it to default the balance of the order) - just needs someone 
to code it - not much to it really.

I am keen to have a look at scripts where we could alter the default 
locations. There have been some changes here recently with Ricard's new 
field in locations which flags if the location should be available as a 
factory to make stuff or no. Would the user's default location not be 
the normal default? We need to be specific about the scripts that need work.

Great feedback as always - thanks Bob.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 20/09/14 01:48, Robert Thomas wrote:
>
> Tim, Gilberto and Phil,
>
> Thank you for your help in solving our performance problem.  I and our 
> users are very happy with the system’s performance.
>
> This performance issue was evident on my system due to its slow 
> response handling a “large” audit trail.  Such could potentially 
> become a problem for other users.  Could all of the system maintenance 
> type functions be removed from session,inc and placed where it is only 
> executed once, possibly on login?
>
> We make a significant number of edits to the sources every time a new 
> version of WebERP is released.  Some of these changes involve 
> customization of forms, e.g. quotation, invoice, packing slips, 
> checks, etc. that are specific to our business.  Others involve 
> corrections or enhancements to WebERP that are applicable to all 
> systems (I can make the changes to the code and submit but would 
> prefer to have such moderated):
>
> ·We rarely ship/invoice complete orders.  The current shipping/invoice 
> function defaults to shipping the total order quantity.  A customer 
> order typically has 20 to over 100 different items all with unique 
> quantities.  Exson very kindly provided simple changes to 
> DefineCartClass.php:
>
> Around line 490 change:
>
>                                 if ($Controlled==1){
>
> $this->QtyDispatched = 0;
>
> } else {
>
> $this->QtyDispatched = $Qty - $QtyInvoiced;
>
> }
>
> To:
>
> $this->QtyDispatched = 0;
>
> We expect that other organizations would find this change in the 
> invoice function useful.  Would it be possible to add:
>
> Invoice quantity default to be quantity outstanding [Y/N] (default Y – 
> current WebERP default)
>
> To the system parameters and then check the appropriate $_Session[‘…’] 
> variable in DefineCartClass.php?
>
> ·Location defaults.  In general the tests for location are not working 
> properly and the first location in alphabetical order is displayed as 
> the default location.  We have a number of locations: Ltron, MRB, 
> NorwH, RMA, Star, …  I have posted our changes for these defaults on 
> the WebERP nabble board.
>
> For our business, the default location to issue stock to a work order 
> should be the location of the work order. Unless context suggests a 
> different default, the location should default to the default 
> manufacturing location as set in the system parameters.  An example of 
> how such can cause a problem, one of our people in the shop had the 
> default displayed as the first location, Ltron, by mistake selected 
> MRB (Material Review Board), instead of NorwH (default manufacturing 
> location and where the inventory was stored).  If NorwH, the work 
> order location, had been defaulted such an error would not have 
> occurred.  The “missing” material caused a customer shipment to be late.
>
> MRB and RMA are new locations.  MRB (Material Review Board) is where 
> suspected defective material from vendors and manufacturing is stored 
> and addressed.  RMA is where returned customer items are stored and 
> handled.
>
> Sincerely,
>
> Robert F. Thomas
>
> *cid:image001.gif@01C71ABB.312C1E90*
>
> 44 Industrial Way
> Norwood, MA USA 02062
> (Office Phone - (781) 329-9200
> *mail to: rf...@as...
>
>