Tran Amount:
Empty. However qty and unit price data are available.
Batch is created in DBs.
TI will import and set empty tran amount to system’s calculated tran amount.
TI will import valid records.
Out of Balance record is searchable with: '*Invoice And DR Memo Entry v1.0.316 (OF.010.00): The Document Total Amount is not equal to the Document Amount by 55.07 Do You Wish to edit?
'*Invoice And DR Memo Entry v1.0.316 (OF.010.00): The Document Print Amount is not equal to the Document Amount by .00 Do You Wish to edit?
|
Batch is created in DBs.
TI will import and set empty tran amount to system’s calculated tran amount.
TI will import valid records.
Out of Balance record is searchable with: '*Invoice And DR Memo Entry v1.0.316 (OF.010.00): The Document Total Amount is not equal to the Document Amount by 29.74 Do You Wish to edit?
'*Invoice And DR Memo Entry v1.0.316 (OF.010.00): The Document Print Amount is not equal to the Document Amount by .00 Do You Wish to edit?
|
62
|
Tran Amount:
Invalid value: Empty.
No data in Qty & Unit Price fields.
|
Batch is created in DBs.
TI will import invalid record and set empty tran amount to system’s calculated tran amount.
TI rejects all valid records following invalid trans amount record.
Invalid record is searchable with: 'System Message 92: Amount must be greater than zero, please reenter.
Valid record immediately follows invalid record and Remaining valid records are searchable with:
'System Message 92: Amount must be greater than zero, please reenter.
'System Message 35: Once transactions are entered, this field cannot be changed
'System Message 8013: Item not found, please reenter. Control: ccustid_1 Key Value: ""AAB$"" Column 25
'System Message 8004: Data File Record/Line Number: 4 Column: 25
'System Message 8055: ========Error Processing Document Data Line
|
Batch is created in DBs.
TI will import invalid record and set empty tran amount to system’s calculated tran amount.
Valid records imported.
Invalid record is searchable with: 'System Message 92: Amount must be greater than zero, please reenter.
Valid record immediately follows invalid record is searchable with: 'System Message 8055: ========Error Processing Document Data Line========
|
63
|
Tran Amount:
Invalid value: 0.000
Data example with value in quantity and unit price fields.
|
Batch is created in DBs.
TI will import invalid record and set zero tran amounts to system’s calculated tran amount.
TI rejects all valid records following invalid trans amount record.
Invalid record is searchable with: 'System Message 92: Amount must be greater than zero, please reenter.
Valid record immediately follows invalid record and Remaining valid records are searchable with:
'System Message 92: Amount must be greater than zero, please reenter.
'System Message 35: Once transactions are entered, this field cannot be changed
'System Message 8013: Item not found, please reenter. Control: ccustid_1 Key Value: ""AAB$"" Column 25
'System Message 8004: Data File Record/Line Number: 4 Column: 25
'System Message 8055: ========Error Processing Document Data Line
|
Batch is created in DBs.
TI will import invalid record and set empty tran amount to system’s calculated tran amount.
Valid records imported.
Invalid record is searchable with: 'System Message 92: Amount must be greater than zero, please reenter.
Valid record immediately follows invalid record is searchable with: 'System Message 8055: ========Error Processing Document Data Line========
|
64
|
Tran Amount:
Zero.
No data in Qty & Unit Price fields.
|
Batch is created in DBs.
TI will import invalid record and set zero trans amount to system’s default amount.
TI rejects all valid records following invalid trans amount record.
Invalid record is searchable with: 'System Message 92: Amount must be greater than zero, please reenter.
Valid record immediately follows invalid record and Remaining valid records are searchable with:
'System Message 92: Amount must be greater than zero, please reenter.
'System Message 35: Once transactions are entered, this field cannot be changed
'System Message 8013: Item not found, please reenter. Control: ccustid_1 Key Value: ""AAB$"" Column 25
'System Message 8004: Data File Record/Line Number: 4 Column: 25
'System Message 8055: ========Error Processing Document Data Line
|
Batch is created in DBs.
TI will import invalid record and set zero trans amount to system’s default amount.
Valid records imported.
Invalid record is searchable with: 'System Message 92: Amount must be greater than zero, please reenter.
Valid record immediately follows invalid record is searchable with: 'System Message 8055: ========Error Processing Document Data Line========
|
65
|
Tran Amount:
Invalid value: Negative
|
Reject entire file
No batch created in DBs.
Invalid record is searchable with: 'System Message 18: Entry must be greater than or equal to .00, please reenter.
'System Message 8002: Error In Field: camount_2 Value: "" -10.00"" Column 29
'System Message 8004: Data File Record/Line Number: 3 Column: 29
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with: 'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by: 'System Message 8055: ========Error Processing Document Data Line
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs
Reject invalid record.
Invalid record is searchable with: 'System Message 18: Entry must be greater than or equal to .00, please reenter.
'System Message 8002: Error In Field: camount_2 Value: "" -30.00"" Column 26
'System Message 8004: Data File Record/Line Number: 7 Column: 26
'System Message 8055: ========Error Processing Transaction Data Line
|
66
|
Tran Amount:
Invalid value: Alpha
|
Reject entire file
No batch created in DBs.
Invalid record is searchable with: 'System Message 8002: Error In Field: camount_2 Value: ""ZZZ"" Column 29
'System Message 8004: Data File Record/Line Number: 3 Column: 29
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'System Message 8002: Error In Field: camount_2 Value: ""ZZZ"" Column 26
'System Message 8004: Data File Record/Line Number: 7 Column: 26
'System Message 8055: ========Error Processing Transaction Data Line
|
67
|
Tran Amount:
Invalid value: Symbols
|
Reject entire file
No batch created in DBs.
Run-Time Error ‘13’ Type mismatch
'System Message 6114: All key fields must be entered before you can enter data in this field.
'System Message 47: Invalid date format, please re-enter as MM/DD/YY.
'System Message 8002: Error In Field: dSvsDate Value: ""012"" Column 66
'System Message 8004: Data File Record/Line Number: 4 Column: 66
|
Batch is created in DBs.
Imported valid records prior to invalid record.
Reject invalid record.
Run-Time Error ‘13’ Type mismatch
'System Message 6114: All key fields must be entered before you can enter data in this field.
'System Message 47: Invalid date format, please re-enter as MM/DD/YY.
'System Message 8002: Error In Field: dSvsDate Value: ""012"" Column 66
'System Message 8004: Data File Record/Line Number: 8 Column: 66
|
68
|
Tran Amount:
Invalid value
Data example: 99,000,999,999.99 (11+2)
|
Reject entire file
No batch created in DBs.
Invalid record is searchable with: 'System Message 15: Entry must be less than or equal to 9999999999.99, please reenter.
'System Message 8002: Error In Field: camount_2 Value: ""99000999000.99"" Column 29
'System Message 8004: Data File Record/Line Number: 3 Column: 29
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'System Message 15: Entry must be less than or equal to 9999999999.99, please reenter.
'System Message 8002: Error In Field: camount_2 Value: ""99000999000.99"" Column 26
'System Message 8004: Data File Record/Line Number: 7 Column: 26
'System Message 8055: ========Error Processing Transaction Data Line========
|
69
|
Tran Amount:
Invalid: Alpha and Numeric
|
Reject entire file
No batch created in DBs.
'System Message 8002: Error In Field: camount_2 Value: ""1o.00"" Column 29
'System Message 8004: Data File Record/Line Number: 3 Column: 29
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs.
Reject invalid record.
'System Message 8002: Error In Field: cunitprice_2 Value: ""3X3"" Column 19
'System Message 8004: Data File Record/Line Number: 7 Column: 19
'System Message 8055: ========Error Processing Transaction Data Line========
|
70
|
Print Amount:
Invalid value: Empty
Data file has qty and unit price data. Print amount is empty.
|
Batch is created in DBs.
TI will import and set empty print amount to system’s calculated print amount.
TI will import valid records.
Out of Balance is searchable with: '*Invoice And DR Memo Entry v1.0.316 (OF.010.00): The Document Print Amount is not equal to the Document Amount by 55.07 Do You Wish to edit?
|
Batch is created in DBs.
TI will import and set empty print amount to system’s calculated print amount.
TI will import valid records.
Out of Balance is searchable with: '*Invoice And DR Memo Entry v1.0.316 (OF.010.00): The Document Print Amount is not equal to the Document Amount by 29.74 Do You Wish to edit?
|
71
|
Print Amount:
Invalid value: Empty
Data file does not have qty and unit price data. Print amount is empty.
|
Batch is created in DBs.
TI override empty print amount with a copy of value from transaction amount.
|
Batch is created in DBs.
TI override empty print amount with a copy of value from transaction amount.
|
72
|
Print Amount:
Invalid value: 0.00
|
Batch is created in DBs.
TI import print amount zero data as is.
Out of Balance record is searchable with: *Invoice And DR Memo Entry v1.0.316 (OF.010.00): The Document Print Amount is not equal to the Document Amount by 10.00 Do You Wish to edit?
'*Invoice And DR Memo Entry v1.0.316 (OF.010.00): The Document Print Amount is not equal to the Document Amount by 10.00 Do You Wish to edit?
|
Batch is created in DBs.
TI Import print amount zero data as is.
Out of Balance record is searchable with: '*Invoice And DR Memo Entry v1.0.316 (OF.010.00): The Document Print Amount is not equal to the Document Amount by 30.00 Do You Wish to edit?
|
73
|
Print Amount:
Invalid value: Negative
|
Reject entire file.
No batch created in DBs.
Invalid record is searchable with: 'System Message 18: Entry must be greater than or equal to .00, please reenter.
'System Message 8002: Error In Field: ctranprntamt Value: ""-10.00"" Column 37
'System Message 8004: Data File Record/Line Number: 3 Column: 37
'System Message 8055: ========Error Processing Transaction Data Line========
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'System Message 18: Entry must be greater than or equal to .00, please reenter.
'System Message 8002: Error In Field: ctranprntamt Value: ""-30.00"" Column 34
'System Message 8004: Data File Record/Line Number: 7 Column: 34
'System Message 8055: ========Error Processing Transaction Data Line========
|
74
|
Print Amount:
Invalid value: Alpha
|
Reject entire file.
No batch created in DBs.
Invalid record is searchable with: 'System Message 15: Entry must be less than or equal to 999999999.99, please reenter.
'System Message 8002: Error In Field: ctranprntamt Value: ""1o.00"" Column 37
'System Message 8004: Data File Record/Line Number: 3 Column: 37
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'System Message 15: Entry must be less than or equal to 999999999.99, please reenter.
'System Message 8002: Error In Field: ctranprntamt Value: ""3o.00"" Column 34
'System Message 8004: Data File Record/Line Number: 7 Column: 34
'System Message 8055: ========Error Processing Transaction Data Line
|
75
|
Print Amount:
Invalid value: Symbols
|
Reject entire file.
No batch created in DBs.
Run-Time Error ‘13’.
Type mismatched.
'System Message 47: Invalid date format, please re-enter as MM/DD/YY.
'System Message 8002: Error In Field: dSvsDate Value: ""012"" Column 66
'System Message 8004: Data File Record/Line Number: 4 Column: 66
|
Batch is created in DBs.
Imported valid records prior to invalid record.
Run-Time Error ‘13’.
Type mismatched.
'System Message 47: Invalid date format, please re-enter as MM/DD/YY.
'System Message 8002: Error In Field: dSvsDate Value: ""012"" Column 66
'System Message 8004: Data File Record/Line Number: 8 Column: 66
|
76
|
Print Amount:
Invalid value:
Data example: 9,000,999,000.99
(10 + 2)
|
Reject entire file
No batch created in DBs.
Invalid record is searchable with: 'System Message 15: Entry must be less than or equal to 999999999.99, please reenter.
'System Message 8002: Error In Field: ctranprntamt Value: ""9000999000.99"" Column 37
'System Message 8004: Data File Record/Line Number: 3 Column: 37
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'System Message 15: Entry must be less than or equal to 999999999.99, please reenter.
'System Message 8002: Error In Field: ctranprntamt Value: ""9000999000.99"" Column 34
'System Message 8004: Data File Record/Line Number: 7 Column: 34
'System Message 8055: ========Error Processing Transaction Data Line========
|
77
|
Print Amount:
Invalid value: Numeric and Alpha
|
Reject entire file.
No batch created in DBs.
Invalid record is searchable with: 'System Message 15: Entry must be less than or equal to 999999999.99, please reenter.
'System Message 8002: Error In Field: ctranprntamt Value: ""1o.00"" Column 37
'System Message 8004: Data File Record/Line Number: 3 Column: 37
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows invalid record is searchable with:
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Remaining valid record are searchable by:
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid AR Type must be provided for the batch before transactions can be entered.’
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: cartype_0 Value:
Best recognition of error is that a batch number was not assigned, indicating that a batch was not created and that the entire data file failed the import.
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'System Message 15: Entry must be less than or equal to 999999999.99, please reenter.
'System Message 8002: Error In Field: ctranprntamt Value: ""3o.00"" Column 34
'System Message 8004: Data File Record/Line Number: 7 Column: 34
'System Message 8055: ========Error Processing Transaction Data Line========
|
78
|
|
