Purchase Order Tab Separated File Format

By |2021-07-22T11:40:46-05:00April 21st, 2021|Comments Off on Purchase Order Tab Separated File Format

Introduction

When creating a Purchase Order, users will have the ability to check a box to include a tab delimited file that contains vital purchase order information. This file can be used for electronic data processing.

Client Notes

  1. The file name is Purchase_Order_mm-dd-yyyy_hh-mm-ss.txt
  2. One file is created.
  3. Each field is separated by a Tab
  4. The items repeat until all PO items have been included.

Programmer’s Notes

  1. Items marked as “Closed” will not be included.
  2. We include the first 250 characters of the Purchase Description
  3. The Item Number could be the Alias depending on print settings
  4. The Ship Method field is new and needs to be added. See separate write-up for that.

Header Data

The following information will be contained in the first rom of the file. This data indicates that this export is a Purchase Order and contains common information.

Field Format and Notes Required
~PO Indicates the beginning of the file and the type of data. Yes
Date mm-dd-yyyy Yes
Expected Date mm-dd-yyyy No
PO # 20 alphanumeric Yes
Company Name 150 alphanumeric Yes
Vendor Name 50 alphanumeric Yes
Account Number 100 alphanumeric No
FOB 20 alphanumeric No
Notes Unlimited alphanumeric No
Ship To 100 alphanumeric (usually a company name) No
Ship To Name 100 alphanumeric (usually the “Attention To”) No
Ship To Address 50 alphanumeric No
Ship To Address 2 50 alphanumeric No
Ship To City 30 alphanumeric No
Ship To State/Prov. 30 alphanumeric No
Ship To Zip 30 alphanumeric No
Ship Method 20 alphanumeric No
Product Name “Total Office Manager Enterprise” Yes
Product Version ##.##.## Yes
Export File Version #.# (the first version will be 1.0) Yes
File Creation Date/Time mm-dd-yyyyThh:mm:ss. Time is in 24 format. Yes

Body Data

The following information is contained in the second row. Each new PO item is a new row. POs must have at least one item.

Field Format and Notes Required
~StartTrans

 

Indicates the beginning of the transaction. Yes
Item Number*

 

55 characters Yes
Quantity

 

Eight numbers followed by an optional decimal point and up to two numbers to the right of that decimal point. Examples: ######## or ########.## or ########.# Yes
Purchase Description

 

250 characters No
Item Cost

 

Eight numbers followed by an optional decimal point and up to four numbers to the right of that decimal point. Examples: ######## or ########.## or ########.##### No
~EndTrans

 

Indicates the end of the transaction. Yes

Purchase Order Tab Separated File Format

Related Topics

Create New Purchase Order

 

Share This Story, Choose Your Platform!

About the Author:

HVAC Electrical Plumbing Software

Aptora delivers a true All-In-One services software solution including CRM, accounting, payroll, inventory, vendors, sales, marketing, dispatch, flat rate pricing, and more. NO 3rd party plugins or integrations required. Created by contractors for contractors, we know what it takes to grow your services-based businesses.

Newsletter

Sign-up to get the latest news and update information. Don’t worry, we won’t send spam!

Thank you for your message. It has been sent.
There was an error trying to send your message. Please try again later.
Go to Top