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
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.
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).
Thank you for your advise
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.
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 ?
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 ?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,232 Super User 2024 Season 2
Martin Dráb 230,064 Most Valuable Professional
nmaenpaa 101,156