Sorting Issue

[mhmmd_srf]

Hi All,

I have straight table.

I have Invoice, Po and PO Line. Where under 1 Invoice there could be multiple PO Line. Same posting is repeating for each PO Line against same Invoice.

I want to Show Invoice Posting Field only against PO Line 1.

How can I do this.

Please help.

Thanks,

Sarif

[sonkumamon]

Please share a screenshot to be clearer.

[mhmmd_srf]

Please find the screen shot.

The value 1019489.16 should be in first line against PO Line 1

[sonkumamon]

What is your current sorting?

[mhmmd_srf]

I have attached QVW file in initial post. Could you please check.

Thanks,

Sarif

[sonkumamon]

You better flag the first line of each invoice in the load script and then try:

Sum{<isFirstLineInInlvoice={1}>} InvoicePostingAmount)

[mhmmd_srf]

I did not get any function like this.

Could you please elaborate.

Thanks,

Sarif