Custom Field: Sum of Product Shipped?

Yahoo Archive
1
After some more research, it appears that in order to get this total, I need to create a calculation that multiplies the ship qty from the customer shipment by the unit price of that line on the sales order. For the sum of all items in this shipment, I would have to do this for each line.

In order to place this information on the Customer Shipment screen, I would need to add the appropriate Order tables and then create the custom calculation. I can conceptualize what needs to be done; however, am not familiar with the code/operations that need to be done to do this. Any suggestions are appreciated. Thank you.


--- In vantage@yahoogroups.com, "pbriscoe10" <pbriscoe10@...> wrote:
>
> Hello,
>
> I was wondering if I could get some help creating the following field: a user defined field (calculated) to appear on the Customer shipment screen that will populate with the total value of product being shipped. Any help is appreciated. Thank you.
>
2
Hello,

I was wondering if I could get some help creating the following field: a user defined field (calculated) to appear on the Customer shipment screen that will populate with the total value of product being shipped. Any help is appreciated. Thank you.
3
How do you make a created option field mandatory on a BAQ Report Paramter
Screen?

Thanks in advance


[Non-text portions of this message have been removed]
4
For simplicity's sake, Id just design the parameter into the crystal
report itself, if they don't fill out the parameter, they won't get any
data, that should make it fairly self fulfilling.

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of advantage
Sent: Monday, November 30, 2009 8:21 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Make a field mandatory on a BAQ Report Parameter
Screen





How do you make a created option field mandatory on a BAQ Report
Paramter
Screen?

Thanks in advance

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





[Non-text portions of this message have been removed]
5
Any ideas on this? Your help is appreciated. Thank you.

--- In vantage@yahoogroups.com, "pbriscoe10" <pbriscoe10@...> wrote:
>
> Hello,
>
> I was wondering if I could get some help creating the following field: a user defined field (calculated) to appear on the Customer shipment screen that will populate with the total value of product being shipped. Any help is appreciated. Thank you.
>
6
Ok, I have figured that no you cannot write a BPM on BAQ Report Parameter
screens. So I tried to shortcut it in the BAQReport Designer under the
options field default, I put "Job Required" then I wrote a customization on
the Report Parameter screen (PS: I'm not a coder by any means, so please
help:)
I was curious what is the code for it to look at that "Job Required" text in
ReportParam.Character01 and pop up a message box that tells the end user
"Job Required"....

I picked through the wizard Form Event Wizard Before Field Changes

I have this so far.
Private Sub BAQReportParam_BeforeFieldChange(ByVal sender As object, ByVal
args As DataColumnChangeEventArgs) Handles BAQReportParam_ColumnChanging
Select Case args.Column.ColumnName
Case "Character01"
Dim Message As String = "Job Number Required.Cancel this operation?"

Dim Caption As String = "Job Number Required"

Dim Buttons As Integer = MessageBoxButtons.YesNo

Dim Result As DialogResult

If (args.proposedvalue.ToString().Length > 13) Then

Result = messagebox.show(Message, Caption, MessageBoxButtons.YesNo, _

MessageBoxIcon.Question, MessageBoxDefaultButton.Button1, _

MessageBoxOptions.RightAlign)

End If

If Result = DialogResult.Yes Then

oTrans.Undo

Throw new UIException

End If



Thanks in advance

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
advantage
Sent: Monday, November 30, 2009 9:21 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Make a field mandatory on a BAQ Report Parameter Screen




How do you make a created option field mandatory on a BAQ Report Paramter
Screen?

Thanks in advance

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







[Non-text portions of this message have been removed]
7
I think the potential trouble there is if they don't attempt to make any
changes at all? To be most reliable youd have to trigger off of an
attempt to print or preview... as to how to intercept an action from
the menu items or the buttons...im clueless..



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of advantage
Sent: Monday, November 30, 2009 2:53 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Make a field mandatory on a BAQ Report Parameter
Screen





Ok, I have figured that no you cannot write a BPM on BAQ Report
Parameter
screens. So I tried to shortcut it in the BAQReport Designer under the
options field default, I put "Job Required" then I wrote a customization
on
the Report Parameter screen (PS: I'm not a coder by any means, so please
help:)
I was curious what is the code for it to look at that "Job Required"
text in
ReportParam.Character01 and pop up a message box that tells the end user
"Job Required"....

I picked through the wizard Form Event Wizard Before Field Changes

I have this so far.
Private Sub BAQReportParam_BeforeFieldChange(ByVal sender As object,
ByVal
args As DataColumnChangeEventArgs) Handles BAQReportParam_ColumnChanging
Select Case args.Column.ColumnName
Case "Character01"
Dim Message As String = "Job Number Required.Cancel this operation?"

Dim Caption As String = "Job Number Required"

Dim Buttons As Integer = MessageBoxButtons.YesNo

Dim Result As DialogResult

If (args.proposedvalue.ToString().Length > 13) Then

Result = messagebox.show(Message, Caption, MessageBoxButtons.YesNo, _

MessageBoxIcon.Question, MessageBoxDefaultButton.Button1, _

MessageBoxOptions.RightAlign)

End If

If Result = DialogResult.Yes Then

oTrans.Undo

Throw new UIException

End If

Thanks in advance

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
advantage
Sent: Monday, November 30, 2009 9:21 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Make a field mandatory on a BAQ Report Parameter
Screen

How do you make a created option field mandatory on a BAQ Report
Paramter
Screen?

Thanks in advance

[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]