AR Export - Revision history

Lsilverman at 18:08, 6 February 2014

2014-02-06T18:08:12Z

Tfusco: /* File Format */

2011-08-02T16:00:33Z

File Format

Tfusco: /* File Format */

2011-08-02T15:59:56Z

File Format

Tfusco at 21:53, 7 May 2010

2010-05-07T21:53:15Z

Tfusco at 18:01, 7 May 2010

2010-05-07T18:01:01Z

Tfusco at 18:00, 7 May 2010

2010-05-07T18:00:32Z

Tfusco: Created page with '=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 onc…'

2010-05-07T17:58:01Z

Created page with '=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 onc…'

New page

=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 ==
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 sec)
*Number of rows: 1200
*Grand total for "Total" column: $18,051.08
*File type: .txt

Example: AR_2010.05.03.20.57.16_1200_18051.08.txt

== File Format ==
* File is a comma delimited ASCII text file

Format:

{| class="wikitable" border="1" cellpadding="5" cellspacing="0"
|-
! Field
! Example
! Format
! Notes
|-
| Invoice number
| R123456
| 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
| 123456
| 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
| TRAX
| 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 rows in 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

← Older revision		Revision as of 18:08, 6 February 2014
Line 79:		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]]

← Older revision		Revision as of 21:53, 7 May 2010
Line 1:		Line 1:
		+	[[Rental\|<< Back to Rental Module]]
		+
		+	[[File-Based_Import/Export\|<< Back to File Based Import/Export]]
		+
	=AR Export=		=AR Export=
	*This export contains AR data for TrackAbout generated rental invoices.		*This export contains AR data for TrackAbout generated rental invoices.

@@ Line 62: / Line 62: @@
 |-
 | Tax region
-| TRAX
+| 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.

@@ Line 37: / Line 37: @@
 |-
 | Invoice number
-| R123456
+| 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
-| 123456
+| 23456
 | Text, Max 30 char
 | This is the customer number. It will be the same number and format used by the business system.
@@ Line 71: / Line 71: @@
 | Due date for invoice.
 |}
 == Example Data ==

@@ Line 1: / Line 1: @@
 =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 ==
@@ Line 65: / Line 67: @@
 | Due date for invoice.
 |}
 == Example Data ==

@@ Line 7: / Line 7: @@
 == File Name ==
 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 sec)
+*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
-Example: AR_2010.05.03.20.57.16_1200_18051.08.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
 {| class="wikitable" border="1" cellpadding="5" cellspacing="0"
@@ Line 65: / Line 66: @@
 |}
-Example rows in file:
+== Example Data ==
   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

AR Export - Revision history

Lsilverman at 18:08, 6 February 2014

Tfusco: /* File Format */

Tfusco: /* File Format */

Tfusco at 21:53, 7 May 2010

Tfusco at 18:01, 7 May 2010

Tfusco at 18:00, 7 May 2010

Tfusco: Created page with '=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 onc…'

Tfusco: Created page with '=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 onc…'