Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Entry in Vendor Ledger Entries that is showing red

Posted on by Microsoft Employee

I have entries in Vendor Ledger Entries that are red. The item is not open for this vendor. Is there something that I need to look at and correct? This particular vendor, when I run the 1099 report does not show an accurate amount paid to them.

Thanks

bd-haven-jan-feb-mar-entries.jpg

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Entry in Vendor Ledger Entries that is showing red

    I  process these Credit Memos on the first of the month. I have a few vendors that their terms are 14 days and I will pay and apply these credit memos on the 15th of the month. Also,  is there a reason why my 1099 report is not showing the correct amount? If you look at the screen shot of my entries for B & D, I have deducted 400.00 from them each month and currently when I run the report, it is off by 400.

    Thanks

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Entry in Vendor Ledger Entries that is showing red

    That is a nice one :-), we have also been wondering about such cases some time ago.

    The style for this record is controlled by a code in OnAfterGetRecord of the page. In some fields, it refers to the style, described in the table itself. Here is this part:

    IF Open THEN BEGIN

     IF WORKDATE > "Due Date" THEN

       EXIT('Unfavorable')

    END ELSE

     IF "Closed at Date" > "Due Date" THEN

       EXIT('Attention');

    EXIT('');

    That is, if the Closed at Date is > then Due Date, then it will be marked with red.

    Check at what date the credit memo is applied?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Entry in Vendor Ledger Entries that is showing red

    Why is part of this entry showing red. I have been deducting 400. per month from the vendor  for an outstanding a/r and right now when I run my 1099 on this vendor, it is 400.00 short. I was thinking this "red" entry may have something to do with it. 1099 amount should be 43800. however when I run the report, it shows 43,400.

    4405.bd-haven-jan-feb-mar-entries.jpg

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Entry in Vendor Ledger Entries that is showing red

    What is the exact issue with this entry?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Entry in Vendor Ledger Entries that is showing red

    Use Rich formatting option and attach screen shot.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Entry in Vendor Ledger Entries that is showing red

    vendor-entries-in-red.jpg

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Entry in Vendor Ledger Entries that is showing red

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Entry in Vendor Ledger Entries that is showing red

    Check the Vendor ledger entries and see if entries are properly applied.

    Can you attach entries screen shot here for further understanding?

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