Account issue for while creating customer journal payment line through data entity - OData service.

(0) Share

Report

Posted on by JAYAKRISHNAN M S

145

Hi experts,

Am a newcomer in AR module. I am try to create the customer journal payment lines through OData services ended up with the following error.

Error says the incompactable account display value. I am used the 'Account type' as 'Customer'. Then I don't know why any specific structure needed and I checked the 'Financial dimension configuration for integrating applications' section and noticed the ledger dimension format like this : MainAccount-BusinessUnit-CostCenter-Department. So How we set the ledger dimension for a customer?

Here is my code,

How we provide the 'Account DisplayValue' through OData service?

Any help would be greatly appreciated.

Thank you.

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Suggested answer

saurabh bharti 15,059 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

It seems you have not defined this setup:

Here you define the "default dimension" sequence for sub ledger and ledger both in the same sequence in which you are importing data.

This should be activated. One for ledger and one for subledger.

Was this reply helpful? Yes No
JAYAKRISHNAN M S 145 on at

Like (0)

Report
Copy link

Link copied!

Saurabh Bharati,

Thanks for quick response.

Am try to create customer journal payment lines via OData service. Not through import. Are you understand the question?

Was this reply helpful? Yes No
Verified answer

WillWU 22,363 on at

Like (1)

Report
Copy link

Link copied!

Hi JAYAKRISHNAN,

You have to set up in the "Financial dimension configuration for integrating applications" that mentioned by Saurabh, and the format must match the value that you feed.

See the blog:

shankarsbiztalk.wordpress.com/.../

Hope this helps.

Was this reply helpful? Yes No
JAYAKRISHNAN M S 145 on at

Like (0)

Report
Copy link

Link copied!

Dear Will WU,

Thanks for the response.

I updated the question with what I had tried in 'Account type'.

So the customer doesn't need any structure, am I right? I am created the lines without account type and it showed 'Customer' as default after creation.

Was this reply helpful? Yes No
Verified answer

SouravDam 11,732 on at

Like (1)

Report
Copy link

Link copied!

Hello JAYAKRISHNAN M S,

Can you try with data management by importing excel after filling all the relevant data for customer payment journal and see if this is working fine or not.

In that excel, please maintain the DefaultDimensionDisplayValue in this format '-BU-CC-DP and upload the data.

For example;

Customer - C001
Business unit - B01
Cost center - C01
Department - D01

Then in Account type is "Customer"; AcountDisplayValue is C001 and DefaultDimensionDisplayValue is '-B01-C01-D01

Kindly check and update us.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
JAYAKRISHNAN M S 145 on at

Like (0)

Report
Copy link

Link copied!

Dear Sourav Dam,

I am double checked with the structure you provided and before also. Finally provide the 'AccountType' into 'Customer' and the error suppressed automatically.
On default creation 'AccountType' become 'Customer' as well. I mentioned this in the question.

Here the modified code snippet I had completed,

Thank you all for the cooperation.

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,732 on at

Like (0)

Report
Copy link

Link copied!

Hello JAYAKRISHNAN M S,

Good to know that the case is solved.

Appreciate if you kindly verify any answer in this thread which you think, helps you closing this case.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
JAYAKRISHNAN M S 145 on at

Like (0)

Report
Copy link

Link copied!

Dear Sourav Dam,

Ofcourse.

Was this reply helpful? Yes No