How to import budget data into GL?

Login to the application and select “Data Migration” module from application home page.

Data Migration home page will be displayed.

To import budget data into GL, select “GL Transaction” from “My Home” tab.

GL Transaction import page will be displayed.

In Upload a File section, select “Download” button to get an Excel Format Template.

Using the template downloaded, enter the following GL transaction details for budget data in the excel.

In ‘AcctgTransFeed’:

  1. acctgTransId: Enter the account gl transaction id in this format “byymmxyz”, where the letter “b” followed by year, then month, then a sequence number for the month
  2. acctgTransTypeId: Enter the account gl transaction type id as “BUDGET”. The word “BUDGET” should be capitalized.
  3. glFiscalTypeId: Enter the gl fiscal type id as “BUDGET”. The word “BUDGET” should be capitalized.
  4. transactionDate: Enter the transaction date in this format “yymmdd hh:mm:ss”.
  5. isPosted: Enter “Y” if it has to be posted else enter as “N”.
  6. postedDate: Enter the transaction date in this format “yymmdd hh:mm:ss”.
  7. description: Enter the description for Account gl Transaction
  8. inventoryItemId: Enter the inventory item id (if required).
  9. productid: Enter the product id (if required).

In ‘AcctgTransEntryFeed’:

  1. acctgTransId: Enter the account gl transaction id in this format “byymmxyz”, where the letter “b” followed by year, then month, then a sequence number for the month
  2. glAccountId: Enter gl Account Id.
  3. amount: Enter the amount.
  4. currencyUomId: Enter the currency uom id.
  5. debitCreditFlag: Enter “D” or “C” based on debit or credit transactions.
  6. acctgTransEntrySeqId: Enter the sequence id for account gl transaction entries.
  7. description: Enter the description for Account transaction entires.

After entering the details in the excel, save the data in your local system.

In ‘GL Transaction import page’,

  1. Select the file from the local system in “File to Import” field.
  2. Click on “Upload” button.

   3. Once uploaded, the status will be displayed in “Not Processed” for the uploaded file.

4. Select “Validate” button to validate the data.
5. Select “Import GL Transactions” button to import GL transaction data.

6. “OrganisationPartyId” and click on “Run Import” button.

7. The data will be imported and will be displayed in “Processed” status.

View Imported Transaction:

To view the transaction imported, select “Financials” module.

In Financials home page, select “Find Transaction” link from “Ledger” tab.

In Transactions page, find the transaction imported.

The transaction list will be displayed.

Select the transaction id imported from the to view the transaction details

The transaction page will be displayed as shown below:

View Comparative Income Statement:

To view comparative income statement, In Financials module select “Reports” tab.

In reports page, “Comparative Income Statement” link.

In Comparative Income Statement page, Enter the details and click on “Generate Reports” buttons.

The transaction details will be displayed as shown below:

Related Resources