AR Type:
No current BI AFRS Codes default in Databases.
(Transaction in data file has tran code & fund data).
a. Entire data file will import.
Assign tran code and fund value from data file.
Each document records will get following error message:
'Application Error: Cant find default AFRS Code for AR Type NO and DocCat ND -
|
N/A
| |
Data file: No Tran Code or Fund included in any of the transaction records
|
b. Reject entire file.
No batch created in DBs.
Invalid record is searchable with: 'Application Error: Cant find default AFRS Code for AR Type NO and DocCat ND.
'System Message 8034: Error in Field: ctrancode_2 Value:
'System Message 2: Data must be entered in this field
|
N/A
|
|
First valid record: no report of error.
Second valid record logged as: '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 logged as: '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.
|
|
Data file: Tran code & Fund included only in first transaction record
|
N/A
|
c. Batch is created.
Only first record with tran code & fund data information from the data is imported.
First Valid record in data file is logged as: 'Application Error: Cant find default AFRS Code for AR Type NO and DocCat ND
First Invalid record is searchable with: 'Application Error: Cant find default AFRS Code for AR Type NO and DocCat ND
'System Message 8034: Error in Field: ctrancode_2 Value:
'System Message 2: Data must be entered in this field
Later invalid records are searchable with: 'System Message 8055: ========Error Processing Document Data Line
'Application Error: Cant find default AFRS Code for AR Type NO and DocCat ND
'System Message 8034: Error in Field: ctrancode_2 Value:
'System Message 2: Data must be entered in this field
|
Data file: the first record DO NOT have tran code and fund information
|
d. Reject entire file.
No batched created in DBs.
Invalid record is searchable with: 'Application Error: Cant find default AFRS Code for AR Type NO and DocCat ND
'System Message 8034: Error in Field: ctrancode_2 Value:
'System Message 2: Data must be entered in this field
Remaining valid records logged as: '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.
|
N/A
|
20
|
Batch Control Amount:
Empty
|
Entire data file will import.
Because the Batch Control Amount and the Batch Total are out of balance, you will get the following warning message:
'System Message 818: Batch is out of balance by 100.00. Do you want to edit?
|
N/A
|
21
|
Batch Control Amount:
Invalid value - alpha characters
“@#$%^$$”
|
Entire data file will import.
Because the Batch Control Amount (default is 0.00) and the Batch Total are out of balance, you will get the following warning message:
'System Message 818: Batch is out of balance by 100.00. Do you want to edit?
|
N/A
|
22
|
Batch Control Amount:
Invalid value: alpha characters w/ numeric
"@#$%^.99”
|
Entire data file will import.
Because the Batch Control Amount (default is 0.00) and the Batch Total are out of balance, you will get the following warning message:
'System Message 818: Batch is out of balance by 100.00. Do you want to edit?
|
N/A
|
23
|
Batch Control Amount:
Invalid value size – digits greater than 10+2
|
Reject entire file.
No batch created in DBs.
'System Message 15: Entry must be less than or equal to 9999999999.99, please reenter
'System Message 8002: Error In Field: cctrltot_0 Value: ""90009990009.99"" Column 20
'System Message 8004: Data File Record/Line Number: 1 Column: 20
'System Message 8055: ========Error Processing Batch Data Line========
First valid record: no logs
Second valid record logged as: '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 records are logged as:
'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.
|
N/A
|
24
|
Batch Control Amount:
Invalid value: comma included in numeric value.
|
Entire data file will import.
|
N/A
|
|
|
25
|
Document header:
Empty
|
a. Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'Application Error: A valid Terms ID must be provided for the document before transactions can be entered.
‘System Message 6114: All key fields must be entered before you can enter data in this field.’
'System Message 818: Batch is out of balance by 10.00. Do you want to edit?
There is no searchable text by document. Number of error detected was 0.00
|
b. Batch is created in DBs.
Reject invalid record.
Invalid 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 30.00 Do You Wish to edit?
'System Message 818: Batch is out of balance by 30.00. Do you want to edit?
There is no searchable text by document. Number of error detected was 0.00.
|
26
|
Document header:
Invalid: ‘DocumentZZ’
|
Batch is created in DBs
Reject invalid record.
Invalid record is searchable with: 'System Message 8021: Invalid Level specified. Treated as a comment Line
'Application Error: A valid Terms ID must be provided for the document before transactions can be entered.
'System Message 6114: All key fields must be entered before you can enter data in this field.
'System Message 818: Batch is out of balance by 10.00. Do you want to edit?
There is no searchable text by document. Number of error detected was 0.00.
|
Batch is created in DBs
Reject invalid record.
Invalid record is searchable with: 'System Message 8021: Invalid Level specified. Treated as a comment Line
'*Invoice And DR Memo Entry v1.0.316 (OF.010.00): The Document Total Amount is not equal to the Document Amount by 30.00 Do You Wish to edit?
'System Message 818: Batch is out of balance by 80.00. Do you want to edit?
There is no searchable text by document. Number of error detected was 0.00.
|
27
|
Document Section:
Entire document row is missing
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'Application Error: A valid Terms ID must be provided for the document before transactions can be entered.
'System Message 6114: All key fields must be entered before you can enter data in this field.
|
Batch is created in DBs.
Transaction with no document gets imported into previous document.
Invalid 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 30.00 Do You Wish to edit?
|
28
|
Doc Type:
Invoice type: empty
|
?
|
?
|
29
|
Doc Ref:
Empty
|
a. Batch is created in DBs
Reject invalid record.
Invalid record is searchable with: 'System Message 6114: All key fields must be entered before you can enter data in this field.”
'Application Error: A valid Terms ID must be provided for the document before transactions can be entered.
'System Message 818: Batch is out of balance by 10.00. Do you want to edit?
There is no searchable text by document. Number of error detected was 0.00.
|
b. Batch is created in DBs
Reject invalid record.
Invalid record is searchable with: 'System Message 6114: All key fields must be entered before you can enter data in this field.”
'Application Error: A valid Terms ID must be provided for the document before transactions can be entered.
'System Message 818: Batch is out of balance by 30.00. Do you want to edit?
There is no searchable text by document. Number of error detected was 0.00.
|
30
|
Doc Ref:
Invalid: greater than 10 alphanumeric characters with first 10 characters being valid.
|
a. Entire data file will import.
Transaction Import will truncate doc ref value greater than allowed length.
|
b. Entire data file will import.
Transaction Import will truncate doc ref value greater than allowed length.
|
31
|
Doc Ref:
Invalid: asterisk, percentage or question mark
|
Reject entire file.
No batch created in DBs.
Invalid record is searchable with: 'System Message 8002: Error In Field: crefnbr Value: ""TB*%?01565"" Column 12
'System Message 8033: Invalid data. Value ""TB*%?01565"" does not match Mask ""UUUUUUUUUU""
'System Message 6114: All key fields must be entered before you can enter data in this field.’
'System Message 8055: ========Error Processing Document Data Line
'Application Error: A valid Terms ID must be provided for the document before transactions can be entered.
Valid record immediately follows invalid record is logged as:
'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 records are logged as:
'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: crefnbr Value: ""TB*%?01567"" Column 12
'System Message 8033: Invalid data. Value ""TB*%?01567"" does not match Mask ""UUUUUUUUUU""
'System Message 6114: All key fields must be entered before you can enter data in this field.
'System Message 8055: ========Error Processing Document Data Line
'Application Error: A valid Terms ID must be provided for the document before transactions can be entered.
|
32
|
Doc Ref:
Duplicate invoice number in AR/Solomon
|
Reject entire file.
No batch created in DBs
Invalid record is searchable with: 'System Message: Reference Number DUPLICATE is already used in Batch 003670
'System Message 8013: Item not found, please reenter. Control: crefnbr Key Value: ""DUPLICATE"" Column 12
'System Message 8004: Data File Record/Line Number: 2 Column: 12
'System Message 6114: All key fields must be entered before you can enter data in this field.
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid Terms ID must be provided for the document before transactions can be entered.
Valid record immediately follows invalid record is logged as:
'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 records are logged as:
'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: Reference Number DUPLICATE is already used in Batch 003670
'System Message 8013: Item not found, please reenter. Control: crefnbr Key Value: ""DUPLICATE"" Column 12
'System Message 8004: Data File Record/Line Number: 6 Column: 12
'System Message 6114: All key fields must be entered before you can enter data in this field.
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: A valid Terms ID must be provided for the document before transactions can be entered.
|
33
|
Doc Ref:
Duplicate invoice number in import data file.
|
N/A
|
Batch is created in DBs.
Will not include invalid document record (the SECOND instance of duplicate Doc #:)
Invalid record is searchable with: '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: ""AAC$"" Column 25
'System Message 8004: Data File Record/Line Number: 6 Column: 25
'System Message 8055: ========Error Processing Document Data Line========
|
34
|
Customer ID:
Empty Customer ID or
Blank Customer ID
|
Reject entire file.
No batch created in DBs.
Invalid record is searchable with: 'Application Error: A valid Terms ID must be provided for the document before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: ccustid_1 Value:
Remaining valid records are searchable by: 'System Message 8055: ========Error Processing Document Data
'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: 'Application Error: A valid Terms ID must be provided for the document before transactions can be entered.
'System Message 2: Data must be entered in this field
'System Message 8034: Error in Field: ccustid_1 Value:
Valid record immediately follows invalid record is reported with: 'System Message 8055: ========Error Processing Document Data
|
35
|
Customer ID:
Invalid Customer ID:
Value not exist in Customer ID table
|
Reject entire file.
No batch created in DBs.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8013: Item not found, please reenter. Control: ccustid_1 Key Value: ""INVALID"" Column 25
'System Message 8004: Data File Record/Line Number: 2 Column: 25
'System Message 8055: ========Error Processing Document Data Line
'Application Error: A valid Terms ID must be provided for the document before transactions can be entered.
Valid record immediately follows invalid record is logged as:
'Application Error: A valid Terms ID must be provided for the document 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 records are logged as: '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 9: Item not found, please reenter.
'System Message 8013: Item not found, please reenter. Control: ccustid_1 Key Value: ""INVALID"" Column 25
'System Message 8004: Data File Record/Line Number: 6 Column: 25
'System Message 8055: ========Error Processing Document Data Line
'Application Error: A valid Terms ID must be provided for the document before transactions can be entered.
|
36
|
Customer ID:
Invalid customer ID:
Greater than 10 characters with first 10 characters matching a valid customer id.
|
Entire data file will import.
|
Entire data file will import.
|
37
|
Customer ID:
Invalid Customer ID
Greater than 10 characters with first 10 characters do not match a valid customer ID.
|
Reject entire file.
No batch created in DBs.
Invalid record is searchable with: 'System Message 9: Item not found, please reenter.
'System Message 8013: Item not found, please reenter. Control: ccustid_1 Key Value: "NOMATCHLON"" Column 25
'System Message 8004: Data File Record/Line Number: 2 Column: 25
'System Message 8055: ========Error Processing Document Data Line
'Application Error: A valid Terms ID must be provided for the document before transactions can be entered.
Valid record immediately follows invalid record is logged as: '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 records are logged as:
'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 9: Item not found, please reenter.
|
