RMA reject to DMR ver 8.03.400

Yahoo Archive
1
Thanks! That was the link I was looking for.

Steve


-----Original Message-----
From: Steven Gotschall [mailto:sgotschall@...]
Sent: December 01, 2009 8:30 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RMA reject to DMR ver 8.03.400




Not sure if this will help you, but I have a BAQ that relates the RMA number
to the DMR number. The table relationship goes in this order:
RMARcpt
RMADisp
NonConf
Reason

RMARcpt.RMAnum is the RMA number and NonConf.DMRNum is the DMR number. The
BAQ looks like this:

for each RMARcpt no-lock , each RMADisp where (RMARcpt.Company =
RMADisp.Company and RMARcpt.RMANum = RMADisp.RMANum and RMARcpt.RMALine =
RMADisp.RMALine and RMARcpt.RMAReceipt = RMADisp.RMAReceipt) no-lock , each
NonConf where (RMADisp.Company = NonConf.Company and RMADisp.RMANum =
NonConf.RMANum and RMADisp.RMALine = NonConf.RMALine and RMADisp.RMAReceipt
= NonConf.RMAReceipt and RMADisp.RMADisp = NonConf.RMADisp) no-lock , each
Reason where ( Reason.ReasonType = 'D') and (NonConf.ReasonCode =
Reason.ReasonCode) no-lock .

This particular BAQ is for DMR Dispositions, so I filter it by
Reason.ReasonType = 'D'.

________________________________
From: vantage03 <vantage@rmgfelm. <mailto:vantage%40rmgfelm.com> com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Tue, December 1, 2009 9:09:10 AM
Subject: [Vantage] RMA reject to DMR ver 8.03.400


Is there any place the the system links RMA reject to the DMR. IE.. RMA
number to DMR number?

Thanks

Steve

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
2
Is there any place the the system links RMA reject to the DMR. IE.. RMA number to DMR number?

Thanks

Steve
3
Not sure if this will help you, but I have a BAQ that relates the RMA number to the DMR number. The table relationship goes in this order:
RMARcpt
RMADisp
NonConf
Reason

RMARcpt.RMAnum is the RMA number and NonConf.DMRNum is the DMR number. The BAQ looks like this:

for each RMARcpt no-lock , each RMADisp where (RMARcpt.Company = RMADisp.Company and RMARcpt.RMANum = RMADisp.RMANum and RMARcpt.RMALine = RMADisp.RMALine and RMARcpt.RMAReceipt = RMADisp.RMAReceipt) no-lock , each NonConf where (RMADisp.Company = NonConf.Company and RMADisp.RMANum = NonConf.RMANum and RMADisp.RMALine = NonConf.RMALine and RMADisp.RMAReceipt = NonConf.RMAReceipt and RMADisp.RMADisp = NonConf.RMADisp) no-lock , each Reason where (Â Reason.ReasonType = 'D') and (NonConf.ReasonCode = Reason.ReasonCode) no-lock .

This particular BAQ is for DMR Dispositions, so I filter it by Reason.ReasonType = 'D'.


________________________________
From: vantage03 <vantage@...>
To: vantage@yahoogroups.com
Sent: Tue, December 1, 2009 9:09:10 AM
Subject: [Vantage] RMA reject to DMR ver 8.03.400

Â
Is there any place the the system links RMA reject to the DMR. IE.. RMA number to DMR number?

Thanks

Steve







[Non-text portions of this message have been removed]