Re: Help, please: AP Import Error: Transaction Distribution Must Be Fully Distributed
Hi,
I have attempted numerous times to do an AP Interface Invoice import in the database view. I keep receiving the error message:
“Transaction Distribution Must Be Fully Distributed.”
However, my csv file is showing that the transaction has been fully distributed. I put a ticket in through BB support, but am not very confident they can help. Any ideas on how to fix this?
Comments
-
@Chandra Hudson
can you share your import file?0 -
@Chandra Hudson
Usually this means once you're in the mapping stage of the import parameter ( assuming of course the actual amounts from total of the invoice and the account / project fields match) Make sure to map all the fields for the distribution. Example If you use both account and projects in the distribution : you'll need the account amount field for the debit of the expense, and since there is a project, you'll need to pull the project id fields and it's corresponding amount / percent. If you leave the extra project amounts off, FE doesn't know what to do with that amount and gives that error. Any time you see that error anywhere in FE, it's almost always an issue with FE not knowing what to do with the breakout to accounts/projects. So I would make sure the amounts do match on the total for the invoice vs all the accounts and or projects. Then I'd go to the fields tab of the import parameter and make sure the mapping of the fields is correct. If you're using more than one project / account then that is doubly important as you now have to account for the third column , extensions, where it starts with 00 -99. That's how FE keeps duplicated accounts grouped together and matches the correct data to the correct set of columns when importing.0 -
@Alex Wong
Hi, I attached the file above. The amounts match. I was just about to check to make sure import parameters to make sure all fields are accounted for.0 -
@Alex Wong I was just about to check the import parameters to make sure all fields are accounted for, according to my import file. Another problem I frequently have is our vendor numbers sometimes have leading zeroes and the CSV file drops the leading zero upon attempting to upload. So, now the vendor ID# does not match, and should match, in the inventory and accounting system.
0 -
@Chandra Hudson
I think Kevin has laid out all the info for you, so take note of that. Looking at your csv, I think you are missing a lot of column of data for importing.0 -
@Alex Wong
Every field on my import file is accounted for in the import parameters section in FE database view. So, why the error?
0 -
@Alex Wong
This is all the data we require. We're just importing simple invoices. I last used the file successfully last month. Nothing has changed, except now, I am receiving the error message.0
Categories
- All Categories
- 6 Blackbaud Community Help
- 211 bbcon®
- 1.4K Blackbaud Altru®
- 402 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 360 Blackbaud eTapestry®
- 2.6K Blackbaud Financial Edge NXT®
- 655 Blackbaud Grantmaking™
- 576 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 941 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.7K Blackbaud Raiser's Edge NXT®
- 3.7K SKY Developer
- 248 ResearchPoint™
- 120 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 240 Member Lounge (Just for Fun)
- 34 Blackbaud Community Challenges
- 37 PowerUp Challenges
- 3 (Open) PowerUp Challenge: Grid View Batch
- 3 (Closed) PowerUp Challenge: Chat for Blackbaud AI
- 3 (Closed) PowerUp Challenge: Data Health
- 3 (Closed) 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
- 796 Community News
- 3K Jobs Board
- 54 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)

