Memos in Order Entry - Vantage 8.03

Yahoo Archive
1
Thank you Rob, I'll give it a try. I'm going to go back into some of
the customizations that I've done and apply your little "wrapping" trick
to see if it will fix some of the problems that we are having.



Regards,

Linda Lowney

Pride Signs



[Non-text portions of this message have been removed]
2
Hi Group,

Does anyone know of a way to customize order entry to show a text box
that indicates if a memo exists?

Regards,
Linda Lowney
Pride Signs
3
I'm not sure where this memo is, are you referring to the sales order comment?

Thanks,
Kunal



----- Original Message ----
From: lindalowney <llowney@...>
To: vantage@yahoogroups.com
Sent: Tuesday, June 3, 2008 1:21:54 PM
Subject: [Vantage] Memos in Order Entry - Vantage 8.03


Hi Group,

Does anyone know of a way to customize order entry to show a text box
that indicates if a memo exists?

Regards,
Linda Lowney
Pride Signs






[Non-text portions of this message have been removed]
4
The memos themselves reside in a table called memo ( assuming you are
using sql - I don't know about progress. ). There is also another
table called memocat which holds memo categories. I would suspect
that you could write a small customisation to your form which runs a
VB script from within one of the forms load or startup events to
query the memo table and return a dataset containing the associated
memos. You could then use this to set a logical checkbox on the form
to indicate if there are memos present. Why would you want to use a
textbox ? Do you want to show the memo data directly on the form ?

--- In vantage@yahoogroups.com, Kunal Ganguly <kunal_vantage@...>
wrote:
>
> I'm not sure where this memo is, are you referring to the sales
order comment?
>
> Thanks,
> Kunal
>
>
>
> ----- Original Message ----
> From: lindalowney <llowney@...>
> To: vantage@yahoogroups.com
> Sent: Tuesday, June 3, 2008 1:21:54 PM
> Subject: [Vantage] Memos in Order Entry - Vantage 8.03
>
>
> Hi Group,
>
> Does anyone know of a way to customize order entry to show a text
box
> that indicates if a memo exists?
>
> Regards,
> Linda Lowney
> Pride Signs
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
Create a function to do a search by id of the memo table. Have it return a true or false value (true if a memo exists).
Â
Add a custom text field and associated it with a ud checkbox field. Give it a label "memo exists?".
Â
Use an epinotification event trigger to fire off a subroutine when the order number changes. Within this sub, call your function.
Â
If you want to get fancy, use the row rule wizard to test if your ud checkbox field value is true or false (text - not boolean) and, if true, perhaps highlight the control's text.
Â
If epinotification is an unreliable event trigger (and they often are) add another custom text box (linked to ordernum) to your form (invisible - and drag it off screen).
Â
Then use the form wizard to create a sub that fires off when that text value (hanges and imbed your function call in there instead.
Â
A little trick (to prevent run time errors) is to wrap your function call from inside an if statement that only executes if len(customtextbox.text) <> 0.
Â
Without that, clearing the screen (or simply changing records in a selected list) will often kick out a cascade of errors as you will otherwise be firing off your function when no record is loaded (row = -1).
Â
If there is no search by ID method for memos (I don't recall), you might be able to use the same custom text box trick above to create sub that sets a declared boolean variable to true if the length of the associated memo < 0. This can replace your search by ID function (or you can turn it into a function by declaring it as such). The ud checkbox field would then be set the variables value.
Â
Get yourself the technical users guide... Well worth the money (even if though they were epicor normal lazy and did not include an index to save you from leafing through several hundred pages to find pertinent code examples for what you are attempting).
Â
Good luck
Â
Rob Brown
Â
Rob Brown.

--- On Tue, 6/3/08, lindalowney <llowney@...> wrote:

From: lindalowney <llowney@...>
Subject: [Vantage] Memos in Order Entry - Vantage 8.03
To: vantage@yahoogroups.com
Date: Tuesday, June 3, 2008, 2:21 PM






Hi Group,

Does anyone know of a way to customize order entry to show a text box
that indicates if a memo exists?

Regards,
Linda Lowney
Pride Signs
6
I want to add a text box just to notify the user that there is an
existing memo attached to the order. Back in a previous version there
was a way to tell if there was a memo by looking at the memo icon.



Linda



[Non-text portions of this message have been removed]