web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Vendor Ledger Entries ...
Microsoft Dynamics NAV (Archived)

Vendor Ledger Entries Wrong Remaining Amount(LCY)

(0) ShareShare
ReportReport
Posted on by Community Member

Dears,

After processing the payment the vendor ledger entries contains a remaining amount that doesn't relate to any Invoice.

Can anyone explain to me why in Detailed Vendor Ledger Entries Amount of the Initial Entry exceeds Amount the Application. 

DetailedVendor.JPG

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    This means, you have received the payment of 21,441.90, however you have applied this payment to Invoice entry having Invoice amount of 21,143.10.

    This mean, you have received access payment or you might require to apply remaining payment balance to any other invoice.

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 on at

    This means that you had received more money than the invoice itself, applied it to invoice and there still is some payment left unapplied. This can happen e.g. in a scenario when:

    - you have two invoices from your vendor

    - you had paid them both in one shot

    - you had applied one invoice to that payment but not yet applied the other

    In certain cases, the remaining unapplied amount can be a subject to return from Vendor. In this case you will post a Finance Charge Memo (sort of credit-memo for payments) and then apply it also to the payment.

  • Community Member Profile Picture
    Community Member on at

    How can get the unapplied invoice for the remaining Amount. Is there any way to trace the invoice which is showing the remaining Amount

    Thanks

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 on at

    You can check what ledger entries have "Invoice" type and still have not zero amount in the "Remaining Amount" field, or those which still have "Yes" checkmark in the "Open" field.

    Normally, when you drill down to ledger entries from the vendor card, they are already filtered out by "Open" to hide the closed transactions which are already fully applied.

  • Community Member Profile Picture
    Community Member on at

    Hi Alexander,

    In vendor Ledger Entries I filtered

    Document Type = Invoice

    Vendor No. = GUL003

    Remaining Amount <>0

    ---------------------------------------------------------------------------------------------------------------------------

    Still I couldn't find any Invoice related to the Remaining Amount 298.80.

    When I drill down to the Detailed Vendor Ledg. Entries from the Remaining Amount 298.80 I get the difference

    21441.90-21143.10=298.80

    21143.10=Application(12.80+76.80+1,022.00+37.80+19,567.70+182.00+244)

    can I know how is the Initial Entry add up to 21441.90 

  • Suggested answer
    Indikauk Profile Picture
    Indikauk 1,759 on at

    Hi Eri

    if you Drill down the Remaining Amount Field you will have it has Arrived in to that Remaining amount meaning you will see what entries has applied to close the invoice.  

    as per your Detail Vendor Ledger Entries it shows that Payment Amount is Higher than the Amount Applied with payment.

    its Better you Print the Detail Aging for this vendor and see what are the outstanding Details, that will give all the document type with the remaining amount with them and from that you will be able to find your 298.80 difference.

  • Community Member Profile Picture
    Community Member on at

    Hi Indika ,

    298.80 is not related to any single invoice but rather  is a difference of Invoices  -19,866.50+19,567.70

    19,866.50 is Invoiced and  not paid .

    Initial Entry Invoice -19,866.50 -19,866.50
    Initial Entry Invoice -12.80 -12.80
    Initial Entry Invoice -244.00 -244.00
    Initial Entry Invoice -76.80 -76.80
    Initial Entry Invoice -1,022.00 -1,022.00
    Initial Entry Invoice -37.80 -37.80
    Initial Entry Invoice -19,567.70 -19,567.70
    Initial Entry Invoice -182.00 -182.00
    Application Payment 12.80 12.80
    Application Payment 76.80 76.80
    Application Payment 1,022.00 1,022.00
    Application Payment 37.80 37.80
    Application Payment 19,567.70 19,567.70
    Application Payment 182.00 182.00
    Application Payment 244.00 244.00
    Remaining Amount -19866.50+19567.70 -298.80
  • Indikauk Profile Picture
    Indikauk 1,759 on at

    Hi Eri

    Can you attached the Vendor Ledger Entry Screen with Outstanding Transactions Only to Get an Idea About Entries open entries.  if the only Pending Transaction is the 19,866.50 and it is not paid then it cannot be set off with any payment and show the wrong remaining Amount.  also if it not paid and then it should not come to the application details of other Transactions it should show separate.

  • Community Member Profile Picture
    Community Member on at

    Hi Indika,

    Attached(Screenshot)

    Payment1.JPG

    After I process the same transaction in test company and got the desired result. It could be a mistake of the users but I couldn't understand what cause the problem.

    Payment1.JPG

  • Suggested answer
    Indikauk Profile Picture
    Indikauk 1,759 on at

    Hi Eri

    Thanks for Screen Shot, now if you on your Payment amount of 21,441.90 the Remaining Amount is 298.80 when Click on the Remaining Amount and Drill Down It Will show what entries users has applied against the payment. can you attached that screen as well there should be a wrong application in this case as you mention 298.80 should not be there.  also you can Un-Apply Payment and and Re Do the Application Correctly that will help you to identify the problem and solve it.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans