Hello Experts,
I have been trying to increase the length of the Account field in the Chart of Accounts form using Segmented Keys (CS202000) form. But seems like the Max Length is only limited to 10 characters. Is there any possibility to increase the Max length to 20+ characters.
Kindly let me know how to achieve this.
Thanks in advance.
Best answer by aaghaei
View originalAn update: We can increase the length to 30 characters, but not able to figure out how shall I increase the same.
+8
To increase the length of Account both the AcctCD field length in DB and in Segments should be increased
Kindly refer the below article.
And changing the Account length of Account and AccCD in DB is also not recommended as it will have impact on so many screen and transactions.
https://www.augforums.com/forums/everything-else/maximum-length-of-gl-segments/
Regards
Ram
+8
For the sake of clarification and avoid misleading information, it is true that Account & Subaccount are used in almost every single Acumatica screens but what all screens are referring to is the surrogate key (AcctID) not the natural key (AcctCD) which it’s length is going to be increased. The number of screens referring to Account is completely irrelevant.
it doesn’t mean I approve or recommend lengthy Account Codes but it also won’t cause technical issues
+18
Reza, do we need to be concerned about account code being too wide? If account number is too long, it will be chopped off , not clearly visible in many screens and reports. We won’t be able to see to what account transactions were posted without many screen and report customizations to widen account field. Maybe number if fields to widen in many screens and reports is the impact Ram is talking about.
+8
Thank you
Not necessarily. We typically enter accounts in grids in which case the length can easily be adjusted if needed by user without customization. Even if accounts are entered using form selector controls still accounts won’t be chopped. The form account selector controls typically are wide enough to show both code and desc. When code increases will leave less space for Desc only.
as for reports there might be very few requiring adjusting.
I repeat I do not recommend lengthy codes but also it won’t cause technical issues like some other fields may cause. For example if someone wants to increase RefNbr field in AR or AP I would say stay far from it as it will result many subsequent changes at Database Level but not for Account or Subaccount
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
