Wiki source code of 9.4 Account Codes

Last modified by Admin User on 2023/06/30 10:26
Hide last authors
Admin User 1.1 1 {{box cssClass="floatinginfobox"}}
2 {{toc/}}
3 {{/box}}
4
5 Account Codes consist of an **Account Code Value** (usually a numeric account code value) and an **Account Code Description** (usually a text description of the value) and are separated by a hyphen when displayed.
6
7 For example if the cost centre code for the purchasing department is 1020 it will be displayed in PECOS P2P as: ‘1020 – Purchasing’. Here 1020 represents the account code// **value**// and Purchasing represents the account code// **description**//.
8
9 Rules relating to values:
10
11 * The value can be alpha-numeric.
12 * ‘Child’ values are validated within each ‘Parent’ segment. A value can therefore only exist once for each valid combination of codes.
13 * Descriptions can be duplicated.
14 * Only descriptions can be edited: values cannot.
15 * Values are passed through onto the APExport interface.
16
17 Each user is assigned a default account code combination consisting of one value for each segment within a method.
18
19 = Adding Account Codes =
20
21 In the **Financial Tracking Maintenance **page:
22
23 1. Select **+ add new value +** from the **Account Code Value - Description** drop down box. The ‘//add account code value’// fields will appear on the right of the screen.
24 [[image:PECOS Admin.WebHome@Fig 8.7 - Add a new account code to a segment.png]]
25 1. Enter the new account code details in the** Account Code Value **(the code number) and **Account Code Description** (the code name) fields.
26 1. Click **Save**. Your new account code will be added and displayed.
27
28 = Editing Account Codes =
29
30 In the **Financial Tracking Maintenance **page:
31
32 1. Select the name and description from the **Account Code Value – Description **drop down box.
33 1. Click the** Edit** button. The ‘//Edit Account Code Value’// fields will open to the right of the screen.
34 [[image:PECOS Admin.WebHome@Fig 8.8 - Edit an account code value.png]]
35 1. Make your change in the **Account Code Description** field. Note that the Account Code Value (code number) cannot be changed.
36 1. Click **Save**.
37
38 = Deactivating Account Codes =
39
40 Before deactivating an accounting value you must check to see if it is used as a default value anywhere in your configuration. It may be assigned to one of the following:
41
42 1. Used as a user’s default account code and therefore assigned to a Business Rule Group.
43 1. A default assigned to a Procurement Card through Procurement Card Financial Tracking.
44 1. A default assigned to a Product Classification Code through Commodity Accounting.
45
46 These defaults **MUST** be changed and updated before deactivation. Failure to do so will result in application errors.
47
48 The effect of deactivating an account code value will be to remove it from all user’s selection options and it will appear bracketed in the Account Code Value drop down box in the Financial Tracking Maintenance page.
49
50 Deactivated account codes DO NOT have any affect on existing requisitions and orders and DO NOT therefore affect accounting retrospectively.
51
52 **Deactivation Steps**
53
54 1. Select the name and description from the **Account Code Value – Description **drop down box.
55 1. Click the** Edit** button. The **Edit Account Code Value** fields will open to the right of the screen.
56 1. To deactivate a value, check the **Deactivate **box.
57 1. Click the **Save **button.
58 1. To reactivate a value, simply remove the check from the **Deactivate** box.
59
60 If the following message is displayed after deactivation, the deactivated value is in use **as a default** and errors may be experienced.
61 [[image:PECOS Admin.WebHome@Fig 8.9 - Account code deactivation warning message.png]]
62
63 If this is the case it is advisable to reactivate the account code value and change the default assignment(s) before deactivation is reattempted.
64
65 **When modifying account code values, be aware that they cannot be deleted from the system, only deactivated. This is to ensure that historical data for financial reporting is not corrupted.**
66
67 = Wildcard Edits =
68
69 A wildcard can be used to view and edit values within any **child** segment.
70
71 Select **% Any Value %** from the **Account Code Value – Description** dropdown list for the **parent** segment of the segment for which you wish to edit account code values. PECOS P2P will ‘wildcard’ this segment and temporarily override any parent/child relationship. All values will appear for editing purposes within subordinate account code value drop down lists and any duplicate values will appear only once. Edits will apply globally to all child values without the need to select each individual parent value.
72
73 This permits convenient enterprise-wide administration by allowing you to make changes to child segments that are used, for example, by multiple parent department segments in the accounting method.
74
75 **Wildcard Example**
76
77 A method contains two segments: Region and Department, Region being the parent of the Department. Each of the four geographic regions has its own sales department, coded as 1060.
78
79 |**Segment – Region**|**Segment – Department**
80 |100 - Eastern|1020 – Central Purchasing
81 ||1050 – Finance Department
82 ||1060 – Sales
83 |200 - Northern|1030 – Marketing Department
84 ||1060 – Sales
85 |300 - Southern|1060 – Sales
86 |400 - Western|1060 – Sales
87 ||1070 – Warehouse Operations
88
89 To apply changes to the **Finance Department** code, you would work conventionally, without wildcards.
90
91 * Within the **Region** segment select: Eastern.
92 * Within the **Department **segment the values for Purchasing, Finance and Sales will appear. Select ‘1050 – Finance’ and click the **Edit **button.
93 * **Edit** and **Save**.
94
95 To apply changes to **ALL Sales Departments** for the four regions we can use the **wildcard**.
96
97 * Within the** Region** segment select: **% any value %**.
98 * Within the **Department** segment ALL values will appear. Because all Sales departments have the same value it will be displayed only once. Select ‘1060 – Sales’ and click the **Edit** button.
99 * **Edit **and **Save**.
100 * All four Sales department values will be updated.
© Elcom Systems Ltd 2025