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.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
