Import New PO from Excel

[ssplus]

Hello,

I am trying to import a new PO. Everything seem to work, but the line item information. Any advise ?

===========================================================
CONFIGURATION INFORMATION
-------------------------------------------------------------------------------------------------------------
FILE NAME: PO.ORDER P/O Purchase Order Entry File
IMPORT FILE: C:\PO.xls
FILE TYPE: EXCEL
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 PURCH_ORDER_NO H ACCOUNT RUN-TIME ASSN Runtime: 0001021 No
00002 PO_DATE H DATE RUN-TIME ASSN Runtime: 05/16/05 No
00003 ORDER_TYPE H STRING ASSIGN S No
00004 DIVISION_NO H ZERO-FILL ASSIGN 00 No
00005 VENDOR_NO H ACCOUNT ASSIGN WAR No
00006 PO_SHIP_TO_CODE H STRING ASSIGN 0000 No
00007 ORDER_STATUS H STRING ASSIGN N No
00008 USE_TAX_HDR H YES/NO ASSIGN N No
00009 PRINT_PO? H YES/NO ASSIGN N No
00010 ON_HOLD? H YES/NO ASSIGN N No
00011 BATCH_FAX H YES/NO ASSIGN N No
00012 ORDER_WHSE_CODE H ACCOUNT ASSIGN 000 No
00013 TERMS_CODE H ZERO-FILL ASSIGN 00 No
00014 TAX_SCHEDULE H STRING ASSIGN DEFAULT No
00015 ITEM_NUMBER L1 STRING REPLACE 00002 Start: 1 Len: 15 No
00016 LINE_TYPE L STRING ASSIGN 1 No
00017 USE_TAX_LINE L6 YES/NO ASSIGN N No
00018 INV_ITM_GL_ACCT L1 ACCOUNT ASSIGN 030000000 No
00019 COST_TYPE L1 STRING ASSIGN 1 No
00020 ITEM_UM L1 STRING ASSIGN EA No
00021 WAREHOUSE_CODE L1 ACCOUNT ASSIGN 000 No
00022 PRODUCT_LINE L1 STRING ASSIGN WAR No
00023 EXTEND_DESC? L7 YES/NO ASSIGN N No
00024 RESCHED? LA YES/NO ASSIGN N No
00025 REC_GOODS_UPDT? L6 YES/NO ASSIGN N No
00026 ALLOC_LNDED_CST L7 YES/NO ASSIGN N No
00027 TAX_CLASS L6 STRING ASSIGN NT No
00028 U_M_CONV_FACTOR L7 NUMBER CALCULATED No
CALC EXP: 0+1
00029 SPECIAL_ITEM_NO L2 STRING ASSIGN No
00030 UNIT_MEASURE L9 STRING ASSIGN EA No
00031 GL_ACCT L8 ACCOUNT ASSIGN 030000000 No
00032 MISC_SLASH LB STRING ASSIGN No
00033 MISC_CODE LB STRING ASSIGN No
00034 QTY_ORDERED L7 NUMBER REPLACE 00001 No

RECORD SELECTION
-------------------------------------------------------------------------------------------------------------
ITEM TYPE DESCRIPTION COLUMN START LENGTH RELATION VALUE
-------------------------------------------------------------------------------------------------------------
00001 1 Item Record 00001 00001 00001 =

 

[Blorf]

Hi. Below I see a potential problem. You have line type 1 (Item Record) if Field 1 = (Then Nothing). What is field 1? If it's a number, change from = nothing, to >0, or base on another field you can do the logic on.

Hope that helps,
ChaZ

RECORD SELECTION
-------------------------------------------------------------------------------------------------------------
ITEM TYPE DESCRIPTION COLUMN START LENGTH RELATION VALUE
-------------------------------------------------------------------------------------------------------------
00001 1 Item Record 00001 00001 00001 =


There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://mysite.verizon.net/res0n4sv/

 

[ssplus]

I have having trouble importing a purchase order. Still no luck.


CONFIGURATION INFORMATION
-------------------------------------------------------------------------------------------------------------
FILE NAME: PO.ORDER P/O Purchase Order Entry File
IMPORT FILE: C:\PO.xls
FILE TYPE: EXCEL
INSERT ALL REQUIRED FIELDS DURING SETUP: Y
HEADER INFORMATION INCLUDED IN DETAIL LINES: Y
PASSWORD: NO
PERFORM: ON SUCCESS ../po/powvip;PO_ORDER_MANUAL
PERFORM: ON FAILURE ../po/powvip;PO_ORDER_MANUAL

DATA ITEMS
-------------------------------------------------------------------------------------------------------------
ITEM ITEM NAME FG TYPE OPERATION COLUMN IMPORT MASK SUB-STRING
-------------------------------------------------------------------------------------------------------------
00001 PURCH_ORDER_NO H ACCOUNT RUN-TIME ASSN Runtime: 0001021 No
00002 PO_DATE H DATE RUN-TIME ASSN Runtime: 05/16/05 No
00003 ORDER_TYPE H STRING ASSIGN S No
00004 DIVISION_NO H ZERO-FILL ASSIGN 00 No
00005 VENDOR_NO H ACCOUNT ASSIGN WAR No
00006 PO_SHIP_TO_CODE H STRING ASSIGN 0000 No
00007 ORDER_STATUS H STRING ASSIGN N No
00008 USE_TAX_HDR H YES/NO ASSIGN N No
00009 PRINT_PO? H YES/NO ASSIGN N No
00010 ON_HOLD? H YES/NO ASSIGN N No
00011 BATCH_FAX H YES/NO ASSIGN N No
00012 ORDER_WHSE_CODE H ACCOUNT ASSIGN 000 No
00013 TERMS_CODE H ZERO-FILL ASSIGN 00 No
00014 TAX_SCHEDULE H STRING ASSIGN DEFAULT No
00015 ITEM_NUMBER L1 STRING REPLACE 00001 Start: 1 Len: 15 No
00016 LINE_TYPE L STRING ASSIGN 1 No
00017 USE_TAX_LINE L6 YES/NO ASSIGN N No
00018 INV_ITM_GL_ACCT L1 ACCOUNT ASSIGN 030000000 No
00019 COST_TYPE L1 STRING ASSIGN 1 No
00020 ITEM_UM L1 STRING ASSIGN EA No
00021 WAREHOUSE_CODE L1 ACCOUNT ASSIGN 000 No
00022 PRODUCT_LINE L1 STRING ASSIGN WAR No
00023 EXTEND_DESC? L7 YES/NO ASSIGN N No
00024 RESCHED? LA YES/NO ASSIGN N No
00025 REC_GOODS_UPDT? L6 YES/NO ASSIGN N No
00026 ALLOC_LNDED_CST L7 YES/NO ASSIGN N No
00027 TAX_CLASS L6 STRING ASSIGN NT No
00028 U_M_CONV_FACTOR L7 NUMBER CALCULATED No
CALC EXP: 0+1
00029 SPECIAL_ITEM_NO L2 STRING ASSIGN No
00030 UNIT_MEASURE L9 STRING ASSIGN EA No
00031 GL_ACCT L8 ACCOUNT ASSIGN 030000000 No
00032 MISC_SLASH LB STRING ASSIGN No
00033 MISC_CODE LB STRING ASSIGN No
00034 QTY_ORDERED L7 NUMBER REPLACE 00002 No

RECORD SELECTION
-------------------------------------------------------------------------------------------------------------
ITEM TYPE DESCRIPTION COLUMN START LENGTH RELATION VALUE
-------------------------------------------------------------------------------------------------------------
00001 1 Item Record 00001 00001 00001 =

 

[Blorf]

Hi.

Your repost still has no criteria for type 1 records, so no records will be added to po lines.

Thanks,
ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.