Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Where does "Remaining Amount" on a posted sales invoice come from?

(0) ShareShare
ReportReport
Posted on by 450

So i'm trying to get a value of the "Remaining Amount" field on a posted sales invoice since i want to use that value in a report.

Now a customer i am developing this for, that field is filled in with a certain amount on each document but i was wondering where that value comes from since i am developing on my OnPrem to later publish it on their SaaS. Now in my OnPrem the "Remaining Amount" field is always equal to 0 so when testing the report on my OnPrem that column is always empty.

Would be thankful if someone can elaborate this.

EDIT:

Turns out there is no difference between my OnPrem and their Saas BUT, still the field on both the posted sales invoice pages are equal to 0 but if i look in the list of those posted sales invoices, where they are all listed, then the "remaining amount" field is filled in...

  • Verified answer
    Olister Rumao Profile Picture
    3,959 on at
    RE: Where does "Remaining Amount" on a posted sales invoice come from?

    Hi,

    It looks like you are search for Remaining Amount value in the wrong place.

    Goto Customer Ledger Entries, filter by Document No. which is equal to Posted Sales Invoice No. and then find the remaining amount using CALCFIELDS.

    Let me know if you need further 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

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
YUN ZHU Profile Picture

YUN ZHU 536 Super User 2025 Season 1

#2
Mansi Soni Profile Picture

Mansi Soni 400

#3
Sagar Dangar, MCP Profile Picture

Sagar Dangar, MCP 384

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans