Dynamics 365 Business Central 2024 Wave 1: E-file IRS 1099 forms without Integration-Part 2

Hi Folks,

Lets cont. on IRS 1099 part 2

Part 1:

Dynamics 365 Business Central 2024 Wave 1 (BC Version 24): E-file IRS 1099 forms without Integration-1.

Part 3:

Dynamics 365 Business Central 2024 Wave 1 (BC Version 24): E-file IRS 1099 forms without Integration-3.

Setup IRS Reporting Periods and Forms

Click on Search icon and search for 1099 Form Boxes.

Click on Search icon and search for IRS Reporting Period. System automatically created the setup data when feature is enabled. Define the Time period with starting date and ending date.

1. Copy Setup From: Every year the new reporting period needs to be defined. User can copy the setup from another period, that includes forms with boxes, vendor setup, adjustment and form statement. Select the Reporting period need to define (e:g 2026) and copy from selecting period (e:g 2025).

2. To specify 1099 forms for this period. Click on Forms. Specify 1099 form types such as DIV, INT, MISC, NEC. 

Each forms type has different form boxes. Click on Form Boxes. Specifies the No. and Description of 1099 form box. The Minimum Reportable Amount field is used to fill in the minimum amount as per IRS instructions for the reporting year. It can be set to 0 if no amount needs to report for a certain form box.

 

To view or Edit the how to print your IRS 1099 statement click Edit Statement.

Each Row No. is having a Print Value Type (Amount OR Yes/No) and Filter Expression. Row totaling specifies row-number interval. Print with is used to define the sign of the amount printed on 1099 form box.

Edit Instructions: These instructions are printed on second page of the report. This is required by IRS as these instruction helps to understand the meaning of each Box. 

3. Click on Vendor Setup, IRS 1099 Vendor Form Box Setup page opens. User can either manually select the Vendor or click on the action suggest to auto populate the vendors. 

Once the vendors are populated, you can update the Form No. and Form Box No.

The above page can also be opened from Vendor List and card.

Let’s quickly see some more setup needed. Search for Vendors and from List page Go to Vendor card.

“Receiving 1099 E-Form Consent” if checked means vendor provided the signed consent to receive 1099 form using email. When enabled either of the email address need to be defined. If “E-mail for IRS” is defined then system uses this email address to send IRS related communication. If not defined then system uses Email on Address tab.

Check mark FATCA requirement if the vendor is setup to require FATCA filing.

Let’s see how IRS 1099 can be used in Purchase Order in Business central.

Click search Icon on top right corner or use hotkeys (Alt +Q). Search for Purchase Order, or Purchasing -> Purchase Orders.

IRS functionality can only be used if the Purchase Order Posting Date is within the date range configured for IRS reporting year & Vendor should be setup.

When creating the PO, the IRS related info get populated from vendor master as shown below. User can change the value of IRS 1099 Form No. and IRS 1099 Form Box No.

Once the PO is posted, the IRS related info get posted to Purchase Invoice.

If the user made a mistake and wrongly selected the IRS 1099 Form No. and IRS 1099 Form Box No. The correction can be done using below steps.

Search for Vendor Ledger Entries OR Go to Posted Purchase Invoice and click on find entries, and select the vendor ledger entry you need to correct.

Click on Edit List and IRS 1099 related fields are editable. Vendor Ledger Entry is the main source of information for 1099 forms.

In case if the Form No. and Form Box No. for vendor is missed or incorrectly setup, correction can still be done on open and posted documents. 

Click search Icon and search for IRS 1099 Vendor Form Box Setup – > Propagate.

Select the Period for which you want to propagate the changes and if you want to update existing opened purchase documents or vendor ledger entries, or both. Click OK.

Let’s see how you can create 1099 Form Documents. Search for IRS Reporting Periods or IRS 1099 Form Documents

Click on Create Form to open the IRS 1099 Create Form Documents.

Filter Option: Select the period (Mandatory field) for IRS 1099 form. Select the Vendor, if no Vendor filter then form documents will be created for all vendors. Select the Form No., if no Form No. filter then form documents will be created for all forms. Replace, if checked then the existing form document will be replaced, else new form document will be created. Click OK.

IRS 1099 Form Documents will list all the forms created.

Click on Edit or double clicking on the record to Open the IRS 1099 Form Document Card.

Few important fields on the form document Header & Line.

  • Status: The created document status is Open, can be marked Release by user and Submitted after submitting to the IRS. 
  • Receiving 1099 E-form consent: The field is un-editable, its enabled as per the vendor setup. If enabled means vendor has provided signed consent to receive their 1099 form electronically.
  • Vendor E-mail: Email as defined on field E-mail for IRS on Vendor card, if the field is blank then Default email of vendor. It can be changed manually on the form.
  • Copy B Sent: The field is un-editable, specifies whether the copy B of the form has been sent to the vendor is used. 
  • Copy 2 Sent: The field is un-editable, specifies whether the copy 2 of the form has been sent to the vendor.
  • Calculated Amount: Specifies the amount per period and IRS code calculated by the Create Forms action on the list page. This amount is taken from the Vendor Ledger Entries page. If Collect Details for Line (IRS Form Setup -> Collect Details for Line) is enabled, you can drill down to see the connected entries. The value can’t be changed manually.
  • Adjustment Amount: Specifies the calculated adjustment amount of the document line, the amount you specified for the Period, Vendor, and Form Box during your setup. The value can’t be changed manually.
  • Amount: Specifies the amount of the document line. The sum of calculated amount and adjustment amount. This value is used for reporting and the amount can be changed manually.
  • Minimum Reportable Amount: The threshold to decide whether the certain form box with the reporting amount must be reported.
  • Include in 1099: Specifies whether the document line should be included in the 1099. The line is included if the amount is more than or equal to the minimum reportable amount.

Let’s Release the Document.

Click OK. Email is sent and Copy B Send is checked.

Attached PDF on email Page 1.

Page 2

In case any error occurs when sending the emails system record the error in the activity log.

Click on Report action to view the Report Type available.

In case of any further assistance on IRS 1099 process, please reach out to us at sales@relgyatech.com

Thanks!!

Please subscribe and Stay Connected.!!

Send Us A Message

More Posts