web-erp-developers — Discussion on development of webERP

Re: [WebERP-developers] Differentiating between cookie path

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

Hi Alistair
If there are just a few lines to your solution which requires no manual editing, then perhaps you would send me the duffs so I could study. As Tim points out it is quite easy to use the config.php sessionssavepath to explicitly set where the server should save the session to. Some documentation as you say might be all we really need

Alastair <kn...@gm...> wrote:

>Hi Tim,
>
>I've just looked into this a little deeper and it appears you're referring to $SessionSavePath. After a while of fiddling around with this variable and manually creating folders for each isolated install, I was able to get this to work. Unfortunately this process isn't well documented and requires manual configuration on the server for this to work (not horrible, I'd prefer to keep manual config to a minimum).
>
>Perhaps, this could be simplified by setting the "Path" value in the session cookies instead. This removes the need to create folders and specify locations in the config file, and it can be easily automated too.
>
>On a side note, the session.inc script should probably be setting the session cookie name with session_name() as PHPSESSID is very generic and doesn't help with debugging at all.
>
>My Regards,
>Alastair Knowles.
>
>On 25/06/15 03:15, Tim Schofield wrote:
>
>Hi Alastair the session save path can be set in config.php. The line is commented out by default.
>
>Thanks
>Tim
>
>On 24 Jun 2015 12:40, "Alastair Knowles" <kn...@gm...> wrote:
>
>Hi,
>It seems currently if you've got 2 different WebERP installs on the same
>web server with 2 different paths (e.g. http://server/webERP1/ and
>http://server/webERP2/), they share the same session cookies and thus
>logging into both sessions at once could end up overriding the wrong
>database. After doing some reading, it seems its possible to set the
>session path in the cookies, thus forcing each install to have its own
>cookies. I've made the required changes to the session.inc file and have
>been running 2 concurrent installs with no problems for the last couple
>of months.
>
>Just as a background as to how I've been using this functionality, this
>allows me to have both a live system and a totally isolated development
>system running concurrently from which I can try modifications without
>the risk of damaging the live system and without having to temporarily
>log out of the live system.
>
>I've made the necessary modifications (a grand total of 4 added lines)
>and have re-based it to the latest svn (as of half an hour ago). Would
>it be possible for this feature to be added upstream to the sourceforge
>svn? (Pending review of course) If so, I'll send through the diff asap.
>
>My Regards,
>Alastair Knowles.
>
>------------------------------------------------------------------------------
>Monitor 25 network devices or servers for free with OpManager!
>OpManager is web-based network management software that monitors
>network devices and physical & virtual servers, alerts via email & sms
>for fault. Monitor 25 devices for free with no restriction. Download now
>http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
>_______________________________________________
>Web-erp-developers mailing list
>Web...@li...
>https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>-- 
>Sent from my Android device with K-9 Mail. Please excuse my brevity.
>------------------------------------------------------------------------------
>Monitor 25 network devices or servers for free with OpManager!
>OpManager is web-based network management software that monitors 
>network devices and physical & virtual servers, alerts via email & sms 
>for fault. Monitor 25 devices for free with no restriction. Download now
>http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
>_______________________________________________
>Web-erp-developers mailing list
>Web...@li...
>https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] Differentiating between cookie path

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

Absolutely

Alastair Knowles <kn...@gm...> wrote:

>Hi,
>It seems currently if you've got 2 different WebERP installs on the same 
>web server with 2 different paths (e.g. http://server/webERP1/ and 
>http://server/webERP2/), they share the same session cookies and thus 
>logging into both sessions at once could end up overriding the wrong 
>database. After doing some reading, it seems its possible to set the 
>session path in the cookies, thus forcing each install to have its own 
>cookies. I've made the required changes to the session.inc file and have 
>been running 2 concurrent installs with no problems for the last couple 
>of months.
>
>Just as a background as to how I've been using this functionality, this 
>allows me to have both a live system and a totally isolated development 
>system running concurrently from which I can try modifications without 
>the risk of damaging the live system and without having to temporarily 
>log out of the live system.
>
>I've made the necessary modifications (a grand total of 4 added lines) 
>and have re-based it to the latest svn (as of half an hour ago). Would 
>it be possible for this feature to be added upstream to the sourceforge 
>svn? (Pending review of course) If so, I'll send through the diff asap.
>
>My Regards,
>Alastair Knowles.
>
>------------------------------------------------------------------------------
>Monitor 25 network devices or servers for free with OpManager!
>OpManager is web-based network management software that monitors 
>network devices and physical & virtual servers, alerts via email & sms 
>for fault. Monitor 25 devices for free with no restriction. Download now
>http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
>_______________________________________________
>Web-erp-developers mailing list
>Web...@li...
>https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] Differentiating between cookie path

[Alastair <kn...@gm...>]

Hi Tim,

I've just looked into this a little deeper and it appears you're referring to $SessionSavePath. After a while of fiddling around with this variable and manually creating folders for each isolated install, I was able to get this to work. Unfortunately this process isn't well documented and requires manual configuration on the server for this to work (not horrible, I'd prefer to keep manual config to a minimum).

Perhaps, this could be simplified by setting the "Path" value in the session cookies instead. This removes the need to create folders and specify locations in the config file, and it can be easily automated too.

On a side note, the session.inc script should probably be setting the session cookie name with session_name() as PHPSESSID is very generic and doesn't help with debugging at all.

My Regards,
Alastair Knowles.

On 25/06/15 03:15, Tim Schofield wrote:

Hi Alastair the session save path can be set in config.php. The line is commented out by default.

Thanks
Tim

On 24 Jun 2015 12:40, "Alastair Knowles" <kn...@gm...> wrote:

Hi,
It seems currently if you've got 2 different WebERP installs on the same
web server with 2 different paths (e.g. http://server/webERP1/ and
http://server/webERP2/), they share the same session cookies and thus
logging into both sessions at once could end up overriding the wrong
database. After doing some reading, it seems its possible to set the
session path in the cookies, thus forcing each install to have its own
cookies. I've made the required changes to the session.inc file and have
been running 2 concurrent installs with no problems for the last couple
of months.

Just as a background as to how I've been using this functionality, this
allows me to have both a live system and a totally isolated development
system running concurrently from which I can try modifications without
the risk of damaging the live system and without having to temporarily
log out of the live system.

I've made the necessary modifications (a grand total of 4 added lines)
and have re-based it to the latest svn (as of half an hour ago). Would
it be possible for this feature to be added upstream to the sourceforge
svn? (Pending review of course) If so, I'll send through the diff asap.

My Regards,
Alastair Knowles.

------------------------------------------------------------------------------
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors
network devices and physical & virtual servers, alerts via email & sms
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
_______________________________________________
Web-erp-developers mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers



-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

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

[Rafael C. <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
>>>
>>
>>
>

[WebERP-developers] Differentiating between cookie path

[Alastair K. <kn...@gm...>]

Hi,
It seems currently if you've got 2 different WebERP installs on the same 
web server with 2 different paths (e.g. http://server/webERP1/ and 
http://server/webERP2/), they share the same session cookies and thus 
logging into both sessions at once could end up overriding the wrong 
database. After doing some reading, it seems its possible to set the 
session path in the cookies, thus forcing each install to have its own 
cookies. I've made the required changes to the session.inc file and have 
been running 2 concurrent installs with no problems for the last couple 
of months.

Just as a background as to how I've been using this functionality, this 
allows me to have both a live system and a totally isolated development 
system running concurrently from which I can try modifications without 
the risk of damaging the live system and without having to temporarily 
log out of the live system.

I've made the necessary modifications (a grand total of 4 added lines) 
and have re-based it to the latest svn (as of half an hour ago). Would 
it be possible for this feature to be added upstream to the sourceforge 
svn? (Pending review of course) If so, I'll send through the diff asap.

My Regards,
Alastair Knowles.

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

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

we have by convention concatenated all strings first ... I am not sure 
if there is a lot of overhead.

Phil

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

On 21/06/15 03:28, Rafael Chacón wrote:
> 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... <mailto: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...
>     <mailto:ph...@lo...>>:
>
>         A phone theme would be great !!
>
>         Phil
>
>         Phil Daintree
>         Logic Works Ltd - +64 (0)275 567890
>         <tel:%2B64%20%280%29275%20567890>
>         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...
>         <mailto:Web...@li...>
>         > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>         >
>
>
>         ------------------------------------------------------------------------------
>         _______________________________________________
>         Web-erp-developers mailing list
>         Web...@li...
>         <mailto: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] Web-erp-developers Digest, Vol 109, Issue 1

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

I have developed a POS specifically for webERP
see

http://www.logicworks.co.nz/Counter-Logic.html

Phil

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

On 21/06/15 08:01, ملک مراد علی wrote:
>
> Dear
>
> Plz tell me how to connect with weberp with pos
> Or which pos is good for this....
>
> Thanks
>
> Rgds
>
> On Jun 19, 2015 11:04 PM, 
> <web...@li... 
> <mailto:web...@li...>> wrote:
>
>     Send Web-erp-developers mailing list submissions to
>     web...@li...
>     <mailto:web...@li...>
>
>     To subscribe or unsubscribe via the World Wide Web, visit
>     https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>     or, via email, send a message with subject or body 'help' to
>     web...@li...
>     <mailto:web...@li...>
>
>     You can reach the person managing the list at
>     web...@li...
>     <mailto:web...@li...>
>
>     When replying, please edit your Subject line so it is more specific
>     than "Re: Contents of Web-erp-developers digest..."
>
>
>     Today's Topics:
>
>        1. Experience using the installer (Pak Ricard)
>        2. Re: Experience using the installer (ExsonQu)
>        3. Change the layout a little to make the mobile     view better
>           (ExsonQu)
>        4. Re: Change the layout a little to make the mobile view better
>           (Phil Daintree)
>        5. Re: Change the layout a little to make the mobile view better
>           (Rafael Chac?n)
>
>
>     ----------------------------------------------------------------------
>
>     Message: 1
>     Date: Fri, 15 May 2015 08:06:06 +0800
>     From: Pak Ricard <pak...@gm... <mailto:pak...@gm...>>
>     Subject: [WebERP-developers] Experience using the installer
>     To: webERP Developers <web...@li...
>     <mailto:web...@li...>>
>     Message-ID:
>            
>     <CAJ...@ma... <mailto:CAJaHx25mc9YhU%2BA...@ma...>>
>     Content-Type: text/plain; charset="utf-8"
>
>     Hi all:
>
>     I had to intall and set up a new instance of webERP and I decided
>     to use
>     the installer. It was a much nicer experience than the time we had no
>     installer.
>
>     But, I found the following issues:
>
>     1) I made a mistake while creating the DB user, but the installer
>     ended
>     with some error messages (I could not read,as it refreshed
>     inmediately).
>     Then I had to manually delete the config.sys file to start again.
>     Probably
>     a new user will not think about deleting the config.sys to restart the
>     installer. A kind of "back" button would be nice
>
>     2) The second time I run the installer, it did not ask me about
>     the time
>     zone, etc, so jumped from the database parameters to the success page.
>
>     3) I deleted some currencies, but webERP did not check if there
>     was any
>     bank accounts defined against those currencies, so ended up with bank
>     accounts with orphaned currencies.
>
>     4) Even if I chosed no demo data, the GL accounts had an account
>     2470 about
>     Canada Pension Funds, which I guess it should not be in the
>     default country
>     installer.
>
>     Hope it's helpful to teh developer of the installer, so the final user
>     experience gets even better.
>
>     Regards,
>     Ricard
>     -------------- next part --------------
>     An HTML attachment was scrubbed...
>
>     ------------------------------
>
>     Message: 2
>     Date: Sun, 24 May 2015 07:25:38 -0700 (PDT)
>     From: ExsonQu <hex...@gm... <mailto:hex...@gm...>>
>     Subject: Re: [WebERP-developers] Experience using the installer
>     To: web...@li...
>     <mailto:web...@li...>
>     Message-ID: <143...@n4...
>     <mailto:143...@n4...>>
>     Content-Type: text/plain; charset=us-ascii
>
>     *Hi, Richard*
>
>                Thank you for your feedback.
>
>               I'll fix it as I have time.
>
>               Best regards!
>
>               Exson
>
>
>
>     --
>     View this message in context:
>     http://weberp-accounting.1478800.n4.nabble.com/Experience-using-the-installer-tp4658250p4658259.html
>     Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
>
>     ------------------------------
>
>     Message: 3
>     Date: Fri, 19 Jun 2015 04:05:24 -0700 (PDT)
>     From: ExsonQu <hex...@gm... <mailto:hex...@gm...>>
>     Subject: [WebERP-developers] Change the layout a little to make the
>             mobile  view better
>     To: web...@li...
>     <mailto:web...@li...>
>     Message-ID: <143...@n4...
>     <mailto:143...@n4...>>
>     Content-Type: text/plain; charset=us-ascii
>
>     *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.
>
>
>
>     ------------------------------
>
>     Message: 4
>     Date: Sat, 20 Jun 2015 01:18:14 +1200
>     From: Phil Daintree <ph...@lo...
>     <mailto:ph...@lo...>>
>     Subject: Re: [WebERP-developers] Change the layout a little to make
>             the mobile view better
>     To: webERP Developers <web...@li...
>     <mailto:web...@li...>>
>     Message-ID: <558...@lo...
>     <mailto:558...@lo...>>
>     Content-Type: text/plain; charset=windows-1252; format=flowed
>
>     A phone theme would be great !!
>
>     Phil
>
>     Phil Daintree
>     Logic Works Ltd - +64 (0)275 567890 <tel:%2B64%20%280%29275%20567890>
>     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...
>     <mailto:Web...@li...>
>     > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>     >
>
>
>
>
>     ------------------------------
>
>     Message: 5
>     Date: Fri, 19 Jun 2015 14:03:13 -0600
>     From: Rafael Chac?n <raf...@gm...
>     <mailto:raf...@gm...>>
>     Subject: Re: [WebERP-developers] Change the layout a little to make
>             the mobile view better
>     To: webERP Developers <web...@li...
>     <mailto:web...@li...>>
>     Message-ID:
>            
>     <CAN...@ma... <mailto:CANX%2Bo...@ma...>>
>     Content-Type: text/plain; charset="utf-8"
>
>     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...
>     <mailto:ph...@lo...>>:
>
>     > A phone theme would be great !!
>     >
>     > Phil
>     >
>     > Phil Daintree
>     > Logic Works Ltd - +64 (0)275 567890
>     <tel:%2B64%20%280%29275%20567890>
>     > 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...
>     <mailto:Web...@li...>
>     > > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>     > >
>     >
>     >
>     >
>     >
>     ------------------------------------------------------------------------------
>     > _______________________________________________
>     > Web-erp-developers mailing list
>     > Web...@li...
>     <mailto:Web...@li...>
>     > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>     >
>     -------------- next part --------------
>     An HTML attachment was scrubbed...
>
>     ------------------------------
>
>     ------------------------------------------------------------------------------
>
>
>     ------------------------------
>
>     _______________________________________________
>     Web-erp-developers mailing list
>     Web...@li...
>     <mailto:Web...@li...>
>     https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>     End of Web-erp-developers Digest, Vol 109, Issue 1
>     **************************************************
>
>
>
> ------------------------------------------------------------------------------
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] Web-erp-developers Digest, Vol 109, Issue 1

[ملک م. ع. <mur...@gm...>]

Dear

Plz tell me how to connect with weberp with pos
Or which pos is good for this....

Thanks

Rgds
On Jun 19, 2015 11:04 PM, <web...@li...>
wrote:

> Send Web-erp-developers mailing list submissions to
>         web...@li...
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> or, via email, send a message with subject or body 'help' to
>         web...@li...
>
> You can reach the person managing the list at
>         web...@li...
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Web-erp-developers digest..."
>
>
> Today's Topics:
>
>    1. Experience using the installer (Pak Ricard)
>    2. Re: Experience using the installer (ExsonQu)
>    3. Change the layout a little to make the mobile     view better
>       (ExsonQu)
>    4. Re: Change the layout a little to make the mobile view better
>       (Phil Daintree)
>    5. Re: Change the layout a little to make the mobile view better
>       (Rafael Chac?n)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 15 May 2015 08:06:06 +0800
> From: Pak Ricard <pak...@gm...>
> Subject: [WebERP-developers] Experience using the installer
> To: webERP Developers <web...@li...>
> Message-ID:
>         <
> CAJ...@ma...>
> Content-Type: text/plain; charset="utf-8"
>
> Hi all:
>
> I had to intall and set up a new instance of webERP and I decided to use
> the installer. It was a much nicer experience than the time we had no
> installer.
>
> But, I found the following issues:
>
> 1) I made a mistake while creating the DB user, but the installer ended
> with some error messages (I could not read,as it refreshed inmediately).
> Then I had to manually delete the config.sys file to start again. Probably
> a new user will not think about deleting the config.sys to restart the
> installer. A kind of "back" button would be nice
>
> 2) The second time I run the installer, it did not ask me about the time
> zone, etc, so jumped from the database parameters to the success page.
>
> 3) I deleted some currencies, but webERP did not check if there was any
> bank accounts defined against those currencies, so ended up with bank
> accounts with orphaned currencies.
>
> 4) Even if I chosed no demo data, the GL accounts had an account 2470 about
> Canada Pension Funds, which I guess it should not be in the default country
> installer.
>
> Hope it's helpful to teh developer of the installer, so the final user
> experience gets even better.
>
> Regards,
> Ricard
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 2
> Date: Sun, 24 May 2015 07:25:38 -0700 (PDT)
> From: ExsonQu <hex...@gm...>
> Subject: Re: [WebERP-developers] Experience using the installer
> To: web...@li...
> Message-ID: <143...@n4...>
> Content-Type: text/plain; charset=us-ascii
>
> *Hi, Richard*
>
>            Thank you for your feedback.
>
>           I'll fix it as I have time.
>
>           Best regards!
>
>           Exson
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/Experience-using-the-installer-tp4658250p4658259.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
>
> ------------------------------
>
> Message: 3
> Date: Fri, 19 Jun 2015 04:05:24 -0700 (PDT)
> From: ExsonQu <hex...@gm...>
> Subject: [WebERP-developers] Change the layout a little to make the
>         mobile  view better
> To: web...@li...
> Message-ID: <143...@n4...>
> Content-Type: text/plain; charset=us-ascii
>
> *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.
>
>
>
> ------------------------------
>
> Message: 4
> Date: Sat, 20 Jun 2015 01:18:14 +1200
> From: Phil Daintree <ph...@lo...>
> Subject: Re: [WebERP-developers] Change the layout a little to make
>         the mobile view better
> To: webERP Developers <web...@li...>
> Message-ID: <558...@lo...>
> Content-Type: text/plain; charset=windows-1252; format=flowed
>
> 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
> >
>
>
>
>
> ------------------------------
>
> Message: 5
> Date: Fri, 19 Jun 2015 14:03:13 -0600
> From: Rafael Chac?n <raf...@gm...>
> Subject: Re: [WebERP-developers] Change the layout a little to make
>         the mobile view better
> To: webERP Developers <web...@li...>
> Message-ID:
>         <
> CAN...@ma...>
> Content-Type: text/plain; charset="utf-8"
>
> 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
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
>
> ------------------------------------------------------------------------------
>
>
> ------------------------------
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
> End of Web-erp-developers Digest, Vol 109, Issue 1
> **************************************************
>

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

[Rafael C. <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] Change the layout a little to make the mobile view better

[Rafael C. <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] Change the layout a little to make the mobile view better

[Phil D. <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
>

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

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

*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.

Re: [WebERP-developers] Experience using the installer

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

*Hi, Richard*

           Thank you for your feedback. 

          I'll fix it as I have time. 

          Best regards!

          Exson



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

[WebERP-developers] Experience using the installer

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

Hi all:

I had to intall and set up a new instance of webERP and I decided to use
the installer. It was a much nicer experience than the time we had no
installer.

But, I found the following issues:

1) I made a mistake while creating the DB user, but the installer ended
with some error messages (I could not read,as it refreshed inmediately).
Then I had to manually delete the config.sys file to start again. Probably
a new user will not think about deleting the config.sys to restart the
installer. A kind of "back" button would be nice

2) The second time I run the installer, it did not ask me about the time
zone, etc, so jumped from the database parameters to the success page.

3) I deleted some currencies, but webERP did not check if there was any
bank accounts defined against those currencies, so ended up with bank
accounts with orphaned currencies.

4) Even if I chosed no demo data, the GL accounts had an account 2470 about
Canada Pension Funds, which I guess it should not be in the default country
installer.

Hope it's helpful to teh developer of the installer, so the final user
experience gets even better.

Regards,
Ricard

[WebERP-developers] Fwd: [Web-erp-svn] SF.net SVN: web-erp:[7296] trunk

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

I uploaded two new features:
(1) GL account code for an inventory location, so that you can have general
ledger transactions of inventory transfers to or from this location; useful
for pledged inventory and goods on consignment.
(2) Allow Invoicing parameter to allow or deny the availability of a
location to be delivered; useful when a location stores compromised good
that can not be sold.

I tried to document inside the code (for programmers) and inside the manual
(for users). Feel free to modify this documentación; specifically, for
those who are English-GB native speakers, please review and fix (remember,
I am not an english native speaker).

Best regards, Rafael.


---------- Forwarded message ----------
From: <rc...@us...>
Date: 2015-05-09 22:54 GMT-06:00
Subject: [Web-erp-svn] SF.net SVN: web-erp:[7296] trunk
To: web...@li...


Revision: 7296
          http://sourceforge.net/p/web-erp/reponame/7296
Author:   rchacon
Date:     2015-05-10 04:54:12 +0000 (Sun, 10 May 2015)
Log Message:
-----------
New features: (1) GL account code for an inventory location, so that you
can have general ledger transactions of inventory transfers to or from this
location; useful for pledged inventory and goods on consignment. (2) Allow
Invoicing parameter to allow or deny the availability of a location to be
delivered; useful when a location stores compromised good that can not be
sold.

Modified Paths:
--------------
    trunk/CustomerBranches.php
    trunk/DeliveryDetails.php
    trunk/Locations.php
    trunk/StockLocTransferReceive.php
    trunk/StockTransfers.php
    trunk/Z_ChangeGLAccountCode.php
    trunk/Z_ChangeLocationCode.php
    trunk/doc/Change.log
    trunk/doc/Manual/ManualAccountsReceivable.html
    trunk/doc/Manual/ManualInventory.html
    trunk/doc/Manual/ManualSalesOrders.html
    trunk/includes/DefineStockTransfers.php
    trunk/sql/mysql/upgrade4.12.2-4.13.sql

Added Paths:
-----------
    trunk/doc/Manual/images/InventoryLocations.png

Modified: trunk/CustomerBranches.php
===================================================================
--- trunk/CustomerBranches.php  2015-05-10 01:01:51 UTC (rev 7295)
+++ trunk/CustomerBranches.php  2015-05-10 04:54:12 UTC (rev 7296)
@@ -12,7 +12,7 @@

 if(isset($_GET['DebtorNo'])) {
        $DebtorNo = mb_strtoupper($_GET['DebtorNo']);
-} else if(isset($_POST['DebtorNo'])) {
+} elseif(isset($_POST['DebtorNo'])) {
        $DebtorNo = mb_strtoupper($_POST['DebtorNo']);
 }

@@ -26,7 +26,7 @@

 if(isset($_GET['SelectedBranch'])) {
        $SelectedBranch = mb_strtoupper($_GET['SelectedBranch']);
-} else if(isset($_POST['SelectedBranch'])) {
+} elseif(isset($_POST['SelectedBranch'])) {
        $SelectedBranch = mb_strtoupper($_POST['SelectedBranch']);
 }

@@ -177,7 +177,7 @@

                $msg = $_POST['BrName'] . ' '._('branch has been updated.');

-       } else if($InputError !=1) {
+       } elseif($InputError !=1) {

        /*Selected branch is null cos no item selected on first time round
so must be adding a  record must be submitting new entries in the new
Customer Branches form */

@@ -286,7 +286,7 @@
                unset($_POST['DeliverBlind']);
                unset($SelectedBranch);
        }
-} else if(isset($_GET['delete'])) {
+} elseif(isset($_GET['delete'])) {
 //the link to delete a selected record was clicked instead of the submit
button

 // PREVENT DELETES IF DEPENDENT RECORDS IN 'DebtorTrans'
@@ -461,7 +461,7 @@

                        if($myrow[10]) {
                                $TotalDisable++;
-                       }else {
+                       } else {
                                $TotalEnable++;
                        }
                } while ($myrow = DB_fetch_row($result));
@@ -698,7 +698,7 @@
        foreach ($CountriesArray as $CountryEntry => $CountryName) {
                if(isset($_POST['BrAddress6']) AND ($_POST['BrAddress6'] ==
$CountryName)) {
                        echo '<option selected="selected" value="' .
$CountryName . '">' . $CountryName . '</option>';
-               }elseif(!isset($_POST['BrAddress6']) AND $CountryName ==
"") {
+               } elseif(!isset($_POST['BrAddress6']) AND $CountryName ==
"") {
                        echo '<option selected="selected" value="' .
$CountryName . '">' . $CountryName . '</option>';
                } else {
                        echo '<option value="' . $CountryName . '">' .
$CountryName . '</option>';
@@ -735,7 +735,7 @@
                echo $_SESSION['UsersRealName'];
                echo '</td>
                        </tr>';
-       }else{
+       } else {

                //SQL to poulate account selection boxes
                $SQL = "SELECT salesmanname,
@@ -800,30 +800,38 @@
                </tr>';
        DB_data_seek($result,0);

-       $SQL = "SELECT locations.loccode, locationname FROM locations INNER
JOIN locationusers ON locationusers.loccode=locations.loccode AND
locationusers.userid='" . $_SESSION['UserID'] . "' AND
locationusers.canupd=1";
+// BEGIN:
**********************************************************************
+       $SQL = "SELECT locations.loccode, locationname
+               FROM locations
+               INNER JOIN locationusers
+               ON locationusers.loccode=locations.loccode
+                       AND locationusers.userid='" . $_SESSION['UserID'] .
"'
+                       AND locationusers.canupd=1
+               WHERE locations.allowinvoicing='1'";
        $result = DB_query($SQL);

        if(DB_num_rows($result)==0) {
                echo '</table>';
                prnMsg(_('There are no stock locations defined as yet') . '
- ' . _('customer branches must refer to a default location where stock is
normally drawn from') . '. ' . _('Please use the link below to define at
least one stock location'),'error');
-               echo '<br /><a href="' . $RootPath . '/Locations.php">' .
_('Define Stock Locations') . '</a>';
+               echo '<br /><a href="', $RootPath, '/Locations.php">',
_('Define Stock Locations'), '</a>';
                include('includes/footer.inc');
                exit;
        }

        echo '<tr>
-                       <td>' . _('Draw Stock From').':</td>
-                       <td><select tabindex="15" name="DefaultLocation">';
+                       <td>', _('Draw Stock From'), ':</td>
+                       <td><select name="DefaultLocation" tabindex="15">';

-       while ($myrow = DB_fetch_array($result)) {
+       while($myrow = DB_fetch_array($result)) {
                if(isset($_POST['DefaultLocation']) AND
$myrow['loccode']==$_POST['DefaultLocation']) {
                        echo '<option selected="selected" value="';
                } else {
                        echo '<option value="';
                }
-               echo $myrow['loccode'] . '">' . $myrow['locationname'] .
'</option>';
+               echo $myrow['loccode'], '">', $myrow['locationname'],
'</option>';

-       } //end while loop
+       }// End while loop.
+// END:
************************************************************************

        echo '</select></td>
                </tr>
@@ -910,7 +918,7 @@
        while ($myrow=DB_fetch_array($ShipperResults)) {
                if(isset($_POST['DefaultShipVia'])and
$myrow['shipper_id']==$_POST['DefaultShipVia']) {
                        echo '<option selected="selected" value="' .
$myrow['shipper_id'] . '">' . $myrow['shippername'] . '</option>';
-               }else {
+               } else {
                        echo '<option value="' . $myrow['shipper_id'] .
'">' . $myrow['shippername'] . '</option>';
                }
        }
@@ -938,53 +946,53 @@
                $_POST['BrPostAddr1']='';
        }
        echo '<tr>
-               <td>' . _('Postal Address 1 (Street)').':</td>
-               <td><input tabindex="23" type="text" name="BrPostAddr1"
size="41" maxlength="40" value="'. $_POST['BrPostAddr1'].'" /></td>
+               <td>', _('Postal Address 1 (Street)'), ':</td>
+               <td><input maxlength="40" name="BrPostAddr1" size="41"
tabindex="23" type="text" value="', $_POST['BrPostAddr1'].'" /></td>
                </tr>';

        if(!isset($_POST['BrPostAddr2'])) {// Postal address, line 2.
Database: custbranch.brpostaddr2, varchar(40)
                $_POST['BrPostAddr2']='';
        }
        echo '<tr>
-               <td>' . _('Postal Address 2 (Suburb/City)').':</td>
-               <td><input tabindex="24" type="text" name="BrPostAddr2"
size="41" maxlength="40" value="'. $_POST['BrPostAddr2'].'" /></td>
+               <td>', _('Postal Address 2 (Suburb/City)'), ':</td>
+               <td><input maxlength="40" name="BrPostAddr2" size="41"
tabindex="24" type="text" value="', $_POST['BrPostAddr2'].'" /></td>
                </tr>';

        if(!isset($_POST['BrPostAddr3'])) {// Postal address, line 3.
Database: custbranch.brpostaddr3, varchar(40)
                $_POST['BrPostAddr3']='';
        }
        echo '<tr>
-               <td>' . _('Postal Address 3 (State)').':</td>
-               <td><input tabindex="25" type="text" name="BrPostAddr3"
size="41" maxlength="40" value="'. $_POST['BrPostAddr3'].'" /></td>
+               <td>', _('Postal Address 3 (State)'), ':</td>
+               <td><input maxlength="40" name="BrPostAddr3" size="41"
tabindex="25" type="text" value="', $_POST['BrPostAddr3'].'" /></td>
                </tr>';

        if(!isset($_POST['BrPostAddr4'])) {// Postal address, line 4.
Database: custbranch.brpostaddr4, varchar(40)
                $_POST['BrPostAddr4']='';
        }
        echo '<tr>
-               <td>' . _('Postal Address 4 (Postal Code)').':</td>
-               <td><input tabindex="26" type="text" name="BrPostAddr4"
size="41" maxlength="40" value="'. $_POST['BrPostAddr4'].'" /></td>
+               <td>', _('Postal Address 4 (Postal Code)'), ':</td>
+               <td><input maxlength="40" name="BrPostAddr4" size="41"
tabindex="26" type="text" value="', $_POST['BrPostAddr4'].'" /></td>
                </tr>';

        if(!isset($_POST['BrPostAddr5'])) {// Postal address, line 5.
Database: custbranch.brpostaddr5, varchar(20)
                $_POST['BrPostAddr5']='';
        }
        echo '<tr>
-               <td>' . _('Postal Address 5').':</td>
-               <td><input tabindex="27" type="text" name="BrPostAddr5"
size="21" maxlength="20" value="'. $_POST['BrPostAddr5'].'" /></td>
+               <td>', _('Postal Address 5'), ':</td>
+               <td><input maxlength="20" name="BrPostAddr5" size="21"
tabindex="27" type="text" value="', $_POST['BrPostAddr5'].'" /></td>
                </tr>';

        if(!isset($_POST['CustBranchCode'])) {
                $_POST['CustBranchCode']='';
        }
        echo '<tr>
-               <td>' . _('Customers Internal Branch Code (EDI)').':</td>
-               <td><input tabindex="28" type="text" name="CustBranchCode"
size="31" maxlength="30" value="'. $_POST['CustBranchCode'].'" /></td>
+               <td>', _('Customers Internal Branch Code (EDI)'), ':</td>
+               <td><input maxlength="30" name="CustBranchCode" size="31"
tabindex="28" type="text" value="', $_POST['CustBranchCode'], '" /></td>
                </tr>
                </table>
                <br />
                <div class="centre">
-                       <input tabindex="28" type="submit" name="submit"
value="' . _('Enter Or Update Branch') . '" />
+                       <input name="submit" tabindex="29" type="submit"
value="', _('Enter Or Update Branch'), '" />
                </div>
                </div>
                </form>';

Modified: trunk/DeliveryDetails.php
===================================================================
--- trunk/DeliveryDetails.php   2015-05-10 01:01:51 UTC (rev 7295)
+++ trunk/DeliveryDetails.php   2015-05-10 04:54:12 UTC (rev 7296)
@@ -113,7 +113,7 @@


 elseif(Date1GreaterThanDate2(Date($_SESSION['DefaultDateFormat'],$EarliestDispatch),
$_POST['DeliveryDate'])) {
                $InputErrors =1;
-               echo '<br /><b>' . _('The delivery details cannot be
updated because you are attempting to set the date the order is to be
dispatched earlier than is possible. No dispatches are made on Saturday and
Sunday. Also, the dispatch cut off time is') .
$_SESSION['DispatchCutOffTime']  . _(':00 hrs. Orders placed after this
time will be dispatched the following working day.');
+               echo '<br /><b>' . _('The delivery details cannot be
updated because you are attempting to set the date the order is to be
dispatched earlier than is possible. No dispatches are made on Saturday and
Sunday. Also, the dispatch cut off time is') .
$_SESSION['DispatchCutOffTime'] . _(':00 hrs. Orders placed after this time
will be dispatched the following working day.');
        }

        */
@@ -236,7 +236,7 @@
                - if shippers defined but the default shipper is bogus then
use the first shipper defined
                */
                if((isset($BestShipper) AND $BestShipper=='') AND
($_POST['ShipVia']=='' OR !isset($_POST['ShipVia']))) {
-                       $sql =  "SELECT shipper_id
+                       $sql = "SELECT shipper_id
                                                FROM shippers
                                                WHERE shipper_id='" .
$_SESSION['Default_Shipper']."'";
                        $ErrMsg = _('There was a problem testing for the
default shipper');
@@ -258,7 +258,7 @@
                                        $BestShipper = $ShipperReturned[0];
                                } else {
                                        prnMsg(_('We have a problem') . ' -
' . _('there are no shippers defined'). '. ' . _('Please use the link below
to set up shipping or freight companies') . ', ' . _('the system expects
the shipping company to be selected or a default freight company to be
used'),'error');
-                                       echo '<a href="' . $RootPath .
'Shippers.php">' .  _('Enter') . '/' . _('Amend Freight Companies')  .
'</a>';
+                                       echo '<a href="' . $RootPath .
'Shippers.php">' . _('Enter') . '/' . _('Amend Freight Companies') . '</a>';
                                }
                        }
                        if(isset($_SESSION['Items'.$identifier]->ShipVia)
AND $_SESSION['Items'.$identifier]->ShipVia!='') {
@@ -272,8 +272,8 @@

 if(isset($_POST['MakeRecurringOrder']) AND ! $InputErrors) {

-       echo '<meta http-equiv="Refresh" content="0; url=' . $RootPath .
'/RecurringSalesOrders.php?identifier='.$identifier   .
'&amp;NewRecurringOrder=Yes">';
-       prnMsg(_('You should automatically be forwarded to the entry of
recurring order details page') . '. ' . _('If this does not happen') . '('
. _('if the browser does not support META Refresh') . ') ' . '<a href="' .
$RootPath . '/RecurringOrders.php?identifier='.$identifier  .
'&amp;NewRecurringOrder=Yes">' .  _('click here')  . '</a> '. _('to
continue'),'info');
+       echo '<meta http-equiv="Refresh" content="0; url=' . $RootPath .
'/RecurringSalesOrders.php?identifier='.$identifier  .
'&amp;NewRecurringOrder=Yes">';
+       prnMsg(_('You should automatically be forwarded to the entry of
recurring order details page') . '. ' . _('If this does not happen') . '('
. _('if the browser does not support META Refresh') . ') ' . '<a href="' .
$RootPath . '/RecurringOrders.php?identifier='.$identifier .
'&amp;NewRecurringOrder=Yes">' . _('click here') . '</a> '. _('to
continue'),'info');
        include('includes/footer.inc');
        exit;
 }
@@ -281,8 +281,8 @@

 if(isset($_POST['BackToLineDetails']) and
$_POST['BackToLineDetails']==_('Modify Order Lines')) {

-       echo '<meta http-equiv="Refresh" content="0; url=' . $RootPath .
'/SelectOrderItems.php?identifier='.$identifier   . '">';
-       prnMsg(_('You should automatically be forwarded to the entry of the
order line details page') . '. ' . _('If this does not happen') . '(' .
_('if the browser does not support META Refresh') . ') '  . '<a href="' .
$RootPath . '/SelectOrderItems.php?identifier='.$identifier  . '">' .
_('click here')  . '</a> '. _('to continue'),'info');
+       echo '<meta http-equiv="Refresh" content="0; url=' . $RootPath .
'/SelectOrderItems.php?identifier='.$identifier  . '">';
+       prnMsg(_('You should automatically be forwarded to the entry of the
order line details page') . '. ' . _('If this does not happen') . '(' .
_('if the browser does not support META Refresh') . ') ' . '<a href="' .
$RootPath . '/SelectOrderItems.php?identifier='.$identifier . '">' .
_('click here') . '</a> '. _('to continue'),'info');
        include('includes/footer.inc');
        exit;

@@ -318,7 +318,7 @@

 UNTIL ONLINE CREDIT CARD PROCESSING IS PERFORMED ASSUME OK TO PROCESS

-               NOT YET CODED     */
+               NOT YET CODED   */

                        $OK_to_PROCESS =1;

@@ -540,7 +540,7 @@

                                $FactoryManagerEmail = _('A new work order
has been created for') .

":\n" . $StockItem->StockID . ' - ' . $StockItem->ItemDescription . ' x ' .
$WOQuantity . ' ' . $StockItem->Units .
-
 "\n" . _('These are for') . ' ' .
$_SESSION['Items'.$identifier]->CustomerName . ' ' . _('there order ref') .
': '  . $_SESSION['Items'.$identifier]->CustRef . ' ' ._('our order
number') . ': ' . $OrderNo;
+
 "\n" . _('These are for') . ' ' .
$_SESSION['Items'.$identifier]->CustomerName . ' ' . _('there order ref') .
': ' . $_SESSION['Items'.$identifier]->CustRef . ' ' ._('our order number')
. ': ' . $OrderNo;

                                if($StockItem->Serialised AND
$StockItem->NextSerialNo>0) {
                                                //then we must create the
serial numbers for the new WO also
@@ -603,16 +603,16 @@
                        echo '<br /><table class="selection">
                                        <tr>
                                                <td><img
src="'.$RootPath.'/css/'.$Theme.'/images/printer.png" title="' . _('Print')
. '" alt="" /></td>
-                                               <td>' . ' ' . '<a
target="_blank" href="' . $RootPath .
'/PrintCustOrder.php?identifier='.$identifier . '&amp;TransNo=' . $OrderNo
. '">' .  _('Print packing slip') . ' (' . _('Preprinted stationery') .
')'  . '</a></td>
+                                               <td>' . ' ' . '<a
target="_blank" href="' . $RootPath .
'/PrintCustOrder.php?identifier='.$identifier . '&amp;TransNo=' . $OrderNo
. '">' . _('Print packing slip') . ' (' . _('Preprinted stationery') . ')'
. '</a></td>
                                        </tr>';
                        echo '<tr>
                                        <td><img
src="'.$RootPath.'/css/'.$Theme.'/images/printer.png" title="' . _('Print')
. '" alt="" /></td>
-                                       <td>' . ' ' . '<a  target="_blank"
href="' . $RootPath . '/PrintCustOrder_generic.php?identifier='.$identifier
. '&amp;TransNo=' . $OrderNo . '">' .  _('Print packing slip') . ' (' .
_('Laser') . ')'  . '</a></td>
+                                       <td>' . ' ' . '<a target="_blank"
href="' . $RootPath . '/PrintCustOrder_generic.php?identifier='.$identifier
. '&amp;TransNo=' . $OrderNo . '">' . _('Print packing slip') . ' (' .
_('Laser') . ')' . '</a></td>
                                </tr>';

                        echo '<tr>
                                        <td><img
src="'.$RootPath.'/css/'.$Theme.'/images/reports.png" title="' .
_('Invoice') . '" alt="" /></td>
-                                       <td>' . ' ' . '<a href="' .
$RootPath . '/ConfirmDispatch_Invoice.php?identifier='.$identifier .
'&amp;OrderNumber=' . $OrderNo .'">' .  _('Confirm Dispatch and Produce
Invoice')  . '</a></td>
+                                       <td>' . ' ' . '<a href="' .
$RootPath . '/ConfirmDispatch_Invoice.php?identifier='.$identifier .
'&amp;OrderNumber=' . $OrderNo .'">' . _('Confirm Dispatch and Produce
Invoice') . '</a></td>
                                </tr>';

                        echo '</table>';
@@ -622,7 +622,7 @@
                        echo '<br /><table class="selection">
                                        <tr>
                                                <td><img
src="'.$RootPath.'/css/'.$Theme.'/images/printer.png" title="' . _('Order')
. '" alt=""></td>
-                                               <td>' . ' ' . '<a href="' .
$RootPath . '/PDFQuotation.php?identifier='.$identifier .
'&amp;QuotationNo=' . $OrderNo . '" target="_blank">' .  _('Print Quotation
(Landscape)')  . '</a></td>
+                                               <td>' . ' ' . '<a href="' .
$RootPath . '/PDFQuotation.php?identifier='.$identifier .
'&amp;QuotationNo=' . $OrderNo . '" target="_blank">' . _('Print Quotation
(Landscape)') . '</a></td>
                                        </tr>
                                        </table>';
                        echo '<br /><table class="selection">
@@ -1007,29 +1007,30 @@
        </tr>';

 echo '<tr>
-       <td>' .  _('Deliver from the warehouse at') .':</td>
+       <td>', _('Deliver from the warehouse at'), ':</td>
        <td><select name="Location">';

 if($_SESSION['Items'.$identifier]->Location=='' OR
!isset($_SESSION['Items'.$identifier]->Location)) {
        $_SESSION['Items'.$identifier]->Location = $DefaultStockLocation;
 }

+// BEGIN:
**********************************************************************
+$SQL = "SELECT locations.loccode, locationname
+       FROM locations
+       INNER JOIN locationusers
+       ON locationusers.loccode=locations.loccode
+               AND locationusers.userid='" . $_SESSION['UserID'] . "'
+               AND locationusers.canupd=1
+       WHERE locations.allowinvoicing='1'";
 $ErrMsg = _('The stock locations could not be retrieved');
 $DbgMsg = _('SQL used to retrieve the stock locations was') . ':';
-$StkLocsResult = DB_query("SELECT locationname,locations.loccode
-                                                       FROM locations
INNER JOIN locationusers ON locationusers.loccode=locations.loccode AND
locationusers.userid='" .  $_SESSION['UserID'] . "' AND
locationusers.canupd=1",
-                                               $ErrMsg,
-                                               $DbgMsg);
-
-while ($myrow=DB_fetch_array($StkLocsResult)) {
-       if($_SESSION['Items'.$identifier]->Location==$myrow['loccode']) {
-               echo '<option selected="selected" value="' .
$myrow['loccode'] . '">' . $myrow['locationname'] . '</option>';
-       } else {
-               echo '<option value="'.$myrow['loccode'].'">' .
$myrow['locationname'] . '</option>';
-       }
+$StkLocsResult = DB_query($SQL, $ErrMsg, $DbgMsg);
+// COMMENT: What if there is no authorized locations available for this
user?
+while($myrow=DB_fetch_array($StkLocsResult)) {
+       echo '<option',
($_SESSION['Items'.$identifier]->Location==$myrow['loccode'] ? '
selected="selected"' : ''), ' value="', $myrow['loccode'], '">',
$myrow['locationname'], '</option>';
 }
-
 echo '</select></td></tr>';
+// END:
************************************************************************

 // Set the default date to earliest possible date if not set already
 if(!isset($_SESSION['Items'.$identifier]->DeliveryDate)) {

Modified: trunk/Locations.php
===================================================================
--- trunk/Locations.php 2015-05-10 01:01:51 UTC (rev 7295)
+++ trunk/Locations.php 2015-05-10 04:54:12 UTC (rev 7296)
@@ -77,7 +77,9 @@

cashsalebranch ='" . $_POST['CashSaleBranch'] . "',

managed = '" . $_POST['Managed'] . "',

internalrequest = '" . $_POST['InternalRequest'] . "',
-
 usedforwo = '" . $_POST['UsedForWO'] . "'
+
 usedforwo = '" . $_POST['UsedForWO'] . "',
+
 glaccountcode = '" . $_POST['GLAccountCode'] . "',
+
 allowinvoicing = '" . $_POST['AllowInvoicing'] . "'
                                                WHERE loccode = '" .
$SelectedLocation . "'";

                $ErrMsg = _('An error occurred updating the') . ' ' .
$SelectedLocation . ' ' . _('location record because');
@@ -105,6 +107,8 @@
                unset($_POST['Contact']);
                unset($_POST['InternalRequest']);
                unset($_POST['UsedForWO']);
+               unset($_POST['GLAccountCode']);
+               unset($_POST['AllowInvoicing']);


        } elseif($InputError !=1) {
@@ -135,7 +139,9 @@

    cashsalebranch,

    managed,

    internalrequest,
-
     usedforwo)
+
     usedforwo,
+
     glaccountcode,
+
     allowinvoicing)
                                                VALUES ('" .
$_POST['LocCode'] . "',
                                                                '" .
$_POST['LocationName'] . "',
                                                                '" .
$_POST['DelAdd1'] ."',
@@ -150,13 +156,15 @@
                                                                '" .
$_POST['Contact'] . "',
                                                                '" .
$_POST['TaxProvince'] . "',
                                                                '" .
$_POST['CashSaleCustomer'] . "',
-                                                       '" .
$_POST['CashSaleBranch'] . "',
+                                                               '" .
$_POST['CashSaleBranch'] . "',
                                                                '" .
$_POST['Managed'] . "',
-                                                               '" .
$_POST['InternalRequest'] ."',
-                                                               '" .
$_POST['UsedForWO'] . "')";
+                                                               '" .
$_POST['InternalRequest'] . "',
+                                                               '" .
$_POST['UsedForWO'] . "',
+                                                               '" .
$_POST['GLAccountCode'] . "',
+                                                               '" .
$_POST['AllowInvoicing'] . "')";

-               $ErrMsg =  _('An error occurred inserting the new location
record because');
-               $DbgMsg =  _('The SQL used to insert the location record
was');
+               $ErrMsg = _('An error occurred inserting the new location
record because');
+               $DbgMsg = _('The SQL used to insert the location record
was');
                $result = DB_query($sql,$ErrMsg,$DbgMsg);

                prnMsg(_('The new location record has been
added'),'success');
@@ -174,10 +182,10 @@
                                0
                        FROM stockmaster";

-               $ErrMsg =  _('An error occurred inserting the new location
stock records for all pre-existing parts because');
-               $DbgMsg =  _('The SQL used to insert the new stock location
records was');
+               $ErrMsg = _('An error occurred inserting the new location
stock records for all pre-existing parts because');
+               $DbgMsg = _('The SQL used to insert the new stock location
records was');
                $result = DB_query($sql,$ErrMsg, $DbgMsg);
-               prnMsg ('........ ' . _('and new stock locations inserted
for all existing stock items for the new location'), 'success');
+               prnMsg('........ ' . _('and new stock locations inserted
for all existing stock items for the new location'), 'success');

        /* Also need to add locationuser records for all existing users*/
                $sql = "INSERT INTO locationusers (userid, loccode,
canview, canupd)
@@ -190,7 +198,7 @@
                                ON www_users.userid = locationusers.userid
                                AND locations.loccode =
locationusers.loccode
                                WHERE locationusers.userid IS NULL
-                               AND  locations.loccode='".
$_POST['LocCode'] . "';";
+                               AND locations.loccode='". $_POST['LocCode']
. "';";

                $ErrMsg = _('The users/locations that need user location
records created cannot be retrieved because');
                $Result = DB_query($sql,$ErrMsg);
@@ -215,7 +223,8 @@
                unset($_POST['Contact']);
                unset($_POST['InternalRequest']);
                unset($_POST['UsedForWO']);
-
+               unset($_POST['GLAccountCode']);
+               unset($_POST['AllowInvoicing']);
        }


@@ -267,7 +276,7 @@
        if($myrow[0]>0) {
                $CancelDelete = 1;
                prnMsg(_('Cannot delete this location because sales orders
have been created delivering from this location'),'warn');
-               echo  _('There are') . ' ' . $myrow[0] . ' ' . _('sales
orders with this Location code');
+               echo _('There are') . ' ' . $myrow[0] . ' ' . _('sales
orders with this Location code');
        } else {
                $sql= "SELECT COUNT(*) FROM stockmoves WHERE
stockmoves.loccode='" . $SelectedLocation . "'";
                $result = DB_query($sql);
@@ -385,20 +394,24 @@
        $sql = "SELECT loccode,
                                locationname,
                                taxprovinces.taxprovincename as description,
+                               glaccountcode,
+                               allowinvoicing,
                                managed
                        FROM locations INNER JOIN taxprovinces
                        ON
locations.taxprovinceid=taxprovinces.taxprovinceid";
        $result = DB_query($sql);

        if(DB_num_rows($result)==0) {
-               prnMsg (_('There are no locations that match up with a tax
province record to display. Check that tax provinces are set up for all
dispatch locations'),'error');
+               prnMsg(_('There are no locations that match up with a tax
province record to display. Check that tax provinces are set up for all
dispatch locations'),'error');
        }

-       echo '<table class="selection">';
-       echo '<tr>
-                       <th class="ascending">' . _('Location Code') .
'</th>
-                       <th class="ascending">' . _('Location Name') .
'</th>
-                       <th class="ascending">' . _('Tax Province') . '</th>
+       echo '<table class="selection">
+               <tr>
+                       <th class="ascending">', _('Location Code'), '</th>
+                       <th class="ascending">', _('Location Name'), '</th>
+                       <th class="ascending">', _('Tax Province'), '</th>
+                       <th class="ascending">', _('GL Account Code'),
'</th>
+                       <th class="ascending">', _('Allow Invoicing'),
'</th>
                        <th class="noprint" colspan="2">&nbsp;</th>
                </tr>';

@@ -414,22 +427,25 @@
 /* warehouse management not implemented ... yet
        if($myrow['managed'] == 1) {
                $myrow['managed'] = _('Yes');
-       }  else {
+       } else {
                $myrow['managed'] = _('No');
        }
 */
        printf('<td>%s</td>
                        <td>%s</td>
                        <td>%s</td>
+                       <td class="number">%s</td>
+                       <td class="centre">%s</td>
                        <td class="noprint"><a
href="%sSelectedLocation=%s">' . _('Edit') . '</a></td>
                        <td class="noprint"><a
href="%sSelectedLocation=%s&amp;delete=1" onclick="return confirm(\'' .
_('Are you sure you wish to delete this inventory location?') . '\');">' .
_('Delete') . '</a></td>
                        </tr>',
                        $myrow['loccode'],
                        $myrow['locationname'],
                        $myrow['description'],
+                       ($myrow['glaccountcode']!='' ?
$myrow['glaccountcode'] : '&nbsp;'),// Use a non-breaking space to avoid an
empty cell in a HTML table.
+                       ($myrow['allowinvoicing']==1 ? _('Yes') : _('No')),

htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '?',
$myrow['loccode'],

htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '?',
$myrow['loccode']);
-
        }
        //END WHILE LIST LOOP
        echo '</table>';
@@ -446,7 +462,7 @@
 if(!isset($_GET['delete'])) {

        echo '<form method="post" action="' .
htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '">';
-    echo '<div>';
+       echo '<div>';
        echo '<input type="hidden" name="FormID" value="' .
$_SESSION['FormID'] . '" />';

        if(isset($SelectedLocation)) {
@@ -469,7 +485,9 @@
                                        cashsalebranch,
                                        managed,
                                        internalrequest,
-                                       usedforwo
+                                       usedforwo,
+                                       glaccountcode,
+                                       allowinvoicing
                                FROM locations
                                WHERE loccode='" . $SelectedLocation . "'";

@@ -477,7 +495,7 @@
                $myrow = DB_fetch_array($result);

                $_POST['LocCode'] = $myrow['loccode'];
-               $_POST['LocationName']  = $myrow['locationname'];
+               $_POST['LocationName'] = $myrow['locationname'];
                $_POST['DelAdd1'] = $myrow['deladd1'];
                $_POST['DelAdd2'] = $myrow['deladd2'];
                $_POST['DelAdd3'] = $myrow['deladd3'];
@@ -494,8 +512,9 @@
                $_POST['Managed'] = $myrow['managed'];
                $_POST['InternalRequest'] = $myrow['internalrequest'];
                $_POST['UsedForWO'] = $myrow['usedforwo'];
+               $_POST['GLAccountCode'] = $myrow['glaccountcode'];
+               $_POST['AllowInvoicing'] = $myrow['allowinvoicing'];

-
                echo '<input type="hidden" name="SelectedLocation" value="'
. $SelectedLocation . '" />';
                echo '<input type="hidden" name="LocCode" value="' .
$_POST['LocCode'] . '" />';
                echo '<table class="selection">';
@@ -561,9 +580,12 @@
        if(!isset($_POST['Managed'])) {
                $_POST['Managed'] = 0;
        }
+       if(!isset($_POST['AllowInvoicing'])) {
+               $_POST['AllowInvoicing'] = 1;// If not set, set value to
"Yes".
+       }

        echo '<tr>
-                       <td>' .  _('Location Name') . ':' . '</td>
+                       <td>' . _('Location Name') . ':' . '</td>
                        <td><input type="text" name="LocationName"
required="required" value="'. $_POST['LocationName'] . '" title="' .
_('Enter the inventory location name this could be either a warehouse or a
factory') . '" namesize="51" maxlength="50" /></td>
                </tr>
                <tr>
@@ -571,23 +593,23 @@
                        <td><input type="text" name="Contact"
required="required" value="' . $_POST['Contact'] . '" title="' . _('Enter
the name of the responsible person to contact for this inventory location')
. '" size="31" maxlength="30" /></td>
                </tr>
                <tr>
-                       <td>' .  _('Delivery Address 1 (Building)') . ':' .
'</td>
+                       <td>' . _('Delivery Address 1 (Building)') . ':' .
'</td>
                        <td><input type="text" name="DelAdd1" value="' .
$_POST['DelAdd1'] . '" size="41" maxlength="40" /></td>
                </tr>
                <tr>
                        <td>' . _('Delivery Address 2 (Street)') . ':' .
'</td>
-                       <td><input type="text" name="DelAdd2" value="' .
$_POST['DelAdd2'] . '" size="41" maxlength="40" /></td>
+                       <td><input type="text" name="DelAdd2" value="' .
$_POST['DelAdd2'] . '" size="41" maxlength="40" /></td>
                </tr>
                <tr>
-                       <td>' .  _('Delivery Address 3 (Suburb)') . ':' .
'</td>
-                       <td><input type="text" name="DelAdd3" value="' .
$_POST['DelAdd3'] . '" size="41" maxlength="40" /></td>
+                       <td>' . _('Delivery Address 3 (Suburb)') . ':' .
'</td>
+                       <td><input type="text" name="DelAdd3" value="' .
$_POST['DelAdd3'] . '" size="41" maxlength="40" /></td>
                </tr>
                <tr>
-                       <td>' .  _('Delivery Address 4 (City)') . ':' .
'</td>
+                       <td>' . _('Delivery Address 4 (City)') . ':' .
'</td>
                        <td><input type="text" name="DelAdd4" value="' .
$_POST['DelAdd4'] . '" size="41" maxlength="40" /></td>
                </tr>
                <tr>
-                       <td>' .  _('Delivery Address 5 (Zip Code)') . ':' .
'</td>
+                       <td>' . _('Delivery Address 5 (Zip Code)') . ':' .
'</td>
                        <td><input type="text" name="DelAdd5" value="' .
$_POST['DelAdd5'] . '" size="21" maxlength="20" /></td>
                </tr>
                <tr>
@@ -595,29 +617,29 @@
                        <td><select name="DelAdd6">';
                foreach ($CountriesArray as $CountryEntry => $CountryName) {
                        if(isset($_POST['DelAdd6']) AND
(strtoupper($_POST['DelAdd6']) == strtoupper($CountryName))) {
-                               echo '<option selected="selected" value="'
. $CountryName . '">' . $CountryName  . '</option>';
-                       }elseif(!isset($_POST['Address6']) AND $CountryName
== "") {
-                               echo '<option selected="selected" value="'
. $CountryName . '">' . $CountryName  . '</option>';
+                               echo '<option selected="selected" value="'
. $CountryName . '">' . $CountryName . '</option>';
+                       } elseif(!isset($_POST['Address6']) AND
$CountryName == "") {
+                               echo '<option selected="selected" value="'
. $CountryName . '">' . $CountryName . '</option>';
                        } else {
-                               echo '<option value="' . $CountryName .
'">' . $CountryName  . '</option>';
+                               echo '<option value="' . $CountryName .
'">' . $CountryName . '</option>';
                        }
                }
                echo '</select></td>
                </tr>
                <tr>
-                       <td>' .  _('Telephone No') . ':' . '</td>
-                       <td><input type="tel" name="Tel"
pattern="[0-9+\-\s()]*" value="' . $_POST['Tel'] . '" size="31"
maxlength="30" title="' . _('The phone number should consist of numbers,
spaces, parentheses, or the + character') . '" /></td>
+                       <td>' . _('Telephone No') . ':' . '</td>
+                       <td><input name="Tel" type="tel"
pattern="[0-9+\-\s()]*" value="' . $_POST['Tel'] . '" size="31"
maxlength="30" title="' . _('The phone number should consist of numbers,
spaces, parentheses, or the + character') . '" /></td>
                </tr>
                <tr>
-                       <td>' .  _('Facsimile No') . ':' . '</td>
-                       <td><input type="tel" name="Fax"
pattern="[0-9+\-\s()]*" value="' . $_POST['Fax'] . '" size="31"
maxlength="30" title="' . _('The fax number should consist of numbers,
parentheses, spaces or the + character') . '"/></td>
+                       <td>' . _('Facsimile No') . ':' . '</td>
+                       <td><input name="Fax" type="tel"
pattern="[0-9+\-\s()]*" value="' . $_POST['Fax'] . '" size="31"
maxlength="30" title="' . _('The fax number should consist of numbers,
parentheses, spaces or the + character') . '"/></td>
                </tr>
                <tr>
-                       <td>' .  _('Email') . ':' . '</td>
-                       <td><input type="email" name="Email" value="' .
$_POST['Email'] . '" size="31" maxlength="55" /></td>
+                       <td>' . _('Email') . ':' . '</td>
+                       <td><input name="Email" type="email" value="' .
$_POST['Email'] . '" size="31" maxlength="55" /></td>
                </tr>
                <tr>
-                       <td>' .  _('Tax Province') . ':' . '</td>
+                       <td>' . _('Tax Province') . ':' . '</td>
                        <td><select name="TaxProvince">';

        $TaxProvinceResult = DB_query("SELECT taxprovinceid,
taxprovincename FROM taxprovinces");
@@ -668,6 +690,18 @@
                echo '<option value="0">' . _('No') . '</option>';
        }
        echo '</select></td></tr>';
+       // Location's ledger account:
+       echo '<tr title="', _('Enter the GL account for this location, or
leave it in blank if not needed'), '">
+                       <td><label for="GLAccountCode">', _('GL Account
Code'), ':</label></td>
+                       <td><input data-type="no-illegal-chars"
id="GLAccountCode" maxlength="20" name="GLAccountCode" size="20"
type="text" value="', $_POST['GLAccountCode'], '" /></td></tr>';
+       // Allow or deny the invoicing of items in this location:
+       echo '<tr title="', _('Use this parameter to indicate whether these
inventory location allows or denies the invoicing of its items.'), '">
+                       <td><label for="AllowInvoicing">', _('Allow
Invoicing'), ':</label></td>
+                       <td><select name="AllowInvoicing">
+                               <option', ($_POST['AllowInvoicing']==1 ? '
selected="selected"' : ''), ' value="1">', _('Yes'), '</option>
+                               <option', ($_POST['AllowInvoicing']==0 ? '
selected="selected"' : ''), ' value="0">', _('No'), '</option>
+                       </select></td>
+               </tr>';

        /*
        This functionality is not written yet ...
@@ -677,12 +711,12 @@
        echo '</table>
                <br />
                <div class="centre">
-                       <input type="submit" name="submit" value="' .
_('Enter Information') . '" />
+                       <input type="submit" name="submit" value="' .
_('Enter Information') . '" />
                </div>
-        </div>
+               </div>
                </form>';

 } //end if record deleted no point displaying form to add record

 include('includes/footer.inc');
-?>
+?>
\ No newline at end of file

Modified: trunk/StockLocTransferReceive.php
===================================================================
--- trunk/StockLocTransferReceive.php   2015-05-10 01:01:51 UTC (rev 7295)
+++ trunk/StockLocTransferReceive.php   2015-05-10 04:54:12 UTC (rev 7296)
@@ -6,21 +6,22 @@
 include('includes/DefineStockTransfers.php');

 include('includes/session.inc');
-$Title = _('Inventory Transfer') . ' - ' . _('Receiving');
-$BookMark = "LocationTransfers";
-$ViewTopic = "Inventory";
+$Title = _('Inventory Transfer') . ' - ' . _('Receiving');// Screen
identification.
+$ViewTopic = 'Inventory';// Filename's id in ManualContents.php's TOC.
+$BookMark = 'LocationTransfers';// Anchor's id in the manual's html
document.
 include('includes/header.inc');
+
 include('includes/SQL_CommonFunctions.inc');

-if (isset($_GET['NewTransfer'])){
+if(isset($_GET['NewTransfer'])) {
        unset($_SESSION['Transfer']);
 }
-if ( isset($_SESSION['Transfer']) and $_SESSION['Transfer']->TrfID == ''){
+if(isset($_SESSION['Transfer']) and $_SESSION['Transfer']->TrfID == '') {
        unset($_SESSION['Transfer']);
 }


-if(isset($_POST['ProcessTransfer'])){
+if(isset($_POST['ProcessTransfer'])) {
 /*Ok Time To Post transactions to Inventory Transfers, and Update Posted
variable & received Qty's  to LocTransfers */

        $PeriodNo = GetPeriod ($_SESSION['Transfer']->TranDate, $db);
@@ -30,24 +31,24 @@
        $i=0;
        $TotalQuantity = 0;
        foreach ($_SESSION['Transfer']->TransferItem AS $TrfLine) {
-               if (is_numeric(filter_number_format($_POST['Qty' . $i]))){
+               if(is_numeric(filter_number_format($_POST['Qty' . $i]))) {
                /*Update the quantity received from the inputs */
                        $_SESSION['Transfer']->TransferItem[$i]->Quantity=
round(filter_number_format($_POST['Qty' .
$i]),$_SESSION['Transfer']->TransferItem[$i]->DecimalPlaces);
-               } elseif ($_POST['Qty' . $i]=='') {
+               } elseif($_POST['Qty' . $i]=='') {
                        $_SESSION['Transfer']->TransferItem[$i]->Quantity=
0;
-               } else {
+               } else {
                        prnMsg(_('The quantity entered for'). ' ' .
$TrfLine->StockID . ' '. _('is not numeric') . '. ' . _('All quantities
must be numeric'),'error');
                        $InputError = True;
                }
-               if (filter_number_format($_POST['Qty' . $i])<0){
+               if(filter_number_format($_POST['Qty' . $i])<0) {
                        prnMsg(_('The quantity entered for'). ' ' .
$TrfLine->StockID . ' '. _('is negative') . '. ' . _('All quantities must
be for positive numbers greater than zero'),'error');
                        $InputError = True;
                }
-               if ($TrfLine->PrevRecvQty + $TrfLine->Quantity >
$TrfLine->ShipQty){
+               if($TrfLine->PrevRecvQty + $TrfLine->Quantity >
$TrfLine->ShipQty) {
                        prnMsg( _('The Quantity entered plus the Quantity
Previously Received can not be greater than the Total Quantity shipped
for').' '. $TrfLine->StockID , 'error');
                        $InputError = True;
                }
-               if (isset($_POST['CancelBalance' . $i]) and
$_POST['CancelBalance' . $i]==1){
+               if(isset($_POST['CancelBalance' . $i]) and
$_POST['CancelBalance' . $i]==1) {

$_SESSION['Transfer']->TransferItem[$i]->CancelBalance=1;
                } else {

 $_SESSION['Transfer']->TransferItem[$i]->CancelBalance=0;
@@ -55,16 +56,16 @@
                $TotalQuantity += $TrfLine->Quantity;
                $i++;
        } /*end loop to validate and update the SESSION['Transfer'] data */
-       if ($TotalQuantity < 0){
+       if($TotalQuantity < 0) {
                prnMsg( _('All quantities entered are less than zero') . '.
' . _('Please correct that and try again'), 'error' );
                $InputError = True;
        }
 //exit;
-       if (!$InputError){
+       if(!$InputError) {
        /*All inputs must be sensible so make the stock movement records
and update the locations stocks */

                foreach ($_SESSION['Transfer']->TransferItem AS $TrfLine) {
-                       if ($TrfLine->Quantity >=0){
+                       if($TrfLine->Quantity >=0) {
                                $Result = DB_Txn_Begin();

                                /* Need to get the current location
quantity will need it later for the stock movement */
@@ -74,7 +75,7 @@
                                                AND loccode= '" .
$_SESSION['Transfer']->StockLocationFrom . "'";

                                $Result = DB_query($SQL, _('Could not
retrieve the stock quantity at the dispatch stock location prior to this
transfer being processed') );
-                               if (DB_num_rows($Result)==1){
+                               if(DB_num_rows($Result)==1) {
                                        $LocQtyRow = DB_fetch_row($Result);
                                        $QtyOnHandPrior = $LocQtyRow[0];
                                } else {
@@ -115,8 +116,8 @@

                /*Insert the StockSerialMovements and update the
StockSerialItems  for controlled items*/

-                               if ($TrfLine->Controlled ==1){
-                                       foreach($TrfLine->SerialItems as
$Item){
+                               if($TrfLine->Controlled ==1) {
+                                       foreach($TrfLine->SerialItems as
$Item) {
                                        /*We need to add or update the
StockSerialItem record and
                                        The StockSerialMoves as well */

@@ -131,7 +132,7 @@
                                                $Result =
DB_query($SQL,'<br />' . _('Could not determine if the serial item exists')
);
                                                $SerialItemExistsRow =
DB_fetch_row($Result);

-                                               if
($SerialItemExistsRow[0]==1){
+
 if($SerialItemExistsRow[0]==1) {

                                                        $SQL = "UPDATE
stockserialitems SET
                                                                quantity=
quantity - " . $Item->BundleQty . "
@@ -188,7 +189,7 @@
                                                AND loccode= '" .
$_SESSION['Transfer']->StockLocationTo . "'";

                                $Result = DB_query($SQL,  _('Could not
retrieve the quantity on hand at the location being transferred to') );
-                               if (DB_num_rows($Result)==1){
+                               if(DB_num_rows($Result)==1) {
                                        $LocQtyRow = DB_fetch_row($Result);
                                        $QtyOnHandPrior = $LocQtyRow[0];
                                } else {
@@ -196,6 +197,49 @@
                                        $QtyOnHandPrior = 0;
                                }

+// COMMENT: "if($TrfLine->Quantity !=0) {}" should be as a general
condition to avoid transactions in zero.
+
+// BEGIN:
**********************************************************************
+                               // Insert outgoing inventory GL transaction
if any of the locations has a GL account code:
+
 if(($_SESSION['Transfer']->StockLocationFromAccount !='' or
$_SESSION['Transfer']->StockLocationToAccount !='') and $TrfLine->Quantity
!=0) {
+                                       // Get the account code:
+
 if($_SESSION['Transfer']->StockLocationFromAccount !='') {
+                                               $AccountCode =
$_SESSION['Transfer']->StockLocationFromAccount;
+                                       } else {
+                                               $StockGLCode =
GetStockGLCode($TrfLine->StockID, $db);// Get Category's account codes.
+                                               $AccountCode =
$StockGLCode['stockact'];// Select account code for stock.
+                                       }
+                                       // Get the item cost:
+                                       $SQLstandardcost = "SELECT
stockmaster.materialcost + stockmaster.labourcost +
stockmaster.overheadcost AS standardcost
+
     FROM stockmaster
+
     WHERE stockmaster.stockid ='" . $TrfLine->StockID . "'";
+                                       $ErrMsg = _('The standard cost of
the item cannot be retrieved because');
+                                       $DbgMsg = _('The SQL that failed
was');
+                                       $myrow =
DB_fetch_array(DB_query($SQLstandardcost,$ErrMsg,$DbgMsg));
+                                       $StandardCost =
$myrow['standardcost'];// QUESTION: Standard cost for: Assembly (value="A")
and Manufactured (value="M") items ?
+                                       // Insert record:
+                                       $SQL = "INSERT INTO gltrans (
+                                                       periodno,
+                                                       trandate,
+                                                       type,
+                                                       typeno,
+                                                       account,
+                                                       narrative,
+                                                       amount)
+                                               VALUES ('" .
+                                                       $PeriodNo . "','" .
+                                                       $SQLTransferDate .
+                                                       "',16,'" .
+
 $_SESSION['Transfer']->TrfID . "','" .
+                                                       $AccountCode .
"','" .
+
 $_SESSION['Transfer']->StockLocationFrom.' - '.$TrfLine->StockID.' x
'.$TrfLine->Quantity.' @ '. $StandardCost . "','" .
+                                                       -$TrfLine->Quantity
* $StandardCost . "')";
+                                       $ErrMsg =  _('CRITICAL ERROR') . '!
' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The outgoing
inventory GL transacction record could not be inserted because');
+                                       $DbgMsg =  _('The following SQL to
insert records was used');
+                                       $Result = DB_query($SQL, $ErrMsg,
$DbgMsg, true);
+                               }
+// END:
************************************************************************
+
                                // Insert the stock movement for the stock
coming into the to location
                                $SQL = "INSERT INTO stockmoves (stockid,

                    type,
@@ -228,13 +272,11 @@
                                /*Get the ID of the StockMove... */
                                $StkMoveNo =
DB_Last_Insert_ID($db,'stockmoves','stkmoveno');

-               /*Insert the StockSerialMovements and update the
StockSerialItems  for controlled items*/
+                               /*Insert the StockSerialMovements and
update the StockSerialItems  for controlled items*/
+                               if($TrfLine->Controlled ==1) {
+                                       foreach($TrfLine->SerialItems as
$Item) {
+                                       /*We need to add or update the
StockSerialItem record and the StockSerialMoves as well */

-                               if ($TrfLine->Controlled ==1){
-                                       foreach($TrfLine->SerialItems as
$Item){
-                                       /*We need to add or update the
StockSerialItem record and
-                                       The StockSerialMoves as well */
-
                                                /*First need to check if
the serial items already exists or not in the location to */
                                                $SQL = "SELECT COUNT(*)
                                                        FROM
stockserialitems
@@ -247,7 +289,7 @@
                                                $SerialItemExistsRow =
DB_fetch_row($Result);


-                                               if
($SerialItemExistsRow[0]==1){
+
 if($SerialItemExistsRow[0]==1) {

                                                        $SQL = "UPDATE
stockserialitems SET
                                                                quantity=
quantity + '" . $Item->BundleQty . "'
@@ -312,9 +354,50 @@
                                $DbgMsg =  _('The following SQL to update
the stock record was used');
                                $Result = DB_query($SQL, $ErrMsg, $DbgMsg,
true);

+// BEGIN:
**********************************************************************
+                               // Insert incoming inventory GL transaction
if any of the locations has a GL account code:
+
 if(($_SESSION['Transfer']->StockLocationFromAccount !='' or
$_SESSION['Transfer']->StockLocationToAccount !='') and $TrfLine->Quantity
!=0) {
+                                       // Get the account code:
+
 if($_SESSION['Transfer']->StockLocationToAccount !='') {
+                                               $AccountCode =
$_SESSION['Transfer']->StockLocationToAccount;
+                                       } else {
+                                               $StockGLCode =
GetStockGLCode($TrfLine->StockID, $db);// Get Category's account codes.
+                                               $AccountCode =
$StockGLCode['stockact'];// Select account code for stock.
+                                       }
+                                       // Get the item cost:
+                                       $SQLstandardcost = "SELECT
stockmaster.materialcost + stockmaster.labourcost +
stockmaster.overheadcost AS standardcost
+
     FROM stockmaster
+
     WHERE stockmaster.stockid ='" . $TrfLine->StockID . "'";
+                                       $ErrMsg = _('The standard cost of
the item cannot be retrieved because');
+                                       $DbgMsg = _('The SQL that failed
was');
+                                       $myrow =
DB_fetch_array(DB_query($SQLstandardcost,$ErrMsg,$DbgMsg));
+                                       $StandardCost =
$myrow['standardcost'];// QUESTION: Standard cost for: Assembly (value="A")
and Manufactured (value="M") items ?
+                                       // Insert record:
+                                       $SQL = "INSERT INTO gltrans (
+                                                       periodno,
+                                                       trandate,
+                                                       type,
+                                                       typeno,
+                                                       account,
+                                                       narrative,
+                                                       amount)
+                                               VALUES ('" .
+                                                       $PeriodNo . "','" .
+                                                       $SQLTransferDate .
"',
+                                                       16,'" .
+
 $_SESSION['Transfer']->TrfID . "','" .
+                                                       $AccountCode .
"','" .
+
 $_SESSION['Transfer']->StockLocationTo.' - '.$TrfLine->StockID.' x
'.$TrfLine->Quantity.' @ '. $StandardCost . "','" .
+                                                       $TrfLine->Quantity
* $StandardCost . "')";
+                                       $ErrMsg =  _('CRITICAL ERROR') . '!
' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The incoming
inventory GL transacction record could not be inserted because');
+                                       $DbgMsg =  _('The following SQL to
insert records was used');
+                                       $Result = DB_query($SQL, $ErrMsg,
$DbgMsg, true);
+                               }
+// END:
************************************************************************
+
                                prnMsg(_('A stock transfer for item code').
' - '  . $TrfLine->StockID . ' ' . $TrfLine->ItemDescription . ' '. _('has
been created from').' ' . $_SESSION['Transfer']->StockLocationFromName . '
'. _('to'). ' ' . $_SESSION['Transfer']->StockLocationToName . ' ' . _('for
a quantity of'). ' '. $TrfLine->Quantity,'success');

-                               if ($TrfLine->CancelBalance==1){
+                               if($TrfLine->CancelBalance==1) {
                                        $sql = "UPDATE loctransfers SET
recqty = recqty + '". round($TrfLine->Quantity, $TrfLine->DecimalPlaces) .
"',
                                                shipqty = recqty + '".
round($TrfLine->Quantity, $TrfLine->DecimalPlaces) . "',
                                                                recdate =
'".Date('Y-m-d H:i:s'). "'
@@ -323,22 +406,22 @@
                                } else {
                                        $sql = "UPDATE loctransfers SET
recqty = recqty + '". round($TrfLine->Quantity, $TrfLine->DecimalPlaces) .
"',
                                                                recdate =
'".Date('Y-m-d H:i:s'). "'
-                                                       WHERE reference =
'". $_SESSION['Transfer']->TrfID . "'
-                                                               AND stockid
= '".  $TrfLine->StockID."'";
+                                               WHERE reference = '".
$_SESSION['Transfer']->TrfID . "'
+                                               AND stockid = '".
$TrfLine->StockID."'";
                                }
                                $ErrMsg =  _('CRITICAL ERROR') . '! ' .
_('Unable to update the Location Transfer Record');
                                $Result = DB_query($sql, $ErrMsg, $DbgMsg,
true);
                                unset ($_SESSION['Transfer']->LineItem[$i]);
                                unset ($_POST['Qty' . $i]);
                        } /*end if Quantity > 0 */
-                       if ($TrfLine->CancelBalance==1){
+                       if($TrfLine->CancelBalance==1) {
                                $sql = "UPDATE loctransfers SET shipqty =
recqty
                                                WHERE reference = '".
$_SESSION['Transfer']->TrfID . "'
                                                AND stockid = '".
$TrfLine->StockID."'";
                                $ErrMsg =  _('CRITICAL ERROR') . '! ' .
_('Un...
 
[truncated message content]

Re: [WebERP-developers] Location with GLAccount code. Help.

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

Hi,

Thanks Ricard and Tim for your comments.

I tested those scripts (
http://unstable.verdorama.systems/downloads/Location_with_GLAccount_code.zip
) in a commercial company (they buy and sell only finished goods, they do
not re-pack) and I do not have cases for testing with Assembly (value="A")
and Manufactured (value="M") items. Before release the code, I want to test
those cases.

The commercial company wants an automatic and documentary way to move goods
from the "merchandise inventory" account to the "pledged inventory" or
"goods on consignment" accounts. That is: (1) they want the people with
role that includes the security token "Inventory Management and Pricing"
can do the movement instead of accounting people (Main Menu -> General
Ledger -> Transactions -> Journal Entry); and (2) they want a signed paper
of the movement (inventory location transfer) because the pledged/consignee
warehouse is in other people's control. The scripts are now working in this
company, but --if it is possible-- I prefer a solution without any extra
coding.

Also, they want to allow or deny invoicing from those locations. I think
invoicing from a pledged inventory location is not a good practice. But,
invoicing from a goods-on-consignment location could be interesting: when
someone is controlling inventory in consignee's warehouse or store, he can
immediately invoice the differences (items sold by the consignee) and
update this inventory.

Best regards, Rafael.


---------- Forwarded message ----------
From: Tim Schofield <tim...@gm...>
Date: 2015-05-08 4:51 GMT-06:00
Subject: Re: [WebERP-developers] Location with GLAccount code. Help.
To: Rafael Emilio Chacon <raf...@gm...>, Pak Ricard <
pak...@gm...>


Hi guys,

Perhaps I am missing something but couldn't this be done by having a
stock category of "Pledged" and moving it into that category. The code
for the GL transfer when this happens is already there so wouldn't
need any extra coding.

As I say maybe I am missing something as i am rushing....

Tim
----------
2015-05-08 2:44 GMT-06:00 Pak Ricard <pak...@gm...>:

> Hi Rafael:
>
> You are right, and with these approaches can't be currently controlled in
> webERP. I also could use the second scenario, thanks!!!
>
> Regading your qeustion, in Manufactured items, somehow the field
> materialcost gets updated with the sum of the costs of all its components,
> so checking this "stockmaster.materialcost + stockmaster.labourcost +
> stockmaster.overheadcost AS standardcost" should be OK.
>
> Never used Assembly items, so not sure about them.
>
> PS: Everyday I'm more impressed about the things webERP can do and people
> do with webERP :-) Also, I realize how deep my ignorance is in a zillion
> different fields
>
> Regards,
> Ricard
>
> 2015-05-08 13:21 GMT+08:00 Rafael Chacón <raf...@gm...>:
>
>> Hi Ricard,
>>
>> Yes.
>>
>> For pledged inventory (in Spanish: "inventario pignorado"), it should be
>> (because it is a collateral for a loan):
>> 1. Physically separated from inventory available to sell or any other
>> inventory; and
>> 2. Registred in an account different from "Merchandise Inventory" (goods
>> available for sale).
>> It is usually that those goods are in a controlled warehouse (similar to
>> a "bonded warehouse"), because you can not use this inventory.
>> Theoretically it is true, but in practice (in some cases) it can differ a
>> little bit (e.g. oil barrels: you can income new oil barrels to the
>> controlled warehouse and then take out old oil barrels). But always you
>> should have a separated control of quantities inside the controlled
>> warehouse and a separated account in the register (accounting). See IAS-2,
>> paragraph 36, bullet (h).
>>
>> For goods on consignment, it is similar:
>> 1. Physically they are in the distributor's warehouse or store (not
>> yours), and
>> 2. they belong to you (the distributor --your customer-- has not
>> purchased yet).
>> Again, it is an inventory that you do not have available to sell, but
>> still yours (consignor), so you have to control (register) in an account
>> different  from "Merchandise Inventory" (goods available for sale).
>> Periodically you (consignor) send a statement to the consignee, stating the
>> inventory that should be on the consignee's stores; differences should be
>> paid immediately to you. Also, in practice, you can have a little
>> differences (e.g. you can sent a client to your client --consignee--).
>>
>> This is a quick overview. If you need other details, let me know.
>>
>> Best regards, Rafael.
>>
>> 2015-05-07 18:50 GMT-06:00 Pak Ricard <pak...@gm...>:
>>
>> Hi Rafael:
>>>
>>> I was thinking to do the very same thing few years ago, but desisted
>>> because we already have the information of stock value by location in a
>>> report.
>>>
>>> We solved it just setting the locations slightly different according to
>>> our business needs, more than physical locations. Much easier than fixing
>>> quite a few scripts.
>>>
>>> If this is not your plan, could you please elaborate a bit more?
>>>
>>> Regards,
>>> Ricard
>>>
>>> 2015-05-08 7:51 GMT+08:00 Rafael Chacón <raf...@gm...>
>>> :
>>>
>>>> Hi,
>>>>
>>>> Sometimes it is needed to have general ledger transactions of inventory
>>>> transfers to or from a location. For example, a location that is used for
>>>> inventory pledged or a place with goods on consignment. In this case, the
>>>> location should be related to a ledger account.
>>>>
>>>> I am working on this (code dowloadable at
>>>> http://unstable.verdorama.systems/downloads/Location_with_GLAccount_code.zip
>>>> ).
>>>>
>>>> To do this, a script enters the general ledger account code for this
>>>> location in the field "locations.glaccountcode". This account code
>>>> overwrites the account codes of inventory categories when a general ledger
>>>> transaction related with this location is created. Each time a user does an
>>>> inventory transfer from or to a location with a non blank account code, the
>>>> system will generate a general ledger transaction (a SysType 16 --Location
>>>> Transfer-- transaction).
>>>> If you do not need accounting entries for inventory transfers, nor
>>>> locations with his own GL account, leave this field in blank.
>>>>
>>>> HELP:
>>>> I take the cost (for the general ledger transactions of inventory
>>>> transfers) from "stockmaster.materialcost + stockmaster.labourcost +
>>>> stockmaster.overheadcost AS standardcost".
>>>> But what's happen with cost for: Assembly (value="A") and Manufactured
>>>> (value="M") items ? Is it this correct?
>>>>
>>>> Any comments are highly appreciated! Thanks in advance!
>>>>
>>>> Best regards, Rafael.
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> One dashboard for servers and applications across Physical-Virtual-Cloud
>>>> Widest out-of-the-box monitoring support with 50+ applications
>>>> Performance metrics, stats and reports that give you Actionable Insights
>>>> Deep dive visibility with transaction tracing using APM Insight.
>>>> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
>>>> _______________________________________________
>>>> Web-erp-developers mailing list
>>>> Web...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>>
>>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> One dashboard for servers and applications across Physical-Virtual-Cloud
>>> Widest out-of-the-box monitoring support with 50+ applications
>>> Performance metrics, stats and reports that give you Actionable Insights
>>> Deep dive visibility with transaction tracing using APM Insight.
>>> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
>>> _______________________________________________
>>> Web-erp-developers mailing list
>>> Web...@li...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>
>>>
>>
>>
>> ------------------------------------------------------------------------------
>> One dashboard for servers and applications across Physical-Virtual-Cloud
>> Widest out-of-the-box monitoring support with 50+ applications
>> Performance metrics, stats and reports that give you Actionable Insights
>> Deep dive visibility with transaction tracing using APM Insight.
>> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
>
> ------------------------------------------------------------------------------
> One dashboard for servers and applications across Physical-Virtual-Cloud
> Widest out-of-the-box monitoring support with 50+ applications
> Performance metrics, stats and reports that give you Actionable Insights
> Deep dive visibility with transaction tracing using APM Insight.
> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] Location with GLAccount code. Help.

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

Hi Rafael:

You are right, and with these approaches can't be currently controlled in
webERP. I also could use the second scenario, thanks!!!

Regading your qeustion, in Manufactured items, somehow the field
materialcost gets updated with the sum of the costs of all its components,
so checking this "stockmaster.materialcost + stockmaster.labourcost +
stockmaster.overheadcost AS standardcost" should be OK.

Never used Assembly items, so not sure about them.

PS: Everyday I'm more impressed about the things webERP can do and people
do with webERP :-) Also, I realize how deep my ignorance is in a zillion
different fields

Regards,
Ricard

2015-05-08 13:21 GMT+08:00 Rafael Chacón <raf...@gm...>:

> Hi Ricard,
>
> Yes.
>
> For pledged inventory (in Spanish: "inventario pignorado"), it should be
> (because it is a collateral for a loan):
> 1. Physically separated from inventory available to sell or any other
> inventory; and
> 2. Registred in an account different from "Merchandise Inventory" (goods
> available for sale).
> It is usually that those goods are in a controlled warehouse (similar to a
> "bonded warehouse"), because you can not use this inventory. Theoretically
> it is true, but in practice (in some cases) it can differ a little bit
> (e.g. oil barrels: you can income new oil barrels to the controlled
> warehouse and then take out old oil barrels). But always you should have a
> separated control of quantities inside the controlled warehouse and a
> separated account in the register (accounting). See IAS-2, paragraph 36,
> bullet (h).
>
> For goods on consignment, it is similar:
> 1. Physically they are in the distributor's warehouse or store (not
> yours), and
> 2. they belong to you (the distributor --your customer-- has not purchased
> yet).
> Again, it is an inventory that you do not have available to sell, but
> still yours (consignor), so you have to control (register) in an account
> different  from "Merchandise Inventory" (goods available for sale).
> Periodically you (consignor) send a statement to the consignee, stating the
> inventory that should be on the consignee's stores; differences should be
> paid immediately to you. Also, in practice, you can have a little
> differences (e.g. you can sent a client to your client --consignee--).
>
> This is a quick overview. If you need other details, let me know.
>
> Best regards, Rafael.
>
> 2015-05-07 18:50 GMT-06:00 Pak Ricard <pak...@gm...>:
>
> Hi Rafael:
>>
>> I was thinking to do the very same thing few years ago, but desisted
>> because we already have the information of stock value by location in a
>> report.
>>
>> We solved it just setting the locations slightly different according to
>> our business needs, more than physical locations. Much easier than fixing
>> quite a few scripts.
>>
>> If this is not your plan, could you please elaborate a bit more?
>>
>> Regards,
>> Ricard
>>
>> 2015-05-08 7:51 GMT+08:00 Rafael Chacón <raf...@gm...>:
>>
>>> Hi,
>>>
>>> Sometimes it is needed to have general ledger transactions of inventory
>>> transfers to or from a location. For example, a location that is used for
>>> inventory pledged or a place with goods on consignment. In this case, the
>>> location should be related to a ledger account.
>>>
>>> I am working on this (code dowloadable at
>>> http://unstable.verdorama.systems/downloads/Location_with_GLAccount_code.zip
>>> ).
>>>
>>> To do this, a script enters the general ledger account code for this
>>> location in the field "locations.glaccountcode". This account code
>>> overwrites the account codes of inventory categories when a general ledger
>>> transaction related with this location is created. Each time a user does an
>>> inventory transfer from or to a location with a non blank account code, the
>>> system will generate a general ledger transaction (a SysType 16 --Location
>>> Transfer-- transaction).
>>> If you do not need accounting entries for inventory transfers, nor
>>> locations with his own GL account, leave this field in blank.
>>>
>>> HELP:
>>> I take the cost (for the general ledger transactions of inventory
>>> transfers) from "stockmaster.materialcost + stockmaster.labourcost +
>>> stockmaster.overheadcost AS standardcost".
>>> But what's happen with cost for: Assembly (value="A") and Manufactured
>>> (value="M") items ? Is it this correct?
>>>
>>> Any comments are highly appreciated! Thanks in advance!
>>>
>>> Best regards, Rafael.
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> One dashboard for servers and applications across Physical-Virtual-Cloud
>>> Widest out-of-the-box monitoring support with 50+ applications
>>> Performance metrics, stats and reports that give you Actionable Insights
>>> Deep dive visibility with transaction tracing using APM Insight.
>>> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
>>> _______________________________________________
>>> Web-erp-developers mailing list
>>> Web...@li...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>
>>>
>>
>>
>> ------------------------------------------------------------------------------
>> One dashboard for servers and applications across Physical-Virtual-Cloud
>> Widest out-of-the-box monitoring support with 50+ applications
>> Performance metrics, stats and reports that give you Actionable Insights
>> Deep dive visibility with transaction tracing using APM Insight.
>> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
>
> ------------------------------------------------------------------------------
> One dashboard for servers and applications across Physical-Virtual-Cloud
> Widest out-of-the-box monitoring support with 50+ applications
> Performance metrics, stats and reports that give you Actionable Insights
> Deep dive visibility with transaction tracing using APM Insight.
> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] Location with GLAccount code. Help.

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

Hi Ricard,

Yes.

For pledged inventory (in Spanish: "inventario pignorado"), it should be
(because it is a collateral for a loan):
1. Physically separated from inventory available to sell or any other
inventory; and
2. Registred in an account different from "Merchandise Inventory" (goods
available for sale).
It is usually that those goods are in a controlled warehouse (similar to a
"bonded warehouse"), because you can not use this inventory. Theoretically
it is true, but in practice (in some cases) it can differ a little bit
(e.g. oil barrels: you can income new oil barrels to the controlled
warehouse and then take out old oil barrels). But always you should have a
separated control of quantities inside the controlled warehouse and a
separated account in the register (accounting). See IAS-2, paragraph 36,
bullet (h).

For goods on consignment, it is similar:
1. Physically they are in the distributor's warehouse or store (not yours),
and
2. they belong to you (the distributor --your customer-- has not purchased
yet).
Again, it is an inventory that you do not have available to sell, but still
yours (consignor), so you have to control (register) in an account
different  from "Merchandise Inventory" (goods available for sale).
Periodically you (consignor) send a statement to the consignee, stating the
inventory that should be on the consignee's stores; differences should be
paid immediately to you. Also, in practice, you can have a little
differences (e.g. you can sent a client to your client --consignee--).

This is a quick overview. If you need other details, let me know.

Best regards, Rafael.

2015-05-07 18:50 GMT-06:00 Pak Ricard <pak...@gm...>:

> Hi Rafael:
>
> I was thinking to do the very same thing few years ago, but desisted
> because we already have the information of stock value by location in a
> report.
>
> We solved it just setting the locations slightly different according to
> our business needs, more than physical locations. Much easier than fixing
> quite a few scripts.
>
> If this is not your plan, could you please elaborate a bit more?
>
> Regards,
> Ricard
>
> 2015-05-08 7:51 GMT+08:00 Rafael Chacón <raf...@gm...>:
>
>> Hi,
>>
>> Sometimes it is needed to have general ledger transactions of inventory
>> transfers to or from a location. For example, a location that is used for
>> inventory pledged or a place with goods on consignment. In this case, the
>> location should be related to a ledger account.
>>
>> I am working on this (code dowloadable at
>> http://unstable.verdorama.systems/downloads/Location_with_GLAccount_code.zip
>> ).
>>
>> To do this, a script enters the general ledger account code for this
>> location in the field "locations.glaccountcode". This account code
>> overwrites the account codes of inventory categories when a general ledger
>> transaction related with this location is created. Each time a user does an
>> inventory transfer from or to a location with a non blank account code, the
>> system will generate a general ledger transaction (a SysType 16 --Location
>> Transfer-- transaction).
>> If you do not need accounting entries for inventory transfers, nor
>> locations with his own GL account, leave this field in blank.
>>
>> HELP:
>> I take the cost (for the general ledger transactions of inventory
>> transfers) from "stockmaster.materialcost + stockmaster.labourcost +
>> stockmaster.overheadcost AS standardcost".
>> But what's happen with cost for: Assembly (value="A") and Manufactured
>> (value="M") items ? Is it this correct?
>>
>> Any comments are highly appreciated! Thanks in advance!
>>
>> Best regards, Rafael.
>>
>>
>> ------------------------------------------------------------------------------
>> One dashboard for servers and applications across Physical-Virtual-Cloud
>> Widest out-of-the-box monitoring support with 50+ applications
>> Performance metrics, stats and reports that give you Actionable Insights
>> Deep dive visibility with transaction tracing using APM Insight.
>> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
>
> ------------------------------------------------------------------------------
> One dashboard for servers and applications across Physical-Virtual-Cloud
> Widest out-of-the-box monitoring support with 50+ applications
> Performance metrics, stats and reports that give you Actionable Insights
> Deep dive visibility with transaction tracing using APM Insight.
> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] Location with GLAccount code. Help.

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

Hi Rafael:

I was thinking to do the very same thing few years ago, but desisted
because we already have the information of stock value by location in a
report.

We solved it just setting the locations slightly different according to our
business needs, more than physical locations. Much easier than fixing quite
a few scripts.

If this is not your plan, could you please elaborate a bit more?

Regards,
Ricard

2015-05-08 7:51 GMT+08:00 Rafael Chacón <raf...@gm...>:

> Hi,
>
> Sometimes it is needed to have general ledger transactions of inventory
> transfers to or from a location. For example, a location that is used for
> inventory pledged or a place with goods on consignment. In this case, the
> location should be related to a ledger account.
>
> I am working on this (code dowloadable at
> http://unstable.verdorama.systems/downloads/Location_with_GLAccount_code.zip
> ).
>
> To do this, a script enters the general ledger account code for this
> location in the field "locations.glaccountcode". This account code
> overwrites the account codes of inventory categories when a general ledger
> transaction related with this location is created. Each time a user does an
> inventory transfer from or to a location with a non blank account code, the
> system will generate a general ledger transaction (a SysType 16 --Location
> Transfer-- transaction).
> If you do not need accounting entries for inventory transfers, nor
> locations with his own GL account, leave this field in blank.
>
> HELP:
> I take the cost (for the general ledger transactions of inventory
> transfers) from "stockmaster.materialcost + stockmaster.labourcost +
> stockmaster.overheadcost AS standardcost".
> But what's happen with cost for: Assembly (value="A") and Manufactured
> (value="M") items ? Is it this correct?
>
> Any comments are highly appreciated! Thanks in advance!
>
> Best regards, Rafael.
>
>
> ------------------------------------------------------------------------------
> One dashboard for servers and applications across Physical-Virtual-Cloud
> Widest out-of-the-box monitoring support with 50+ applications
> Performance metrics, stats and reports that give you Actionable Insights
> Deep dive visibility with transaction tracing using APM Insight.
> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

[WebERP-developers] Location with GLAccount code. Help.

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

Hi,

Sometimes it is needed to have general ledger transactions of inventory
transfers to or from a location. For example, a location that is used for
inventory pledged or a place with goods on consignment. In this case, the
location should be related to a ledger account.

I am working on this (code dowloadable at
http://unstable.verdorama.systems/downloads/Location_with_GLAccount_code.zip
).

To do this, a script enters the general ledger account code for this
location in the field "locations.glaccountcode". This account code
overwrites the account codes of inventory categories when a general ledger
transaction related with this location is created. Each time a user does an
inventory transfer from or to a location with a non blank account code, the
system will generate a general ledger transaction (a SysType 16 --Location
Transfer-- transaction).
If you do not need accounting entries for inventory transfers, nor
locations with his own GL account, leave this field in blank.

HELP:
I take the cost (for the general ledger transactions of inventory
transfers) from "stockmaster.materialcost + stockmaster.labourcost +
stockmaster.overheadcost AS standardcost".
But what's happen with cost for: Assembly (value="A") and Manufactured
(value="M") items ? Is it this correct?

Any comments are highly appreciated! Thanks in advance!

Best regards, Rafael.

Re: [WebERP-developers] The number format is wrong ??

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

Would there be any interest in creating and maintaining a Spanish-USA
(es_US)?

2015-05-07 10:53 GMT-06:00 Rafael Chacón <raf...@gm...>:

> Hi Humberto,
>
> It is the same problem in Costa Rica: some people want to use "American
> format" (format in US machines), but it is not the "legal" one.
>
> In Spanish the correct is (see Spanish language authorities):
> * Comma for decimal, dot for thousands.
> * Billion for 1 million x 1 million (1.000.000.000.000), not 1 thousand x
> 1 millon (as american English). In Spanish is the same as
> in British English, in German, etc.).
>
> I warn you about using no-standard formats. Some software can not handle
> this and information exchange formats are based on standardised formats.
>
> Best regards, Rafael.
>
> 2015-05-07 10:24 GMT-06:00 ciesac <we...@si...>:
>
> How Can I modify this ? we use 1,000.50 this format ( we are in peru ) we
>> speak spanish as well
>>
>>
>>
>> --
>> View this message in context:
>> http://weberp-accounting.1478800.n4.nabble.com/The-number-format-is-wrong-tp4658235p4658241.html
>> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>>
>>
>> ------------------------------------------------------------------------------
>> One dashboard for servers and applications across Physical-Virtual-Cloud
>> Widest out-of-the-box monitoring support with 50+ applications
>> Performance metrics, stats and reports that give you Actionable Insights
>> Deep dive visibility with transaction tracing using APM Insight.
>> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>
>

Re: [WebERP-developers] The number format is wrong ??

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

Hi Humberto,

It is the same problem in Costa Rica: some people want to use "American
format" (format in US machines), but it is not the "legal" one.

In Spanish the correct is (see Spanish language authorities):
* Comma for decimal, dot for thousands.
* Billion for 1 million x 1 million (1.000.000.000.000), not 1 thousand x 1
millon (as american English). In Spanish is the same as in British English,
in German, etc.).

I warn you about using no-standard formats. Some software can not handle
this and information exchange formats are based on standardised formats.

Best regards, Rafael.

2015-05-07 10:24 GMT-06:00 ciesac <we...@si...>:

> How Can I modify this ? we use 1,000.50 this format ( we are in peru ) we
> speak spanish as well
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/The-number-format-is-wrong-tp4658235p4658241.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> One dashboard for servers and applications across Physical-Virtual-Cloud
> Widest out-of-the-box monitoring support with 50+ applications
> Performance metrics, stats and reports that give you Actionable Insights
> Deep dive visibility with transaction tracing using APM Insight.
> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] The number format is wrong ??

[ciesac <we...@si...>]

How Can I modify this ? we use 1,000.50 this format ( we are in peru ) we
speak spanish as well



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/The-number-format-is-wrong-tp4658235p4658241.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] The number format is wrong ??

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

For Spanish, the ISO format is "#.##0,00". That is comma for decimal, dot
for thousands.

Where, exactly, is it not this format?

2015-05-07 9:26 GMT-06:00 ciesac <we...@si...>:

> Sorry for that
> Server :
> Linux  3.2.0-4-amd64 #1 SMP Debian 3.2.65-1+deb7u2 x86_64 GNU/Linux
>
> locale :
> LANG=es_PE.UTF-8
> LANGUAGE=es_PE:es
> LC_CTYPE="es_PE.UTF-8"
> LC_NUMERIC="es_PE.UTF-8"
> LC_TIME="es_PE.UTF-8"
> LC_COLLATE="es_PE.UTF-8"
> LC_MONETARY="es_PE.UTF-8"
> LC_MESSAGES="es_PE.UTF-8"
> LC_PAPER="es_PE.UTF-8"
> LC_NAME="es_PE.UTF-8"
> LC_ADDRESS="es_PE.UTF-8"
> LC_TELEPHONE="es_PE.UTF-8"
> LC_MEASUREMENT="es_PE.UTF-8"
> LC_IDENTIFICATION="es_PE.UTF-8"
> LC_ALL=
>
>
> change in LanguagesArray.php
> $LanguagesArray['es_ES.utf8']['LanguageName'] = 'Español';
> $LanguagesArray['es_ES.utf8']['WindowsLocale'] = 'spanish';
> $LanguagesArray['es_ES.utf8']['DecimalPoint'] = '.';
> $LanguagesArray['es_ES.utf8']['ThousandsSeparator'] = ',';
>
> users are in spanish
>
> if a try to modify any price or cost example Prices.php?
>
> the number format is wrong
>
> if a change to english united kingdom works ok, but not for language
> spanish
>
>
>
>
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/The-number-format-is-wrong-tp4658235p4658239.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> One dashboard for servers and applications across Physical-Virtual-Cloud
> Widest out-of-the-box monitoring support with 50+ applications
> Performance metrics, stats and reports that give you Actionable Insights
> Deep dive visibility with transaction tracing using APM Insight.
> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] The number format is wrong ??

[ciesac <we...@si...>]

Sorry for that
Server : 
Linux  3.2.0-4-amd64 #1 SMP Debian 3.2.65-1+deb7u2 x86_64 GNU/Linux

locale : 
LANG=es_PE.UTF-8
LANGUAGE=es_PE:es
LC_CTYPE="es_PE.UTF-8"
LC_NUMERIC="es_PE.UTF-8"
LC_TIME="es_PE.UTF-8"
LC_COLLATE="es_PE.UTF-8"
LC_MONETARY="es_PE.UTF-8"
LC_MESSAGES="es_PE.UTF-8"
LC_PAPER="es_PE.UTF-8"
LC_NAME="es_PE.UTF-8"
LC_ADDRESS="es_PE.UTF-8"
LC_TELEPHONE="es_PE.UTF-8"
LC_MEASUREMENT="es_PE.UTF-8"
LC_IDENTIFICATION="es_PE.UTF-8"
LC_ALL=


change in LanguagesArray.php
$LanguagesArray['es_ES.utf8']['LanguageName'] = 'Español';
$LanguagesArray['es_ES.utf8']['WindowsLocale'] = 'spanish';
$LanguagesArray['es_ES.utf8']['DecimalPoint'] = '.';
$LanguagesArray['es_ES.utf8']['ThousandsSeparator'] = ',';

users are in spanish

if a try to modify any price or cost example Prices.php?

the number format is wrong

if a change to english united kingdom works ok, but not for language spanish







--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/The-number-format-is-wrong-tp4658235p4658239.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.