Hi everyone, Can we create ledger detail report (Account and contra account in same line)? Can you guide me?
Assuming your data is configured for having accounts and contra account code in different dimensions - in application studio as a custom report? yes - use a slice or a nested hyperblock. in self service - yes, add both lines into your left hand cross tab report. in Adhoc - same yes. if you don't have the contra information in a different dimension, then you would need somehow to identify the contra accounts from the data (maybe as an attribute? - then you need to apply filters by attributes.
Thanks Peter, Because one account may be associated with several contra accounts, and these mappings can vary between journals, what is the appropriate way to define the dimensions or attributes?