anyone know which fields you need to add to a crystal report to obtain data on the RMA's you have entered?  IE rma number, customer code etc. RMA date etc.
 
when I try ISSRINV in a crystal report and click browse all fields are empty, no data?

when I add those to crystal and click browse all fields are empty, no data?

I just ran this for Jill on all our companies, and the fields are still blank.  What else needs to be done?
 
Val

Good question I already tried checking for that.  I used the PCC to see if I could see any data in those tables, and I do not.  I checked tables I KNOW should definitely contain data (bkarinv for example) and I could see the data in those tables.  So it looks like for some reason they are in fact empty. So if we are logging RMAs (and oh yeah, we have a lot of them!). where's the data???
 
Val

Um, yes we are (jksosa.run for enter, t6jksosb.run for print, and jksosc.run for convert).  So that data is in the BKESTQT file--OK will check to confirm and we'll go from there.  Thanks!
 
Val

Ok, really need to get to the bottom of this.  The CEO is looking for a report, and while we can look up the stuff in EvoERP, for whatever reason we can't get to it via Crystal to create the detailed report he needs because we don't know where the info is kept!  That's not a good explanation for him.  Should it be this difficult?  Geez, seems to me if you have the stuff in your system and you can see it, ya should be able to access it and report on it.  
 
HELP US PLEASE, SOMEONE!!!!!!
 
Val

Thanks, Colin, for the response.
 
Though, geez louise, we're trying to report on RMA reasons for open and closed, so now we're completely screwed.  Had we known we couldn't report on some of this data, we would have used something different instead of putting it all into Evo.  
 
Lynn, Allen, anyone:  Why is it that we can see closed RMAs in Evo, but we can't get access to report on them?  How can that possibly be?  That data has to be somewhere--where is it????
 
What other modules will surprise us like this, not having access to the data we've so diligently entered into the system?
 
Val

Val,
 
  The old RMA system was not written by us. It was a DBA Consultant who had written and sold that RMA Mod to some of his clients. We sold it for him for a while, then eventually we absorbed the code into the standard system, and Now have written our own.. The Old RMA system was lacking in many ways, that is why we have written our own.  
 
  On that note I will look and see where the old RMA info goes... I'll let you know. but if I remember some of the data is stored in the BKAR.INV.EXTRA field and is Embedded in specific locations ie string pos 1 to 10 is old SO number... pos 11 is open or closed or something like that... like I said it was lacking...