Process
Process
Last updated
Process
Last updated
Why this is needed? Data transfer between Sage Intacct and Synchronoss is achieved using csv file. The file format is fixed for the integration.
What are the file formats? Sage Intacct Account Payable Invoice/Adjustment import file format • Import file specification as supplied by Synchronoss/CallOne. • File will include both bills and adjustments. In addition, will create bills and adjustments in Sage Intacct Incoming file must be in CSV format. • File name must include text “bills”. For e.g. CObills10232020.csv is a valid file name. • Execute process/job manually instead of scheduling for testing purposes. Upload import files on ftp; directory – FTP Directory parameter as specified on SFTP/FTP connector. Execute the following process from GUMU™
Field
Description
Date Loaded
Format MM/DD/YYYY. Required for Paid Invoices.
Vendor Name
Enter Vendor name
Account Number
Enter Vendor Id from Sage Intacct
Invoice Number
Enter Invoice number
AP Posting Date
Format MM/DD/YYYY. Required for Paid Invoices.
Invoice Due Date
Format MM/DD/YYYY. Required for Paid Invoices.
GL Account
Account Label
Description
Enter Description
Amount
Enter amount
Account
Enter AP offset account from Intacct.
Sage Intacct Accounts Payable payment export files format • Export file in a format as supplied by Synchronoss/CallOne. • File will be CSV format. • Exported file name would be CLOAPFMMDDYYYY.csv • Execute process/job manually instead of scheduling for testing purposes. Upon execution export file will be uploaded to directory – FTP Export Folder parameter specified on Integration configuration. • To Check Exported file Go to SFTP Server > Open Export Data Folder > Select file by checking current Date and Time.
Field
Description
File Exported Date
Format MM/DD/YYYY. (10/28/2020)
Record ID ‘H’
Header Record
File Name
FILE NAME OF EXPORT FILE (CLOAPFMMDDYYYY.csv)
File Type
APF
File Version
1
AP Interface
M (Miscellaneous)
Record ID ‘C’
Detail Records
Vendor Number
Vendor ID
Invoice Number
Record ID
Receipt date
Format MM/DD/YYYY.
BANK
Account Number
Amount
Invoice Payment Amount
Check Amount
Check Amount
Date
Check Date
Feedback Status
P = Paid
R = Rejected
V = Void (for already-paid checks), W = Pending Payment
Feedback Description
Description field
Accounting Month
Format YYYYMM (EX: 201104 represents April, 2011)
Record ID ‘T’
Trailer Record .Total number of record sent in the file (including header and trailer records)
Total Number of Invoices
Detail Records ‘C’ (EX : 26 Detail record count from exported file)
Total Paid Amount
Total of Invoice Payment Amount fields for records with Record ID = C and Status = P minus amounts for Status = V
