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) / Using Integration Mana...
Microsoft Dynamics GP (Archived)

Using Integration Manager to Import SOP

(0) ShareShare
ReportReport
Posted on by James Lux 175

I am having trouble importing SOP data using Integration Manager.  Does anyone have experience with this?  The problem I am facing is getting the dates to "behave" as I want them.  I want to post the transaction (batch) to date #1, and the individual invoices to date #2.  This was the sales go to the correct date and the batch can have multiple sales dates.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    It wouldn't be an issue with your posting set up?

    Tools >> Seup >> Posting >>Posting...select Series Sales and Origin Sales Transaction Entry. Is GP set up to take the posting dte from the transaction or the batch?

    Is IM creating the batch, or do you set it up yourself before running the integration?

    We are talking about the Batch posting to a single GL Posting date?

    Best regards,

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Ian is exactly right, your posting setup would determine what's possible.  And it's extremely important to use the right terminology, or we're all playing broken telephone. 

    If your posting settings are set to use the posting date from the batch, then you must have the batch already created in GP to be able to specify the batch date, otherwise it will default to the GP date at the time of creation.

    If you posting settings are set to use the posting date from the transaction, then you can specify a Date (Invoice, or Document Date) and a Posting Date (GL Posting Date) in your integration.

  • James Lux Profile Picture
    James Lux 175 on at

    Thanks a lot for your posts.  I am an IT guy, not  GP user, so my terminology is challenged.  I have 6-8 other integrations (Journal, Payables, etc) working fine.  Just need to get this SOP working.  I did forget to mention, we are on GP 9.0 still.  The settings I have are: Create a Journal Entry Per: Transaction, Post Date From: Batch.  Does that help?  I am also not sure which of the dates in IM are most relevant.

  • Community Member Profile Picture
    Community Member on at

    Can you explain exactly what you mean by:

    I want to post the transaction (batch) to date #1, and the individual invoices to date #2.

    I ask because, individual Invoices are transactions, and many transactions (individual invoices) can be saved to a batch.

    Each transaction can have its own document date. This is the invoice date. If you open an existing SOP Invoice in GP, you will see the Document Date in the header.

    (SOP Invoices have more than just one type of date. If you click on the blue arrow beside the Document Date field, you will see Tax Date and Posting date - Tax Date is the date you want the invoice considered for Sales Tax returns, and Posting Date is the date the resultant GL journal will hit the GL).

    SOP Invoices post to the Sales Ledger based on the document date. However, these transactions also generate seperate GL Journals that get posted in the General Ledger. These get posted by the Posting Date.

    When considering what date to use for the GL Posting Date, GP uses eithre the posting date attached to the SOP invoice or the posting date attached to the Batch that the invoice is saved in.

    So, just to be sure...what exactly is it about the transactions that they don't work how you want (date wise).

    Can you confirm that the Integration Manager is integrting the transactions successfully - its just that the dates look wrong?

    Best regards,

     

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Since your posting settings are taking the posting date from the batch, you would need to create the batch in GP manually to be able to specify the posting date.  The invoice date would map to Date field on the main (first) section in the IM integration mapping.

  • James Lux Profile Picture
    James Lux 175 on at
    This post was extremely helpful.  I was hoping to define the posting data with IM, but the settings are forcing it to use the current date.  The transactions do import, but I get a warning:

    DOC 1 WARNING: One or more distributions amounts are incorrect and will not be posted.

    When I look in Sales Batch Entry, it appears to be correct.  Not sure why I am getting this error.
  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    You can easily have the user who will be posting the SOP batch change the posting date, since it's just one step per batch, prior to posting.

    For the other issue - are you importing the GL distributions or letting GP default them?  Here is a blog post that might help with this error in general: http://victoriayudin.com/2008/12/08/sales-transaction-entry-gl-distributions-in-dynamics-gp/ (the last question/answer).

  • Community Member Profile Picture
    Community Member on at

    Are you getting the 'Distribution' error on all transactions?

    Print a Batch Edit list in GP - and it will tell you what the distribution error is. - or at least tell you if it is on a line or header level.

    Let us know what this problem is and we can suggest a solution.

  • James Lux Profile Picture
    James Lux 175 on at

    You folks have been such a huge help.  The Batch Edit list gives me this error:

    **ERROR: The sales distribution(s) does not equal the actual amount.
    **ERROR: The taxes distribution(s) does not equal the actual amount.

     But, the transaction balances and the totals are equal.  When I open the Distribution in GP, it prompts me to save, but I get no error.

    Strange.

  • Community Member Profile Picture
    Community Member on at

    Strange indeed...but I've seen this before...somewhere!

    Are these multicurrency transactions?

    After you open the transaction, open and save the distribution...can you then post the invoice?

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