Dynamics GP – Error “No Obligations found for the year” when retrieving VAT Obligations – Issue with the version of the VAT100ElectronicSubmission DLL file

We had a client report the error “No Obligations found for the Year 2020” when trying to retrieve the obligations when doing the VAT return. They were running Dynamics GP 2018 version 18.00.0704.

The exact error is below

We checked all the usual things like company VAT number, and also tried when logged in as “sa” even though the relevant service pack has been applied, however the error persisted. (more details on troubleshooting can be found in this Microsoft link)

I then had a colleague run a fiddler trace and he noticed that on the tunnel to the HRMC API there were calls using TLS 1.0 and on further investigation the message “The function requested is not supported”

My colleague suspected a change on the HRMC side which was preventing TLS 1.0 from working.

We suspected the file VAT100ElectronicSubmission.DLL located in the GP client folder was responsible for this functionality so I checked the version currently installed which was 18.0.705.0

I then copied the VAT100ElectronicSubmission.dll file from my Dynamics GP 18.3 local install which is version 18.3.1181.0 to the users PC. (i.e. the latest version)

Now when we tried again this all worked! The obligations were retrieved successfully and we are now presented with the “Select Obligations” window

We also tried another PC which had previously had the same issue and this also worked!

Therefore we can only surmise that something has changed at HMRC’s side and there are now issues with certain versions of the VAT100ElectronicSubmission.dll files on older versions of GP.

We now plan on rolling out Dynamics GP 18.3 to all PCs at this site and are waiting to see if this affects other users on the older version.

Conclusion

Again we can only guess, however it seems something may have changed at the HMRC side which is preventing making tax digital submissions when you have an older version of the VAT100ElectronicSubmission.dll file. We found the solution is to replace this file with the most recent copy available with Dynamics GP 18.3.

Fingers crossed this helps others who may encounter this issue.

Thanks for reading!

Dynamics GP – Error Msg “Transaction Analysis information for this transaction is incorrect or missing” on Sales Edit List.

A client reported the error “Transaction Analysis information for this transaction is incorrect or missing” when trying to post a batch of sales invoices.

A screen shot of the error message on the edit list is below:

I connected to the clients system, ran an edit list, and found I also received the same error message.

I know this error is usually related to Multi Dimensional Analysis (MDA) or Analytical Accounting (AA) issues on the transaction, and as this client doesn’t use MDA, I figured it was most likely related to AA.

I therefore checked the AA window in the distributions on the transaction, expecting missing AA codes, however everything seemed fine. I then clicked “Validate” and was presented with the following permission error:

This indicates I don’t have permissions to some of the AA codes on the transaction.

I therefore went to “Tools > Setup > Company > Analytical Accounting > User Access” and granted permissions to all the relevant AA codes for my user. Then, I then ran another edit list of the batch and the error had gone.

Next I updated the clients permissions and they can now post the transaction.

I hope this helps anyone else encountering the same issue.

Thanks for reading!

GP to BC Fundamentals Video- General Posting Groups

As I’ve mentioned several times on my blog I originally come from a Dynamics GP background so making the transition to Dynamics 365 Business Central has been a real learning journey for me, and one that is still ongoing.

Along the way I’ve managed to learn some important concepts which I hope to share in a series of short videos.

The first one focuses on how GP and BC differ when setting up and selecting default GL codes.

Hopefully new GP to BC users will find it useful. (or anyone new to BC for that matter)

Thanks for reading!