Browse By Tags

  • Webinar - Add a logo to invoices and layouts - Recording available

    Learn how to use the Report Designer to add a logo to your invoices and other documents in Sage 50 Accounts. This session has already taken place, but you can catch up with a recording:
  • Hold the Phone! A round up of articles that discuss Phone Numbers in Sage CRM

    In Sage CRM development around phone numbers and email addresses needs careful thought. This is because Sage CRM "entities" can be complex. For example, the information for a Company consists of a company record, a default person record and a default…
  • Why do Phone numbers appear in the Company and Person screens when they are stored in the Phone table?

    This is a follow-up to the article I wrote previously called " Understanding the CRMEmailPhoneData table ". That article explained that the CRMEmailPhoneData is a utility table and that its job is to speed up reports. It holds a row for each company…
  • Understanding the CRMEmailPhoneData table

    If you have spent time looking at the way in which views are constructed in Sage CRM then you may have found the CRMEmailPhoneData table referenced and wondered what is the table's purpose. I asked a colleague in our development team for some help in…
  • Inserting Companies, Persons, Communication to another territory

    We would like to move companies, persons and communication to another territory. Is it possible to do this with a stored procedure and how do I do it? Also, I may not want to move the entire persons in the company.
  • BASIC ADDITION TO 'SALES'

    When invoices are done up, i quite often would like to use point form. Please add in the ability to 'tab' to indent or the option to change justification - left or right to help with this basic problem that allows the end receipiant a clear invoice. …
  • Importing customer payment for existing invoice

    We have an existing payment engine that processes credit card and checking. I have created the ability to lookup invoices with a balance, "grab" all the details and offer customer payment through other means. Now I need to bring the payment information…
  • Cannot Insert, Update Or Delete ...

    I'm trying to assign Optional Fields that I created in Common Services to to the A/R Optional Fields Module. Every time I press Save, I get this message: Incorrect procedure. Cannot insert, update, or delete A/R Optional Fields until all other users…
  • How to add a column to price sheets?

    Hi All, First post, a little bit about myself: I'm an IT intern for a small manufacturing company in Northern Colorado, I've been given some projects that involve MAS 500, mainly report customization. There currently is no on-site IT staff, so I've…