Crystal Report Conversion for V8.5

A major improvement in Version 8.5 is the support of alphanumeric document numbers. This significant change adds flexibility and addresses the pressing issue that many Elliott users faced, which is running out of order and invoice numbers. The support of alphanumeric document numbers requires changes to the Data Dictionary Files (DDFs) that are used by external applications to access the data in Elliott. 

After converting to Elliott V8.5, new data dictionary files are installed in <ElliottRoot>\Bin85\DDF40  (<ElliottRoot> is the root directory where Elliott is installed, such as M:\Elliott8). After changing the directory settings for the database to use the new DDFs or changing the DSN to one that uses the V8.5 DDFs, Crystal will discover type mismatches in your reports. 

For example, accessing a report that is using the CPINVLIN_VIEW will report that there are now mapped fields. This is due to the fact that the data type has changed from a numeric value to a string. To resolve this issue:

1. Uncheck “Match Type.”


Notice that INV_NO and INV_ORDER_NO are listed in the unmapped fields. 

2. Highlight INV_NO in the unmapped fields. Find “INV_NO” on list of top-right box.

3. Click “INV_NO” from top-right box then click button “Map.” “INV_NO” would move down to box “Mapped Fields” in the lower left hand corner.

4. Follow the same procedure for any remaining fields. 

5. Click OK to save your changes.

All document numbers in Elliott V8.5 were changed. Below is a list of the tables and fields that were affected.

 * TABLE: APADJTRX_MNUL
AP_OPN_ADJ_CHK_NO_M

* TABLE: APADJTRX_TERM
AP_OPN_ADJ_CHK_NO_T

* TABLE: APCHKHST
APCHKHST_CHECK_NO

* TABLE: APDISFIH
AP_DISH_VHR1_OR_CHK1

* TABLE: APDISFIL
AP_DIST_VHR1_OR_CHK1

* TABLE: APDSTHST
APDSTHST_VOUCHER_NO
APDSTHST_DOC_NO

* TABLE: APHISFIL
AP_HIST_VOUCHER_NO

* TABLE: APOPNFIL_CHK
AP_OPEN_CHECK_NO
AP_OPN_CHK_VCH_NO_C

* TABLE: APOPNFIL_VHR
AP_OPEN_VOUCHER_NO_V

* TABLE: APRCNFIL
AP_RECON_VOUCH_NO_1
AP_RECON_ORDER_NO
AP_RECON_DOC_NO
AP_RECON_VOUCH_NO_2

* TABLE: APRCNHIS
AP_RECON_HIST_VCH_N1
AP_RECON_HIST_ORD_NO
AP_RECON_HIST_DOC_NO
AP_RECON_HIST_VCH_N2

* TABLE: APTRXDST
NEW_AP_DIST_VCHR_NO
NEW_AP_DIST_DOC_NO

* TABLE: APTRXFIL
NEW_AP_VCHR_NO
NEW_AP_CHK_NO

* TABLE: APVENFIL
VEND_CHK_NO

* TABLE: ARADJAUD
ADJ_DOCUMENT_NO
ADJ_APPLY_TO_NO

* TABLE: ARCOMDUE
COM_DOC_NO

* TABLE: ARCOMHST
COMM_HST_DOCUMENT_NO

* TABLE: ARCRCLOG
ARCRCLOG_LOG_NO
ARCRCLOG_LOG_NO_ALT
ARCRCLOG_APPLY_TO

* TABLE: ARCRCTRX
ARCRCTRX_APPLY_TO

* TABLE: ARCSHAPL
CSH_APL_CK_NO
CSH_APL_APPLY_TO

* TABLE: ARCSHIFC
CSHIFC_CHECK_NO

* TABLE: ARCSHTRX
CSH_CK_NO

* TABLE: ARCUSCON
ARCUSCON_CONTRACT_NO
ARCUSCON_ALT_CONTRAC

* TABLE: ARDISFIH
AR_DISH_DOC_NO

* TABLE: ARDISFIL
AR_DIST_DOC_NO

* TABLE: ARHISFIL
AR_HIS_DOC_NO
AR_HIS_APP_TO_NO
AR_HIS_APP_TO_NO_ALT

* TABLE: AROPNFIL
AR_OPN_DOC_NO
AR_OPN_APPLY_TO
AR_OPN_APPLY_TO_ALT

* TABLE: ARSLSDST
SALES_DIST_DOC_NO

* TABLE: ARSLSTRX
SALES_DOC_NO
SALES_APPLY_TO

* TABLE: ARSRVTRX_HDR
SERV_DOCUMENT_NO
SERV_TRX_APPLY_TO_NO

* TABLE: ARSRVTRX_LINE
SERV_DOCUMENT_NO_L

* TABLE: ARSTLFIL
STL_INVOICE_NO
STL_INVOICE_NO_1
STL_INVOICE_NO_2

* TABLE: BANKREC
BK_REC_CHECK_AL1
BK_REC_CHECK_AL3

* TABLE: BMDISFIH
BM_DISH_ORDER_NO

* TABLE: BMDISFIL
BM_DIST_ORDER_NO

* TABLE: BMENGCHG
BM_ENG_CHG_CHANGE_NO

* TABLE: BMENGHST
ENG_CHG_HST_CHG_NO

* TABLE: BMHSTMTL
BMHSTMTL_ORD_NO

* TABLE: BMHSTSER
BMHSTSER_ORD_NO
BMHSTSER_ORD_NO2

* TABLE: BMHSTTRX
BMHSTTRX_ORD_NO

* TABLE: BMJOBHST
BM_JOBHST_ORDER_NO
BM_JOBHST_PKG_ORD_NO

* TABLE: BMLSTRXS
BM_INV_LS_TRX_ORD_NO

* TABLE: BMORDFIL
PRD_ORD_ORDER_NO
PRD_ORD_PKG_ORDER_NO

* TABLE: BMORDMTL
ORDMTL_ORDER_NO
ORDMTL_ORDER_NO_1
ORDMTL_ORDER_NO_2

* TABLE: BMORDOPT
PRD_ORD_OPT_ORDER_NO

* TABLE: BMORDRTG
ORDRTG_ORDER_NO

* TABLE: BMORDSER
PROD_ORD_SER_ORD_NO

* TABLE: BMORDTRX
PRD_ORD_TRX_ORDER_NO

* TABLE: BMPRDDTL
BMPRDDTL_ORDER_NO

  * TABLE: BMPTXCST
PRDCST_ORDER_NO

* TABLE: BMPTXFIL
BMPTXFIL_ORDER_NO
BMPTXFIL_REV_ORD_NO

* TABLE: BMPTXHST
BMPTXHST_ORDER_NO
BMPTXHST_REV_ORD_NO

* TABLE: BMTRXFIL
BMTRXFIL_ORD_NO

* TABLE: BMTRXMTL
BMTRXMTL_ORD_NO

* TABLE: BMTRXSER
BMTRXSER_ORD_NO
BMTRXSER_ORD_NO2

* TABLE: CHECKREC
CHK_REC_CHK_NO

* TABLE: CPBOLDTL
BOLDTL_ORD_NO
BOLDTL_ORD_NO_ALT

* TABLE: CPBOLHDR
BOLORD_ORD_NO
BOLORD_ORD_NO_ALT
BOLORD_ORD_NO_ALT2

* TABLE: CPBOLORD
BOLORD_INV_NO
BO_WRK_ORDER_NO
BO_WRK_BM_ORD_NO

* TABLE: CPBOXFHS
CPBOXFHS_INV_NO

* TABLE: CPBOXFIL
CPBOXFIL_ORDER_NO

* TABLE: CPBOXHSR
CPBOXHSR_INV_NO
CPBOXHSR_INV_NO3

* TABLE: CPBOXHST
CPBOXHST_INV_NO
CPBOXHST_INV_NO1

* TABLE: CPBOXSER
CPBOXSER_ORD_NO
CPBOXSER_ORD_NO3

* TABLE: CPBOXSHP
CPBOXSHP_ORD_NO
CPBOXSHP_ORD_NO1

* TABLE: CPCONHDR
CPCONHDR_CONTRACT_NO

* TABLE: CPCONITM
CPCONITM_CONTRACT_NO
CPCONITM_CONTRAC_NO2

* TABLE: CPCUSPOF
CUSPOF_1ST_ORD_NO

* TABLE: CPFBOAUD
BO_AUD_ORDER_NO

* TABLE: CPFBOTRX
CPFBOTRX_ORDER_NO

* TABLE: CPFBWORK
CPFBWORK_ORDER_NO

* TABLE: CPHODHDR
CPHODHDR_ORD_NO
CPHODHDR_APPLY_TO
CPHODHDR_ORD_NO_ALT
CPHODHDR_CHECK_NO
CPHODHDR_INVC_NO

* TABLE: CPHODLIN
CPHODLIN_ORDER_NO
CPHODLIN_ALT_ORD_1
CPHODLIN_ALT_ORD_2
CPHODLIN_BM_ORD_NO
CPHODLIN_BLT_ORD_NO

* TABLE: CPHODMTL
CPHODMTL_ORDER_NO
CPHODMTL_ORDER_NO_1

* TABLE: CPHODOPT
CPHODOPT_ORDER_NO

* TABLE: CPHODRTG
CPHODRTG_ORDER_NO

* TABLE: CPHSTTRX
HIST_TRX_INV_NO
HIST_TRX_ORDER_NO

* TABLE: CPINVHDR
INV_NO
INV_APPLY_TO_NO
INV_NO_ALT
INV_CHECK_NO
INV_ORDER_NO

* TABLE: CPINVLIN
INV_ITM_INV_NO
INV_ITM_BM_ORDER_NO
INV_ITM_ORG_BK_ORDNO

* TABLE: CPINVMTL
CPINVMTL_ORDER_NO
CPINVMTL_ORDER_NO_1

* TABLE: CPINVOPT
COP_INV_OPT_INV_NO

* TABLE: CPINVRTG
CPINVRTG_ORDER_NO

* TABLE: CPLINAUD
LINE_AUD_ORDER_NO
LINE_AUD_ORD_NO_ALT
LINE_AUD_ORD_NO_ALT1
LINE_AUD_ORIG_ORD_NO

* TABLE: CPLSTRXS
CPINV_LS_TRX_ORDR_NO

* TABLE: CPOPNSLM
OPEN_SLM_ORDER_NO

* TABLE: CPORDHDR
ORDER_NO
ORDER_APPLY_TO_NO
ORDER_NO_ALT
ORDER_CHECK_NO
ORDER_INVOICE_NO

* TABLE: CPORDLIN
LINE_ITM_ORDER_NO
LINE_ITM_ORD_NO_ALT1
LINE_ITM_ORD_NO_ALT2
LINE_ITM_BM_ORDER_NO
LINE_ITM_BKT_ORD_NO

* TABLE: CPORDLS
ORD_LINE_LS_ORD_NO

* TABLE: CPORDMTL
CPORDMTL_ORDER_NO
CPORDMTL_ORDER_NO_1

* TABLE: CPORDOPT
COPORD_OPT_ORDER_NO

* TABLE: CPORDPMT
CPORDPMT_DOC_NO
CPORDPMT_APPLY_TO_NO

* TABLE: CPORDRTG
CPORDRTG_ORDER_NO

* TABLE: CPPOITMD
POITMD_ORD_NO

* TABLE: CPPOITMF
POITMF_1ST_ORD_NO

* TABLE: CPPOPEND
CPPO_PEND_PO_NO

* TABLE: CPPOREF
PO_REF_ORDER_NO

* TABLE: CPPROMID
CPPROMID_INV_NO

* TABLE: CPPUDELH
PUDELH_INV_NO
PUDELH_ORD_NO

* TABLE: CPPUDELV
PUDELV_INV_NO
PUDELV_ORD_NO

* TABLE: CPRECHDR
RECUR_ORDER_NO
RECUR_APPLY_TO_NO
RECUR_ORDER_NO_ALT
RECUR_ORDER_NO2

* TABLE: CPRECLIN
REC_ITM_ORDER_NO
REC_ITM_ORD_NO_ALT1
REC_ITM_ORD_NO_ALT2

* TABLE: CPSABATC
CPSABATC_START_ORDER
CPSABATC_END_ORDER

* TABLE: CPSABATL
CPSABATL_ORDER_NO

* TABLE: CPSABATO
CPSABATO_ORDER_NO

* TABLE: CPSJNWRK
SALES_JRNL_DOC_NO
SALES_JRNL_ORDER_NO

* TABLE: CPSTGDTL
CPSTGDTL_ORDER_NO

* TABLE: CPSTGSORD
CPSTGORD_ORDER_NO

* TABLE: CPSTGSER
CPSTGSER_ORDER_NO

* TABLE: CPSTGSLP
STAGING_ORDER_NO

* TABLE: CPSTGUSR
CPSTGUSR_ORDER_NO

* TABLE: CPWMSDTL
CPWMSDTL_ORDER_NO

* TABLE: CPWMSORD
CPWMSORD_ORDER_NO
CPWMSORD_ORDER_NO_3

* TABLE: IMCTLFIL
IM_CTL_NEXT_DOC_NO

* TABLE: IMINVTRX
INV_TRX_DOC_NO

* TABLE: IMTAGFIL
TAG_NO
TAG_NO_ALT

* TABLE: IMTAGSER
IM_TAG_SER_TAG_NO
IM_TAG_SER_TAG_NO_2

* TABLE: IMTAGWRK
TAG_WK_TAG_NO

* TABLE: IMTRXDST
IM_TRX_DIST_DOC_NO
IM_TRX_DIST_DOC_ALT

* TABLE: IMTRXFIL
IM_TRX_DOC_NO

* TABLE: IMTRXSER
IM_TRX_SER_DOC_NO

* TABLE: JOBHIST_AP
JOB_HST_VCHR_NO_AP

* TABLE: JOBHIST_AR
JOB_HST_AR_INV_AR

* TABLE: JOBHIST_IM
JOB_HST_DOC_NO_IM

* TABLE: JOBHIST_PR
JOB_HST_CHK_NO_PR

* TABLE: MNTRXFIL
MNL_TRX_CHK_NO

* TABLE: NSCTLFIL_1
LAST_INV_NO_USED

* TABLE: NSCTLFIL_13
STARTING_CONTRACT_NO
NEXT_WEB_ORDER_NO
NEXT_CREDIT_LOG_NO

* TABLE: NSCTLFIL_15
LAST_WEB_VOUCHER_NO

* TABLE: NSCTLFIL_18
START_RECUR_NO
NEW_IMPORT_ORDER_NO
CHG_IMPORT_ORDER_NO

* TABLE: NSCTLFIL_22
NEXT_WEB_PROD_ORDER

* TABLE: NSCTLFIL_29
NEXT_MANUAL_CHECK

* TABLE: NSCTLFIL_30
ACH_LAST_BATCH_NO

* TABLE: NSCTLFIL_2001
LAST_VOUCHER_NO

* TABLE: NSCTLFIL_2002
START_INVOICE_NO

* TABLE: NSCTLFIL_2003
START_ORDER_NO

* TABLE: NSCTLFIL_2004
STARTING_PO_NO
NEXT_DOC_NO

* TABLE: NSCTLFIL_2006
NEXT_ORDER_NO
NEXT_ENGR_CHG_NO

* TABLE: POAUDCOM
POACOM_ORDER_NO

* TABLE: POAUDHDR
POAHDR_ORDER_NO
POAHDR_ORDER_NO_ALT

* TABLE: POAUDLIN
POALIN_ORDER_NO

* TABLE: POCOMFIL
ITEM_COM_ORDER_NO

  * TABLE: POINVHDH
POINVHDH_VOUCHER_NO

* TABLE: POINVLIH
POINVLIH_PO_NO
POINVLIH_RCPT_DOC_N0

* TABLE: POINVLIN
POINVLIN_PO_NO
POINVLIN_RCPT_DOC_NO

* TABLE: POLINHST
LINE_HIST_ORDER_NO

* TABLE: POORDHDR
ORD_HDR_ORDER_NO
ORD_HDR_ORDER_NO_ALT

* TABLE: POORDLIN
ORD_LINE_ORDER_NO

* TABLE: POPURECI
POPURECI_DOC_NO

* TABLE: PORCNFIL
PO_RECON_ORDER_NO
PO_RECON_DOC_NO_1
PO_RECON_DOC_NO_2

* TABLE: PORCNHIS
PO_RECON_HIS_ORD_NO
PO_RECON_HIS_DOC_NO1
PO_RECON_HIS_DOC_NO2

* TABLE: PORECAUD
REC_AUD_ORDER_NO
REC_AUD_DOC_NO

* TABLE: POREQTRX
PO_REQ_TRX_BO_ORDNO

* TABLE: POSHPFIL
SHIP_TO_PO_START_NO

* TABLE: POTRXDST
REC_TRX_DIST_ORD_NO
REC_TRX_DIST_DOC_NO
REC_TRX_DST_DOCNOALT

* TABLE: POTRXFIL
REC_TRX_ORDER_NO
REC_TRX_DOC_NO

* TABLE: POTRXSER
REC_TRX_SER_ORD_NO
REC_TRX_SER_DOC_NO

* TABLE: POWHHSTI
POWHHSTI_DOC_NO

* TABLE: POWHRECI
POWHRECI_DOC_NO

* TABLE: PRCHKFIL
PAYROLL_CHECK_NO

* TABLE: PRCHKREC
PR_REC_CHK_NO

* TABLE: PRDEDHST
PR_DED_HIST_CHK_NO

* TABLE: PRDISFIH
PR_DISH_CHK_NO

* TABLE: PRDISFIL
PR_DIST_CHK_NO

* TABLE: PRHISFIL
PR_HIST_CHK_NO

* TABLE: PRHSTCDE_LI
L_I_HIST_CHECK_NO

* TABLE: PRHSTCDE_SHIFT
SHIFT_HIST_CHECK_NO

* TABLE: PRTIMFIL
PR_TIME_CHK_NO

* TABLE: SFORDFIL_HDR
SO_HDR_COP_ORDER_CD

* TABLE: SYACHBAD
SYACHBAD_BATCH_NO
SYACHBAD_BAT_NO_ALT
SYACHBAD_DOCUMENT_NO

* TABLE: SYACHBAT
SYACHBAT_BATCH_NO

* TABLE: SYACHQUE
SYACHQUE_DOCUMENT_NO

* TABLE: WSORDHDR
ORDER_NO
ORDER_APPLY_TO_NO
ORDER_NO_ALT
ORDER_CHECK_NO
ORDER_INVOICE_NO

* TABLE: WSORDLIN
LINE_ITM_ORDER_NO
LINE_ITM_ORD_NO_ALT1
LINE_ITM_ORD_NO_ALT2
LINE_ITM_BM_ORDER_NO
LINE_ITM_BKT_ORD_NO

CLS

Elliott Version 8.5

  1. V8.5 Alpha Document Number Support
  2. Crystal Report Conversion for V8.5
  3. Animating COBOL Code in Elliott V8.5
  4. The Run Local or Hybrid Feature in Elliott 8.5
  5. How to Use EL850DB.EXE Utility to Create PSQL Databases
  6. PSQL Database Naming Convention for 8.5 Databases
  7. Showing Document Date in Links After Elliott 8.5
  8. The Lessons We Learned from Upgrading Web Service 8.2 to 8.5 in eStore
  9. Report Desk Tables
  10. Report Desk Delivery Strategy
  11. Report Desk Thresholds
  12. How Is Font Being Determined in Report Desk?
  13. How to Use DebugLogLevel Registry Value to Debug Report Desk Issues
  14. How to Use Report Desk – User Perspective
  15. How to Use Report Desk – Admin Perspective
  16. Feature - ASCII File Filter Condition in Mass Email and Export Processor
  17. How to Use Variables in Report Desk Title and Column Headings
  18. How to Override Report Desk Font and Margin Defaults
  19. Feature - List Users Acively Logged into Elliott and Optionally Send Email
  20. Feature - Allow Print One Invoice to Print Duplicate Invoices for Order Not Posted
  21. Feature - Print Range of Duplicate Unposted Orders
  22. Feature - Prevent Duplicate Invoice Numbers with Invoice Cross Reference File
  23. Feature - Last Year Net Income Layout Support
  24. Receive Message "Not Found" When Trying to Set Up Run Local
  25. Receive 'Invalid Column Name' Message After Starting to Use Alphabetic Document Numbers
  26. Feature - Invoice Log Report
  27. Feature - Add Sales or Usage to Where-Used inquiry
  28. Feature - Case Size Support for Quantity Per Box
  29. Feature - Exclude Obsolete Customers from Customer Generic Search
  30. Feature - Refresh VICS Bill of Lading
  31. Feature - Support Item Case Size in New Item CSV Import and Change Existing Item Import
  32. Feature - Copy Notes, Attributes, and Links When Copying Item Through the New Item CSV Import
  33. Feature - Enhanced Cash Receipts Processing Apply-To Range
  34. Feature - Add Links Import to System Files Setup
  35. Feature - Shipment Email Acknowledgement for Bill-To Customers
  36. Feature - Restrict Sending Tracking Number to Bill-To Customer in Shipment Email Acknowledgement
  37. Overriding Report Desk Report Configuration
  38. Report Desk: Using Global Variables and Parameters
  39. Using CheckBoxes in Report Desk

Feedback and Knowledge Base