web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Cash Receipts using In...
Microsoft Dynamics GP (Archived)

Cash Receipts using Integration Manager - GP2010

(0) ShareShare
ReportReport
Posted on by Steve Hoffmann 400

I am new to GP and Intergation Manager and am looking for some direction on using the cash receipts integration.  I can successfully run the integration with a single payment however the payment is not applied to the invoice (doc number) specified in the source file.  Any suggestions?

When I include multiple invoices in the CRHeader and CRDistribution source files, the first document will integrate successfully but the second does not.  I have mapped the Receipt field in the destination (Cash Receipts) to a source field in the CRHeader as I am trying to use the customer's check number as the Receipt.  It seems the integration will not work because the Receipt # already exists due to the first record being integrated successfully.  Any suggestions?

When I set the Receipt mapping to Default is solve the above issue, (a receipt number is assigned for each document in the CRHeader) - I get a similar error for the Check Number in the destination Cash Receipts.  I have mapped the Check Number in Cash Receipts to the source in CRHeader named Card #.  Any suggetsions?

*This post is locked for comments

I have the same question (0)
  • Bruce Wilkins Profile Picture
    Bruce Wilkins 570 on at

    To get payment to apply to invoice make sure in the integration set the Rule for Field "Apply-To Amount" under Cash Apply to Use Source Field and use Amount column in your upload file. Also make sure field "Apply Entire Amount" uses Rule "Use Constant" and Source = True.

    I only use one source file and one header. I don't use Distribution because I set Record Source to Use Default. That way it will default to account for Checkbook (Debit) and account for AR (Credit).

  • Steve Hoffmann Profile Picture
    Steve Hoffmann 400 on at

    Thanks Bruce.  I changed the field "Apply to Amount" to Use Source Field using the Amount field in the header source file.  The "Apply Entire Amount" was sent to Use Constant and Source = True.

    The integration was successful but in the payment was applied to the "oldest" documents, not the document number specified in the source.

  • Bruce Wilkins Profile Picture
    Bruce Wilkins 570 on at

    Did you verify the Field "Apply-To Document Number" was set to Use Source Field and Source was Doc Number from file?

  • Steve Hoffmann Profile Picture
    Steve Hoffmann 400 on at

    Yes, it was specified as you defined.

  • Verified answer
    Bruce Wilkins Profile Picture
    Bruce Wilkins 570 on at

    Strange because my worked perfect. If you will email me at bruce.wilkins@flagstonere.com. I will send you my sample file and screen prints of my integration to verify against your.

  • Community Member Profile Picture
    Community Member on at

    Just to clarify what Bruce means, please take a look into the following article:

    mohdaoud.blogspot.com/.../import-transactions-distributions-using_360.html

  • Steve Hoffmann Profile Picture
    Steve Hoffmann 400 on at

    Thanks for the repsonse.  I verified the integration was defined as stated in the article and it did not fix the problem of applying the payment to the invoice (doc number) in the CRHeader.

  • mpolino Profile Picture
    mpolino on at

    I have the same issue as Steve Hoffman. Integrating with setting to "Auto Apply" works properly but applies to oldest invoice (as expected). When set to Use Source Recordset and the appropriate recordset is selected, the apply header shows applied. The detail line no longer shows in the apply window (it doesn't show as checked, it's gone). The transaction posts and the posted record shows no payment document number.

    Mark

  • Bruce C Wilkins Profile Picture
    Bruce C Wilkins 150 on at

    Mark,

    I helped Steve offline and was able to build integration. He needed to apply a single payment to multiple invoices. So for example it would apply a payment of $1100 to two invoice $500 and $600 invoices. We had to add column in source file for Apply To Document and update destination mapping.

    Regards,

    Bruce

  • Ankit Profile Picture
    Ankit 10 on at

    hi Bruce,

    I am facing the same issue. would you be able to send me the sample file and screen prints on itsankit007@msn.com

    Thanks for your help

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans