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) / How do I import cash r...
Microsoft Dynamics GP (Archived)

How do I import cash receipts and apply to specific invoices in Integration manager?

(0) ShareShare
ReportReport
Posted on by Community Member

I want to import cash receipts and apply them to specific invoice numbers, but I am getting warnings that "Apply-to document (invoice #) had problems saving."  The cash receipt is importing but it isn't applying.

I have followed the example of the sample RM Cash Receipts integration, but it seems to have errors in it.  On the 'Cash Apply' options, it is set to 'Auto Apply' rather than look at a source file.  When this option is chosen it auto applies based on document date, and doesn't apply to the invoice you have specified.

I setup a new integration.  There is only one txt delimited file, however I have created two 'sources' from it - one for the main cash receipt import, and one for the Cash Apply import.  I only want to apply one invoice to each cash receipt.

I have setup the 'Cash Apply' mappings as below

Apply-To Document Number = source field - invoice number

Apply-To Document Type = Constant - Sales/Invoices

Apply-To Amount = Source field - payment amount

Can anybody advise what I am getting the errors "Apply-to document (invoice #) had problems saving."?

*This post is locked for comments

I have the same question (0)
  • Loan Nguyen Profile Picture
    Loan Nguyen 305 on at

    Not sure if you found a solution but I do know the answer.

    In Destination Mapping for Cash Apply.  On the Cash Apply Options, set the Rule to "Use Source Recordset" then choose your source file under Source.

    Hope that helps.

  • Ankit Profile Picture
    Ankit 10 on at

    Hi

    i am having the same Error . Did you find a solution to this ????

    Thanks

  • David.Eichner Profile Picture
    David.Eichner 185 on at

    Mass Apply Receivables is a tool from ICAN Software Solutions that allows you to import the cash receipt with the invoice stored in the comment field...and then allows you to mass apply all credit documents (credit memo, payment or return) using that information. You can also import specific one-to-many apply records and then run a mass apply of those credit to debit apply records.  And it also supports mass auto apply for range of customers and date ranges.

  • David.Eichner Profile Picture
    David.Eichner 185 on at

    A recorded demo of Mass Apply Receivables is available at http://www.icansoftware.com

  • Loan Nguyen Profile Picture
    Loan Nguyen 305 on at

    Hi,

    Did you try my suggestion above?  

    I know I was rushing when typing that so I'm expanding it here for you.

    Double click on Destination Mapping then click on the folder Cash Apply.  There will be two tabs on the right hand side.  Click on the tab called Options, set the Rule to "Use Source Recordset" then choose the field that you want to match under the Source column.  

    Hope that will work for you.  Let me know how it goes.

    Thanks.

  • StefanieC Profile Picture
    StefanieC 434 on at

    Hate to bring up an old post but I'm having this issue and have tried EVERYTHING.  This is an integration that worked with GP10 but was just upgraded to GP2010 and no longer works.  I didn't write the integration but it was done with one source file through a SQL script.  I also tried added a second for the apply information but that didn't help.  

    The source has multiple cash receipts for the same customer and being applied to the same invoice.  I have manually entered a few to make sure it saves fine.  When running the integration, I get the error "Apply-to document (invoice #) had problems saving."  It looks like the first receipt for the customer/invoice imports fine and shows $0 Unapplied; however, when you click Apply there are no invoices marked and clicking Unapply does nothing.  Then the second cash imports but shows the full amount unapplied and gives the above warning.

    Like I said, it worked in the previous GP10 environment.  I've made sure everything is the exact same except the destination database on the connection string.  

    Thank you

  • StefanieC Profile Picture
    StefanieC 434 on at

    By the way, I also tried the integration with a text file.  Same results. :(

  • Acctg BA Profile Picture
    Acctg BA 400 on at

    That worked for me. I tried it with just one of the many invoices for that customer.  I will try it next with several.  

    Our situation is that we use Parent - Child relationships.  We receive a check from the Parent but need to apply it to many invoices across many of the children.  I am trying to use the check number in the Check/Card number mapping.  When I tried this, I received an error that the check number was a duplicate for all transactions after the first one.  Any solutions for this?

  • StefanieC Profile Picture
    StefanieC 434 on at

    My issue was solved by applied the Integration Manager service pack. How silly not to think of that sooner. :(

  • Community Member Profile Picture
    Community Member on at

    I am not completely sure if this will help. The integration manager will not import the apply to invoice information unless the invoice is already posted.

    I have not received an error message like the OP, but certainly lost the apply to information unless I posted the invoices first.

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