Validation of Account??

Hi Friends,

Is there any core routine to find out, whether an Account is valid or invalid?

i.e. if the Account is closed or restricted or invalid, the routine should return 0 or 1...so that we can know that the account is invalid...

Expecting ur reply

Thanks,
Soms

A closed account can be identified by ACCOUNT.CLOSED application.

Need to do more research on this.
_________________
M A L A I

If the Account has a Posting restriction, then it wont be in the ACCOUNT.CLOSED appl.

So at that time also I shud not raise acct. entries...

In ACCOUNT 13th field is POSTING.RESTRICT...In this field if NO CR is given then credit shud not happen to that account..

Actually in my dev. i shud avoid those acconts having such restrictions.
_________________
Thanks n Regards,
Somz

Hi,

The ACCOUNT.CLOSED is not useful. it will have the id as date. In the ACCOUNT application CLOSURE.DATE will be set if the account is going to be closed. If you are raising accounting entry then the core will arise the override. Are you going to run in online or COB. If you can give the specification then we may help you easily.

Create a routine as follows. I cannot find any core routine.

1) Check whether the account is in live file if not then the account should be closed or wrong account.

2) If the inactive marker field in account is set to 'Y' then the account is not active.

3) if there is any positing restrict in account then the account has a posting restriction.

Last edited by vkarthik on Thu Mar 16, 2006 2:00 am; edited 1 time in total

Hi Karthik,

Thanks for you effort.

Could you tell me what this POSTING.RESTRICT stands for?
_________________
M A L A I

The purpose of this table is to define any type of restrictions which may be imposed on Accounts, e.g. 'POST NO DEBITS', 'WHEREABOUTS UNKNOWN', 'PENDING CLOSURE', etc.

Posting Restriction codes may be assigned to Accounts as required, which then means that any entries meeting the specified conditions will require an override.

The system will automatically close any Account with a Posting Restriction in the range 90-99, as soon as all Balances are zero.

It means that, the accounts which the fied POSTING.RESTRICT is set to 10, then the CREDITS for that account will be blocked.

This will take effect after EOD/COB process.

Right?
_________________
M A L A I

It depends upon the RESTRICTION.TYPE in the particular record. The RESTRICTION.TYPE in POSTING.RESTRICT will determine whether to restrict debit or credit or all movements. This will be applicabe for both online and COB.

Last edited by Lion on Thu Mar 09, 2006 8:40 am; edited 1 time in total

Hi Karthik,

Thanx a lot.

I too searched for the core rtn. But i didnt find it. So we have to manually handle this filtering.

Anyway thanx for ur coding and ur efforts.

I didnt expect such response and am really surprised, as I am new to this forum.

Thanx.
_________________
Thanks n Regards,
Somz