subtotal in purchtablelistpage form

(1) Share

Report

Posted on by M_R

123

hello everyone,

I am trying to add subtotal column in the purchtablelistpage form,

i have added the code like this, but it was showing the subtotal only for existing purchase order,

[ExtensionOf(tableStr(PurchTable))]
public final class ABCPurchTable_Extension
{
Display PurchLineAmount SubTotal()
{
PurchTotalsSummary pts;
;
select pts where pts.PurchId == this.PurchId;
return pts.NetLines;
}

}

what changes should be done if we want subtotal for newly created purchase order for all order status

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (0)

Report

subtotal in purchtablelistpage form

Hi M_R,

So you want the total for all purchOrders and not just the current purchase order?

If that's the case, your code won't work because in the where condition you are saying where pts.PurchId = this.PurchId -- which means it will give the total for only this PurchId

If you need the total for all PurchIds then you need to use the keyword "count"

Select count(FieldYouWantToCount) from Table1

Thanks,

Layan Jweihan

Was this reply helpful? Yes No