1099 season is coming up and remember that in Sage 500 you can use AP/1099 Beginning Balances task to import beginning balances. A successful import inserts records into tapVend1099Bal table.
The supported file layout is fixed length. Delimited files are not supported. If a record contains a vendor, year, form, and box that already exist in the table, the BegBal field is updated with the value from the file. A warning is issued on the error log when this occurs. In order to delete imported 1099 beginning balance records, manually delete them from the grid in the 1099 Beginning Balance form. Here is the record layout:
No. |
Import Table Field Name |
Description |
Data Type |
Start |
Width |
1 |
VendID |
Vendor |
Char(12) |
1 |
12 |
2 |
Year |
Year |
SmallInt |
13 |
4 |
3 |
V1099Form |
Form |
SmallInt |
17 |
1 |
4 |
V1099Box |
Box |
Char(3) |
18 |
3 |
5 |
BegBal |
Beginning Balance |
Dec(15,3) |
21 |
16 |
Valid values for V1099Form field are:
1 = interest
2 = Misc
3 = Dividend
Also attached is a sample file for vendor ID=ACS that can be used in demo company SOA.