Browse By Tags

  • Difference between Quantity on PO and Quantity on Order- Inventory Reorder Worksheet

    Hello, We're starting to utilize the inventory reorder worksheet report, and we can not figure out what the difference of the column options are for "Quantity on PO" and "Quantity on Order". The figure seems to be the same, but this has to mean two…
  • Configure your view - Add / remove columns in a couple of clicks...

    In Sage 50cloud Accounts it's easy to add, remove and resize columns to suit your needs. You can do this in each module, for example, Customers and Suppliers, plus many additional windows with list or grid views. Read more >
  • Sales Order Lines Column Format suddenly changed?

    I'm hoping someone will have experienced something similar. Today our Sales Dept. reported that the columns in the Lines tab for Sales Order Management had suddenly changed. As you can see below there are now EDI PO Line, EDI L UDF1, & EDI L UDF 2 being…
  • Character Limitations

    Currently SAGE 50 only allows for 15 characters in the country field and 2 in the state field. When shipping overseas this presents problems as some country names exceed that character limitation. Or, in a place like Australia the state abbreviations…
  • List - Control the column width

    Is it possible to adjust the display width of a list page? I have the following list page and I would prefer that the Reference number did not "wrap" to the next line. Is there a way to force this column to always default to a fixed width? I want the…
  • Converting default ntext fields from an old install of CRM to nvarchar(max)

    This is a SQL script that will solve the problem associated with on-premise accounts that still have some ntext fields in their database from older versions of CRM. The ntext fields do not allow some of the actions that are used in the views of CRM…
  • Creating a compound filter (filterWhere) using the Client Side API

    This article is about the client side API. Specifically this article is concerned with how to write a script to handle the information within a grid and then apply an action to the cells, row or columns of the grid where more than one criteria is needed…
  • Control of Grids, Lists and Columns Using the Client Side API

    The Client Side API contains methods that make it much easier to select rows, columns and individual cells for manipulation. Properties can be set, new data displayed in tool tips and the style of each cell can be changed. The documentation contains…
  • Useful Date Functions

    Occasionally you will need to fetch a date from either the CRM database or perhaps from an external system that is then needs to be formatted so it looks like a CRM date. All users are able to set their date preferences. The are other articles that…
  • Building Lists without reference to Metadata in the ASP COM API

    Above is a picture of a new list added into the My CRM area of Sage CRM. The code below shows how a list can be created using the ASP COM API. var intRecordId = CRM.GetContextInfo("user","user_userid"); var Arg = "oppo_assigneduserid="+intRecordId; var…
  • The importance of column prefixes in tables exposed via the Web Services API

    This is a little quirk. If you have added a new table into the CRM database that you intend to access via the webservices interface, then be sure that the table column makes use of column prefixes. For example if you have added a new project table then…
  • How do I remove the Type column from the PersonList?

    The personlist list block is defined under the Admin>Customization>person>lists area but the column for the type is added by the dll. The column draws its information from the translations (custom_captions) that control the different 'types' of person…
  • Team calendar - Agenda and Tasks.

    Hello! We are working with a sale manager that needs to be able to see who the assigned user is on the Agenda and Task screens for the Team calendar. They are currently using CRM 2017 R3. Is it possible to add a column to the Team Agenda and Task lists…
  • Why wont the sales windows columns stop automatically resizing?

    It's quite annoying. The Windows and the columns within them keep resizing themselves. The sizes I select will not stick. Is there some kind of a hack or tweak that will keep the sizes fixed? I don't need the TAX CODE, QUANTITY, ORDER, etc columns to…
  • Sage 50 Forms Designer - Adjust column widths

    I am trying to lay out my invoice but have gotten stuck laying out the columns for the invoice. Right now I have two columns, Description, and Amount. They are both equal in width which looks sort of strange. I want the description column to be, say,…