Skip to content
logo Knowledgebase

Running year end when using POS and Debtors Manager SQL

Created on  | Last modified on 

Summary

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.

Description

There are certain modules that are affected when running the year end process.

Resolution

Point of Sale (POS) SQL   

  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.

    Image

  7. You will receive a message that the company has been created.
  8. Select Next until you get to Process.
  9. Select Process.

You must process in the same company as you always have done as the year end would have been run in this 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:  

    Image

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