Thanks for replying back...
Looks like I got it fixed by adding SOLD_TO field and map it to FILE ASSIGN AR:CUST:NAME
Anyway, the import went really well from SQL to MAS90 using ODBC connections.
But now my problem is when I am doing AR cash receipts entry, I am NOT able to post against the invoices and distribute check amount to the invoices because theres no invoice no shows up at all on the list and its greyed out. Once you select the customer it pulled out the correct current balance for that customer just fine. I checked the security clearance, just in case, it was fine.
I am not sure if my import was incomplete and missing something...
Any suggestion is highly appreciated, thanks...
here's the code:
CONFIGURATION INFORMATION
-------------------------------------------------------------------------------------------------------------
FILE NAME: AR.INVOICE A/R Invoice Data Entry File
DATA SOURCE: XXXXX
FILE TYPE: ODBC
INSERT ALL REQUIRED FIELDS DURING SETUP: Y
HEADER INFORMATION INCLUDED IN DETAIL LINES: Y
PASSWORD: NO
DATA ITEMS
-------------------------------------------------------------------------------------------------------------
ITEM ITEM NAME FG TYPE OPERATION COLUMN IMPORT MASK SUB-STRING
-------------------------------------------------------------------------------------------------------------
00001 INVOICE_NO H ACCOUNT REPLACE 00001 ####### No
00002 INVOICE_TYPE H STRING ASSIGN IN No
00003 DIVISION_NO H ZERO-FILL ASSIGN 00 No
00004 CUSTOMER_NO H ACCOUNT REPLACE 00007 ####### No
00005 INVOICE_DATE H DATE REPLACE 00006 YYYY/MM/DD No
00006 TERMS_CODE H ZERO-FILL ASSIGN 00 No
00007 TAX_SCHEDULE H STRING ASSIGN NONTAX No
00008 SALESPRSN_NO H ACCOUNT ASSIGN 0001 No
00009 PRINT_INVOICE H YES/NO ASSIGN N No
00010 ADJUSTMENT H YES/NO ASSIGN N No
00011 ACT_PRINTED H YES/NO ASSIGN Y No
00012 INVALID_TX_CALC H YES/NO ASSIGN N No
00013 BATCH_FAX H YES/NO ASSIGN N No
00014 SALES_CODE L1 STRING ASSIGN TRANS No
00015 SALES_ACCNT L1 STRING FILE ASSIGN AR.SALESCD:SALES_ACCNT No
00016 COST_SALE_ACCNT L1 STRING FILE ASSIGN AR.SALESCD:COST_OF_SALES No
00017 INVENTORY_ACCNT L1 STRING FILE ASSIGN AR.SALESCD:INVENTORY_ACCNTNo
00018 SUBJ_TO_EXEMPT L4 YES/NO ASSIGN N No
00019 COMMISSIONABLE L4 YES/NO ASSIGN N No
00020 TAX_CLASS L4 STRING ASSIGN NT No
00021 INVC_COMMENT H STRING REPLACE 00002 Start: 1 Len: 30 No
00022 CUSTOMER_PO_NO H STRING REPLACE 00012 Start: 1 Len: 15 No
00023 AMOUNT L4 NUMBER REPLACE 00016 No
00024 DESCRIPTION L4 STRING ASSIGN Transportation Services No
00025 NON_TAX_AMT H NUMBER REPLACE 00016 No
00026 PRICE L1 NUMBER REPLACE 00016 No
00027 LINE_INDEX L ZERO-FILL ASSIGN 00001 No
00028 QUANTITY L1 NUMBER RUN-TIME ASSN Runtime: 1 No
00029 UNIT_MEASURE L1 STRING ASSIGN EACH No
00030 SOLD_TO H STRING FILE ASSIGN AR.CUST:NAME No
RECORD SELECTION
-------------------------------------------------------------------------------------------------------------
ITEM TYPE DESCRIPTION COLUMN START LENGTH RELATION VALUE
-------------------------------------------------------------------------------------------------------------
00001 1 Sales Code Lines 00001 00001 00001 <> 0
PERFORM: AFTER WRITE ..\AR\ARWVIP;AR_INVOICE
00002 3 Comment Lines 00001 00001 00001 =
PERFORM: AFTER WRITE ..\AR\ARWVIP;AR_INVOICE
00003 SKIP Skip Record 00001 00001 00001 =
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
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
