Client has Sage 50 Accounts Professional version 22 (on a server).
They have a few customer/debtor accounts, but mostly use one debtor account styled 'cash account' for invoice production, otherwise their customer list would be pretty huge.
Invoice address panel contains
cash account - xxxxxxx (name of customer)
mobile number
email address
(and occasionally the full address)
Historically the email addresses have been collated in a separate database, but the phone numbers have not.
Client now wishes to extract the mobile numbers.
Wondering if anyone knows how this can be done? Nothing obvious springs to mind from Sage.
Wondering if Onion can help?
Edit - oops forgot to add - there is about 8500 lines of invoice data, albeit once extracted there will be duplication of info as its a repeat customer bases (annually or some times more).
-- Edited by Cheshire on Thursday 12th of December 2019 04:54:02 PM
__________________
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
I know none of the usual customer/invoice reports will do what you want, but I suspect exporting the invoices instead of printing them might work - and I've just fired up my Windows laptop (very rarely do I do that at home!) and experimented, and I think you're in luck - at least, this seems to work for me. Try it with a small batch first, just in case.
Select the batch of invoices, then click on the print (not quick print) icon on the toolbar. Select the invoice layout, and instead of printing, choose export (just the standard export, NOT export to Excel). Change the 'Save as type' to CSV, choose a filename, then save.
If you load the newly saved CSV file into a spreadsheet, you should hopefully see it's saved it as a line per invoice (whereas the Excel option would've laid it out to resemble an invoice). If they've been consistent with that address format you describe, the phone numbers *should* all be in one column. (You'll probably find the columns intermixed slightly - depending on the actual layout for invoices. (Here for example, A is 'Invoice' or 'Credit Note', B is the company name, C the account reference, D the first line of the address, E the date, F the second line of the address, and so on).
You could probably create a new layout that contains not much more than the address panel, and thus reduces the clutter in the CSV file - might speed things up slightly.
As for having that one customer account, I have a client set up similarly (my choice, not theirs). In their case, it's two accounts, one for B2B sales, one for B2C sales. (This happens to be the one I've mentioned before for whom I wrote an invoicing program).
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
I keep an eye out, but it's not often I know anything that is of particular use to the folks on here. Then one on Sage comes along (I might have a chance there) and Vince piles in with his usual very comprehensive answer. Oh well. He must sleep sometime. I'll try looking for unanswered questions that I might know something about in the dead of night!
