Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Cash Receipts

Posted on by 1,550

I have a Third-party application which has provision to enter an invoice with multiple line items as we do in GP, and same can be posted.

When we receive a payment, and tried to apply against the invoice, then it is considering each line item wise but not an Invoice wise,

For example

INV0001

Line Item 1 - $250

Line Item 2 - $150

Line Item 3 - $200


so total invoice amount is $600,

Now when we receive $500 and apply to this invoice, then it is considering as below,

Line Item 1 - $250 - Fully Applied

Line Item 2 - $150 - Fully Applied

Line Item 3 -$100 - Partial Apply

It is required to bring the same functionality in GP.

Is it possible to do this, if yes, kindly provide me steps to do this or any other suggestions

*This post is locked for comments

  • Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,550 on at
    RE: Cash Receipts

    Hi Heather,

    Thanks for providing the clarity.

    I am searching for any Add-Ons, authenticated by Microsoft.

    If this is not helping, then i might proceed with developing Dexterity based Custom Feature for this functionality.

    Thanks,

    Praveen

  • Verified answer
    Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: Cash Receipts

    Hi Praveen

    There is no functionality in GP to allow you to apply at line level.  Something I hope one day may be considered by Microsoft.

    So the only thing you can do in GP is bring in the full amount of the payment and apply it to the invoice.  The invoice will show as $100 outstanding - but no way from within GP to see which $100 is outstanding.

    If your third-party application is also SQL based, it may be possible to then create a report that could be run from within GP that would have that level of detail.

    Cheers

    Heather

  • Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,550 on at
    RE: Cash Receipts

    When we apply any amount it will be against an invoice but not at each line item of that invoice.

    Please suggest

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cash Receipts

    Go ahead and change the apply amount and you should be fine.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans