What happens if you don't have cost centres within your coding structure, can you still use formulas that require this element (e.g. cost centre)?
Please see the answer in the section below. If you require further assistance, you can either add a comment or log a support ticket here.
0 Votes
Gabrielle Day posted
about 2 months ago
AdminBest Answer
Some of the Excel Add-in formulas require specific attributes, such as cost centre, because they are designed to analyse data at that level.
If your coding structure does not use cost centres, you can use the IP.GLBaseAmount formula instead. This formula only requires legal entity, period and account as mandatory arguments. Posting attributes (such as cost centre, department, or custom attributes) are optional, so you can enter values for any attributes you do use, or omit them entirely if you have none.
Gabrielle Dayposted
about 2 months ago
AdminAnswer
Some of the Excel Add-in formulas require specific attributes, such as cost centre, because they are designed to analyse data at that level.
If your coding structure does not use cost centres, you can use the IP.GLBaseAmount formula instead. This formula only requires legal entity, period and account as mandatory arguments. Posting attributes (such as cost centre, department, or custom attributes) are optional, so you can enter values for any attributes you do use, or omit them entirely if you have none.
This query was raised during a recent webinar:
What happens if you don't have cost centres within your coding structure, can you still use formulas that require this element (e.g. cost centre)?
Please see the answer in the section below. If you require further assistance, you can either add a comment or log a support ticket here.
0 Votes
Gabrielle Day posted about 2 months ago Admin Best Answer
Some of the Excel Add-in formulas require specific attributes, such as cost centre, because they are designed to analyse data at that level.
If your coding structure does not use cost centres, you can use the IP.GLBaseAmount formula instead. This formula only requires legal entity, period and account as mandatory arguments. Posting attributes (such as cost centre, department, or custom attributes) are optional, so you can enter values for any attributes you do use, or omit them entirely if you have none.
For further reading:
0 Votes
1 Comments
Gabrielle Day posted about 2 months ago Admin Answer
Some of the Excel Add-in formulas require specific attributes, such as cost centre, because they are designed to analyse data at that level.
If your coding structure does not use cost centres, you can use the IP.GLBaseAmount formula instead. This formula only requires legal entity, period and account as mandatory arguments. Posting attributes (such as cost centre, department, or custom attributes) are optional, so you can enter values for any attributes you do use, or omit them entirely if you have none.
For further reading:
0 Votes
Login to post a comment