Posts tagged with: modules in ax 2012

Time and Material Project – B/S Scenario

MS Dynamics AX 2012 Project Management and Accounting Module leverages different types of projects and its respective accounting treatment based on the given project types and different setup options like Project Group, Line Properties etc.

Time and Materials Project is mainly used where costs can be matched with revenue on each transaction and project in invoiced as work progresses. Possible capitalization related accounting treatments are described below in the form of relevant accounting entries:

Ledger Posting Scenarios –  Capitalization

Setup > Posting > Project Groups

1

 

Setup > Line Properties > Line Properties

2

 

Note: Where Chargeable is not selected on Line Property, Ledger Transactions at the time of Invoice Posting will not occur. Rest will stay the same

Hour Journal 
At the time of posting hour journal
WIP Cost Value
  Payroll Allocation
At the time of Invoice Posting
Summary Account (AR)
   Invoiced Revenue
Project Cost
  WIP Cost Value
Expense Journal 
At the time of posting Expense Journal
WIP Cost Value
    Offset Account (Mentioned at the time of posting journal line)
At the time of Invoice Posting
Summary Account (AR)
   Invoiced Revenue
Project Cost
   WIP Cost Value
 Item Journal

 

At the time of posting Inventory Journal
WIP Cost Value Item
   Inventory Issue (Inventory Module)
At the time of Invoice Posting
Summary Account (AR)
   Invoiced Revenue
Project Cost
   WIP Cost Value Item

 

Ledger Posting Scenarios – No Capitalization

Setup > Posting > Project Groups

3

 

Setup > Line Properties > Line Properties

4

 

Note: Where Chargeable is not selected on Line Property, Ledger Transactions at the time of Invoice Posting will not occur. Rest will stay the same

Hour Journal 
At the time of posting hour journal
Project Cost
  Payroll Allocation
At the time of Invoice Posting
Summary Account (AR)
   Invoiced Revenue
Expense Journal 
At the time of posting Expense Journal
Project Cost
    Offset Account (Mentioned at the time of posting journal line)
At the time of Invoice Posting
Summary Account (AR)
   Invoiced Revenue
 Item Journal

 

At the time of posting Inventory Journal
Project Cost
   Inventory Issue (Inventory Module)
At the time of Invoice Posting
Summary Account (AR)
   Invoiced Revenue

 


Time and Material Project – P&L Scenario

MS Dynamics AX 2012 Project Management and Accounting Module leverages different types of projects and its respective accounting treatment based on the given project types and different setup options like Project Group, Line Properties etc.

Time and Materials Project is mainly used where costs can be matched with revenue on each transaction and project in invoiced as work progresses. Possible accounting treatments are described below in the form of relevant accounting entries:

Ledger Posting –  Accrual Scenarios

Setup > Posting > Project Groups

1

 

Setup > Line Properties > Line Properties

2

 

Note: For all accrual scenarios, it is assumed that Line Properties > WIP Posting > Accrue Revenue is checked. If this option is not selected, Accrual Ledger posting will not occur. Where Chargeable is not selected on Line Property, Ledger Transactions at the time of Invoice Posting will not occur. Rest will stay the same

Hour Journal
 At the time of posting hour journal
Project Cost
  Payroll Allocation
WIP – Sales Value
     Accrued Revenue – Sales Value
At the time of Invoice Posting
Summary Account (AR)
   Invoiced Revenue
Accrued Revenue – Sales Value
   WIP – Sales Value
Expense Journal
At the time of posting Expense Journal
Project Cost
    Offset Account (Mentioned at the time of posting journal line)
WIP – Sales Value
     Accrued Revenue – Sales Value
At the time of Invoice Posting
Summary Account (AR)
   Invoiced Revenue
Accrued Revenue – Sales Value
   WIP – Sales Value
Item Journal
At the time of posting Inventory Journal
Project Cost
   Inventory Issue (Inventory Module)
WIP – Sales Value
   Accrued Revenue – Sales Value
At the time of Invoice Posting
Summary Account (AR)
   Invoiced Revenue
Accrued Revenue – Sales Value
  WIP – Sales Value

Fee Journal
At the time of posting Fee Journal
WIP – Sales Value
   Accrued Revenue – Sales Value
At the time of Invoice Posting
Summary Account (AR)
   Invoiced Revenue
Accrued Revenue – Sales Value
    WIP – Sales Value

 

 

Ledger Posting Scenarios –  No Accrual

Setup > Posting > Project Groups

3

 

Setup > Line Properties > Line Properties

4

 

Note: Where Chargeable is not selected on Line Property, Ledger Transactions at the time of Invoice Posting will not occur. Rest will stay the same

Hour Journal 
At the time of posting hour journal
Project Cost
  Payroll Allocation
At the time of Invoice Posting
Summary Account (AR)
   Invoiced Revenue
Expense Journal
At the time of posting Expense Journal
Project Cost
    Offset Account (Mentioned at the time of posting journal line)
At the time of Invoice Posting
Summary Account (AR)
   Invoiced Revenue
 Item Journal 
At the time of posting Inventory Journal
Project Cost
   Inventory Issue (Inventory Module)
At the time of Invoice Posting
Summary Account (AR)
   Invoiced Revenue
Fee Journal
At the time of posting Fee Journal
No Ledger Posting
At the time of Invoice Posting
Summary Account (AR)
   Invoiced Revenue

 


Division of Modules in Microsoft Dynamics AX 2012

A few modules in the Microsoft Dynamics AX 2009 have been divided into sub-modules in Microsoft Dynamics AX 2012. The modules in Microsoft Dynamics AX 2009 and their division into the sub-modules in Microsoft Dynamics AX 2012 are listed below:

AX 2009 Module AX 2012 Module
Bank Cash and Bank Management
Accounts Payable Accounts Payable

Procurement and Sourcing

 

Accounts receivable Accounts receivable

Sales and Marketing

 

General Ledger General Ledger

Fixed Assets

 

Inventory Management Product Information

Inventory and Warehouse management

 

Production Production Control

 

Expense Management Travel and Expense management

 

Project Project management and Accounting

Compliance and Internal Control