Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

Retrieving Value From one Page Field to Another table Field

Posted on by 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.

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 45 on at
    RE: Retrieving Value From one Page Field to Another table Field

    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.

  • Pushparaj Kohli Profile Picture
    Pushparaj Kohli 60 on at
    RE: Retrieving Value From one Page Field to Another table Field

    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.

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 45 on at
    RE: Retrieving Value From one Page Field to Another table Field

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans