Home > The Back Office > CustomProjects > 1666_EpicorCustomExport

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

Edit section

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  

Supplier:VendorID

Change to Blank (" ")

8
vendor_code Supplier:VendorID Supplier:VendorID 12
pay_to_code Supplier:VendorID

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  

ACH

Change to "CHECK"

8
hold_flag 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

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

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
       
       
       
       

 

Last modified

Tags

Classifications

This page has no classifications.