ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> rma field names for crystal
http://www.istechforum.com/YaBB.pl?num=1201545284

Message started by jfowler on 01/28/08 at 11:34:43

Title: rma field names for crystal
Post by jfowler on 01/28/08 at 11:34:43

[smiley=embarassed.gif] 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?

Title: Re: rma field names for crystal
Post by GasGiant on 01/28/08 at 11:40:00

They are just like the Sales Order fields (same names) but are in ISSRINV.B and ISSRINVL.B instead of the BKAR tables. They are mixed in with the SR orders, if you use them. The Status field differentiates them.

Title: Re: rma field names for crystal
Post by jfowler on 01/28/08 at 12:06:44

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

Title: Re: rma field names for crystal
Post by GasGiant on 01/28/08 at 12:39:51

Likely you have not remade your ODBC files since the new tables were added. You will need to run ODBCDDF.RUN to update them so that CR, etc. can find the newer tables.

Title: Re: rma field names for crystal
Post by gtladmin on 01/29/08 at 10:40:55

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

Val

Title: Re: rma field names for crystal
Post by GasGiant on 01/29/08 at 10:55:18

Hmmm... I suppose that this is where I should belatedly ask, do you see data in ISSRINV.Bnn when viewed with Maintain Database?

Title: Re: rma field names for crystal
Post by gtladmin on 01/29/08 at 13:36:43

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

Title: Re: rma field names for crystal
Post by GasGiant on 01/29/08 at 13:55:08

Egad, are you using the old RMA program?

Those go into the Quotes table, status Y

that's BKESTQT.Bnn

Sorry!

Title: Re: rma field names for crystal
Post by gtladmin on 01/29/08 at 15:45:36

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

Title: Re: rma field names for crystal
Post by gtladmin on 01/29/08 at 16:04:36

Colin,

OK, so I see the data in the quotes table, but no "status" field. In fact when I look at the properties of the table for the field names and indexes, they all are bkar_inv, not BK_ESTQT. I don't see anything in the data that looks like the stuff they are entering in the RMAs (like reason for return, etc.). So what'd you think is up with that?

Lynn, any ideas?

Val

Title: Re: rma field names for crystal
Post by gtladmin on 01/30/08 at 09:02:28

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

Title: Re: rma field names for crystal
Post by GasGiant on 01/30/08 at 10:07:06

As I said, the headers are mixed in with the quote headers. The status field is BKAR_INV_INVCD. Open RMAs have a "Y", but closed have an "X", just like the quotes. Our quote are in a different number range, so I can cull them that way.

BKESTQTL has the lines that go with the headers.

As for the reasons, etc., that is hashed into the BKAR_INV_EXTRA field in BKESTQT. Looks rather ugly, but it must be placed based on character spacing.

Actually, it looks like closed RMAs go poof! out of this table, so I don't know what the X means :(

Title: Re: rma field names for crystal
Post by gtladmin on 01/30/08 at 10:41:46

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

Title: Re: rma field names for crystal
Post by GasGiant on 01/30/08 at 11:21:23

Well, I am happy to report that the new RMA module, written by ISTech, is quite good. In the new module each line gets a status, a reason, a disposition, etc. and the info is in ISRMAI.Bnn and easy to follow.

Title: Re: rma field names for crystal
Post by NovaZyg on 01/30/08 at 11:29:41

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...

Title: Re: rma field names for crystal
Post by NovaZyg on 01/30/08 at 14:39:46

Val,

OLD RMA Specs: from the code.

; place ORIG SO ORGSON IN BKAR.INV.EXTRA 90,6
; place ORIG INV ORGINV IN BKAR.INV.EXTRA 105,6
; place REORDER YN RORDYN IN BKAR.INV.EXTRA 115,1
; place REASON FOR RMARES IN BKAR.INV.EXTRA 116,35

define ORGSON type a size 6 ; IN BKAR.INV.EXTRA 90,6
define ORGINV type a size 6 ; IN BKAR.INV.EXTRA 105,6
define ORGSONN type n size 6 ; IN BKAR.INV.EXTRA 90,6
define ORGINVN type n size 6 ; IN BKAR.INV.EXTRA 105,6
define REOSO type n size 6 ; ; reoso=mid(bkar.inv.extra,77,6)
define CRMSO type n size 6 ; ; crmso=mid(bkar.inv.extra,84,6)
define RORDYN type a size 1 ; IN BKAR.INV.EXTRA 115,1
define RMARES type a size 35 ; IN BKAR.INV.EXTRA 116,35

RMA files are BKESTQT for the Header, and BKESTQTL for the Line items
That is also the Quote file so to distinguish between and RMA and a quote, BKAR.INV.EXTRA position 83 = "R" for RMA and " " for Quote. Bkar.inv.invcd = 'Y' means it is invoiced and closed, Blank or 'X' means it is still open.

Like I said I did not write it.. I'm just telling you how it works.
:-[

Allen

Title: Re: rma field names for crystal
Post by gtladmin on 01/30/08 at 16:04:20

Thanks, Allen. I did an initial data extract and we'll be culling through it. So far it looks like we have some stuff to work with. I GREATLY appreciate your help here!

Colin, I have everyone ready to put off the old system and use the new one so we won't have this issue going forward. Thanks agian!

Val

Title: Re: rma field names for crystal
Post by dameng on 02/11/08 at 20:20:43

Val,
i hope your company starts using the New RMA module. as Allen noted. if you want some help with your original data. let me know.

Dave