How can I show data in Recipient Bank Account column automatically in Payment Journal page?

(0) Share

Report

Posted on by Community Member Microsoft Employee

8475.Untitled.jpg

I already insert data in Recipient Bank Account ( BBL as you see in the picture). and now we have only one account per vendor. How can I fetch the data to show on the page in navision automatically ( like KBANK in the picture, I have to click drop down list to show it), so users don't need to select it again.

Thank you for helping in advance.

Regards.

*This post is locked for comments

All responses (6)

Answers (1)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: How can I show data in Recipient Bank Account column automatically in Payment Journal page?

Please forgive me if I have misunderstood your question.

If you want to automatically populate the "Recipient Bank Account" on the payment journal line - then you should populate the "Preferred Bank Account Code" field on the vendor card.
Suggested answer

Alexander Ermakov 28,094 on at

Like (0)

Report

RE: How can I show data in Recipient Bank Account column automatically in Payment Journal page?

Agree with Suresh, in standard there is no automatic validation of bank account field. You also would need to solve the question what to put in case your vendor would have multiple bank accounts (put first or do not put anything to draw user's attention to make proper selection).
Community Member Microsoft Employee on at

Like (0)

Report

RE: How can I show data in Recipient Bank Account column automatically in Payment Journal page?

Thank you for your advise
Verified answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: How can I show data in Recipient Bank Account column automatically in Payment Journal page?

Do you mean to populate that value automatically instead of the selection ? if so then you need to modify the code in Gen. Journal Line table on the validation of the Account No. to retrieve that value based on Receipient Bank Account table.
Community Member Microsoft Employee on at

Like (0)

Report

RE: How can I show data in Recipient Bank Account column automatically in Payment Journal page?

sorry Suresh,

I have the dropdown list.

When I click the dropdown list, it has data ( V000191, BBL in the picture).

Now if I want it to show the value I have to click dropdown list and select the value.

is there the way to show value(V000191, BBL) automatically ?
Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: How can I show data in Recipient Bank Account column automatically in Payment Journal page?

Pan,

I am sorry but i don't think i understand your query, you don't to have the dropdown list ? or you want that to filter it for a specific value ?