Good morning,
We are experiencing an issue running the AR Customer aging report. Unless the "Exclude zero balance accounts" parameter is checked on, the report run will fail with the following.
Message (06:48:37 am)
Cannot execute a data definition language command on Calculated result of aging process (CustVendAgingCalculatedTmp).
The SQL database has issued an error.
SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]String or binary data would be truncated.
SQL statement: INSERT INTO tempdb."DBO".t104017_540ADBAD7D644158BAEFD021FDBBF5C9 (ACCOUNTNUM,TXT,RECVERSION,PARTITION) SELECT T1.ACCOUNTNUM,T1.NAME,1,5637144576 FROM tempdb."DBO".t12143_369C81839C1E43DAB23CB384D1BD2865 T1 WHERE (T1.PARTITION=5637144576) AND NOT (EXISTS (SELECT 'x' FROM tempdb."DBO".t104017_F69B0013ACDC4FAABE860D445BF38A54 T2 WHERE ((T2.PARTITION=5637144576) AND (T1.ACCOUNTNUM=T2.ACCOUNTNUM))))
The failure only happens when running the Customer aging report in a particular company; all other companies work fine regardless of whether the "Exclude zero balance accounts" check box is checked or not.
I tracked down the 'zero balance' param controlling an insert_recordset statement in CustAgingCalculation.postProcess() but I'm not sure what it does. I removed the insert portion of the statement and printed out the name and text. From what I can tell, the company with the issue may have issues with special characters (e.g., '#') in the data. I'm still looking through the infolog output trying to find a pattern but if anyone can offer any thoughts I'd appreciate it.
Thank you.
*This post is locked for comments
I have the same question (0)
