Amount entered for vendor does not agree with 1099 report

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

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. 1099 Report is showing 43400.00 and it should be 43800.00. Thanks

This is the way I run the 1099 report

*This post is locked for comments

All responses (21)

Answers (1)

Suggested answer

Alex Chow 4,481 on at

Like (0)

Report

RE: Amount entered for vendor does not agree with 1099 report

Is that a typo? The report should be showing 43600?

The 1099 will only calculate for Payment entries.
Meghan Parisi 10 on at

Like (0)

Report

RE: Amount entered for vendor does not agree with 1099 report

Is the credit memo is red applied to the invoice? What is the remaining amount? What is the result on the report if you apply it?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Amount entered for vendor does not agree with 1099 report

Ok thanks
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Amount entered for vendor does not agree with 1099 report

Not sure, what could be the reason.

Better you take all these Vendor Ledger Entries and Detailed Vendor Ledger entries in excel and try to match the fields value. See if you find any difference between Feb and March entries (Invoice, Credit Memo and Payment entries).

If nothing works, arrange to check with developer via debugging.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Amount entered for vendor does not agree with 1099 report

No entries in Remaining Pmt Disc. Possible field
Community Member Microsoft Employee on at

Like (0)

Report

RE: Amount entered for vendor does not agree with 1099 report

I added the column Remaining Pmt Disc. Possible to view in my Vendor Ledger Entries and all the entries are zeros from Sep 15 forward.

When I run that 1099 report for just January, the amount of 14600. shows and that is correct. When I run the report for February that amount of 14600 is also correct. When I run the report for March it shows 14200.00. I am getting ready to pay again on the first of April and will do another 400.00 deduction which is paying down an outstanding a/r. I will go into Cash receipts and do a Credit Memo to Customer and apply entries and on the second line I will use Credit Memo on account type Vendor with nothing applied. This puts it out in the vendor file for me to deduct. Would you suggest another way?

Thanks
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Amount entered for vendor does not agree with 1099 report

Hi,

Do you see any value in "Remaining Pmt. Disc. Possible" field for any of these Entries?

Also, Check the Application against all these three Payments and see if it is correctly applied within Jan to March months Invoices and not to any previous months entries.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Amount entered for vendor does not agree with 1099 report
Community Member Microsoft Employee on at

Like (0)

Report

RE: Amount entered for vendor does not agree with 1099 report

Can you please attach the report output screen shot here for this particular Vendor?

And also attach the Vendor Ledger Entries screen shot for this Vendor (with Remaining Amount column)
Alexander Ermakov 28,094 on at

Like (0)

Report

RE: Amount entered for vendor does not agree with 1099 report

What is exactly the result? Any system messages?