We are working on setting up the new 1099 functionality in 10.1.600. I have conversion Cvap0042 to create initial data for US 1099 reporting. I have ran conversion as report only and report and update. I see from the log file says it created box 3 and box 7 and updated suppliers and invoices.
When looking in AP setup 1099 Box Number US there is nothing. It is my understanding from documentation they should have been created when the conversion ran. What steps am I missing?
Complete the following settings in the Company Configuration
a. System Setup/Company/Site Maintenance/Company Configuration
b. Modules/Finance/1099 reporting (this tab it is only available when the Localization USA it is installed) Fill out the information Click Save
c. Year: 2016
d. TIN:
e. Name Control:
f. Office Code:
g. Name:
h. Street Address: City:
i. State:
j. Zip Code:
k. Phone Number:
l. Transmitter Control Code:
m. Click Save
n. NOTE: at this point you can set up the boxes and the1099 codes.
o. This will be already created by the conversion.
Set up the 1099 boxes
a. Financial Management/Accounts Payable/Set up/1099 Box Number US
b. 1099 Form Type should be Miscellaneous Income Click in 1099 Box Number Select all Click ok Confirm that the Box Number is from 01 to 18b The Boxes are user definable and System boxes can be modified, but can’t be deleted, you can use the 1099 Box Number Maintenance option The 1099 Code Tracks Paid Amounts per Box, you can use the 1099 Code Maintenance window This option is Located in Financial Management/Accounts Payable/Set up/1099 Code US
Setup the Supplier Record
a. Financial Management/Accounts Payable/Set up/Supplier Maintenance Click and Search any Supplier id (ABCM) Go to Supplier/1099 Mark the 1099’s check box as True and fill out the information
b. 1099 code: 01
c. Type and TIN: EIN
d. Click Save
I have updated company config prior to running conversion and we are licensed for USA localization. My issue is that after I run conversion based on documentation I should already have box 3 and 7 setup and the 1099 codes as you specify in step 3o. They are not there I am trying to confirm if something is not working correctly in 10.1.600.8 or if I missed something. I want to verify I can print 1099s for needed suppliers that was migrated from 9.05.702.
Dan,
Is there anything else that needs to be configured or run? I have done the license/Company configs, run conversion920 set up suppliers with payment processing and 1099 boxes checked. I then created new PO’s, Received, Invoiced and paid them but get an error running the 1099 report that no records have been selected. When I run the Supplier Payment Report it comes back with the suppliers that are 1099 compliant and with amounts over the $600 min.