Article ID: 0403041526511 - Last Review: 18 May 2006 by jasonl - Revision: 1 - Views: 1744
About "Exporting financial information to Pegasus"
This article describes the export of financial information (invoices) to Pegasus from Service Accent. There are two exports available, standard and enhanced. The two formats are very similar, with the enhanced including additional information (the majority of which does not exist in Service Accent and blank fields are therefore output).
The fields are separated by commas, text is enclosed in quote marks and each record is delineated by a newline.
Standard Pegasus export This creates two text files, a transaction file and an analysis file.
Format of the transaction file Account No Invoice date Invoice No Order No Invoice type ("I" or "C") Total invoice value Total VAT value Total invoice value Invoice due date
Format of the analysis file Account No Blank Invoice date Invoice No Invoice type ("I" or "C") Region (blank) Terriatory (blank) Customer type (blank) Analysis code (blank) Country Blank Discount (blank) Nominal code Product No Item value less VAT Item VAT value Analysis code (blank) "H" "S" Item VAT code ("0", "1" etc) VAT rate Line description
Enhanced Pegasus export This creates two text files, a transaction file and an analysis file.
Format of the transaction file Account No Invoice date Invoice No Order No Invoice type ("I" or "C") Total invoice value Total VAT value Total invoice value blank Invoice date "N" blank blank blank blank blank blank Invoice due date 15 blank analysis fields Region ("999") Payment type ("004" for direct debit, "001" for on account)
Format of the analysis file Account No Account No Invoice date Invoice date Invoice date Invoice No Invoice type ("I" or "C") Region ("999") Payment type (as above) Customer type (blank) Analysis code (blank) Analysis code (blank) Analysis code (blank) "N" Analysis code (blank) Country Analysis code (blank) Analysis code (blank) Analysis code (blank) Analysis code (blank) Nominal code Product No Item value less VAT Analysis code (blank) Item VAT value Analysis code (blank) Analysis code (blank) "H" "S" VAT code ("1" or "Z") VAT rate "T" "F" "T" 15 blank analysis fields Line description