Exporting financial information to Pegasus

Article ID: 0403041526511 - Last Review: 18 May 2006 by jasonl - Revision: 1 - Views: 1846


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


 
 Related articles

What customer information can be exported to Sage Line 50
What invoice information can be exported to Sage Line 50

For additional resources and information, you can go to the Service Accent Support Centre

Click here to go to the Service Accent Support Centre



Copyright © 2003-2024 Vantage Computing Ltd. All rights reserved. The information contained on this web site is correct as of its publication date.