Can anybody point me in the right direction on this? It seems to be checking whether or not the GL code is there fine but when throwing the exception it then won't allow me to create a new GL code.
--- In vantage@yahoogroups.com, "jeff" <jpurvis00@...> wrote:
>
> So I changed it to the following:
>
> for each Customer no-lock , each EntityGLC no-lock outer-join where (String(Customer.CustNum) = EntityGLC.Key1 and EntityGLC.GLControlCode = "" )
>
> Added that to "number of rows in the 'temp' query is less than 1" and am raising an exception. This seems to work fine but then when I try and do "New GL control" it just raises my exception again and won't let me complete the adding of a new GL code. What am I doing wrong?
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> >
> > STRING(Customer.CustNum)=Table.Key1
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> > On Mon, Jun 3, 2013 at 1:54 PM, jeff <jpurvis00@> wrote:
> >
> > > **
> > >
> > >
> > > I'm not the greatest at queries but I did the following in a BAQ and found
> > > the customer and their GL values. If I try to use that in my BPM I get a
> > > "Incompatible data types" error. I guess that's because CustNum is an
> > > Integer and Key1 is a character? Is there a way around that?
> > >
> > > for each Customer no-lock , each EntityGLC no-lock outer-join where
> > > (Customer.CustNum = EntityGLC.Key1
> > >
> > > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > > >
> > > > You can do a BPM and on Customer Update PreProc check that they have a GL
> > > > Assinged if not dont' alloow to save
> > > >
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *
> > > > *
> > > > *T: 904.469.1524 mobile
> > > > E: jose@
> > > > http://www.josecgomez.com
> > > > <http://www.linkedin.com/in/josecgomez> <
> > > http://www.facebook.com/josegomez>
> > > > <http://www.google.com/profiles/jose.gomez> <
> > > http://www.twitter.com/joc85>
> > > > <http://www.josecgomez.com/professional-resume/>
> > > > <http://www.josecgomez.com/feed/>
> > > > <http://www.usdoingstuff.com>
> > > >
> > > > *Quis custodiet ipsos custodes?*
> > > >
> > > >
> > > > On Mon, Jun 3, 2013 at 11:14 AM, jeff <jpurvis00@> wrote:
> > > >
> > > > > **
> > >
> > > > >
> > > > >
> > > > > We are going to be tracking our sales through three different customer
> > > > > groups which will require all our customer's being assigned a GL
> > > control.
> > > > > What's the best way to enforce our user's to assign a GL code during
> > > > > initial customer creation? I thought I could do a BPM but the GL
> > > control
> > > > > tab is not active without the user clicking on "New GL Control".
> > > Thanks for
> > > > > any direction.
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>