web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • Barbara Salazar Profile Picture
    Barbara Salazar 1,415 on at

    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.

  • Barbara Salazar Profile Picture
    Barbara Salazar 1,415 on at

    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!

  • Suggested answer
    sueconrod Profile Picture
    sueconrod 337 on at

    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

    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

  • sueconrod Profile Picture
    sueconrod 337 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans