Accounts Receivable Conversion

I am copying a current company to a new number so we can use the same vendor group for all of our companies. I have to rebuild all sub ledgers.

Has anyone converted AR (AR97, AR98, AR99)? Would you be willing to share what you did, steps and any issues you may have run into?

I have converted GL and AM in the past but want to be sure I don't miss anything like beginning balances, aging, etc.

Find more posts tagged with

Comments

Legacy Contributor

I did a similar conversion very recently - I can send you some information over the weekend

gwhiteford

Can you copy me on that AR conversion information as well? Thank you.

Legacy Contributor

You can either post online or my e-mail is prattja@wvuhs.com.

I appreciate the response.

Legacy Contributor

I used AddIns for this so just used AR09 and AR10 for customer conversion part rather than AR98.
Used AR99 rather than AR97 - I don't remember why – I think that I had trouble with payments using the AR97 conversion

Attached are files, upload templates and reference files (AR97 templates and data are included but I did not use them in the end). Hopefully there is some help here. I ran through the process 4 times in test.

I used old customer numbers since this company was going the other way - from the main customer group to their own group. Problem with that was that, unlike AP, you can't then turn auto numbering back on.

I never got the partial application part of open transactions to do what I wanted but had a pretty small set of them so it just applied them manually. Fin Conversion guide might help you not make the same mistake. I had several false starts with fully applied transactions – I wanted to include the transactions and payments and fully applied status always left the payments hanging on the accounts as credit balances so I ended up using status open.

AR Adjustments wouldn’t work for me but I only had 2 to convert.

I did not attempt to convert any non-ar cash entries

Sequence numbers in AR99.2 (column F) were very important to not duplicate
My steps:
- make sure all transactions were released and updated in AR
- ran Open AR and tied to GL
- created the new customer group, company defaults, process levels, corresponding BL stuff.
- created the customers using AR09 and AR10 uploads.
- uploaded AR99 tabs and ran the AR500 series update jobs
Found AR505 Balance Conversion really helpful in verifying that things were on the right track.
- verified new Open AR tied to old and to GL
- Used 9 for status everywhere because I didn't want to generate GL transactions

Legacy Contributor

Thanks JFicther!

I don't think I need customers (AR98). My AR data is not changing. I actually had to copy the GL company because of the Accounts Payable Vendor Group.

All I really need now is for the transactions in the AR subledger to match the GL.

Do you know the difference between the AR97 / AR560 process compared to the AR99 / AR502 process? That is what I am not understanding. They look the same.

Also, I want to be sure I don't miss anything like beginning and ending balances. But, I am assuming the AR97 process would handle all of that.

If you would like to talk please feel free to e-mail (prattja@wvuhs.com). I appreciate all of the files you sent and the help.

Copyright © 2025 Infor. All rights reserved.