Welcome, Guest. Please Login.
05/06/24 at 07:05:57
News:
Home Help Search Login


Pages: 1
Send Topic Print
Field name for "Reason for Returns" for RMA (Read 1920 times)
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Field name for "Reason for Returns" for RMA
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
Back to top
 
 

Val Feehan
  IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1523
Gender: male
Re: Field name for "Reason for Returns" for RMA
Reply #1 - 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)?
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: Field name for "Reason for Returns" for RMA
Reply #2 - 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
Back to top
 
 

Val Feehan
  IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1523
Gender: male
Re: Field name for "Reason for Returns" for RMA
Reply #3 - 08/25/08 at 14:53:52
 
yes
 
ISRMAI.is_rma_reason
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: Field name for "Reason for Returns" for RMA
Reply #4 - 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
Back to top
 
 

Val Feehan
  IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1523
Gender: male
Re: Field name for "Reason for Returns" for RMA
Reply #5 - 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.
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: Field name for "Reason for Returns" for RMA
Reply #6 - 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
Back to top
 
 

Val Feehan
  IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1523
Gender: male
Re: Field name for "Reason for Returns" for RMA
Reply #7 - 08/26/08 at 09:38:50
 
Tell them how much the bill would be. That might motivate them  Cheesy
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
dameng
Senior Member
****


DBA / EVO Software
Consultant

Posts: 275
Gender: male
Re: Field name for "Reason for Returns" for RMA
Reply #8 - 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 !! Shocked  Grin
Back to top
 
 

Dave Mengelkamp
Digital Consulting
760.832.2536
davemeng@earthlink.net
Email WWW   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: Field name for "Reason for Returns" for RMA
Reply #9 - 08/27/08 at 07:31:15
 
BELIEVE ME, that has run through my mind SEVERAL times!!!!!! Wink
Back to top
 
 

Val Feehan
  IP Logged
Pages: 1
Send Topic Print