How do I import budget transactions from Caselle Advantage?
Budgeting
If you're using Caselle Advantage, it's a budgeting and reporting tool that will help you plan and analyze your organization's working budget, you can use this routine to import budget transactions created in Caselle Advantage into Connect General Ledger. Once the budget transactions are imported, you can use the General Ledger budget routines to calculate annualized budget (13/YY), copy budget amounts to a single period, copy period budgets to next year budget, copy to projected budget, and modify year-to-date budgets to equal project budget.
For more information about Caselle Advantage, contact your Client Relationship Manager (CRM) at (800) 228-9851.
Before you get started
-
Before proceeding, back up the current files. Always make a back up of the database BEFORE running routines that modify or delete transactions. See the help topic titled How do I back up the database?
Importing budget transactions from Caselle Advantage
1. Open Connect General Ledger > Budgeting > Import from Caselle Advantage.
What if I can't click on the link to Import from Caselle Advantage? Contact your IT Admin or Application Admin to verify that you have user rights to import budget transactions. For more information, see the help topic How do I assign user rights?
2. Fill in the following fields.
3. Click GO (CTRL+G).
The budget transactions are imported to the selected budgeting journal.
2019.05, 2019Feb27
Setting the default configuration file and data set
Clicking Options (F12) will show the default configuration file and data set for accessing Caselle Advantage.
Error: Cannot Run Process
This error displays when
the name of the configuration file that is saved in the Options form does not match the name of the configuration file in Caselle Advantage, or
a data set is not selected in the Options form. Usually, FIN is the default setting.
Troubleshooting
Check if the configuration file name matches the name on the Caselle Advantage configuration file.
Make sure a data set is selected.
Options
Journal code
Select the destination journal code to post the imported transactions.
Budget level
Select the destination budget level to post the imported transactions.
Transaction description
Enter a transaction description to identify the imported transactions.
Caselle Advantage budget name
Select the budget name of the budget that you want to import from Caselle Advantage.
Caselle Advantage fiscal year
Select the fiscal year of the budget that you want to import from Caselle Advantage.
Load annual budget
Summarize the monthly budget transactions from Caselle Advantage and post the total to the selected GL period. Using this option will create one a budget transaction for each record in the import file.
You'll need to select the option to Load Annual Budget and then select the destination GL period.
2019.05
Load to GL period
If you select Load Annual Budget, select the GL period to post the annual budget from the Load to GL Period drop-down list.
Load individual period
Post the monthly budget amount to each GL period (1-12). Use the Amount 1-12 fields to select the GL period to post the individual budget amount.
Note: This option will not include the zero period, Period 13, or Period 14.
You'll need to select the option to Load Individual Period and then map each individual amount in the selected period to the selected period in the fiscal year. The Amount 1-12 drop-down list will
show periods that fall in the fiscal year and the future year as long as you have set up future periods in the General Ledger application.
not show closed periods.
When you click GO, the routine will create a budget transactions for each record from the import file.
2019.05
Warning Message: Budget Already Exists
This warning message displays when there are budget transactions in the selected period or periods. Connect checks for budget transactions with a period date that matches at least one of the selected periods for the selected journal code.
If you click Yes, you may create duplicate records. If you click No, the selected transactions will not be imported.
Copyright © 2025 Caselle, Incorporated. All rights reserved.