{"id":2963,"date":"2021-08-31T12:03:21","date_gmt":"2021-08-31T11:03:21","guid":{"rendered":"https:\/\/www.qmulus-solutions.com\/?page_id=2963"},"modified":"2021-10-01T16:48:04","modified_gmt":"2021-10-01T15:48:04","slug":"sage-tips","status":"publish","type":"page","link":"https:\/\/qmulus-solutions.com\/index.php\/sage-tips\/","title":{"rendered":"Q-Tips Sage software"},"content":{"rendered":"

<\/p>\n

The best practices<\/p>\n

\n<\/div>

<\/p>\n

from our Sage Experts<\/p>\n

\n<\/div>

<\/p>\n

Find out our best practices demonstrated and tested by our exceptional software developers delivering quick and easy frameworks for various situations! Whether it is Sage 200<\/a> or Sage CRM<\/a>\u00a0software, you might find them helpful!<\/span><\/p>\n

View Sage Video Tutorials<\/span><\/a><\/p>\n

\n<\/div>\n

\n\t\n\t\t<\/i> Watch now!\t<\/a>\n<\/div>\n<\/div><\/div>
\n\n \"Marketing <\/div>\n
\n\n \"marketing <\/div>\n<\/div><\/div><\/div><\/div><\/section>
\n\n \"Sage <\/div>\n<\/div><\/div>
\n\n \"qmulus <\/div>\n<\/div><\/div>
<\/p>\n

Report Templates<\/span><\/p>\n

\n<\/div>

<\/p>\n

Save your complicated report selection criteria for future use!<\/span><\/p>\n

\n<\/div>

<\/p>\n

A very useful feature available on all reports in Sage 200 is the ability to SAVE your selection criteria as a template and then recall them every time you need to run the same report.<\/span><\/p>\n

\n<\/div>\n

\n\t\n\t\t<\/i> Read More\t<\/a>\n<\/div>\n<\/div><\/div><\/div><\/div><\/section>
<\/p>\n

Importing changes to existing records<\/span><\/p>\n

\n<\/div>

<\/p>\n

The ability to import changes to Sales, Purchase, Nominal and Stock records has been available for a while but seems to be rarely used. It can be an extremely useful function…<\/span><\/p>\n

\n<\/div>\n

\n\t\n\t\t<\/i> Read More\t<\/a>\n<\/div>\n<\/div><\/div>
\n\n \"qmulus <\/div>\n<\/div><\/div>
<\/p>\n

Securing Supplier bank details<\/span><\/p>\n

\n<\/div>

<\/p>\n

It is very important to ensure that your supplier Bank Account Details are secure in Sage 200<\/a>. You may need to prevent most of your users from being able to see and\/or amend supplier bank details. Ideally, you would only permit certain users to be able to access this sensitive data.<\/span><\/p>\n

\n<\/div>

\n
\n\t\n\t\t<\/i> Read More\t<\/a>\n<\/div>\n<\/div><\/div>
\n\n \"Q-tips <\/div>\n<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>
\t\r\n\r\n\t\t\r\n\t\r\n\r\n\t
\r\n\t\t\t\t\r\n\t\t
\r\n\t\t\t\t
\r\n\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t<\/i>\r\n\t\t\t\t\t\t\t<\/div>\t\t\t\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t<\/i>\r\n\t\t\t\t\t\t\t<\/div>\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t
\r\n\t\t\t\t\t\t

Amend \/ Correct Nominal Ledger Journals that have already been posted<\/h2><\/div>\t\t\t\t\t\t

This function was introduced into Sage 200 quite a while ago but seems to be rarely used. The following tip will show you how to amend or correct ANY part of a Nominal Journal that you have already posted. Quite a useful function!<\/p><\/div>\t\t\t\t\t\t

Read More<\/a><\/div>\t\t\t\t\t<\/div>\r\n\t\t\t\t<\/div>\r\n\t\t<\/div>\r\n\t<\/div>\t\t\t\r\n\t\t\t\r\n\t\r\n\t\r\n\t\t\t\r\n\r\n\t\t\r\n\t\r\n\r\n\t
\r\n\t\t\t\t\r\n\t\t
\r\n\t\t\t\t
\r\n\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t<\/i>\r\n\t\t\t\t\t\t\t<\/div>\t\t\t\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t<\/i>\r\n\t\t\t\t\t\t\t<\/div>\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t
\r\n\t\t\t\t\t\t

Creating a Sales Return from a Sales Order<\/h2><\/div>\t\t\t\t\t\t

Sage 200 provides a Returns Note procedure that follows a process from New Return Note and Receiving the Returned Goods through to creating the Credit Note and allocating the returned products back into stock (ideally into a Returns or Quarantine warehouse).<\/p><\/div>\t\t\t\t\t\t

Read More<\/a><\/div>\t\t\t\t\t<\/div>\r\n\t\t\t\t<\/div>\r\n\t\t<\/div>\r\n\t<\/div>\t\t\t\r\n\t\t\t\r\n\t\r\n\t\r\n\t\t
<\/div>\t\r\n\r\n\t\t\r\n\t\r\n\r\n\t
\r\n\t\t\t\t\r\n\t\t
\r\n\t\t\t\t
\r\n\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t<\/i>\r\n\t\t\t\t\t\t\t<\/div>\t\t\t\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t<\/i>\r\n\t\t\t\t\t\t\t<\/div>\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t
\r\n\t\t\t\t\t\t

Print Spooling<\/h2><\/div>\t\t\t\t\t\t

It is usually the case that most Sage 200 users will choose to \u201cpreview\u201d their reports on screen rather than \u201cspool\u201d them, however there are some benefits in using the Print Spooler in Sage 200, especially for month-end or management reports...<\/p><\/div>\t\t\t\t\t\t

Read More<\/a><\/div>\t\t\t\t\t<\/div>\r\n\t\t\t\t<\/div>\r\n\t\t<\/div>\r\n\t<\/div>\t\t\t\r\n\t\t\t\r\n\t\r\n\t\r\n\t\t<\/div><\/div>
<\/div>\t\r\n\r\n\t\t\r\n\t\r\n\r\n\t
\r\n\t\t\t\t\r\n\t\t
\r\n\t\t\t\t
\r\n\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t<\/i>\r\n\t\t\t\t\t\t\t<\/div>\t\t\t\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t<\/i>\r\n\t\t\t\t\t\t\t<\/div>\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t
\r\n\t\t\t\t\t\t

Lead management<\/h2><\/div>\t\t\t\t\t\t

All information is collected in the lead profiles and is also displayed in dashboard analytics. Track lead sources to evaluate the effectiveness of lead generation channels used in your marketing campaigns and focus your efforts on the best performing channels.<\/p><\/div>\t\t\t\t\t\t

Read More<\/a><\/div>\t\t\t\t\t<\/div>\r\n\t\t\t\t<\/div>\r\n\t\t<\/div>\r\n\t<\/div>\t\t\t\r\n\t\t\t\r\n\t\r\n\t\r\n\t\t<\/div><\/div>
<\/div>\t\r\n\r\n\t\t\r\n\t\r\n\r\n\t
\r\n\t\t\t\t\r\n\t\t
\r\n\t\t\t\t
\r\n\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t<\/i>\r\n\t\t\t\t\t\t\t<\/div>\t\t\t\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t<\/i>\r\n\t\t\t\t\t\t\t<\/div>\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t
\r\n\t\t\t\t\t\t

Trigger campaigns<\/h2><\/div>\t\t\t\t\t\t

Plan campaigns using the simple visual campaign designer and define conditions for transitioning between campaign stages. The system allows for the setting up of criteria for target conversion rates and campaign completion. <\/p><\/div>\t\t\t\t\t\t

Read More<\/a><\/div>\t\t\t\t\t<\/div>\r\n\t\t\t\t<\/div>\r\n\t\t<\/div>\r\n\t<\/div>\t\t\t\r\n\t\t\t\r\n\t\r\n\t\r\n\t\t<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>
\n\n \"qtips <\/div>\n<\/div><\/div>
\n\n \"qmulus <\/div>\n<\/div><\/div>
<\/p>\n

Project users<\/span><\/p>\n

\n<\/div>

<\/p>\n

A customer needs to associate a number of Users to an Opportunity so that when something changes on that Opportunity all the associated Users are notified via email.
<\/strong>
We could build new functionality into the system to allow a CRM<\/a> User to link a User to an Opportunity, but maybe there is an easier solution that might satisfy the customer's needs without the need for lots of 'coding'…<\/p>\n

\n<\/div>\n

\n\t\n\t\t<\/i> Read More\t<\/a>\n<\/div>\n<\/div><\/div><\/div><\/div><\/section>
\t\r\n\r\n\t\t\r\n\t\r\n\r\n\t
\r\n\t\t\t\t\r\n\t\t
\r\n\t\t\t\t
\r\n\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t<\/i>\r\n\t\t\t\t\t\t\t<\/div>\t\t\t\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t<\/i>\r\n\t\t\t\t\t\t\t<\/div>\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t
\r\n\t\t\t\t\t\t

SQL Functions<\/h2><\/div>\t\t\t\t\t\t

SQL Functions can be very useful for solving complex problems - with one caveat, we must always consider the cost to SQL Server's performance. That being said the following is a SQL function that will take a date and work out the Financial Year, Quarter, and Month, it will also return a 'normalized' Financial date although this is not necessarily needed as we could always create this outside the function.<\/p><\/div>\t\t\t\t\t\t

Read More<\/a><\/div>\t\t\t\t\t<\/div>\r\n\t\t\t\t<\/div>\r\n\t\t<\/div>\r\n\t<\/div>\t\t\t\r\n\t\t\t\r\n\t\r\n\t\r\n\t\t
\n\n \"qmulus <\/div>\n
<\/div>\n
\n\t\n\t\tGet in Touch!\t<\/a>\n<\/div>\n<\/div><\/div>
<\/div>
<\/p>\n

\nHaving some questions?<\/p>\n

\n<\/div>

<\/p>\n

\nLet us help you! Book a Free consultation with our Expert!<\/p>\n

\n<\/div>

<\/div><\/div><\/div><\/div><\/div><\/div>
\t\r\n\r\n\t\t\r\n\t\r\n\r\n\t
\r\n\t\t\t\t\r\n\t\t
\r\n\t\t\t\t
\r\n\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t<\/i>\r\n\t\t\t\t\t\t\t<\/div>\t\t\t\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t<\/i>\r\n\t\t\t\t\t\t\t<\/div>\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t
\r\n\t\t\t\t\t\t

Global Script caching<\/h2><\/div>\t\t\t\t\t\t

When we're working with global custom scripts (C:\\Program Files (x86)\\Sage\\CRM\\CRM\\WWWRoot\\js\\custom\\) it is a bit annoying to have to refresh the CRM App Pool or reset IIS in order to be able to test our changes.<\/p><\/div>\t\t\t\t\t\t

Read More<\/a><\/div>\t\t\t\t\t<\/div>\r\n\t\t\t\t<\/div>\r\n\t\t<\/div>\r\n\t<\/div>\t\t\t\r\n\t\t\t\r\n\t\r\n\t\r\n\t\t\t\r\n\r\n\t\t\r\n\t\r\n\r\n\t
\r\n\t\t\t\t\r\n\t\t
\r\n\t\t\t\t
\r\n\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t<\/i>\r\n\t\t\t\t\t\t\t<\/div>\t\t\t\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t
\r\n\t\t\t\t\t\t\t\t<\/i>\r\n\t\t\t\t\t\t\t<\/div>\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t
\r\n\t\t\t\t\t\t

Removing an element that is added to the screen after the :apos:Ready:apos: or :apos:Load:apos: event<\/h2><\/div>\t\t\t\t\t\t

In this article we're going to look at how we can hide an element that is loaded into CRM after the page 'Ready' or 'Load' event has fired; e.g. Date and Time field images.<\/p><\/div>\t\t\t\t\t\t

Read More<\/a><\/div>\t\t\t\t\t<\/div>\r\n\t\t\t\t<\/div>\r\n\t\t<\/div>\r\n\t<\/div>\t\t\t\r\n\t\t\t\r\n\t\r\n\t\r\n\t\t<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>
<\/p>\n

Interested in learning how Sage can help your business?<\/p>\n

\n<\/div>

<\/p>\n

Find out more useful Tips here<\/p>\n

\n<\/div>

<\/p>\n

Can Moving From Sage 50 To Sage 200 Really Improve My Business?\u21aa<\/a><\/p>\n

\n<\/div>

<\/p>\n

Sage 200 Overview \u21aa<\/a><\/p>\n

\n<\/div><\/div><\/div>

<\/p>\n

What is the difference between Sage 50 and Sage 200? \u21aa<\/a><\/p>\n

\n<\/div>

<\/p>\n

Sage CRM Video Tutorials \u21aa<\/a><\/p>\n

\n<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"template-home.php","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"class_list":["post-2963","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/qmulus-solutions.com\/index.php\/wp-json\/wp\/v2\/pages\/2963","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/qmulus-solutions.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/qmulus-solutions.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/qmulus-solutions.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qmulus-solutions.com\/index.php\/wp-json\/wp\/v2\/comments?post=2963"}],"version-history":[{"count":12,"href":"https:\/\/qmulus-solutions.com\/index.php\/wp-json\/wp\/v2\/pages\/2963\/revisions"}],"predecessor-version":[{"id":2986,"href":"https:\/\/qmulus-solutions.com\/index.php\/wp-json\/wp\/v2\/pages\/2963\/revisions\/2986"}],"wp:attachment":[{"href":"https:\/\/qmulus-solutions.com\/index.php\/wp-json\/wp\/v2\/media?parent=2963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}