Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Payment Against Invoices

Posted on by 3,027

Hi

 I want to generate a report in which i want Bank Payment done to Vendor and against which invoices it has been done.

Thanks

*This post is locked for comments

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Payment Against Invoices

    Please kindly check this thread: community.dynamics.com/.../203449

    Here is another discussion: https://dynamicsuser.net/nav/f/developers/93536/how-to-get-applied-payments-for-a-invoice

  • Suggested answer
    Mouli Kaku Profile Picture
    Mouli Kaku 515 on at
    RE: Payment Against Invoices

    3463.Capture.JPG 

    Go to Vendor Ledger Entry(23) Findout Payments and go to detail vendor ledger entry(380) find Applied Vendor Ldger entry no fields for the same payment entry no as shown in the image and you can filter Intial documents type as Invoice. will you the desired result

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Payment Against Invoices

    Hi

      I am looking at this table . But

      How from this table can i check that following payment has been made against which Invoices.

    Thanks

  • Suggested answer
    RobertasR Profile Picture
    RobertasR 5,002 on at
    RE: Payment Against Invoices

    The table is 380 'Detailed Vendor Ledg. Entry'

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Payment Against Invoices

    Hi

     Can u tell me the table name

    Thanks

  • Suggested answer
    RobertasR Profile Picture
    RobertasR 5,002 on at
    RE: Payment Against Invoices

    Hi, it's not very straightforward, especially when trying to find what exact amount was applied for individual invoice. The data is in the Detailed Ledger Entries of the 'bank payment' vendor ledger entry line.

    The good example is UK version report 10.532.

    Robertas

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Payment Against Invoices

    Hi

     In my Data both are Blanks

    Thanks

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Payment Against Invoices

    Check in vendor Ledger entry fields like

    Applies-to Doc. Type

    Applies-to Doc. No.

    As well as check detailed vendor ledger entry table for more details.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans