In this article

MEM 1099 Reports

The Multi-Entity Management version of these reports are a copy of the standard Microsoft Dynamics 365 Business Central report with MEM preceding the report name.

  • MEM 1099 Dividend
  • MEM Vendor 1099 Interest
  • MEM 1099 Miscellaneous

Based on the security settings on the Multi-Entity Management Setup page, the generated report(s) shows only the records that belong to entities to which you have access and match the other criteria that you specified. MEM security settings can restrict the visibility and access to the following types of records based on the entities to which you have access: bank account, customer, fixed asset, item, location, and vendor.

The data on these reports is organized based on the 1099 Reporting Sort By option on the Multi-Entity Management Setup.

Fields

These pages contain the following fields:

Field Description
Entity Filter

Select a range of entities or specific entities to appear on the report.

  • When the Entity Filter contains specific entities, the report shows only the records for the specified entities.
  • When the Entity Filter contains a range of entities, the report shows only the records within the specified entity range.
  • When the Entity Filter is empty, the report shows all records that belong to entities to which you have access.
Company FastTab

Displays the company address information for the reporting vendor. This information can be changed as needed.

The default address information is based on Print By Paying Entity option on the Multi-Entity Management Setup. When this option is turned on, the default address is from the vendor of the paying entity. When this option is turned off, the default address is from the vendor of the invoice entity.

You can also specify the Federal ID Number to appear on the report.

MEM 1099 Reports by Entity

These Multi-Entity Management 1099 reports have all the same features and functionality as the standard Microsoft Dynamics 365 Business Central report except the data on the report is grouped by entity.

  • MEM 1099 Dividend by Entity
  • MEM 1099 Miscellaneous by Entity
  • MEM Vendor 1099 Interest by Entity

The data on these reports is organized based on the 1099 Reporting Sort By option on the Multi-Entity Management Setup.

MEM Vendor 1099 Magnetic Media by Entity

If the Entity Filter has multiple entities selected or a range of entities, after the report is run, a one media file for each entity selected is generated. For example, the report has the following records: 

  • Vendor_1099 Entity ADM = 100.00
  • Vendor_1099 Entity PROD = 150.00
  • Vendor_1099 Entity SALES = 200.00

When the report is run with the entity filter range set as ADM...SALES, or the Entity Filter is empty, the following three files are generated. The file naming convention used is Entity_IRSTAX.

  • ADM_IRSTAX = 100.00
  • PROD_IRSTAX = 150.00
  • SALES_IRSTAX = 200.00

Print by Paying Entity

The 1099 amount can be categorized and printed for each payment entity. The setting that controls this feature is the Print by Paying Entity option on the Multi-Entity Management Setup. All 1099 reports including the following are affected by this feature: 

  • MEM 1099 Dividend
  • MEM 1099 Interest
  • MEM 1099 Miscellaneous
  • MEM 1099 Dividend by Entity
  • MEM 1099 Interest by Entity
  • MEM 1099 Miscellaneous by Entity
  • MEM Vendor 1099 Interest
  • MEM Vendor 1099 Interest by Entity
  • 1099 Statistics

Review the following examples to better understand how the report is printed by payment entity.

An invoice created with the header entity ADM, but the line is paid by the PROD entity. The General Ledger entries are as follows: 

PROD September 18, 2020 Payment G04007   V_1099_DIV 1099 Dividend BANK 100.00 100.00 100.00 0.00 0.00 DIV-01-A 0.00
ADM September 18, 2020 Invoice 108216 1 V_1099_DIV Invoice 107219 BANK -100.00 -100.00 -100.00 0.00 0.00 DIV-01-A -100.00

When Print by Payment Entity is turned off, the payment amounts appear below each entity as follows: 

  • ADM: 100.00
  • PROD: 0.00

When Print by Payment Entity is turned on, the payment amounts appear below each entity as follows: 

  • ADM: 0.00
  • PROD: 100.00

An invoice created with the header entity ADM, the line is paid by both ADM (10.00) and PROD (20.00) entities. The General Ledger entries are as follows: 

PROD September 18, 2020 Payment G04013   V_1099_DIV 1099 Dividend BANK 20.00 20.00 20.00 10.00 10.00 DIV-01-A 0.00
ADM September 18, 2020 Payment G04012   V_1099_DIV 1099 Dividend BANK 40.00 40.00 40.00 20.00 20.00 DIV-01-A 0.00
ADM September 18, 2020 Invoice 108221 5 V_1099_DIV Invoice 107224 BANK -100.00 -100.00 -100.00 0.00 0.00 DIV-01-A -100.00

When Print by Payment Entity is turned off, the payment amounts appear below each entity as follows: 

  • ADM: 30.00
  • PROD: 0.00

When Print by Payment Entity is turned on, the payment amounts appear below each entity as follows: 

  • ADM: 10.00
  • PROD: 20.00