You’re offline. This is a read only version of the page.
We've created a development GP 2013 server. We have custom IM tables that are used for integration. Whenever we run the Integration we get the following error.
DOC 2 ERROR: Field 'Document Number' does not have a default value. - Destination Field
ID: Document Number - Field Value: T-8006-02
DOC 2 ERROR: Field 'Distributions.Distribution Account' does not have a default value. -
Destination Field ID: Distributions.Distribution Account - Field Value:
It states the batch does not exist but the batch was created and it's status is "Avaliable".
*This post is locked for comments
IM only points to the instance of GP that is running on the machine that you are running IM on. If that makes sense. It uses the same ODBC as GP and GP must be logged into the company that you want to import data into.
There are no blank rows or fields. It is a 2 row file. I am testing with a sample file.
Also, I am curios about one thing. The integration manager was installed with configuration from a production server. I moved the access DB file to the local DEV server and recreated a new integration with the source and the destination. Is it possible that even though I created a new integration the mapping might still be pointing to the other server? Is there a way to find out from IM which GP server it is pointing to?
thanks,
Justin
Yes the source file does have a GL account number as one of the fields. But the error does not indicate to that field. I don't know if that helps.
It's really challenging to troubleshoot an issue like this online because of the number of variables associated with an integration but I would be looking at the integrity of the source file. Check to make sure that no blank rows or fields exist. Let us know what you find.
Frank has you looking at the source table - question would be 'are there values that are real account number or index values in that table?
The Custom tables actually refer to the source Text files. These are comma delimited files.
Okay, next question - what is the nature of the 'custom tables' referred to in the first post?
Hi Frank,
Thanks for your reply. No they are not set as default. I have set it to take from the Use source field. That is what I have set in the mapping section.
thanks
Justin
The error messages indicate that your mapping has 'Default' set as the source for Document Number and Distribution Account but there are no defaults set in GP for those values. Should those values not be coming from your source file?
Hi Frank,
This is Payables Transaction. I work with AnettaJ. We both are working on this issue.
Thanks
Justin
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,113
Super User 2024 Season 2
#2
Martin Dráb
229,918
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (