Forum Discussion

Betabiz's avatar
Betabiz
Experienced Cover User
2 years ago
Solved

Migration Error - Foreign key constraint name = FK_NZGSTReturnOptions_OutputTaxAccount

Hi   Am trying to upgrade a V19 AccountRight Standard file to 2023.2.  Below is my log.   The linking for the GST codes is all correct, there are no linked adjustment codes in the Prepare GST ret...
  • gavin12345's avatar
    gavin12345
    2 years ago

    Hi Betabiz 

     

    In your v19 file, go to the Accounts Command Centre and select Prepare GST Return. Check the value for GST Output Tax Adjustment - the error seems to indicate the account selected here cannot be found in the accounts list. Try clearing any value here. If it is already clear, it may only appear to be and may actually hold a corrupt value, so try setting it to a valid existing account. Close and re-open this screen to ensure the entry sticks - if not there is likely a file corruption issue. If the account is now a valid account, try the upgrade again. Let us know how you get on.

     

    Regards

    Gavin

gavin12345's avatar
gavin12345
Ultimate User

Hi Betabiz 

 

In your v19 file, go to the Accounts Command Centre and select Prepare GST Return. Check the value for GST Output Tax Adjustment - the error seems to indicate the account selected here cannot be found in the accounts list. Try clearing any value here. If it is already clear, it may only appear to be and may actually hold a corrupt value, so try setting it to a valid existing account. Close and re-open this screen to ensure the entry sticks - if not there is likely a file corruption issue. If the account is now a valid account, try the upgrade again. Let us know how you get on.

 

Regards

Gavin

Betabiz's avatar
Betabiz
Experienced Cover User
2 years ago

Thanks Gavin

 

I had removed the value for the GST outputs adj box - so I added a new GST GL code, added that to the outputs adjustment in the GST return, optimised the file then tried the upgrade again ... and it worked!!!

 

Appreciate your help - thank you