Skip to main content
Question

How could I calculate the revenue by Identity using the "GL-Voucher Rows Analysis"?

  • September 26, 2021
  • 2 replies
  • 85 views

ZTC ZTC JGOTA
Hero (Customer)
Forum|alt.badge.img+14

Hello IFS Community.

 

I am trying to calculate revenue per customer. I posted a previous question “How could I find revenue data per Customer?” One person advised me to search using the “GL Voucher Rows Analysis” However, how could I find the revenue data using GL Voucher Rows Analysis?

 

It will be helpful if you could provide screenshot. Please.

 

Thanks,

JL

This topic has been closed for replies.

2 replies

Forum|alt.badge.img+9
  • Hero (Employee)
  • 32 replies
  • September 26, 2021

Hi @ZTC ZTC JGOTA ,

 

Go to GL Voucher rows analysis and Query as below

Account-Revenue account
Identity-Customer ID

BR/Janith


Dhananga Jayatilake
Hero (Employee)
Forum|alt.badge.img+7

Hello @ZTC ZTC JGOTA 

Yes, at Janith has advised identity refers to customer ID, thus using it in the searching context and querying for the records would fulfill your requirement.