One invoice with 5 lines into FENXT - not sure how to set it up in Excel
Need help with importing one invoice into FENXT with 5 lines and not sure how to set it up in Excel, csv file. Can anyone help me with this? TY
Comments
-
@Jessica Coriz each invoice is a single row in Excel, so the fields for the lines on the invoice repeat in columns across the row as many times as you have rows up to 100., 5 times in your current invoice. Then when you map the fields in the import parameter, you just need to make sure that each column in a group (representing a single line in the invoice) all have the same extension number in the field mapping.
0 -
@Jessica Coriz
Here is the KB with examples and sample file : KB for importing invoice with distributions . Denis is correct where you'd put all the data into a single row. If you have 5 distribution lines, you'll be using 5 sets of columns for your expense account(s), project(s) etc. The file in the KB illustrates the format using an invoice with 2 lines. You'd just add 3 more sets to it and use that to import.0 -
@ Kevin Brazell Very helpful. But where would the description go for each line entry? Thank you for help!
0 -
@Denise Appelgren Very helpful. But where would the description go for each line entry? Thank you for help!
0 -
@Jessica Coriz there is a description field for import for the line items called line item descriptions. you'd map one per line.
0 -
@Kevin Brazell Can you tell me what column it should go after in the Excel spreadsheet, such as after the Project ID column?
0 -

@Jessica Coriz Here's a sample where the yellow highlighted cells represent the invoice header and the columns J-N would be the group of columns repeated for each line item on the invoice.
0 -
@Denise Appelgren But where would the line item description go? (in which column between J-N, I think I need to add a column between there for each line description). Each line will have a different description from the overall invoice. IE. Overall invoice would be April premium. One line item description would be Faculty, then another would be Admin, then another line description would be Philanthropy, then 4th line item description would be Facilities, last would be Adjustments. Each line has their own description, GL code and amount. TY
0 -
@Jessica Coriz when importing it can be any order, but I usually go to the fields tab of the import and go in order from top to bottom on all the fields I may use. Makes mapping easier.
0 -
@Jessica Coriz Sorry - yes - the line item description is in column L of the example. You would then repeat columns J-N for each line item, so each will have a unique description and distribution.
0 -
@Kevin Brazell Hi Kevin, not sure what you mean. Once I have the columns in order and save as a csv, I go to import in AP. Is this where you are mentioning your suggestion?
0 -
@Denise Appelgren I see it now. Let me try this and I might have more questions at the import stage. TY Denise
1 -
@Kevin Brazell
I tried importing this article as a TEST but it didn't work…time's out.0
Categories
- All Categories
- 6 Blackbaud Community Help
- 206 bbcon®
- 1.4K Blackbaud Altru®
- 394 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 357 Blackbaud eTapestry®
- 2.5K Blackbaud Financial Edge NXT®
- 646 Blackbaud Grantmaking™
- 561 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 934 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.4K Blackbaud Raiser's Edge NXT®
- 3.6K SKY Developer
- 242 ResearchPoint™
- 117 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 238 The Tap (Just for Fun)
- 33 Blackbaud Community Challenges
- 28 PowerUp Challenges
- 3 (Open) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 777 Community News
- 2.9K Jobs Board
- 53 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)

