Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Integration Manager Pa...
Microsoft Dynamics GP (Archived)

Integration Manager Payables Transaction Entry failing on A value exceeding the maximum length was found in the 'Distribution Type'

(0) ShareShare
ReportReport
Posted on by Richard Ottley 140

Okay so I've been trying to automate my AP (Payables) transactions but it keeps failing on me.

I've done it with both a CSV and TXT and am getting the same error.I've attached a sample file.

We will only have one line in the distribution for the purchases..

My Troubleshooting includes:

1. Running the Macros while doing the integration to show the windows.

1.1 Removing the dashes from the GL Account in case that was the issue.

2. Breaking it down so I only do the portion with just the initial Transaction Entry first. (And that's good).

3. The issue seems to come on the last part with my distributions but I'm not seeing it.

Opening source query...
Establishing source record count...

Beginning integration...

DOC 1 ERROR: A value exceeding the maximum length was found in the 'Distribution Type' field of the 'Distributions' recordset. Maximum length is 0. Value is 6., length is 1

Integration Failed

Integration Results

1 documents were read from the source query.

1 documents were attempted:

0 integrated without warnings.

0 integrated with warnings.

1 failed to integrate.

 

*This post is locked for comments

  • Richard Ottley Profile Picture
    Richard Ottley 140 on at
    RE: Integration Manager Payables Transaction Entry failing on A value exceeding the maximum length was found in the 'Distribution Type'

    Hey Ven, Now that stuff is starting to clear on my plate, I've been able to get it to work in one file.

    The issue was that we have made customizations to the screens so it was causing an issue with the Integration and throwing off my fields.

    Went to  --> Tools --> Customize --> Customization Status, disabled the Customization and worked like a charm.

    Now to find all these customizations and start cutting down on them if we're not using 'em. :-)

  • Verified answer
    Richard Ottley Profile Picture
    Richard Ottley 140 on at
    RE: Integration Manager Payables Transaction Entry failing on A value exceeding the maximum length was found in the 'Distribution Type'

    Fixed it by going the "logical" way and breaking it up to two files instead of trying to use just one.

  • Richard Ottley Profile Picture
    Richard Ottley 140 on at
    RE: Integration Manager Payables Transaction Entry failing on A value exceeding the maximum length was found in the 'Distribution Type'

    I'll try this later today Venin my test environment.

  • Richard Ottley Profile Picture
    Richard Ottley 140 on at
    RE: Integration Manager Payables Transaction Entry failing on A value exceeding the maximum length was found in the 'Distribution Type'

    IT still does not work. Gives the same error.

  • 26P2ER Profile Picture
    26P2ER 1,773 on at
    RE: Integration Manager Payables Transaction Entry failing on A value exceeding the maximum length was found in the 'Distribution Type'

    In addition to the above, I have a defaul-nonimported rule for record source.

  • 26P2ER Profile Picture
    26P2ER 1,773 on at
    RE: Integration Manager Payables Transaction Entry failing on A value exceeding the maximum length was found in the 'Distribution Type'

    Hello Richard,

    I am not seeing this error in my environment, I use the standard GP Dynamics Payables Management destination adapter.

    What happens if you change the mapping to send a constant value for distribution type meaning Purchases and the payables line is going to be defaulted by Intg Mgr?

  • Richard Ottley Profile Picture
    Richard Ottley 140 on at
    RE: Integration Manager Payables Transaction Entry failing on A value exceeding the maximum length was found in the 'Distribution Type'

    Hi Ven,

    I checked the Schema and the Data Sources for the Integration. The Schema is showing as text and the integration is showing them as strings.

  • Suggested answer
    26P2ER Profile Picture
    26P2ER 1,773 on at
    RE: Integration Manager Payables Transaction Entry failing on A value exceeding the maximum length was found in the 'Distribution Type'

    Hello Richard, 

    Can you open the schema.ini file via Notepad and check to see what data type is referenced for the distribution type column and under your data source section?

    I would leave it as text.

    You can accomplish this by opening the data source properties and switching the distribution column data type to string.

  • Richard Ottley Profile Picture
    Richard Ottley 140 on at
    RE: Integration Manager Payables Transaction Entry failing on A value exceeding the maximum length was found in the 'Distribution Type'

    File.jpg

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans