Re: Web-erp-developers Digest, Vol 26, Issue 7

View: New views
2 Messages — Rating Filter:   Alert me  

Parent Message unknown Re: Web-erp-developers Digest, Vol 26, Issue 7

by Francisco Marco-Serrano :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Dear Tim,

In Spain, you are given by the Government a set of codes you have to
use in your accounts (i.e. 430 Customers, 600 Purchases...). These set
of codes tend to be very stable over time (until Jan 1st we were using
the accounts given in 1990 accounting law).

So, if I have an account that before was 215 (Software), now with the
new law I need to re-code it so it's 206.

I imagine there's no pre-made script but I think I'll be able to code
an SQL sentence. If that's the recommended procedure.

Regards,

Francisco Marco-Serrano

2008/7/19  <web-erp-developers-request@...>:

>
> Message: 3
> Date: Sat, 19 Jul 2008 11:22:09 +0200
> From: "Francisco Marco-Serrano" <fmarco@...>
> Subject: [WebERP-developers] Change accounts code
> To: web-erp-developers@...
> Message-ID:
>        <1ef1e010807190222s1f2281d2q3b090ff93136b2ec@...>
> Content-Type: text/plain; charset=UTF-8
>
> Hi,
>
> Very recently (from Jan 1st 2008) in Spain we've "suffered" a change
> in the official set of accounts a company has to stick to.
>
> So, here we go that we need to re-code the accounts. What procedure
> would be the best to attain this?.
>
> Regards,
>
> --
> __________________________________________________
>
> Francisco Marco-Serrano
> Economist
> K|P|K - Key Productivity Konsulting, S.L.N.E.
>
>
>
> ------------------------------
>
> Message: 4
> Date: Sat, 19 Jul 2008 14:30:17 +0300
> From: "Tim Schofield" <tim.schofield1960@...>
> Subject: Re: [WebERP-developers] Change accounts code
> To: "webERP Developers" <web-erp-developers@...>
> Message-ID:
>        <1cafbfd40807190430h72fe1a5cq8eb4dde7760abfe@...>
> Content-Type: text/plain; charset=UTF-8
>
> Francisco,
>
> Can you give me more info on what you are trying to do?
>
> Tim
>
>
> 2008/7/19 Francisco Marco-Serrano <fmarco@...>:
>> Hi,
>>
>> Very recently (from Jan 1st 2008) in Spain we've "suffered" a change
>> in the official set of accounts a company has to stick to.
>>
>> So, here we go that we need to re-code the accounts. What procedure
>> would be the best to attain this?.
>>
>> Regards,
>>
>> --
>> __________________________________________________
>>
>> Francisco Marco-Serrano
>> Economist
>> K|P|K - Key Productivity Konsulting, S.L.N.E.
>>
>> -------------------------------------------------------------------------
>> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
>> Build the coolest Linux based applications with Moblin SDK & win great prizes
>> Grand prize is a trip for two to an Open Source event anywhere in the world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web-erp-developers@...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>
>
>

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: Web-erp-developers Digest, Vol 26, Issue 7

by Tim Schofield :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Francisco

I need to think this one through, as there are a number of tables
involved here. Its not as simple as just an sql statement.

Tim


2008/7/19 Francisco Marco-Serrano <fmarco@...>:

> Dear Tim,
>
> In Spain, you are given by the Government a set of codes you have to
> use in your accounts (i.e. 430 Customers, 600 Purchases...). These set
> of codes tend to be very stable over time (until Jan 1st we were using
> the accounts given in 1990 accounting law).
>
> So, if I have an account that before was 215 (Software), now with the
> new law I need to re-code it so it's 206.
>
> I imagine there's no pre-made script but I think I'll be able to code
> an SQL sentence. If that's the recommended procedure.
>
> Regards,
>
> Francisco Marco-Serrano
>
> 2008/7/19  <web-erp-developers-request@...>:
>
>>
>> Message: 3
>> Date: Sat, 19 Jul 2008 11:22:09 +0200
>> From: "Francisco Marco-Serrano" <fmarco@...>
>> Subject: [WebERP-developers] Change accounts code
>> To: web-erp-developers@...
>> Message-ID:
>>        <1ef1e010807190222s1f2281d2q3b090ff93136b2ec@...>
>> Content-Type: text/plain; charset=UTF-8
>>
>> Hi,
>>
>> Very recently (from Jan 1st 2008) in Spain we've "suffered" a change
>> in the official set of accounts a company has to stick to.
>>
>> So, here we go that we need to re-code the accounts. What procedure
>> would be the best to attain this?.
>>
>> Regards,
>>
>> --
>> __________________________________________________
>>
>> Francisco Marco-Serrano
>> Economist
>> K|P|K - Key Productivity Konsulting, S.L.N.E.
>>
>>
>>
>> ------------------------------
>>
>> Message: 4
>> Date: Sat, 19 Jul 2008 14:30:17 +0300
>> From: "Tim Schofield" <tim.schofield1960@...>
>> Subject: Re: [WebERP-developers] Change accounts code
>> To: "webERP Developers" <web-erp-developers@...>
>> Message-ID:
>>        <1cafbfd40807190430h72fe1a5cq8eb4dde7760abfe@...>
>> Content-Type: text/plain; charset=UTF-8
>>
>> Francisco,
>>
>> Can you give me more info on what you are trying to do?
>>
>> Tim
>>
>>
>> 2008/7/19 Francisco Marco-Serrano <fmarco@...>:
>>> Hi,
>>>
>>> Very recently (from Jan 1st 2008) in Spain we've "suffered" a change
>>> in the official set of accounts a company has to stick to.
>>>
>>> So, here we go that we need to re-code the accounts. What procedure
>>> would be the best to attain this?.
>>>
>>> Regards,
>>>
>>> --
>>> __________________________________________________
>>>
>>> Francisco Marco-Serrano
>>> Economist
>>> K|P|K - Key Productivity Konsulting, S.L.N.E.
>>>
>>> -------------------------------------------------------------------------
>>> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
>>> Build the coolest Linux based applications with Moblin SDK & win great prizes
>>> Grand prize is a trip for two to an Open Source event anywhere in the world
>>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>>> _______________________________________________
>>> Web-erp-developers mailing list
>>> Web-erp-developers@...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>
>>
>>
>>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers