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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

SOP Blank Invoice needs to show deposit/credit card payment and remaining balance

(0) ShareShare
ReportReport
Posted on by

I cannot believe this is not available out of the box - I have a client that needs to show the total paid against an invoice and then show any amount still due.  I read somewhere to create calculated fields F/O Deposit and F/O Remaining Amounts, however, nothing displays on the F/O Deposit when I create these and the for the remaining amount the only field I can see to attach to it is sub total remaining - I need the on account amount to be equal to the remaining amount of the invoice.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    KirkLivermont Profile Picture
    5,985 on at

    How is the deposit recorded in GP? This seems like it should be fairly simple to create using document amount less deposit received.

    Regards,

    Kirk

  • L Vail Profile Picture
    65,271 on at

    Hi,

    There are two fields instead of one. I haven't tested how this works if there are multiple payments received on the invoice.

    Kind regards,

    Leslie

  • Suggested answer
    L Vail Profile Picture
    65,271 on at

    Hi,

    Created a Calculated field that is:

    F/O Document Amount - SOP_HDR_WORK.Payment Received

    That should give you the balance due.

    Kind regards,

    Leslie

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans