RMA Return Type

SUGGESTED

Hi

when I print out a RMA, I found RMA line has return type like 'Credit","Not a Return", but I couldn't find where this come from? who and where user enter this information

thanks

  • 0
    SUGGESTED
    There is a checkbox on the line items in the Enter RMA screen to mark it for replacement. If unchecked it defaults to return for credit.
  • 0 in reply to John Mitchell
    Hi John.
    Thank you very much
    In our company we do not check the Rplc check box, so our RMA 99 % shows Credit under Return For. but we really have some RMA shows "Not a Return",I checked RMA Report for this Return Type function code, see below

    if {tsoPrtRMALnWrk.RtrnType} = 1 then
    FreeFormText("kSOCredit")
    else
    if {tsoPrtRMALnWrk.RtrnType} = 2 then
    FreeFormText("kSReplacement")
    else
    FreeFormText("kslvNotaReturn")

    I checked the database RMA line table , some RMA Line return type is not 1 or 2, it is 0, so we got "Not a Return".

    from my understanding , check Rplc , RMA Line should show "Replacement", uncheck Rplc, should show "Credit".

    How come we get 0 in the database?

    thanks you again

    Joe
  • 0 in reply to joe99
    Just a shot in the dark, but does the following query return any CreateType other than 1?

    SELECT
    RMA.CreateType
    ,RMAL.RtrnType
    FROM
    tsoRMA RMA WITH (NOLOCK)
    INNER JOIN tsoRMALine RMAL WITH (NOLOCK) ON
    RMAL.RMAKey = RMA.RMAKey
    WHERE
    RMAL.RtrnType = 0
  • 0 in reply to Ramon M.
    Hi John

    see below result of the query

    thanks



    CreateType RtrnType
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
    1 0
  • 0 in reply to joe99
    I was just curious to see if any of the CreateType values were something other than 1, which would have been a possible indicator that the RMAs came in through a process other than the Sage UI for RMAs. The shot in the dark missed.
  • 0 in reply to Ramon M.
    Hi Ramon

    I double checked the database found all RMA create type are 1, no any other than 1.

    totally we have 18474 records(RMA Lines)
    70 records create type 1, return type 0 (these RMA Lines shows "Not a Return")
    1804 records create type 1, return type 1(these RMA Lines are correct)


    also we have other problems maybe same issue like this:

    1, In inventory, some item QtyRequestForWO not correct. I compare all open WOs total qty with inventory qtyreqforWO, don't match.
    2, Stock status, some item qtyonhand is not match with inventory valuation report.even we select different start date when we run valuation report , we will get different result. some time I got negative numbers.

    please give some idea for the RMA first.

    thanks