Welcome, Guest. Please Login.
05/17/25 at 18:37:16
News:
Home Help Search Login


Pages: 1 2 
Send Topic Print
rma field names for crystal (Read 2179 times)
NovaZyg
Administrator
*****


When all else
fails.. Read the
instructions.

Posts: 789
Gender: male
Re: rma field names for crystal
Reply #15 - 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.
 embarrassed
 
Allen  
 
 
Back to top
 
 

Allen Landry
Evo~ERP

EvoERP and DBA Classic always Beta's of the Latest versions.

WWW   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: rma field names for crystal
Reply #16 - 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
Back to top
 
 

Val Feehan
  IP Logged
dameng
Senior Member
****


DBA / EVO Software
Consultant

Posts: 275
Gender: male
Re: rma field names for crystal
Reply #17 - 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
Back to top
 
 

Dave Mengelkamp
Digital Consulting
760.832.2536
davemeng@earthlink.net
Email WWW   IP Logged
Pages: 1 2 
Send Topic Print