Tuesday, January 15, 2019

Revenue by Customer Report Displays Deferred Revenue instead of Revenue/ Income Account

Check the column being used in the custom report if it was sourced from the Account Name/Number from Transaction Dimension > Account (Line) > Name/Number.  The system is sourcing the revenue account based on whatever was the credit account in the Invoice transaction (although the amount of revenue will still be based on how much was recognized).

 

To resolve this and see the actual revenue account entry from the Rev Rec Journal pull the Account Name/ Number from the Account Balance folder:

1. Pull up the custom Revenue by Customer report

2. Hit Return to Customization

3. Edit Columns select the folder: Account Balance > Account (Line) > click Name or select Number (for account number) for it to be added

4. Remove the Account Name/Number pulled from Transaction Dimension (Transaction Dimension > Account (Line) > Name/Number)

5. Preview the report, save the changes if desired

 

No comments:

Post a Comment