View Single Post
  #2 (permalink)  
Old August 7th, 2007, 16:17
bmj_23 bmj_23 is offline
Senior Member and Blogger
 
Join Date: May 2007
Posts: 170
Thanks: 4
Thanked 31 Times in 31 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
bmj_23 will become famous soon enough
Re: Sell shipment costing + 6% of buy

Bob - a very simple approach to this is just to load sell side rates that have a value of the buy side cost but with the margin added.

So, if your buy side rate from A-B is $1000 with a $50 fuel surcharge, you would create a sell side rate from A-B for $1060 with a fuel surcharge accessorial of $3.

At the appropriate time in your buy side process, the sell side shipment would get created with the sell side rate.

This avoids the complication of using the order release allocated cost as the basis of generating the sell side rates.

If you allocate the buy side and sell side costs back to your order releases, you can see both the buy side and the sell side allocated cost there at the line level in order to see the "margin" you are making on each order.

Hope this is feasible in your design.
The Following User Says Thank You to bmj_23 For This Useful Post:
bob_romijn (August 8th, 2007)