Skip to main content
Solved

Tran Description should be same in All Modules

  • August 4, 2026
  • 1 reply
  • 43 views

Hi , 

In GL Module the tran description has 256 Characters where in Fixed asset Module in it 512 Characters 

so could you please validate and add the point

Best answer by Rakshanda

Hi ​@Abinayatarani ,

The TranDesc field in FATran (Fixed Assets) is defined as PXDBString(256), while GLTran (General Ledger) uses PXDBString(512). This mismatch means that when a GL transaction description exceeds 256 characters and flows into the Fixed Asset module, it will be truncated.


If you want to make it 512 length you can create extension File: PX.Objects\FA\DAC\FATran.cs (Line 583)
Current:
[PXDBString(256, IsUnicode = true)]
Proposed Fix:
[PXDBString(Common.Constants.TranDescLength512, IsUnicode = true)]
Impact: Aligns the Fixed Asset module's transaction description length with the GL module (512 characters), preventing data truncation during cross-module postings.
Database Change Required: The corresponding database column FATran.TranDesc must be altered from NVARCHAR(256) to NVARCHAR(512).

Hope above helps!!

1 reply

Forum|alt.badge.img+5
  • Jr Varsity II
  • Answer
  • August 4, 2026

Hi ​@Abinayatarani ,

The TranDesc field in FATran (Fixed Assets) is defined as PXDBString(256), while GLTran (General Ledger) uses PXDBString(512). This mismatch means that when a GL transaction description exceeds 256 characters and flows into the Fixed Asset module, it will be truncated.


If you want to make it 512 length you can create extension File: PX.Objects\FA\DAC\FATran.cs (Line 583)
Current:
[PXDBString(256, IsUnicode = true)]
Proposed Fix:
[PXDBString(Common.Constants.TranDescLength512, IsUnicode = true)]
Impact: Aligns the Fixed Asset module's transaction description length with the GL module (512 characters), preventing data truncation during cross-module postings.
Database Change Required: The corresponding database column FATran.TranDesc must be altered from NVARCHAR(256) to NVARCHAR(512).

Hope above helps!!