AL Help

(0) Share

Report

Posted on by LearnBC

240

Dear Experts

In Sales order List page, how can we bring the Total of Remaining amount of all the line items which was not invoiced

Thankyou in Advance

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

There is already a function for that in the system. Go to statistics (F7) and you will see exactly that data there.

Was this reply helpful? Yes No
LearnBC 240 on at

Like (0)

Report
Copy link

Link copied!

Sorry i was mistaken while selecting the column

actually, required to total of already invoiced

Total = Sum (Qty to Invoiced * Unit Price) all line Items

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,423 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi

you have to do a customisation to get this information

you should make a function to be exposed on the page that performs that calculation

DAniele

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

You have already the Fact box available for all the balances, see the image, see if it help you.

Was this reply helpful? Yes No
LearnBC 240 on at

Like (0)

Report
Copy link

Link copied!

Hello Nithin

thanks for your reply

we need from this Sales order what it the Total value of partially invoiced to the list page. (it is not in Fact box also. so that we can easily understand from list page how much amount is partially invoiced from the Total Value)

Total = Sum (Qty Invoiced * Unit Price) all line Items

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

In that case you have customized that page. so that you can do the run time calculation based on the qty. invoiced and display.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

pageextension 62007 "Sales Order PartialValue" extends "Sales Order List"

{

layout

{

addafter("Amt. Ship. Not Inv. (LCY)")

{

field("Partial Invoiced"; PartialInvoiced)

{

ApplicationArea = All;

}

}

}

trigger OnAfterGetRecord()

var

PartialQty: Record "Sales Line";

begin

PartialInvoiced := 0;

PartialQty.Reset();

PartialQty.SetRange("Document Type", PartialQty."Document Type"::Order);

PartialQty.SetRange("Document No.", Rec."No.");

PartialQty.SetFilter("Quantity Invoiced", '>%1', 0);

if PartialQty.FindSet() then

repeat

PartialInvoiced += PartialQty."Quantity Invoiced" * PartialQty."Unit Price";

until PartialQty.Next() = 0;

end;

var

PartialInvoiced: Decimal;

}

Was this reply helpful? Yes No