Importing and combining g/l code segments from separate excel columns

We are going to be converting/importing data to FE. Our current actuals and budgets are in excel sheets. Each sheet is its own department (39 of them). In order to not re-key every account string, we would like to be able to insert a column in front of g/l code for fund, and after g/l code for department. Copy it down for entire spreadsheet. Then import to FE in segments and have FE combine to account string. fund-g/l code-department ie: 01-4500-9000

where 01 fund and 9000 department would be in the entire column of excel sheet and we would change for each department sheet.

  • Guest
  • May 11 2020
  • Already exists
  • Attach files
  • Julia Petit commented
    May 15, 2020 14:40

    Hi! Thanks so much for adding your idea here. To clarify the end goal, are you looking to be able to create various accounts within FE/FENXT based on a specific segment of your account number? If so, this is possible by going to database view > General Ledger > accounts > create multiple accounts.

    Attachments Open full size

Related ideas