Armanino Blog

Straight Line Revenue Recognition for Dynamics AX Project Accounting & Management

August 17, 2016

With the release of Dynamics AX R3 CU8, Microsoft has built some great tools for straight line revenue recognition. Straight line revenue recognition uses the amortization principle where the deferred revenue is recognized based on a set timeline – whether monthly, weekly, quarterly, half-yearly, etc. As a principal, deferred revenue is taken as liability on to the balance sheet account and thereafter for recognition, the deferred revenue account is debited and the revenue P&L account is credited based on above set timeline – monthly, weekly etc. Deferred revenue are usually the advance payments taken for the service to be performed and as the service is provided, the revenue is recognized or returned if the contractual obligations are terminated midterm or just according to the contract's terms.

The Bottom Line: Dynamics AX R3 project accounting with version CU8 allows for the estimates on project to be run on the straight line method.

See How It Works

The images below illustrate the process of configuring the system for the new functionality. This functionality is available only for fixed price projects (with the actual start and end date being mandatory) on the project setup.

At the project group level following setup is required:

Estime Fixed Price

Important: The revenue recognition accounting rule needs to be "completed percentage".

Period code – Create the period code and set the desired frequency of week, month, quarter, etc. from the drop down menu.

Cost template – The setup of the cost template remains the same as it would be for any other fixed price project, however the enhancement that was brought in by Microsoft in version CU8 was the option of Straight Line Revenue Recognition for completion based on the field/calculation rule. (See below.)

Cost Template

Project Revenue Posting enables users to take the initial invoice amount to the Balance Sheet, then decrementing that account and incrementing the P&L revenue account on posting of the project estimates, defined as follows:

Revenue Accounts

WIP-Invoiced-on-account is credited on the generation of the initial invoice.

WIP-Sales Value account is debited on the posting of the project estimates.

Make sure you have the above two accounts on the same balance sheet account for a credit and debit posting.

Accrued Revenue – Sales Value is credited on posting of the project estimate. It's relevant to have this account as the P&L revenue account for recognition of revenue at the end of the service cycle.

LEARN MORE: Interested in finding out more about straight line revenue recognition with Dynamics AX? Discover more tips and tricks throughout Armanino's Dynamics blog or connect directly today at [email protected].

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Related News & Insights
Costco Travel Webinar
One of the world’s top retailers reveals their cloud upgrade process.

May 19, 2022 | 11:00 AM - 11:30 AM PT
Overview of Sage Intacct R2 Release Webinar
Learn the newest features and enhancements in Sage Intacct from the 2022 Release 2.

May 18, 2022 | 01:00 PM - 02:00 PM PT
Foundation Cuts Manual Data Entry, Empowers Staff With Robotic Process Automation
Case Study
RPA tech enables lasting growth, boosts savings and frees up staff to redirect their time to meaningful strategies.

May 18, 2022