Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Problem with lane items import
- Thread starter georgib68
- Start date
- Thread starter
- #3
I'm trying to import A/R in MAS 90.
That is what we have:
DATA ITEMS
-------------------------------------------------------------------------------------------------------------
ITEM ITEM NAME FG TYPE OPERATION COLUMN IMPORT MASK SUB-STRING
-------------------------------------------------------------------------------------------------------------
00001 INVOICE_NO H ACCOUNT NEXT ####### No
00002 INVOICE_TYPE H STRING ASSIGN IN No
00003 DIVISION_NO H ZERO-FILL ASSIGN 00 No
00004 CUSTOMER_NO H ACCOUNT REPLACE 00002 ####### No
00005 INVOICE_DATE H DATE REPLACE 00003 MMDDYY No
00006 TERMS_CODE H ZERO-FILL ASSIGN 0 No
00007 TAX_SCHEDULE H STRING REPLACE 00004 Start: 1 Len: 9 No
00008 SALESPRSN_NO H ACCOUNT REPLACE 00005 #### No
00009 PRINT_INVOICE H YES/NO ASSIGN Y No
00010 CM_INVOICE_REF H STRING REPLACE 00006 Start: 1 Len: 7 No
00011 INVC_COMMENT H STRING REPLACE 00007 Start: 1 Len: 30 No
00012 ADJUSTMENT? H YES/NO REPLACE 00008 Start: 1 Len: 1 No
00013 ACT_PRINTED? H YES/NO ASSIGN Y No
00014 INV_DUE_DATE H DATE REPLACE 00003 MMDDYY No
00015 INVALID_TX_CALC H YES/NO REPLACE 00009 Start: 1 Len: 1 No
00016 BATCH_FAX H YES/NO ASSIGN Y No
00017 COST_SALE_ACCNT L1 ACCOUNT ASSIGN 0 No
00018 UDF_GUEST_COUNT H NUMBER REPLACE 00010 No
00019 MISC_G/L_ACCNT L2 ACCOUNT FILE ASSIGN AR.SALESCD:SALES_ACCNT No
00020 SALES_CODE L1 STRING REPLACE 00011 Start: 1 Len: 6 No
00021 SALES_ACCNT L1 ACCOUNT FILE ASSIGN AR.SALESCD:SALES_ACCNT No
00022 SUBJ_TO_EXEMPT L4 YES/NO REPLACE 00012 Start: 1 Len: 1 No
00023 COMMISSIONABLE? L4 YES/NO REPLACE 00013 Start: 1 Len: 1 No
00024 TAX_CLASS L4 STRING REPLACE 00014 Start: 1 Len: 2 No
00025 QUANTITY L1 NUMBER REPLACE 00015 No
00026 AMOUNT L4 NUMBER REPLACE 00016 No
RECORD SELECTION
-------------------------------------------------------------------------------------------------------------
ITEM TYPE DESCRIPTION COLUMN START LENGTH RELATION VALUE
-------------------------------------------------------------------------------------------------------------
00001 1 Sales Code Lines 00001 00011 00003 <> 0
VALIDATION RECORDS
-------------------------------------------------------------------------------------------------------------
ITEM FIELD METHOD SKIP FILE/STRING/EXPRESSION
-------------------------------------------------------------------------------------------------------------
00001 INVOICE_TYPE STRING N CMDMINFCCAXD
00002 DIVISION_NO FILE N AR.DIV
00003 CUSTOMER_NO FILE N AR.CUST
00004 INVOICE_DATE EXPRESSION N AR7$(49,6)<>DIM(6)
00005 TERMS_CODE FILE N AR.TERMS
Run Date: 01/18/2005 GEO Copy of CAT for testing only Page: 2
V/I Date: 01/18/2005 JOB DEFINITION PRINTING FOR JOB: INVOICE Time: 03:07 PM
VALIDATION RECORDS
-------------------------------------------------------------------------------------------------------------
ITEM FIELD METHOD SKIP FILE/STRING/EXPRESSION
-------------------------------------------------------------------------------------------------------------
00006 TAX_SCHEDULE FILE N SY.TXSCHDH
00007 SALESPRSN_NO FILE N AR.SPERSON
00008 PRINT_INVOICE UPPERCASE N YN
00009 ADJUSTMENT? UPPERCASE N YN
00010 ACT_PRINTED? UPPERCASE N YN
00011 JOB_NUMBER FILE Y JC.JOBS
00012 INVALID_TX_CALC STRING N YN
00013 BATCH_FAX STRING N YN
That is what we have:
DATA ITEMS
-------------------------------------------------------------------------------------------------------------
ITEM ITEM NAME FG TYPE OPERATION COLUMN IMPORT MASK SUB-STRING
-------------------------------------------------------------------------------------------------------------
00001 INVOICE_NO H ACCOUNT NEXT ####### No
00002 INVOICE_TYPE H STRING ASSIGN IN No
00003 DIVISION_NO H ZERO-FILL ASSIGN 00 No
00004 CUSTOMER_NO H ACCOUNT REPLACE 00002 ####### No
00005 INVOICE_DATE H DATE REPLACE 00003 MMDDYY No
00006 TERMS_CODE H ZERO-FILL ASSIGN 0 No
00007 TAX_SCHEDULE H STRING REPLACE 00004 Start: 1 Len: 9 No
00008 SALESPRSN_NO H ACCOUNT REPLACE 00005 #### No
00009 PRINT_INVOICE H YES/NO ASSIGN Y No
00010 CM_INVOICE_REF H STRING REPLACE 00006 Start: 1 Len: 7 No
00011 INVC_COMMENT H STRING REPLACE 00007 Start: 1 Len: 30 No
00012 ADJUSTMENT? H YES/NO REPLACE 00008 Start: 1 Len: 1 No
00013 ACT_PRINTED? H YES/NO ASSIGN Y No
00014 INV_DUE_DATE H DATE REPLACE 00003 MMDDYY No
00015 INVALID_TX_CALC H YES/NO REPLACE 00009 Start: 1 Len: 1 No
00016 BATCH_FAX H YES/NO ASSIGN Y No
00017 COST_SALE_ACCNT L1 ACCOUNT ASSIGN 0 No
00018 UDF_GUEST_COUNT H NUMBER REPLACE 00010 No
00019 MISC_G/L_ACCNT L2 ACCOUNT FILE ASSIGN AR.SALESCD:SALES_ACCNT No
00020 SALES_CODE L1 STRING REPLACE 00011 Start: 1 Len: 6 No
00021 SALES_ACCNT L1 ACCOUNT FILE ASSIGN AR.SALESCD:SALES_ACCNT No
00022 SUBJ_TO_EXEMPT L4 YES/NO REPLACE 00012 Start: 1 Len: 1 No
00023 COMMISSIONABLE? L4 YES/NO REPLACE 00013 Start: 1 Len: 1 No
00024 TAX_CLASS L4 STRING REPLACE 00014 Start: 1 Len: 2 No
00025 QUANTITY L1 NUMBER REPLACE 00015 No
00026 AMOUNT L4 NUMBER REPLACE 00016 No
RECORD SELECTION
-------------------------------------------------------------------------------------------------------------
ITEM TYPE DESCRIPTION COLUMN START LENGTH RELATION VALUE
-------------------------------------------------------------------------------------------------------------
00001 1 Sales Code Lines 00001 00011 00003 <> 0
VALIDATION RECORDS
-------------------------------------------------------------------------------------------------------------
ITEM FIELD METHOD SKIP FILE/STRING/EXPRESSION
-------------------------------------------------------------------------------------------------------------
00001 INVOICE_TYPE STRING N CMDMINFCCAXD
00002 DIVISION_NO FILE N AR.DIV
00003 CUSTOMER_NO FILE N AR.CUST
00004 INVOICE_DATE EXPRESSION N AR7$(49,6)<>DIM(6)
00005 TERMS_CODE FILE N AR.TERMS
Run Date: 01/18/2005 GEO Copy of CAT for testing only Page: 2
V/I Date: 01/18/2005 JOB DEFINITION PRINTING FOR JOB: INVOICE Time: 03:07 PM
VALIDATION RECORDS
-------------------------------------------------------------------------------------------------------------
ITEM FIELD METHOD SKIP FILE/STRING/EXPRESSION
-------------------------------------------------------------------------------------------------------------
00006 TAX_SCHEDULE FILE N SY.TXSCHDH
00007 SALESPRSN_NO FILE N AR.SPERSON
00008 PRINT_INVOICE UPPERCASE N YN
00009 ADJUSTMENT? UPPERCASE N YN
00010 ACT_PRINTED? UPPERCASE N YN
00011 JOB_NUMBER FILE Y JC.JOBS
00012 INVALID_TX_CALC STRING N YN
00013 BATCH_FAX STRING N YN
- Thread starter
- #4
- Thread starter
- #5
- Thread starter
- #6
- Thread starter
- #8
- Thread starter
- #10
The problem is there are many sales codes and ammounts in the 1st field.
I'm trying to import
in,2400,062068,ILL,0156, ,ghjghghj,N,n,250,810,9000,200,4500,520,656565,
/everythig is one lane/
The header is included:
"type=Inv, Customer Num=2400,TaxSch=ILL, Sales person code=0156, ,Comments=ghjghghj,TAxable=N,Commision=N, SALES CODE=810,AMOUNT=9000...BUT I NEED TO IMPORT AND THE REST OF THE RECORDS AS LINE ITEMS/SALES CODES AND AMOUNT/
sALES CODE=200, AMOUNT=4500, SALES CODE =520, AMOUNT=6565665,/
IT IMPORTS ONLY TWO RECORDS FOR DETAIL LINE.
hELP PLEASE. i'M MISSING SOMETHING.
I'm trying to import
in,2400,062068,ILL,0156, ,ghjghghj,N,n,250,810,9000,200,4500,520,656565,
/everythig is one lane/
The header is included:
"type=Inv, Customer Num=2400,TaxSch=ILL, Sales person code=0156, ,Comments=ghjghghj,TAxable=N,Commision=N, SALES CODE=810,AMOUNT=9000...BUT I NEED TO IMPORT AND THE REST OF THE RECORDS AS LINE ITEMS/SALES CODES AND AMOUNT/
sALES CODE=200, AMOUNT=4500, SALES CODE =520, AMOUNT=6565665,/
IT IMPORTS ONLY TWO RECORDS FOR DETAIL LINE.
hELP PLEASE. i'M MISSING SOMETHING.
Hi. I am not completely sure about the problem.
Your record source is a csv file, and the first line has the header row.
After that, on a single line, you have repeating data, with no Carriage return / Line Feed seperating them?
If so, then I am not sure about the solution, other than fixing your csf file so the records are seperated.
ChaZ
There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
Your record source is a csv file, and the first line has the header row.
After that, on a single line, you have repeating data, with no Carriage return / Line Feed seperating them?
If so, then I am not sure about the solution, other than fixing your csf file so the records are seperated.
ChaZ
There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.
- Status
Similar threads
- Locked
- Question