Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login
Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Tek-Tips LinkedIn® Group

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...Where have you been all my life! I found the answer I needed in seconds..."
More...

Geography

Where in the world do Tek-Tips members come from?
Click Here To Find Out!

Tek-Tips Shirts!

Get Tek-Tips Swag
Get your
Tek-Tips Forums
SWAG here!
Home > Forums > Enterprise Applications > ERP and CRM Solution Vendors > ACCPAC Solutions Forum

invoice import error in accpac 5.0

thread631-1684258
Read More Threads Like This One
tsquare1975 (IS/IT--Management)
26 May 12 3:04
Dear all,
while importing invoice in accpac 5.0, I received an error " Description: Order. Record already exists.". plz guide me the solution to fix it.
ettienne (TechnicalUser)
26 May 12 8:02
Record already exists.
tsquare1975 (IS/IT--Management)
28 May 12 2:17
But there is no duplication, record is newly created and unique. Please guide me the tables and field values to track why and where the value is being duplicated
ettienne (TechnicalUser)
28 May 12 8:01
Check your import file, there is a duplication.
tsquare1975 (IS/IT--Management)
30 May 12 4:29
there is no duplication found ...
here is output of spy file.plz suggest.. thankx


[d08] AS0021: ASRST [12:34:08.84].Load
[d08] AS0021: ASRST [12:34:08.87].Open(PIB=2046, link=73)
[d08] 0 <==[12:34:08.89;t=16;ovh=0] {view=0x008e4d94}
[d08] AS0021: ASRST [12:34:08.89].Keys(view=0x008e4d94)
[d08] 0 <==[12:34:08.89;t=0;ovh=0] {keys=1}
[d08] AS0021: ASRST [12:34:08.89].Key(view=0x008e4d94, number=0)
[d08] 0 <==[12:34:08.89;t=0;ovh=0] {name='Database ID ', fields=3, keyFields=0$1$2$}
[d08] AS0021: ASRST [12:34:08.89].Fields(view=0x008e4d94)
[d08] 0 <==[12:34:08.89;t=0;ovh=0] {fields=11}
[d08] AS0021: ASRST [12:34:08.90].Name(view=0x008e4d94, field=999999998 <TITLE_IDX>)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {name='Restart ', desc='Restart Records '}
[d08] AS0021: ASRST [12:34:08.90].CmpNames()
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {count=1}
[d08] AS0021: ASRST [12:34:08.90].CmpNames()
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {count=0, names=''}
[d08] AS0021: ASRST [12:34:08.90].Keys(view=0x008e4d94)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {keys=1}
[d08] AS0021: ASRST [12:34:08.90].Key(view=0x008e4d94, number=0)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {name='Database ID ', fields=3, keyFields=0$1$2$}
[d08] AS0021: ASRST [12:34:08.90].Field(view=0x008e4d94, number=1)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {name='ORGID ', field=0}
[d08] AS0021: ASRST [12:34:08.90].Type(view=0x008e4d94, field=0)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {type=1, size=6, precision=0, styles=0x0000}
[d08] AS0021: ASRST [12:34:08.90].Attribs(view=0x008e4d94, field=0)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {attributes=0x0000008e}
[d08] AS0021: ASRST [12:34:08.90].Field(view=0x008e4d94, number=2)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {name='PGMNAME ', field=1}
[d08] AS0021: ASRST [12:34:08.90].Type(view=0x008e4d94, field=1)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {type=1, size=8, precision=0, styles=0x0000}
[d08] AS0021: ASRST [12:34:08.90].Attribs(view=0x008e4d94, field=1)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {attributes=0x0000008e}
[d08] AS0021: ASRST [12:34:08.90].Field(view=0x008e4d94, number=3)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {name='PCSNUM ', field=2}
[d08] AS0021: ASRST [12:34:08.90].Type(view=0x008e4d94, field=2)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {type=7, size=2, precision=0, styles=0x0000}
[d08] AS0021: ASRST [12:34:08.90].Attribs(view=0x008e4d94, field=2)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {attributes=0x0000008e}
[d08] AS0021: ASRST [12:34:08.90].Presents(view=0x008e4d94, field=0)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {Mask}
[d08] AS0021: ASRST [12:34:08.90].Name(view=0x008e4d94, field=0)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {name='ORGID ', desc='Database ID '}
[d08] AS0021: ASRST [12:34:08.90].Get(view=0x008e4d94, field=0, size=6)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {buffer='\20\20\20\20\20\20' -> ' '}
[d08] AS0021: ASRST [12:34:08.90].Presents(view=0x008e4d94, field=0, size=6)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {mask='%-6N'}
[d08] AS0021: ASRST [12:34:08.90].Presents(view=0x008e4d94, field=1)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {None}
[d08] AS0021: ASRST [12:34:08.90].Name(view=0x008e4d94, field=1)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {name='PGMNAME ', desc='Program Name '}
[d08] AS0021: ASRST [12:34:08.90].Get(view=0x008e4d94, field=1, size=8)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {buffer='\20\20\20\20\20\20\20\20' -> ' '}
[d08] AS0021: ASRST [12:34:08.90].Presents(view=0x008e4d94, field=2)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {None}
[d08] AS0021: ASRST [12:34:08.90].Name(view=0x008e4d94, field=2)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {name='PCSNUM ', desc='Restart Number '}
[d08] AS0021: ASRST [12:34:08.90].Get(view=0x008e4d94, field=2, size=2)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {buffer='\00\00'}
[d08] AS0021: ASRST [12:34:08.90].Browse(view=0x008e4d94, filter='(ORGID = EXCO AND PGMNAME = OE1100IM)', direction=forward)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {}
[d08] AS0021: ASRST [12:34:08.90].Keys(view=0x008e4d94)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {keys=1}
[d08] AS0021: ASRST [12:34:08.90].Key(view=0x008e4d94, number=0)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {name='Database ID ', fields=3, keyFields=0$1$2$}
[d08] AS0021: ASRST [12:34:08.90].Get(view=0x008e4d94, field=0, size=6)
[d08] 0 <==[12:34:08.90;t=0;ovh=0] {buffer='\20\20\20\20\20\20' -> ' '}
[d08] AS0021: ASRST [12:34:08.92].Get(view=0x008e4d94, field=1, size=8)
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {buffer='\20\20\20\20\20\20\20\20' -> ' '}
[d08] AS0021: ASRST [12:34:08.92].Get(view=0x008e4d94, field=2, size=2)
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {buffer='\00\00'}
[d08] AS0021: ASRST [12:34:08.92].Put(view=0x008e4d94, field=0, size=6, verify=0, buffer='\20\20\20\20\20\20' -> ' ')
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {}
[d08] AS0021: ASRST [12:34:08.92].Put(view=0x008e4d94, field=1, size=8, verify=0, buffer='\20\20\20\20\20\20\20\20' -> ' ')
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {}
[d08] AS0021: ASRST [12:34:08.92].Put(view=0x008e4d94, field=2, size=2, verify=0, buffer='\01\80')
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {}
[d08] AS0021: ASRST [12:34:08.92].Browse(view=0x008e4d94, filter='(ORGID = EXCO AND PGMNAME = OE1100IM)', direction=forward)
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {}
[d08] AS0021: ASRST [12:34:08.92].Fetch(view=0x008e4d94)
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {}
[d08] AS0021: ASRST [12:34:08.92].Get(view=0x008e4d94, field=0, size=6)
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {buffer='\45\58\43\4f\20\20' -> 'EXCO '}
[d08] AS0021: ASRST [12:34:08.92].Get(view=0x008e4d94, field=1, size=8)
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {buffer='\4f\45\31\31\30\30\49\4d' -> 'OE1100IM'}
[d08] AS0021: ASRST [12:34:08.92].Get(view=0x008e4d94, field=2, size=2)
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {buffer='\e5\1a'}
[d08] AS0021: ASRST [12:34:08.92].Get(view=0x008e4d94, field=0, size=6)
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {buffer='\45\58\43\4f\20\20' -> 'EXCO '}
[d08] AS0021: ASRST [12:34:08.92].Get(view=0x008e4d94, field=1, size=8)
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {buffer='\4f\45\31\31\30\30\49\4d' -> 'OE1100IM'}
[d08] AS0021: ASRST [12:34:08.92].Get(view=0x008e4d94, field=2, size=2)
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {buffer='\e5\1a'}
[d08] AS0021: ASRST [12:34:08.92].Put(view=0x008e4d94, field=0, size=6, verify=0, buffer='\20\20\20\20\20\20' -> ' ')
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {}
[d08] AS0021: ASRST [12:34:08.92].Put(view=0x008e4d94, field=1, size=8, verify=0, buffer='\20\20\20\20\20\20\20\20' -> ' ')
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {}
[d08] AS0021: ASRST [12:34:08.92].Put(view=0x008e4d94, field=2, size=2, verify=0, buffer='\01\80')
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {}
[d08] AS0021: ASRST [12:34:08.92].Browse(view=0x008e4d94, filter='(ORGID = EXCO AND PGMNAME = OE1100IM)', direction=forward)
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {}
[d08] AS0021: ASRST [12:34:08.92].Fetch(view=0x008e4d94)
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {}
[d08] AS0021: ASRST [12:34:08.92].Get(view=0x008e4d94, field=0, size=6)
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {buffer='\45\58\43\4f\20\20' -> 'EXCO '}
[d08] AS0021: ASRST [12:34:08.92].Get(view=0x008e4d94, field=1, size=8)
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {buffer='\4f\45\31\31\30\30\49\4d' -> 'OE1100IM'}
[d08] AS0021: ASRST [12:34:08.92].Get(view=0x008e4d94, field=2, size=2)
[d08] 0 <==[12:34:08.92;t=0;ovh=0] {buffer='\e5\1a'}
[d08] AS0021: ASRST [12:34:08.93].Field(view=0x008e4d94, number=4)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {name='USERID ', field=3}
[d08] AS0021: ASRST [12:34:08.93].Type(view=0x008e4d94, field=3)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {type=1, size=8, precision=0, styles=0x0000}
[d08] AS0021: ASRST [12:34:08.93].Attribs(view=0x008e4d94, field=3)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {attributes=0x00000006}
[d08] AS0021: ASRST [12:34:08.93].Field(view=0x008e4d94, number=5)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {name='DATE ', field=4}
[d08] AS0021: ASRST [12:34:08.93].Type(view=0x008e4d94, field=4)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {type=3, size=5, precision=0, styles=0x0000}
[d08] AS0021: ASRST [12:34:08.93].Attribs(view=0x008e4d94, field=4)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {attributes=0x00000006}
[d08] AS0021: ASRST [12:34:08.93].Presents(view=0x008e4d94, field=4)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {None}
[d08] AS0021: ASRST [12:34:08.93].Name(view=0x008e4d94, field=4)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {name='DATE ', desc='Date '}
[d08] AS0021: ASRST [12:34:08.93].Get(view=0x008e4d94, field=4, size=5)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {buffer='\02\01\20\53\0c' -> 20120530}
[d08] AS0021: ASRST [12:34:08.93].Field(view=0x008e4d94, number=6)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {name='TIME ', field=5}
[d08] AS0021: ASRST [12:34:08.93].Type(view=0x008e4d94, field=5)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {type=4, size=5, precision=0, styles=0x0000}
[d08] AS0021: ASRST [12:34:08.93].Attribs(view=0x008e4d94, field=5)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {attributes=0x00000006}
[d08] AS0021: ASRST [12:34:08.93].Presents(view=0x008e4d94, field=5)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {None}
[d08] AS0021: ASRST [12:34:08.93].Name(view=0x008e4d94, field=5)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {name='TIME ', desc='Time '}
[d08] AS0021: ASRST [12:34:08.93].Get(view=0x008e4d94, field=5, size=5)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {buffer='\01\23\22\41\4c' -> 12322414}
[d08] AS0021: ASRST [12:34:08.93].Field(view=0x008e4d94, number=7)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {name='MSGLEN ', field=6}
[d08] AS0021: ASRST [12:34:08.93].Type(view=0x008e4d94, field=6)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {type=7, size=2, precision=0, styles=0x0000}
[d08] AS0021: ASRST [12:34:08.93].Attribs(view=0x008e4d94, field=6)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {attributes=0x00000006}
[d08] AS0021: ASRST [12:34:08.93].Field(view=0x008e4d94, number=8)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {name='DATALEN ', field=7}
[d08] AS0021: ASRST [12:34:08.93].Type(view=0x008e4d94, field=7)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {type=7, size=2, precision=0, styles=0x0000}
[d08] AS0021: ASRST [12:34:08.93].Attribs(view=0x008e4d94, field=7)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {attributes=0x00000006}
[d08] AS0021: ASRST [12:34:08.93].Field(view=0x008e4d94, number=9)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {name='REFERENCE ', field=8}
[d08] AS0021: ASRST [12:34:08.93].Type(view=0x008e4d94, field=8)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {type=2, size=20, precision=0, styles=0x0000}
[d08] AS0021: ASRST [12:34:08.93].Attribs(view=0x008e4d94, field=8)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {attributes=0x00000006}
[d08] AS0021: ASRST [12:34:08.93].Field(view=0x008e4d94, number=10)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {name='MESSAGE ', field=9}
[d08] AS0021: ASRST [12:34:08.93].Type(view=0x008e4d94, field=9)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {type=1, size=1024, precision=0, styles=0x0000}
[d08] AS0021: ASRST [12:34:08.93].Attribs(view=0x008e4d94, field=9)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {attributes=0x00000006}
[d08] AS0021: ASRST [12:34:08.93].Presents(view=0x008e4d94, field=9)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {None}
[d08] AS0021: ASRST [12:34:08.93].Name(view=0x008e4d94, field=9)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {name='MESSAGE ', desc='Message '}
[d08] AS0021: ASRST [12:34:08.93].Get(view=0x008e4d94, field=9, size=1024)
[d08] 0 <==[12:34:08.93;t=0;ovh=0] {buffer='\49\6d\70\6f\72\74\20\66\72\6f\6d\20\45\3a\5c\45\58\49\53\54\20\43\41\53\48\55\50\5c\4d\61\79\20\32\30\31\32\5c\42\41\5c\32\34\2d\30\35\2d\32\30\31\32\20\53\65\6e\64\45\58\5c\45\78\70\6f\72\74\5c\4f\45\2e\78\6c\73\20\61\74\20\72\65\63\6f\72\64\3a\31\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\2
[d08] AS0021: ASRST [12:34:08.95].Get(view=0x008e4d94, field=0, size=6)
[d08] 0 <==[12:34:08.95;t=0;ovh=0] {buffer='\45\58\43\4f\20\20' -> 'EXCO '}
[d08] AS0021: ASRST [12:34:08.95].Get(view=0x008e4d94, field=1, size=8)
[d08] 0 <==[12:34:08.95;t=0;ovh=0] {buffer='\4f\45\31\31\30\30\49\4d' -> 'OE1100IM'}
[d08] AS0021: ASRST [12:34:08.95].Get(view=0x008e4d94, field=2, size=2)
[d08] 0 <==[12:34:08.95;t=0;ovh=0] {buffer='\e5\1a'}
[d08] AS0021: ASRST [12:34:08.95].Fetch(view=0x008e4d94)
[d08] 6 <==[12:34:08.95;t=0;ovh=0] {**ERROR**}
[d08] AS0021: ASRST [12:34:11.81].Get(view=0x008e4d94, field=0, size=6)
[d08] 0 <==[12:34:11.81;t=0;ovh=0] {buffer='\45\58\43\4f\20\20' -> 'EXCO '}
[d08] AS0021: ASRST [12:34:11.81].Get(view=0x008e4d94, field=1, size=8)
[d08] 0 <==[12:34:11.81;t=0;ovh=0] {buffer='\4f\45\31\31\30\30\49\4d' -> 'OE1100IM'}
[d08] AS0021: ASRST [12:34:11.81].Get(view=0x008e4d94, field=2, size=2)
[d08] 0 <==[12:34:11.81;t=0;ovh=0] {buffer='\e5\1a'}
[d08] AS0021: ASRST [12:34:11.81].Put(view=0x008e4d94, field=0, size=6, verify=0, buffer='\20\20\20\20\20\20' -> ' ')
[d08] 0 <==[12:34:11.81;t=0;ovh=0] {}
[d08] AS0021: ASRST [12:34:11.81].Put(view=0x008e4d94, field=1, size=8, verify=0, buffer='\20\20\20\20\20\20\20\20' -> ' ')
[d08] 0 <==[12:34:11.81;t=0;ovh=0] {}
[d08] AS0021: ASRST [12:34:11.81].Put(view=0x008e4d94, field=2, size=2, verify=0, buffer='\01\80')
[d08] 0 <==[12:34:11.81;t=0;ovh=0] {}
[d08] AS0021: ASRST [12:34:11.82].Browse(view=0x008e4d94, filter='(ORGID = EXCO AND PGMNAME = OE1100IM)', direction=forward)
[d08] 0 <==[12:34:11.82;t=0;ovh=0] {}
[d08] AS0021: ASRST [12:34:11.82].Fetch(view=0x008e4d94)
[d08] 0 <==[12:34:11.82;t=0;ovh=0] {}
[d08] AS0021: ASRST [12:34:11.82].Get(view=0x008e4d94, field=0, size=6)
[d08] 0 <==[12:34:11.82;t=0;ovh=0] {buffer='\45\58\43\4f\20\20' -> 'EXCO '}
[d08] AS0021: ASRST [12:34:11.82].Get(view=0x008e4d94, field=1, size=8)
[d08] 0 <==[12:34:11.82;t=0;ovh=0] {buffer='\4f\45\31\31\30\30\49\4d' -> 'OE1100IM'}
[d08] AS0021: ASRST [12:34:11.82].Get(view=0x008e4d94, field=2, size=2)
[d08] 0 <==[12:34:11.82;t=0;ovh=0] {buffer='\e5\1a'}
[d08] AS0021: ASRST [12:34:11.82].Get(view=0x008e4d94, field=4, size=5)
[d08] 0 <==[12:34:11.82;t=0;ovh=0] {buffer='\02\01\20\53\0c' -> 20120530}
[d08] AS0021: ASRST [12:34:11.82].Get(view=0x008e4d94, field=5, size=5)
[d08] 0 <==[12:34:11.82;t=0;ovh=0] {buffer='\01\23\22\41\4c' -> 12322414}
[d08] AS0021: ASRST [12:34:11.82].Get(view=0x008e4d94, field=9, size=1024)
[d08] 0 <==[12:34:11.82;t=0;ovh=0] {buffer='\49\6d\70\6f\72\74\20\66\72\6f\6d\20\45\3a\5c\45\58\49\53\54\20\43\41\53\48\55\50\5c\4d\61\79\20\32\30\31\32\5c\42\41\5c\32\34\2d\30\35\2d\32\30\31\32\20\53\65\6e\64\45\58\5c\45\78\70\6f\72\74\5c\4f\45\2e\78\6c\73\20\61\74\20\72\65\63\6f\72\64\3a\31\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\2
[d08] AS0021: ASRST [12:34:11.82].Read(view=0x008e4d94)
[d08] 0 <==[12:34:11.82;t=0;ovh=0] {}
[d08] AS0021: ASRST [12:34:11.82].Get(view=0x008e4d94, field=0, size=6)
[d08] 0 <==[12:34:11.82;t=0;ovh=0] {buffer='\45\58\43\4f\20\20' -> 'EXCO '}
[d08] AS0021: ASRST [12:34:11.82].Get(view=0x008e4d94, field=1, size=8)
[d08] 0 <==[12:34:11.82;t=0;ovh=0] {buffer='\4f\45\31\31\30\30\49\4d' -> 'OE1100IM'}
[d08] AS0021: ASRST [12:34:11.82].Get(view=0x008e4d94, field=2, size=2)
[d08] 0 <==[12:34:11.82;t=0;ovh=0] {buffer='\e5\1a'}
[d08] AS0021: ASRST [12:34:11.82].Get(view=0x008e4d94, field=4, size=5)
[d08] 0 <==[12:34:11.82;t=0;ovh=0] {buffer='\02\01\20\53\0c' -> 20120530}
[d08] AS0021: ASRST [12:34:11.82].Get(view=0x008e4d94, field=5, size=5)
[d08] 0 <==[12:34:11.82;t=0;ovh=0] {buffer='\01\23\22\41\4c' -> 12322414}
[d08] AS0021: ASRST [12:34:11.82].Get(view=0x008e4d94, field=9, size=1024)
[d08] 0 <==[12:34:11.82;t=0;ovh=0] {buffer='\49\6d\70\6f\72\74\20\66\72\6f\6d\20\45\3a\5c\45\58\49\53\54\20\43\41\53\48\55\50\5c\4d\61\79\20\32\30\31\32\5c\42\41\5c\32\34\2d\30\35\2d\32\30\31\32\20\53\65\6e\64\45\58\5c\45\78\70\6f\72\74\5c\4f\45\2e\78\6c\73\20\61\74\20\72\65\63\6f\72\64\3a\31\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\2
[d08] AS0021: ASRST [12:34:11.82].Process(view=0x008e4d94)
[d08] 0 <==[12:34:11.92;t=93;ovh=0] {}
[d08] AS0021: ASRST [12:34:11.92].Get(view=0x008e4d94, field=0, size=6)
[d08] 0 <==[12:34:11.92;t=0;ovh=0] {buffer='\45\58\43\4f\20\20' -> 'EXCO '}
[d08] AS0021: ASRST [12:34:11.92].Get(view=0x008e4d94, field=1, size=8)
[d08] 0 <==[12:34:11.92;t=0;ovh=0] {buffer='\4f\45\31\31\30\30\49\4d' -> 'OE1100IM'}
[d08] AS0021: ASRST [12:34:11.92].Get(view=0x008e4d94, field=2, size=2)
[d08] 0 <==[12:34:11.92;t=0;ovh=0] {buffer='\e5\1a'}
[d08] AS0021: ASRST [12:34:11.92].Get(view=0x008e4d94, field=4, size=5)
[d08] 0 <==[12:34:11.92;t=0;ovh=0] {buffer='\02\01\20\53\0c' -> 20120530}
[d08] AS0021: ASRST [12:34:11.92].Get(view=0x008e4d94, field=5, size=5)
[d08] 0 <==[12:34:11.92;t=0;ovh=0] {buffer='\01\23\41\18\5c' -> 12341185}
[d08] AS0021: ASRST [12:34:11.92].Get(view=0x008e4d94, field=9, size=1024)
[d08] 0 <==[12:34:11.92;t=0;ovh=0] {buffer='\49\6d\70\6f\72\74\20\66\72\6f\6d\20\45\3a\5c\45\58\49\53\54\20\43\41\53\48\55\50\5c\4d\61\79\20\32\30\31\32\5c\42\41\5c\32\34\2d\30\35\2d\32\30\31\32\20\53\65\6e\64\45\58\5c\45\78\70\6f\72\74\5c\4f\45\2e\78\6c\73\20\61\74\20\72\65\63\6f\72\64\3a\31\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\20\2
[d08] AS0021: ASRST [12:34:11.93].Presents(view=0x008e4d94, field=7)
[d08] 0 <==[12:34:11.93;t=0;ovh=0] {None}
[d08] AS0021: ASRST [12:34:11.93].Name(view=0x008e4d94, field=7)
[d08] 0 <==[12:34:11.93;t=0;ovh=0] {name='DATALEN ', desc='Data Length '}
[d08] AS0021: ASRST [12:34:11.93].Get(view=0x008e4d94, field=7, size=2)
[d08] 0 <==[12:34:11.93;t=0;ovh=0] {buffer='\c0\01'}
[d08] AS0021: ASRST [12:34:11.93].Field(view=0x008e4d94, number=11)
[d08] 0 <==[12:34:11.93;t=0;ovh=0] {name='DATA ', field=10}
[d08] AS0021: ASRST [12:34:11.93].Type(view=0x008e4d94, field=10)
[d08] 0 <==[12:34:11.93;t=0;ovh=0] {type=2, size=1024, precision=0, styles=0x0000}
[d08] AS0021: ASRST [12:34:11.93].Attribs(view=0x008e4d94, field=10)
[d08] 0 <==[12:34:11.93;t=0;ovh=0] {attributes=0x00000006}
[d08] AS0021: ASRST [12:34:11.93].Presents(view=0x008e4d94, field=10)
[d08] 0 <==[12:34:11.93;t=0;ovh=0] {None}
[d08] AS0021: ASRST [12:34:11.93].Name(view=0x008e4d94, field=10)
[d08] 0 <==[12:34:11.93;t=0;ovh=0] {name='DATA ', desc='Data '}
[d08] AS0021: ASRST [12:34:11.93].Get(view=0x008e4d94, field=10, size=1024)
[d08] 0 <==[12:34:11.93;t=0;ovh=0] {buffer='\32\00\00\00\c0\01\00\00\01\00\00\00\00\00\00\00\05\00\00\00\3b\00\00\00\01\00\00\00\00\00\00\00\00\00\00\00\87\00\00\00\3d\00\00\00\c4\00\00\00\3b\00\00\00\ff\00\00\00\3d\00\00\00\3c\01\00\00\44\00\00\00\80\01\00\00\40\00\00\00\45\3a\5c\45\58\49\53\54\20\43\41\53\48\55\50\5c\4d\61\79\20\32\30\31\32\5c\42\41\5c\32\34\2d\30\35\2d\32\30\31\32\20\53\65\6e\64\45\58\5c\45\78\70\6f\72\74\5c\4f\45\2e\78\6c\73\4f\45\30\35\32\30\00\00\03\00\00\00\00\ed\12\00\c0\ec\2a\04\71\00\00\00\06\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\4f\72\64\65\72\73\05\00\00\00\1c\a0\00\00\00\00\00\27\01\00\00\4f\45\30\35\30\30\00\00\01\00\00\00\4f\45\30\35\32\30\00\04\2c\00\00\00\0d\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\4f\72\64\65\72\5f\44\65\74\61\69\6c\73\0b\c5\07\04\00\00\4f\45\30\36\38\30\00\00\01\00\00\00\4f\45\30\35\32\30\00\04\04\00\00\00\14\00\00\00\00\00\00\00\00\00\00\00\00\00\00\00\4f\72\64\65\72\5f\53\65\72\69\61\6c\5f\4e\75\6d\62\65\72\73\0f\4f\45\30\31\38\30\00\00\01\00\0
[d08] OE0520: OEORDH [12:34:11.95].Load
[d08] OE0520: OEORDH [12:34:11.95].InstanceOpen(PIB=2046, link=52, flags=0x00000000)
[d08] OE0540: OEPLAT [12:34:11.95].Load
[d08] OE0540: OEPLAT [12:34:11.95].InstanceOpen(PIB=2046, link=52, flags=0x00000040)
[d08] 0 <==[12:34:11.95;t=0;ovh=0] {view=0x0b45cffc}
[d08] OE0540: OEPLAT [12:34:11.95].Name(view=0x0b45cffc, field=999999998 <TITLE_IDX>)
[d08] 0 <==[12:34:11.95;t=0;ovh=0] {name=' ', desc='Templates '}
[d08] OE0540: OEPLAT [12:34:11.95].CmpNames()
[d08] 0 <==[12:34:11.95;t=0;ovh=0] {count=0}
[d08] OE0540: OEPLAT [12:34:11.95].CmpNames()
[d08] 0 <==[12:34:11.95;t=0;ovh=0] {count=0, names=''}
[d08] OE0480: OEOPT [12:34:11.95].Load
[d08] OE0480: OEOPT [12:34:11.95].InstanceOpen(PIB=2046, link=52, flags=0x00000000)
[d08] 0 <==[12:34:11.95;t=0;ovh=0] {view=0x0b53ea2c}
[d08] OE0480: OEOPT [12:34:11.95].Name(view=0x0b53ea2c, field=999999998 <TITLE_IDX>)
[d08] 0 <==[12:34:11.95;t=0;ovh=0] {name=' ', desc='Options '}
[d08] 0 <==[12:34:11.96;t=15;ovh=0] {view=0x03fac75c}
[d08] OE0520: OEORDH [12:34:11.96].Keys(view=0x03fac75c)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {keys=6}
[d08] OE0520: OEORDH [12:34:11.96].Key(view=0x03fac75c, number=0)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {name='Order Uniquifier Key ', fields=1, keyFields=1$}
[d08] OE0520: OEORDH [12:34:11.96].Fields(view=0x03fac75c)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {fields=249}
[d08] OE0520: OEORDH [12:34:11.96].Name(view=0x03fac75c, field=999999998 <TITLE_IDX>)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {name=' ', desc='Orders '}
[d08] OE0520: OEORDH [12:34:11.96].CmpNames()
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {count=63}
[d08] OE0520: OEORDH [12:34:11.96].CmpNames()
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {count=9, names='OE0500$OE0680$OE0180$OE0740$OE0420$OE0400$OE0660$OE0160$OE0720$'}
[d08] OE0520: OEORDH [12:34:11.96].Keys(view=0x03fac75c)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {keys=6}
[d08] OE0520: OEORDH [12:34:11.96].Key(view=0x03fac75c, number=0)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {name='Order Uniquifier Key ', fields=1, keyFields=1$}
[d08] OE0520: OEORDH [12:34:11.96].Field(view=0x03fac75c, number=1)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {name='ORDUNIQ ', field=1}
[d08] OE0520: OEORDH [12:34:11.96].Type(view=0x03fac75c, field=1)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {type=6, size=10, precision=0, styles=0x0000}
[d08] OE0520: OEORDH [12:34:11.96].Attribs(view=0x03fac75c, field=1)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {attributes=0x0000008e}
[d08] OE0520: OEORDH [12:34:11.96].Key(view=0x03fac75c, number=1)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {name='Order Number Key ', fields=1, keyFields=2$}
[d08] OE0520: OEORDH [12:34:11.96].Field(view=0x03fac75c, number=2)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {name='ORDNUMBER ', field=2}
[d08] OE0520: OEORDH [12:34:11.96].Type(view=0x03fac75c, field=2)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {type=1, size=22, precision=0, styles=0x0000}
[d08] OE0520: OEORDH [12:34:11.96].Attribs(view=0x03fac75c, field=2)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {attributes=0x00000006}
[d08] OE0520: OEORDH [12:34:11.96].Key(view=0x03fac75c, number=2)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {name='Customer Number ', fields=1, keyFields=3$}
[d08] OE0520: OEORDH [12:34:11.96].Field(view=0x03fac75c, number=3)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {name='CUSTOMER ', field=3}
[d08] OE0520: OEORDH [12:34:11.96].Type(view=0x03fac75c, field=3)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {type=1, size=12, precision=0, styles=0x0000}
[d08] OE0520: OEORDH [12:34:11.96].Attribs(view=0x03fac75c, field=3)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {attributes=0x00000006}
[d08] OE0520: OEORDH [12:34:11.96].Key(view=0x03fac75c, number=3)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {name='Type/Complete ', fields=3, keyFields=39$129$1$}
[d08] OE0520: OEORDH [12:34:11.96].Field(view=0x03fac75c, number=4)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {name='CUSTGROUP ', field=4}
[d08] OE0520: OEORDH [12:34:11.96].Type(view=0x03fac75c, field=4)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {type=1, size=3, precision=0, styles=0x0000}
[d08] OE0520: OEORDH [12:34:11.96].Attribs(view=0x03fac75c, field=4)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {attributes=0x00000006}
[d08] OE0520: OEORDH [12:34:11.96].Field(view=0x03fac75c, number=5)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {name='BILNAME ', field=5}
[d08] OE0520: OEORDH [12:34:11.96].Type(view=0x03fac75c, field=5)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {type=1, size=30, precision=0, styles=0x0000}
[d08] OE0520: OEORDH [12:34:11.96].Attribs(view=0x03fac75c, field=5)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {attributes=0x00000006}
[d08] OE0520: OEORDH [12:34:11.96].Field(view=0x03fac75c, number=6)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {name='BILADDR1 ', field=6}
[d08] OE0520: OEORDH [12:34:11.96].Type(view=0x03fac75c, field=6)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {type=1, size=30, precision=0, styles=0x0000}
[d08] OE0520: OEORDH [12:34:11.96].Attribs(view=0x03fac75c, field=6)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {attributes=0x00000006}
[d08] OE0520: OEORDH [12:34:11.96].Field(view=0x03fac75c, number=7)
[d08] 0 <==[12:34:11.96;t=0;ovh=0] {name='BILADDR2 ', field=7}
[d08] OE0520: OEORDH [12:34:11.96].Type(view=0x03fac75c, field=7)
[d08] 0 <==[12:34:11.98;t=0;ovh=0] {type=1, size=30, precision=0, styles=0x0000}
[d08] OE0520: OEORDH [12:34:11.98].Attribs(view=0x03fac75c, field=7)
[d08] 0 <==[12:34:11.98;t=0;ovh=0] {attributes=0x00000006}
[d08] OE0520: OEORDH [12:34:11.98].Field(view=0x03fac75c, number=8)
[d08] 0 <==[12:34:11.98;t=0;ovh=0] {name='BILADDR3 ', field=8}
[d08] OE0520: OEORDH [12:34:11.98].Type(view=0x03fac75c, field=8)
[d08] 0 <==[12:34:11.98;t=0;ovh=0] {type=1, size=30, precision=0, styles=0x0000}
[d08] OE0520: OEORDH [12:34:11.98].Attribs(view=0x03fac75c, field=8)
[d08] 0 <==[12:34:11.98;t=0;ovh=0] {attributes=0x00000006}
[d08] OE0520: OEORDH [12:34:11.98].Field(view=0x03fac75c, number=9)
[d08] 0 <==[12:34:11.98;t=0;ovh=0] {name='BILADDR4 ', field=9}
[d08] OE0520: OEORDH [12:34:11.98].Type(view=0x03fac75c, field=9)
[d08] 0 <==[12:34:11.98;t=0;ovh=0] {type=1, size=30, precision=0, styles=0x0000}
[d08] OE0520: OEORDH [12:34:11.98].Attribs(view=0x03fac75c, field=9)
[d08] 0 <==[12:34:11.98;t=0;ovh=0] {attributes=0x00000006}
[d08] OE0520: OEORDH [12:34:11.98].Field(view=0x03fac75c, number=10)
[d08] 0 <==[12:34:11.98;t=0;ovh=0] {name='BILCITY ', field=10}
[d08] OE0520: OEORDH [12:34:11.98].Type(view=0x03fac75c, field=10)
[d08] 0 <==[12:34:11.98;t=0;ovh=0] {type=1, size=20, precision=0, styles=0x0000}
[d08] OE0520: OEORDH [12:34:11.98].Attribs(view=0x03fac75c, field=10)
[d08] 0 <==[12:34:11.98;t=0;ovh=0] {attributes=0x00000006}
[d08] OE0520: OEORDH [12:34:11.98].Field(view=0x03fac75c, number=11)
[d08] 0 <==[12:34:11.98;t=0;ovh=0] {name='BILSTATE ', field=11}
[d08] OE0520: OEORDH [12:34:11.98].Type(view=0x03fac75c, field=11)
[d08] 0 <==[12:34:11.98;t=0;ovh=0] {type=1, size=20, precision=0, styles=0x000
tuba2007 (Programmer)
30 May 12 6:50
That RVSPY snippet was useless, it wasn't from the end where the error was.

In your import file, do not put ORDNUMBER, let the system create it.
Read More Threads Like This One

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To ACCPAC Solutions

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close