Finance | Project Operations, Human Resources, ...

A row created in data set LedgerJournalLines was not published. Error message: 'Write failed for table row of type 'LedgerJournalLineEntity'. Infolog: Warning: validateWrite failed on data source 'LedgerJournalTrans (LedgerJournalTrans)

(0) Share

Report

Posted on by Andres

When I try to import a General Ledger using EXCEL addons the EXCEL shows this message after using the "Publish" button. I try to import lines related to projects. When I use as account and offset account "Ledger" this works, but if I change the "offset account type" to project this doesn't work. To try to solve I create a general journal whit the configuration that I need (Account = Ledger and Offset account = project) and export using "OPEN IN EXCEL" function, but if I made any change in this line or create other exactly line, the system show me the error mesaje.

All responses (2)

Answers (0)

Diegocruz 5 on at

Like (0)

Report

RE: A row created in data set LedgerJournalLines was not published. Error message: 'Write failed for table row of type 'LedgerJournalLineEntity'. Infolog: Warning: validateWrite failed on data source 'LedgerJournalTrans (LedgerJournalTrans)

Dear community!

We have this issue:

A row created in data set General_Journals_Excel was not published. Error message: 'Control 'VAT Reporting Date' is read-only. CorrelationId: ec3322b7-bb48-4843-ada6-f2a22ccc4d81.'

Thanks!
Suggested answer

Michal Krejza on at

Like (0)

Report

RE: A row created in data set LedgerJournalLines was not published. Error message: 'Write failed for table row of type 'LedgerJournalLineEntity'. Infolog: Warning: validateWrite failed on data source 'LedgerJournalTrans (LedgerJournalTrans)

Hi Andres,

Similar question was raised to Microsoft support team for Fixed asset offset. Unfortunately current design of General journal line entry template doesn't support every account type.

FinOps:554105 - Excel add-in doesn't allow user to Publish a GL journal line with Account Type of Fixed assets (using 'General journal line entry' template)