How to Display last Invoice Number and Transaction Date for a Customer

[Former Member]

HI friends,

I have a requirement to display Last invoice Number and Its Transaction Date for every customer. I have billing document date and billing document number. But they are characters. Help me to report.

Many Thanks,

Anand

[Former Member · Accepted solution]

Hi Anand,

You can create a formula variable of type number, and populate the values with replacement path, for each Last invoice Number and Its Transaction Date , and then use this formula variable in a formula keyfigure.

Later you can set the TOP N condition on the formula keyfigure, to get your desired result.

Hope this helps.

Regards,

Umesh Chavan.

[Former Member · Accepted solution]

Thank you Chavan,

I did the same as what you said. But it is displaying X and nothing else.

Many Thanks,

Anand

[Former Member · Accepted solution]

Can you try without applying the TOP N condition, just to check the formula keyfigures,and check if the Replacament value are getting populated properly for Billing Number and date respectively.

Regards,

Umesh.

[Former Member · Accepted solution]

Hi Umesh,

I did. Its not populating values. Do I need to give any Offset limits when creating replacement path.

Please Let me Know,

Anand

[Former Member · Accepted solution]

Thanks Umesh,

My Problem Is solved.

Full Points Awarded

Many Thanks,

Anand

[Former Member · Accepted solution]

Hi Anand,

What resolved the problem finally so that X wasn't displayed?

Thanks,

K

[Former Member · Accepted solution]

Hi K,

Display the Billing Document (Char) along with Formula Variable that was created using replacement path (Later Hide this as this is used only to create a condition) and then take the TOPN condition. Thus te Prob Is solved.

Thanks,

Anand