I am working on translating the FTP download from Concur into a something to upload into Sage 300 CRE AP. Has anyone successfully completed this task? What is required to upload into Sage 300 CRE?
We tired to work with concur to get this but they were not able to do so for us. Here is the info they need to be exporting. If they ever support the fixed format it will work for everyone. From the sage help.
Import order |
Required to have a value? |
Field description |
Field type |
Field length | What setting determines when the field’s value is validated in the format? | Click to view detailed field verification information |
---|---|---|---|---|---|---|
1
|
Always |
APIF |
Alpha |
4 |
Always validated |
|
2 |
Always |
Vendor |
Alpha |
10 |
Always validated |
|
3 |
Always |
Invoice |
Alpha |
15 |
Always validated |
|
4 |
No |
Description |
Alpha |
30 |
Always validated |
|
5 |
(a) |
Amount |
Numeric |
-9.2 |
Always validated |
|
6 |
No |
Tax |
Numeric |
-7.2 |
AP Settings, Invoice Settings, Tax Settings = Enter total tax for invoice and tax amount for each distribution |
|
7 |
No |
Discount Offered |
Numeric |
-7.2 |
AP Settings, Invoice Settings, Discount Usage = Invoice level |
|
8 |
No |
Misc Deduction |
Numeric |
-7.2 |
AP Settings, Invoice Settings, Misc deduction usage = Invoice level |
|
9 |
(b) |
Invoice Date |
Date |
|
Always validated |
|
10 |
(c) |
Date Received |
Date |
|
AP Settings, Invoice Settings, Date received usage ! = Not used |
|
11 |
No |
Discount Date |
Date |
|
AP Settings, Invoice Settings, Discount usage ! = Not used |
|
12 |
(d) |
Payment Date |
Date |
|
AP Settings, Invoice Settings, Payment date usage ! = Not used |
|
13 |
Yes |
Accounting Date |
Date |
|
AP Settings, Invoice Settings, Accounting date usage = Entered |
|
14 |
No |
Invoice Code 1 |
Alpha |
10 |
AP Settings, Invoice Settings, Additional Settings |
|
15 |
No |
Invoice Code 2 |
Alpha |
10 |
AP Settings, Invoice Settings, Additional Settings |
|
16 |
(e) |
Summary Payee Name |
Alpha |
30 |
Always validated |
|
17 |
No |
Summary Payee Address 1 |
Alpha |
33 |
Always validated |
|
18 |
No |
Summary Payee Address 2 |
Alpha |
33 |
Always validated |
|
19 |
No |
Summary Payee City |
Alpha |
15 |
Always validated |
|
20 |
No |
Summary Payee State |
Alpha |
4 |
Always validated |
|
21 |
No |
Summary Payee Zip |
Alpha |
10 |
Always validated |
Notes:
*All 21 fields require representation in the APIF . Use the notes below to determine whether an actual value or a comma-placeholder is required to represent those fields.
(a) Must be equal to the sum of all distribution amounts. Required if this sum is non-zero.
(b) Required if AP Settings, Invoice Settings, Accounting date usage = 'Invoice date', otherwise is not required.
(c) Required if AP Settings, Invoice Settings, Date received usage = 'Required', otherwise is not required.
(d) Required if AP Settings, Invoice Settings, Payment date usage = 'Required', otherwise is not required.
(e) Required to have a value if the vendor type of the entered vendor is Summary. Required to not have a value if the vendor type of the entered vendor ID is not Summary.
Import order |
Required to have a value? |
Field description |
Field type |
Field length | What setting determines when the field’s value is validated in the format? | Click to view detailed field verification information |
---|---|---|---|---|---|---|
1
|
Always |
APIF |
Alpha |
4 |
Always validated |
|
2 |
Always |
Vendor |
Alpha |
10 |
Always validated |
|
3 |
Always |
Invoice |
Alpha |
15 |
Always validated |
|
4 |
No |
Description |
Alpha |
30 |
Always validated |
|
5 |
(a) |
Amount |
Numeric |
-9.2 |
Always validated |
|
6 |
No |
Tax |
Numeric |
-7.2 |
AP Settings, Invoice Settings, Tax Settings = Enter total tax for invoice and tax amount for each distribution |
|
7 |
No |
Discount Offered |
Numeric |
-7.2 |
AP Settings, Invoice Settings, Discount Usage = Invoice level |
|
8 |
No |
Misc Deduction |
Numeric |
-7.2 |
AP Settings, Invoice Settings, Misc deduction usage = Invoice level |
|
9 |
(b) |
Invoice Date |
Date |
|
Always validated |
|
10 |
(c) |
Date Received |
Date |
|
AP Settings, Invoice Settings, Date received usage ! = Not used |
|
11 |
No |
Discount Date |
Date |
|
AP Settings, Invoice Settings, Discount usage ! = Not used |
|
12 |
(d) |
Payment Date |
Date |
|
AP Settings, Invoice Settings, Payment date usage ! = Not used |
|
13 |
Yes |
Accounting Date |
Date |
|
AP Settings, Invoice Settings, Accounting date usage = Entered |
|
14 |
No |
Invoice Code 1 |
Alpha |
10 |
AP Settings, Invoice Settings, Additional Settings |
|
15 |
No |
Invoice Code 2 |
Alpha |
10 |
AP Settings, Invoice Settings, Additional Settings |
|
16 |
(e) |
Summary Payee Name |
Alpha |
30 |
Always validated |
|
17 |
No |
Summary Payee Address 1 |
Alpha |
33 |
Always validated |
|
18 |
No |
Summary Payee Address 2 |
Alpha |
33 |
Always validated |
|
19 |
No |
Summary Payee City |
Alpha |
15 |
Always validated |
|
20 |
No |
Summary Payee State |
Alpha |
4 |
Always validated |
|
21 |
No |
Summary Payee Zip |
Alpha |
10 |
Always validated |
Notes:
*All 21 fields require representation in the APIF . Use the notes below to determine whether an actual value or a comma-placeholder is required to represent those fields.
(a) Must be equal to the sum of all distribution amounts. Required if this sum is non-zero.
(b) Required if AP Settings, Invoice Settings, Accounting date usage = 'Invoice date', otherwise is not required.
(c) Required if AP Settings, Invoice Settings, Date received usage = 'Required', otherwise is not required.
(d) Required if AP Settings, Invoice Settings, Payment date usage = 'Required', otherwise is not required.
(e) Required to have a value if the vendor type of the entered vendor is Summary. Required to not have a value if the vendor type of the entered vendor ID is not Summary.
Import order |
Required to have a value? |
Field description |
Field type |
Field length | What setting determines when the field’s value is validated in the format? | Click to view detailed field verification information |
---|---|---|---|---|---|---|
1
|
Always |
APIF |
Alpha |
4 |
Always validated |
|
2 |
Always |
Vendor |
Alpha |
10 |
Always validated |
|
3 |
Always |
Invoice |
Alpha |
15 |
Always validated |
|
4 |
No |
Description |
Alpha |
30 |
Always validated |
|
5 |
(a) |
Amount |
Numeric |
-9.2 |
Always validated |
|
6 |
No |
Tax |
Numeric |
-7.2 |
AP Settings, Invoice Settings, Tax Settings = Enter total tax for invoice and tax amount for each distribution |
|
7 |
No |
Discount Offered |
Numeric |
-7.2 |
AP Settings, Invoice Settings, Discount Usage = Invoice level |
|
8 |
No |
Misc Deduction |
Numeric |
-7.2 |
AP Settings, Invoice Settings, Misc deduction usage = Invoice level |
|
9 |
(b) |
Invoice Date |
Date |
|
Always validated |
|
10 |
(c) |
Date Received |
Date |
|
AP Settings, Invoice Settings, Date received usage ! = Not used |
|
11 |
No |
Discount Date |
Date |
|
AP Settings, Invoice Settings, Discount usage ! = Not used |
|
12 |
(d) |
Payment Date |
Date |
|
AP Settings, Invoice Settings, Payment date usage ! = Not used |
|
13 |
Yes |
Accounting Date |
Date |
|
AP Settings, Invoice Settings, Accounting date usage = Entered |
|
14 |
No |
Invoice Code 1 |
Alpha |
10 |
AP Settings, Invoice Settings, Additional Settings |
|
15 |
No |
Invoice Code 2 |
Alpha |
10 |
AP Settings, Invoice Settings, Additional Settings |
|
16 |
(e) |
Summary Payee Name |
Alpha |
30 |
Always validated |
|
17 |
No |
Summary Payee Address 1 |
Alpha |
33 |
Always validated |
|
18 |
No |
Summary Payee Address 2 |
Alpha |
33 |
Always validated |
|
19 |
No |
Summary Payee City |
Alpha |
15 |
Always validated |
|
20 |
No |
Summary Payee State |
Alpha |
4 |
Always validated |
|
21 |
No |
Summary Payee Zip |
Alpha |
10 |
Always validated |
Notes:
*All 21 fields require representation in the APIF . Use the notes below to determine whether an actual value or a comma-placeholder is required to represent those fields.
(a) Must be equal to the sum of all distribution amounts. Required if this sum is non-zero.
(b) Required if AP Settings, Invoice Settings, Accounting date usage = 'Invoice date', otherwise is not required.
(c) Required if AP Settings, Invoice Settings, Date received usage = 'Required', otherwise is not required.
(d) Required if AP Settings, Invoice Settings, Payment date usage = 'Required', otherwise is not required.
(e) Required to have a value if the vendor type of the entered vendor is Summary. Required to not have a value if the vendor type of the entered vendor ID is not Summary.
Pelican Design Consulting uses Sage Office Connector technology to import Accounting Extract Files from SAP Concur's Expense System as well as their Invoicing System. See the following web site for their brochure and a short video explaining how their integration template works: https://pelicandesignconsulting.com/concur-sage-300-tool
*Community Hub is the new name for Sage City