Moving merging a GL account into a different GL account

[michellepace]

Hi there,

I have two General Ledger accounts:

2010/070 Subcontractor - Material Testing
2020/010 Raw Materials

In our income statement, 2010/070 is nonsensical and so we've decided to move these costs into 2020/010.

Question 1:
Is there a way to easily move all the GRN's and PC's out of into 2020/010?

Question 2:
If the answer to Q1 is "no", do I just do a General Journal Entry and transfer each monthly amount in to 2020/010?

Thanks once again,
Michelle

[Neville Bailey]

There is a module called General Ledger Manager that will do exactly what you want, plus more.

However, it's probably not worth spending money on a module that you will use only once, so I suggest that you send me a backup of your company and I can do the merge (using my GL Manager module) and then send you a fresh backup.

[michellepace]

Hi Neville, thank you very much for your kind offer. But I am quite sure I would be fired on the spot for sharing such sensitive information. Thank you, thats nice of you to offer .

Is Question 2 an option... ?

[Kevin Smith]

Hi Michelle

Question 2 is an option. Once completed, block the GL account so no further processing happens to it.

The required changes can also be scripted in PVSW - it would require a consultant to have access to your data (via remote support session) and would require sole access mode for about 30 minutes. All the entries can be moved, then the main and sub account balances for 2010 000, 2010070, 2020000 and 2020010 would have to be adjusted in the gl masterfile in the database. You would then be able to delete the 2010 070 account. They would have access to your data to perform the exercise, but it would not be leaving your site.

[michellepace]

The required changes can also be scripted in PVSW - it would require a consultant to have access to your data (via remote support session) and would require sole access mode for about 30 minutes. All the entries can be moved, then the main and sub account balances for 2010/000, 2010/070, 2020/000 and 2020/010 would have to be adjusted in the gl masterfile in the database. You would then be able to delete the 2010 070 account. They would have access to your data to perform the exercise, but it would not be leaving your site.

Hi Kevin, I really like the sound of your suggestion - especially that I'll then be able to delete 2010/070 !

Thanks very much. I'm going to send you a PM now to see if its perhaps something you're abel to consult on for me.