Re: Help, please: AP Import Error: Transaction Distribution Must Be Fully Distributed

Chandra Hudson

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?

Alex Wong

@Chandra Hudson
can you share your import file?

Kevin Brazell

@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.

Chandra Hudson

@Alex Wong
FinancialEdge-AP_Atl Brand 083023 Inv 5926.CSV

Chandra Hudson

FinancialEdge-AP_Atl Brand 083023 Inv 5926.CSV@Alex Wong

Chandra Hudson

FinancialEdge-AP_Atl Brand 083023 Inv 5927.CSV@Alex Wong

Chandra Hudson

@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.

Chandra Hudson

@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.

Alex Wong

@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.

Chandra Hudson

@Alex Wong

Every field on my import file is accounted for in the import parameters section in FE database view. So, why the error?

Chandra Hudson

@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.