Control Parameters

There are six that need to be set in the Data Transfer Parameter Type.

ParameterName	ParameterValue	Description
ServerTransferDirectory. (This is the first step in the file creation process)	E.g.: \\Sql\Transfer\Transfer	The directory, relative to the SQL Server machine itself, where transfer files will be created by stored procedure based exports. UNC Pathing should be used as the second part of the transfer takes it from this SQL related directory. Workbench is doing this second step and can only find the directory using UNC pathing. If you use the Map drive relative to the SQL Server (e.g. C:) Workbench cannot find the directory when doing the second step. Note:- Make sure there are no spaces in the directory name or this wont work. SQL doesn't cope with spaces.
TransferDirectory. (This is the second step in the file creation process)	E.g.: T:\Workbench\Transfer or \\Fp01\t\Workbench\Transfer	The directory where transfer files will end up when created by stored procedure based exports. UNC Pathing should be used but it does not have to be.
MYOB Job Field	Null, Profit Centre, PC Job Suffix or Job	This controls what 'Job' we pass to MYOB. Where Null then Job Field = Null Where 'Profit Centre' then Job Field = Job's Profit Centre on the Transactions line Where 'PC Job Suffix' then Job Field = Job Suffix from the Job's Profit Centre on the Transactions line Where 'Job' then Job Field = Job on the Transaction line
MYOB Description Field in AP	E.g. <JTD>;<JC>;<JD>;<WC>;<AC>	There are 5 possibilities of data to go into the MYOB Description field in AP. They would appear in order of the Control Parameter. Any or all of the following 2-3 letter codes enclosed in <> and separated by semi colons: JTD (JobTransaction.Details), JC (Job Code), JD (Job Description), WC (Work Centre), AC (Activity Centre)
MYOB Description Field in AR	E.g.:<JC>;<JD>;<SC>;<SCD>;<ILD>	There are 5 possibilities of data to go into the MYOB Description field in AR. They would appear in order of the Control Parameter. Any or all of the following 2-3 letter codes enclosed in <> and separated by semi colons: JC (Job Code), JD (Job Description), SC (Sales Code), SCD (Sales Code Description), ILD (Invoice Line Description)
MYOB Journal Memo Field in AR	Eg: <JD>;<JIT>;<JID>	There are 3 possibilities of data to go into the MYOB Journal Memo field in AR. They would appear in order of the Control Parameter. Any or all of the following 2-3 letter codes enclosed in <> and separated by semi colons: JD (Job Description), JIT (Job Invoice Title), JID (Job Invoice Details)
Display AR GST Type	Must be Yes	The GST Type defaults from the Sales Code. Where the Sales Code selected does not have a GST Type an error is displayed for you to select a different Sales Code. The GST Type is displayed on the Form.
Display AP GST Type	Must be Yes	The GST Type defaults from the Activity Code. This can be changed on transaction entry.

Through Batch export Workbench creates a TXT file and places it into the TransferDirectory. You then go into MYOB and import the TXT file.

Difficulties in the Workbench Export normally relate to issues around the ServerTransferDirectory and the TransferDirectory and the rights that the user has to create the .TXT file.

(The ServerTransferDirectory is where SQL deposits the file. Pathing must be known to the SQL Server. UNC pathing works. Note:- Make sure there are no spaces in the directory name or this wont work. SQL doesn't cope with spaces.

Workbench then shifts the file from the ServerTransferDirectory to the TransferDirectory. Pathing of both directories must be known to Workbench. UNC pathing works)