Skip to content
logo Knowledgebase

Processing a year end - using SQL

Created on  | Last modified on 

Summary

How to run a year end when using SQL Point of Sale (POS) or Debtors Manager in Sage 50cloud Pastel.

Description

Modules affected when running year end.

  • POS using SQL
  • Debtors Manager using SQL

Resolution

Point of Sale (POS) SQL   

  1. Click Change and then Year End.
  2. Click Next and then Create a new company called.
  3. Insert the folder name and the financial year of before running the year end.
  4. Don't select Run the Year End in the new company and click Next.

    Create new company is selected showing the folder name and the year that will be last year. The option Run Year End in the new company is not selected.

  5. You will receive the message about the company creation, click Next.
  6. Screen reminding you about printing year end reports will show click Next.
  7. Screen summary about the year end process will show, click Next and then Process.

 NOTE: You will process in the company folder you have always used as you choose to run the year end in that company. 


Debtors Manager SQL

You will need to change the location of the database to point to the new company.

  1. Open Debtors Manager and open the company for last year.
  2. Click File and then Locate Pastel Company File.
  3. Click on Browse and then navigate to the new company folder.
  4. Double-click on the company folder and then click Refresh Data.