Skip to content
logo Knowledgebase

How to run Year end if using Debtors Manager and SQL POS

Created on  | Last modified on 


In this article you will learn how to run a year end if you use SQL Debtors Manager and SQL Point of Sale in Sage 50cloud Pastel Accounting.


There are certain modules that are affected when the Year – End process is ran.



Pastel SQL POS   

  1. Select Change > Year End
  2. If you don’t have a backup, please select the option to make a backup
  3. Select Next
  4. Select Create a new company called, [insert the folder name with previous year digits] to know company is for which year.
  5. DO NOT select Run the Year End in the new company
  6. Select Next

  7. You will receive a message that the company has been created. Select Next until you get to Process, select Process to continue with the Year–End

You should then continue processing in the company you have been using as the year end would have been processed on that company. 

CAUTION: Do not process on the new company created. 


Debtors Manager

SQL Server as the database:

You will need to change the location of the database to point to the new company (this will use the database name you setup on the original company)

To change the location of the Database:

  1. Open Debtors Manager
  2. The data for last year will display open it
  3. Click on File > Locate Pastel Company File
  4. The Open a Pastel Company screen will display:  


  5. Click on Browse
  6. Navigate to the new company folder created after Year End
  7. Click on Refresh Data