'Ledger posting setup' and 'Project/group line properties'

Below mentioned are the steps that needs to be followed for configuring the ledger setup and line property setup against the project group and categories / category group.

Ledger posting setup

1.      Define the project group

a.      Assumption:

                                                    i.     Ledger posting search direction – Project

                                                   ii.     Line property search direction - Project

2.      Define the ledger codes on the project group, if you are certain.

(This will create following rules in ‘Ledger posting setup’:

-        “Group-Project group-All-BLANK -> Ledger code” rule)

       

3.      Get the list of categories

4.      Get the Chart of Accounts and analyse it well

5.      Define the basic rules of posting against the categories and category groups

(Configure the ledger codes against the categories. This will create following rule in ‘Ledger posting setup’:

-        “All-BLANK-Table-Category -> Ledger Code” rule AND

-        “All-BLANK-Group-Category group -> Ledger Code”)

6.      Define the override rules against the project group

(This will create following rule in ‘Ledger posting setup’:

-        “Group-Project group-Table-Category -> Ledger code” rule AND

-        “Group-Project group-Group-Category group -> Ledger code”)

 Project / group line properties

1.      Define the basic line properties initially, like ‘Billable’ and ‘Non-billable’.

-        Billable -> Chargeable, Accrue revenue and Capitalise cost = CHECKED

-        Non-Billable -> Chargeable, Accrue revenue and Capitalise cost = UN-CHECKED

2.      For all the overrides create new line properties and define the specific rules in the matrix, keeping in mind the search priority.

3.      Line property (Default line property) defined on the ‘Category’ and ‘Category group’ will create following entries in the ‘Project / group line properties’:

  

4.      Line property (Default line property) defined on the ‘Project group’ will create following entry in the ‘Project / group line properties’:

5.      Line property overrides will be defined directly in the ‘Project / group line properties’. This will give rise to following entries in ‘Project / group line properties’:

General points

1.      For the expense transactions specifically, ‘Default offset account for expenses’ needs to be setup.

2.      With all the steps above, the heart of project module, the ledger posting setup combined with line property could be setup. Make use of the ‘Line property’ setup (Capitalise cost checkbox) to maximise the use of the category, instead of creating specific categories for posting into P&L and BS.

3.      While following all the steps above make sure that the entire posting tie down to the solution that is crafted. Play the solution (accounting entries) in mind while configuring this setup in an excel sheet.

4.      Do not assume that the ‘Ledger posting setup’ will work as designed. Sometimes the setup does not work as expected and hence test each and every scenario in standard AX in your own VPC.

This post will be updated as and when some new insights are experienced while doing this setup in any future projects / assignments.

Thanks

Sarang