Hi Kpurdy!

Do you have "Retain 1099 totals per GL prefix" selected in AP Settings?

April

Yes, I do.  What does it do if it is checked?

Did you run the AP Reports > Miscellaneous > 1099 Preparation report for your property prefixes to confirm you have amounts?

I ran it but it doesn't break it down by prefix, or I am doing something wrong.  This is my first time, new to company and new to software so I could definitely be doing something wrong

You should be getting a prompt to select to run by Vendor or by GL prefix (may be listed as "by property" if that is the description for your prefixes). This is assuming that your fiscal settings are at the property prefix level.

yes, it say to vendor or by fiscal entity.  I think it worked, reports have prefix listed on it with the 3 different company #'s

when I upload into the Aatrix 1099 software it should print correctly I would assume as well

When you run in Aatrix (AP Tasks > Government efiling and Reporting > Form 1099 (USA)), you'll have a prompt to report 1099 amounts by Vendor or by fiscal entity. So be sure to choose the Fiscal entity. You'll run this task separately for each entity.

THANK YOU!!!  for answering my question and helping me - I haven't slept in a couple nights thinking about this.  I will let you know if it works when I get to running 1099s for that company.

our company will have the same scenario in 2021 - when one chooses the Fiscal entity when processing the 1099's how will the system knows to pull the payments for current year posted against this company.

we will also have several companies (same FEIN) and one company (different FEIn) in one database

Hi Irma,

You need to have Maintain Prefix Totals turned on in AP Settings, then totals by the GL prefix and vendor will get updated as payments are made. Totals are maintained for the current year (This Year), the prior year (Last Year), and the future year (Next Year). The current year is determined from the 1099 Year End date found in AP Settings.

If Maintain Prefix Totals was not turned on before payments were entered for the year you need to start accumulating totals, you can use the Recalculate 1099 Totals to populate those totals.

Sage Knowledgebase article 23986 How do I use the Accounts Payable Recalculate 1099 Totals tool to correct 1099 amounts? explains how to use this tool.

April