Jape Consulting Ltd
  • About Us
  • Sage
    • Sage Training Courses >
      • Sage 50 Accounts Training
      • Sage Training Online
      • Sage Payroll Training Courses
      • Sage Report Designer Training Courses
      • Sage 200 Report Designer course
      • Sage HR Training Courses
    • Sage Consultancy >
      • Sage Report Design Service
      • Sage Layouts and Templates
      • Sage 50 Commercial Invoice
      • Sage Support
      • Sage Data Export
    • Sage Software
  • Crystal Reports
    • Crystal Reports Training >
      • Introduction to Crystal Reports Training Course
      • Advanced Crystal Reports Training Course
    • Crystal Reports Online Training Courses
    • Crystal Reports Consultancy & report development
    • Crystal Reports Support
    • Crystal Reports Access Dimensions
    • SAP Business One Crystal Reports
  • Contact
  • Blog

SAGE & CRYSTAL REPORTS NEWS & HELP

Sage 50 Commercial Invoice

10/12/2020

0 Comments

 
We are getting lots of requests for commercial invoices from Sage which display a lot more information which is required for Brexit.  The invoice can be produced either directly from the Invoices and credits screen or from the Sales order confirmation screen.

See the sample below of an invoice we have produced.

Sample Sage Commercial Invoice Template >

We are happy to discuss your requirements and tailor this to your company.

The price to produce a single Sage layout template is £90 + VAT

​
Contact us today
0 Comments

Where to post furlough amounts in Sage 50 Nominal?

7/5/2020

0 Comments

 
If you have claimed to furlough your staff and are not sure where to post this into Sage, you can follow the instructions in the document link below.  Basically you need to setup two Nominal codes, Sage suggest 1150 which is Job Retention scheme accrued income and 4950 (or any number in the 49 section) which is Job Retention scheme grant received.  You then need to post a journal to record the claim you have made and then when the payment is received post a bank payment to your normal bank account but to Nominal code 1150 which should mean that this account should then be netted off.

https://ask.sage.co.uk/scripts/ask.cfg/php.exe/enduser/std_adp.php?p_faqid=46426
0 Comments

The Swap button in Sage 50!

30/10/2019

0 Comments

 
Whenever I visit a customer to do training I ask them if they know what the "Swap" button is that appears on all the menus.  Most people have no idea!  Basically it is designed so that if you select a single record (e.g. you select a customer in the list) or a couple of records, when you hit the swap button it reverses the highlights so that all the customers are highlighted except the ones you originally highlighted.  Therefore the highlights are swapped!!
0 Comments

Sage 200 Report Designer training

3/6/2019

0 Comments

 
We have recently been doing a lot of training on the Sage 200 report designer tool and have produced some really useful reports for monitoring sales by period, quarter, year etc.  If you are interested in training please contact us today on 020 8352 1504.
0 Comments

Sage upgrade for MTD

13/12/2018

0 Comments

 
If you are not sure about whether you have to upgrade your Sage software for the new VAT MTD regulations from April 2019 and want to discuss it please contact us today.  We can offer some alternatives to the costly upgrade.
0 Comments

How to change the default Signature from Outlook when emailing from Sage

13/12/2018

0 Comments

 
Did you know you can change the default signature that Outlook uses when emailing invoices directly from Sage? Click on Settings, E-mail defaults and on the invoice tab and select the signature required in the "Override default Outlook signature" box. When you click OK it will then ask you which layout you wish to change. Select the layout you use to send invoices and click Save. Next time you email an invoice from Sage it will use this signature.
0 Comments

Crystal Reports from Acolaid and Uniform

26/2/2018

0 Comments

 
We have recently finished a project writing Crystal Reports for North Herts District Council's planning department linking to their new IDOX Uniform system.   We originally did training on Crystal Reports linking to their Acolaid system and these reports needed to be transferred to the new system.

We are therefore quite familiar with the database structures for both of these products.  If you need training on Crystal Reports linking to either of these products or would like us to write the reports for you, please get in touch at info@japeconsulting.co.uk
0 Comments

Christmas card emails from Sage 50

14/11/2017

0 Comments

 
​It's that time of year again.  I have been asked recently by some of my customers how to send email christmas cards from Sage, so here is a quick guide:

1. Click on Customers or Suppliers
2. Select the records you want to send them to, or click Swap to select all
3. Click on File, Microsoft Integration, Contents to Microsoft Word, New Document
4. This will open up Microsoft Word
5. You then need to type the email message you want to send.  If you want the persons name to be included at the top you can click on Insert Merge Field and select the field <<Contact Name>> and this will enter the name of the person in the Contact name field in Sage.
6. Click on Finish and Merge, send Email messages
     - In the To box, select EMAIL
     - In the subject box, type the subject you want the email to have
     - In the mail format, select Plain text
     - Select All.  Note: it is a good idea to do a test first, so if you just select Current Record it will send it to
        the first record in the list.
     - Click OK.  This will send them automatically from Microsoft outlook.

Good luck and Merry Xmas!
Picture
0 Comments

Looking to upgrade your Sage 50 software?

2/8/2017

0 Comments

 
If you are on an old version of Sage 50  (prior to Sage 50 2015), Sage are offering a good offer this August for upgrades.  The cost is between £100 - £400 + VAT depending on what suite and number of users/companies you have.  If you upgrade with us we can give you a free online training session one-to-one with an Accredited Sage trainer to go through the new features that have appeared since your current version.  Call us on 020 8352 1504 or email info@japeconsulting.co.uk.
0 Comments

Crystal Reports - How to easily swap or replace a field

11/7/2017

1 Comment

 
I have done a lot of work recently for a customer which involved replacing specific fields within a Crystal Reports.  In doing so, I have made use of the really useful 'swap' feature.  If you hold down the shift key and drag a field from the Field Explorer over the top of another field, it totally replaces it but retains all the formatting of the original field.  Very useful time saving feature.
1 Comment
<<Previous

    Author

    Jackie Kashman

    Archives

    December 2020
    May 2020
    October 2019
    June 2019
    December 2018
    February 2018
    November 2017
    August 2017
    July 2017
    May 2017
    April 2017
    January 2017
    September 2016
    July 2016

    Categories

    All
    Crystal Reports
    Sage200
    Sage 50

Email

Telephone

info@japeconsulting.co.uk
+44 (0)20 8352 1504
Jape Consulting Ltd, Registered in England & Wales No. 4371339
  • About Us
  • Sage
    • Sage Training Courses >
      • Sage 50 Accounts Training
      • Sage Training Online
      • Sage Payroll Training Courses
      • Sage Report Designer Training Courses
      • Sage 200 Report Designer course
      • Sage HR Training Courses
    • Sage Consultancy >
      • Sage Report Design Service
      • Sage Layouts and Templates
      • Sage 50 Commercial Invoice
      • Sage Support
      • Sage Data Export
    • Sage Software
  • Crystal Reports
    • Crystal Reports Training >
      • Introduction to Crystal Reports Training Course
      • Advanced Crystal Reports Training Course
    • Crystal Reports Online Training Courses
    • Crystal Reports Consultancy & report development
    • Crystal Reports Support
    • Crystal Reports Access Dimensions
    • SAP Business One Crystal Reports
  • Contact
  • Blog