Hello,
We are planning a major chart of account redesign in our company and I would like some information regarding the best practices with regards to the financial dimensions available in AX 2012.
For now, we actually record "Sales" in +/- 20 main accounts. Each main account is split into segments between sales category and product. The actual account structure allows us to have more details on the sales done by the company.
For e.g.
GL accounts code Description 1 Description 2 Description 3
300300400 Revenue Sales - Category 1 Product 1
300300402 Revenue Sales - Category 1 Product 2
300300403 Revenue Sales - Category 1 Product 3
300305405 Revenue Sales - Category 2 Product 4
300310410 Revenue Sales - Category 3 Product 5
300310411 Revenue Sales - Category 3 Product 6
300315415 Revenue Sales - Category 4 Product 7
From what I understand from the different information gathered is that financial dimensions are analytical fields used mainly to allow a main (natural) account to be broken down for reporting purposes.
My question is therefore, would the best practice in the above case be to create a single sales account and make use of the default financial dimensions (BU, DPT, COS) to obtain the split previously hardcoded in the GL accounts? Or would there be any reporting constraints / data entry constraints in doing so?
For e.g.
GL code Description 1 BU DPT COS
300300400 Revenue Sales - Category 1 Sales - Category 1 Product 1 / Product 2 / Product 3
300300400 Revenue Sales - Category 2 Sales - Category 2 Product 4
300300400 Revenue Sales - Category 3 Sales - Category 3 Product 5 / Product 6
300300400 Revenue Sales - Category 4 Sales - Category 4 Product 7
Also, same logic could apply to Trade Payables / Receivables which are for now broken down into specific GL accounts for the categories they represent.
On a broader scale, would you recommend any means on determining what to include or not in account segments v/s financial dimensions?
Many thanks
JY
