Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Great Plains 10.0 Integration Manager and Due Date

Posted on 2010-09-12
4
Medium Priority
?
724 Views
Last Modified: 2012-08-14
We are using Integration manager to attempt to update the Due Date.  However - after the transaction is successfully imported and we then look at the record in Great Plains, the Due Date is set to the calculated date from the default payment terms.  We would like to be able to override the due date from the calculated value based on the due date.  For instance - an account is set for default to 30 day net which would auto-calc to 10/15/2010 - we pass in a due date of 10/1/2010 with integration manager  but it still show 10/15/2010.

Any ideas?
0
Comment
Question by:Obeg_
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 18

Expert Comment

by:Victoria Yudin
ID: 33660321
Are you're trying to update posted transactions or are these brand new transactions you're importing in?  What transaction type?

If these are already posted, I do not believe IM can update the due date.  You can either change the due dates directly in GP (recommended) or, if there are a lot, you could do this in SQL.  Without knowing what transaction type you are using it's hard to give a more specific answer than that.
0
 

Author Comment

by:Obeg_
ID: 33661177
They are all new transactions.

I expect that I need to pass in something for Payment Terms to let it know not to override my date with the default - but I have tried passing in blank and DUE ON RECEIPT  and neither helped.  

Currently my client imports the transactions and then goes and manually changes the due date.  Obviously this is not optimum.
0
 
LVL 18

Accepted Solution

by:
Victoria Yudin earned 2000 total points
ID: 33661651
You have not said what transaction type, so I just picked the PM Transaction to test with.  Here is what I did in the Destination Mapping:

On the Payment Terms section I choose Use Constant under Rule and entered a date, then I switched to the Options tab (still on the Payment Terms section) and chose Use Field Rules under the Rule for Record Source.  (Without this change it did not work properly!)

I left the Payment Terms field on the main section defaulted to Use Default, not mapped to anything.

When I import with these settings I have the Payment Terms populating from the Vendor setup, however, the due date populating correctly to what I set in IM - I set it to be in the following year, just to make sure.  I would expect this to work in a similar way if you have the Due Date in your source data, however, you may need to play with the Rules on the Options tab for the Payment Terms.

If this is still not working for you, can you provide some more detail, including the type of transaction, and the version and build of IM?

Also, if this is a situation where a payment term CAN be set up to calculate correctly, I would recommend that over passing in a due date for each transaction.  That way the payment term displayed on the transaction in GP will match the calculated due date.  
0
 

Author Closing Comment

by:Obeg_
ID: 33661818
Excellent!  Thank you!  It was the setting under options that I was missing!

This import was set up and running for years by the previous contractor and Friday afternoon was my first time looking at it or Integration Manager in order to add the due date column.  

I am going to look into mapping over their payment terms from the inventory system but wanted to take this baby step first as there is a bit more work to do on that side first.


Thanks!
0

Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part II
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question