Skip to main content
Question

Increase length of account group field

  • Nov 12, 2026 10:31 PM UTC
  • 0 replies
  • 5 views
  • Translate All

Goal 

Allow Account Group IDs (ACCGROUP segmented key) of up to 30 characters. 

 

Problem 

On Segmented Keys (CS202000), ACCGROUP shows Max Length = 10. 

Setting Segment 1 Length to 30 and saving returns: "Error: Updating 'Dimension' record raised at least one error. Please review the errors. The key length is greater than the maximum allowed value." 

 

What we have done (customization project FSAcctGroupCD30, published 2026-11-12) 

1. Database Scripts > Increase Column Length: PMAccountGroup.GroupCD from String(10) to 30. The Column Length Increase dialog now reports the column as String(30). 

2. Data Access > PMAccountGroup.GroupCD: Replace Original attributes, changing only the string attribute to [PXDBString(30, IsUnicode = true, IsKey = true, InputMask = "")] The original attribute had no explicit length. All other attributes (PXDimensionSelector, PXDefault, PXUIField, PXFieldDescription) are unchanged. 

3. Published. Max Length on CS202000 for ACCGROUP still shows 10. 

 

Findings from the Source Code screen (SM204570) 

- DimensionMaint (PX.Objects.CS) sets Dimension.MaxLength from PXDimensionAttribute.GetMaxLength(...) in Dimension_RowSelected (line 282) and validates against it in Dimension_RowUpdating (line 271). 

- AccountGroupRawAttribute is declared [PXDBString(30, IsUnicode = true, ...)], so the business code allows 30. 

- Other fields registered to ACCGROUP via PXDimensionSelector (Account.AccountGroupID, PMCostProjection, PMDateSensitive, PMForecastDetail) are integer ID fields with no string length. 

- Request Profiler showed no SQL against Dimension or Segment when CS202000 loads, so the value appears to come from cached or compiled metadata. 

 

 Questions 1. What source does PXDimensionAttribute.GetMaxLength use to return 10 for ACCGROUP? 

2. Is there a supported way to raise the ACCGROUP maximum length to 30 (customization, configuration or other)? 

3. If not, are there known limits elsewhere in Project Accounting that would prevent a 30-character Account Group ID?