web
You’re offline. This is a read only version of the page.
close
Skip to main content
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...

I have the same question (0)
  • Verified answer
    Olister Rumao Profile Picture
    3,967 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

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,255

#2
Sumit Singh Profile Picture

Sumit Singh 2,665

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,401

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans