PO Entry Comment Field

Yahoo Archive
1
Did you ever find a way to join the customer to the memo?




--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> ChangeLogs are the same way. Vantage stores the identifiers for the
> related record as a string in field Key1.
>
>
>
> However I've discovered that you can't write a BAQ that joins say
> Customer to ChangeLog or Memo because the customer identifier in
> Customer is CustNum, which is an integer, and Memo/ChangeLog.Key1 is a
> string. The BAQ will return null.
>
>
>
> Anyone know how to work around this type mismatch issue?
>
>
>
> -bws
>
>
>
> --
>
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
> Picometrix
>
> bspolarich@... ~ 734-864-5618 ~
> www.advancedphotonix.com
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of bpbuechler
> Sent: Monday, February 02, 2009 3:33 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: PO Entry Comment Field
>
>
>
> Have you considered using Memos instead?
>
> You can add memos to a variety of records in Vantage even after the
> record is closed.
>
> Depending upon your use of this information, then you can write a
> baq/dashboard/crystal report and collect the memo contents. Just
> know that Memos are a table on their own, so you do have to specify
> the Related to File and Key1 to find the memo attached to the
> specific record.
>
> Thanks
> Patty Buechler
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Vic
> Drecchio" <vic.drecchio@>
> wrote:
> >
> > Hey gang, anybody have any ideas?
> >
> >
> >
> > I need to create a comments field on PO Entry. Now, I know there's
> > already a tab for this on PO Entry Header.
> >
> >
> >
> > That field will be fine.
> >
> >
> >
> > My challenge is I need this field to be enabled and updateable no
> matter
> > the status of the PO. Once the PO has been Closed, the Vantage
> business
> > logic locks all fields down.
> >
> >
> >
> > Has anyone been successful in defeating the Vantage business logic
> in
> > this fashion?
> >
> >
> >
> > Thank you very much!
> >
> >
> >
> >
> >
> >
> >
> > Vic
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
Hey gang, anybody have any ideas?



I need to create a comments field on PO Entry. Now, I know there's
already a tab for this on PO Entry Header.



That field will be fine.



My challenge is I need this field to be enabled and updateable no matter
the status of the PO. Once the PO has been Closed, the Vantage business
logic locks all fields down.



Has anyone been successful in defeating the Vantage business logic in
this fashion?



Thank you very much!







Vic





[Non-text portions of this message have been removed]
3
Have you considered using Memos instead?

You can add memos to a variety of records in Vantage even after the
record is closed.

Depending upon your use of this information, then you can write a
baq/dashboard/crystal report and collect the memo contents. Just
know that Memos are a table on their own, so you do have to specify
the Related to File and Key1 to find the memo attached to the
specific record.

Thanks
Patty Buechler

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...>
wrote:
>
> Hey gang, anybody have any ideas?
>
>
>
> I need to create a comments field on PO Entry. Now, I know there's
> already a tab for this on PO Entry Header.
>
>
>
> That field will be fine.
>
>
>
> My challenge is I need this field to be enabled and updateable no
matter
> the status of the PO. Once the PO has been Closed, the Vantage
business
> logic locks all fields down.
>
>
>
> Has anyone been successful in defeating the Vantage business logic
in
> this fashion?
>
>
>
> Thank you very much!
>
>
>
>
>
>
>
> Vic
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
ChangeLogs are the same way. Vantage stores the identifiers for the
related record as a string in field Key1.



However I've discovered that you can't write a BAQ that joins say
Customer to ChangeLog or Memo because the customer identifier in
Customer is CustNum, which is an integer, and Memo/ChangeLog.Key1 is a
string. The BAQ will return null.



Anyone know how to work around this type mismatch issue?



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bpbuechler
Sent: Monday, February 02, 2009 3:33 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: PO Entry Comment Field



Have you considered using Memos instead?

You can add memos to a variety of records in Vantage even after the
record is closed.

Depending upon your use of this information, then you can write a
baq/dashboard/crystal report and collect the memo contents. Just
know that Memos are a table on their own, so you do have to specify
the Related to File and Key1 to find the memo attached to the
specific record.

Thanks
Patty Buechler

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Vic
Drecchio" <vic.drecchio@...>
wrote:
>
> Hey gang, anybody have any ideas?
>
>
>
> I need to create a comments field on PO Entry. Now, I know there's
> already a tab for this on PO Entry Header.
>
>
>
> That field will be fine.
>
>
>
> My challenge is I need this field to be enabled and updateable no
matter
> the status of the PO. Once the PO has been Closed, the Vantage
business
> logic locks all fields down.
>
>
>
> Has anyone been successful in defeating the Vantage business logic
in
> this fashion?
>
>
>
> Thank you very much!
>
>
>
>
>
>
>
> Vic
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
5
Thank you Patty.

That's a great idea and I thought of that a while ago but the Purchasing
Dept rebutted that idea and said "How will we know there is a Memo upon
opening or viewing the PO Entry Screen?"

Perhaps I could put a customization on the screen that checks for any
memo's....


Thank you very much!

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bpbuechler
Sent: Monday, February 02, 2009 3:33 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: PO Entry Comment Field

Have you considered using Memos instead?

You can add memos to a variety of records in Vantage even after the
record is closed.

Depending upon your use of this information, then you can write a
baq/dashboard/crystal report and collect the memo contents. Just
know that Memos are a table on their own, so you do have to specify
the Related to File and Key1 to find the memo attached to the
specific record.

Thanks
Patty Buechler

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...>
wrote:
>
> Hey gang, anybody have any ideas?
>
>
>
> I need to create a comments field on PO Entry. Now, I know there's
> already a tab for this on PO Entry Header.
>
>
>
> That field will be fine.
>
>
>
> My challenge is I need this field to be enabled and updateable no
matter
> the status of the PO. Once the PO has been Closed, the Vantage
business
> logic locks all fields down.
>
>
>
> Has anyone been successful in defeating the Vantage business logic
in
> this fashion?
>
>
>
> Thank you very much!
>
>
>
>
>
>
>
> Vic
>
>
>
>
>
> [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/.
(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