Cash Sales Value too long in property "AccountCode" of "PaymentAccount" - The di call #1 did fail.

[gilhan]

Dear Community,

we have two cash salereceipts that don't get posted because of this error:

"999 - Invoke of: GetBusinessObjectFromXML

Source:
Description: CServiceData::SetPropertyValueString failed, Value too long in property "AccountCode" of "PaymentAccount"

-The di call #1 did fail."

When checking the receipts in CCM there is nothing, in my opinion, wrong with the data.

Do you guys know, what could be the problem there?

Kind regards

[JoergAldinger · Accepted solution]

Hello Giano:

I suspect that you may have made the same mistake with another account, too, and that the other account is causing the "couldn't be found". Make sure you check all accounts and that in all account fields only the AcctCode is used.

After you have corrected the account codes, if you still have a remaining error, you may want to to check SAP Note 2693418, for the specific error message and follow the solutions there.

Hope this helps.

Best regards,

Joerg.

[gilhan · Accepted solution]

Hello Joerg,

okay I'll check that out.

Your help is much appreciated!
Thank you.

Kind regards

Giano

[JoergAldinger]

Hello Giano,

Yes, always use only the value from the AcctCode field.

Best regards,

Joerg.

[gilhan]

Hello Joerg,

so I just tried to push the receipt with the "Transit Account" value being only 8711. But then I'll receive an error that this account couldn't be found.

When I insert the data which was automatically filled in, I'll receive the Error from which this post started.
Transit Account Field looks like this in the receipt: 8711: AcctName

[JoergAldinger]

Hello Giano:

34 characters can't be right, since the maximum is 15. Check the value you are using with this query:

SELECT "AcctCode", "FormatCode", "AcctName" FROM OACT

Make sure you are using the AcctCode, not the FormatCode.

Hope this helps.

Best regards,

Joerg.

[gilhan]

The "Transit Account" from said receipts has an AcctCode of "8711".
But with Name it is much longer.
Does posting receipts only go by AcctCode?

Then it wouldn't be too long I guess?

Thank you!

[JoergAldinger]

Hello Giano,

Clearly during the DI call a string is set to the AccountCode of PaymentAccount (that refers to the detail section in a payment of type account) that is longer than 15 characters.

You could find out what exactly is being set by looking at the DI Proxy log. You should find the final XML being posted there (default directory is C:\Program Files (x86)\sap\SAP Business One Integration\DIProxy\log).

But guessing from the type of operation, I would suggest you double-check the configuration under "Petty cash accounts" in CCO, you might find a wrong account definition there.

Hope this helps.

Best regards,

Joerg.

[gilhan]

Hey Joerg,

I will check that out and report back.
Thank you for your help!

[gilhan]

Hello Joerg,

I can't get access to the POS, because it is in use right now.

I've checked the receipts one more time in the CCOm:

Payment Mode: out

Transit Account: Has 34 characters (also in SAP Business One in chart of accounts obviously)

Could that be too long? And how could I make that work instead of making it shorter?

Your help is much appreciated!

Kind regards

Giano