The Book-keepers Forum (BKF)

Post Info TOPIC: Sage query re EC Sales list


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Sage query re EC Sales list
Permalink Closed


Hi Guys

Well Ive never come across this one before.  I have just completed an EC sales list for a client and on the Sage reports it is missing one letter from the end of the customers Irish VAT number.  

All the other country VAT numbers are correct, and indeed the missing letter is actually present on the customer record, so I am at a loss how to correct it.  Ive also completed several EC sales lists on the same version of sage and not encountered this problem before.   

Wondering if it was still April fools day?!!  

Workaround was easy enough in that I complete the EC sales list manually via VAT online, rather than submitting from my Sage, but just wondering how that one could be sorted.

Any ideas folks?

 



__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Veteran Member

Status: Offline
Posts: 99
Date:
Permalink Closed

Hi Joanne - my turn to reply to a message of yours now!!

Do you mean the Sage report as in a PDF (like the one accessed in Customer>Reports>EC Sales) or the generated return which is accessed on the VAT screen?
If it's the PDF version, I have endless problems with them cutting off information because of the columns not being wide enough...? Thank goodness for Report Designer!

I just entered a few dummy customers on a Sage of mine and tried all variations of Irish VAT numbers (with the 8 or 9 digits, letters before/after), it all showed up ok for me.



__________________
Faye


Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

As Faye suggests, the problem is almost certainly a case of the number not fitting in the space given over to it in the report.

Looking up the format of Irish VAT numbers, they are eight characters long, most of which are digits but either the last or the second and last could be letters. In most fonts, numerical digits all have the same width - but unless you are using a fixed width font (which the report probably isn't), then the width of letters can vary.

I'd guess that if you looked at the affected VAT number, any letters it contains are wider ones. This would make the overall VAT number slightly wider when printed than one that doesn't have similarly wide letters in it.

When you submit the return online to HMRC from within Sage, it doesn't send them a print out; it sends the actual data - so (if the above is indeed the problem) submission wouldn't have been affected.

Edit: @Faye - Like the maths joke. Sadly, I get it. ;)



-- Edited by VinceH on Tuesday 5th of April 2016 11:06:33 AM

__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Thanks guys - it is indeed just the PDF report. Must be lucky with the other lines on there, unlike you Faye. But yes Vince the particular problem one has an 'M' at the end, which is a wider one!


__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About