ISTech Support Forum - What file to write back tracking #

Welcome, Guest. Please Login.

	09/20/24 at 22:40:55 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › General DBA Topics

‹ Previous topic | Next topic ›

Pages: 1

What file to write back tracking # (Read 1516 times)

JNAPIER Active Member Evil-Evo Bad Dog! Posts: 533 Gender:	What file to write back tracking # 04/21/05 at 11:10:00 I have set-up an ODBC interface to DBA for shipping UPS and FedEx. What file name is the tracking # DBA writes to? Thanks, John
Back to top	EVO-ERP, ISTS 3.27.08 , 2000I 10 user IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: What file to write back tracking # Reply #1 - 04/21/05 at 11:57:25 Assuming you mean the Shipping tracking info in SO-E and/or SO-P-I with IS Tech updates, it is BKARDESC linked by SO Number before invoice posting and transferred to BKARHDSC linked by invoice number when the invoice posts.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

Mike_Habich Full Member Posts: 227	Re: What file to write back tracking # Reply #2 - 05/03/05 at 11:17:07 John...did you get this working? If so, what does your UPS export map look like? I tried UPS tracking number -> BKARDESC BK.DESC.LINE UPS ref 2 (put SO number here) -> BKARDESC BK.DESC.NUM Doesn't work yet. I'm not sure how to tell the map which link is the index and which is to be written.
Back to top	IP Logged

Mike_Habich

Full Member

Posts: 227

Re: What file to write back tracking #
Reply #3 - 05/03/05 at 11:55:48

map should be
track no -> BKARDESC BK.DESC.NOTES
ref 2 (SO) -> BKARDESC BK.DESC.NUM
and...how to do this?
1 -> BKARDESC BK.DESC.NUM
I'll contact UPS for how to write a constant "1" instead of a field value

Forget index and stuff...everything should get written into a new record, or so it seems. Don't know what this would do if somebody already entered SO notes line 1...

IP Logged

JNAPIER

Active Member

Evil-Evo Bad Dog!

Posts: 533
Gender: male

Re: What file to write back tracking #
Reply #4 - 05/03/05 at 14:32:22

Mike,

I played with some sample exports. The problem I encountered was UPS has no Index Key field to write to the proper SO #. It wrote to the field but not to the correct SO# It looks like the ISTS popup to enter at release knows at what line to write to based on existing SO notes? It also allows you to put the carrier name in. I think the write back for ups tracking # is questionable.

John

EVO-ERP, ISTS 3.27.08 , 2000I 10 user

IP Logged

Mike_Habich Full Member Posts: 227	Re: What file to write back tracking # Reply #5 - 05/04/05 at 06:20:23 I have it working by now. Once I've tested it a bit more, I'll publish the details. For SO, just put it in UPS Ref 2.
Back to top	IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › General DBA Topics

‹ Previous topic | Next topic ›