P.S.  The VAT number is on the customer record - and it has been verified via VIES. 

Hi Karen.

Thanks for using Sage City.

Has the VAT number been amended in any way? 

What you can try is take a backup of the data > then delete this particular transaction > re-enter it using the same details > save > check it again.

Regards.

Sean,

Sage UKI

Thanks Sean.  I'll try that out next week and let you know.

Regards,

Karen

Hi Karen, did you ever resolve this?

I have had a problem this month and it seems to be a code issue.  An invoice as raised late - after the last ECSL (and VAT return) was submitted, with a September date. The amount is included on the October VAT return, however when the October ECSL is created it does not include anything prior to October, even though it wasn't subnitted on the previous ECSL retun.

This is different to how both VAT and Intrastat are calculated as 'unflagged' items are included in the return.  Can Sage confirm this is an issue and can it be fixed.  As far as I can see the ECSL can't be manually amended so will have to be submitted and then an adjustment form submitted to HMRC for the September invoice not included.

I'm having the same problem with missing transactions after June, I've checked all the criteria in the help section for missing transactions and all of mine were set up correctly - T4 Transactions, customer flagged as IE, address is Ireland, Ireland is marked as an EU country etc - is there a bug introduced when I moved to the subscription version as it seems to be missing transactions after June.  Just had to work it out manually and send correction form to HMRC for the ones missed on earlier declarations.  I had relied on SAGE being right unfortunately - my current declaration stated no transactions yet I knew there had been one, thankfully that was what alerted me to check the other declarations.

Hi Stephen.

Thanks for using Sage City.

At the moment the ECSL won't pick up late entries so you will have to do a manual adjustment.

However, you can keep an eye on future changes and also submit this request for change at www.sage.co.uk/roadmap.

Regards,

Sean
Sage UKI

Hi Tracy.

Thanks for using Sage City.

Are you running the EC sales list for the same date as the transactions are dated?

Regards,

Sean
Sage UKI

My current ECSL period is Q4 Oct to Dec.  The transaction that is missing this time is dated 16/09/2019 but Posted Date is 11/10/2019. Therefore nothing was shown for this period and it wasn't picked up earlier in Q3.  

I then ran a query using the date range as Jan - Dec 2019 and noticed that two other transactions were not picked up in earlier periods.  Whatever the dates are they should be picked up in one period or the other, surely?

If I issue a quote on 16/09 and take a deposit of 50%, I can't issue the final invoice until the goods are manufactured and sent on 11/10/2019 (that is the point when I update ledger).

Hi Tracy.

Thanks for the additional information. 

If the date on the transaction is in September it won't get picked up on Oct - Dec ECSL. 

Looking at the dates you mentioned, it looks like it may have been posted after you'd already completed Jul - Sept ECSL as well. 

This is the same issues Stephen was having. At the moment you would have to manually submit those ones. If you also submit your request for change on www.sage.co.uk/roadmap and our development team will look in to these suggestions for future releases. 

Regards,

Sean
Sage UKI

I've logged a request to fix this - if anyone wants to vote for it it's here https://www.sagecity.com/gb/sage-50-accounts-and-sage-50cloud-accounts-uk/i/sage-50-accounts-and-sage-50cloud-accounts-ideas/correct-the-loophole-that-misses-ecsl-transactions