SDS - LWA Secure File Transfer

SDS School District Software

Note: If the archive tab is not available you may either need to login as a user with the rights to see that data or you may need to enable archiving (speak with SDS tech support, Betty, Roger, Peter etc)

Reports are possible both via the SDS Office Program and through the VT320 terminal. The preferred method is through the Office Program

Start up the SDS Office Application

Click on Accounts Payable in the left pane
Choose Transaction Batch List with GST
Change the following options:

Open/Closed: Change to "C"
Batch Start: 1
Batch End: 999999

NOTE: Before running the report, make sure the checkbox next to the printer icon is NOT checked.

Run the report(just hit enter)
A preview pane now comes up. Make sure the columns are wide enough so that no numbers are cut-off. Choose export button(just to the right of the print button)
Choose Record Style(columns with spaces) as format
Choose disk file as destination
Select both options in number and date format dialog

This report creates a file for the current year only. To create reports for previous years, click on the archive tab on the left pane and choose the A/P section for each FY. Then follow the instructions as above.

Alternatively

A similar but less useful report can be created using the terminal:

This report should be done by the VT320 (SDS Telnet) terminal, other reports may be possible using the Office Assistant, consult the SDS tech support as they are quite helpful in this regard. If you are familiar with the report creation process, the two reports we are looking for are: ACINTHDR (going back 4 years) and ACVENXRF

To create these files:

In Windows, Start -> All Programs -> SDS VT320

After logging in (you'll need to login with each year's username in order to print out previous years), go to:

Accounting -> Reports -> User Defined - Data Bridge

Choose 1 Create ASCII File

Choose 1 - ASCII Delimited

Enter the report name ACINTHDR

Choose N

Hit F3

Now You'll have to choose which fields to include, include our required fields (Vendor ID, Invoice Date, Invoice #, Invoice Date, Invoice Amount, GST Amount, Batch No) and any other useful fields that you have (Description, Cheque No, PST Amount, PO No.)

You'll need to number the fields sequentially (1-?) and then you'll have to choose a field to sort by, just put a 1 in the sort column by Batch No.

Hit F3

Hit Enter

Now enter an Output Filename

Output the file by giving it a name (ie ./gstreport.txt), Choose Y for print file format, then choose 1 to create file. Follow the same steps for ACVENXRF giving it a filename of vendorlist.txt or similar.