web-erp-developers — Discussion on development of webERP

Re: [WebERP-developers] Print Price List does not Work

[rfthomas <rf...@as...>]

Exson,

 

We still get the following error message:

 

WARNING Message Report : There were no price details to print out for the
customer or category specified

 

Sincerely,

Robert F. Thomas



 44 Industrial Way 
Norwood, MA USA 02062
*  Office Phone - (781) 329-9200
* mail to: rf...@as...

 

 

From: ExsonQu [via webERP accounting]
[mailto:ml-...@n4...] 
Sent: Saturday, October 31, 2015 7:22 AM
To: rfthomas <rf...@as...>
Subject: Re: Print Price List does not Work

 

Hi, Bob,

          I've revised the file. Would you like to check if it does work? 

          Best regards! 

          Exson 

        PDFPriceList.zip
<http://weberp-accounting.1478800.n4.nabble.com/file/n4658372/PDFPriceList.z
ip>  

  _____  

If you reply to this email, your message will be added to the discussion
below:

http://weberp-accounting.1478800.n4.nabble.com/Print-Price-List-does-not-Wor
k-tp4658353p4658372.html 

To unsubscribe from Print Price List does not Work, click here
<http://weberp-accounting.1478800.n4.nabble.com/template/NamlServlet.jtp?mac
ro=unsubscribe_by_code&node=4658353&code=cmZ0QGFzdGhvbWFzLmNvbXw0NjU4MzUzfC0
xODc0MzAxMjU=> .
 
<http://weberp-accounting.1478800.n4.nabble.com/template/NamlServlet.jtp?mac
ro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.names
paces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.we
b.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.nam
l-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.n
aml> NAML 



image001.png (51K) <http://weberp-accounting.1478800.n4.nabble.com/attachment/4658376/0/image001.png>




--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Print-Price-List-does-not-Work-tp4658353p4658376.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Quotation Prices incorrect

[rfthomas <rf...@as...>]

Exson,

 

We have list of customer types for example:

 

Default

End User

OEM

 

Sales Types:

 

End User

End User 10%

OEM/Integrator

 

Discount Matrix with information for each of the sales types, using discount
categories, quantity break and discount rate.

 

We have customers setup with customer type and sales type code.

 

When a quote is prepared the Sales Type should cause prices to be generated
based on the Discount Matrix.  In the base 4.12.3 code when creating a
quotation the only prices available are the Default.  In our system Default
is the End User price.   The price should be calculated by applying the
Sales Type Discount Matric against the Default price (in our case End User).

 

We have reverted to the prior release code that correctly calculates the
prices: 

 

/* $Id: GetPrice.inc 6941 2014-10-26 23:18:08Z daintree $*/

 

Sincerely,

Robert F. Thomas



 44 Industrial Way 
Norwood, MA USA 02062
*  Office Phone - (781) 329-9200
* mail to: rf...@as...

 

 

From: ExsonQu [via webERP accounting]
[mailto:ml-...@n4...] 
Sent: Saturday, October 31, 2015 6:53 AM
To: rfthomas <rf...@as...>
Subject: Re: Quotation Prices incorrect

 

Hi, Bob,

          Would you describe your problem more clearly? What do you mean
customer price list is not the default? 

          Best regards! 

         Exson 

  _____  

If you reply to this email, your message will be added to the discussion
below:

http://weberp-accounting.1478800.n4.nabble.com/Quotation-Prices-incorrect-tp
4658352p4658371.html 

To unsubscribe from Quotation Prices incorrect, click here
<http://weberp-accounting.1478800.n4.nabble.com/template/NamlServlet.jtp?mac
ro=unsubscribe_by_code&node=4658352&code=cmZ0QGFzdGhvbWFzLmNvbXw0NjU4MzUyfC0
xODc0MzAxMjU=> .
 
<http://weberp-accounting.1478800.n4.nabble.com/template/NamlServlet.jtp?mac
ro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.names
paces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.we
b.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.nam
l-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.n
aml> NAML 



image003.png (51K) <http://weberp-accounting.1478800.n4.nabble.com/attachment/4658375/0/image003.png>




--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Quotation-Prices-incorrect-tp4658352p4658375.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Development discuss - Customer code in stockserialmoves table

[ExsonQu <hex...@gm...>]

*Hi, Bob,*

          Thank you for sharing this!

          Best regards!

          Exson



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

Re: [WebERP-developers] Prototype Quotes

[ExsonQu <hex...@gm...>]

*Hi, Bob,*

             We can do it but I'm not sure if it's general requirements. 

             So we would like to hear more feedback!

             Thanks and best regards!

             Exson
            



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

Re: [WebERP-developers] Print Price List does not Work

[ExsonQu <hex...@gm...>]

*Hi, Bob,*

          I've revised the file. Would you like to check if it does work?

          Best regards!

          Exson

         PDFPriceList.zip
<http://weberp-accounting.1478800.n4.nabble.com/file/n4658372/PDFPriceList.zip>  



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Print-Price-List-does-not-Work-tp4658353p4658372.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Quotation Prices incorrect

[ExsonQu <hex...@gm...>]

*Hi, Bob,*

          Would you describe your problem more clearly? What do you mean
customer price list is not the default? 

          Best regards!

         Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Quotation-Prices-incorrect-tp4658352p4658371.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Development discuss - Customer code in stockserialmoves table

[rfthomas <rf...@as...>]

We had provided such a report a couple of years ago.  We have attached the
export of this report function. Ser.txt
<http://weberp-accounting.1478800.n4.nabble.com/file/n4658370/Ser.txt>  

You can import this report into webERP via the "Report Builder Tool" in the
Set-up menu.

We have written a number of reports to track inventory at customers and in
manufacturing.

Bob Thomas



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

Re: [WebERP-developers] Development discuss

[ExsonQu <hex...@gm...>]

*Dear all,*

          Thank you for your feedback!!

         Now those feature is completed and commit to the trunk. 
          
         Since the local currency and bank account currency can be reviewed
at Daily bank transaction as Tim point out, I've only improved the
DailyBankTransactions.php, and make the Bank account balance, and GL
narrative available during the inquiry. 
         And suppliers'  delivery note No can be input during goods
receiving. And the GRN, delivery note and PO No and Supplier's invoice can
be inquired with a new inquiry scripts. 

         Thank you for all of your help!!

         Best regards!

         Exson



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

Re: [WebERP-developers] Development discuss - Customer code in stockserialmoves table

[ExsonQu <hex...@gm...>]

*Hi, Arwan,*

           I'm not very sure about your requirement. If you want to know
where those serialized items gone, we can add a new inquiry scripts to show
it. 
          But I do not understand why we should add a field to this table.
If you need to reserve it during issue a sales orders, we do not need to add
a special field for it. 
           I've create a feature of auto pull and conservation serialized
items by FIFO at issuing a new sales orders. But I cannot public it
currently. 
          
         Thanks and best regards!

          Exson 
          
          



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

Re: [WebERP-developers] Development discuss - Customer code in stockserialmoves table

[Arwan <r1g...@gm...>]

ExsonQu,

Thank you for your great contributions to webERP development

while you make the proposed changes, is it possible to add a
customer code field in the stockserialmoves table and have the 
serial numbers issue PHP script update it so what there is a way
of tracking which serial numbers are with which customer ?

Thanks in advance



Arwan



-----
WebTech Resources
Nairobi Kenya
+254 724659244
Email  :in...@we...  
WEB  :weberp.co.ke

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

Re: [WebERP-developers] Development discuss

[rfthomas <rf...@as...>]

I too am in favor of all of your proposed updates.

Currently we have not had to deal in multiple currencies, but we do need to
correlate supplier shipments to GRN's.

Bob Thomas



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

Re: [WebERP-developers] Development discuss

[Rafael C. <raf...@gm...>]

Hi,

Always, I agree with having new features. In the worst case, we have to add
a turn on/off setup option for a new feature.

Go ahead!

Regards, Rafael.
El 28/10/2015 07:49, "gilberto dos santos alves" <gs...@gm...>
escribió:

> Hi. +1 for 1, 2 and 3.
>
> 2015-10-28 7:04 GMT-02:00 Phil Daintree <ph...@lo...>:
>
>> Like the sound of 1 2 and 3!
>>
>> Phil
>>
>> Phil Daintree
>> Logic Works Ltd - +64 (0)275 567890
>> http://www.logicworks.co.nz
>>
>> On 28/10/15 21:20, ExsonQu wrote:
>> > *Hi, Richard*
>> >
>> >              Thank you for your quick response.
>> >
>> >              For No.2, users need a link to communicate with suppliers
>> when
>> > issue a invoice or return the goods.  For instance, if some thing wrong
>> with
>> > the invoice, the users can communicate with suppliers with supplier's
>> > delivery note number.
>> >
>> >             I'll add a inquiry screen with Tim's current table
>> settings. Then
>> > users can get suppliers' invoice no, delivery note by GRN batch No or
>> vice
>> > versa.
>> >
>> >            Thanks and best regards!
>> >
>> >            Exson
>> >
>> >
>> >
>> >
>> >
>> >
>> > --
>> > View this message in context:
>> http://weberp-accounting.1478800.n4.nabble.com/Development-discuss-tp4658360p4658362.html
>> > Sent from the web-ERP-developers mailing list archive at Nabble.com.
>> >
>> >
>> ------------------------------------------------------------------------------
>> > _______________________________________________
>> > Web-erp-developers mailing list
>> > Web...@li...
>> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>> >
>>
>>
>>
>> ------------------------------------------------------------------------------
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>
>
>
> --
> gilberto dos santos alves
> +55(11)9-8646-5049
> sao paulo - sp - brasil
>
>
>
>
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] Development discuss

[gilberto d. s. a. <gs...@gm...>]

Hi. +1 for 1, 2 and 3.

2015-10-28 7:04 GMT-02:00 Phil Daintree <ph...@lo...>:

> Like the sound of 1 2 and 3!
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890
> http://www.logicworks.co.nz
>
> On 28/10/15 21:20, ExsonQu wrote:
> > *Hi, Richard*
> >
> >              Thank you for your quick response.
> >
> >              For No.2, users need a link to communicate with suppliers
> when
> > issue a invoice or return the goods.  For instance, if some thing wrong
> with
> > the invoice, the users can communicate with suppliers with supplier's
> > delivery note number.
> >
> >             I'll add a inquiry screen with Tim's current table settings.
> Then
> > users can get suppliers' invoice no, delivery note by GRN batch No or
> vice
> > versa.
> >
> >            Thanks and best regards!
> >
> >            Exson
> >
> >
> >
> >
> >
> >
> > --
> > View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Development-discuss-tp4658360p4658362.html
> > Sent from the web-ERP-developers mailing list archive at Nabble.com.
> >
> >
> ------------------------------------------------------------------------------
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
>
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>



-- 
gilberto dos santos alves
+55(11)9-8646-5049
sao paulo - sp - brasil

Re: [WebERP-developers] Development discuss

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

Like the sound of 1 2 and 3!

Phil

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

On 28/10/15 21:20, ExsonQu wrote:
> *Hi, Richard*
>
>              Thank you for your quick response.
>
>              For No.2, users need a link to communicate with suppliers when
> issue a invoice or return the goods.  For instance, if some thing wrong with
> the invoice, the users can communicate with suppliers with supplier's
> delivery note number.
>
>             I'll add a inquiry screen with Tim's current table settings. Then
> users can get suppliers' invoice no, delivery note by GRN batch No or vice
> versa.
>
>            Thanks and best regards!
>
>            Exson
>               
>
>            
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Development-discuss-tp4658360p4658362.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] Development discuss

[ExsonQu <hex...@gm...>]

*Hi, Richard*

            Thank you for your quick response. 

            For No.2, users need a link to communicate with suppliers when
issue a invoice or return the goods.  For instance, if some thing wrong with
the invoice, the users can communicate with suppliers with supplier's
delivery note number. 

           I'll add a inquiry screen with Tim's current table settings. Then
users can get suppliers' invoice no, delivery note by GRN batch No or vice
versa. 

          Thanks and best regards!

          Exson
             

          



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

Re: [WebERP-developers] Development discuss

[Pak R. <pak...@gm...>]

Hi Exson:

I am voting for 1) and 3) for sure. Checking the bank accounts in foreign
currency is not user friendly nowadays. It has been in my to-do list for
years :-(

We check the bank balance via reconciliation script but it's not the best
way to do it.

For 2) we don't use it much, so not sure of its usability.

Many thanks for asking our POV and for being always there ready to help!

Regards,
Ricard

2015-10-28 15:32 GMT+08:00 ExsonQu <hex...@gm...>:

> *Dear all,*
>
>               Thank you for your long time nice support!
>
>               I'd like to commit some new feature to webERP. But I'm not
> sure if it's a general requirements or just a niche requirement. So your
> opinion is quite important. If it's a general requirements, I'll commit it
> to the trunk.
>
>               1. Original amount and currency show during GL inquiry for
> bank account.
>                  The GL inquiry will show the Bank Reference, Currency and
> transaction amount in bank default currency instead of  operation currency.
> It will help users to see the bank check no, currency and amount.
>               2. Record suppliers delivery note No in GRN.
>                  Currently, webERP has no records for suppliers' delivery
> note No. Shall we add a field to store it for yours who maybe need it? For
> instance, users' may use it to input supplier's invoice.
>
>               3. Bank transaction
>                   Currently, if we have multi currency, the bank account
> balance can be checked directly.
>                   There are two option for us, one is add a current balance
> in banktrans table, just like QOH of inventory. Or we add some code to
> calculated in DailyBankTrans.php. Then the balance can be checked
> conveniently.
>
>               If those features are needed, I'll commit it to trunk within
> one week.
>
>               Thanks and best regards!
>
>               Exson
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Development-discuss-tp4658360.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

[WebERP-developers] Development discuss

[ExsonQu <hex...@gm...>]

*Dear all,*

              Thank you for your long time nice support!

              I'd like to commit some new feature to webERP. But I'm not
sure if it's a general requirements or just a niche requirement. So your
opinion is quite important. If it's a general requirements, I'll commit it
to the trunk. 

              1. Original amount and currency show during GL inquiry for
bank account. 
                 The GL inquiry will show the Bank Reference, Currency and
transaction amount in bank default currency instead of  operation currency.
It will help users to see the bank check no, currency and amount. 
              2. Record suppliers delivery note No in GRN. 
                 Currently, webERP has no records for suppliers' delivery
note No. Shall we add a field to store it for yours who maybe need it? For
instance, users' may use it to input supplier's invoice. 

              3. Bank transaction
                  Currently, if we have multi currency, the bank account
balance can be checked directly. 
                  There are two option for us, one is add a current balance
in banktrans table, just like QOH of inventory. Or we add some code to
calculated in DailyBankTrans.php. Then the balance can be checked
conveniently. 

              If those features are needed, I'll commit it to trunk within
one week.  

              Thanks and best regards!

              Exson
                 



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

[WebERP-developers] Print Price List does not Work

[rfthomas <rf...@as...>]

This is a problem that has existed for many version of WebERP going back
several years.

Print price list does not print price list for any prices other than the
default price list.

The following error is generated:

WARNING Message Report : There were no price details to print out for the
customer or category specified

The script is PDFPriceList.php



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Print-Price-List-does-not-Work-tp4658353.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] Quotation Prices incorrect

[rfthomas <rf...@as...>]

We are using 4.12.3 and find that includes/GetPrice.inc returns a 0.00 price
for items if the customer price list is not the default.  The Discount
Matrix is properly set-up, but ignored.  We have restored the version of
GetPrice from /* $Id: GetPrice.inc 6714 2014-05-17 03:09:03Z daintree $*/
removing the ,$db, and everything works as expected.



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Quotation-Prices-incorrect-tp4658352.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] Prototype Quotes

[rfthomas <rf...@as...>]

We prepare many quotes that have similar (identical) components in different
quantities.  Is there a way in webERP to copy a quote and just make edits to
it, changing the customer information, and quantities using the customer
specific prices?



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

Re: [WebERP-developers] Database Maintenance at Logon Fails Regularly

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

Hi Ade,

 >What we want to know is:
 >1. What's the script actually do? which DB table affected by this script?

It runs the function DB_Maintenance() - in includes/ConnectDB_mysqlx.inc
the code in the ConnectDB_mysqli.inc does this:

function DB_Maintenance(){

     prnMsg(_('The system has just run the regular database 
administration and optimisation routine.'),'info');

     $TablesResult = DB_query("SHOW TABLES");
     while ($myrow = DB_fetch_row($TablesResult)){
         $Result = DB_query('OPTIMIZE TABLE ' . $myrow[0]);
     }

     $Result = DB_query("UPDATE config
                 SET confvalue='" . Date('Y-m-d') . "'
                 WHERE confname='DB_Maintenance_LastRun'");
}

so runs OPTIMIZE TABLE on all tables

https://dev.mysql.com/doc/refman/5.1/en/optimize-table.html


 >2. Is the script really necessary to run in webERP? Is there's any 
problem if we set it to '0' (never)?

The effect is minimal I think as indexes do not need to be rebuilt often.

 >3. Is it possible that this issues happens because our database is 
growing larger and larger each months?

Yes the bigger the DB the longer the OPTIMIZE TABLE will take.

 >If it's really the issues, so how we manage to perform the database 
maintenance properly?

Probably could run the OPTIMIZE TABLE from phpMyAdmin or from mysql 
command line more efficiently.

Phil

Re: [WebERP-developers] Database Maintenance at Logon Fails Regularly

[gilberto d. s. a. <gs...@gm...>]

Hi. IMHO you could use:

1. What's the script actually do? which DB table affected by this script?

Problem is new version of databases (constraints (primary key, foreign key,
indexes)) that goto live production without tests.

2. Is the script really necessary to run in webERP? Is there's any problem
if we set it to '0' (never)?

First answer is no you do not have any problem if you do not clean your
database; but if your provider limit size of your data base space or your
resources (memory + network) are rare this leave you to more slow weberp
environment. So if you use share dreamhost, hostgator or other like these
providers keep cool. I use weberp for more than 6 years in small, medium
and high volume and never we have issues with this.

Make a phpmyadmin export (with zip or gzip mode) and after clear all
records of table AUDITTRAIL. For detailed database weberp 4.11.2 please see




3. Is it possible that this issues happens because our database is growing
larger and larger each months? If it's really the issues, so how we manage
to perform the database maintenance properly?

Make a phpmyadmin export (with zip or gzip mode) and after clear all
records of table AUDITTRAIL.
For detailed database weberp 4.11.2 please see [1]

Look for this code fragment session.inc or (login.php) search at [2]

******************** fragment end ***********************************


/*If the Code $Version - held in ConnectDB.inc is > than the Database
VersionNumber held in config table then do upgrades */
if (strcmp($Version,$_SESSION['VersionNumber'])>0 AND
(basename($_SERVER['SCRIPT_NAME'])!='UpgradeDatabase.php')) {
	header('Location: UpgradeDatabase.php');
}
if(isset($_SESSION['DB_Maintenance'])){
	if ($_SESSION['DB_Maintenance']>0)  { //run the DB maintenance script
		if (DateDiff(Date($_SESSION['DefaultDateFormat']),
				ConvertSQLDate($_SESSION['DB_Maintenance_LastRun'])
				,'d')	>= 	$_SESSION['DB_Maintenance']){

			/*Do the DB maintenance routing for the DB_type selected */
			DB_Maintenance($db);
			$_SESSION['DB_Maintenance_LastRun'] = Date('Y-m-d');
		}
	}
}
//purge the audit trail if necessary
if (isset($_SESSION['MonthsAuditTrail'])){
	 $sql = "DELETE FROM audittrail
			WHERE  transactiondate <= '" . Date('Y-m-d', mktime(0,0,0,
Date('m')-$_SESSION['MonthsAuditTrail'])) . "'";
	$ErrMsg = _('There was a problem deleting expired audit-trail history');
	$result = DB_query($sql,$db);
}

******************** fragment end ***********************************

Regards.


[1] http://auvix.com.br/#DB-Auvix402_erp14
[2] http://sourceforge.net/p/web-erp/code/HEAD/tree/trunk/


2015-10-19 4:26 GMT-02:00 baliboss <it...@ba...>:

> Dear, All webERP Developers and Phil Daintree
>
> In our webERP System Configuration (version 4.10.1), we set the Perform
> Database Maintenance At Logon to Monthly and there is no problem for more
> than 3 years now.
>
> But now when the first user login every month and performing the database
> maintenance, the process seems like stuck and loading for hours, no error
> messages, it's just loading. It's happen for several months now. We thought
> it's stuck so we decide to change the config in phpmyadmin and set
> DB_Maintenance to '0' (never)  and cancel the process, clear the browser
> cache and webERP running as usual.
>
> What we want to know is:
> 1. What's the script actually do? which DB table affected by this script?
> 2. Is the script really necessary to run in webERP? Is there's any problem
> if we set it to '0' (never)?
> 3. Is it possible that this issues happens because our database is growing
> larger and larger each months? If it's really the issues, so how we manage
> to perform the database maintenance properly?
>
> Thank You,
>
> Best Regards,
> ----------------
> Ade / baliboss
>
>
>
> -----
> Baliboss
> Bali Open Source Solution
> www.baliboss.com
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Database-Maintenance-at-Logon-Fails-Regularly-tp4658349.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>



-- 
gilberto dos santos alves
+55(11)9-8646-5049
sao paulo - sp - brasil

[WebERP-developers] Database Maintenance at Logon Fails Regularly

[baliboss <it...@ba...>]

Dear, All webERP Developers and Phil Daintree

In our webERP System Configuration (version 4.10.1), we set the Perform
Database Maintenance At Logon to Monthly and there is no problem for more
than 3 years now.

But now when the first user login every month and performing the database
maintenance, the process seems like stuck and loading for hours, no error
messages, it's just loading. It's happen for several months now. We thought
it's stuck so we decide to change the config in phpmyadmin and set
DB_Maintenance to '0' (never)  and cancel the process, clear the browser
cache and webERP running as usual.

What we want to know is:
1. What's the script actually do? which DB table affected by this script?
2. Is the script really necessary to run in webERP? Is there's any problem
if we set it to '0' (never)?
3. Is it possible that this issues happens because our database is growing
larger and larger each months? If it's really the issues, so how we manage
to perform the database maintenance properly?

Thank You,

Best Regards, 
----------------
Ade / baliboss



-----
Baliboss
Bali Open Source Solution
www.baliboss.com
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Database-Maintenance-at-Logon-Fails-Regularly-tp4658349.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] How to handle defect goods?

[ExsonQu <hex...@gm...>]

*Dear all,*

            Several times users ask if webERP can handle defect goods in
Manufacturing module.  There are defective material and defective finish
goods. 
            For defective material, we can return to vendor for incoming
defect. But there are no feature to handle those defective material which is
caused by users themselves. 
            For defective finish goods, sometime we will keep it for further
judgment. Or it will be scrap later.
            The problem is that, if we set up a warehouse as a defective
warehouse, these defect item will be calculated as normal goods and the item
cost will be affected. 
            Steven has brought up a idea is that we create a shadow
warehouse, which only records the quantity of defect items and it will not
involve cost and MRP calculation. 
            Any idea is highly appreciated!

            Thanks and best regards!

            Exson
             
            



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/How-to-handle-defect-goods-tp4658348.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Question about barcode field

[Pak R. <pak...@gm...>]

Thanks Rafael and Phil:

So, we'll be using stockid then. Our stockid is AAAANN-BB-CC and want to
use 28 mm labels (as we sell jewellery and labels should be really small).
Easily legible barcodes with 12 characters use more than 28 mm. If reduced
until 28 mm, then are not properly printed and afterwards read.

Regarding Phil's idea, I tried, but when the PDF is printed and the PDF
resolution and printer resolution don't match, the vertical lines get
wrong. So (as example) if PDF barcode is created at 200 dpi and printed on
a barcode printer of 300 dpi, 1 PDF vertical line of 1 point should be
printed as 1.5 points at the printer. Some printers will choose to print 1
point, some 2. Then the barcode read can't be read properly, as the
proportion between line widths is not correct.

So the "proper" way to do it, is to match PDF and printer resolutions (or
printer resolution being a multiple of PDF resolution). Following previous
example, if printer is 600 dpi, then every 1 PDF point gets printed as 3
printer points, and it works OK.

Main issue is: now, seems like barcodes are geneated at 72dpi and it's "the
mother of all messes". I will explore to print barcodes with TCPDF
directly, as there's a parameter $xres than (if I'm not wrong) can de used
to set the resolution of the barcode image.

I'm still on the learning curve, so probably there are some errors on my
point.

Regards,
Ricard

2015-09-28 22:19 GMT+08:00 Rafael Chacón <raf...@gm...>:

> Hi Ricard,
>
> I also use stockmaster.stockid=stockmaster.barcode (with 13 digits
> barcodes). I use two label sizes; the "for public label" is 50 x 100 mm
> (american 2 x 4 inches). I prefer to use 5 cm length barcode (for 13
> digits), but you can use a 3 cm length barcode (you can reduce the size of
> the barcode image and it still readable).
>
> Sorry, I use other software to print labels because I did not know this in
> webERP (I had no time to move from this other software to webERP, but I
> will do). Nicola Asuni's TCPDF has parameters for Width/Height of a
> single bar element in pixels (and put it in a cell + other elements like
> item name, etc.; you can preview it in HTML and then print in PDF --as
> generate a PDF from HTML--)
>
> The barcode reader is used to input the stock code
> in CounterSales.php/Item
> Code, SelectOrderItems.php?identifier=9999999999/OR Enter extract of the
> Stock Code:, etc. instead of type ("write by fingers").
>
> For me:
> + Pros: Everybody knows the stockmaster.stockid (except, obviously, the
> private barcodes --200 series--).
> - Cons: PDFPriceList.php sorts by "Item Code" instead of "Item
> Description" (and barcodes arr by manufacturer and by
> first-come-first-code).
>
> Best regards, Rafael.
>
>
> 2015-09-28 1:31 GMT-06:00 Pak Ricard <pak...@gm...>:
>
>> Hi all:
>>
>> On my struggle to print barcodes, etc... I face another problem. my
>> barcode field contains the same info as stockid (stockmaster.barcode =
>> stockmaster.stockid) and it's too long for the label :-(
>>
>> Question: Does webERP need that stockmaster.barcode = stockmaster.stockid
>> to use the barcode readers? Or webERP detects when a barcode reader is used
>> and selects the item by barcode field? Or dies it by stockid?
>>
>> Example: CounterSales.php does not read/use the field
>> stockmaster.barcode. How does it identify the items? by stockid?
>>
>> Completely lost about this.
>>
>>
>>
>> Regards,
>> Ricard
>>
>>
>> ------------------------------------------------------------------------------
>>
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>