Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / "THE TRANSACTION ...
Microsoft Dynamics GP (Archived)

"THE TRANSACTION AMOUNT IS NOT FULLY DISTRIBUTED" error in bank transaction integration- checks (to input vendor checks)

(0) ShareShare
ReportReport
Posted on by Barbara Salazar 1,415

I developed Integration of Bank Transactions- Checks (i.e. vendor checks inputted through Bank Transaction Entry window for specific checkbook ID.

Integration does not work. It gives 11 errors with message, each "THE TRANSACTION AMOUNT IS NOT FULLY DISTRIBUTED". Could you please give detailed instructions how to fix?

This is how I did integration:

1)     It has 2 sources for header & line/distribution which are 2 identical Excel files with different names. Files have 1st column with different numbers by which I linked them in Query Relationship.

2)     Destination mapping is as follows:

a.     “Amount” in Bank Transaction entry is equal to “Debit Amount” in Distribution window- both are linked to source file. “Credit Amount” in Distribution window is set as “Use Default”.

b.     Account number is linked to source file column with debited account number (I assumed that the Integration will credit account linked to checkbook ID automatically.

 

*This post is locked for comments

  • sueconrod Profile Picture
    sueconrod 335 on at
    Re: "THE TRANSACTION AMOUNT IS NOT FULLY DISTRIBUTED" error in bank transaction integration- checks (to input vendor checks)

    These are the columns I have:

    Checkbook ID Paid ToRcvd From GL Posting Date Checkbook Amount CM Trx Number Account

    Both header and detail are the same:  the relationship is the CM Trx Number (Check).  And I use a tab delimited upload.  

    I've never had a problem uploading.  

    Sue

  • Barbara Salazar Profile Picture
    Barbara Salazar 1,415 on at
    Re: "THE TRANSACTION AMOUNT IS NOT FULLY DISTRIBUTED" error in bank transaction integration- checks (to input vendor checks)

    Thank you very much, Susan!

    I did everything as you described & I'm getting "THE TRANSACTION AMOUNT IS NOT FULLY DISTRIBUTED" error.

    My Excel integration file has multiple rows. Should debit amount & checkbook amount for each row be equal? (This is how I currently have them). For example,

    debit amount  checkbook amount

    5.22                  5.22

    10.01              10.01

    11.12               11.12

  • Suggested answer
    sueconrod Profile Picture
    sueconrod 335 on at
    Re: "THE TRANSACTION AMOUNT IS NOT FULLY DISTRIBUTED" error in bank transaction integration- checks (to input vendor checks)

    I do this all the time to bring in Outstanding checks and you are right, you only have to give it the db amount in the distribution because the credit side defaults automatically.  Just went back through mine and here it is.

    Distributions:

    Accounting Number:  Account for Db

    Debit Amount:  Checkbook Amount

    Credit Amount:  Default

    Origination Debit:  Default

    Originating Cr:  Default

    Distribution Ref:  Use source

    Bank Trx Entry:

    Option:  Use constant Enter Transacation

    Type:  Use Constant:  Check

    Checkbook:  Use Constant -Whatever your checkbook

    Currency ID:  Use Default

    Number:  Use Source:  CM Trx Number

    Trx Date:  GL Posting Date

    Posting Date:  Use Constant or you can use your source

    Amount:  Use Source, Checkbook Amount

    Paid to:  Use Source:  Paid to

    Recv'd From:  Use Default

    Description:  Use Source:  Description

    Note:  Use Default

  • Barbara Salazar Profile Picture
    Barbara Salazar 1,415 on at
    Re: "THE TRANSACTION AMOUNT IS NOT FULLY DISTRIBUTED" error in bank transaction integration- checks (to input vendor checks)

    I changed the formating & now the situation is back to my ORIGINAL QUESTION:

    11 ERRORS "THE TRANSACTION AMOUNT IS NOT FULLY DISTRIBUTED" - Integration does not work.

    Please help! Many thanks in advance!

  • Barbara Salazar Profile Picture
    Barbara Salazar 1,415 on at
    Re: "THE TRANSACTION AMOUNT IS NOT FULLY DISTRIBUTED" error in bank transaction integration- checks (to input vendor checks)

    Un update: Now, I'm getting different 11 error messages: "OBJECT CANNOT BE CAST FROM DBNULL TO OTHER TYPES"

    PLEASE GIVE DETAILED INSTRUCTION ON HOW I SHOULD CORRECT THIS INTEGRATION.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans