Hi Pete,

You will also need to look into migrating data from all your subledgers, you can't just point them to a new GL. So for AP, you would want to pay out as much as you are able, then move just the open invoices to the AP module under the new GL. For AR, you'll close out your receipt batches then move all the open invoices. AP and AR each have an interface table, and you could use sql to read the open invoices and load them into the interface table with the new ledger and operating unit info. For Assets, you'll need to convert them including the current status (original value, prior depreciation, current value, etc.). There is a webADI front end for Assets to do a Mass Load. You'll need to post to the GL; if you load the open items and then post, the GL journal should be only the conversion data; if you don't want to keep the journal then you can reverse it. In all cases, confirm that the total ending amount in the old ledger equals the total starting amount in the new ledger. Close all the periods in the old ledger, so it's there for reporting but can't be transacted.

Something to consider is whether you want YTD to be accurate. Suppose July is the open period. The simple thing would be to convert everything into July and check the inception-to-date values match. That does work, but be aware that YTD through June will be zero and MTD July will be the inception-to-date value, so that if you compare month-to-month or year-to-year, it won't be accurate. That isn't significant in some businesses. But if you want YTD to be accurate, then open Dec-2024 and convert ITD through Dec-2024 balances. Post and close, so Jan-2025 starts as it did in the original ledger. Then migrate Jan-25 from old to new, post and close, and continue each month. This approach gives you accurate ITD, YTD, and MTD values if you need them.

Good luck with your move,

J