DTW Error [OACT.Postable] Field cannot be updated (ODBC -1029)

[Former Member]

Hi,

I want to change a number of GL accounts from Active Accounts to Title Accounts using DTW.

My template is simple. The first 5 rows look like this:

Code ActiveAccount
AcctCode Postable
101 N
102 N
103 N

I get the error message [OACT.Postable], Field cannot be updated (ODBC -1029) when I try to do the update via DTW.

I can change the accounts in SAP manually to Title accounts without error. For the accounts that I changed manually, when I run the DTW it works successfully for these codes only.

I have tried replacing 'N' with 'tNo' which results in the error 'Exception from HRESULT: 0xFFFFFC1765171'

I have removed all GL determinations and control account tags which may prevent an account being changed to title.

This is a blank database so no transactions have been posted.

Any ideas?

Thanks,
Josh.

[ANKIT_CHAUHAN · Accepted solution]

Hi All,

This is currently a limitation of DI API and it has been registered as a future version candidate (FVC).

Kind regards,

ANKIT CHAUHAN

SAP SME Support

[pter_forr · Accepted solution]

Hi Ankit,

Thank you very much for the information.

[pter_forr]

I have the same problem. This is also a blank database without any transaction posted, and I am not able to turn active accounts to title accounts.

Happening with 9.2 PL06

[agustin_marcoscividanes]

Hi

I think you want to disable these accounts. Use the field Validfor.

The field you want to use indicates if the account is a title or an account with journal entries. If the account has journal entries SBO does not allow to change.

Kind regards

Agustín

[Former Member]

Hi Agustin,

I don't want to disable the accounts, I want to turn them into title accounts.

As per my original post, there are no transactions in the database so this is not the problem. I can change the accounts inside the client but get the error when I try to make the change via DTW.

Thanks,
Josh.

[kothandaraman_nagarajan]

Hi,

Please advice SAP version and PL.

Regards,

Nagarajan

[Former Member]

9.20.110 PL:01