Trial Balance

(0) Share

Report

Posted on by Muthusamy

Hi All,

Environment : D365 F&O Version 10.0.6 PU30.

We are using Vendor, Customer and Project as financial dimensions. It's working fine, When calculating the Trial Balance by using Main account and Main Account + Vendor and Main Account + Customer.

But, I am getting the below error when calculate the Trial balance by Main Account + Project Combination.

session 1025 (Admin)

UPDATE tempdb."DBO".t12042IISdev85ac10b8fa146528_C3683F93651C4DA18E71D08450782412 SET DIMNAME2 = DimAttributeProjTable.Name FROM DimAttributeProjTable WHERE tempdb."DBO".t12042IISdev85ac10b8fa146528_C3683F93651C4DA18E71D08450782412.DIMENTITYINSTANCE2 = DimAttributeProjTable.KEY_ AND DimAttributeProjTable.PARTITION = 5637144576 AND tempdb."DBO".t12042IISdev85ac10b8fa146528_C3683F93651C4DA18E71D08450782412.PARTITION = 5637144576

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]String or binary data would be truncated.

Object Server Azure:

Cannot execute the required database operation. The SQL database has issued an error.

Its throwing error on when selecting Project Id combination. I guess that, Issue is because of few Project id's having the Symbol of hyphen "-". For e.g. P3507-AB

Earlier COA delimiter was hyphen "-". Now, I have changed the COA delimiter as bar symbol "|". After that, I can see all the vouchers are updated as like delimiter with Symbol "|".

Then, cleared the existing balances and then rebuild (created & Updated) the balances by using Financial dimension sets. Still getting the same error.

Please provide your views to resolve the issue.

Thanks

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I would recommend contacting the MS support. what you describe sounds like a bug.

best regards

ludwig

Was this reply helpful? Yes No
Suggested answer

Sheela Ningappa Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Check the string size on “DimAttributeProjTable.Name . Also, check the AOT node Extended Data Type Extensions for any extensions on “ProjName” that could have increased the size.

However, this large ProjName EDT could cause problems within Project code.

Regards,

Sheela

Support Engineer for D365 F & O

Was this reply helpful? Yes No
Muthusamy 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Ludwig,

yes, we will try to solve it. If not possible, will raise a MS ticket.

Hi Sheela,

Yes, ProjName EDT is extended with the string size of 120. Actually In Standard, it is 60 only.

In development server, there is no issue. Its working fine. In Testing server, getting the issue..

Do i need to remove the extension ? Or we can solve this issue without removing extended edt. What is the best way?

Thanks,

Was this reply helpful? Yes No
Crispin John Augustine 37,081 on at

Like
a
(0)

Report
Copy link

Link copied!

The part of the error message "...String or binary data would be truncated...." could only confirm that.

So, if you increased the string size of a standard field, you need to make sure, it is also increased across the system, including variables / fields where it is assigned to:

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,059 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Muthusamy,

We also faced similar kind of issue by changing the COA delimiter. We contacted Microsoft and they resolved.

They found that as bug that time.

Was this reply helpful? Yes No
Suggested answer

Sheela Ningappa Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I would suggest to log an support incident.

Was this reply helpful? Yes No
Suggested answer

Muthusamy 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi All,

Issue is resolved.

Solution: Extension of DimensionFocusNameTmp.DimName2 extended data type, DimensionValueName, to increase the size to 250 instead of 100. Size increased as equal to the project name EDT size.

Thanks for all your suppport.

Regards,

Was this reply helpful? Yes No