Welcome to the Sage 500 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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
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".
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".
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
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.
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.