Solved

Sage Line 50 - customer data disappeared

Posted on 2008-10-07
4
1,078 Views
Last Modified: 2011-09-20
I have been administering  Sage and Small Business Server for a year now.  This is the first time I have administered Sage.  I recently updated a lot of prices and added some new customer pricelists.  In order to do this I took a backup of the live system and restored it onto a local machine separate from the network to work on independently.

For a week I updated the standalone version and let the live version run on the network for the business to use. Last weekend I restored the standalone version I had updated back onto the network and keyed in the outstanding invoices from the previous week.  

All works well, except we have lost all the memos from the customer records.  Can anyone tell me which Sage system file this information would be in - and could I just add this back in to the system to make the information show up again?
0
Comment
Question by:tom65d
  • 2
  • 2
4 Comments
 
LVL 13

Expert Comment

by:Nick Denny
ID: 22657702
Which version of Sage do you have?
This is a known problem in V11 - it doesnt backup the files for the Memo.

Sages answer is to download the whole install program v11.01  and the v11.01 Service Pack 2 and reinstall/apply updates.

The memo fields are held as *.lm files n the Program Files\Sage\Accounts\MEMO directory.
0
 

Author Comment

by:tom65d
ID: 22657949
Thanks for your comments.  We have v12 - service pack 1, so hopefully my backups should have the memo files still intact somewhere.  I'll have a look and reapply them to the current version.  Thanks for your help.
0
 
LVL 13

Accepted Solution

by:
Nick Denny earned 125 total points
ID: 22658059
Hi
In addition to SP1 you should also have hotfixes 57, 58, 61, 68 & 70.

Also, the error in v11 (which may not apply here of course) was the the MEMO directory was not actually backup up.
0
 

Author Closing Comment

by:tom65d
ID: 31503753
Thanks - managed to reload the MEMO files from a previous Windows backup.  Seems the Sage backups I took didn't include MEMO directory - even using v12.  
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Exchange 2010 - Two email addresses - OOF on one 45 94
Unable to edit save GPO not enough disk space 11 47
Massive Event ID 10009 5 33
roaming profiles windows server 2016 8 67
In the event you manage a Small Business Server 2003, and you are audited for PCI compliance, there are several changes you must make in order to pass the audit. I can take no credit for discovering any of these fixes or workarounds, but there is no…
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question