web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 2010: Apply Cash to...
Microsoft Dynamics GP (Archived)

GP 2010: Apply Cash to Invoice Line Items

(0) ShareShare
ReportReport
Posted on by webberland 355

Is there a way to apply payment to specific line items in AR?  We have customers who will pay for specific line items on an invoice at a time instead of the whole thing.  It makes it hard on our collections because they don't know which line items to discuss with the customer, but instead have to go through the whole invoice.  We are using GP 10.

Thanks,

Jason

*This post is locked for comments

I have the same question (0)
  • PB_SBSB Profile Picture
    PB_SBSB 5 on at
    RE: GP 2010: Apply Cash to Invoice Line Items

    Has anyone tried using the ISV Binary Streams solution called MLLR?  If so, does it also encompass lockbox processing?

    Thanks,

    Paul

  • Community Member Profile Picture
    Community Member on at
    Re: GP 2010: Apply Cash to Invoice Line Items

    Leslie thanks for your reply on my another issue. But I want your help on this issue. As you mentioned "I have one client that needed this kind of thing too. They didn't want to change the way the SOP documents were entered, but they wanted to apply the cash receipts to the line item. Here's what I came up with. After the invoice was posted I used IM to read the SOP history tables and created an RM transaction for each line on the posted invoice.

    The document numbers of the created RM transactions were derived from combining the SOP Doc Number + Line Sequence + Item Number. The line sequence number was converted to a two character digit. The original document created from the posted SOP document is written off in an imported cash receipt trx."

    Will you please let me know while setting up Cash Apply Item wise which Destination you have selected 1)whther you have Selected Cash Receipt/Receivable Transactions/Sales Transactions (SOP)

    2)Which Sources you have utillized for this Integration.

    Your this information will helpful to me to set up a new Integration and I hope it will work.

  • Community Member Profile Picture
    Community Member on at
    Re: GP 2010: Apply Cash to Invoice Line Items

    Yes I want more information about your post.  I want to know how you had set up integration for Cash Apply with item wise sales invoice. Please send me any documentation if you have with this so that i can set that integration at my end. please mail me on sanjay.parab@pathinfotech.com

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: GP 2010: Apply Cash to Invoice Line Items

    Sanjay,

    That is what this thread was about. Do you have a question about one of the resolutions herein?

    Leslie

  • Community Member Profile Picture
    Community Member on at
    Re: GP 2010: Apply Cash to Invoice Line Items

    is there any way in GP to Apply Sales invoice with Item No? I have a invoice which have multiple Items and the payment which i received is 15% advance and remaining at due date per Item. I want outstanding for itemwise also i want to apply payment itemwise. Please advise on this.

    Thanks

    Sanjay Parab.

  • Christopher Mast CPA Profile Picture
    Christopher Mast CPA 225 on at
    Re: GP 2010: Apply Cash to Invoice Line Items

    If you create an RM document for each line item in SOP history, what about the RM doc that's already in RM?  Doesn't it need to be removed, or credited, or voided?  If it's allowed to remain you're double dipping, aren't you?

    I have a client with the same issue, and we're looking for a solution.  So far this seems like the most viable.  I'd probably use SmartConnect and schedule it to run daily.  

    Thanks.

    Chris Mast CPA
    Grand Rapids MI

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: GP 2010: Apply Cash to Invoice Line Items

    It's great to have so many options! We have a very good community here! Please let us know if you run into any snags. There are always those pesty details that get in the way of speed <grin>.

    Kind regards,

    Leslie

  • webberland Profile Picture
    webberland 355 on at
    Re: GP 2010: Apply Cash to Invoice Line Items

    Thanks everyone for the quick answers.  Leslie I am going to start looking into you suggestion.  

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    Re: GP 2010: Apply Cash to Invoice Line Items

    Jason,

    I have one client that needed this kind of thing too. They didn't want to change the way the SOP documents were entered, but they wanted to apply the cash receipts to the line item. Here's what I came up with. After the invoice was posted I used IM to read the SOP history tables and created an RM transaction for each line on the posted invoice.

    The document numbers of the created RM transactions were derived from combining the SOP Doc Number + Line Sequence + Item Number. The line sequence number was converted to a two character digit. The original document created from the posted SOP document is written off in an imported cash receipt trx.

    At the end of the day the original SOP Document is intact and can be reprinted. The line items appear on separate RM docs so that the items can be paid for separately. The RM docs are easily tied back to the original SOP doc because the RM doc number starts with the SOP doc number.

    It may sound odd, but it was easy and it's working.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member on at
    Re: GP 2010: Apply Cash to Invoice Line Items

    On a similar tone, we have a customer who produces a 'Statement/Invoice'. This lists all of the sales transactions on a customers account since the last statement was run.

    At the bottom of the Statement/Invoice, the VAT for all of the invoices is summarised, and an 'Invoice' total is printed etc.

    The top half displays the different invoices (each has only one line) - but the whole looks like a normal invoice. And each line gets paid seperately.

    But it does mean putting only one line on each SOP invoice (or multiple lines if they are going to be paid together) as Victoria says.

    Another customer prints their sales invoice lines to XL and stores it as an attachment in the document OLE container. When they receive cash, they update the relevant XL sheet. They do more in the XL file than just track the cash applies, so it makes sense for them to keep a file they can play around with.

    Have you looked at Scheduled installments? Could this be of any use?

    Ian.

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans