How Account Code Levels has changed automatically ?

[Former Member]

Hi,

Chart of Accounts Levels has changed to another level. what are the levels 5 account changed to level 2 how it will changed automatically if I modify level 2 to level 5 is there any effect in old entries. And I restored 20-03-09 Back up in this DB exactly is there. How it will happen automatically. And live DB also there is no updated date. How we can find who did and how it will updated.

This is the query:

select OACT.Acctcode,OACT.Acctname,OACT.createdate,OACT.updatedate,OACT.usersign,ousr.userid,OUSR.user_Code,OUSR.U_Name from OACT

inner join ousr on ousr.userid=oact.usersign

here there is no updated date.please guide me.

Regds,

Sampath Kumar.

[Former Member · Accepted solution]

Hi,

If changed Levels 2 to 5 it will effect the existing entries.Please guide me asp.

Regds,

Sampath Kumar

[msundararaja_perumal · Accepted solution]

Hi,

It will not affect your existing entries.

But in future ensure that all users are not allowed to access edit chart of accounts,use authorization for user restriction.

[former_member187989]

hi,

Check it in AACT table by latest log instance.

Jeyakanthan

[Former Member]

Hi,

How we can check it.

select OACT.Acctcode,OACT.Acctname,OACT.createdate,OACT.updatedate,OACT.usersign,ousr.userid,OUSR.user_Code,OUSR.U_Name,AACT.LogInstanc,AACT.usersign from OACT

inner join ousr on ousr.userid=oact.usersign

inner join AACT on AACT.Acctcode=OACT.Acctcode

Regds,

Sampath.

[former_member187989]

hi,

Whether chart of accounts is segmented ?

Jeyakanthan

[Former Member]

Hi,

No.

Regds,

Sampath Kumar.