Link to home
Start Free TrialLog in
Avatar of Obeg_
Obeg_

asked on

Great Plains 10.0 Integration Manager and Due Date

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?
Avatar of Victoria Yudin
Victoria Yudin
Flag of United States of America image

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.
Avatar of Obeg_
Obeg_

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of Victoria Yudin
Victoria Yudin
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Obeg_

ASKER

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!