 |
| ||||||||
How do I make an accounting field visible and required for all account categories in SAP ERP sites?
In order to make an accounting field visible and required for all account category values, you need to update the FAUS1 column of the AccountCategory.csv file (Import Account Categories task). The FAUS1 column represents the field status group strings, which determine the accounting fields to display and require for a particular account category value.
The following tables indicate the position within the string that represents each accounting field and the character that dictates the behavior of each accounting field for that account category.
Note: The string positions are defined in the FieldStatusToAccountingFieldNameMapExport.csv file, which you load using the Import Field Status To Accounting Field Name Mapping task. Your site might have custom accounting fields defined in an unused string position.
| Accounting Field | String Position |
| Cost center | 10 |
| Internal order | 11 |
| WBS element (project) | 12 |
| Network | 19 |
| Asset | 24 |
| Activity Number | 60 |
| General ledger (GL account) | 51 |
| Character | SAP ERP | Ariba Procurement Solution |
| + (plus sign) | Required entry | Displays the field and requires user input. |
| . (period) | Optional entry | Displays the field, and you can decide whether to change it. |
| * (asterisk) | Display | Does not display this field because it does not require user input. |
| - (minus sign) | Suppressed | Does not display this field because it is not relevant. |
The default configuration for the AccountCategory.csv file follows. If you examine the tenth character position within each row of the file, the character that represents the cost center accounting field is marked with a plus (+) sign only for account category K.
UTF8
KNTTP,KNTTX,FAUS1
A,Asset,----------**-----------+--------.-----------------*...-...............
F,Order,---------..-------.-------------.-----------------+-..-...............
K,Cost center,---------+.---------------------.-----------------+-..-...............
P,Project,-----------.------.-------------.-----------------+-..-...............
If you want to make the Cost Center field visible and required for all account category values, update the tenth character to a plus (+) sign for each account category.
UTF8
KNTTP,KNTTX,FAUS1
A,Asset,---------+**-----------+--------.-----------------*...-...............
F,Order,---------+.-------.-------------.-----------------+-..-...............
K,Cost center,---------+.---------------------.-----------------+-..-...............
P,Project,---------+-.------.-------------.-----------------+-..-...............
This change ensures that all requisition line items have a cost center, meaning that any approval rules that are based off the line-item cost center value always add the appropriate approver to the approval flow.
The requirement settings for the following assignment category entries are fixed. The entries are always required, regardless of the requirement setting in the FAUS1 field.
- Asset: Asset Number
- Order: Internal Order, GL Account, Asset, and Sub Asset
- Cost Center: Cost Center, GL Account
- Project: WBS Element, GL Account
- Network: Network, Activity Number
- Unassigned: Unknown account assignment
Please refer to documentation for further details.
In order to make the Activity Number field mandatory for the Network Account type, the below entry has to be added to the FieldStatusToAccountingFieldNameMap.csv file.
"UTF-8"
UniqueName,Name,Description
"060","ActivityNumber","Activity Number"
Core Procurement > Core Administration > Core Accounting
Purchasing > Requisitioning > Requisitioning Accounting