web-erp-developers — Discussion on development of webERP

Re: [WebERP-developers] Change the layout a little to make the mobile view better

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

*Hi, Rafael,*
         
             Thank you for your always contribution. 

             Sorry for that we have no progress for this. 

             Best regards!

             Exson




--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Change-the-layout-a-little-to-make-the-mobile-view-better-tp4658271p4658419.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Bug in GLAccountInquiry

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

*Hi, Richard,*

               Thank you for your test!

               Since this change looks strange to accounts, it'll be
reversed. So I did not fix the bug. 
               I believe there are lots of small companies which have no
accounts and GL account inquiry is not only for accountants to review.
               If there are more feedback about reserving this, I'll change
it as option instead of removing from the trunk.

              Best regards!

              Exson



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

Re: [WebERP-developers] Change the layout a little to make the mobile view better

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

Hi Exson,

Has your group worked more on a solution for webERP users can use the
mobile to view more convenient ?

Best regards, Rafael.

----------
2015-06-25 8:50 GMT-06:00 Rafael Chacón <raf...@gm...>:

> Hi Exson;
>
> Sorry not to be able to help more.
>
> Some other suggestions to have a CSS for small devices:
>
> * Hide icons in AppInfoDiv ( AppInfoDiv img{display: none;} ).
> * Replace "Manual" and "Logout" links with help-icon_button and
> logout-icon_button.
>
> Best regards, Rafael.
>
>
>
> 2015-06-20 9:28 GMT-06:00 Rafael Chacón <raf...@gm...>:
>
>> Hi,
>>
>> I added the meta tag:
>>
>> "<meta name="viewport" content="width=device-width, initial-scale=1">"
>>
>> to header.inc. The purpose of this tag is to tell the small device that
>> the website is a responsive site. That is: to keep a relationship 1:1
>> between CSS pixels and device pixels.
>>
>> I put it as a commented line because, if someone use a "big device" CSS
>> format in a small device, this can cause him problems (he has to move the
>> screen to see content; he can not see all in a small size). If someone
>> wants to use CSS for small-devices (responsive website), just uncomment
>> this line.
>>
>> Note: I re-format for better reading, and I use commas instead of dots in
>> the echo function because PHP with dots joins the string first and then
>> outputs them, while with commas just prints them out one after the other
>> (little faster).
>>
>> Best regards, Rafael.
>>
>> 2015-06-19 14:03 GMT-06:00 Rafael Chacón <raf...@gm...>
>> :
>>
>>> Hi Exson,
>>>
>>> It is great to run webERP in a smartphone (small devices).
>>>
>>> If you do not want to change the layout, the solution is simple:
>>>
>>> *** Add at the bottom of the css:
>>>
>>> @media only screen and (max-width: 1024px) {
>>> ...code...
>>> }
>>>
>>> On "max-width" is the width from you want the change. If you want for
>>> differents sizes (one for less than 480px and other for 480px to 1024px)
>>> you can have:
>>>
>>> @media only screen and (max-device-width : 480px) {
>>> ...code for this size...
>>> }
>>> @media only screen and (min-device-width : 480px) and (max-device-width
>>> : 1024px) {
>>> ...code for this size...
>>> }
>>>
>>> In this section, you put only changes (differences) with the "desktop
>>> screen".
>>>
>>>
>>> *** If the problem is the QuickMenuDiv, you can re-style with
>>> "display:inline; line-height:37px; padding:8px; etc" .
>>> Comment: in the "desktop screen": padding-bottom: 11px; padding-left:
>>> 24px; padding-right: 24px; padding-top: 11px; so that creates a
>>> QuickMenuDiv so big in the little screen.
>>> Suggestion 1: You can also re-style the MainMenuDiv to have it in inline
>>> mode (horizontal with wrap), so in this way you can save space for
>>> the SubMenuDiv.
>>> Suggestion 2: you can use float and width properties to to reposition
>>> the columns to the width available of the 3 blocks of SubMenuDiv.
>>>
>>> ----
>>> On the other hand, if you want to change in inner code, there is a
>>> solution: bootstrap. Some selectors must change the name, but we can arrive
>>> to have a full responsive web design.
>>>
>>> Best regards, rafael.
>>>
>>>
>>> 2015-06-19 7:18 GMT-06:00 Phil Daintree <ph...@lo...>:
>>>
>>>> A phone theme would be great !!
>>>>
>>>> Phil
>>>>
>>>> Phil Daintree
>>>> Logic Works Ltd - +64 (0)275 567890
>>>> http://www.logicworks.co.nz
>>>>
>>>> On 19/06/15 23:05, ExsonQu wrote:
>>>> > *Dear all,*
>>>> >
>>>> >                I've received a solution for webERP users can use the
>>>> mobile
>>>> > to view more convenient. But there are a little change of the layout.
>>>> >
>>>> >              The *logout* and *help *are moved to top left corner.  I
>>>> > attached the screen shot here.
>>>> >
>>>> >              If there are no objection, I'll commit his change to the
>>>> trunk.
>>>> >
>>>> >               newlayout.zip
>>>> > <
>>>> http://weberp-accounting.1478800.n4.nabble.com/file/n4658271/newlayout.zip
>>>> >
>>>> >
>>>> >             Thanks and best regards!
>>>> >
>>>> >             Exson
>>>> >
>>>> >
>>>> >
>>>> > --
>>>> > View this message in context:
>>>> http://weberp-accounting.1478800.n4.nabble.com/Change-the-layout-a-little-to-make-the-mobile-view-better-tp4658271.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
>>>>
>>>
>>>
>>
>

Re: [WebERP-developers] webERP. New version on November ?

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

Ok. Let's work on GLAccountInquiry.php
El 15/11/2015 06:41, "Pak Ricard" <pak...@gm...> escribió:

> Hi Rafael:
>
> IMHO, we should fix the bugs reported in my last email about GLAccountInquiry.php
> before rolling any new version, as it's confusing for users as it's showing
> wrong information.
>
>
>
> Regards,
> Ricard
>
> 2015-11-15 8:57 GMT+08:00 Rafael Chacón <raf...@gm...>:
>
>> Hi all,
>>
>> Is it a good time to roll up a new release? Since the last release we
>> have:
>> * Add documentation, help and direct printing on some scripts.
>> * Fix some errors.
>> * Add scripts for horizontal analysis of the statement of financial
>> position and for horizontal analysis of the statement of comprehensive
>> income.
>> * Add Korean translation.
>> * Fix the wrong material cost updated in SupplierCredit.php.
>> * Add invoice to grns mapping data in SupplierInvoice.php.
>> * Add bank default currency, original amount and check no data to GL
>> account inquiry in GLAccountInquiry.php.
>> * Add GL narrative and account balance information to
>> DailyBankTransactions.php.
>> * Allow user input supplier's delivery note during goods receiving.
>> * Tidy some scripts.
>> * New feature GL accounts - users authority.
>>
>> Best regards, Rafael.
>>
>>
>> ------------------------------------------------------------------------------
>>
>> _______________________________________________
>> 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
>
>

Re: [WebERP-developers] webERP. New version on November ?

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

Hi Rafael:

IMHO, we should fix the bugs reported in my last email about
GLAccountInquiry.php
before rolling any new version, as it's confusing for users as it's showing
wrong information.



Regards,
Ricard

2015-11-15 8:57 GMT+08:00 Rafael Chacón <raf...@gm...>:

> Hi all,
>
> Is it a good time to roll up a new release? Since the last release we have:
> * Add documentation, help and direct printing on some scripts.
> * Fix some errors.
> * Add scripts for horizontal analysis of the statement of financial
> position and for horizontal analysis of the statement of comprehensive
> income.
> * Add Korean translation.
> * Fix the wrong material cost updated in SupplierCredit.php.
> * Add invoice to grns mapping data in SupplierInvoice.php.
> * Add bank default currency, original amount and check no data to GL
> account inquiry in GLAccountInquiry.php.
> * Add GL narrative and account balance information to
> DailyBankTransactions.php.
> * Allow user input supplier's delivery note during goods receiving.
> * Tidy some scripts.
> * New feature GL accounts - users authority.
>
> Best regards, Rafael.
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

[WebERP-developers] webERP. New version on November ?

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

Hi all,

Is it a good time to roll up a new release? Since the last release we have:
* Add documentation, help and direct printing on some scripts.
* Fix some errors.
* Add scripts for horizontal analysis of the statement of financial
position and for horizontal analysis of the statement of comprehensive
income.
* Add Korean translation.
* Fix the wrong material cost updated in SupplierCredit.php.
* Add invoice to grns mapping data in SupplierInvoice.php.
* Add bank default currency, original amount and check no data to GL
account inquiry in GLAccountInquiry.php.
* Add GL narrative and account balance information to
DailyBankTransactions.php.
* Allow user input supplier's delivery note during goods receiving.
* Tidy some scripts.
* New feature GL accounts - users authority.

Best regards, Rafael.

[WebERP-developers] Bug in GLAccountInquiry

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

Hi Exson:

I am using the latest scripts with your nice upgrades. Happy with them,
buit I think there's a bug aroung lines 278 to 292 in GLAccountInquiry.php,
as I am getting wrong results. The field Bank Reference is shown with wrong
data, as it shows data from diferent transactions.

Am I the only one having thses issues?


Regards,
Ricard

[WebERP-developers] Authority to see / update GL accounts

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

Hi all:

I developed a system (inspired in location - user authority) to restrict
the GL accounts the users can see / update in webERP.
Probably our chief accountant has the right to see / update all the
accounts, but some accountants, just registering bank payments / receipts
should not be able to update some accounts.

As examples, almost no-one in a company should be able to check how much
the owners took as dividends or how much the company spend in the new CEO
car :-). Or only the HR accountant should be able to see how much the
company spends in salaries... Thousand examples, deending on every
organization.

So I created a table glaccountusers with the same fields and spirit than
locationusers and modified all the GL scripts needing it.

In scripts where the user can create a GL transaction, she must have the
canupdate = 1 to be able to select that account.
In scripts where the user just reads information there's two possible
outcomes:
a) if we can hide that account, we hide it, as in P/L or B/S.
b) if we can't hide the account (as example in a Journal inquiry) we show a
fixed text "Other GL accounts" and show no details

I know outcome a) is vurtually non-possible, as users having access to P/L
or B/S for sure will be allowed to see/update all GL accounts, but as a
double safety measure have been done.

By default, webERp will work as it works now, so when we create a new user,
she will be allowed to see/update all GL accounts, so it's a task of webERP
admin to "cut rights" if needed. If you won't be using this feature, no
worries, webERP will work as usual.

It has been commited just now. Has been tested, but please let me know if
there's any bug.

Regards,
Ricard

Re: [WebERP-developers] Quotation Prices incorrect

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

Exson,

We have made modifications to GetPrice.inc so that it works properly using
Sales Type, Discount Matrix and Default Price List.  The modifications
consist of:

1) Adding a second check against the pricematrix for an end date of
"0000-00-00", that was missing from the original script.
2) Adding the inclusive check of the pricematrix.
3) Removing the code that fetches a row, preventing proper completion of the
script.

GetPrice.inc
<http://weberp-accounting.1478800.n4.nabble.com/file/n4658402/GetPrice.inc>  

The changes made are a correction of incorrect handling of the various
pricing methods.  They should not change usage for any users.

Bob Thomas




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

Re: [WebERP-developers] Quotation Prices incorrect

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

*Hi, Bob,*

              As your finding, the order of the sql inquiry is the problem
you entered. The sql order reflects the sales type priority. The version of
the price matrix as the first priority exists very short time in the trunk
and it has never been released publicly. 
              If it's not a generally used feature, it's not suitable to
merge to trunk.  At least currently, there are little feedback about this. 
              Best regards!

              Exson
              
              
               



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

[WebERP-developers] Design improvement to Pricing

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

In the current database design, the end date for a given price is coded as
0000-00-00 if there is no expiration date.  When doing a date compare this
is before all other dates.  Such creates unnecessary complication in all of
the routines that attempt to determine pricing.  In effect whenever a price
is queried for a given case two queries are programmed.

Changing all expiration dates of 0000-00-00 to 9999-99-99 would eliminate
the duplication of queries greatly streamlining the code.

The change is relatively simple.

Can such be considered for a future release of webERP?

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Design-improvement-to-Pricing-tp4658400.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] Quotation Prices incorrect

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

Exson,

We did not change what we were doing and it is per the documentation and
file design.  The behavior of GetPrice.php changed, breaking something that
worked per the documentation.

We have been studying the code.  It is not obvious why Get Price.inc is not
finding the price.  The order of inquiries has changed possibly causing the
problem.

We have a number of sales types.  When we change the default price, the
pricing in all of the other sales types properly reflect the change.  We
will try to see where in GetPrice the error was introduced and post a
correction to the community such that no other pricing structures are
disturbed.

Bob Thomas



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

Re: [WebERP-developers] Quotation Prices incorrect

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

*Hi, Bob,*
                    
                    It's not a bug. It's the design of the file. 
                    It's not a general requirement for this feature. When I
asked if someone need this, so we can make it a choice, there is no
feedback. I've got a feedback from webERP chinese community. But what he
want is current discount matrix. Because it's quite tedious to modify the
prices if lots of prices changed. 
                     The file I changed last time can be used. But it'll not
be merged to the trunk. 

                     Best regards!

                     Exson
                



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

Re: [WebERP-developers] Quotation Prices incorrect

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

Exson,

We restored GetPrice.inc from 4.12.3 distribution.  It always returns 0.0
from GetPrice.inc for any sales types other than that which is the default
sales type.

Bob Thomas



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

Re: [WebERP-developers] Quotation Prices incorrect

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

Exson,

Could you send me the current production version of GetPrice.php so that we
can test?

We use the sales type and discount matrix to obtain all of our pricing.  We
do not have customer unique prices so we need GetPrice.php to properly
handle this situation.

The issues with GetPrice.php have been a problem for several releases of
webERP.  It appears that the error in GetPrice.php was introduced sometime
between 4.11.5 and 4.12.2.

Bob Thomas 



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

Re: [WebERP-developers] Quotation Prices incorrect

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

*Hi, Bob,*
             I've checked your file. And it's not the version you mentioned. 
            
            Since there is no response to revise the feature, I'll keep it
as is. 

            Thanks and best regards!

            Exson

              



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

Re: [WebERP-developers] Quotation Prices incorrect

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

Exson,

You provided PriceMatrix.php.  We have replaced the existing PriceMatrix.php
and see no problem in a quick test, but we are using the following
GetPrice.inc:

GetPrice.inc
<http://weberp-accounting.1478800.n4.nabble.com/file/n4658387/GetPrice.inc>  

Bob Thomas



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

Re: [WebERP-developers] Quotation Prices incorrect

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

*Hi, Bob,*

              I've revised the GetPrice.php. 
             I think it will work for you!
               PriceMatrix.zip
<http://weberp-accounting.1478800.n4.nabble.com/file/n4658385/PriceMatrix.zip>  
             Best regards!

             Exson

 



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Quotation-Prices-incorrect-tp4658352p4658385.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,*
          
             After review the file again. I know what you mean. 

            Best regards!

            Exson



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

[WebERP-developers] Shall we make PriceMatrix the default price?

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

*Dear all,*

           Currently our price retrieving method almost make the price
matrix useless if there are default sales type set. The price matrix is use
to retrieve different price according to sales order quantity. 
           We have two choices to solve this problem:
           1. Move the price matrix  SQL to the top. Then webERP will
retrieve the price matrix result directly without considering the price
matrix.
           2. Set up a setting parameter. Then user can choose to use which
as the default price setting method. 
          
           If most of feedback agree to change webERP's current method, I'll
make a modification in relative scripts.

         
          Any comments are welcome!

          Best regards!

          Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Shall-we-make-PriceMatrix-the-default-price-tp4658383.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,*

           It only show default type is a bug. It has no relationship with
the GetPrice.php problem.

          Best regards!

          Exson



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

Re: [WebERP-developers] Quotation Prices incorrect

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

*Hi, Bob,*

         Thank you for your quick response!

         It's no difference with the trunk!
         Would you like to post the file you revised?

        Best regards!

        Exson



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

Re: [WebERP-developers] Quotation Prices incorrect

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

Exson,

The attached was in the original download of V4.12.3 that we performed.

GetPrice.inc
<http://weberp-accounting.1478800.n4.nabble.com/file/n4658380/GetPrice.inc>  

Could there have been a corrupt version that was corrected after we
downloaded the package?

If the current production version is identical to what we are using then
there must have been an issue with the downloaded package.

Bob Thomas



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Quotation-Prices-incorrect-tp4658352p4658380.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 like to post your reworked copy? 
            I cannot find what goes wrong. The latest version and the
version (6714) what you said OK has no big difference except $db. The
previous version only removed two lines of debug messages. 
           
           Thanks and best regards!

           Exson



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

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

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

Exson,

We suspect that the problem involves the same error that crept into
GetPrice.inc that returns a 0.00 price of any sales type other than default. 
Looking at the php, if all of the prices are zero the error message is
generated.

There is no "Default" price list option.  The report only displays a
pricelist if the Default price list's name in our case "End User" is
specified.  IN all other cases the error message is displayed.

Thank you,
Bob Thomas



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