The budget transaction interface program creates budget file transactions from an external source. (i.e. spreadsheet)
BPS-Interface > Budget Transaction Interface Profile > Add, Change, Delete
Format name ________________________________________
-
Enter a name for the budget transaction interface profile
Fixed/Delimited format [D/F]
-
Choose D for delimited (Tab or Comma), choose F for fixed format
Record Length
-
Enter the total number of characters (length) of each record in the interface. This is a summation of all the fields lengths., Only applicable to fixed record format.
GL Account Code (Max=20)
-
For delimited formats, enter the number that refers to the column (from spreadsheet program A=1, B=2, C=3, etc)
-
For fixed format, enter the starting position and length of the GL code within the transaction record
Transaction Type (Max= 1)
-
For delimited formats, enter the number that refers to the column (from spreadsheet program A=1, B=2, C=3, etc)
-
For fixed format, enter the starting position and length of the transaction type data within the transaction record
-
Transaction type can be B (base), I (increase), D delete), N (new)
Unit Qty (Max=10)
-
For delimited formats, enter the number that refers to the column (from spreadsheet program A=1, B=2, C=3, etc)
-
For fixed format, enter the starting position and length of the unit qty data within the transaction record
Unit Price (Max=10)
-
For delimited formats, enter the number that refers to the column (from spreadsheet program A=1, B=2, C=3, etc)
-
For fixed format, enter the starting position and length of the unit price data within the transaction record
Amount (Max=12)
-
For delimited formats, enter the number that refers to the column (from spreadsheet program A=1, B=2, C=3, etc)
-
For fixed format, enter the starting position and length of the amount data within the transaction record
-
Do not apply currency formatting
Reference Data (Max=1050)
-
For delimited formats, enter the number that refers to the column (from spreadsheet program A=1, B=2, C=3, etc)
-
For fixed format, enter the starting position and length of the reference data within the transaction record
Budget Transaction Upload from Text File
Check the Interface Profile for your Excel spreadsheet setup.
Budget Transaction Interface Profile
Once you have run the Budget Position Control Report and are happy with the Positions FTE and Salary.
Run the Create Transactions from Positions to create the salary and benefit costs which will create batch BP4.
The combination of BP4 batch, and your previously interface Services and Supply batches, will create the budget dollars.