How to segregate the revenue generated from different services in GL Analysis when using same account for all of them.
Ex: I am using same Revenue Account 160000 for capturing the revenue generated from different Services. Types of Services are Repairs, Field Service & AMC.
Account 160000- Revenue from Repairs
160000- Revenue from Field Service
160000- Revenue from AMC
Now in GL level, I want to determine how much revenue has been generated per Service i.e. Segregation of Revenue per Service.
Request you to please help me on this.
Thanks,
Rakesh
Best answer by Sachin Vithanage
Hi @Rakesh ,
One way of achieving this requirement would be, allocating a separate code part and defining code part values for each revenue sources. Then, these code part values can be connected when entering revenue transactions. After that, you should be able to query the account balance in GL balance analysis using the defined code part as a filtering option.
However, if identifying and monitoring the revenue source is a key business requirement, allocating separate accounts for each revenue source in the relevant posting control setup would be a much more simplified approach.
One way of achieving this requirement would be, allocating a separate code part and defining code part values for each revenue sources. Then, these code part values can be connected when entering revenue transactions. After that, you should be able to query the account balance in GL balance analysis using the defined code part as a filtering option.
However, if identifying and monitoring the revenue source is a key business requirement, allocating separate accounts for each revenue source in the relevant posting control setup would be a much more simplified approach.
