Scripting help - Contracting

SOLVED

Forgive me if this is against the rules, but I'm trying to find resources to help create a script in SO_SalesOrder Entry. I used to reach out to a particular individual but they are not responding so I'm looking for other folks that could help.

In short, we run a semi-complicated pricing rule system on our e-comm site that does not work (at least we've never seen how to make it work) in sage. We have our customer's assigned a price level, but the price assigned will be determined by the base price of the item & the unit of measure they are purchasing. It's is not a standard volume level discount like I've seen in Sage.

Is anyone familiar with someone who could help with creating a script to achieve this?

Parents
  • 0

    are you saying they may have a different price if they buy by Each vs Case vs Pallet

  • 0 in reply to BigLouie

    Yes, for example:

    If product.udf_stockbaseprice = 'Y' then stockbaseprice*uomconversionqty
    else if account.pricelevel = '1' and unitofmeasure = EACH then stockbaseprice
    else if account.pricelevel = '1' and unitofmeasure = INNE then stockbaseprice*(1-.01)*uomconversionqty
    else if account.pricelevel = 1'' and unitofmeasure = CASE then stockbaseprice*(1-.03)*uomconversionqty

    I mean, I think I have 80% of the script logic done, it's a matter of the objects, getval, retval stuff for Sage I don't understand.

Reply
  • 0 in reply to BigLouie

    Yes, for example:

    If product.udf_stockbaseprice = 'Y' then stockbaseprice*uomconversionqty
    else if account.pricelevel = '1' and unitofmeasure = EACH then stockbaseprice
    else if account.pricelevel = '1' and unitofmeasure = INNE then stockbaseprice*(1-.01)*uomconversionqty
    else if account.pricelevel = 1'' and unitofmeasure = CASE then stockbaseprice*(1-.03)*uomconversionqty

    I mean, I think I have 80% of the script logic done, it's a matter of the objects, getval, retval stuff for Sage I don't understand.

Children