Re: [WebERP-developers] Z_ChangeGLAccountCode.php

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

Hi Phil,

Thank you, very much. The latest changes are very useful. They solve
problems I'm having in the implementation of webERP.

Regards, Rafael.


2013/5/3 webERP Developers <web...@li...>

>  Hi Rafael,
>
> Looks like my commit yesterday missed this file forgot to add it first!!
> Just done it now - you can get the file from:
>
>
> http://sourceforge.net/p/web-erp/code/HEAD/tree/trunk/Z_ChangeGLAccountCode.php?format=raw
>
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
> skype:daintree
>
>
> On 04/05/13 11:58, webERP Developers wrote:
>
>  Excuse me, where can I download "Z_ChangeGLAccountCode.php" ?
>
> Regards, Rafael
>
>
> 2013/5/3 webERP Developers <web...@li...>
>
>>  done ...
>> Thanks for your work :-)
>>
>> Phil
>>
>> Phil Daintree
>> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>> skype:daintree
>>
>>
>> On 03/05/13 21:45, webERP Developers wrote:
>>
>>  Hi all:
>>
>>  This is a script allowing to change a GL account code all over webERP.
>> Checked twice and I think I did not forget any GL account field.
>>
>>  Anyway, I detected some fields in the database still int(11), that did
>> not change back in 4.07-4.06, so, these lines should be added to
>> upgrade4.10-4.11.sql file
>>
>>  ALTER TABLE  `companies` CHANGE  `debtorsact`  `debtorsact` VARCHAR( 20
>> ) NOT NULL DEFAULT  '70000',
>> CHANGE  `pytdiscountact`  `pytdiscountact` VARCHAR( 20 ) NOT NULL DEFAULT
>>  '55000',
>> CHANGE  `creditorsact`  `creditorsact` VARCHAR( 20 ) NOT NULL DEFAULT
>>  '80000',
>> CHANGE  `payrollact`  `payrollact` VARCHAR( 20 ) NOT NULL DEFAULT
>>  '84000',
>> CHANGE  `grnact`  `grnact` VARCHAR( 20 ) NOT NULL DEFAULT  '72000',
>> CHANGE  `exchangediffact`  `exchangediffact` VARCHAR( 20 ) NOT NULL
>> DEFAULT  '65000',
>> CHANGE  `purchasesexchangediffact`  `purchasesexchangediffact` VARCHAR(
>> 20 ) NOT NULL DEFAULT  '0',
>> CHANGE  `retainedearnings`  `retainedearnings` VARCHAR( 20 ) NOT NULL
>> DEFAULT  '90000',
>> CHANGE  `freightact`  `freightact` VARCHAR( 20 ) NOT NULL DEFAULT  '0';
>>
>>  ALTER TABLE  `lastcostrollup` CHANGE  `stockact`  `stockact` VARCHAR(
>> 20 ) NOT NULL DEFAULT  '0',
>> CHANGE  `adjglact`  `adjglact` VARCHAR( 20 ) NOT NULL DEFAULT  '0';
>>
>>  INSERT INTO  `scripts` (`script` , `pagesecurity` , `description`)
>> VALUES (
>> 'Z_ChangeGLAccountCode.php',  '15',  'Script to change a GL account code
>> accross all tables necessary'
>> );
>>
>>  Still with problems commiting (even in a brand new computer, something
>> is wrong with TortoiseSVN and permissions). More on that when I sort it out.
>>
>>  Phil, could you pls commit it for me?
>>
>>  Regards,
>>  Ricard
>>
>>
>>  ------------------------------------------------------------------------------
>> Get 100% visibility into Java/.NET code with AppDynamics Lite
>> It's a free troubleshooting tool designed for production
>> Get down to code-level detail for bottlenecks, with <2% overhead.
>> Download for free and get started troubleshooting in minutes.http://p.sf.net/sfu/appdyn_d2d_ap2
>>
>>
>>
>> _______________________________________________
>> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Get 100% visibility into Java/.NET code with AppDynamics Lite
>> It's a free troubleshooting tool designed for production
>> Get down to code-level detail for bottlenecks, with <2% overhead.
>> Download for free and get started troubleshooting in minutes.
>> http://p.sf.net/sfu/appdyn_d2d_ap2
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
>
> ------------------------------------------------------------------------------
> Get 100% visibility into Java/.NET code with AppDynamics Lite
> It's a free troubleshooting tool designed for production
> Get down to code-level detail for bottlenecks, with <2% overhead.
> Download for free and get started troubleshooting in minutes.http://p.sf.net/sfu/appdyn_d2d_ap2
>
>
>
> _______________________________________________
> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
> ------------------------------------------------------------------------------
> Get 100% visibility into Java/.NET code with AppDynamics Lite
> It's a free troubleshooting tool designed for production
> Get down to code-level detail for bottlenecks, with <2% overhead.
> Download for free and get started troubleshooting in minutes.
> http://p.sf.net/sfu/appdyn_d2d_ap2
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>