1666_EpicorCustomExport
Overview
THIS PROJECT IS IN PROGRESS. THIS IS NOT A FINAL DOCUMENT, IT IS A WORKING DOCUMENT (PLEASE EXCUSE ALL TYPO'S AND FORMATTING). WE USE THIS TOOL TO DOCUMENT PROJECTS, THIS PAGE WILL REMAIN WHEN THE PROJECT IS COMPLETE.
PLEASE NOTE: SINCE THIS APP IS IN BETA THE EXPORT FILE CREATED CONTAINS THE FOLLOWING WARNING:
"BETA PROJECT..do not use for production until project is approved. (Once approved this line will be removed) "
The "1666_EpicorCustomExport" is a custom export in Accounting Link developed by The Back Office. This export was developed at the request and direction of the customer listed below.
AAA Arizona
P.O. Box 10810
Phoeniz, AZ 85064
602-308-3023
Project Contacts
| Paul Carr | pcarr@arizona.aaa.com |
| Gail Logan | glogan@arizona.aaa.com |
| Nell Wheat | nwheat@arizona.aaa.com |
| Lisa Battle | lbattle@arizona.aaa.com |
| Mark Allan | mallan@arizona.aaa.com |
THIS IS A CUSTOM EXPORT AND IS NOT SUPPORTED BY R.O. WRITER OR THE BACK OFFICE OR AS PART OF ANY SUPPORT PLAN. IT IS THE CUSTOMERS SOLE RESPONSIBILITY TO PROOF THIS EXPORT TO INSURE IT IS WORKING TO THEIR SATISFACTION.
System Requirements
Settings
This export allows the user to change settings to allow for changes in processes over time. The follow settings are available by clicking on the "Edit Settings" link on the bottom of the screen.
| Setting | Comment |
| EXPORTPATH | |
| DELIMITER: GL Export | Comma |
| DELIMITER: AP Header | Tab |
| DELIMITER: AP Detail | Tab |
File Layouts
GL Detail (fields included in new extract are highlighted in yellow)
| Export Heading | Current Extract | New Extract | Field Length |
| company_code | Delete | ||
| journal_ctrl_num | location_id | Delete | |
| sequence_id | row position | Delete | |
| rec_company_code | Delete | ||
| account_code | GLEntryDetail:AccountKey | GLEntryDetail:AccountKey | n/a |
| ADD: debit_amt | GLEntryDetail:Debit | n/a | |
| ADD: credit_amt | GLEntryDetail:Credit | n/a | |
| ADD: Blank Column | Blank | n/a | |
| ADD: Blank Column | Blank | n/a | |
| description | GLEntryDetail:Description | GLEntry:Date_GLEntryDetail:Descpription **Date format mm/dd/yyyy **No quotations around field | n/a |
| document_1 | GLEntryKey | Delete | |
| document_2 | Delete | ||
| reference_code | Delete | ||
| balance | Transaction amount | Delete | |
| balance_oper | Transaction amount | Delete | |
| nat_balance | Transaction amount | Delete | |
| nat_cur_code | USD | Delete | |
| rate | 1 | Delete | |
| rate_oper | 1 | Delete | |
| rate_type_home | USD | Delete | |
| rate_type_oper | USD | Delete | |
| processed_flag | Delete | ||
| Import_Identifier | Delete | ||
| batch_no | Delete | ||
| record_id_num | Delete | ||
| User_ID | Delete | ||
| org_id | RA | Delete |
AP Header
| Export Heading | Current Extract | New Extract | Field Length CHAR unless specified () |
| No Header Row | |||
| company_code | RA | RA | 8 |
| process_ctrl_num | 16 | ||
| source_trx_ctrl_num | GLEntryKey | GLEntryKey | 16 |
| trx_ctrl_num | 16 | ||
| trx_type | 4091 | 4091 | 4; (SMALLINT) |
| doc_ctrl_num | GLEntryDetail:TranReference | GLEntryDetail:TranReference | 16 |
| apply_to_num | 16 | ||
| po_ctrl_num | 16 | ||
| ticket_num | 20 | ||
| date_applied | GLEntry:Date | GLEntry:Date (mm/dd/yyyy) | 10 |
| date_aging | GLEntry:Date | GLEntry:Date (mm/dd/yyyy) | 10 |
| date_due | GLEntry:Date (mm/dd/yyyy) | 10 | |
| date_doc | GLEntry:Date (mm/dd/yyyy) | 10 | |
| date_received | GLEntry:Date (mm/dd/yyyy) | 10 | |
| date_required | GLEntry:Date (mm/dd/yyyy) | 10 | |
| date_discount | GLEntry:Date (mm/dd/yyyy) | 10 | |
| posting_code |
Change to Blank (" ") | 8 | |
| vendor_code | Supplier:VendorID | Supplier:VendorID | 12 |
| pay_to_code | Supplier:VendorID |
Change to Blank (" ") | 8 |
| branch_code | NOBRANCH | 8 | |
| comment_code | 8 | ||
| tax_code | NOTAX | NOTAX | 8 |
| terms_code | DUE NOW | 8 | |
| payment_code |
Change to "CHECK" | 8 | |
| hold_flag | 0 | 0 | 1; (SMALLINT) |
| doc_desc | GLEntry:Reference | GLEntry:Reference | 40 |
| hold_desc | 40 | ||
| intercompany_flag | 0 | 0 | 1; (SMALLINT) |
| nat_cur_code | USD | USD | 8 |
| rate_type_home | USD | BUY | 8 |
| rate_type_oper | USD | BUY | 8 |
| rate_home | 1 | 1 | (FLOAT) |
| rate_oper | 1 | 1 | (FLOAT) |
| pay_to_addr1 | Supplier:SupplierName | Supplier:SupplierName | 40 |
| pay_to_addr2 | Supplier:SupplierAddress | Supplier:SupplierAddress | 40 |
| pay_to_addr3 | Supplier:SupplierCity_SupplierState, _SupplierZip | Supplier:SupplierCity_SupplierState, _SupplierZip | 40 |
| pay_to_addr4 | 40 | ||
| pay_to_addr5 | 40 | ||
| pay_to_addr6 | 40 | ||
| attention_name | 40 | ||
| attention_phone | 30 | ||
| approval_code | 0 | 8 | |
| approval_flag | 0 | 0 | 1; (SMALLINT) |
| add_cost_flag | 0 | 0 | 1; (SMALLINT) |
| amt_freight | 0 | 0 | (FLOAT) |
| amt_misc | GLEntryDetail:Amount |
0 | (FLOAT) |
| amt_paid | 0 | 0 | (FLOAT) |
| amt_restock | 0 | 0 | (FLOAT) |
| amt_tax_included | 0 | 0 | (FLOAT) |
| class_code | 8 | ||
| cms_flag | 0 | 0 | 1; (SMALLINT) |
| date_entered | GLEntry:Date | 10 | |
| date_recurring | 10 | ||
| drop_ship_flag | 1; (SMALLINT) | ||
| fob_code | 8 | ||
| frt_calc_tax | 0 | (FLOAT) | |
| location_code | 0 | 8 | |
| one_check_flag | 0 | 1; (SMALLINT) | |
| recurring_code | 8 | ||
| recurring_flag | 0 | 0 | 1; (SMALLINT) |
| times_accrued | 0 | 0 | 1; (SMALLINT) |
| user_trx_type_code | VOUCHER | 8 | |
| vend_order_num | 20 | ||
| date_processed | DATETIME | ||
| processed_flag | 0 | INT | |
| Import_Identifier | INT | ||
| batch_no | INT | ||
| record_id_num | INT | ||
| User_ID | 30 | ||
| org_id | RA | RA | 30 |
| tax_freight_no_recoverable | 0 | 0 | (FLOAT) |
AP Detail
| Export Heading | Current Extract | New Extract | Field Length CHAR unless specified () |
| No Header Row | |||
| company_code | RA | RA | 8 |
| process_crtl_num | 16 | ||
| HeaderDetail | FALSE | Delete this field from export | |
| source_trx_ctrl_num | GLEntryKey | GLEntryKey | 16 |
| trx_crtl_num | 16 | ||
| trx_type | 4091 | 4091 | 4; (SMALLINT) |
| sequence_id | Line sequence in entry | Line sequence in entry | INT |
| location_code | 8 | ||
| item_code | 30 | ||
| qty_ordered | 0 | 1; (FLOAT) | |
| qty_received | 1 | 1 | 1; (FLOAT) |
| qty_returned | 0 | 1; (FLOAT) | |
| tax_code | NOTAX | NOTAX | 8 |
| return_code | 8 | ||
| code_1099 | 8 | ||
| po_ctrl_num | 16 | ||
| unit_code | EA | 8 | |
| unit_price | GLEntryDetail:Amount | GLEntryDetail:Amount | (FLOAT) |
| amt_discount | 0 | 1; (FLOAT) | |
| amt_tax | 0 | 1; (FLOAT) | |
| gl_exp_acct | GLEntryDetail:AccountKey | GLEntryDetail:AccountKey | 32 |
| line_desc | GLEntryDetail:Description | GLEntryDetail:Description | 60 |
| reference_code | 32 | ||
| rec_company_code | RA | RA | 8 |
| approval_code | 8 | ||
| amt_freight | 0 | 0 | 1; (FLOAT) |
| amt_misc | GLEntryDetail:Amount |
0 | (FLOAT) |
| bulk_flag | 0 | 1; (SMALLINT) | |
| clac_tax | 0 | 0 | 1; (FLOAT) |
| date_entered | GLEntry:Date | 10 | |
| new_gl_exp_acct | 32 | ||
| new_reference_code | 32 | ||
| po_orig_flag | 0 | 1; (SMALLINT) | |
| qty_prev_returned | 0 | 1; (FLOAT) | |
| rma_num | 20 | ||
| processed_flag | 0 | 1; (INT) | |
| Import_Identifier | (INT) | ||
| batch_no | (INT) | ||
| record_id_num | (INT) | ||
| User_ID | (INT) | ||
| org_id | RA | RA | 30 |
| amt_nonrecoverable_tax | 0 | 0 | 1; (FLOAT) |
| amt_tax_det | 0 | 0 | 1; (FLOAT) |
Downloads
| Version | Date | Install File Name | Comment |
- © Copyright 2022 Back Office Portal