web-erp-developers — Discussion on development of webERP

Re: [WebERP-developers] web shop

[webERP D. <web...@li...>]

Hi Phil:

I've played a bit with it and looks good. Just a few questions:
1) Are you planning to make it multi-currency? So customer can pick the
currency she is more comfortable with.
2) Stock in hand, could it consider the stock in several locations? This
parameter is used in Mo's cart and it's very useful. Kind of webshop if
loccode in ("loca", "locb", "locc", etc...).
3) Discounts. Will the shop show the items in discount with price before /
after discount? Or price - X%?

But, really, it's looking better tan I thought few months ago ;-)

Regards,
Ricard


2013/4/30 webERP Developers <web...@li...>

> **
>  I mentioned that I had been enjoying myself creating a web-shop
> integrated for webERP. There is still some way to go, but I have put up a
> partially working demo at
>
>  http://www.weberp.org/shop
>
>  login/checkout/payment all yet to complete... but enough to get a flavour
> of what I am up to.
>  The shop is configured in webERP at:
>  http://www.weberp.org/weberp/ShopParameters.php
>
>  I haven't committed this development yet ... until I have it all going.
>
>  I am thinking a small charge might be applicable for the web-shop - like
> my POS - so will probably not be open-source.
>
>  Phil
>
> Ph: +64 (0)275 567890
> Skype: daintree
> http://www.logicworks.co.nz
>
>
> ------------------------------------------------------------------------------
> Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
> Get 100% visibility into your production application - at no cost.
> Code-level diagnostics for performance bottlenecks with <2% overhead
> Download for free and get started troubleshooting in minutes.
> http://p.sf.net/sfu/appdyn_d2d_ap1
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] SMTP mail

[webERP D. <web...@li...>]

Of course it is only sense to make these modifications so we use the
functionality consistently across all scripts.
Thanks Exson :-)

On 30 April 2013 at 16:22 webERP Developers
<web...@li...> wrote:
> *Hi, Phil:*
>
> Thank you for your understanding!
>
> There are 16 scripts left now. If you agree to revise them, I'll
> revise them one by one within 2 weeks.
>
> Since android phone becomes more and more popular, and mails just
> like a message to help them know what's happening if they use gmail.
>
> And I believe that more mobile info are needed.
>
> Maybe we can set up a default smtp servers then the admin no
> bother to do it themselves?
>
> Thanks and best regards!
>
> Exson
>
>
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Re-Web-erp-svn-SF-net-SVN-web-erp-5863-trunk-sql-mysql-upgrade4-09-4-10-sql-tp4656326p4656336.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
> Get 100% visibility into your production application - at no cost.
> Code-level diagnostics for performance bottlenecks with <2% overhead
> Download for free and get started troubleshooting in minutes.
> http://p.sf.net/sfu/appdyn_d2d_ap1
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
Phil

Ph: +64 (0)275 567890
Skype: daintree
http://www.logicworks.co.nz

Re: [WebERP-developers] SMTP mail

[webERP D. <web...@li...>]

*Hi, Phil:*

           Thank you for your understanding!

           There are 16 scripts left now. If you agree to revise them, I'll
revise them one by one within 2 weeks.

           Since android phone becomes more and more popular, and mails just
like a message to help them know what's happening if they use gmail.

            And I believe that more mobile info are needed. 

            Maybe we can set up a default smtp servers then the admin no
bother to do it themselves?
             
            Thanks and best regards!

            Exson
      
            
           



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Re-Web-erp-svn-SF-net-SVN-web-erp-5863-trunk-sql-mysql-upgrade4-09-4-10-sql-tp4656326p4656336.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] web shop

[webERP D. <web...@li...>]

I mentioned that I had been enjoying myself creating a web-shop integrated for
webERP. There is still some way to go, but I have put up a partially working
demo at

http://www.weberp.org/shop

login/checkout/payment all yet to complete... but enough to get a flavour of
what I am up to.
The shop is configured in webERP at:
http://www.weberp.org/weberp/ShopParameters.php
<http://www.weberp.org/weberp/ShopParameters.php>

I haven't committed this development yet ... until I have it all going.

I am thinking a small charge might be applicable for the web-shop - like my POS
- so will probably not be open-source.

Phil

Ph: +64 (0)275 567890
Skype: daintree
http://www.logicworks.co.nz

[WebERP-developers] SMTP mail

[webERP D. <web...@li...>]

Hi Exson,

Yes I think I see .... instead of configuring the server properly, the settings
in webERP are pragmatically easier to administer. Makes sense to me.

There are actually many scripts that use the htmlMimeMail class that need to
have the send method parameters set to use the smtp option though still if this
change is to be effective though.

Phil

On 30 April 2013 at 15:44 webERP Developers
<web...@li...> wrote:
> *Hi, Phil:
> *
> I've been asked not less than 3 times from the users that how to
> set the smtp in webERP.
>
> Usually, those users will not host webERP in a virtual host, and
> some of them don't know how to config smtp in windows environment or Unix
> like environment --(I'm one of them too -:).
>
> It's more convenient for them to set the SMTP in the setup than
> to change the php.ini or to revise the smtp.php scripts themselves.
>
> Does that make sense?
>
> Exson
>
>
>
> web-ERP-developers mailing list wrote
> > Hi Exson,
> >
> > Interested in your work on this smtp transport option.
> >
> > Although we have had this smtp settings configuration form for a while. We
> > have
> > only ever sent one email I think using the htmlMimeMail class smtp
> > transport
> > option.
> >
> > I have never run into an issue with the normal php mail function - but
> > interested to understand when and why the new smtp option might be used?
> > On windows servers the php mail function can be set to use an external
> > smtp
> > server in any event in the php.ini
> >
> > Thanks
> >
> > Phil
> >
> >
> > On 30 April 2013 at 13:39 webERP Developers
> > &lt;
>
> > web-erp-developers@.sourceforge
>
> > &gt; wrote:
> >> *Hi, Richard:*
> >>
> >> Thank you for your comments. I'm wondering what I should do
> >> yesterday. It's a lazy idea. I'll correct it soon.
> >>
> >> Best regards!
> >>
> >> Exson
> >>
> >>
> >>
> >> --
> >> View this message in context:
> >> http://weberp-accounting.1478800.n4.nabble.com/Re-Web-erp-svn-SF-net-SVN-web-erp-5863-trunk-sql-mysql-upgrade4-09-4-10-sql-tp4656326p4656329.html
> >> Sent from the web-ERP-developers mailing list archive at Nabble.com.
> >>
> >> ------------------------------------------------------------------------------
> >> Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
> >> Get 100% visibility into your production application - at no cost.
> >> Code-level diagnostics for performance bottlenecks with <2% overhead
> >> Download for free and get started troubleshooting in minutes.
> >> http://p.sf.net/sfu/appdyn_d2d_ap1
> >> _______________________________________________
> >> Web-erp-developers mailing list
> >>
>
> > Web-erp-developers@.sourceforge
>
> >> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> > Phil
> >
> > Ph: +64 (0)275 567890
> > Skype: daintree
> > http://www.logicworks.co.nz
> > ------------------------------------------------------------------------------
> > Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
> > Get 100% visibility into your production application - at no cost.
> > Code-level diagnostics for performance bottlenecks with <2% overhead
> > Download for free and get started troubleshooting in minutes.
> > http://p.sf.net/sfu/appdyn_d2d_ap1
> > _______________________________________________
> > Web-erp-developers mailing list
>
> > Web-erp-developers@.sourceforge
>
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Re-Web-erp-svn-SF-net-SVN-web-erp-5863-trunk-sql-mysql-upgrade4-09-4-10-sql-tp4656326p4656333.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
> Get 100% visibility into your production application - at no cost.
> Code-level diagnostics for performance bottlenecks with <2% overhead
> Download for free and get started troubleshooting in minutes.
> http://p.sf.net/sfu/appdyn_d2d_ap1
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
Phil

Ph: +64 (0)275 567890
Skype: daintree
http://www.logicworks.co.nz

Re: [WebERP-developers] [Web-erp-svn] SF.net SVN: web-erp:[5863] trunk/sql/mysql/upgrade4.09-4.10.sql

[webERP D. <web...@li...>]

*Hi, Phil:
*
            I've been asked not less than 3 times from the users that how to
set the smtp in webERP.  

            Usually, those users will not host webERP in a virtual host, and
some of them don't know how to config smtp in windows environment or Unix
like environment --(I'm one of them too -:). 
           
            It's more convenient for them to set the SMTP in the setup than
to change the php.ini or to revise the smtp.php scripts themselves.
          
            Does that make sense?

            Exson



web-ERP-developers mailing list wrote
> Hi Exson,
> 
> Interested in your work on this smtp transport option.
> 
> Although we have had this smtp settings configuration form for a while. We
> have
> only ever sent one email I think using the htmlMimeMail class smtp
> transport
> option.
> 
> I have never run into an issue with the normal php mail function - but
> interested to understand when and why the new smtp option might be used?
> On windows servers the php mail function can be set to use an external
> smtp
> server in any event in the php.ini
> 
> Thanks
> 
> Phil
> 
> 
> On 30 April 2013 at 13:39 webERP Developers
> <

> web-erp-developers@.sourceforge

> > wrote:
>> *Hi, Richard:*
>>
>> Thank you for your comments. I'm wondering what I should do
>> yesterday. It's a lazy idea. I'll correct it soon.
>>
>> Best regards!
>>
>> Exson
>>
>>
>>
>> --
>> View this message in context:
>> http://weberp-accounting.1478800.n4.nabble.com/Re-Web-erp-svn-SF-net-SVN-web-erp-5863-trunk-sql-mysql-upgrade4-09-4-10-sql-tp4656326p4656329.html
>> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>>
>> ------------------------------------------------------------------------------
>> Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
>> Get 100% visibility into your production application - at no cost.
>> Code-level diagnostics for performance bottlenecks with <2% overhead
>> Download for free and get started troubleshooting in minutes.
>> http://p.sf.net/sfu/appdyn_d2d_ap1
>> _______________________________________________
>> Web-erp-developers mailing list
>> 

> Web-erp-developers@.sourceforge

>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> Phil
> 
> Ph: +64 (0)275 567890
> Skype: daintree
> http://www.logicworks.co.nz
> ------------------------------------------------------------------------------
> Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
> Get 100% visibility into your production application - at no cost.
> Code-level diagnostics for performance bottlenecks with <2% overhead
> Download for free and get started troubleshooting in minutes.
> http://p.sf.net/sfu/appdyn_d2d_ap1
> _______________________________________________
> Web-erp-developers mailing list

> Web-erp-developers@.sourceforge

> https://lists.sourceforge.net/lists/listinfo/web-erp-developers





--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Re-Web-erp-svn-SF-net-SVN-web-erp-5863-trunk-sql-mysql-upgrade4-09-4-10-sql-tp4656326p4656333.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] [Web-erp-svn] SF.net SVN: web-erp:[5863] trunk/sql/mysql/upgrade4.09-4.10.sql

[webERP D. <web...@li...>]

Hi Exson,

Interested in your work on this smtp transport option.

Although we have had this smtp settings configuration form for a while. We have
only ever sent one email I think using the htmlMimeMail class smtp transport
option.

I have never run into an issue with the normal php mail function - but
interested to understand when and why the new smtp option might be used?
On windows servers the php mail function can be set to use an external smtp
server in any event in the php.ini

Thanks

Phil


On 30 April 2013 at 13:39 webERP Developers
<web...@li...> wrote:
> *Hi, Richard:*
>
> Thank you for your comments. I'm wondering what I should do
> yesterday. It's a lazy idea. I'll correct it soon.
>
> Best regards!
>
> Exson
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Re-Web-erp-svn-SF-net-SVN-web-erp-5863-trunk-sql-mysql-upgrade4-09-4-10-sql-tp4656326p4656329.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
> Get 100% visibility into your production application - at no cost.
> Code-level diagnostics for performance bottlenecks with <2% overhead
> Download for free and get started troubleshooting in minutes.
> http://p.sf.net/sfu/appdyn_d2d_ap1
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
Phil

Ph: +64 (0)275 567890
Skype: daintree
http://www.logicworks.co.nz

[WebERP-developers] bugs fixed daily report April 29 2013

[webERP D. <web...@li...>]

             Please review today's bugs fixed report.

             I fixed SMTP mail related bugs today:
             1.  Users can config use smtp or not in setup.
             2.  They can mail their PO via smtp mail by the SMTP setting.

             The SMTP settings has some error messages for those Boolean
instead of object query return. And fixed the SMTP does not work for Chinese
setting, maybe also other language except English. At the same time fixed
the mailing feature for PO PDF files via smtp. It's no such setting before.
               
              Tim has review those files and found that </select> tag
missing.
              And I got Richard's feedback that I should create another
4.10-4.11 sql file.

              Thank you Tim and Richard.

             Best regards!

             Exson

20130430.zip
<http://weberp-accounting.1478800.n4.nabble.com/file/n4656331/20130430.zip>  

                



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/bugs-fixed-daily-report-April-29-2013-tp4656331.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] [Web-erp-svn] SF.net SVN: web-erp:[5863] trunk/sql/mysql/upgrade4.09-4.10.sql

[webERP D. <web...@li...>]

*Hi, Richard:*

           Thank you for your comments. I'm wondering what I should do
yesterday. It's a lazy idea. I'll correct it soon.

           Best regards!

           Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Re-Web-erp-svn-SF-net-SVN-web-erp-5863-trunk-sql-mysql-upgrade4-09-4-10-sql-tp4656326p4656329.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] [Web-erp-svn] SF.net SVN: web-erp:[5864] trunk/SystemParameters.php

[webERP D. <web...@li...>]

*Hi, Tim:*

               Thank you very much for your review. I'll correct it. 

               Best regards!

               Exson
           



Tim Schofield wrote
> Hi Exson,
> 
> I think that there is a missing 
> </select>
>  tag at the end of the selection box.
> 
> Thanks
> Tim
> 
> On 29/04/2013, ex...@us... &lt;ex...@us...&gt; wrote:
>> Revision: 5864
>>           http://sourceforge.net/p/web-erp/reponame/5864
>> Author:   exsonqu
>> Date:     2013-04-29 10:43:45 +0000 (Mon, 29 Apr 2013)
>> Log Message:
>> -----------
>> 04/29/2013: Exson Add new configuration for users use smtp mail.
>> 
>> Modified Paths:
>> --------------
>>     trunk/SystemParameters.php
>> 
>> Modified: trunk/SystemParameters.php
>> ===================================================================
>> --- trunk/SystemParameters.php	2013-04-29 10:41:57 UTC (rev 5863)
>> +++ trunk/SystemParameters.php	2013-04-29 10:43:45 UTC (rev 5864)
>> @@ -95,6 +95,9 @@
>>  	}elseif (mb_strlen($_POST['X_FrequentlyOrderedItems']) > 2 OR
>> !is_numeric($_POST['X_FrequentlyOrderedItems'])) {
>>  		$InputError = 1;
>>  		prnMsg(_('The number of frequently ordered items to display must be
>> numeric'),'error');
>> +	}elseif (strlen($_POST['X_SmtpSetting']) != 1 OR
>> !is_numeric($_POST['X_SmtpSetting'])){
>> +		$InputError = 1;
>> +		prnMsg(_('The SMTP setting should be selected as Yes or No'),'error');
>>  	}
>>  
>>  	if ($InputError !=1){
>> @@ -312,6 +315,10 @@
>>  		if ($_SESSION['AutoAuthorisePO'] != $_POST['X_AutoAuthorisePO']){
>>  			$sql[] = "UPDATE config SET confvalue='" .
>> $_POST['X_AutoAuthorisePO'] .
>> "' WHERE confname='AutoAuthorisePO'";
>>  		}
>> +		if ($_SESSION['SmtpSetting'] != $_POST['X_SmtpSetting']){
>> +			$sql[] = "UPDATE config SET confvalue = '".$_POST['X_SmtpSetting'] ."
>> '
>> WHERE confname='SmtpSetting'";
>> +
>> +		}
>>  		$ErrMsg =  _('The system configuration could not be updated because');
>>  		if (sizeof($sql) > 1 ) {
>>  			$result = DB_Txn_Begin($db);
>> @@ -1075,11 +1082,20 @@
>>  	

> <input type="text" name="X_InventoryManagerEmail" size="50"
>>
>  maxlength="50" value="' . $_SESSION['InventoryManagerEmail'] . '" />

>>  	

> ' . _('The email address for the inventory manager, where
>> notifications of all manual stock adjustments created are sent by the
>> system. Leave blank if no emails should be sent to the factory manager
>> for
>> manual stock adjustments') .'

> ';
>>  
>> +echo '

> ' . _('Using Smtp Mail'). '

>> +	

> <select type="text" name="X_SmtpSetting" >
>> +		
> <option select="selected" value = "0">
> '._('No').'
> </otpion>
>> +		
> <option value = "1">
> '._('Yes').'
> </option>
>> +	    

>> +	 

> '. _('The default setting is using mail in default php.ini, if you
>> choose Yes for this selection, you can use the SMTP set in the setup
>> section.').'

> ';
>>  
>> +
>> +
>> +
>>  echo '

>>  		
> <br />
> <div class="centre">
> <input type="submit" name="submit" value="' .
>>
>  _('Update') . '" />
> </div>
>>      
> </div>
>>  	
> </form>
> ';
>>  
>>  include('includes/footer.inc');
>> -?>
>> \ No newline at end of file
>> +?>
>> 
>> 
>> ------------------------------------------------------------------------------
>> Try New Relic Now & We'll Send You this Cool Shirt
>> New Relic is the only SaaS-based application performance monitoring
>> service
>> 
>> that delivers powerful full stack analytics. Optimize and monitor your
>> browser, app, & servers with just a few lines of code. Try New Relic
>> and get this awesome Nerd Life shirt!
>> http://p.sf.net/sfu/newrelic_d2d_apr
>> _______________________________________________
>> Web-erp-svn mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-svn
>> 
>>
> 
> 
> -- 
> Course View Towers,
> Plot 21 Yusuf Lule Road,
> Kampala
> T   +256 (0) 312 314 418
> M +256 (0) 752 963 325
> www.weberpafrica.com
> @TimSchofield2
> Blog: http://weberpafrica.blogspot.co.uk/





--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Re-Web-erp-svn-SF-net-SVN-web-erp-5864-trunk-SystemParameters-php-tp4656327p4656328.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] [Web-erp-svn] SF.net SVN: web-erp:[5863] trunk/sql/mysql/upgrade4.09-4.10.sql

[webERP D. <web...@li...>]

> Hi Exson:
>
> Wouldn't it be better to create a new file upgrade 4.10-4.11?
>
> Instalaltions already running 4.10.X should not run again the 4.09-4.10,
> in my opinion.
>
> Many thanks for all your work ;-)
>
> Regards,
> Ricard
>
>
> 2013/4/29 <ex...@us...>
>
> Revision: 5863
>>           http://sourceforge.net/p/web-erp/reponame/5863
>> Author:   exsonqu
>> Date:     2013-04-29 10:41:57 +0000 (Mon, 29 Apr 2013)
>> Log Message:
>> -----------
>> 04/29/2013 Add configuration for uses use smtp mail.
>>
>> Modified Paths:
>> --------------
>>     trunk/sql/mysql/upgrade4.09-4.10.sql
>>
>> Modified: trunk/sql/mysql/upgrade4.09-4.10.sql
>> ===================================================================
>> --- trunk/sql/mysql/upgrade4.09-4.10.sql        2013-04-29 10:06:28 UTC
>> (rev 5862)
>> +++ trunk/sql/mysql/upgrade4.09-4.10.sql        2013-04-29 10:41:57 UTC
>> (rev 5863)
>> @@ -60,4 +60,8 @@
>>
>>  ALTER TABLE `debtortrans` ADD `packages` INT NOT NULL DEFAULT '1'
>> COMMENT 'number of cartons';
>>
>> +INSERT INTO config VALUES('SmtpSetting',0);
>> +
>> +
>> +
>>  UPDATE config SET confvalue='4.10.1' WHERE confname='VersionNumber';
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Try New Relic Now & We'll Send You this Cool Shirt
>> New Relic is the only SaaS-based application performance monitoring
>> service
>> that delivers powerful full stack analytics. Optimize and monitor your
>> browser, app, & servers with just a few lines of code. Try New Relic
>> and get this awesome Nerd Life shirt!
>> http://p.sf.net/sfu/newrelic_d2d_apr
>> _______________________________________________
>> Web-erp-svn mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-svn
>>
>
>

[WebERP-developers] bugs fixed daily report April 28 2013

[webERP D. <web...@li...>]

*Dear all:*

          Please refer to today's bugs fixed report:

          Thank you very much for Samudaya's report and correction. Also
thanks for Phil's efforts to fixed these bugs. 

  27/4/13 Samudaya: Fixed a bug in PO_Items.php when a line of a purchase
order is deleted (other than the last line) and then subsequently a new line
is added - the last line of the order is over-written. 
27/4/13 Samudaya: PO_Items.php When purchasing a non-stock item (asset),
AssetID goes to wrong column in purchorderdetails table (Column name -
suppliers_partno). Fixed the bug and now save the AssetID in the correct
assetid column.
27/4/13 Samudaya: Fixed the Page Navigation (Go, Previous, Next) problem.
This problem occurs  there are many assets and display as several pages.
And a title mistake Z_CurrencySuppliersBalance.php revised by Phil.
       

        Best regards!

        Exson

                 20130428z.zip
<http://weberp-accounting.1478800.n4.nabble.com/file/n4656325/20130428z.zip>  




--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/bugs-fixed-daily-report-April-28-2013-tp4656325.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] bugs fixed daily report

[webERP D. <web...@li...>]

*Dear all:*

            Please refer to today's report:

 25/4/13 Tim: Selecting customer in Contracts form was not working - fixed
 25/4/13 Bob Thomas: WorkOrderIssue.php was not showing the serialised items
with a quantity that could be issued was showing them all in error
 25/4/13 Phil: BOMs.php fixed error that allowed auto issue to be flagged on
serialised items

           Thanks and best regards!
           Exson

20130426.zip
<http://weberp-accounting.1478800.n4.nabble.com/file/n4656323/20130426.zip>  



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/bugs-fixed-daily-report-tp4656323.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Non-existing items displayed in WO Issue of Serial No. Items

[webERP D. <web...@li...>]

Tim,

The batch controlled part is not and never was set to auto-issue.  I have
checked the database.  It is not set to auto-issue in the BOM table.  I will
try to research the problem further.  For now we can correct the database
outside of WebERP and continue  I haven't looked into what has happened due
this problem ot the costing and ledger postings.

Bob Thomas 



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Non-existing-items-displayed-in-WO-Issue-of-Serial-No-Items-tp4656289p4656320.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Non-existing items displayed in WO Issue of Serial No. Items

[webERP D. <web...@li...>]

The batch item handling is another can of worms.  If a batch is issued to a
Work Order, part received and then the work order is closed, the remaining
items in the batch are lost.  Example:

Batch 20121225 has 100 of ITEM A

We need 50 of PART XYZ the requires one of ITEM A per part.

When we build 50 of PART XYZ, receive and close the work order, 100 of Item
A have been removed from inventory never to be found in the database.

The problem gets even more involved, if we have to take ITEM A from multiple
batches.  PART XYZ gets a unique serial number upon integration of ITEM A. 
We need batch traceability.  This forces us to create multiple work orders
based on the quantities in a batch.

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Non-existing-items-displayed-in-WO-Issue-of-Serial-No-Items-tp4656289p4656318.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Non-existing items displayed in WO Issue of Serial No. Items

[webERP D. <web...@li...>]

Well the issue I think is that when issuing controlled items to a work order, we
are really only wanting to see those batches where there is actually stock
available. Bob's revision just returns the batches with a quantity > 0. It is of
course no point displaying batches where there is no stock left.

Phil

On 26 April 2013 at 13:11 webERP Developers
<web...@li...> wrote:
> *Hi, Phil and Bob:*
>
> I'm not sure if I understand the situation correctly, sometime
> we should to know where those serialized items goes and when. So the
> quantity is zero is make sense and the serial no is kept. Maybe the issue
> date should be kept. I did not check the actual situation.
>
> Best regards!
>
> Exson
>
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Non-existing-items-displayed-in-WO-Issue-of-Serial-No-Items-tp4656289p4656316.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Try New Relic Now & We'll Send You this Cool Shirt
> New Relic is the only SaaS-based application performance monitoring service
> that delivers powerful full stack analytics. Optimize and monitor your
> browser, app, & servers with just a few lines of code. Try New Relic
> and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
Phil

Ph: +64 (0)275 567890
Skype: daintree
http://www.logicworks.co.nz

Re: [WebERP-developers] Non-existing items displayed in WO Issue of Serial No. Items

[webERP D. <web...@li...>]

*Hi, Phil and Bob:*

             I'm not sure if I understand the situation correctly, sometime
we should to know where those serialized items goes and when. So the
quantity is zero is make sense and the serial no is kept. Maybe the issue
date should be kept. I did not check the actual situation. 

             Best regards!

             Exson

             



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Non-existing-items-displayed-in-WO-Issue-of-Serial-No-Items-tp4656289p4656316.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] bugs fixed daily report

[webERP D. <web...@li...>]

*Hi, Phil:*

           Thank you for your efforts to fixed those bugs. 

           Glad to hear that the GLPostings' progress.  It's a great news. 

           Best regards!

           Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/bugs-fixed-daily-report-tp4656310p4656315.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Non-existing items displayed in WO Issue of Serial No. Items

[webERP D. <web...@li...>]

The rationale for retaining the serialnumber reference was that if the item was
ever returned, the credit note logic expects the serial number to exist (you can
turn this off as a parameter - for the situation where webERP may not have been
in use when the serial number was actually made). Also, when you wish to look at
historical stock movements and which serial numbers were on it - this record is
required (I think?).

I have committed your change - thanks for feeding back your improvements to
webERP.

Phil

On 26 April 2013 at 01:00 webERP Developers
<web...@li...> wrote:
> Yes. The table stockserialitems is queried. In that table, no records are
> ever deleted when a serial numbered item is moved to a new location or
> becomes part of a new item. The quantity is merely set to 0. I have not
> had the time to study the code in detail to determine the rational for such
> behavior. One would have expected the record to have been deleted instead
> of just setting the quantity to 0.
>
> In any case, addition of the condition "AND quantity > 0" to the query
> corrected the problem.
>
> Since we have started using WebERP for tracking manufacturing, we have built
> hundreds of serialized items. The list had grown very large.
>
> We generally have bar code on the serial numbered items. The issue to Work
> Order function as currently implemented does not support keyed entry of
> serial numbers. We use the bar code scanner as a supplement to the
> keyboard. We would not want to lose the existing selection box, but would
> like the option of keyed entry also.
>
> Bob Thomas
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Non-existing-items-displayed-in-WO-Issue-of-Serial-No-Items-tp4656289p4656313.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Try New Relic Now & We'll Send You this Cool Shirt
> New Relic is the only SaaS-based application performance monitoring service
> that delivers powerful full stack analytics. Optimize and monitor your
> browser, app, & servers with just a few lines of code. Try New Relic
> and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
Phil

Ph: +64 (0)275 567890
Skype: daintree
http://www.logicworks.co.nz

Re: [WebERP-developers] Non-existing items displayed in WO Issue of Serial No. Items

[webERP D. <web...@li...>]

Yes.  The table stockserialitems is queried.  In that table, no records are
ever deleted when a serial numbered item is moved to a new location or
becomes part of a new item.  The quantity is merely set to 0.  I have not
had the time to study the code in detail to determine the rational for such
behavior.  One would have expected the record to have been deleted instead
of just setting the quantity to 0.

In any case, addition of the condition "AND quantity > 0" to the query
corrected the problem.

Since we have started using WebERP for tracking manufacturing, we have built
hundreds of serialized items.  The list had grown very large.

We generally have bar code on the serial numbered items.  The issue to Work
Order function as currently implemented does not support keyed entry of
serial numbers.  We use the bar code scanner as a supplement to the
keyboard.  We would not want to lose the existing selection box, but would
like the option of keyed entry also.

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Non-existing-items-displayed-in-WO-Issue-of-Serial-No-Items-tp4656289p4656313.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] bugs fixed daily report

[webERP D. <web...@li...>]

Good to have you back on the case Exson, I am not sure we have really 
bottomed the BOMExtendedQty one though yet ... it is a bit more 
complicated than that I think ... I have not really looked into it yet.

There is a bug in BOM.php that allows a controlled item to be updated as 
an auto issued component - of course that should not be possible as the 
batch/serial number needs to be entered for each issue of a controlled 
item. I have just fixed this now.

I am pleased to have the GLPostings.inc fixed finally - (I hope) please 
if anyone gets a TB out of balance again if you could let me know. In 
the words of Randy Jackson - big "props" to MacPhotoBiker off the webERP 
forum for his help in figuring out who this posting error occurs. Sorry 
I have been watching too much American Idol :-) That GL bug has been a 
pain in the butt for quite some time, so would be great if that was the 
end of it!!

Phil

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


On 25/04/13 21:55, webERP Developers wrote:
> *Dear all:*
>
>          Thank you very much for your report those bugs and thank you for
> Phil, Tim and Richard to fix those bugs:
>
>           Today's bugs fixed including:
>
>            1) BOMExtendedQty.php missing the PO with authorized and printed
> status. Reported by Bob and fixed by Phil
>            2) Credit_Invoice.php the link missing the $identifier fixed by
> Tim.
>            3) session.inc purge audit records completely. Fixed by Richard.
>            4) GLPosting.php rewrited by Phil to avoid wrong posting to
> non-existing period.
>            5) DateFunctions.php fixed the bugs when from and To is the same
> date. Reported and fixed by Kalmer.
>
>            Thanks and best regards!
>
>            Exson 20130425.zip
> <http://weberp-accounting.1478800.n4.nabble.com/file/n4656310/20130425.zip>
>
>
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/bugs-fixed-daily-report-tp4656310.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Try New Relic Now&  We'll Send You this Cool Shirt
> New Relic is the only SaaS-based application performance monitoring service
> that delivers powerful full stack analytics. Optimize and monitor your
> browser, app,&  servers with just a few lines of code. Try New Relic
> and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

[WebERP-developers] bugs fixed daily report

[webERP D. <web...@li...>]

*Dear all:*

        Thank you very much for your report those bugs and thank you for
Phil, Tim and Richard to fix those bugs: 
           
         Today's bugs fixed including:

          1) BOMExtendedQty.php missing the PO with authorized and printed
status. Reported by Bob and fixed by Phil
          2) Credit_Invoice.php the link missing the $identifier fixed by
Tim.
          3) session.inc purge audit records completely. Fixed by Richard.
          4) GLPosting.php rewrited by Phil to avoid wrong posting to
non-existing period.
          5) DateFunctions.php fixed the bugs when from and To is the same
date. Reported and fixed by Kalmer.

          Thanks and best regards!

          Exson 20130425.zip
<http://weberp-accounting.1478800.n4.nabble.com/file/n4656310/20130425.zip>  

          



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/bugs-fixed-daily-report-tp4656310.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Non-existing items displayed in WO Issue of Serial No. Items

[webERP D. <web...@li...>]

*Hi, Bob, 
*
      Do you mean all those serial no appeared when the users want to issue
the times to production whether it's had been issued or not？ And your
correction made only the available items displayed in the interface?

　　Best regards!

      Exson



rfthomas wrote
> Serial Number items are maintained in a separate file.  A permanent record
> is created for each Stockitem/serialno/loccode when the item is issued and
> made part of a higher lever assembly or otherwise moved, the record is
> never deleted, the quantity is just changed to 0.
> 
> When attempting to issue serial number items to a WO the whole history of
> serial numbers at the location is displayed in the selection box.  A check
> in the SQL for a quantity > 0 is needed.
> 
> The following correction in WorkOrderIssue.php fixes this problem:





--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Non-existing-items-displayed-in-WO-Issue-of-Serial-No-Items-tp4656289p4656308.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Vendor discount terms

[webERP D. <web...@li...>]

VAT based on 100% price:

Tim, if I am not totally off the road, that is not so in Germany: if the
vendor reduces the price by 10% with respect to the original quotation (or
if I get an early payment discount), then VAT is based on the 90% payed, not
on the original 100%. As we had VAT tax audits and they went fine, I assume
I did that right.

Klaus



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Vendor-discount-terms-tp4656278p4656307.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Vendor discount terms

[webERP D. <web...@li...>]

Bob,

Why wouldn't the payment terms for the supplier be set up to be say

1.5% discount for payment within 7 days.

then when an invoice is entered the terms pop up and the due date is 
defaulted to invoice date plus 7 days. It would seem additional work to 
enter the discount with each invoice, if this is part of the terms.

The payment run functionality would then need to handle the discount 
applicable so we only pay the net amount.

Let me know off list if you wish to sponsor such development. It would 
be a nice addition.

Phil

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


On 25/04/13 03:45, webERP Developers wrote:
> In our in-house system, vendor discount terms are handled as follows:
>
> When the vendor invoice is entered the following is entered:
>      invoice date
>      discount percent and discount
>      normal due date
>
> The AP clerk runs payments once or twice a week specifying a payment date.
> Invoices automatically suggested for payment are:
>
>      Invoices with available discount on payment date
>      Invoices past due
>      Invoices due with-in 5 days (system default - clerk can override)
>
> The clerk then selects the invoices to be paid and makes payment.  If based
> on the payment date there is available discount, then such is taken.  If the
> payment date is outside the discount window then the invoice is paid in
> full.
>
> Bob Thomas
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Vendor-discount-terms-tp4656278p4656290.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Try New Relic Now&  We'll Send You this Cool Shirt
> New Relic is the only SaaS-based application performance monitoring service
> that delivers powerful full stack analytics. Optimize and monitor your
> browser, app,&  servers with just a few lines of code. Try New Relic
> and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>