GL Accounts for IC - merging accounts

Hi - our Finance department wants to decrease the number of accounts being used in the General Ledger for supplies. I was wondering if anyone in the community has ever merged accounts using GL122, or using addins? Any information will be greatly appreciated. They want this to be done by end of Fiscal year, which is June 30 because they have built the new Fiscal Budget based on these accounts.

0811181026417683.xls

Find more posts tagged with

Infor Lawson Supply Chain Management - Discussion

Comments

jon-athey

We did this about 4 or 5 years ago but we didn't merge accounts. We just stopped using them and Finance made them inactive. Finance gave me a crosswalk of all the accounts they wanted to inactivate and the account the charges should be moved to. For instance, we had separate accounts for Radiology Film and Contrast Material and Finance moved these into Medical Supplies. I extracted all IC12, IC81 and PO15 records that were coded to charge to the accounts to be eliminated and updated them with the correct account using Addins and I inactivated all IC04 records that were tied to the eliminated accounts. I also identified any open POs with those accounts and updated them as well.

cpashley

Thanks Jon. You are always so helpful and informative. They were thinking that this is something that Finance had to do but it really is more of a job on the procurement side. Would you still have the template that you used for the uploading?

jon-athey

Sorry I don't generally save those. But here's the mapping.

IC12.1

IC81.1

PO15.1

cpashley

Thanks, Jon. We are reviewing these this afternoon. This will be a great tool.

0911060553270289.pdf

Copyright © 2025 Infor. All rights reserved.