Welcome, Guest. Please Login.
12/23/24 at 20:41:33
News:
Home Help Search Login


Pages: 1
Send Topic Print
DBASO.IN file field question (Read 1317 times)
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 639
Gender: male
DBASO.IN file field question
01/29/08 at 15:20:36
 
We use the DBASO.IN file to import batches of orders.
We generate DBASO.IN using a Script.
 
I do not see a DBASO.IN field that populates the BKARHINV.INV.SHPATN field.
 
Am I just missing it, or is there no way to populate this field in a Sales Order from the DBASO.IN file?
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
RPCAdmin
Active Member
*****


Please save me from
the Users!!!!!!!

Posts: 521
Gender: male
Re: DBASO.IN file field question
Reply #1 - 01/31/08 at 05:09:59
 
Kevin,
 
I assume you have looked at the map of DBASO.IN and DBASO.OUT - If not, I can send it to you.  From what I can tell, the field you mention is not there.  They do map BAKR.INV.CUSATT to position 224 in SOHEAD, but I don't know if that is the same data as what you are looking for.
Back to top
 
 

Mike Nessen
Sr. Engineer/IT Manager/Anything else I need to be
EVO-Erp Build (always the latest) Client/Server
Pervasive 2000i on NT4 Server 15 users
Email 272531373   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: DBASO.IN file field question
Reply #2 - 01/31/08 at 08:22:43
 
We map the ship attn: to the bkar.inv.custattn in the header, which works fine when it's used.
 
Val
 
Back to top
 
 

Val Feehan
  IP Logged
RPCAdmin
Active Member
*****


Please save me from
the Users!!!!!!!

Posts: 521
Gender: male
Re: DBASO.IN file field question
Reply #3 - 01/31/08 at 08:38:24
 
If for some reason that is not what Kevin needs, then he is out of luck as far as bringing in data into a field in the database.  The only other thing you can do is to use SONOTES to bring in information into the Sales Order notes.
Back to top
 
 

Mike Nessen
Sr. Engineer/IT Manager/Anything else I need to be
EVO-Erp Build (always the latest) Client/Server
Pervasive 2000i on NT4 Server 15 users
Email 272531373   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 639
Gender: male
Re: DBASO.IN file field question
Reply #4 - 03/07/08 at 10:54:06
 
Thanks for all the info.
 
We do currently populate some description fields with email address, phone number, and XXX'ed out Credit Card info.
 
I did not notice the custattn in the header.  We will just map it in there, and then in my SQL, I will just use that  
field if the actual Shipto attention fields is blank.
 
Thanks!
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Pages: 1
Send Topic Print