How to import 1099 beginning balances

Less than one minute read time.

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.