Welcome, Guest. Please Login.
11/01/24 at 09:35:46
News:
Home Help Search Login


Pages: 1
Send Topic Print
Write freight cost to DBA from UPS WorldShip (Read 643 times)
Mike_Habich
Full Member
***




Posts: 227
Write freight cost to DBA from UPS WorldShip
05/06/05 at 08:44:22
 
UPS WorldShip can export freight cost via ODBC.  I've figured out how to write the tracking number back to DBA (see post in General DBA Topics)...that's easy, because you're just writing a new record to the DBA file.  How could you write freight cost to DBA?  I'm guessing that it would require writing a field to an existing record.  Would this be most easily done with an add-on?
Back to top
 
 
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Write freight cost to DBA from UPS WorldShip
Reply #1 - 05/06/05 at 17:09:32
 
You are reinventing the wheel.  There is already an add-on to link the UPS WorldShip and DBA.  See www.addsuminc.com, they have had this available for several years.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Mike_Habich
Full Member
***




Posts: 227
Re: Write freight cost to DBA from UPS WorldShip
Reply #2 - 05/07/05 at 07:38:41
 
Yes, and it seems a great program, sort of a limo as wheels go.  I'm looking for a training wheel for a scooter...don't need address import and such, since we ship to the same customers all the time.
 
Anyway, how hard is it to write the freight cost to DBA?  Is it something that can be done simply with ODBC, or would it take more?
Back to top
 
 
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Write freight cost to DBA from UPS WorldShip
Reply #3 - 05/12/05 at 11:19:03
 
I think you only need to write to the BKARINV file, field BKAR.INV.FRGHT because the SO-F program when printing the invoice will recalculate the invoice total.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print