Doing credit control for a larger organisation it is easier to put everything into a spreadsheet where we can put notes that can be seen by all line managers, not everyone has access to Sage. But once done we are then having to put the notes onto the customers accounts so that a full history can be seen and also if court action is required a clear audit trail is achieved.
Tina Baldwin
| Idea Benefit | Time - Records on account with up to date real time information - Importing Data from a spreadsheet is quick and instant - update numerous accounts together |
| How do you solve for this problem today? | This is done manually at present |
| Product Variant | Sage for Education |
thanks for the clarity, at present you can't import notes into the customer records, so the workaround to export given about is the only other option for you at present.
Hi Jo
The trouble is we are dealing with 456 customers on our ledger and to put the notes in one by one is just too time consuming, which is why we use the spreadsheet.
Is there a way that the report designer can make a report that we can use so that we can then import the notes onto sage?
Thanks
Kind regards
Tina Baldwin
This would be possible to enter the notes into Sage and then extract for use in Excel. If you contact our report design team they can do it via the report design service, you get 3 reports per year included with your Sage 200 contract.
Why not do it the other way? Enter the notes into Sage, and then draw the data into an Excel Report?
That's the way my clients handle their Debt Control these days.