You’re offline. This is a read only version of the page.
60
Hi Experts,
I have a requirement of retrieving value from a field called Applied Amount to Payment Journal Lines.
its like if we going to pay a vendor some money , we have to apply the Open Invoice ,right?
when we click the set applies - id it will apply the selected lines. there will calculation of ‘APPLIED AMOUNT’ at the end of the page.
I want to get this value to show in the PAYMENT JOURNAL LINE RELATED TO THE VENDOR.
it would be great if i got some advice and example.
The applied amount you see in that page is a variable and is run time calculated and not saved anywhere. I write in the comment above how you can calculate it yourself.
Hi ,
Thank You for your response ,
But after setting the Set applies to - ID in the Apply vendor ledger page. how can I retrieve the value from the applied amount.
Hi,
When you do apply entries, in the background you actually fill Applies-to ID field of the Vendor Ledger Entry record.
So after you are done with application you can sum the amount of vendor ledger entries that have Applies-to ID equal to your payment journal line Document No.
You can see it yourself after applying open vendor ledger entries and see these fields filled.
Note: Make sure you calculate payment discounts etc if they are with payments because of payment terms etc.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (