• Transition from TASBooks to Sage 50
    Easy with the Right Partner and Remarkably Beneficial
  • Transition from TASBooks to Sage 50

KB Category: ARW (Advanced Report Writer)

ARW Report – Payroll Submission Report by Pay Method

Written by Pimbrook Support on .

 

ARW Report – Payroll Submission Report by Pay Method

 

To download and install the payroll submission report as follows:

1. Locate where you need to save the payroll files by clicking on Help – System Information in your payroll

2. Click on the Data Directory.  This will open the file location where you need to save the ARW reports.

 

 

3. Click here to download the ARW files.

4. Unzip the files and save to the above location within your company file

5. Save the 2 files (PSRPM.ARW and PSRPM.ARP) into the data directory.

6. When you log into your ARW your report is now available to run.

 

If you are not using the ARW feature and require training please contact us on 051-395900 and we can arrange this.

 

 

When opening Advanced Report Writer (ARW) an error appears: Error: ‘Data Source Error Filling Lattice’ or ‘Cannot Read User File’

Written by Pimbrook Support on .

When opening Advanced Report Writer (ARW) an error appears: Error: ‘Data Source Error Filling Lattice’ or ‘Cannot Read User File’

 

These errors can appear when you try to open the ARW (Advanced Report Writer) if the computer you are running the ARW on does not have the required ODBC driver installed on it.

“Data Source Error Filling Lattice: The Company data could not be accessed Data Source Name not found and no default driver specified”

“Cannot Read User File – Please ensure that ODBC is installed”

To Fix this issue:

1. Close out of Sage Payroll (Micropay) and any other Sage applications on the computer you’re trying to run ARW on.

2. Download the ODBC driver from our website or click here.  Depending on your Internet browser, the file automatically download to your Downloads folder or you will be asked to save the file, take note of where the file is saved to, for example, the Windows desktop & Save.

3. Open the folder where you saved the download file and double-click ODBC driver.msi and click Run.

4. When the ODBC Driver Setup window appears, click Next and follow the on-screen prompts to complete the installation.

5. Log back into ARW from your desktop & the issue should be corrected.