Hi,
I want to increase the Segment length of the the Subaccount from the current Value, however I’m facing the Below
Errror: “Updating 'Segment' record raised at least one error. Please review the errors. Segment '1' has values and cannot be updated”.
I have deleted the existing Segment Values to be able to try this & re-import them. However the Default vlue get saved automaticaly.
What’s the best approach to increase the Segment Length for the Subaccounts.
Thanks!
Best answer by Rakshanda
Hi
Acumatica deliberately restricts changing the length of an existing segment via the UI because:
SegmentValue table): Values already exist for DimensionID = 'SUBACCOUNT' and SegmentID = 1.Sub table): Subaccount IDs are stored as segmented strings (or mapped to specific segment positions). Changing segment length alters parsing and key formatting for all existing subaccount records.Depending on whether this is an active production environment or a development/testing environment, you have a few ways to resolve or work around this:
If business requirements allow:
CS202000).SUBACCOUNT.1 as it is, and click + (Add Row) to add Segment 2 (or a subsequent segment) to cover the extra length needed.If this is a new setup, sandbox, or subaccount values were entered by mistake and no GL transactions / history reference these subaccounts:
CS203000) screen.SUBACCOUNT and Segment 1.GL203000) and verify no subaccount records exist (delete them if empty/unused).CS202000), select SUBACCOUNT, and update the length.Hope above helps!!
+8
Please create a new one.Once Segment 1 of the SUBACCOUNT segmented key already has values, Acumatica does not allow changing that existing segment length from Segmented Keys (CS202000). The reason is that existing subaccount values and posted/historical GL references depend on the current segment structure. Acumatica documentation notes that segment values are controlled by the segment length defined in Segmented Keys, and existing values remain tied to that setup.
Hi
Acumatica deliberately restricts changing the length of an existing segment via the UI because:
SegmentValue table): Values already exist for DimensionID = 'SUBACCOUNT' and SegmentID = 1.Sub table): Subaccount IDs are stored as segmented strings (or mapped to specific segment positions). Changing segment length alters parsing and key formatting for all existing subaccount records.Depending on whether this is an active production environment or a development/testing environment, you have a few ways to resolve or work around this:
If business requirements allow:
CS202000).SUBACCOUNT.1 as it is, and click + (Add Row) to add Segment 2 (or a subsequent segment) to cover the extra length needed.If this is a new setup, sandbox, or subaccount values were entered by mistake and no GL transactions / history reference these subaccounts:
CS203000) screen.SUBACCOUNT and Segment 1.GL203000) and verify no subaccount records exist (delete them if empty/unused).CS202000), select SUBACCOUNT, and update the length.Hope above helps!!
+14Hi
Since you have already deleted the existing values, I recommend checking whether any subaccounts are still using this segment and investigating why the default value is being recreated automatically.
If the segment is still in use, increasing its length may not be supported without addressing those dependencies.
As an alternative, consider adding a new segment to the SUBACCOUNT structure, provided it meets your business requirements.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
