VI "File Assign" Not Working

[richcwi]

Hi all,

Starting to create a new VI job to import data into PO.RECEIPT. The already created Purchase Order in the import record contains the DIVISION_NO and VENDOR_NO that wants to be populated in the PO.RECEIPT record. So I'm using "file assign" to the PO.ORDER table (PO.ORDERIVISION_NO and PO.ORDER:VENDOR_NO).

I only have a few header fields defined so far and am running the job in "test" mode and viewing the PASS/FAIL report and fixing a field at a time. However I can't get pass the "file assign" apparently not getting the data I need from the PO.ORDER table.

Any help would be helpful!

MAS90 V3.71


CONFIGURATION INFORMATION
-------------------------------------------------------------------------------------------------------------
FILE NAME: PO.RECEIPT P/O Receipt of Goods Entry
DATA SOURCE: NJDEV221_MASDATA
FILE TYPE: ODBC

INSERT ALL REQUIRED FIELDS DURING SETUP: Y
HEADER INFORMATION INCLUDED IN DETAIL LINES: N
PASSWORD: NO
PERFORM: ON SUCCESS ../po/powvip;PO_RECEIPT_CALC
PERFORM: ON FAILURE ../po/powvip;PO_RECEIPT_CALC

DATA ITEMS
-------------------------------------------------------------------------------------------------------------
ITEM ITEM NAME FG TYPE OPERATION COLUMN IMPORT MASK SUB-STRING
-------------------------------------------------------------------------------------------------------------
00001 RECEIPT_TYPE H STRING REPLACE 00001 Start: 1 Len: 1 No
00002 RECEIPT_NO H ACCOUNT REPLACE 00002 ###### No
00003 RECEIPT_DATE H DATE REPLACE 00003 MM/DD/YYYY No
00004 RECEIPT_TYPE_2 H STRING REPLACE 00004 Start: 1 Len: 1 No
00005 PURCH_ORDER_NO H ACCOUNT REPLACE 00005 ####### No
00006 DIVISION_NO H ZERO-FILL FILE ASSIGN PO.ORDERIVISION_NO No
00007 VENDOR_NO H ACCOUNT FILE ASSIGN PO.ORDER:VENDOR_NO No

VALIDATION RECORDS
-------------------------------------------------------------------------------------------------------------
ITEM FIELD METHOD SKIP FILE/STRING/EXPRESSION
-------------------------------------------------------------------------------------------------------------
00001 RECEIPT_TYPE UPPERCASE N IG
00002 RECEIPT_NO EXPRESSION N PO5$(2,6)<>DIM(6)
00003 RECEIPT_DATE EXPRESSION N PO5$(8,6)<>DIM(6)
00004 RECEIPT_TYPE_2 STRING N IG
00005 PURCH_ORDER_NO FILE Y PO.ORDER
00006 DIVISION_NO FILE N AP.DIV
00007 VENDOR_NO FILE N AP.VENDOR
00008 PO_SHIP_TO_CODE FILE Y PO.SHIPTO
00009 PO_STATUS STRING N BCNOX
00010 PURCH_ADDRS_CD FILE Y PO.ADDRESS
00011 USE_TAX_HDR STRING N YN
00012 ORDER_WHSE_CODE FILE N IM.WHSE
00013 ARDIVISION_NO FILE Y AR.DIV
00014 CUSTOMER_NO FILE Y AR.CUST
00015 TERMS_CODE FILE Y AP.TERMS
00016 BANK_CODE FILE Y GL.BANK
00017 PO_TYPE STRING Y SDMRX
00018 HOLD_PAYMENT? STRING N YN
00019 LOT_SER_LINES? STRING N YN
00020 TAX_SCHEDULE FILE N SY.TXSCHDH
00021 INVALID_TX_CALC STRING Y YN
00022 ITEM_NUMBER FILE N IM.ITEM
00023 LINE_TYPE STRING N 12345
00024 USE_TAX_LINE STRING N YN
00025 INV_ITM_GL_ACCT FILE N GL.ACCOUNT
00026 COST_TYPE STRING N 123456
00027 UNIT_MEASURE EXPRESSION N PO6$(71,4)<>DIM(4)
00028 WAREHOUSE_CODE FILE N IM.WHSE
00029 FULLY_DIST STRING Y YN
00030 PO_WHSE_CODE FILE Y IM.WHSE
00031 PRODUCT_LINE FILE N IM.PRODUCT
00032 JOB_NUMBER FILE Y JC.JOBS
00033 COST_CODE FILE Y JC.COSTCD
00034 WORK_ORDER_NO FILE Y WO.MASTER
00035 ALLOC_LNDED_CST STRING N YN
00036 TAX_CLASS FILE N SY.TXCLASS
00037 U_M_CONV_FACTOR EXPRESSION N PO6[6]>0
00038 SPECIAL_ITEM_NO EXPRESSION N PO6$(1,1)="*"
00039 UNIT_MEASURE EXPRESSION N PO6$(79,4)<>DIM(4)
00040 GL_ACCT FILE N GL.ACCOUNT


The Failed Record as viewed in Log Details is as follows:

Field Data Validation Type Validation Results
RECEIPT_TYPE G UPPER PASSED
RECEIPT_NO 500000 EXPRESSION PASSED
RECEIPT_DATE 02/07/2007 EXPRESSION PASSED
RECEIPT_TYPE_2 G STRING PASSED
PURCH_ORDER_NO 0019809 FILE PASSED
DIVISION_NO 00 FILE PASSED
VENDOR_NO 0019809 FILE FAILED

NOTE: DIVISION_NO defaluts to ZERO-FILL which happens to be a valid DIVISION_NO (but it's not the one on the Purchase Order).
NOTE: The VENDOR_NO has the last assigned value which is the PURCH_ORDER_NO.

 

[Sorebrek]

Try using "replace" instead of file assign. It will match up with the existing records.

 

[richcwi]

If I use "replace" then I need to supply the values in the import data - right? I was hoping not to have to supply these values and use vi's capability to "file assign" these values for me.....

 

[BigLouie]

This is an old issue but can't remember all the details off th e top of my head. Leaving for vacation tomorrow so will not be able to look into this until next week. If I remember correctly it has to do with the division and vendor number combining due to an error in one of the data dictionaries. Maybe ProgrammerChris can help if he is who I think he is.