P09814 - Delete Account Master Codes

  • Thread starter steven_lawrence
  • Start date

steven_lawrence

Active Member
We are planning to run this program to remove tons of unwanted and
unloved account codes that are clogging up our F0901. Has anyone else
used this function ? Anything I should be aware of ? Thanks. Steve
Lawrence, Coral Racing Ltd. A7.3 cum 10. AS/400 RISC 620. OS V4R5.

--------------------------------------------
Steven Lawrence
Retail Accounting Manager
Coral Racing Ltd
Glebe House
Vicarage Drive
Barking Essex IG11 7NS

E-Mail [email protected]
Direct Dial 020 8507 5469
Fax 020 8591 8647

www.coral.co.uk
--------------------------------------------
 
Steve,

Over the past year, our users in the financial area have been using this
program to do clean-up of the F0901 for the same reasons. To my knowledge,
they have not encountered any undesirable results. They wanted to get rid
of accounts that had been created, but never had any activity posted against
them.

Janet

A7.2 cum 9. OS V5R2.

Janet Celestino Leppo
Sr. Business Application Developer
NJR Service Corporation
(732) 919-8260
mailto:[email protected]
 
Steve,

When you run this it removes not only F0901 but also F0911 and F0902 records. If any of the accounts you want to delete have balances in them you'll need to have a strategy for placing those balances somewhere in yor general ledger. If they are old expense or revenue accounts, you'll ned to summarize the balances and put the summary amounts in an equity account or else your company will be out of balance.

teven_lawrence <[email protected]> wrote:
We are planning to run this program to remove tons of unwanted and
unloved account codes that are clogging up our F0901. Has anyone else
used this function ? Anything I should be aware of ? Thanks. Steve
Lawrence, Coral Racing Ltd. A7.3 cum 10. AS/400 RISC 620. OS V4R5.
--------------------------------------------
Steven Lawrence
Retail Accounting Manager
Coral Racing Ltd
Glebe House
Vicarage Drive
Barking Essex IG11 7NS
E-Mail [email protected]
Direct Dial 020 8507 5469
Fax 020 8591 8647
www.coral.co.uk
--------------------------------------------
--------------------------
To view this thread, visit the JDEList forum at: http://www.jdelist.com/ubb/showflat.php?Cat=&Board=W&Number=73443

This is the JDELIST World* Mailing List. To stop receiving these messages, login to http://www.jdelist.com/forums, click Control Panel, then click Edit by "Subscribe / Unsubscribe from receiving board posts by email, change message notifications, etc." and adjust your subscription preferences. JDEList is not affiliated with JDEdwards®

---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger


World, OW B733X and Xe
 
You can run this to delete accounts that are not used. The program search the following files, for the account to be deleted, and if a record is found it will not delete the account.

F0311 Accounts Receivable Ledger
F0411 Accounts Payable Ledger
F0911 Account Ledger
F0902 Account Balances
F1202 Item Balances
F2111 Least Cost Ledger
F2313 Owner Detail Ledger
F4311 Purchase Order Detail
F51911 Draw Reporting Master
F0912 Cost Allocations/Flex Budgeting
F06106 Employee Pay Instructions
F0618 Payroll Transaction History
F0624 Burden Distribution
F06116 Employee Transactions Detail

Just be carefull that you do not delete summary accounts because they don't have records in the other files. In your data selection make sure you have the following:

Posting Edit . . . . . . . . . . . . .NE N
 

Similar threads

Replies
7
Views
4K
peterban
peterban
Replies
8
Views
2K
steven_lawrence
Replies
0
Views
2K
steven_lawrence
Replies
4
Views
4K
steven_lawrence
Back
Top