VAT Submission
11-30-21
Operating system: Windows
Unable to file VAT submission with error "Refreshing access token failed". Nothing has changed from when it worked previously. Any ideas please?
Anna Lasko
12-3-21
Some more info from Paul:

The last time I tried to update it did not import the backup file. Richard Saunders looked into this at the time but never came back with an answer - is he still with Hansa?

ERP Version 8.5.342962
Windows Version 10 or server 12
Both client server and standalone

The issue was identified when trying to move to Version 8.5.342962 from 8.5.2020/01/07 Build 85330533.

A TB file was created from 0533. Version 2962 was installed and when the TB file was loaded into a client it crashed during import and hung the program. It was also tried to install the TB file direct to a clean install of the server but this also did not run smoothly. It crashed out during loading. If the server service was started with the database at this point the service could not be shut down. It would hang and require a server reboot to clear. No clients could log into the server in this state and also when the program was run in single user mode it would not start correctly after the failed import.

The same TB file was then installed back into an existing client on the network and it loaded fine so this is the PC we still have running today. This would indicate that the TB file is good and that its just something that has happened between versions that means the TB file will not load. I think that is where you need to look.

That was the bug report I filed. Richard had got a developer to look at it and see if they could work out why it would not update. The time was allocated then I never heard anything back after that. I guess Richard has gone then!!

It would be handy if you could ask if this was identified and fixed before I try and update again?
Anna Lasko
12-3-21
Nejc, 09:49
no idea about the bug he cited but if we can get our hands on the backup we can probably fix it. And I have even less idea about UK invoicing. Sounds like a bug that will probably be prioritised as law requirement. A PM should test and find out what exactly it is that is not working for the customer and test it in latest version.
Anna Lasko
12-3-21
waiting for backup
Anna Lasko
12-3-21
"Refreshing access token failed" error message it might be because you need to grant access to the app using their login details

maybe when trying to update you broke the link with HMRC UK gov


https://www.gov.uk/government/publications/vat-notice-70022-making-tax-digital-for-vat/vat-notice-70022-making-tax


Available from:
Standard ERP 8.5 2018-11-23

MAKING TAX DIGITAL (MTD) WITH STANDARD ERP

Businesses with a taxable turnover that exceeds the VAT registration threshold (currently £85,000) need to submit their VAT return following the Making Tax Digital (MTD) criteria from April 2019. Please follow the steps below to link Standard ERP to your government gateway account and prepare your VAT Return to be submitted directly to HMRC.

To prepare your Standard ERP VAT report to ensure that the correct figures correspond to the correct boxes of the HMRC Vat Return:

1. Nominal Ledger >> Report Settings >> VAT Report >> flip B.
2. Add the corresponding box of the VAT return to the correct calculation in the VAT report.


In System>> Settings>> Company Info >> Reg tile, The VAT number must be entered correctly (i.e. GB xxx xxxx xx) in the VAT Reg. No. field.

To submit your VAT Return to HMRC, you need to grant access to allow the software to submit your VAT return on your behalf.
This access is granted for 18 months, after which you will need to grant the access again.

First allow access, through Access Groups, to a person or group of people who should be in charge of managing your VAT Submissions to HMRC.
In System >> Settings >>Access Groups >> Amend HMRC Access token with level Full.
This will allow a user to edit the Electronic VAT Declaration setting.

Nominal Ledger >> Electronic VAT Declaration setting
The Service mode should be set to Live.
If the Sender ID and Sender Key have not already been entered (Get these from who is managing the HMRC Developer Portal). This is referred to as the Client ID and Client Secret in the HMRC Developer portal.
1. Once you have your Sender ID and Sender Key entered, select the Operations Menu, then “Request Access Token”.
2. This will take you to the HMRC Government gateway webpage.
3. Select “Continue” on the “Authority to interact with HMRC on your behalf” webpage.
4. Enter your Government Gateway user ID and password to log in to your Government Gateway account.
5. Select the “Grant Authority” button to allow your HansaWorld product to interact with HMRC on your behalf.
6. If all submitted information is correct, the authority will be granted. Copy the authorisation code and paste it into your HansaWorld product in the Authorisation Code field, found in the Electronic VAT Declaration setting of the Nominal Ledger.

7. After entering your Authorisation Code, Select “Save”.

You will then receive an Access Token and a Refresh Token. These should not be manually edited.


Now you can Submit your VAT return to HMRC.
1. Navigate to the Nominal Ledger >> VAT Report

2. Run the report for the period that you would like to submit your VAT return.
3. Select “Submit VAT declaration electronically”.


This will open a new record window called VAT Declaration. These records are saved in Nominal Ledger, Settings, VAT Declaration.

4. Select the “OK” checkbox, then “Save”.
5. Open the Operations Menu and select “Submit VAT Report”.
This will send the VAT return to HMRC. You will be notified by a window that the VAT report was successfully submitted. If not, please ensure that you have all the correct settings as described above.


After Ok'ing this window you will see, on the VAT Declaration record window, the “FormBundleNumber” and the “Timestamp” have been entered, and the Fulfilled checkbox is checked. This is to notify you that your VAT return has been successfully sent to HMRC.

To view all previously submitted VAT returns, they can be viewed in the Nominal Ledger Settings >> Vat Declarations.
You can see for which date the VAT return was submitted as well as whether it was Fulfilled (Successfully received by HMRC).

If a correction needs to be made to a previously submitted VAT return, the amounts should be included in your next VAT submission.


Link to HMRC VAT Notice 700/22: Making Tax digital for VAT
https://www.gov.uk/government/publications/vat-notice-70022-making-tax-digital-for-vat/vat-notice-70022-making-tax-
digital-for-vat
Anna Lasko
12-3-21
so what you need to do is Update to the version you want, and after that grant access to the ERP app against HMRC Gov uk tax
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Back to the list
Latest Posts
Hi, No changes should have been made that would increase client's HDB file. Please try to delete HANSA.HDB from client folder and reconnect to server and check if it will grow to 30MB again. ...
10:14 30 Apr 2024
Hi Dave, Thank you for the message! Can you please report this as a bug and inform if you get anything in the hansa.log during the flickering. Thank you! Best regards, Rasmus...
09:35 30 Apr 2024