A couple of suggestions for improving this function...

It would be nice if it threw up a warning if the year-end date was beyond the system date's year-end. It would reduce the risk of accidentally running the function way too early.

Also, the function does not act on the YTD 1099 Payments bucket or the Next Year 1099 bucket for those vendors not flagged to receive a 1099. I believe a vendor not flagged should be treated the same as a flagged vendor. Of course under normal circumstances the buckets would be zero to begin with, but in the case where the flag was originally turned on, and then turned off, there might be a non-zero figure, and it would be wrong to leave it there.

Steve

The recent service pack (130131) has implemented my second suggestion, and 1099 buckets are emptied even if the vendor is not flagged as a 1099 vendor. That was quick!

Steve

We were recently informed by several California clients that the 1099 details from Payables should be excluding certain types of transactions and certain types vendors. The implications were, that not all of the vendor transactions were eligible to be included in 1099 reporting.

Is there any way to adjust the 1099 content reporting (or selectively purge) or flag expense distribution in Payables so that this can be more compliant for reporting.

Thanks,
Brian

Hi Brian,

In Payables, vendors with the 1099 property can be assigned a Form Type, and this type is available as a filter when printing the 1099 forms. This allows excluding certain vendors.

There is no option on a payment to flag it as 1099 compliant or not, either for an invoice payment or a cash invoice.

What type of expenses/payments should be excluded from incrementing the YTD 1099 statistic on the vendor? If paying an already posted invoice, do the distributions/accounts need to be inspected for compliance? If posting an invoice that results in matching up to a pre-payment, do the same expense inspections apply? Does reversing a check need to inspect all the paid invoices (current or history) for the expense distributions? As you can see, the scope of this sort of change is not minimal, and this isn't everything.

Hi, Brian,

If need be, you could enable edting of vendor statistics and edit the YTD 1099 Payments amounts on the Statistics - YTD tab.

Hi Brian

The rule is that services are 1099-reportable, products are not.

Since 1099 is cash-basis and Adagio is accrual-basis, there is no way to capture this information at the time of invoice entry.

The only way to do it is to have two vendor codes, one flagged for 1099 to pay services (I recommend using ABCD99 as the vendor format for the 1099-vendor) and another for products (ABCD01).

Steve