PoRel to TranGLC in BAQ

Haha, I love it when it's a simple answer

LIttle help.  Why do you think I am not picking up the GL Account on the PO Release.  I thought I had all the keys correct.

 

for each PORel no-lock  where  PORel.PONum = 148258  ,  each TranGLC no-lock  outer-join where (PORel.Company = TranGLC.Company and PORel.PONum = TranGLC.Key1 and PORel.POLine = TranGLC.Key2 and PORel.PORelNum = TranGLC.Key3 ) and  TranGLC.RelatedToFile = 'orderrel' .

 

 

Miguel A. Santillan

ERP Analyst

Compass Manufacturing Systems

510-661-6666  Office

510-656-0603  Fax

msantillan@...

 

Try it with RelatedToFile = 'PORel' instead of orderrel

yes..thank you….

 

After re-reading the query myself a few times, AGAIN.  I just said…ahhh you dumb f#$% Miguel. Thanks.

 

Miguel A. Santillan

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of aj.rembert@...
Sent: Tuesday, February 04, 2014 10:08 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: PoRel to TranGLC in BAQ

 

 

Try it with RelatedToFile = 'PORel' instead of orderrel