View Single Post
  #7 (permalink)  
Old December 7th, 2007, 18:34
AlejandroBarba AlejandroBarba is offline
Senior Member and Blogger
 
Join Date: Nov 2006
Location: San Diego, CA
Posts: 76
Blog Entries: 2
Thanks: 0
Thanked 18 Times in 17 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 3
AlejandroBarba is on a distinguished road
Re: Updating Buy Shipments

Hi Eric,

If it is a flat rate; is it dependant on the lane or does it change for every shipment? If it is dependant on the lane, I strongly suggest creating Sell Rate Records for these flat rates.

If the flat amount changes for every shipment, the approach I can think of is kind of complex but here it comes:

1. Create a "dummy" sell rate record just to be able to plan the sell shipment (lets say $0.01 per shipment)
2. Send the sell shipment cost as a order release reference number in the XML transmission
3. Have an agent listening to the sell shipment creation with a Direct SQL Command action that will copy the reference number value to the Sell Shipment Cost.

Finally, make sure that no one re-assigns a rate to the sell shipments because it will change the cost back to the "dummy" sell rate and also that the sell rate record can only be used for only these sell shipments.

Hope this helps, if you still have any questions, please let me know.

Alejandro B.