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) / 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

I have the same question (0)
  • Richard Ottley Profile Picture
    Richard Ottley 140 on at

    File.jpg

  • Suggested answer
    26P2ER Profile Picture
    26P2ER 1,775 on at

    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

    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.

  • 26P2ER Profile Picture
    26P2ER 1,775 on at

    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?

  • 26P2ER Profile Picture
    26P2ER 1,775 on at

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

  • Richard Ottley Profile Picture
    Richard Ottley 140 on at

    IT still does not work. Gives the same error.

  • Richard Ottley Profile Picture
    Richard Ottley 140 on at

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

  • Verified answer
    Richard Ottley Profile Picture
    Richard Ottley 140 on at

    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

    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. :-)

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
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans