The BUDGET TRANSACTION INTERFACE module creates a batch of budget file transactions from an external source. (i.e. spreadsheet)
SELECT FORMAT #
Select the format desired (as created in the Interface Format module).
LOAD TRANSACTIONS INTO YEAR
Enter the year the transactions affect. The defaults presented are the CURRENT year from the BPS Master Profile. This is the year to which the transactions will be attached. If there is a year in the transaction file it will be ignored.
LOAD TRANSACTIONS INTO BUDGET ID
Enter the Budget ID the transactions affect. The default is ‘0‘.
LOAD TRANSACTIONS INTO BUDGET PHASE
Enter the Budget Phase the transactions affect. The default is ‘0‘.
ENTER DIRECTORY OF INTERFACE FILE
Enter the full directory name of the directory containing the file to be interfaced into BPS. This filename will be saved and appear as a default the next time you enter the module.
ENTER INTERFACE FILE NAME
Enter the actual name of the file to be interfaced into BPS. This file can either be a fixed length or delimited file. This filename will be saved and appear as a default the next time you enter the module. <FIND> displays a window containing the files in the directory entered above. You can then select the file you want.
PRELIMINARY/FINAL RUN
Enter 'P' or <CR> if this interface is a preliminary run. A preliminary interface will produce a report of the budget transactions without actually updating the BPS files. Check the .LOG file for any errors and correct before running the final.
Enter 'F' if this run is to be a final interface. A final interface will create a batch of budget file transactions in BPS. Any errors or rejections will be recorded in the .LOG file.
The following prompts will only display if ‘FINAL’ is selected for the ‘Preliminary/Final Run’ prompt.
ENTER BATCH CODE TO INTERFACE
Enter the BPS batch number to record these budget file transactions. This batch number supports alpha, numeric, or alphanumeric codes. This batch number will be saved and appear as a default the next time you enter the module.
ENTER DEFAULT TRANSACTION TYRP
Enter the transaction type to use whenever the input transaction has an invalid or no type code. 'B' (BUDGET BASE) will be presented as the default.
ENTER TRANSACTION DESCRIPTION
A transaction can be entered that will be applied to all transactions within the interface file. If a description has already been entered within the interface file, and is defined within the interface file, this description will not be used.
ENTER <CR> TO PRINT REPORT
The system will produce a report of the information contained in the interface file and, if a Final Run is requested, will update the BPS Transaction file with the interface data.