WARNING: The TrackAbout MetaWiki has been deprecated and is no longer being updated.
Please visit our new TrackAbout Knowledge Base at https://supportkb.trackabout.com for the most-up-to-date documentation on TrackAbout and TrackAbout Mobile.
Difference between revisions of "AR Export"
Jump to navigation
Jump to search
Lsilverman (talk | contribs) |
|||
| (2 intermediate revisions by one other user not shown) | |||
| Line 37: | Line 37: | ||
|- | |- | ||
| Invoice number | | Invoice number | ||
| − | | | + | | 8001001 |
| Text, Max 255 char | | Text, Max 255 char | ||
| This is the TrackAbout generated rental invoice number. The format will be worked out in advance with the business system to ensure that the invoice number can be used in the business systems AR. Commonly this is done by giving TrackAbout a number range and/or a prefix. For instance "A 7 digit number with the first number set as 9900001" or "A 6 digit number prefixed with 'R' and starting with R010001". | | This is the TrackAbout generated rental invoice number. The format will be worked out in advance with the business system to ensure that the invoice number can be used in the business systems AR. Commonly this is done by giving TrackAbout a number range and/or a prefix. For instance "A 7 digit number with the first number set as 9900001" or "A 6 digit number prefixed with 'R' and starting with R010001". | ||
|- | |- | ||
| Customer number | | Customer number | ||
| − | | | + | | 23456 |
| Text, Max 30 char | | Text, Max 30 char | ||
| This is the customer number. It will be the same number and format used by the business system. | | This is the customer number. It will be the same number and format used by the business system. | ||
| Line 62: | Line 62: | ||
|- | |- | ||
| Tax region | | Tax region | ||
| − | | | + | | PA01 |
| Text, Max 25 char | | Text, Max 25 char | ||
| This is the tax region set on the customer. It originates from the business system and so should be in a format that works from the business system. | | This is the tax region set on the customer. It originates from the business system and so should be in a format that works from the business system. | ||
| Line 71: | Line 71: | ||
| Due date for invoice. | | Due date for invoice. | ||
|} | |} | ||
| − | |||
== Example Data == | == Example Data == | ||
| Line 80: | Line 79: | ||
R409066,10058,19.00,04/30/2010,1.60,LACQ,05/30/2010 | R409066,10058,19.00,04/30/2010,1.60,LACQ,05/30/2010 | ||
R409067,10070,37.92,04/30/2010,3.12,LACG,05/30/2010 | R409067,10070,37.92,04/30/2010,3.12,LACG,05/30/2010 | ||
| + | [[Category:Rental]] | ||
Latest revision as of 14:08, 6 February 2014
<< Back to File Based Import/Export
AR Export
- This export contains AR data for TrackAbout generated rental invoices.
Transfer Mechanism
- This export is kicked off at the end of a rental run. Typically once a month.
- A file is dropped into a TrackAbout hosted FTP site in a designated folder.
File Name
Here is an example file name: AR_2010.05.03.20.57.16_1200_18051.08.txt
The file name is built up of these components separated by underscore delimeters:
- Prefix: AR
- Date: 2010.05.03.20.57.16 (This is equivalent to 5/3/2010 20:57:16)
- Number of rows: 1200
- Grand total for "Total" column: $18,051.08
- File type: .txt
This creates a unique file name and also provides total fields that can be used by the business system to ensure that it read in all rows in the file.
File Format
- File is a comma delimited ASCII text file
- Fields in file
| Field | Example | Format | Notes |
|---|---|---|---|
| Invoice number | 8001001 | Text, Max 255 char | This is the TrackAbout generated rental invoice number. The format will be worked out in advance with the business system to ensure that the invoice number can be used in the business systems AR. Commonly this is done by giving TrackAbout a number range and/or a prefix. For instance "A 7 digit number with the first number set as 9900001" or "A 6 digit number prefixed with 'R' and starting with R010001". |
| Customer number | 23456 | Text, Max 30 char | This is the customer number. It will be the same number and format used by the business system. |
| Total | 100.00 | Numeric, Two decimal places | The total amount of the rental invoice including taxes. There is no thousands separator and no currency symbol, just the number. |
| Invoice Date | 04/30/2010 | Date in format MM/DD/YYYY | Invoice date |
| Tax amount | 6.50 | Numeric, Two decimal places | The total amount of tax on the invoice. Includes all tax levels. There is no thousands separator and no currency symbol, just the number. |
| Tax region | PA01 | Text, Max 25 char | This is the tax region set on the customer. It originates from the business system and so should be in a format that works from the business system. |
| Due Date | 05/30/2010 | Date in format MM/DD/YYYY | Due date for invoice. |
Example Data
Here is an example of the rows in the file.
R409063,10024,90.08,04/30/2010,7.14,LABF,05/30/2010 R409064,10043,1080.00,04/30/2010,.00,TXGC,05/30/2010 R409065,10056,85.74,04/30/2010,7.44,LADC,05/30/2010 R409066,10058,19.00,04/30/2010,1.60,LACQ,05/30/2010 R409067,10070,37.92,04/30/2010,3.12,LACG,05/30/2010