ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> Field name for "Reason for Returns" for RMA
http://www.istechforum.com/YaBB.pl?num=1219692358

Message started by gtladmin on 08/25/08 at 12:25:57

Title: Field name for "Reason for Returns" for RMA
Post by gtladmin on 08/25/08 at 12:25:57

In SO-P-F, Enter Returns, what is the table and field name that holds the date for "Reason for Return"?

TIA,

Val

Title: Re: Field name for "Reason for Returns" for RMA
Post by GasGiant on 08/25/08 at 12:40:50

Are you looking for the data from each RMA (ISRMAI.B) or the list of codes (ISRMAC.B)?

Title: Re: Field name for "Reason for Returns" for RMA
Post by gtladmin on 08/25/08 at 14:31:33

The data - sales wants to do a Crystal report using the data entered in that field. They are not using codes,
but words, like "customer ordered wrong part".

Would that be in the ISRMAI.B table?

Val

Title: Re: Field name for "Reason for Returns" for RMA
Post by GasGiant on 08/25/08 at 14:53:52

yes

ISRMAI.is_rma_reason

Title: Re: Field name for "Reason for Returns" for RMA
Post by gtladmin on 08/26/08 at 06:18:35

Ok, so at first I didn't see that table through Crystal. So I generated new DDFs in Evo and now
I can see those two tables, but no data comes up in them. What's up with that?

Val

Title: Re: Field name for "Reason for Returns" for RMA
Post by GasGiant on 08/26/08 at 06:28:09

Try looking at them in Maintain Database. If you are using the RMA module (as we do) then that is where the data goes. I can see it in there and I can use the data for my browser-based datamining reports.

Title: Re: Field name for "Reason for Returns" for RMA
Post by gtladmin on 08/26/08 at 09:11:32

Well, it turns out that Sales has refused to move to the new module (even though they went thru testing it for months) and have remained using the old module. Way back in Jan/Feb I had posted a question on how to get the date from the old RMA stuff and had to do a data extraction to Excel to get it, and it wasn't very friendly but it was all there. And I let Sales know how the data was being stored and that reason should be one of the primary reasons why they move to the new RMA module. Now we are back in time--again they are asking the same thing, how to do a Crystal report using that data, and again (DEJA VU!) I am telling them you can't but if you use the new module you will be able to--but they won't use the new module. I'm at my wits end here......

SO NOW they just want me to make Lynn and Allen modify the old module so it essentially does what the new module does--save the data into a different table. There's no telling them otherwise.....

Val

Title: Re: Field name for "Reason for Returns" for RMA
Post by GasGiant on 08/26/08 at 09:38:50

Tell them how much the bill would be. That might motivate them :D

Title: Re: Field name for "Reason for Returns" for RMA
Post by dameng on 08/26/08 at 10:57:36

or accidently remove the old RMA menu.......

blame the update.......or something.

but magically transpose into the New RMA, and tell them, Oh well !! :o ;D

Title: Re: Field name for "Reason for Returns" for RMA
Post by gtladmin on 08/27/08 at 07:31:15

BELIEVE ME, that has run through my mind SEVERAL times!!!!!! ;)