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