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 :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / %Paid Invoice for a job
Small and medium business | Business Central, N...
Answered

%Paid Invoice for a job

(0) ShareShare
ReportReport
Posted on by Indira88 1,037

Hi All

There is a requirement where I will have to calculate the % of paid invoices based on a job.

my question is what is total invoiced for a job from where can we get that?

how can we know what amount is paid from which table

%paid invoice = Paid Amount./total invoiced * 100

  • Suggested answer
    JAngle Profile Picture
    JAngle 159 on at

    Publish this page as a web service: Job Invoices (1029, List) that shows the Job Planning Line Invoice (1022) table - in case you want to use a different reporting method.

    That has all the invoice numbers from jobs and the amounts. You can then match that up with the customer ledger entries for payments

  • Suggested answer
    Ashish K Profile Picture
    Ashish K 154 on at

    Hi Indira, I do not see a direct linking between Jobs Invoices and Payments. We will have to find the invoice from Job Ledger Entry or Page 1029 and find the Invoice in CLE ( Cust. Ledger Entry) to check the Amount Due column. Then create a report showing all the Invoices and Amount Due etc.

    If this has answered to your question then do Click Suggested Answer as Verified.

  • Indira88 Profile Picture
    Indira88 1,037 on at

    Hi Ashish,

    Thank you for the reply I took the values from the Detailed Customer Ledger Entries because I saw that the remaining amount in the customer ledger entry is actually the Flow field being taken from the Detailed Cust ledger Entry.

    Regards,

    Indira

  • Indira88 Profile Picture
    Indira88 1,037 on at

    Hi JAngle,

    Thank you for the reply I took the values from the Detailed Customer Ledger Entries because I saw that the remaining amount in the customer ledger entry is actually the Flow field being taken from the Detailed Cust ledger Entry.

    Regards,

    Indira

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 720 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 436 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 409 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans