Sage 100

 View Only

  • 1.  Crystal formula error on Unit of Measure.

    Posted 03-28-2021 13:43
    I'm trying to create a formula in crystal that if the items bought by the linear yard or perf length it will display the total weight of the item on the picking sheet.

    Here is what I have for my formula to display if the unit of measure begins with L or P:

    if {SO_PickingSheetWrk.UnitOfMeasure} startswith "L" then {@LineWeight} or
    {SO_PickingSheetWrk.UnitOfMeasure} startswith "P" then {@LineWeight_PERF} else 0

    @LineWeight_PERF formula = (({SO_PickingSheetWrk.QuantityOrdered} * {CI_Item.UDF_PERF_LEN})/36) * {SO_PickingSheetWrk.ItemWeight}
    @LineWeight formula = {SO_PickingSheetWrk.QuantityOrdered} * {SO_PickingSheetWrk.ItemWeight}

    Here is the error I'm getting. I think it has to be a simple I'm overlooking with this error.





    ​​

    ------------------------------
    Shannon Stanley
    Sage 100 Consultant
    Ardent Consulting LLC
    704-839-6697
    ------------------------------


  • 2.  RE: Crystal formula error on Unit of Measure.

    Posted 03-28-2021 14:23
    try this:

    if {SO_PickingSheetWrk.UnitOfMeasure} startswith "L" then {@LineWeight} else if
    {SO_PickingSheetWrk.UnitOfMeasure} startswith "P" then {@LineWeight_PERF} else "0"

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 3.  RE: Crystal formula error on Unit of Measure.

    Posted 03-28-2021 14:32
    Take off the OR at the end of line 1 and put ELSE IF at the start of line 2

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Tennessee Software Solutions
    269-445-1625
    ------------------------------



  • 4.  RE: Crystal formula error on Unit of Measure.

    Posted 03-28-2021 19:17
    Thank you Doug and Beth! I got the formula to work.

    ------------------------------
    Shannon Stanley
    Sage 100 Consultant
    Ardent Consulting LLC
    704-839-6697
    ------------------------------

    Original Message


Related Content