Create Field to report on a BAQ

Yahoo Archive
1
Wow, that is simple enough. Thanks a lot. Didn't even notice that button there. I was just a button away.

--- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:
>
> In the BAQ Designer, click the little button with a strange picture and a tooltip of “Show User Defined Fields”, usually to the right of the A->Z sort button. Otherwise the designer hides all the CheckBox01 etc fields on you.
>
>
>
> Brian.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Drew
> Sent: Tuesday, April 17, 2012 4:53 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Create Field to report on a BAQ
>
>
>
>
>
> Thanks for the reply. I did select "Part.CheckBox01" on the EpiBinding row, but when I pull "Part" into my BAQ, it does not have a checkbox01 column to select. Do I have to make it visible somewhere else?
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Vic Drecchio" <vic.drecchio@> wrote:
> >
> > Andrew,
> >
> > If you bound your control within Customization to a table’s field, then that’s all you need. That value will now update Part.Checkbox01 (assuming you selected that field when you customized your form).
> >
> > Then, simply create a BAQ or modify other Report Data Def’s to include your field in various reports.
> >
> >
> >
> > From: Drew
> > Sent: Tuesday, April 17, 2012 4:12 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Create Field to report on a BAQ
> >
> >
> > I have created a Check box on my Part Entry screen to suggest if something needs to go to inspection or not. I am new to Epicor and don't know how to map it so it is a reportable field. For example, if I wanted to pull that check box into a BAQ for reporting. I see the EpiBinding and I have selected CheckBox01, but how do I add it to "Part" so I can query it into my BAQ and how do I rename that field to say what I want it to say?
> >
> > is this done by creating a UD Table?
> >
> > I hope I was clear in what I want to do.
> >
> > Thanks,
> > Andrew
> >
> >
> >
> >
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2012.0.1913 / Virus Database: 2411/4942 - Release Date: 04/17/12
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
I have created a Check box on my Part Entry screen to suggest if something needs to go to inspection or not. I am new to Epicor and don't know how to map it so it is a reportable field. For example, if I wanted to pull that check box into a BAQ for reporting. I see the EpiBinding and I have selected CheckBox01, but how do I add it to "Part" so I can query it into my BAQ and how do I rename that field to say what I want it to say?

is this done by creating a UD Table?

I hope I was clear in what I want to do.

Thanks,
Andrew
3
BTW, I'm on 9.05.607

--- In vantage@yahoogroups.com, "Drew" <ahsalloum@...> wrote:
>
> I have created a Check box on my Part Entry screen to suggest if something needs to go to inspection or not. I am new to Epicor and don't know how to map it so it is a reportable field. For example, if I wanted to pull that check box into a BAQ for reporting. I see the EpiBinding and I have selected CheckBox01, but how do I add it to "Part" so I can query it into my BAQ and how do I rename that field to say what I want it to say?
>
> is this done by creating a UD Table?
>
> I hope I was clear in what I want to do.
>
> Thanks,
> Andrew
>
4
Andrew,

If you bound your control within Customization to a table’s field, then that’s all you need. That value will now update Part.Checkbox01 (assuming you selected that field when you customized your form).

Then, simply create a BAQ or modify other Report Data Def’s to include your field in various reports.



From: Drew
Sent: Tuesday, April 17, 2012 4:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Create Field to report on a BAQ


I have created a Check box on my Part Entry screen to suggest if something needs to go to inspection or not. I am new to Epicor and don't know how to map it so it is a reportable field. For example, if I wanted to pull that check box into a BAQ for reporting. I see the EpiBinding and I have selected CheckBox01, but how do I add it to "Part" so I can query it into my BAQ and how do I rename that field to say what I want it to say?

is this done by creating a UD Table?

I hope I was clear in what I want to do.

Thanks,
Andrew




No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2411/4942 - Release Date: 04/17/12


[Non-text portions of this message have been removed]
5
Thanks for the reply. I did select "Part.CheckBox01" on the EpiBinding row, but when I pull "Part" into my BAQ, it does not have a checkbox01 column to select. Do I have to make it visible somewhere else?

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Andrew,
>
> If you bound your control within Customization to a table’s field, then that’s all you need. That value will now update Part.Checkbox01 (assuming you selected that field when you customized your form).
>
> Then, simply create a BAQ or modify other Report Data Def’s to include your field in various reports.
>
>
>
> From: Drew
> Sent: Tuesday, April 17, 2012 4:12 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Create Field to report on a BAQ
>
>
> I have created a Check box on my Part Entry screen to suggest if something needs to go to inspection or not. I am new to Epicor and don't know how to map it so it is a reportable field. For example, if I wanted to pull that check box into a BAQ for reporting. I see the EpiBinding and I have selected CheckBox01, but how do I add it to "Part" so I can query it into my BAQ and how do I rename that field to say what I want it to say?
>
> is this done by creating a UD Table?
>
> I hope I was clear in what I want to do.
>
> Thanks,
> Andrew
>
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.1913 / Virus Database: 2411/4942 - Release Date: 04/17/12
>
>
> [Non-text portions of this message have been removed]
>
6
In the BAQ Designer, click the little button with a strange picture and a tooltip of “Show User Defined Fields”, usually to the right of the A->Z sort button. Otherwise the designer hides all the CheckBox01 etc fields on you.



Brian.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Drew
Sent: Tuesday, April 17, 2012 4:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Create Field to report on a BAQ





Thanks for the reply. I did select "Part.CheckBox01" on the EpiBinding row, but when I pull "Part" into my BAQ, it does not have a checkbox01 column to select. Do I have to make it visible somewhere else?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Andrew,
>
> If you bound your control within Customization to a table’s field, then that’s all you need. That value will now update Part.Checkbox01 (assuming you selected that field when you customized your form).
>
> Then, simply create a BAQ or modify other Report Data Def’s to include your field in various reports.
>
>
>
> From: Drew
> Sent: Tuesday, April 17, 2012 4:12 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Create Field to report on a BAQ
>
>
> I have created a Check box on my Part Entry screen to suggest if something needs to go to inspection or not. I am new to Epicor and don't know how to map it so it is a reportable field. For example, if I wanted to pull that check box into a BAQ for reporting. I see the EpiBinding and I have selected CheckBox01, but how do I add it to "Part" so I can query it into my BAQ and how do I rename that field to say what I want it to say?
>
> is this done by creating a UD Table?
>
> I hope I was clear in what I want to do.
>
> Thanks,
> Andrew
>
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.1913 / Virus Database: 2411/4942 - Release Date: 04/17/12
>
>
> [Non-text portions of this message have been removed]
>





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