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

1099 Adjustments not appearing on 1099 Vendor Information Reports

(0) Share

Report

Posted on by theish803

Hi,

We had a client recently go live with the SaaS version of Business Central. This client had 1099 balances in their legacy system that were already paid in their legacy system (meaning no active balance for the vendor when we brought them over to BC). We advised them to upload via a configuration package we created, which applied them to the 1099 Adjustments table.

Now they're trying to print their 1099's and the only information coming out of them is from the transactions that were performed in Business Central, and none of the entries in the 1099 Adjustments table. We did run the job that updated the 1099 Form-Boxes, but that didn't do the trick.

It seems that Business Central reads only off of the payment transactions in Vendor Ledger Entries. Then why have a 1099 Adjustments table?

Anyway we can go about this without some sort of customization?

Thanks in advance,

Ishraaj Jolly

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Andy Sather on at

Like (1)

Report

Hello - Correcting the historical VLE's will require updating the entries. I would have one of your developers write a report to update the 1099 vendors vs. doing them manually. In Table 25 (Vendor Ledger Entry), the following fields need to be populated for Document Type ‘Invoice’ & ‘Credit Memo’:

IRS 1099 Code

IRS 1099 Amount – (Positive Amount for Credit Memo, Negative Amount (-) for Invoice)

For Document Type ‘Payment’, only this field needs to be populated:

IRS 1099 Code

For Open PO's, these tables need updated for the 1099 vendor's orders:

Table 38 Purchase Header

IRS 1099 Code

Table 39 Purchase Line

IRS 1099 Liable = TRUE

This is a much better way to update the ledger entries to be as they should have for 2020 and get the proper tax reporting amounts.

Was this reply helpful? Yes No
theish803 5 on at

Like (0)

Report

Hi Andy,

I appreciate your response. Ordinarily, that would be the way we would have dealt with this. The problem is, the client had a number of payments that were flagged as 1099 in their previous system (they went live with BC in September 2020). We only loaded in open transactions for A/P as of September 2020 for their Go-Live. The 1099 payments would not have come over since they were already applied to invoices in their previous system and closed.

Instead of going back and trying to put in the A/P detail history from Jan 2020 to September 2020 (which would be a nightmare), is there any other way? I saw the table for 1099 adjustments, but it doesn't seem to feed into any of the reports.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Ishraaj,

Make sure when you are running the 1099's for 2020 you set your Work Date = a date on 2020 (i.e. 12/31/20). The Adjustment are the proper approach in filling in correct 1099 Amounts for a Vendor in a Calendar 1099 Year. This overrides any calculated Payment 1099 Amounts. Also make sure you have a Date Filter set = 1/1/20..12/31/20.

The Work Date fix is a bug and has been reported to Microsoft.

Try this.

Thanks,

steve

Was this reply helpful? Yes No
theish803 5 on at

Like (0)

Report

Hi Steve,

I tried your suggestion, and still getting the same issue. Here's some screenshots that illustrate what we did:

1. Changed the work date to 12/31/2020:

2. I deleted the adjustments and personally typed them in again under the 1099 Adjustments for NEC-01 and used 2020 for the tax year:

However, if I go to run the Vendor 1099 Information report for one of the adjusted vendors (I used Vendor ID 00034 in the screenshot below, it doesn't pull any information:

The same is when I run the 1099 NEC report.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hello,

I went back and created a few more tests and I think I found a bug in the reports, all reports. It stems from this section:

trigger OnOpenPage()

begin

RunTestPrint := false;

CurrYear := Date2DMY(WorkDate(), 3);

end;

I did create a custom report layout of the base report, then rem out the line CurrYear:=... The report worked. I have submitted a Microsoft ticket to get the 1099 Reports fixed.

Thanks,

Steve

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hello,

Update... Microsoft is working on this issue. Note that if you click Print, not Preview, and set your Work Date to 12/31/20 (the Year you are running), the 1099-NEC report will print.

If I hear anything else I will update this ticket.

Thanks,

Steve

Was this reply helpful? Yes No