sorry just had another issue on this: - Is it possible to reverse this action:
So if the user enters details into the comments text box and checks a box within the sales order screen it then updates/overwrites the Customer character06 text (the default).
I'm not sure if its possible?
Rupert
So if the user enters details into the comments text box and checks a box within the sales order screen it then updates/overwrites the Customer character06 text (the default).
I'm not sure if its possible?
Rupert
--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Yeah man remember to Always add company (even if you only have one) and to
> over state the same thing in 5 different emails while being utterly helpful
> ;)
>
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
>
> On Thu, Aug 19, 2010 at 2:24 PM, Sean McDaniel <
> smcdaniel@...> wrote:
>
> >
> >
> > I'd say that despite only having one company you should ALWAYS include
> > the company.
> > I came across a dashboard that had a query that never returned. Added in
> > the company and it returned in a second or two.
> >
> >
> > From: vantage@yahoogroups.com <vantage%40yahoogroups.com> [mailto:
> > vantage@yahoogroups.com <vantage%40yahoogroups.com>] On Behalf
> > Of Brian W. Spolarich
> > Sent: Thursday, August 19, 2010 12:58 PM
> >
> > To: vantage@yahoogroups.com <vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] BPM Pass customer details directly into sales
> > order header
> >
> > Agreed. If you only have one Company your BPMs/queries/etc. will
> > work. When you add Company #2 things will suddenly stop working or will
> > return strange results and you won't know why.
> >
> > I always have my BAQs return Company from the primary/starting table.
> >
> > -bws
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <vantage%40yahoogroups.com> <mailto:
> > vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> > [mailto:vantage@yahoogroups.com <vantage%40yahoogroups.com> <mailto:
> > vantage%40yahoogroups.com <vantage%2540yahoogroups.com>> ] On
> > Behalf
> > Of Kevin Simon
> > Sent: Thursday, August 19, 2010 12:52 PM
> > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <mailto:
> > vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> > Subject: RE: [Vantage] BPM Pass customer details directly into sales
> > order header
> >
> > Minor technicalities: You should always include the company when reading
> > tables, and you may want to match customer and OrderHed by CustNum, not
> > CustID. Your "Find First" line would then be:
> >
> > find first Customer where Customer.Company = ttOrderHed.Company AND
> > Customer.CustNum=ttOrderHed.CustomerCustNum
> > no-error.
> >
> > Kevin Simon
> > SimsTrak Consulting
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <vantage%40yahoogroups.com> <mailto:
> > vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> > [mailto:vantage@yahoogroups.com <vantage%40yahoogroups.com> <mailto:
> > vantage%40yahoogroups.com <vantage%2540yahoogroups.com>> ] On
> > Behalf
> > Of
> > Jose Gomez
> > Sent: Thursday, August 19, 2010 10:36 AM
> > To: vantage@yahoogroups.com <vantage%40yahoogroups.com> <mailto:
> > vantage%40yahoogroups.com <vantage%2540yahoogroups.com>>
> > Subject: Re: [Vantage] BPM Pass customer details directly into sales
> > order
> > header
> >
> > Try this on Order Udpate
> >
> > for each ttOrderHed.
> > find first Customer where Customer.CustID=ttOrderHed.CustomerCustID
> > no-error.
> > if (available Customer and Customer.Character06 <> '') then
> > do:
> > Assign ttOrderHed.ShipComment=Customer.Character06.
> > end.
> > end.
> >
> > Sincerely
> > Jose C Gomez
> >
> > http://www.josecgomez.com
> >
> > On Thu, Aug 19, 2010 at 10:19 AM, Rupert <r.oo@...<r.oo%40firenet.uk.net>
> > <mailto:r.oo%40firenet.uk.net <r.oo%2540firenet.uk.net>> > wrote:
> >
> > >
> > >
> > > Hi Guys,
> > > (408)
> > > I'm looking to pass a static txt field [customer.character06] into the
> > > orderhed.shipcomment field if it exists.
> > >
> > > This will save the data entry team a lot of time. So far I've written
> > this
> > > in a orderhed.update BPM
> > >
> > > find first Customer where Customer.CustID = ttOrderHed.CustomerCustID
> > > no-error.
> > > if available Customer then
> > > do:
> > > if(Customer.Character06 <> '') then
> > > do:
> > > for each ttOrderHed.
> > > Assign ttOrderHed.shipcomment=Customer.Character06.
> > > end.
> > > end.
> > > end.
> > >
> > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > have
> > already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
> > and
> > Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > <http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > <http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>