Skip to Main Content
Sage 200 UKI Ideas Portal
Status Idea Accepted - Gauging Support
Categories Account Account
Created by Tina Baldwin
Created on Jun 6, 2024

Import Memo Notes from a spreadsheet to Various Customers or Suppliers Accounts

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.

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
  • Admin
    Jo Kirkup
    Reply
    |
    Jul 8, 2024

    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.

  • Tina Baldwin
    Reply
    |
    Jul 2, 2024

    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

  • Admin
    Jo Kirkup
    Reply
    |
    Jul 2, 2024

    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.

  • Tony Davis-Coyle
    Reply
    |
    Jun 24, 2024

    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.