Year end troubleshooting guide

Open batches message when trying to run year end

You might get messages as below about open batches.

• Open batches containing serialised items have been found when running the Count Inventory
• The year end procedure will not run if you have any open batches

Ensure all open batches have been updated. Refer to the step above "Update open batches and place documents on hold" for assistance with open batches.

There might be open batches for users that have been deleted. You will need to recreate these users so you can see the open batch under Open Batches screen. When you go to View...Open Batches, you will get message as below. Click Yes, for the batch to be copied to current user. 

Once the batches has been copied you can access these and update or delete the batch. 

 CAUTION: If you delete batch for documents e.g. tax invoice, you still need to update the documents batch to clear the open batch message. 

Deleting batch files from the company folder

If you still get the error you can delete open batch files for cash book batches, journal batches and inventory journal batches from the company folder as per steps below.

1. Press the Windows and E keys found on your keyboard simultaneously
2. Double click on the company folder to display the data fi les
3. Look for the following fi les in your company, right click and delete them (where XXX represent the user number)
   1. ACCBTN.XXX
   2. ACCBSJ.XXX

For POS open batches, ensure all open batches have been updated. Refer to the step above "Update open batches and place documents on hold" for assistance with open batches. If you still get error, there might be POS documents that are on hold or COD. To update documents that are On Hold and COD transactions do the following:

1. Click on View…Batch Listing to check for documents that are on hold or COD
2. If the user does not have access to the View menu, give user access to be POS Supervisor temporarily as illustrated below.
   
    CAUTION: Please ensure you deselect this after updating the POS open batches for the user.
   
   
3. Select Tax Invoice on Document Type when viewing the Batch Listing report
4. The report will show which tax invoices are on hold or COD and for which customer as illustrated below.

Follow steps below to access POS COD or On Hold transaction and update it.

1. Log into POS as the user that processed the COD or On Hold transaction. Once in the program, go to Process…Point of Sale, if you are not taken to the processing screen automatically.
2. Click on the Edit button.
3. Select the document type that you would like to edit from the Search Types drop down list. A list of invoices will display. Click on the invoice and click on Select.
   
    CAUTION: 

    

   If the documents do not show after clicking Edit, close the Search screen, click on <F9> On Account, select customer account with on hold or COD document as per report above and the click Edit. If there is more than one customer you will need to do this for each customer account. 
   
   
4. The invoice will display on your screen. Deselect the option On Hold or Cash On Delivery by clicking on the Place on Hold or Cash on Delivery tab. You can then complete the transaction and print if required.
5. Then go to Process...Update all Batches. Click on Start and all the invoices will be updated and will not show on the Open batches screen.
6. The documents should now show. You can also change the document type from On Hold to COD. You can the take the document off hold or off COD and update the documents as per above steps.

If the error persists it could be due to corruption in the General Ledger Parameter file. The errors can be fixed via Data Fix. The Data Fix can be done by a Certified Pastel Dealer that specialize in data fixing or Log a ticket with support for assistance to upload the data for a Data Fix.

Data Integrity Errors

When running the Data Integrity, you may receive an error report showing errors e.g Verify Balances and Transactions.

If you get the error that there are missing accounts as shown, you will need to recreate the missing customer, supplier or general ledger accounts.  After having created the account, run the data integrity again because, the process was stopped when the missing accounts were detected.

The errors can be fixed via Data Fix. The Data Fix can be done by a Certified Pastel Dealer that specialise in data fixing or Log a ticket with support for assistance to upload the data for a Data Fix.

Runtime error 6149 or runtime error -2147417848(80010108) when creating Period 13 under Setup Periods

These errors sometimes occur when the dates for the periods are selected from the calendar. You can try entering the dates manually, i.e., typing them in physically, instead of selecting the date from the drop-down calendar.

If the error persists it could be due to corruption in the General Ledger Parameter file. The errors can be fixed via Data Fix. The Data Fix can be done by a Certified Pastel Dealer that specialise in data fixing or Log a ticket with support for assistance to upload the data for a Data Fix.

Financial periods are not compatible with the Tax Manager when trying to setup 13th period

Changes made to the financial periods are not compatible with the Tax Manager when trying to setup 13th period

Should you wish to change your Financial Year and getting the below error when you are busy changing your periods you would need to Log a ticket with support for assistance as the solution will differ for each company.

Runtime Error 53

This error will occur when running the Year End over a network or there are missing files needed to run the Year End.

 NOTE: Make sure you run the Year End for the server machine. 

To check if the company is accessed locally:

• Select File...Open, the Open a Company screen will display
• Select the Company ensure it is highlighted in blue, at the bottom of the screen verify the company path, this should point to local path e.g.

   

  C:\Pastel19
  

If you are running the year end on the server and the error occurs then, please follow the steps below.

Create a copy and run year end on the copy company. To create a copy company, please follow the steps below.

1. Go to File...New
2. Click on the option Copy Another Company in the Method block.
3. In the New Company Name field provide the copy company with an appropriate name. Remember this copy company will be the new company that is normally created when going through the year end process. Therefore please give the file an appropriate name that represents the new financial year. Please find example below illustrating the options that should be selected.
   
4. Click the Create button to create the company. The system creates the new folder and copies the company data from the original company.
5. Once the copy (new) company has been made. Please go through the year end process again in the copy (new) company. On the Copy the Company to Another Company screen, please select the option Do not create a new company option as shown in the example below.
   

Runtime Error 70 and Runtime Error 75

These errors occur when something is blocking the Year End process.

• Ensure the user is a Windows Administrator
• Ensure that the Year End is run on the Server
• Make sure the company is sitting directly to the Pastel folder
• Remove the read only attributes from the company and Pastel folder
• Ensure all POS users are logged out of the company and POS is closed on all machines

To check if the company is accessed locally:

• Select File > Open, the Open a Company screen will display
• Select the Company ensure it is highlighted in blue, at the bottom of the screen verify the company path, this should point to C: Pastel17/18/ Xpress17/18

Permissions on the Company folder:

• Press the Windows and E keys found on your keyboard simultaneously
• Double click on the C: Drive
• Double click on the Sage Pastel Xpress/ Partner folder

• Right click on the company folder and select the option Properties. Ensure the Attributes are removed

• Select the Security tab on top, select each Group or user name under Group or user name, ensure the Permission is set to Full Control
• Should you still receive the error message, you can add a user Everyone
  • Select Add, type in Everyone, select OK
  • Ensure Full Control is selected
  • Select Apply and OK

Full Control added to the Pastel folder:

• Press the Windows and E keys simultaneously, browse to the Pastel folder

• Right click on the Pastel17/18/Xpress17/18 folder, select the option Share With > Specific People

• Type in Everyone, select Add
• Change the Permission Level for Everyone to Read/Write by selecting the drop down

• Select Share and then Done to complete the process

Runtime Error 5 When Opening a Company

This error occurs when the company folder name exceeds 8 characters or there is a special character in the company folder name

To check the Company Folder Name:

• Select File > Open, the ‘Open a Company’ screen will display, search for your company and look at the name in brackets, this is the folder name, this folder should not have more than 8 characters or any special characters

Correcting the company folder:

• Select File > Open > Manage, select the company
• Select Remove Company and close Pastel
• Press the Windows and E keys found on your keyboard simultaneously

• Double click on the Xpress17/18/Pastel 17/18 folder
• Right click on the company folder, select Rename, remove the special character or reduce the number of characters.

• Open Sage Pastel Xpress/ Partner
• Select File > Open > Add Company
• Select Add Company again, browse for your company
• Double click and select OK
• Select Close, log into your company and run the Year End

Runtime Error 6

Please follow the steps below to resolve the error

Rebuild the ACCTRN.DAT, ACCMAS.DAT and ACCOI.DAT files through the Rebuild Utility.

Refer to article How do I rebuild a Btrieve file using the Rebuild Utility on how to 

If the error persists after the rebuild, please run a Data Integrity test

• Go to File and select Data Integrity
• Select Next
• Select Verify the Data Only
• Select Process

If there are any errors on the Data Integrity, the data needs to be fixed by our Data Fix team. Log a ticket with support, the turnaround time is 24 to 48 hours excluding weekends and holidays from the time the data is received.

NOTE: No processing can take place while our team is fixing the data. 

If there are no errors, please follow steps below

• Go to File > New
• Select Copy Another Company
• On the left-hand side ensure the company you want to copy is highlighted

• Type a name in the New Company Name field to provide a name for the copy company

NOTE: This Copy Company will be the ccompany that will be used to do the Year End. Please ensure this folder name is appropriate for the new financial year. 

• Select Create, to create the company
• Select File > Open
• Select the copy company (example: NEW19) to open
• Select Change > Year End > Next
• Select Do not create a new ccompany
• Select Next > Process to complete the Year End 

Incorrect financial periods 

You need to restore backup that was done before processing the year end and process year end again.

Follow the steps below to restore backup.

1. Log into your company on Sage Pastel Accounting
2. Select File...Restore menu option to restore data
3. Sage Pastel will automatically pick up any backup that has been created on the computer or on the external drives
   You will be able to select the most recent backup due to the date and time stamp visible on the backup. If the backup is not in a .zip folder, it will not be visible in the Backed Up Files column
   
4. Select the backup you wish to restore and ensure that the backup is highlighted in blue.
   
5. Click Process to confirm the operation.
6. You will receive a warning message if you are restoring from your local drive, click Yes to proceed with the restore process.
   
7. You will receive another warning message, advising you that you will be restoring live data, click OK to proceed.
   
8. Log back into the company and confirm that the necessary changes have been made to your data.

Errors detected on Data Integrity

You need to restore backup that was done before processing the year end and process year end again.

Follow the steps below to restore backup.

1. Log into your company on Sage Pastel Accounting
2. Select File...Restore menu option to restore data
3. Sage Pastel will automatically pick up any backup that has been created on the computer or on the external drives
   You will be able to select the most recent backup due to the date and time stamp visible on the backup. If the backup is not in a .zip folder, it will not be visible in the Backed Up Files column
   
4. Select the backup you wish to restore and ensure that the backup is highlighted in blue.
   
5. Click Process to confirm the operation.
6. You will receive a warning message if you are restoring from your local drive, click Yes to proceed with the restore process.
   
7. You will receive another warning message, advising you that you will be restoring live data, click OK to proceed.
   
8. Log back into the company and confirm that the necessary changes have been made to your data.

If there were no errors before running year end but errors are being detected after running year end again, Log a ticket with support for further assistance.

Year End ran in wrong company

This error normally occurs when the client select the option to create a new company and forget to tick the option to run the year end in the new company.

During the Year End process you have the options:

• Create a new company
• Do not create a new company 
• Run year end in the new company

If the Year End has been run in the incorrect company you have two options:

1. Restore the Year End Backup and run the Year End again ensuring you select the option 'Run Year End in the New Company'
2. You can change the company names around

Restore the Year End backup and re-run the Year End

1. Restore your Year End Backup
2. Re-process the Year End as per steps 2 on article Sage 50cloud Pastel Accounting Year End Guide

NOTE: Ensure you select the option to Run the Year End in the New company.

Change the Company Folder Names around

1. Select File> Open> Manage> Add company
2. Remove the companies where the Year End is wrong
3. Navigate to the company folders
4. Right click on the first company and select rename
5. Enter the name of the other company folder with an a at the end
6. Select the other company right click and select rename, rename it to the first company folder name
7. Go back to the first company and select rename remove the a
8. Open your Software and add the companies back

EXAMPLE: Company A is called Demo2019 Company B is called Demo2020. The Year End was run in company A but it should have been company B. You will need to rename Demo2019 to Demo2020 and Demo2020 to Demo2019.