• Replies 9 replies
  • Subscribers 339 subscribers
  • Views 131 views
  • Users 0 members are here
Related

Adding a fee to existing orders

Chris Jensen
$organization

We are getting started with our '11-'12 season rollover, and after executing our first two Rollover Sets, we find that the fee rule wasn't quite right, and none of these orders have a handling fee.

Is anyone aware of a way to add these en masse? Crazy SQL solutions welcome. :-)

Parents
  • $organization

    Fees are not terribly difficult to add to an order.  We add fees in order to charge our Met Player Monthly and Yearly Subscriptions in an automated process.   I have included the code but it I consulted with the Network before I did this and would advise the same...(they always remind me of something I may have missed).....At the time they told me also to inclue the execute of  TP_Update_Order_Totals.   Hope this helps.

     

     

    EXEC @next_idFF = AP_GET_NEXTID_FUNCTION 'FF'

     

    INSERT INTO T_SLI_FEE ( sli_no, fee_no, order_no, li_seq_no, fee_amt, fee_override_ind, fee_override_amt, user_defined_ind, customer_no, id )

     

    VALUES ( 0, @fee_no, @order_no, 0, @fee_amt, 'N', 0.0000, 'Y', 0, @next_idFF )

     

     

    Exec TP_UPDATE_ORDER_TOTALS @parm_type = 'O', @parm_val =  @order_no

     

Reply
  • $organization

    Fees are not terribly difficult to add to an order.  We add fees in order to charge our Met Player Monthly and Yearly Subscriptions in an automated process.   I have included the code but it I consulted with the Network before I did this and would advise the same...(they always remind me of something I may have missed).....At the time they told me also to inclue the execute of  TP_Update_Order_Totals.   Hope this helps.

     

     

    EXEC @next_idFF = AP_GET_NEXTID_FUNCTION 'FF'

     

    INSERT INTO T_SLI_FEE ( sli_no, fee_no, order_no, li_seq_no, fee_amt, fee_override_ind, fee_override_amt, user_defined_ind, customer_no, id )

     

    VALUES ( 0, @fee_no, @order_no, 0, @fee_amt, 'N', 0.0000, 'Y', 0, @next_idFF )

     

     

    Exec TP_UPDATE_ORDER_TOTALS @parm_type = 'O', @parm_val =  @order_no

     

Children