Suggestions for transitioning FY balances for North American Payroll

We are on PS 9.2 Pum 38 and will be converting our Fiscal year. We have tried a few scenarios like updating the number of periods on the balance ID table to cover the transition periods but unable to save as it looks for the same number of periods for prior years. We also have tried SQL inserting the transition periods on the Balance ID tables but when we go in to add new periods for the new FY periods we still get PC errors asking us to insert additional periods. We would ideally like