Sections in this article
Import Spreadsheet Error Types (column/error #)
The Customer Projections Application (CPA) enables a Purchasing Department to receive Customer Projections via spreadsheet on future projected purchases for a product at a specific location for 12 months, or four quaters, of for the entire year.
These projections will then be measured against actual results and provide feedback to the Purchasing Department for futher review and decision making.
Since the entire process begins with receicing a spreadsheet from a customer, we will need to have the following errors provided for clean data.
The file K_CPAIMPU will capture the errors identified from the import spreadsheer process. These errors will be emailed to the contacts identified in the Controls file (K_CPACMST).
There are 29 different errors that can occur when processing an import spreadsheet.
A1
Description:
When importing a csv file into the K3S system, it is important that the company code is not blank. This table code is responsible for giving you an error if the company code is blank.
Enable:
Error will be given if the company code is blank.
Structure:
Table Code Value: A1 Table Code Description 1: Company Code must not be blank Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
A2
Description:
When importing a csv file into the K3S system, it is important that the company code is valid. This table code is responsible for giving you an error if the company code is not valid.
Enable:
Error will be given if the company code is not valid.
Structure:
Table Code Value: A2 Table Code Description 1: Company Code provided is not valid Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
B1
Description:
When importing a csv file into the K3S system, it is important that the location ID is not blank. This table code is responsible for giving you an error if the location ID is not blank.
Enable:
Error will be given if the location ID is blank.
Structure:
Table Code Value: B1 Table Code Description 1: Location ID must not be blank Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
B2
Description:
When importing a csv file into the K3S system, it is important that the location ID is valid. This table code is responsible for giving you an error if the location ID is not valid.
Enable:
Error will be given if the location ID is not valid.
Structure:
Table Code Value: B2 Table Code Description 1: Location ID provided is not valid Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
C1
Description:
When importing a csv file into the K3S system, it is important that the customer ID is not blank. This table code is responsible for giving you an error if the customer ID is not blank.
Enable:
Error will be given if the customer ID is blank.
Structure:
Table Code Value: C1 Table Code Description 1: Customer ID must not be blank Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
C2
Description:
When importing a csv file into the K3S system, it is important that the customer ID is valid. This table code is responsible for giving you an error if the customer ID is not valid.
Enable:
Error will be given if the customer ID is not valid.
Structure:
Table Code Value: C2 Table Code Description 1: Customer ID provided is not valid Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
D1
Description:
When importing a csv file into the K3S system, it is important that the product ID is not blank. This table code is responsible for giving you an error if the product ID is not blank.
Enable:
Error will be given if the product ID is blank.
Structure:
Table Code Value: D1 Table Code Description 1: Product ID must not be blank Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
D2
Description:
When importing a csv file into the K3S system, it is important that the product ID is valid. This table code is responsible for giving you an error if the product ID is not valid.
Enable:
Error will be given if the product ID is not valid.
Structure:
Table Code Value: D2 Table Code Description 1: Product ID provided is not valid Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
E1
Description:
When importing a csv file into the K3S system, it is important that a year is provided. This table code is responsible for giving you an error if a year is not provided.
Enable:
Error will be given if a year is not provided.
Structure:
Table Code Value: E1 Table Code Description 1: Year was not provided Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
E2
Description:
When importing a csv file into the K3S system, it is important that a year is provided and is the current, or up to 5 years into the future. This table code is responsible for giving you an error if a year is past that 5 year into the future mark.
Enable:
Error will be given if a year is past that 5 year into the future mark.
Structure:
Table Code Value: E2 Table Code Description 1: Year can be the current year, or up to 5 years into the future Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
E3
Description:
When importing a csv file into the K3S system, it is important that a year is provided and is not more than 5 years in the past. This table code is responsible for giving you an error if a year is past that 5 year mark.
Enable:
Error will be given if a year is past that 5 year mark.
Structure:
Table Code Value: E3 Table Code Description 1: Year can not be more than 5 years in the past Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
F1
Description:
When importing a csv file into the K3S system, it is important that the type is provided. These 3 values would include value MM, which is the type for monthly projections. Value QQ will be the Quarterly projections type and value YY which is the annual projections type. This table code is responsible for giving you an error if a type is not provided.
Enable:
Error will be given if the type is not provided.
Structure:
Table Code Value: F1 Table Code Description 1: Type was not provided Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
F2
Description:
When importing a csv file into the K3S system, it is important that a product type is provided. This table code is responsible for giving you an error if a type is not provided.
Enable:
Error will be given if the type is not valid
Structure:
Table Code Value: F2 Table Code Description 1: Type provided is not valid Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
G1
Description:
When importing a csv file into the K3S system, it is important that a valid number is provided for period 1. This table code is responsible for giving you an error if there is an invalid number under period 1.
Enable:
Error will be given if period 1 has an invalid number.
Structure:
Table Code Value: G1 Table Code Description 1: Period 01 quantity must be between 0 and 9,999,999 Table Flag 1: 0
Program Used In:
G2
Description:
Type MM, which means that the monthly projections are being used, must have a quantity found in the periods.
Enable:
Error will occur if type MM is being used, but no quantities are found in the Periods
Structure:
Table Code Value: G2 Table Code Description 1: Type MM being used, but no quantities found in Periods 01 thru 12 Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
G3
Description:
Type QQ, which means that quarterly projections are being used must have a quantity found in the periods.
Enable:
Error will occur if type QQ is being used, but no quantities are found in the periods
Structure:
Table Code Value: G3 Table Code Description 1: Type QQ being used, but no quantities found in Periods 01 thru 04 Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
G4
Description:
Type YY, which means that annual projections are being used must have a quantity found in the periods.
Enable:
Error will occur if type YY is being used, but no quantities are found in the periods
Structure:
Table Code Value: G4 Table Code Description 1: Type YY being used, but no quantity found in Period 01 Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
H1
Description:
When importing a csv file into the K3S system, it is important that a valid number is provided for period 2. This table code is responsible for giving you an error if there is an invalid number under period 2.
Enable:
Error will be given if period 2 has an invalid number.
Structure:
Table Code Value: H1 Table Code Description 1: Period 02 quantity must be between 0 and 9,999,999 Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
I1
Description:
When importing a csv file into the K3S system, it is important that a valid number is provided for period 3. This table code is responsible for giving you an error if there is an invalid number under period 3.
Enable:
Error will be given if period 3 has an invalid number.
Structure:
Table Code Value: I1 Table Code Description 1: Period 03 quantity must be between 0 and 9,999,999 Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
J1
Description:
When importing a csv file into the K3S system, it is important that a valid number is provided for period 4. This table code is responsible for giving you an error if there is an invalid number under period 4.
Enable:
Error will be given if period 4 has an invalid number.
Structure:
Table Code Value: J1 Table Code Description 1: Period 04 quantity must be between 0 and 9,999,999 Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
K1
Description:
When importing a csv file into the K3S system, it is important that a valid number is provided for period 5. This table code is responsible for giving you an error if there is an invalid number under period 5.
Enable:
Error will be given if period 5 has an invalid number.
Structure:
Table Code Value: K1 Table Code Description 1: Period 05 quantity must be between 0 and 9,999,999 Table Flag 1: 0
Program Used In:
L1
Description:
When importing a csv file into the K3S system, it is important that a valid number is provided for period 6. This table code is responsible for giving you an error if there is an invalid number under period 6.
Enable:
Error will be given if period 6 has an invalid number.
Structure:
Table Code Value: L1 Table Code Description 1: Period 06 quantity must be between 0 and 9,999,999 Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
M1
Description:
When importing a csv file into the K3S system, it is important that a valid number is provided for period 7. This table code is responsible for giving you an error if there is an invalid number under period 7.
Enable:
Error will be given if period 7 has an invalid number.
Structure:
Table Code Value: M1 Table Code Description 1: Period 07 quantity must be between 0 and 9,999,999 Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
N1
Description:
When importing a csv file into the K3S system, it is important that a valid number is provided for period 8. This table code is responsible for giving you an error if there is an invalid number under period 8.
Enable:
Error will be given if period 8 has an invalid number.
Structure:
Table Code Value: N1 Table Code Description 1: Period 08 quantity must be between 0 and 9,999,999 Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
O1
Description:
When importing a csv file into the K3S system, it is important that a valid number is provided for period 9. This table code is responsible for giving you an error if there is an invalid number under period 9.
Enable:
Error will be given if period 9 has an invalid number.
Structure:
Table Code Value: O1 Table Code Description 1: Period 09 quantity must be between 0 and 9,999,999 Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
P1
Description:
When importing a csv file into the K3S system, it is important that a valid number is provided for period 10. This table code is responsible for giving you an error if there is an invalid number under period 10.
Enable:
Error will be given if period 10 has an invalid number.
Structure:
Table Code Value: P1 Table Code Description 1: Period 10 quantity must be between 0 and 9,999,999 Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
Q1
Description:
When importing a csv file into the K3S system, it is important that a valid number is provided for period 11. This table code is responsible for giving you an error if there is an invalid number under period 11.
Enable:
Error will be given if period 11 has an invalid number.
Structure:
Table Code Value: Q1 Table Code Description 1: Period 11 quantity must be between 0 and 9,999,999 Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
R1
Description:
When importing a csv file into the K3S system, it is important that a valid number is provided for period 12. This table code is responsible for giving you an error if there is an invalid number under period 12.
Enable:
Error will be given if period 12 has an invalid number.
Structure:
Table Code Value: R1 Table Code Description 1: Period 12 quantity must be between 0 and 9,999,999 Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
S1
Description:
If the notes have a special character that is not supported, then an error will arise.
Enable:
Error will be given if there is a special character in a note where it is not supported.
Structure:
Table Code Value: S1 Table Code Description 1: Notes contain special characters not supported Table Flag 1: 0
Program Used In:
- AR_EDTCPDA
