'System Message 8013: Item not found, please reenter. Control: ccustid_1 Key Value: ""NOMATCHLON"" 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.
38
|
Customer ID:
Inactive 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: ""INACTIVE"" 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:
|
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: ""INACTIVE"" Column 25
'System Message 8004: Data File Record/Line Number: 8 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.
|
|
|
'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.
|
|
39
|
Customer Description:
Empty
|
Will import
|
Will import
|
40
|
Customer Description:
Invalid: over 30 characters
|
Batch is created in DBs
Data is truncated.
|
Batch is created in DBs
Data is truncated.
|
41
|
Doc Amount:
Empty
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'Application Error: Document Amount must be greater than zero before transactions may be entered
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'Application Error: Document Amount must be greater than zero before transactions may be entered
|
42
|
Doc Amount:
Invalid value: $0.00
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'Application Error: Document Amount must be greater than zero before transactions may be entered”
|
Batch is created in DBs.
Reject invalid record.
Invalid record is searchable with: 'Application Error: Document Amount must be greater than zero before transactions may be entered”
|
43
|
Doc/Tran Amount:
Invalid $0.00 doc amount & Transaction Amount: $0.00
|
Batch is created in DBs.
Reject invalid record.
Invalid document record is searchable with: 'Application Error: Document Amount must be greater than zero before transactions may be entered”
Invalid Transaction 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========
|
Batch is created in DBs.
Reject invalid record.
Invalid document record is searchable with: 'Application Error: Document Amount must be greater than zero before transactions may be entered”
Invalid Transaction 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========
|
44
|
Doc Amount:
Invalid: Two $0.00 records preceding a valid record.
|
Batch is created in DBs
Reject invalid record.
Invalid document record is searchable with: 'Application Error: Document Amount must be greater than zero before transactions may be entered.
|
Batch is created in DBs
Reject invalid record.
Invalid document record is searchable with: 'Application Error: Document Amount must be greater than zero before transactions may be entered.
|
45
|
Doc Amount:
Negative amount
|
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: corigdocamt_1 Value: "" -10.00"" Column 51
'System Message 8004: Data File Record/Line Number: 2 Column: 51
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: Document Amount must be greater than zero before transactions may be entered
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: corigdocamt_1 Value: "" -30.00"" Column 49
'System Message 8004: Data File Record/Line Number: 6 Column: 49
'System Message 8055: ========Error Processing Document Data Line========
'Application Error: Document Amount must be greater than zero before transactions may be entered
Error searchable by “Error Processing Document Data Line”
|
|
|
46
|
Quantity:
Empty
|
Batch is created in DBs.
Will import and set blank Quantity to default.
|
Batch is created in DBs
Will import and set blank Quantity to default.
|
47
|
Quantity:
0.00
|
Batch is created in DBs.
Will import and set 0.00 Quantity to default.
|
Batch is created in DBs.
Will import and set 0.00 Quantity to default.
|
48
|
Quantity:
Invalid: 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 .0000, please reenter.
'System Message 8002: Error In Field: cqty_2 Value: ""-1"" Column 15
'System Message 8004: Data File Record/Line Number: 3 Column: 15
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows 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: 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 .0000, please reenter.
'System Message 8002: Error In Field: cqty_2 Value: ""-1"" Column 15
'System Message 8004: Data File Record/Line Number: 3 Column: 15
'System Message 8055: ========Error Processing Transaction Data Line
|
49
|
Quantity:
Invalid: Alpha
|
Reject entire file.
No batch created in DBs.
Invalid record is searchable with: 'System Message 8002: Error In Field: cqty_2 Value: ""ABCD"" Column 15
'System Message 8004: Data File Record/Line Number:
'System Message 8055: ========Error Processing Transaction Data Line
Valid record immediately follows 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: 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: cqty_2 Value: ""ABCD"" Column 15
'System Message 8004: Data File Record/Line Number:
'System Message 8055: ========Error Processing Transaction Data Line
|
50
|
Quantity:
Invalid: Symbols
|
Batch is created in DBs.
Will import and set characters Quantity to default.
|
Batch is created in DBs.
Will import and set characters Quantity to default.
|
51
|
Quantity:
Invalid value:
Data example: 99,999,999.0000
(8+4 in length)
|
Batch is created in DBs.
Transaction Import will import with no error.
|
Batch is created in DBs.
Transaction Import will import with no error.
|
52
|
Quantity:
Invalid value:
Data example: 999,999,999.0000
(9+4 in length)
|
Batch is created in DBs.
Transaction Import will import with no error.
|
Batch is created in DBs.
Transaction Import will import with no error.
|
53
|
Quantity:
Invalid value:
Data example: 9,999,999,999.0000
(10+4 in length)
|
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.9900, please reenter.
'System Message 8002: Error In Field: cqty_2 Value: ""9999999999.0000"" Column 15
'System Message 8004: Data File Record/Line Number: 3 Column: 15
'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.9900, please reenter.
'System Message 8002: Error In Field: cqty_2 Value: ""9999999999.0000"" Column 15
'System Message 8004: Data File Record/Line Number: 3 Column: 15
'System Message 8055: ========Error Processing Transaction Data Line
|
54
|
Unit Price:
Empty
|
Batch is created in DBs.
Will import and set empty unit price to default.
|
Batch is created in DBs.
Will import and set empty unit price to default.
|
55
|
Unit Price:
Zero
|
Batch is created in DBs.
Will import and set zero unit prices to default.
|
Batch is created in DBs.
Will import and set zero unit prices to default.
|
56
|
Unit Price:
Invalid: 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 .000, please reenter.
'System Message 8002: Error In Field: cunitprice_2 Value: ""-.065"" Column 22
'System Message 8004: Data File Record/Line Number: 3 Column: 22
'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 .000, please reenter.
'System Message 8002: Error In Field: cunitprice_2 Value: ""-.065"" Column 22
'System Message 8004: Data File Record/Line Number: 3 Column: 22
'System Message 8055: ========Error Processing Transaction Data Line
|
57
|
Unit Price:
Invalid: Alpha
|
Reject entire file
No batch created in DBs.
Invalid record is searchable with: 'System Message 8002: Error In Field: cunitprice_2 Value: ""ZZZ"" Column 22
'System Message 8004: Data File Record/Line Number: 3 Column: 22
'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: cunitprice_2 Value: ""ZZZ"" Column 22
'System Message 8004: Data File Record/Line Number: 3 Column: 22
'System Message 8055: ========Error Processing Transaction Data Line========
|
58
|
Unit Price:
Invalid: Symbols
|
Batch is created in DBs.
Will import and set characters unit price to default.
|
Batch is created in DBs.
Will import and set characters unit price to default.
|
59
|
Unit Price:
Invalid value
Data example: 9,999,999,990.99
(10 + 3)
|
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.990, please reenter.
'System Message 8002: Error In Field: cunitprice_2 Value: ""9999999990.99"" Column 22
'System Message 8004: Data File Record/Line Number: 3 Column: 22
'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.990, please reenter.
'System Message 8002: Error In Field: cunitprice_2 Value: ""9999999990.99"" Column 22
'System Message 8004: Data File Record/Line Number: 3 Column: 22
'System Message 8055: ========Error Processing Transaction Data Line========
|
60
|
Unit Price:
Invalid: Numeric and alpha (3x3)
|
Reject entire file.
No batch created in DBs.
Invalid record is searchable with: 'System Message 8002: Error In Field: cunitprice_2 Value: ""3X3"" Column 22
'System Message 8004: Data File Record/Line Number: 3 Column: 22
'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: 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
|
61
|
|