Ensuring Account Lookup receives data from the scheduled download

Click Start and type Task Scheduler and press ENTER. The Task Scheduler opens.

Check the location

Check that the Scheduled Task IRDAccountLookUpService is set up to run on the SQL Server - the same server where the VizPost background task runs.

Check the settings

Review the following in the IRDAccountLookUpService Scheduled Task:

Open the \SOL64 folder, open the configuration files and review the following: 

InstalledTaxDatabases.IRD

This file uses UNC paths, ensure there are no mapped drives.  For example:
     Name~Location~DBLocn
     SQLTAX\TAXFILE~\\SERVER01\myob\Sol64~S6:\\SQLSERVER\MSSQL\SQLTAX\TAXFILE

Check that the server name(s) are correct.

In the above example, the \SOL64 folder is located on server SERVER01, whereas TAXFILE is on the server SQLSERVER.  In other cases, both the SOL64 and TAXFILE may be on the same server.

ScheduleSettings.IRD

     15/06/2011 7:22:00 a.m.
     Daily
     [Admin user]
     [encrypted password]
     [Domain]
If the above details are incorrect, you may need to modify the Scheduled Task and .IRD files by running the Account Lookup Scheduler in \SOL64\SETUP, re-enter the correct Admin User credentials, and click OK.  Once you have modified the Scheduled Task, re-check the parameters in this file. 

TaxDatabases.IRD

Ensure the content of this file is Default.

1. Rename old IRD files in \SOL64\FILES\SQLTAX\TAXFILE\ALOOKUP, ie. Accountsxxx.IRD, Transactionsxxx.IRD, IRDAccountLookUpLog.txt.
2. Open Task Manager, select Processes tab. The Processes are listed sorted by Name alphabetically.
3. Open Task Scheduler and run the IRDAccountLookUpService Scheduled Task.   In the Task Manager Processes list, you see the IRDAcccountCodeLookUp.Controller.EXE appear and run.| The System Services window opens up, automatically logs in, then closes.   Then the Tax Tracking window opens up, automatically logs in, then close. Also in the \ALOOKUP folder, a new log file ALULog.txt is created.
4. Open the ALULog.txt file with Notepad. You should see the following section:
       ----------------------------------------
        General Information: 0 : Timestamp: 28/05/2013 4:52:16 p.m.
        Message: making service call...
   This indicates that Controller.EXE is contacting the IRD server. After a few minutes, a couple of files appear in the \ALOOKUP folder Accounts[xxxx].IRD, Transactions[xxxx].IRD; then a couple of .IDX files appear, _[alphanumeric].IRD.
   The System release window opens again, and in the centre of the window shows the transactions being processed.
   Once this is completed, the window opens and closes multiple times, where the system is checking and reconciling individual client info with the IRD server.
5. Review the log file ALULog.txt.

Error messages in the ALULog.text file

Some possible error messages in the log file are:

Error	Solution
"The request channel timed out while waiting for a reply after 00:05:00."	This is a communications error, where the IRD server has not responded in the time required. This may be because the IRD servers are busy – particularly if run during business hours. Check that the Scheduled Task is set to run from  5:00am onwards for example.
“Server returned an invalid SOAP Fault.”	This is a communications error, where the IRD server has not responded in the time required. This may be because the IRD servers are busy – particularly if run during business hours. Check that the Scheduled Task is set to run from  5:00am onwards for example.
“There was no endpoint listening at https://b2b.ird.govt.nz/Enquiry.”	This usually indicates no communication was possible with the IRD system – often because a proxy server was not allowing communication out.  To check Proxy Server settings Open Control Panel and select Internet Options. Click the Connections tab.  Click LAN settings; if Use a proxy server is selected, click the Advanced button, and add the address b2b.ird.govt.nz into the Exceptions field. Click OK on all windows to close.
“LoginFailed”	One of the IRD Online Services usernames and/or logins as held in MYOBAO Classic is incorrect. Verify ALL Usernames and passwords by going to IRD’s website www.ird.govt.nz, and try logging into Online Services using the usernames and passwords supplied.  This may be the main Username & Password held in Tools > Options..., select Tax tab and then Account Lookup sub-tab, click IRD Login Settings button; or if Allow separate agency details for staff is ticked on the Tax Returns sub-tab, then go to Employees tab, select an employee and then select Agents sub-tab and check Username & Passwords held in Account Lookup login details section.
“Insufficient permissions for setting the configuration section 'defaultProxy'.”	Check the file \SOL64\IRDAccountCodeLookUp.Controller.exe.config – does it contain the following section?:      <system.net>                <defaultProxy useDefaultCredentials="true">                </defaultProxy>           </system.net> If so, make a copy of the .CONFIG file as IRDAccountCodeLookUp.Controller.exe. Config.OLD. This is so you can undo the changes if required. Then remove the above section in the .config file and Save.  Then run the Scheduled Task again.