Transfer to AP Timberline B File Format

Transfer to AP—Timberline B File Format

This format for the transfer to AP is an ASCII file that is compatible with Timberline.

Note

This format is for use with ePO only.

When a user selects the Timberline B format and runs the Transfer to AP process, a comma-separated (.csv) file is created in the following format.

Timberline B File Format

This is a comma-separated file with all Alpha data type fields in double quotes.
At least one APD (Distribution Line) per API (Invoice Line) is required for each invoice exported from the AMSI database. There can be multiple ADPs for each invoice, but at a minimum one ADP separates each API.
Every field in the layout must be represented, although the application does not populate all fields. The layout consists of fields 1–15 for API Invoice and 1–6 for API Distribution. If a field is not used, it will be represented by empty " ", and then separated by commas.

Field	Field Name	Field Type	Length	Values or Format
Record—API Invoice
1	API	Format ID		"API"
2	Vendor	Alpha	10	Vendor ID
3	Invoice	Alpha	15	Invoice Number
4	Description	Alpha	30	Invoice header description
5	Amount	Numeric		Total amount of the invoice
6	Invoice Date	Date		mm/dd/yyyy (Invoice Date)
7	Payment Date	Date		mm/dd/yyyy (Due Date)
8	Accounting Date	Date		mm/dd/yyyy (Transaction Date)
9	P.O. /Gal	Alpha	10	PO number from first line of invoice
Invoice – (*Fields 10 – 15 will only be populated if the Separate Check option is enabled for the Vendor)
10	Summary Payee Name	Alpha	30	Vendor name*
11	Summary Payee Address 1	Alpha	33	Vendor address 1*
12	Summary Payee Address 2	Alpha	33	Vendor address 2*
13	Summary Payee City	Alpha	30	Vendor city*
14	Summary Payee State	Alpha	4	Vendor state*
15	Summary Payee Zip	Alpha	10	Vendor zip*
Record—API Distribution
1	APD	Format ID		"APD"
2	Expense Account	Alpha	13	PropertyIDCompanyID-Expense Code
3	Amount	Numeric		Line item amount.
4	1099 Exempt	Check Box		Y/N based on 1099.
5	Description	Alpha	30	Line Item description
6	Joint Payee	Alpha	30	Blank

Samples (API and APD are separate lines):

"API","10777","08/09/2011.001","testing month end create recur","300.00","08/09/2011","08/09/2011","08/09/2011","10-7 Cleaning and Services","28317 Courtney Ln.","","Ponchatoula","LA","70454"

"APD","","","","","","CB122-6030","","","","300.00","","N","","line 1","",""

"API","10777","cb122Invoice","815.00","815.00","08/15/2011","08/15/2011","08/15/2011","10-7 Cleaning and Services","28317 Courtney Ln.","","Ponchatoula","LA","70454"

"APD","","","","","","CB122-5100 01","","","","815.00","","N","","Rent.Com","",""