Khurramshaikh47
Member
- Local time
- Today, 05:56
- Joined
- Aug 19, 2021
- Messages
- 212
Hi, I want to Concatenate 2 fields to make a separate Code for each account in chart of account.
I have a fields:
1) ID containing numbers 0001, 0002, 0003 etc
2) AGCode (AccountGroup Code) containing 11, 12, 13, 21, 22 etc this is a code to Identify each Account Group such as Current Asset, Fixed Asset, Current Liability etc.
3) COACode (ChartOfAccount Code) this is the field in which I am trying to apply an expression to generate separate code for each head of account for general ledger.
The Code I am trying is:
and Output for the above code is:
11.1, 11.2, 11.3, 21.1, 21.2 etc.
While my desired output is:
11.0001, 11.0002, 11.0003, 21.0001, 21.0002 etc.
Please guide me how to change its output to 11.0001 to 11.1
Thank you
I have a fields:
1) ID containing numbers 0001, 0002, 0003 etc
2) AGCode (AccountGroup Code) containing 11, 12, 13, 21, 22 etc this is a code to Identify each Account Group such as Current Asset, Fixed Asset, Current Liability etc.
3) COACode (ChartOfAccount Code) this is the field in which I am trying to apply an expression to generate separate code for each head of account for general ledger.
The Code I am trying is:
Code:
[AGCode] & "." & [ID]
and Output for the above code is:
11.1, 11.2, 11.3, 21.1, 21.2 etc.
While my desired output is:
11.0001, 11.0002, 11.0003, 21.0001, 21.0002 etc.
Please guide me how to change its output to 11.0001 to 11.1
Thank you
Last edited: