Run the year end with SQL in Sage 50cloud Pastel
Description
Cause
Resolution

How this works

When you use POS or Debtors Manager with SQL, you can't run a standard year end. Instead, you:

  1. Create a new company to store the previous year's data.
  2. Run the year end in your current company (the one you always use).
  3. Point Debtors Manager to the new company.

Before you start

  1. Back up your company data. A year end permanently updates your data, and you can't reverse it. See Process a backup.
  2. Complete your year end preparation. See the year end preparation articles for the required steps.
  3. Print your year end reports.
  4. Decide on a name for the new company. Include the financial year in the name so you can identify it easily (for example, MyCompany2026).

Point of Sale (POS) SQL

  1. In Sage 50cloud Pastel, select Change, then Year End.

  2. Select Next.

  3. Select Create a new company called, then enter the folder name for the new company.

  4. Enter the financial year that's ending.

  5. Clear the Run the Year End in the new company checkbox.

    NOTE:

    Keep the checkbox clear. Sage 50cloud Pastel then runs the year end in your current company and copies last year's data. Select it, and the year end runs in the wrong company.

     

     

  6. Select Next to confirm the new company creation.
  7. Select Next at the report print reminder. Print your year end reports first if you haven't already.
  8. Select Next at the process summary.
  9. Select Process.

Sage 50cloud Pastel runs the year end in your current company. You continue working in this company for the new financial year. The new company holds your previous year's data.


Debtors Manager SQL

Connect Debtors Manager to the new company.

  1. Open Debtors Manager.
  2. Open the company for last year.
  3. Select File, then Locate Pastel Company File.
  4. Select Browse, and go to the new company folder.
  5. Double-click the new company folder.
  6. Select Refresh Data.
Steps to duplicate
Related Solutions