The Book-keepers Forum (BKF)

Post Info TOPIC: How to deal with two customer entries on Sage for the same customer??


Member

Status: Offline
Posts: 14
Date:
How to deal with two customer entries on Sage for the same customer??
Permalink Closed


Hi All,

I'm hoping you can help.  I work with my husband & I'm finding that when new customers come along, I will confirm with him what the 'invoice' customer details will show before setting the customer up on Sage i.e in this scenario I was told to create an account for the customer as 'Mrs Walker' which I did and posted a payment on account for the cash amount paid.

Frustratingly the customer invoice is then something different so in this case its the company name and now I have two entries relating to the one customer, one with the invoice details and another for a payment on account.

I have tried deleting the customer in the customer list window but it tells me I can't as there is activity associated.  I know I can go into the maintenance area and delete but just wanted to check what other's do in this scenario as I'd hate to delete something I shouldn't so see this as the last resort really.

Any advice would be much appreciated.

Mrs MacP 



__________________


Senior Member

Status: Offline
Posts: 266
Date:
Permalink Closed

I would go into file maintenance, find the payment on account, and then change the customer account to the one that includes the customer invoice.  That wil tidy up the transactions so that the payment on account and invoice are in the same customer account.  It may well be that Sage still doesn't allow you to delete the original customer account (even though 'Mrs Walker' is now empty), in which case you may simply have to amend the name of the account to 'ignore' or something similar.

If this happens again in the future, can you not just amend the details (name, address etc) of the customer account from the individual to the company?  The downside to this may be that the account reference may not be correct (if it's based on the individual's name, rather than the company's name).



__________________

Pearce & Co - Chartered Accountant and Chartered Tax Adviser 

www.pearceandcoaccountants.co.uk

These comments are outline only and are not a substitute for specific professional advice.



Member

Status: Offline
Posts: 14
Date:
Permalink Closed

Hi Robert,

Thanks for the advice. As soon as I read your response I thought 'why didn't I think of that'! Your suggestion worked perfectly & you were right that I'm not able to delete the customer from the customer list, but that's ok, I've just marked it as duplicate so I know not to use it.

Part of using the system as against manual entry is training those around me that things can't just be altered so easily! Its a communcation thing mainly that we need to sort out & I'll be making sure that I double check through the customer list & cross checking with the office before setting any new customer up.

Many thanks

__________________
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