web-erp-developers — Discussion on development of webERP

[WebERP-developers] webERP4.13.1 released

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

*Dear all,*

             I've just made a release of webERP4.13.1. 
              
             It includes cash flow statement from Rafael and he also make
great efforts to make the pdf file worked more gracefully.  And there are
also some bugs fixed in this new release.
             Please see more details as following:

 
23/11/16 RChacon: On AccountGroups.php, add navigation aids (return button).
08/11/16 RChacon: On WWW_Users.php, fix hardcoded label (difficult to
translate for languages with a different structure to English), do sortable
the users list, replace printf() with plain list echo, and add format class.
08/11/16 RChacon: Add scripts to show a statement of cash flows for the
period using the indirect method.
08/11/16 RChacon: On SelectSupplier.php, fix table html code.
06/11/16 RChacon: On SupplierPriceList.php, fix to show price in user's
locale format, add supplier's id and name to title, replace printf() with
plain list echo, and regroup and document code.
03/11/16 RChacon: On Dashboard.php, fix creditors payment to point to
allocation instead to payment, replace printf() with plain list echo,
regroup code, and complete column styles.
01/11/16 RChacon: On SupplierInquiry.php, replace the printf() statements
with echo statements to fix bug caused by a supplier invoice with a comment
that includes a % character (reported by R2-G, solution by Tim).
30/10/16 RChacon: In SecurityTokens.php: Fix Description's input maxlength,
fix table head in data table, move form-tables after data table, add cancel
button in edit form table, add return button, add style to print data table,
add title in form tables, regroup code, change from if/elseif to switch/case
to improve code readability, and add code documentation.
30/10/16 RChacon: On SupplierPriceList.php, add ViewTopic and BookMark, and
complete html table. Add info to manual.
17/10/16 Phil: Fix SQL in ReverseGRN.php as reported by Ricard/Tim.
16/10/16 RChacon: Fix function convertDate(dS,dF).
05/10/16 Eatong: Format the ManualAPITutorial.html for easier reading.
05/10/16 Eatong: Add CSS rule for <pre> for easier reading.
05/10/16 Eatong: Align field length of salesanalysis.salesperson to
salesman.salesmancode.
05/10/16 RChacon: Add cross.svg, next.svg, previous.svg, and tick.svg images
in Scalable Vector Graphics (SVG) format for general use (any size).
04/10/16 RChacon: In class.pdf.php, fix the function addJpegFromFile() use
of the functionality Image() of TCPDF class.
04/10/16 RChacon: In class.pdf.php, functions Rectangle() and
RoundRectangle() use the functionalities Rect() and RoundedRectXY() of TCPDF
class.
04/10/16 RChacon: Add return.svg image for Return button in Scalable Vector
Graphics (SVG) format.
27/09/16 RChacon: Add webERP logo in Scalable Vector Graphics format.
25/09/16 Exson: Make customer reference GET method workable in
SelectCompletedOrder.php. Fixed decimalplaces missing bug in
SelectOrderItems.php. Add due date, order date and customer reference option
in SelectSalesOrder.php.
25/09/16 Exson: Make the details show immediately when the search result is
one in SelectCompletedOrder.php.And add return links in OrderDetails.php.
24/10/16 Simon Kelly: Fixed placing POs for sales orders using array form
variable
24/09/16 waynemcdougall: Fixed missing date in Sales Price history
24/09/16 Exson: Make Justify feature workable in addTextWrap in
class.pdf.php.
24/09/16 Exson: Fixed the AddTextWrap missing characters errors when there
is space and make it more reliable.
21/09/16 RChacon: In SuppWhereAlloc.php, accepts the payment multiple
creditors. In CustWhereAlloc.php, accepts the receipt of multiple debtors.
18/09/16 RChacon: Add style to describe how button image should be
displayed. Clean up Xenos css.
18/09/16 Exson: Add multiple items issue for non-controlled items feature to
Work Orders in WorkOrderIssue.php.
14/09/16 Exson: Add narrative, transaction date data to
PDFOrdersInvoiced.php.
14/09/16 Exson: Add order line narrative and invoices link to sales order
inquiry in OrderDetails.php.
12/09/16 Exson: Add a filter to avoid tons of zero valued gl transaction
records generated in SQL_CommonFunctions.inc.
04/09/16 Exson: Add WO items delete constraint in WorkOrderEntry.php. Thanks
for Phil's reminder.
04/09/16 Exson: Add delete Work orders Items feature in WorkOrderEntry.php.
04/09/16 Exson: Fixed the undefined noise in WorkOrderStatus.php.
04/09/16 Exson: Fixed the bug that work order location will be wrong when
user select location which is not user's default location.
04/09/16 Dave Parrish fixed accumulated No of orders bug in
SalesByTypePeriodInquiry.php.
31/08/16 Exson: Addd new feature assign cash from one tab to another.
24/08/16 Exson: Fixed the latin1 charset mixed bug in supplierdiscounts
table;
24/9/16 Exson: Fixed the bug that days of payment terms in the following
month over 31 days can not be handled correctly in DateFunctions.inc.
20/08/16 RChacon: In ConfirmDispatch_Invoice.php, fix table html code.
18/08/16 RChacon: In PDFStatementPageHeader.inc, replace addJpegFromFile()
and RoundRectangle() functions from class.pdf.php with Image() and
RoundedRect() functions from tcpdf.php.
18/08/16 Exson: Add a Cancel button on SupplierAllocations.php to make user
can return to previous page easily.
18/08/16 Exson: Add date format validation in PcClaimExpensesFromTab.php.
17/8/16 RChacon committed for Tim: In CustWhereAlloc.php and
SuppWhereAlloc.php, use the ConvertSQLDate() function for the dates.
14/8/16 RChacon:In SuppWhereAlloc.php, show transaction date in report.
Improvements in HTML code and code documentation.
13/8/16 RChacon:In CustWhereAlloc.php, show transaction date in report.
Standardise trandate in debtortrans. Improvements in HTML code and code
documentation.
11/8/16 Phil: committed falkoners fix for the upgrade script - was not
adding the new field in customercontact required for the customer statements
email address
11/8/16 Simon Kelly: Fix SQL for location users in SelectSalesOrder.php
05/08/16 RChacon: In GLAccountInquiry.php, add noprint class to clean up
printer output and improve code documentation.
05/08/16 RChacon: Fix html code in SuppInvGRNs.php.
02/08/16 Exson: Make account inquiry shown directly when GL Code selected or
inquiry result is 1 in SelectGLAccount.php.
27/07/16 Exson: Add cost update date for material cost in
WorkOrderCosting.php and WorkOrderIssue.php.
27/07/16 Exson: Fixed the typo in Credit_Invoice.php introduced in previous
update.
27/07/16 Exson: Fixed the divided by zero error when discount is 100% in
SelectOrderItems.php.
27/07/16 Exson: Add error proof to avoid a blank credit note issued without
any items credited or freight charge input in Credit_Invoice.php.
25/07/16 Exson: Add InternalStockRequestInquiry.php script.
22/07/16 Exson: Make items search limited to the sales orders and if search
result is 1 show the result immediately in SelectSalesOrder.php
22/07/16 Exson: Add empty check for internal request to avoid empty request
creating in InternalStockRequest.php.
09/07/16 Exson: Fixed the utf8 character print incorrect of pdf file in
class.pdf.php.
08/07/16 Exson: Fixed the transaction atomicity bug by change table lock to
row lock in SQL_CommonFunctions.inc.
08/07/16 Exson: Fixed the bug that when bank account or currency changes the
functional rate or exrate unchanged with suggested rate in Payments.php.
07/07/16: Exson: Fixed the bug of wrong original amount of payments to
another bank accounts in GLAccountInquiry.php and wrong transaction link in
DailyBankTransactions.php and add payment transaction no in bank transaction
ref to make it traceable.
29/06/16 Exson: add identifier to avoid SESSION overwritten in
CustomerReceipt.php.
29/06/16 Exson: Fixed the wrong balance of amount in bank account currency
in DailyBankTransactions.php.
20/06/16 Exson: Fixed bom clone failure due to fields missing in
CopyBom.php. Reported by shane.
20/06/16 Exson: Fixed the bug that # is not allowed as part of stockid in
SelectProduct.php.
16/06/16 Exson: Make monthly payment term can be more than 30 days.
12/06/16 TurboPT: Fix syntax error in StockClone.php
08/06/16 Exson: add data label for SalesGraph.php.
23/11/16 RChacon: On AccountGroups.php, add navigation aids (return button).
08/11/16 RChacon: On WWW_Users.php, fix hardcoded label (difficult to
translate for languages with a different structure to English), do sortable
the users list, replace printf() with plain list echo, and add format class.
08/11/16 RChacon: Add scripts to show a statement of cash flows for the
period using the indirect method.
08/11/16 RChacon: On SelectSupplier.php, fix table html code.
06/11/16 RChacon: On SupplierPriceList.php, fix to show price in user's
locale format, add supplier's id and name to title, replace printf() with
plain list echo, and regroup and document code.
03/11/16 RChacon: On Dashboard.php, fix creditors payment to point to
allocation instead to payment, replace printf() with plain list echo,
regroup code, and complete column styles.
01/11/16 RChacon: On SupplierInquiry.php, replace the printf() statements
with echo statements to fix bug caused by a supplier invoice with a comment
that includes a % character (reported by R2-G, solution by Tim).
30/10/16 RChacon: In SecurityTokens.php: Fix Description's input maxlength,
fix table head in data table, move form-tables after data table, add cancel
button in edit form table, add return button, add style to print data table,
add title in form tables, regroup code, change from if/elseif to switch/case
to improve code readability, and add code documentation.
30/10/16 RChacon: On SupplierPriceList.php, add ViewTopic and BookMark, and
complete html table. Add info to manual.
17/10/16 Phil: Fix SQL in ReverseGRN.php as reported by Ricard/Tim.
16/10/16 RChacon: Fix function convertDate(dS,dF).
05/10/16 Eatong: Format the ManualAPITutorial.html for easier reading.
05/10/16 Eatong: Add CSS rule for <pre> for easier reading.
05/10/16 Eatong: Align field length of salesanalysis.salesperson to
salesman.salesmancode.
05/10/16 RChacon: Add cross.svg, next.svg, previous.svg, and tick.svg images
in Scalable Vector Graphics (SVG) format for general use (any size).
04/10/16 RChacon: In class.pdf.php, fix the function addJpegFromFile() use
of the functionality Image() of TCPDF class.
04/10/16 RChacon: In class.pdf.php, functions Rectangle() and
RoundRectangle() use the functionalities Rect() and RoundedRectXY() of TCPDF
class.
04/10/16 RChacon: Add return.svg image for Return button in Scalable Vector
Graphics (SVG) format.
27/09/16 RChacon: Add webERP logo in Scalable Vector Graphics format.
25/09/16 Exson: Make customer reference GET method workable in
SelectCompletedOrder.php. Fixed decimalplaces missing bug in
SelectOrderItems.php. Add due date, order date and customer reference option
in SelectSalesOrder.php.
25/09/16 Exson: Make the details show immediately when the search result is
one in SelectCompletedOrder.php.And add return links in OrderDetails.php.
24/10/16 Simon Kelly: Fixed placing POs for sales orders using array form
variable
24/09/16 waynemcdougall: Fixed missing date in Sales Price history
24/09/16 Exson: Make Justify feature workable in addTextWrap in
class.pdf.php.
24/09/16 Exson: Fixed the AddTextWrap missing characters errors when there
is space and make it more reliable.
21/09/16 RChacon: In SuppWhereAlloc.php, accepts the payment multiple
creditors. In CustWhereAlloc.php, accepts the receipt of multiple debtors.
18/09/16 RChacon: Add style to describe how button image should be
displayed. Clean up Xenos css.
18/09/16 Exson: Add multiple items issue for non-controlled items feature to
Work Orders in WorkOrderIssue.php.
14/09/16 Exson: Add narrative, transaction date data to
PDFOrdersInvoiced.php.
14/09/16 Exson: Add order line narrative and invoices link to sales order
inquiry in OrderDetails.php.
12/09/16 Exson: Add a filter to avoid tons of zero valued gl transaction
records generated in SQL_CommonFunctions.inc.
04/09/16 Exson: Add WO items delete constraint in WorkOrderEntry.php. Thanks
for Phil's reminder.
04/09/16 Exson: Add delete Work orders Items feature in WorkOrderEntry.php.
04/09/16 Exson: Fixed the undefined noise in WorkOrderStatus.php.
04/09/16 Exson: Fixed the bug that work order location will be wrong when
user select location which is not user's default location.
04/09/16 Dave Parrish fixed accumulated No of orders bug in
SalesByTypePeriodInquiry.php.
31/08/16 Exson: Addd new feature assign cash from one tab to another.
24/08/16 Exson: Fixed the latin1 charset mixed bug in supplierdiscounts
table;
24/9/16 Exson: Fixed the bug that days of payment terms in the following
month over 31 days can not be handled correctly in DateFunctions.inc.
20/08/16 RChacon: In ConfirmDispatch_Invoice.php, fix table html code.
18/08/16 RChacon: In PDFStatementPageHeader.inc, replace addJpegFromFile()
and RoundRectangle() functions from class.pdf.php with Image() and
RoundedRect() functions from tcpdf.php.
18/08/16 Exson: Add a Cancel button on SupplierAllocations.php to make user
can return to previous page easily.
18/08/16 Exson: Add date format validation in PcClaimExpensesFromTab.php.
17/8/16 RChacon committed for Tim: In CustWhereAlloc.php and
SuppWhereAlloc.php, use the ConvertSQLDate() function for the dates.
14/8/16 RChacon:In SuppWhereAlloc.php, show transaction date in report.
Improvements in HTML code and code documentation.
13/8/16 RChacon:In CustWhereAlloc.php, show transaction date in report.
Standardise trandate in debtortrans. Improvements in HTML code and code
documentation.
11/8/16 Phil: committed falkoners fix for the upgrade script - was not
adding the new field in customercontact required for the customer statements
email address
11/8/16 Simon Kelly: Fix SQL for location users in SelectSalesOrder.php
05/08/16 RChacon: In GLAccountInquiry.php, add noprint class to clean up
printer output and improve code documentation.
05/08/16 RChacon: Fix html code in SuppInvGRNs.php.
02/08/16 Exson: Make account inquiry shown directly when GL Code selected or
inquiry result is 1 in SelectGLAccount.php.
27/07/16 Exson: Add cost update date for material cost in
WorkOrderCosting.php and WorkOrderIssue.php.
27/07/16 Exson: Fixed the typo in Credit_Invoice.php introduced in previous
update.
27/07/16 Exson: Fixed the divided by zero error when discount is 100% in
SelectOrderItems.php.
27/07/16 Exson: Add error proof to avoid a blank credit note issued without
any items credited or freight charge input in Credit_Invoice.php.
25/07/16 Exson: Add InternalStockRequestInquiry.php script.
22/07/16 Exson: Make items search limited to the sales orders and if search
result is 1 show the result immediately in SelectSalesOrder.php
22/07/16 Exson: Add empty check for internal request to avoid empty request
creating in InternalStockRequest.php.
09/07/16 Exson: Fixed the utf8 character print incorrect of pdf file in
class.pdf.php.
08/07/16 Exson: Fixed the transaction atomicity bug by change table lock to
row lock in SQL_CommonFunctions.inc.
08/07/16 Exson: Fixed the bug that when bank account or currency changes the
functional rate or exrate unchanged with suggested rate in Payments.php.
07/07/16: Exson: Fixed the bug of wrong original amount of payments to
another bank accounts in GLAccountInquiry.php and wrong transaction link in
DailyBankTransactions.php and add payment transaction no in bank transaction
ref to make it traceable.
29/06/16 Exson: add identifier to avoid SESSION overwritten in
CustomerReceipt.php.
29/06/16 Exson: Fixed the wrong balance of amount in bank account currency
in DailyBankTransactions.php.
20/06/16 Exson: Fixed bom clone failure due to fields missing in
CopyBom.php. Reported by shane.
20/06/16 Exson: Fixed the bug that # is not allowed as part of stockid in
SelectProduct.php.
16/06/16 Exson: Make monthly payment term can be more than 30 days.
12/06/16 TurboPT: Fix syntax error in StockClone.php
08/06/16 Exson: add data label for SalesGraph.php.

           Thank you for all of you who have contribute the code, test it,
feedback to us! 

            Best regards!

            Exson
            



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/webERP4-13-1-released-tp4658730.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Shall we make a new release in November?

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

Hi,

Until new release, I will do only minor updates. That is:
* Improve translation (Spanish).
* Merge duplicated texts (e.g. "Number" and "Number:", to reduce translated
lines).

Also, if I have a well tested troubleshooting code, I will update it.

Best regards, Rafael.
----------
2016-10-31 7:27 GMT-06:00 Tim Schofield <tim...@gm...>:

> Hi Rafael, I have notified Phil and Exson privately as I am not
> allowed to post to the mailing list, and I have posted several bug
> reports with fixes to the forum. InternalStockRequestInquiry.php is
> one that springs to mind that I have emailed and posted about numerous
> times but the bugs remain. There was a recent fix I posted for a bug
> in SupplierInquiry.php on the forum. There were quite a few others,
> but I would have to search back and Phil and Exson have them.
>
> I sometimes think I have more influence on the project now than when I
> was the admin, all I have to do is to post a fix, or a new feature
> that has been requested and it is guaranteed not to be committed :-(
>
> Tim
>
> On 31 October 2016 at 13:02, Rafael Chacón
> <raf...@gm...> wrote:
> > Hi Tim,
> >
> > If we know what are those bugs, we can help to troubleshoot.
> >
> > Best regards, Rafael.
> >
> > 2016-10-31 2:01 GMT-06:00 Tim Schofield <tim...@gm...>:
> >>
> >> Hi Exson, there are several bugs I have reported to you that haven't
> >> been fixed. Are these going to be fixed in the next release?
> >>
> >> Tim
> >>
> >> On 31 October 2016 at 01:11, ExsonQu <hex...@gm...> wrote:
> >> > *Dear all,*
> >> >
> >> >                  I'd like to make a new release in November to meet
> the
> >> > six
> >> > months release circle.
> >> >
> >> >                  Any comments?
> >> >
> >> >                  Thanks and best regards!
> >> >                  Exson
> >> >
> >> >
> >> >
> >> > --
> >> > View this message in context:
> >> > http://weberp-accounting.1478800.n4.nabble.com/Shall-we-
> make-a-new-release-in-November-tp4658719.html
> >> > Sent from the web-ERP-developers mailing list archive at Nabble.com.
> >> >
> >> >
> >> > ------------------------------------------------------------
> ------------------
> >> > The Command Line: Reinvented for Modern Developers
> >> > Did the resurgence of CLI tooling catch you by surprise?
> >> > Reconnect with the command line and become more productive.
> >> > Learn the new .NET and ASP.NET CLI. Get your free copy!
> >> > http://sdm.link/telerik
> >> > _______________________________________________
> >> > Web-erp-developers mailing list
> >> > Web...@li...
> >> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >>
> >>
> >>
> >> --
> >>
> >> www.weberpafrica.com
> >> Twitter: @TimSchofield2
> >> Blog: http://weberpafrica.blogspot.co.uk/
> >
> >
>
>
>
> --
> Course View Towers,
> Plot 21 Yusuf Lule Road,
> Kampala
> T   +256 (0) 312 314 418
> M +256 (0) 752 963 325
> www.weberpafrica.com
> Twitter: @TimSchofield2
> Blog: http://weberpafrica.blogspot.co.uk/
>

Re: [WebERP-developers] Shall we make a new release in November?

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

Hi,

Until new release, I will do only minor updates. That is:
* Improve translation (Spanish).
* Merge duplicated texts (e.g. "Number" and "Number:", to reduce translated
lines).

Also, if I have a well tested troubleshooting code, I will update it.

Best regards, Rafael.
----------
2016-10-31 7:27 GMT-06:00 Tim Schofield <tim...@gm...>:

> Hi Rafael, I have notified Phil and Exson privately as I am not
> allowed to post to the mailing list, and I have posted several bug
> reports with fixes to the forum. InternalStockRequestInquiry.php is
> one that springs to mind that I have emailed and posted about numerous
> times but the bugs remain. There was a recent fix I posted for a bug
> in SupplierInquiry.php on the forum. There were quite a few others,
> but I would have to search back and Phil and Exson have them.
>
> I sometimes think I have more influence on the project now than when I
> was the admin, all I have to do is to post a fix, or a new feature
> that has been requested and it is guaranteed not to be committed :-(
>
> Tim
>
> On 31 October 2016 at 13:02, Rafael Chacón
> <raf...@gm...> wrote:
> > Hi Tim,
> >
> > If we know what are those bugs, we can help to troubleshoot.
> >
> > Best regards, Rafael.
> >
> > 2016-10-31 2:01 GMT-06:00 Tim Schofield <tim...@gm...>:
> >>
> >> Hi Exson, there are several bugs I have reported to you that haven't
> >> been fixed. Are these going to be fixed in the next release?
> >>
> >> Tim
> >>
> >> On 31 October 2016 at 01:11, ExsonQu <hex...@gm...> wrote:
> >> > *Dear all,*
> >> >
> >> >                  I'd like to make a new release in November to meet
> the
> >> > six
> >> > months release circle.
> >> >
> >> >                  Any comments?
> >> >
> >> >                  Thanks and best regards!
> >> >                  Exson
> >> >
> >> >
> >> >
> >> > --
> >> > View this message in context:
> >> > http://weberp-accounting.1478800.n4.nabble.com/Shall-
> we-make-a-new-release-in-November-tp4658719.html
> >> > Sent from the web-ERP-developers mailing list archive at Nabble.com.
> >> >
> >> >
> >> > ------------------------------------------------------------
> ------------------
> >> > The Command Line: Reinvented for Modern Developers
> >> > Did the resurgence of CLI tooling catch you by surprise?
> >> > Reconnect with the command line and become more productive.
> >> > Learn the new .NET and ASP.NET CLI. Get your free copy!
> >> > http://sdm.link/telerik
> >> > _______________________________________________
> >> > Web-erp-developers mailing list
> >> > Web...@li...
> >> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >>
> >>
> >>
> >> --
> >>
> >> www.weberpafrica.com
> >> Twitter: @TimSchofield2
> >> Blog: http://weberpafrica.blogspot.co.uk/
> >
> >
>
>
>
> --
> Course View Towers,
> Plot 21 Yusuf Lule Road,
> Kampala
> T   +256 (0) 312 314 418
> M +256 (0) 752 963 325
> www.weberpafrica.com
> Twitter: @TimSchofield2
> Blog: http://weberpafrica.blogspot.co.uk/
>

Re: [WebERP-developers] Replace printf() with plain list echo

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

Relaxed either way ... its a Do-ocracy

https://communitywiki.org/wiki/DoOcracy

Phil

On 2016-11-06 13:23, Rafael Chacón wrote:
> Hi,
> 
> When i was fixing SupplierInquiry.php, I had to replace printf() with
> plain list echo using single-quotes. The reason is that printf() uses
> % characters as "special" characters (e.g. when the text to print has
> a ""Includes a 25% discount" character).
> 
> Also, I replaced  printf() with plain list echo using single-quotes in
> Dashboard.php and SupplierPriceList.php.
> 
> The results are: less lines, a little less time, and "more readable"
> code. The last one, is my personal opinion.
> 
> If all agree, it is better to continue using a plain list echo using
> single-quotes instead a printf().
> 
> Comments ?
> 
> Best regards, Rafael.
> 

[WebERP-developers] Replace printf() with plain list echo

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

Hi,

When i was fixing SupplierInquiry.php, I had to replace printf() with plain
list echo using single-quotes. The reason is that printf() uses %
characters as "special" characters (e.g. when the text to print has a
""Includes
a 25% discount" character).

Also, I replaced  printf() with plain list echo using single-quotes in
Dashboard.php and SupplierPriceList.php.

The results are: less lines, a little less time, and "more readable" code.
The last one, is my personal opinion.

If all agree, it is better to continue using a plain list echo using
single-quotes instead a printf().

Comments ?

Best regards, Rafael.

Re: [WebERP-developers] Shall we make a new release in November?

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

Hi Tim,

If we know what are those bugs, we can help to troubleshoot.

Best regards, Rafael.

2016-10-31 2:01 GMT-06:00 Tim Schofield <tim...@gm...>:

> Hi Exson, there are several bugs I have reported to you that haven't
> been fixed. Are these going to be fixed in the next release?
>
> Tim
>
> On 31 October 2016 at 01:11, ExsonQu <hex...@gm...> wrote:
> > *Dear all,*
> >
> >                  I'd like to make a new release in November to meet the
> six
> > months release circle.
> >
> >                  Any comments?
> >
> >                  Thanks and best regards!
> >                  Exson
> >
> >
> >
> > --
> > View this message in context: http://weberp-accounting.
> 1478800.n4.nabble.com/Shall-we-make-a-new-release-in-
> November-tp4658719.html
> > Sent from the web-ERP-developers mailing list archive at Nabble.com.
> >
> > ------------------------------------------------------------
> ------------------
> > The Command Line: Reinvented for Modern Developers
> > Did the resurgence of CLI tooling catch you by surprise?
> > Reconnect with the command line and become more productive.
> > Learn the new .NET and ASP.NET CLI. Get your free copy!
> > http://sdm.link/telerik
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
> --
>
> www.weberpafrica.com
> Twitter: @TimSchofield2
> Blog: http://weberpafrica.blogspot.co.uk/
>

Re: [WebERP-developers] Shall we make a new release in November?

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

Hi all:

OK for me.

I don't remember exactly, but there was the issue of modified PDF standard
libraries. Was it already sorted out?

Also, we have to fix (or delay the  release) for the Assign Cash issue of
commit 7605 (it can lead to accounting errors).

Regards,
Ricard

2016-10-31 10:53 GMT+08:00 ExsonQu <hex...@gm...>:

> *Hi, Phil,*
>
>                    I'll do the new release in Nov if there is no any
> objection.
>
>                    Some new features will be added and some bugs will be
> fixed before the new release.
>
>                    Thanks and best regards!
>
>                    Exson
>
>
>
> --
> View this message in context: http://weberp-accounting.
> 1478800.n4.nabble.com/Shall-we-make-a-new-release-in-
> November-tp4658719p4658722.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------
> ------------------
> The Command Line: Reinvented for Modern Developers
> Did the resurgence of CLI tooling catch you by surprise?
> Reconnect with the command line and become more productive.
> Learn the new .NET and ASP.NET CLI. Get your free copy!
> http://sdm.link/telerik
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] Shall we make a new release in November?

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

*Hi, Phil,*

                   I'll do the new release in Nov if there is no any
objection. 

                   Some new features will be added and some bugs will be
fixed before the new release. 

                   Thanks and best regards!

                   Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Shall-we-make-a-new-release-in-November-tp4658719p4658722.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Shall we make a new release in November?

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

Sounds good to me ... do you want to do this one Exson?

Phil

On 2016-10-30 20:36, Rafael Chacón wrote:
> Hi,
> 
> I agree!! It is a good idea to have a release every 6 months.
> 
> I will close my works-in-process to redirect efforts to test the trunk
> code.
> 
> Thanks and best regards! Rafael.
> 
> 2016-10-30 19:11 GMT-06:00 ExsonQu <hex...@gm...>:
> 
>> *Dear all,*
>> 
>> I'd like to make a new release in November to meet
>> the six
>> months release circle.
>> 
>> Any comments?
>> 
>> Thanks and best regards!
>> Exson
>> 
>> --
>> View this message in context:
>> 
> http://weberp-accounting.1478800.n4.nabble.com/Shall-we-make-a-new-release-in-November-tp4658719.html
>> [1]
>> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>> 
>> 
> ------------------------------------------------------------------------------
>> The Command Line: Reinvented for Modern Developers
>> Did the resurgence of CLI tooling catch you by surprise?
>> Reconnect with the command line and become more productive.
>> Learn the new .NET and ASP.NET [2] CLI. Get your free copy!
>> http://sdm.link/telerik
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers [3]
> 
> 
> 
> Links:
> ------
> [1]
> http://weberp-accounting.1478800.n4.nabble.com/Shall-we-make-a-new-release-in-November-tp4658719.html
> [2] http://ASP.NET
> [3] https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> 
> ------------------------------------------------------------------------------
> The Command Line: Reinvented for Modern Developers
> Did the resurgence of CLI tooling catch you by surprise?
> Reconnect with the command line and become more productive.
> Learn the new .NET and ASP.NET CLI. Get your free copy!
> http://sdm.link/telerik
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] Shall we make a new release in November?

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

Hi,

I agree!! It is a good idea to have a release every 6 months.

I will close my works-in-process to redirect efforts to test the trunk code.

Thanks and best regards! Rafael.


2016-10-30 19:11 GMT-06:00 ExsonQu <hex...@gm...>:

> *Dear all,*
>
>                  I'd like to make a new release in November to meet the six
> months release circle.
>
>                  Any comments?
>
>                  Thanks and best regards!
>                  Exson
>
>
>
> --
> View this message in context: http://weberp-accounting.
> 1478800.n4.nabble.com/Shall-we-make-a-new-release-in-
> November-tp4658719.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------
> ------------------
> The Command Line: Reinvented for Modern Developers
> Did the resurgence of CLI tooling catch you by surprise?
> Reconnect with the command line and become more productive.
> Learn the new .NET and ASP.NET CLI. Get your free copy!
> http://sdm.link/telerik
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

[WebERP-developers] Shall we make a new release in November?

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

*Dear all,*

                 I'd like to make a new release in November to meet the six
months release circle. 

                 Any comments?

                 Thanks and best regards!
                 Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Shall-we-make-a-new-release-in-November-tp4658719.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] About MiscFunctions.js

[Jon R <jr...@gm...>]

If the headers are setup right each of the supporting files can be cached
client side so there would actually be less overhead...

On 19 Oct 2016 6:58 am, "Girish Nair" <get...@gm...> wrote:

>
> I would suggest to keep the code beautifully formatted and adding as much
> comments needed which will be helpful to developers.
>
> Generally the practice is to minify the js/css files and generate
> filename-min.js/filename-min.css, this can be committed along with the
> original one for every build, Also, there should be an  easy way to switch
> between the non-minified/minified version.
>
> Some useful tools to minify:
> https://github.com/tedious/JShrink
> https://github.com/mishoo/UglifyJS2
> http://yui.github.io/yuicompressor/
> http://www.crockford.com/javascript/jsmin.html
> There are many more...
>
>
> On a production server these optimizations can be used:
> Enabling gzip compression on the webserver(Apache/nginx) etc will reduce
> the overall download size for all files: js, css, html etc.
> http://howtounix.info/howto/Apache-gzip-compression-with-mod_deflate
>
> Configure the pagespeed module (by Google)
> https://developers.google.com/speed/pagespeed/module/
>
>
> Compression results from the JShrink doc:
>     Raw - 586,990
>     Gzip - 151,301
>     JShrink - 371,982
>     JShrink and Gzip - 93,507
>
>
> hope this info is useful.
>
> Girish,
> InfraStack-Labs.com
>
>
> On Wed, Oct 19, 2016 at 3:29 AM, gilberto dos santos alves <
> gs...@gm...> wrote:
>
>> +1 from me to min javascripts. documentation must be inside manuals. see
>> refs about  on javadocs that is large used. restructured text like sphinx
>> could be used to build php python java c++ or any other language. see that
>> current texts inside weberp sources already can be handled for this.
>> it is like .pot and .mo files for translations.
>> uml diagrams  could enhance docs  for devellopment.
>> regards.
>>
>> Em 18/10/2016 16:15, "Rafael Chacón" <raf...@gm...>
>> escreveu:
>>
>> Hi,
>>
>> Recently, I updated the file MiscFunctions.js. I added comments and
>> improve the format. Now it is more easy to understand the code.
>>
>> But it has a big disadvantage: Each html page generated by the webERP
>> loads that file through ~/includes/header.inc. That is: if we add comments
>> and reformat the code to make it very easy to understand, we increase the
>> traffic of that file to about 239% (more comments and spaces in formatting
>> code).
>>
>> Someone say me that he prefers a minimum file size to prioritise the
>> principle "low footprint" (absolutely minimal network traffic) over to
>> "easily readable", because this file is modified infrequently. That is: to
>> have a MiscFunctions.js without comments (explanations) and put them in the
>> manual. Also, to remove the spacing for easy reading.
>>
>> I agree. But, if we are strict, that "minimising" principle should apply
>> to all JavaScript, CSS and HTML code.
>>
>> Comments? Opinions?
>>
>> Best regards, Rafael.
>>
>> ------------------------------------------------------------
>> ------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>>
>> ------------------------------------------------------------
>> ------------------
>> Check out the vibrant tech community on one of the world's most
>> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] About MiscFunctions.js

[Girish N. <get...@gm...>]

I would suggest to keep the code beautifully formatted and adding as much
comments needed which will be helpful to developers.

Generally the practice is to minify the js/css files and generate
filename-min.js/filename-min.css, this can be committed along with the
original one for every build, Also, there should be an  easy way to switch
between the non-minified/minified version.

Some useful tools to minify:
https://github.com/tedious/JShrink
https://github.com/mishoo/UglifyJS2
http://yui.github.io/yuicompressor/
http://www.crockford.com/javascript/jsmin.html
There are many more...


On a production server these optimizations can be used:
Enabling gzip compression on the webserver(Apache/nginx) etc will reduce
the overall download size for all files: js, css, html etc.
http://howtounix.info/howto/Apache-gzip-compression-with-mod_deflate

Configure the pagespeed module (by Google)
https://developers.google.com/speed/pagespeed/module/


Compression results from the JShrink doc:
    Raw - 586,990
    Gzip - 151,301
    JShrink - 371,982
    JShrink and Gzip - 93,507


hope this info is useful.

Girish,
InfraStack-Labs.com


On Wed, Oct 19, 2016 at 3:29 AM, gilberto dos santos alves <gs...@gm...
> wrote:

> +1 from me to min javascripts. documentation must be inside manuals. see
> refs about  on javadocs that is large used. restructured text like sphinx
> could be used to build php python java c++ or any other language. see that
> current texts inside weberp sources already can be handled for this.
> it is like .pot and .mo files for translations.
> uml diagrams  could enhance docs  for devellopment.
> regards.
>
> Em 18/10/2016 16:15, "Rafael Chacón" <raf...@gm...>
> escreveu:
>
> Hi,
>
> Recently, I updated the file MiscFunctions.js. I added comments and
> improve the format. Now it is more easy to understand the code.
>
> But it has a big disadvantage: Each html page generated by the webERP
> loads that file through ~/includes/header.inc. That is: if we add comments
> and reformat the code to make it very easy to understand, we increase the
> traffic of that file to about 239% (more comments and spaces in formatting
> code).
>
> Someone say me that he prefers a minimum file size to prioritise the
> principle "low footprint" (absolutely minimal network traffic) over to
> "easily readable", because this file is modified infrequently. That is: to
> have a MiscFunctions.js without comments (explanations) and put them in the
> manual. Also, to remove the spacing for easy reading.
>
> I agree. But, if we are strict, that "minimising" principle should apply
> to all JavaScript, CSS and HTML code.
>
> Comments? Opinions?
>
> Best regards, Rafael.
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] About MiscFunctions.js

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

+1 from me to min javascripts. documentation must be inside manuals. see
refs about  on javadocs that is large used. restructured text like sphinx
could be used to build php python java c++ or any other language. see that
current texts inside weberp sources already can be handled for this.
it is like .pot and .mo files for translations.
uml diagrams  could enhance docs  for devellopment.
regards.

Em 18/10/2016 16:15, "Rafael Chacón" <raf...@gm...>
escreveu:

Hi,

Recently, I updated the file MiscFunctions.js. I added comments and improve
the format. Now it is more easy to understand the code.

But it has a big disadvantage: Each html page generated by the webERP loads
that file through ~/includes/header.inc. That is: if we add comments and
reformat the code to make it very easy to understand, we increase the
traffic of that file to about 239% (more comments and spaces in formatting
code).

Someone say me that he prefers a minimum file size to prioritise the
principle "low footprint" (absolutely minimal network traffic) over to
"easily readable", because this file is modified infrequently. That is: to
have a MiscFunctions.js without comments (explanations) and put them in the
manual. Also, to remove the spacing for easy reading.

I agree. But, if we are strict, that "minimising" principle should apply to
all JavaScript, CSS and HTML code.

Comments? Opinions?

Best regards, Rafael.

------------------------------------------------------------
------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] About MiscFunctions.js

[Andrew G. <aga...@re...>]

I vote no added comments but spaces in code if that isn't too much overhead.


From: Phil Daintree [mailto:ph...@lo...]
Sent: Tuesday, October 18, 2016 2:23 PM
To: webERP Developers
Subject: Re: [WebERP-developers] About MiscFunctions.js


There is a bit of a double standard there I agree ... I think Tim even used single letter variable names etc to minimise the overhead.

I also like readable and there is a compromise position ... you decide where that is Rafael.

Phil



Phil Daintree

Logic Works Ltd - +64 (0)275 567890

http://www.logicworks.co.nz
On 19/10/16 07:09, Rafael Chacón wrote:
Hi,

Recently, I updated the file MiscFunctions.js. I added comments and improve the format. Now it is more easy to understand the code.
l
But it has a big disadvantage: Each html page generated by the webERP loads that file through ~/includes/header.inc. That is: if we add comments and reformat the code to make it very easy to understand, we increase the traffic of that file to about 239% (more comments and spaces in formatting code).

Someone say me that he prefers a minimum file size to prioritise the principle "low footprint" (absolutely minimal network traffic) over to "easily readable", because this file is modified infrequently. That is: to have a MiscFunctions.js without comments (explanations) and put them in the manual. Also, to remove the spacing for easy reading.

I agree. But, if we are strict, that "minimising" principle should apply to all JavaScript, CSS and HTML code.

Comments? Opinions?

Best regards, Rafael.




------------------------------------------------------------------------------

Check out the vibrant tech community on one of the world's most

engaging tech sites, SlashDot.org! http://sdm.link/slashdot




_______________________________________________

Web-erp-developers mailing list

Web...@li...<mailto:Web...@li...>

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

Re: [WebERP-developers] About MiscFunctions.js

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

There is a bit of a double standard there I agree ... I think Tim even 
used single letter variable names etc to minimise the overhead.

I also like readable and there is a compromise position ... you decide 
where that is Rafael.

Phil

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

On 19/10/16 07:09, Rafael Chacón wrote:
> Hi,
>
> Recently, I updated the file MiscFunctions.js. I added comments and 
> improve the format. Now it is more easy to understand the code.
> l
> But it has a big disadvantage: Each html page generated by the webERP 
> loads that file through ~/includes/header.inc. That is: if we add 
> comments and reformat the code to make it very easy to understand, we 
> increase the traffic of that file to about 239% (more comments and 
> spaces in formatting code).
>
> Someone say me that he prefers a minimum file size to prioritise the 
> principle "low footprint" (absolutely minimal network traffic) over to 
> "easily readable", because this file is modified infrequently. That 
> is: to have a MiscFunctions.js without comments (explanations) and put 
> them in the manual. Also, to remove the spacing for easy reading.
>
> I agree. But, if we are strict, that "minimising" principle should 
> apply to all JavaScript, CSS and HTML code.
>
> Comments? Opinions?
>
> Best regards, Rafael.
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

[WebERP-developers] About MiscFunctions.js

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

Hi,

Recently, I updated the file MiscFunctions.js. I added comments and improve
the format. Now it is more easy to understand the code.

But it has a big disadvantage: Each html page generated by the webERP loads
that file through ~/includes/header.inc. That is: if we add comments and
reformat the code to make it very easy to understand, we increase the
traffic of that file to about 239% (more comments and spaces in formatting
code).

Someone say me that he prefers a minimum file size to prioritise the
principle "low footprint" (absolutely minimal network traffic) over to
"easily readable", because this file is modified infrequently. That is: to
have a MiscFunctions.js without comments (explanations) and put them in the
manual. Also, to remove the spacing for easy reading.

I agree. But, if we are strict, that "minimising" principle should apply to
all JavaScript, CSS and HTML code.

Comments? Opinions?

Best regards, Rafael.

Re: [WebERP-developers] Calendar in input field.

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

Gilberto, Tim and Phil:

Thank you, very much for your help. I fixed the function convertDate(dS,dF)
in ~/javascripts/MiscFunctions.js.

Best regards, Rafael.


2016-10-16 18:32 GMT-06:00 Phil Daintree <ph...@lo...>:

> The JavaScript function isDaye() in JavaScript miscfumctions.js
>
> Phil
> Phil Daintree
> +64 (0)275 567 890
>
> On 17/10/2016, at 11:27 AM, gilberto dos santos alves <gs...@gm...>
> wrote:
>
> see what locale your server is using for inference format currencies ...
> decimals and dayes. this is hard coded inside default functions. look at
> sources.
>
> Em 16/10/2016 18:18, "Rafael Chacón" <raf...@gm...>
> escreveu:
>
> Hello,
>
> The calendar in input field "<input alt="$_SESSION['DefaultDateFormat']"
> class="date" maxlength="10" name="DateBanked" onchange="isDate(this.value,
> '$_SESSION['DefaultDateFormat']')" required="required" size="10"
> tabindex="2" type="text" value="$FormatedValue" /> works with formats "
> d/m/Y", "d.m.Y", "m/d/Y", and "Y/m/d", but it does not work with format "
> Y-m-d". That is: calendar does not go to the date displayed in the field.
>
> Anyone have any idea where could be the problem?
>
> Best regards, Rafael.
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] Calendar in input field.

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

The JavaScript function isDaye() in JavaScript miscfumctions.js

Phil
Phil Daintree
+64 (0)275 567 890

> On 17/10/2016, at 11:27 AM, gilberto dos santos alves <gs...@gm...> wrote:
> 
> see what locale your server is using for inference format currencies ... decimals and dayes. this is hard coded inside default functions. look at sources.
> 
> 
> Em 16/10/2016 18:18, "Rafael Chacón" <raf...@gm...> escreveu:
> Hello,
> 
> The calendar in input field "<input alt="$_SESSION['DefaultDateFormat']" class="date" maxlength="10" name="DateBanked" onchange="isDate(this.value, '$_SESSION['DefaultDateFormat']')" required="required" size="10" tabindex="2" type="text" value="$FormatedValue" /> works with formats "d/m/Y", "d.m.Y", "m/d/Y", and "Y/m/d", but it does not work with format "Y-m-d". That is: calendar does not go to the date displayed in the field.
> 
> Anyone have any idea where could be the problem?
> 
> Best regards, Rafael.
> 
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> 
> 
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most 
> engaging tech sites, SlashDot.org! http://sdm.link/slashdot
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] Calendar in input field.

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

see what locale your server is using for inference format currencies ...
decimals and dayes. this is hard coded inside default functions. look at
sources.

Em 16/10/2016 18:18, "Rafael Chacón" <raf...@gm...>
escreveu:

Hello,

The calendar in input field "<input alt="$_SESSION['DefaultDateFormat']"
class="date" maxlength="10" name="DateBanked" onchange="isDate(this.value,
'$_SESSION['DefaultDateFormat']')" required="required" size="10"
tabindex="2" type="text" value="$FormatedValue" /> works with formats "d/m/Y",
"d.m.Y", "m/d/Y", and "Y/m/d", but it does not work with format "Y-m-d".
That is: calendar does not go to the date displayed in the field.

Anyone have any idea where could be the problem?

Best regards, Rafael.

------------------------------------------------------------
------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

[WebERP-developers] Calendar in input field.

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

Hello,

The calendar in input field "<input alt="$_SESSION['DefaultDateFormat']"
class="date" maxlength="10" name="DateBanked" onchange="isDate(this.value,
'$_SESSION['DefaultDateFormat']')" required="required" size="10"
tabindex="2" type="text" value="$FormatedValue" /> works with formats "d/m/Y",
"d.m.Y", "m/d/Y", and "Y/m/d", but it does not work with format "Y-m-d".
That is: calendar does not go to the date displayed in the field.

Anyone have any idea where could be the problem?

Best regards, Rafael.

[WebERP-developers] Purchase order printing problems - PO_PDFPurchOrder.php

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

There are several problems with PO_PDFPurchOrder.php script.

1) When we create a purchase order, order detail lines are sorted by
itemcode.  This creates problems when ordering non-inventory items. 
Additionally the order of printing does not match the order of entry.  For
non-inventory items (no itemcode), the order of detail items is random
(undefined).  We have several very lengthy PO's for which every item/service
is one time purchase abd the order of items on the Purchase order needs to
match vendor quote as closely as possible.
2) There is always one to many lines in the detail printout per page.

We have made the following changes to PO_PDFPurchOrder.php:

Around line 223 replace itemcode to podetailitem:

				WHERE orderno ='" . $OrderNo . "'
				ORDER BY podetailitem";	/*- ADDED: Sort by our item code -*/

Around line 275:

				if ($YPos - 2*$line_height <= $Bottom_Margin) {

Around line 292:

				if ($YPos - 2*$line_height <= $Bottom_Margin) {

Our default paper size is Letter.  We hope that these changes could be
incorporated into the trunk.

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Purchase-order-printing-problems-PO-PDFPurchOrder-php-tp4658708.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] [Web-erp-svn] SF.net SVN: web-erp:[7605] trunk

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

*Hi, Richard,*

             Thank you for review the script. 
             I've overlook the multiple currency situation. 
             The scenario for this is that sometime manager has no time to
assign money to members under him. So he assigned all of those money to a
clerk and then the clerk allocate the money to other members. 
             I'll find sometime to check the multiple currency issue later. 
             My notebook just be recovered from network card problem, sorry
for the late reply.
             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-7605-trunk-tp4658706p4658707.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] [Web-erp-svn] SF.net SVN: web-erp:[7605] trunk

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

Hi Exson:

Sorry for the delay, but just today I checked this new script and I think
it has a major issue (that can lead to accounting errors): it is not
multicurrency-coded.

It allows to transfer amounts from any currency tab to ant other, without
the proper exchange rates. We could move 1.000.000 IDR into 1.000.000 USD,
which would be nice but it's not correct.

Probably restricting the "Tab To" drop down list to the tabs with the same
currency as the "from" would do the trick, as we probably don't want
employees to run their own exchange-currency side-business.

Also, could you please let us know which is the situation where this script
is used? If company assigns X money to user A and Y money to user B, is it
ok for user A to send money to user B? Why not company assigning less to A
and more to B? Or is there any situation I'm missing?



Regards,
Ricard

2016-08-31 18:58 GMT+08:00 Tim Schofield <tim...@gm...>:

> Hi Exson, what is the use case for this script? Is it wise to have
> funds allocated for one purpose to then be transferred for another
> completely different use?
>
> Tim
>
> On 31 August 2016 at 07:32,  <ex...@us...> wrote:
> > Revision: 7605
> >           http://sourceforge.net/p/web-erp/reponame/7605
> > Author:   exsonqu
> > Date:     2016-08-31 06:32:57 +0000 (Wed, 31 Aug 2016)
> > Log Message:
> > -----------
> > 31/08/16 Exson: Addd new feature assign cash from one tab to another.
> >
> > Modified Paths:
> > --------------
> >     trunk/includes/MainMenuLinksArray.php
> >     trunk/sql/mysql/upgrade4.13-4.13.1.sql
> >
> > Added Paths:
> > -----------
> >     trunk/PcAssignCashTabToTab.php
> >
> > Added: trunk/PcAssignCashTabToTab.php
> > ===================================================================
> > --- trunk/PcAssignCashTabToTab.php                              (rev 0)
> > +++ trunk/PcAssignCashTabToTab.php      2016-08-31 06:32:57 UTC (rev
> 7605)
> > @@ -0,0 +1,393 @@
> > +<?php
> > +
> > +include('includes/session.inc');
> > +$Title = _('Assignment of Cash From Tab To Tab');
> > +/* webERP manual links before header.inc */
> > +$ViewTopic= 'PettyCash';
> > +$BookMark = 'CashAssignment';
> > +include('includes/header.inc');
> > +
> > +if (isset($_POST['SelectedTabs'])){
> > +       $SelectedTabs = mb_strtoupper($_POST['SelectedTabs']);
> > +} elseif (isset($_GET['SelectedTabs'])){
> > +       $SelectedTabs = mb_strtoupper($_GET['SelectedTabs']);
> > +}
> > +
> > +if (isset($_POST['Days'])){
> > +       $Days = $_POST['Days'];
> > +} elseif (isset($_GET['Days'])){
> > +       $Days = $_GET['Days'];
> > +}
> > +
> > +if (isset($_POST['Cancel'])) {
> > +       unset($SelectedTabs);
> > +       unset($Days);
> > +       unset($_POST['Amount']);
> > +       unset($_POST['Notes']);
> > +       unset($_POST['Receipt']);
> > +}
> > +
> > +if (isset($_POST['Process'])) {
> > +       if ($SelectedTabs=='') {
> > +               prnMsg(_('You Must First Select a Petty Cash Tab To
> Assign Cash'),'error');
> > +               unset($SelectedTabs);
> > +       }
> > +       if ($SelectedTabs == mb_strtoupper($_POST['SelectedTabsTo'])) {
> > +               prnMsg(_('The Tab selected From should not be the same
> as the selected To'),'error');
> > +               unset($SelectedTabs);
> > +               unset($_POST['SelectedTabsTo']);
> > +               unset($_POST['Process']);
> > +       }
> > +}
> > +
> > +if (isset($_POST['Go'])) {
> > +       $InputError = 0;
> > +       if ($Days<=0) {
> > +               $InputError = 1;
> > +               prnMsg(_('The number of days must be a positive
> number'),'error');
> > +               $Days=30;
> > +       }
> > +}
> > +
> > +if (isset($_POST['submit'])) {
> > +       //initialise no input errors assumed initially before we test
> > +       $InputError = 0;
> > +
> > +       echo '<p class="page_title_text"><img src="'.$RootPath.'/css/'.$Theme.'/images/money_add.png"
> title="' .
> > +               _('Search') . '" alt="" />' . ' ' . $Title. '</p>';
> > +
> > +       /* actions to take once the user has clicked the submit button
> > +       ie the page has called itself with some user input */
> > +
> > +       $i=1;
> > +
> > +       if ($_POST['Amount']==0) {
> > +               $InputError = 1;
> > +               prnMsg('<br />' . _('The Amount must be input'),'error');
> > +       }
> > +
> > +       $sqlLimit = "SELECT tablimit,tabcode
> > +                               FROM pctabs
> > +                               WHERE tabcode IN ('" . $SelectedTabs .
> "','" . $_POST['SelectedTabsTo'] . "')";
> > +
> > +       $ResultLimit = DB_query($sqlLimit,$db);
> > +       while ($LimitRow=DB_fetch_array($ResultLimit)){
> > +               if ($LimitRow['tabcode'] == $SelectedTabs) {
> > +                       if (($_POST['CurrentAmount']+$_
> POST['Amount'])>$LimitRow['tablimit']){
> > +                               $InputError = 1;
> > +                               prnMsg(_('The balance after this
> assignment would be greater than the specified limit for this PC tab') . '
> ' . $LimitRow[1],'error');
> > +                       }
> > +               }  elseif ($_POST['SelectedTabsToAmt'] -
> $_POST['Amount']>$LimitRow['tablimit']) {
> > +                               $InputError = 1;
> > +                               prnMsg(_('The balance after this
> assignment would be greater than the specified limit for this PC tab') . '
> ' . $LimitRow[1],'error');
> > +               }
> > +       }
> > +
> > +       if ($InputError !=1 ) {
> > +               // Add these 2 new record on submit
> > +               $sql = "INSERT INTO pcashdetails
> > +                                       (counterindex,
> > +                                       tabcode,
> > +                                       date,
> > +                                       codeexpense,
> > +                                       amount,
> > +                                       authorized,
> > +                                       posted,
> > +                                       notes,
> > +                                       receipt)
> > +                       VALUES (NULL,
> > +                                       '" . $_POST['SelectedTabs'] . "',
> > +                                       '".FormatDateForSQL($_POST['
> Date'])."',
> > +                                       'ASSIGNCASH',
> > +                                       '" .
> filter_number_format($_POST['Amount']) . "',
> > +                                       '0000-00-00',
> > +                                       '0',
> > +                                       '" . $_POST['Notes'] . "',
> > +                                       '" . $_POST['Receipt'] . "'
> > +                               ),
> > +                               (NULL,
> > +                                       '" . $_POST['SelectedTabsTo'] .
> "',
> > +                                       '" .
> FormatDateForSQL($_POST['Date']) . "',
> > +                                       'ASSIGNCASH',
> > +                                       '" .
> filter_number_format(-$_POST['Amount']) . "',
> > +                                       '0000-00-00',
> > +                                       '0',
> > +                                       '" . $_POST['Notes'] . "',
> > +                                       '" . $_POST['Receipt'] . "')";
> > +               $msg = _('Assignment of cash from PC Tab ') . ' ' .
> $_POST['SelectedTabs'] .  ' ' . _('to') . $_POST['SelectedTabsTo'] . ' ' .
> _('has been created');
> > +       }
> > +
> > +       if ( $InputError !=1) {
> > +               //run the SQL from either of the above possibilites
> > +               $result = DB_query($sql,$db);
> > +               prnMsg($msg,'success');
> > +               unset($_POST['SelectedExpense']);
> > +               unset($_POST['Amount']);
> > +               unset($_POST['Notes']);
> > +               unset($_POST['Receipt']);
> > +               unset($_POST['SelectedTabs']);
> > +               unset($_POST['Date']);
> > +       }
> > +
> > +}
> > +
> > +if (!isset($SelectedTabs)){
> > +
> > +       echo '<p class="page_title_text"><img src="'.$RootPath.'/css/'.$Theme.'/images/money_add.png"
> title="' .
> > +               _('Search') . '" alt="" />' . ' ' . $Title. '</p>';
> > +
> > +       echo '<form method="post" action="' . htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8')
> . '">';
> > +    echo '<div>';
> > +       echo '<input type="hidden" name="FormID" value="' .
> $_SESSION['FormID'] . '" />';
> > +
> > +       $SQL = "SELECT tabcode
> > +                       FROM pctabs
> > +                       WHERE assigner='" . $_SESSION['UserID'] . "'
> > +                       ORDER BY tabcode";
> > +
> > +       $result = DB_query($SQL,$db);
> > +
> > +    echo '<br /><table class="selection">'; //Main table
> > +
> > +    echo '<tr><td>' . _('Petty Cash Tab To Assign Cash From') . ':</td>
> > +            <td><select name="SelectedTabs">';
> > +       while ($myrow = DB_fetch_array($result)) {
> > +               if (isset($_POST['SelectTabs']) and
> $myrow['tabcode']==$_POST['SelectTabs']) {
> > +                       echo '<option selected="selected" value="';
> > +               } else {
> > +                       echo '<option value="';
> > +               }
> > +               echo $myrow['tabcode'] . '">' . $myrow['tabcode'] .
> '</option>';
> > +       }
> > +
> > +       echo '</select></td></tr>';
> > +  echo '<tr><td>' . _('Petty Cash Tab To Assign Cash To') . ':</td>
> > +         <td><select name="SelectedTabsTo">';
> > +       DB_data_seek($result,0);
> > +       while ($myrow = DB_fetch_array($result)) {
> > +               if (isset($_POST['SelectTabsTo']) AND $myrow['tabcode']
> == $_POST['SelectTabs']) {
> > +                       echo '<option selected="selected" value="';
> > +               } else {
> > +                       echo '<option value="';
> > +               }
> > +               echo $myrow['tabcode'] . '">' . $myrow['tabcode'] .
> '</option>';
> > +       }
> > +       echo '</select></td></tr>';
> > +       echo '</table>'; // close main table
> > +    DB_free_result($result);
> > +
> > +       echo '<br />
> > +               <div class="centre">
> > +                       <input type="submit" name="Process" value="' .
> _('Accept') . '" />
> > +                       <input type="submit" name="Cancel" value="' .
> _('Cancel') . '" />
> > +               </div>';
> > +       echo '</div>
> > +          </form>';
> > +}
> > +
> > +//end of ifs and buts!
> > +if (isset($_POST['Process']) OR isset($SelectedTabs)) {
> > +
> > +       if (!isset($_POST['submit'])) {
> > +               echo '<p class="page_title_text"><img
> src="'.$RootPath.'/css/'.$Theme.'/images/money_add.png" title="' .
> > +                       _('Search') . '" alt="" />' . ' ' . $Title.
> '</p>';
> > +       }
> > +       echo '<br /><div class="centre"><a href="' .
> htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '">' .
> _('Select another tab') . '</a></div>';
> > +
> > +
> > +
> > +       if (! isset($_GET['edit']) OR isset ($_POST['GO'])){
> > +
> > +               if (isset($_POST['Cancel'])) {
> > +                       unset($_POST['Amount']);
> > +                       unset($_POST['Date']);
> > +                       unset($_POST['Notes']);
> > +                       unset($_POST['Receipt']);
> > +               }
> > +
> > +               if(!isset ($Days)){
> > +                       $Days=30;
> > +                }
> > +
> > +               /* Retrieve decimal places to display */
> > +               $SqlDecimalPlaces="SELECT decimalplaces
> > +                                       FROM currencies,pctabs
> > +                                       WHERE currencies.currabrev =
> pctabs.currency
> > +                                               AND tabcode='" .
> $SelectedTabs . "'";
> > +               $result = DB_query($SqlDecimalPlaces,$db);
> > +               $myrow=DB_fetch_array($result);
> > +               $CurrDecimalPlaces = $myrow['decimalplaces'];
> > +
> > +               $sql = "SELECT * FROM pcashdetails
> > +                               WHERE tabcode='" . $SelectedTabs . "'
> > +                               AND date >=DATE_SUB(CURDATE(), INTERVAL
> " . $Days . " DAY)
> > +                               ORDER BY date, counterindex ASC";
> > +               $result = DB_query($sql,$db);
> > +
> > +               echo '<form method="post" action="' .
> htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '">
> > +                       <div>
> > +                               <input type="hidden" name="FormID"
> value="' . $_SESSION['FormID'] . '" />
> > +                               <table class="selection">
> > +                               <tr>
> > +                                       <th colspan="8">' . _('Detail Of
> PC Tab Movements For Last') .':
> > +                                               <input type="hidden"
> name="SelectedTabs" value="' . $SelectedTabs . '" />
> > +                                               <input type="text"
> class="number" name="Days" value="' . $Days  . '" maxlength="3" size="4" />
> ' . _('Days') . '
> > +                                               <input type="submit"
> name="Go" value="' . _('Go') . '" /></th>
> > +                               </tr>
> > +                               <tr>
> > +                                       <th>' . _('Date') . '</th>
> > +                                       <th>' . _('Expense Code') .
> '</th>
> > +                                       <th>' . _('Amount') . '</th>
> > +                                       <th>' . _('Authorised') . '</th>
> > +                                       <th>' . _('Notes') . '</th>
> > +                                       <th>' . _('Receipt') . '</th>
> > +                               </tr>';
> > +
> > +               $k=0; //row colour counter
> > +
> > +       while ($myrow = DB_fetch_array($result)) {
> > +               if ($k==1){
> > +                       echo '<tr class="EvenTableRows">';
> > +                       $k=0;
> > +               } else {
> > +                       echo '<tr class="OddTableRows">';
> > +                       $k=1;
> > +               }
> > +
> > +               $sqldes="SELECT description
> > +                                       FROM pcexpenses
> > +                                       WHERE codeexpense='".
> $myrow['3'] . "'";
> > +
> > +               $ResultDes = DB_query($sqldes,$db);
> > +               $Description=DB_fetch_array($ResultDes);
> > +
> > +               if (!isset($Description['0'])){
> > +                       $Description['0']='ASSIGNCASH';
> > +               }
> > +
> > +               if (($myrow['authorized'] == '0000-00-00') and
> ($Description['0'] == 'ASSIGNCASH')){
> > +                       // only cash assignations NOT authorized can be
> modified or deleted
> > +                       echo '<td>' . ConvertSQLDate($myrow['date']) .
> '</td>
> > +                               <td>' . $Description['0'] . '</td>
> > +                               <td class="number">' .
> locale_number_format($myrow['amount'],$CurrDecimalPlaces) . '</td>
> > +                               <td>' . ConvertSQLDate($myrow['authorized'])
> . '</td>
> > +                               <td>' . $myrow['notes'] . '</td>
> > +                               <td>' . $myrow['receipt'] . '</td>
> > +                               </tr>';
> > +               }else{
> > +                       echo '<td>' . ConvertSQLDate($myrow['date']) .
> '</td>
> > +                               <td>' . $Description['0'] . '</td>
> > +                               <td class="number">' .
> locale_number_format($myrow['amount'],$CurrDecimalPlaces) . '</td>
> > +                               <td>' . ConvertSQLDate($myrow['authorized'])
> . '</td>
> > +                               <td>' . $myrow['notes'] . '</td>
> > +                               <td>' . $myrow['receipt'] . '</td>
> > +                               </tr>';
> > +               }
> > +       }
> > +               //END WHILE LIST LOOP
> > +
> > +               $sqlamount="SELECT sum(amount) as amt,
> > +                                       tabcode
> > +                                       FROM pcashdetails
> > +                                       WHERE tabcode IN
> ('".$SelectedTabs."','" . $_POST['SelectedTabsTo'] . "')
> > +                                       GROUP BY tabcode";
> > +
> > +               $ResultAmount = DB_query($sqlamount,$db);
> > +               if (DB_num_rows($ResultAmount)>0) {
> > +                       while ($AmountRow=DB_fetch_array($ResultAmount))
> {
> > +                               if (is_null($AmountRow['amt'])) {
> > +                                       $AmountRow['amt'] = 0;
> > +                               }
> > +                               if ($AmountRow['tabcode'] ==
> $SelectedTabs) {
> > +                                       $SelectedTab =
> array($AmountRow['amt'],$SelectedTabs);
> > +                               } else {
> > +                                       $SelectedTabsTo =
> array($AmountRow['amt'],$_POST['SelectedTabsTo']);
> > +                               }
> > +                       }
> > +               }
> > +               if (!isset($SelectedTab)) {
> > +                       $SelectedTab = array(0,$SelectedTabs);
> > +                       $SelectedTabsTo = array(0,$_POST['
> SelectedTabsTo']);
> > +               }
> > +
> > +
> > +
> > +               echo '<tr>
> > +                               <td colspan="2"
> style="text-align:right"><b>' . _('Current balance') . ':</b></td>
> > +                               <td>' . locale_number_format($
> SelectedTab['0'],$CurrDecimalPlaces) . '</td></tr>
> > +                               <input type="hidden"
> name="CurrentAmount" value="' . $SelectedTab[0] . '" />
> > +                               <input type="hidden" name="SelectedTabs"
> value="' . $SelectedTab[1] . '" />
> > +                               <input type="hidden"
> name="SelectedTabsTo" value="' . $SelectedTabsTo[1] . '" />
> > +                               <input type="hidden"
> name="SelectedTabsToAmt" value="' . $SelectedTabsTo[0] . '" />';
> > +
> > +
> > +               echo '</table>';
> > +        echo '</div>
> > +              </form>';
> > +       }
> > +
> > +
> > +
> > +               echo '<form method="post" action="' .
> htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') .'">
> > +                       <div>
> > +                               <input type="hidden" name="FormID"
> value="' . $_SESSION['FormID'] . '" />';
> > +
> > +/* Ricard: needs revision of this date initialization */
> > +               if (!isset($_POST['Date'])) {
> > +                       $_POST['Date']=Date($_SESSION[
> 'DefaultDateFormat']);
> > +               }
> > +
> > +        echo '<br />
> > +                               <table class="selection">'; //Main table
> > +            echo '<tr>
> > +                                       <th colspan="2"><h3>' . _('New
> Cash Assignment') . '</h3></th>
> > +                               </tr>';
> > +               echo '<tr>
> > +                               <td>' . _('Cash Assignation Date') .
> ':</td>
> > +                               <td><input type="text" class="date"
> alt="'.$_SESSION['DefaultDateFormat'].'" name="Date" required="required"
> autofocus="autofocus" size="10" maxlength="10" value="' . $_POST['Date'] .
> '" /></td>
> > +                       </tr>';
> > +
> > +
> > +               if (!isset($_POST['Amount'])) {
> > +                       $_POST['Amount']=0;
> > +               }
> > +
> > +               echo '<tr>
> > +                               <td>' . _('Amount') . ':</td>
> > +                               <td><input type="text" class="number"
> name="Amount" size="12" maxlength="11" value="' .
> locale_number_format($_POST['Amount'],$CurrDecimalPlaces) . '" /></td>
> > +                       </tr>';
> > +
> > +               if (!isset($_POST['Notes'])) {
> > +                       $_POST['Notes']='';
> > +               }
> > +
> > +               echo '<tr>
> > +                               <td>' . _('Notes') . ':</td>
> > +                               <td><input type="text" name="Notes"
> size="50" maxlength="49" value="' . $_POST['Notes'] . '" /></td>
> > +                       </tr>';
> > +
> > +               if (!isset($_POST['Receipt'])) {
> > +                       $_POST['Receipt']='';
> > +               }
> > +
> > +               echo '<tr>
> > +                               <td>' . _('Receipt') . ':</td>
> > +                               <td><input type="text" name="Receipt"
> size="50" maxlength="49" value="' . $_POST['Receipt'] . '" /></td>
> > +                       </tr>
> > +                       </table>
> > +                       <input type="hidden" name="CurrentAmount"
> value="' . $SelectedTab['0']. '" />
> > +                       <input type="hidden" name="SelectedTabs"
> value="' . $SelectedTabs . '" />
> > +                       <input type="hidden" name="Days" value="'
> .$Days. '" />
> > +                       <input type="hidden" name="SelectedTabsTo"
> value="' . $SelectedTabsTo[1] . '" />
> > +                       <input type="hidden" name="SelectedTabsToAmt"
> value="' . $SelectedTabsTo[0] . '" />
> > +                       <br />
> > +                       <div class="centre">
> > +                               <input type="submit" name="submit"
> value="' . _('Accept') . '" />
> > +                               <input type="submit" name="Cancel"
> value="' . _('Cancel') . '" /></div>
> > +                       </div>
> > +               </form>';
> > +
> > +}
> > +
> > +include('includes/footer.inc');
> > +?>
> >
> > Modified: trunk/includes/MainMenuLinksArray.php
> > ===================================================================
> > --- trunk/includes/MainMenuLinksArray.php       2016-08-25 21:05:53 UTC
> (rev 7604)
> > +++ trunk/includes/MainMenuLinksArray.php       2016-08-31 06:32:57 UTC
> (rev 7605)
> > @@ -446,10 +446,12 @@
> >
>                        '/MaintenanceTasks.php');
> >
> >  $MenuItems['PC']['Transactions']['Caption'] = array(_('Assign Cash to
> PC Tab'),
> > +                                                       _('Cash Transfer
> Between Tabs'),
> >
>                                _('Claim Expenses From PC Tab'),
> >
>                                _('Expenses Authorisation'));
> >
> >  $MenuItems['PC']['Transactions']['URL'] =
> array('/PcAssignCashToTab.php',
> > +
>  '/PcAssignCashTabToTab.php',
> >
>                        '/PcClaimExpensesFromTab.php',
> >
>                        '/PcAuthorizeExpenses.php');
> >
> >
> > Modified: trunk/sql/mysql/upgrade4.13-4.13.1.sql
> > ===================================================================
> > --- trunk/sql/mysql/upgrade4.13-4.13.1.sql      2016-08-25 21:05:53 UTC
> (rev 7604)
> > +++ trunk/sql/mysql/upgrade4.13-4.13.1.sql      2016-08-31 06:32:57 UTC
> (rev 7605)
> > @@ -8,5 +8,6 @@
> >  -- standardise transaction date to DATE type:
> >  ALTER TABLE `debtortrans` CHANGE `trandate` `trandate` DATE NOT NULL
> DEFAULT '0000-00-00';
> >  ALTER table supplierdiscounts CONVERT TO CHARACTER SET utf8;
> > +INSERT INTO scripts VALUES ('PcAssignCashTabToTab.php',12,'Assign cash
> from one tab to another');
> >
> >
> >
> >
> > ------------------------------------------------------------
> ------------------
> > _______________________________________________
> > 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
> Twitter: @TimSchofield2
> Blog: http://weberpafrica.blogspot.co.uk/
>

[WebERP-developers] weberp Report and Form Builder - Step 5

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

[1] http://www.weberp.org/weberp/reportwriter/admin/ReportCreator.php
Hi!
I want create a new report on weberp 4.13. using, report and form builder,
using environment
from [1] ReportCreator.php, setup menu from url
http://www.weberp.org/weberp/index.php
My new report is single as 2 cols from table stockmaster (stockid and
description).
On step 5 when i select dropdown list where have these fields, we give this
error:

: There is an error in your database field or description. Please check and
try again.

Please:
1-there are some config or there are some issues with this report creator?
2-are some one using this on production environment with sucess for
creation and run this reports?

thanks.

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