The Book-keepers Forum (BKF)

Post Info TOPIC: Sage wizard needed


Veteran Member

Status: Offline
Posts: 45
Date:
Sage wizard needed
Permalink Closed


Hi,

I am trawling through a bundle of remittances which i have matched to hard copy invoices so i can post several months worth of receipts. However in the customer activity i cannot see the invoice number. I have then checked the invoice list, and the invoice number on the remittance and printed invoice has been allocated to a different customer.

Sage are as baffled as me, and have said it is down to human error rather than a technical issue with the software. I have around 40 printed invoices that have been paid for, which i cannot post a receipt against as they are the invoice number is now assigned to another customer.

Any  sugestions will be extremely greatful.



__________________


Senior Member

Status: Offline
Posts: 426
Date:
Permalink Closed

apologies I really cannot visualise this query - are the invoices raised manually rather than on sage? I am unable to understand how a sage raised invoice would post to a different account.

__________________

 

Donna Curling - Complete Book-Keeping Ltd (CBKLtd) - 07939 101900

Payroll & bookkeeping solutions - info@completebookkeeping.co.uk

www.completebookkeeping.co.uk

IAB Training centre - Ringwood

 



Senior Member

Status: Offline
Posts: 115
Date:
Permalink Closed

Hi Nikola,

I presume you've done all the data checking available in Sage and there's nothing to report?

I think I'd be inclined to engage with either John Donnelly, at Leyburn Solutions, or Bruce Denney, at Making I.T. Happen, for stuff like this. Very knowledgeable guys.

Regards,

__________________

Ian

Ian Brown FCA
Onion Reporting Software Ltd

www.onionrs.co.uk

Sage accounts in Excel to go. No set-up necessary.



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Have they done this through the recall invoice option and then forgotten to change the customer name before loading the invoice?

Maybe you could post a screen shot of the invoice page, although the above seems most likely to me (as someone who has made that mistake, although only on one invoice). If it is this then consider manual Credit note and re invoice to correct account although if there are a lot you may wish to avoid this (don't do via the invoice facility or this will mess up your future numbering). Or as Ian suggests speak to one of the guys he mentions, both do great work/ have great reviews and are on this site somewhere.

__________________

 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: 45
Date:
Permalink Closed

Sage checked for any corruption and there was nothing to report.

The MD raises the sales invoices and i cannot speak to her just yet. She did comment a few weeks ago, that she though there may be invoice numbers missing in Sage. Nothing else was mentioned so i didnt push it with being new with the company.

The printed invoices are correct as the customer would not issue a payment. I just cant get my head around around the MD has managed to then go on to use some of these invoices numbers to generate invoices for other companies.

I think i need to have a chat with Leyburn or Making IT Happen.

__________________


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Any chance you can sit with her whilst she shows you what she has done? (After taking a back up of course). Just read your post again and you mention printed invoices, but are they appearing anywhere in sage? Are they listed under a different customer? Or not on there at all?

Sounds like they have been raised as draft but not posted? Also it's possible the MD has done a reset on the invoicing page which may mean the system has started again, or if they did a restore after issuing a batch it will not have picked up the new ones.

Can you check via the invoicing screen - go into a blank invoice & overtype the <autonumber> with one of the numbers you have printed then tab along. If the invoice appears then it means it is definitely in the system somewhere.

__________________

 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



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Sorry, hard to visualise what you are seeing, plus what my sage shows as I'm not online today.



__________________

 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: 45
Date:
Permalink Closed

I have just printed off a day book summary, and there are no invoices for Aug - Oct, despite me physically looking at the hard copies as we speak.

I have spoken to a lovely chap at Leyburn, and we have established that the invoice numbers have been generated again under a different customer as whoever has restored a backup, must have not restored the most recent back up.

Such a mess really!

I have 2 options > 1, Restore to the most recent backup, and re-invoice from last week of November. Or option 2 is to find out exactly which invoice numbers have been used twice, and re-invoice the earlier customer that wasnt restored from the last backup.

Sage is such a mess at the minute... Argghhhhhh



__________________


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Oh heck, good thing is that at least you now know why!!! That's always half the battle. Need to try to find out why a different back up was restored or you could be opening up a whole NW can of worms. The prudent me says go to the earlier back up even if it's a bit extra work. But how about using the later back up, extract the info of the new clients you need to invoice, invoice manually (??), restore earlier back up, add re-invoices via as pad sheet data import (giving them an additional reference eg a letter, so you don't get things mixed up? Something along those lines anyway. Good luck with it.

__________________

 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: 45
Date:
Permalink Closed

New can of worms is what i am afraid of. The accountant has been using a manual cash book for this financial year, so looks like i will be continuing with that until i can sort Sage out.



__________________
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