Total Line Weights To Display on Quote/Order Entry Screens

Yahoo Archive
1
Hi - Thanks for your help.

It seems all well and good, but we are just staritng out with Vantage and it all seems a little over our heads.

Does anyone have a step by step guide on how to do this in Vantage? I need the weights on the Quote Entry and Order Entry screen.

I then need to take the field and add it to the Crystal report for Invoice, Quote etc.

Wouldn't you have thought that vantage would do this already?

I'm about to post another topic of how we can get the Customer Ship To address displaying on Crystal for a Quote.

Thanks,


CHRIS THOMPSON




________________________________
From: Tony Hughes <thughes281@...>
To: vantage@yahoogroups.com
Sent: Thursday, October 30, 2008 5:59:19 PM
Subject: Re: [Vantage] Re: Total Line Weights To Display on Quote/Order Entry Screens


I use a subreport that pulls weight and dimensions from part master, main report stores the return weight in a variable.

Tony

____________ _________ _________ __
From: Michael McWilliams <mmcwilliams22@ yahoo.com>
To: vantage@yahoogroups .com
Sent: Thursday, October 30, 2008 12:50:03 PM
Subject: [Vantage] Re: Total Line Weights To Display on Quote/Order Entry Screens

Here is we do. When the quantity field is validated it multiplies
it by the part.netweight. You will need to create a foreign key
fiew for this to the part table. It then saves it on the line and
also on the header. If they create another line it does the same
thing but then it adds the second amount to the header and saves
that new value. We do this both on the quote and order.

--- In vantage@yahoogroups .com, "robert.nupp" <robert.nupp@ ...>
wrote:
>
>
> Did you end up getting any response on this? We are in the
process of
> doing the same thing. Thanks
>
> Robert Nupp
> Laclede Chain Manufacturing Co.
>
>
> --- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ >
wrote:
> >
> > My company has a requirement to display the total line weight and
> then a total order weight on the Quote/Opportunity Entry and Sales
> Order Entry screens.
> >
> > In theory, it sounds easy:
> >
> > Take the Part.NetWeight figure, and multiply it by the Line Qty
figure.
> >
> > Then have a box on the page that is the sum of all of the line
totals.
> >
> > Has anyone done anything similar to this or does anyone know
where
> to start?
> >
> > We are new at all this and need it in place before going live.
> >
> > Thanks,
> >
> >
> >
> > CHRIS THOMPSON
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

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






[Non-text portions of this message have been removed]
2
My company has a requirement to display the total line weight and then a total order weight on the Quote/Opportunity Entry and Sales Order Entry screens.
Â
In theory, it sounds easy:
Â
Take the Part.NetWeight figure, and multiply it by the Line Qty figure.
Â
Then have a box on the page that is the sum of all of the line totals.
Â
Has anyone done anything similar to this or does anyone know where to start?
Â
We are new at all this and need it in place before going live.
Â
Thanks,
Â
Â

CHRIS THOMPSON




[Non-text portions of this message have been removed]
3
Did you end up getting any response on this? We are in the process of
doing the same thing. Thanks

Robert Nupp
Laclede Chain Manufacturing Co.


--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...> wrote:
>
> My company has a requirement to display the total line weight and
then a total order weight on the Quote/Opportunity Entry and Sales
Order Entry screens.
> Â
> In theory, it sounds easy:
> Â
> Take the Part.NetWeight figure, and multiply it by the Line Qty figure.
> Â
> Then have a box on the page that is the sum of all of the line totals.
> Â
> Has anyone done anything similar to this or does anyone know where
to start?
> Â
> We are new at all this and need it in place before going live.
> Â
> Thanks,
> Â
> Â
>
> CHRIS THOMPSON
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
Here is we do. When the quantity field is validated it multiplies
it by the part.netweight. You will need to create a foreign key
fiew for this to the part table. It then saves it on the line and
also on the header. If they create another line it does the same
thing but then it adds the second amount to the header and saves
that new value. We do this both on the quote and order.

--- In vantage@yahoogroups.com, "robert.nupp" <robert.nupp@...>
wrote:
>
>
> Did you end up getting any response on this? We are in the
process of
> doing the same thing. Thanks
>
> Robert Nupp
> Laclede Chain Manufacturing Co.
>
>
> --- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@>
wrote:
> >
> > My company has a requirement to display the total line weight and
> then a total order weight on the Quote/Opportunity Entry and Sales
> Order Entry screens.
> > Â
> > In theory, it sounds easy:
> > Â
> > Take the Part.NetWeight figure, and multiply it by the Line Qty
figure.
> > Â
> > Then have a box on the page that is the sum of all of the line
totals.
> > Â
> > Has anyone done anything similar to this or does anyone know
where
> to start?
> > Â
> > We are new at all this and need it in place before going live.
> > Â
> > Thanks,
> > Â
> > Â
> >
> > CHRIS THOMPSON
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
5
I use a subreport that pulls weight and dimensions from part master, main report stores the return weight in a variable.

Tony




________________________________
From: Michael McWilliams <mmcwilliams22@...>
To: vantage@yahoogroups.com
Sent: Thursday, October 30, 2008 12:50:03 PM
Subject: [Vantage] Re: Total Line Weights To Display on Quote/Order Entry Screens


Here is we do. When the quantity field is validated it multiplies
it by the part.netweight. You will need to create a foreign key
fiew for this to the part table. It then saves it on the line and
also on the header. If they create another line it does the same
thing but then it adds the second amount to the header and saves
that new value. We do this both on the quote and order.

--- In vantage@yahoogroups .com, "robert.nupp" <robert.nupp@ ...>
wrote:
>
>
> Did you end up getting any response on this? We are in the
process of
> doing the same thing. Thanks
>
> Robert Nupp
> Laclede Chain Manufacturing Co.
>
>
> --- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ >
wrote:
> >
> > My company has a requirement to display the total line weight and
> then a total order weight on the Quote/Opportunity Entry and Sales
> Order Entry screens.
> >
> > In theory, it sounds easy:
> >
> > Take the Part.NetWeight figure, and multiply it by the Line Qty
figure.
> >
> > Then have a box on the page that is the sum of all of the line
totals.
> >
> > Has anyone done anything similar to this or does anyone know
where
> to start?
> >
> > We are new at all this and need it in place before going live.
> >
> > Thanks,
> >
> >
> >
> > CHRIS THOMPSON
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>






[Non-text portions of this message have been removed]
6
I sent the other person a customization that will do this If you
want I can send you it also. I am on 403c Or I can just post the
code if you would like.
--- In vantage@yahoogroups.com, "robert.nupp" <robert.nupp@...>
wrote:
>
>
> Did you end up getting any response on this? We are in the
process of
> doing the same thing. Thanks
>
> Robert Nupp
> Laclede Chain Manufacturing Co.
>
>
> --- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@>
wrote:
> >
> > My company has a requirement to display the total line weight and
> then a total order weight on the Quote/Opportunity Entry and Sales
> Order Entry screens.
> > Â
> > In theory, it sounds easy:
> > Â
> > Take the Part.NetWeight figure, and multiply it by the Line Qty
figure.
> > Â
> > Then have a box on the page that is the sum of all of the line
totals.
> > Â
> > Has anyone done anything similar to this or does anyone know
where
> to start?
> > Â
> > We are new at all this and need it in place before going live.
> > Â
> > Thanks,
> > Â
> > Â
> >
> > CHRIS THOMPSON
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>