BAQReportParameters - Filter1

Yahoo Archive
1
Roel,



It gets complicated when not all receipts are inspected within the
filter dates, thus they don't have INSPECTED date, in that case we must
use the cutoff date as the second date.



Mike Tonoyan / Natel Engr.

mtonoyan@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Roel Martinez
Sent: Wednesday, July 20, 2011 8:24 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: BAQReportParameters - Filter1





Mike, is my approach too simplistic or should you just bring the
RcvDtl.ReceiptDate and RcvDtl.InspectedDate and subtract the 1st from
the 2nd for your "INSPECTION DAYS"? Sorry, I have not used Inspection in
a very long time and might be completely off your purpose....

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax:
817-852-1705

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Mike Tonoyan
Sent: Tuesday, July 19, 2011 4:47 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQReportParameters - Filter1

Finally I was able to manually create the RI_Aging.rpt file, which I was
struggling with earlier.

Now I have another question, I need to create a calculated field to find
number of days the PO Receipt was in the Receiving Inspection area. One
of the BAQ report options is the cutoff date. Is there any way to
capture the cutoff date in Crystal Reports? I can see the date when I
browse the Filter1 in BAQReportParameters. Do I need to create a formula
to fetch the data I need or there is an easy way?

Mike Tonoyan / Natel Engr.

mtonoyan@... <mailto:mtonoyan%40natelengr.com>
<mailto:mtonoyan%40natelengr.com>

__________________________________________________________
Notice: This email transmission may contain confidential information and
is intended only for the person(s) named. Any use, copying or disclosure
to/by any other person(s) is strictly prohibited. By accepting this
information, recipients confirm that they understand and will comply
with all applicable ITAR and EAR requirements.
__________________________________________________________

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

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




______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

[Non-text portions of this message have been removed]
2
We're trying to add 2 method directives to the JobEntry screen. We'd simply like to record the time and date of when the JobEngineered and JobReleased fields are checked, the first time. I added them as pre-processing directives. They worked fine in the test company so I exported them and imported into our live database. After I enabled them, users started calling reporting an error, "Record has been modified by another user and couldn't be updated. Please press the Refresh button and re-enter your changes," when they try to save the job after clicking either JobEngineered or JobReleased. The workaround was to un-click Engineered and then save. Seems like it's a timing issue between the two directives.

They are both added as Pre-Processing directives. Here they are...

JobEngineered Conditions
-------------------------
the JobHead.JobEngineered field of the changed row is equal to the True value and the JobHead.Date04 field of the changed row is equal to the ? value

JobEngineered Actions
-------------------------
for each ttJobHead where ttJobHead.JobEngineered = True no-lock. Assign ttJobHead.Date04 = Today. End.

JobReleased Conditions
-------------------------
the JobHead.JobReleased field of the changed row is equal to the True value and the JobHead.Date05 field of the changed row is equal to the ? value

JobReleased Actions
-------------------------
for each ttJobHead where ttJobHead.JobReleased = True no-lock. Assign ttJobHead.Date05 = Today. End.

Any thoughts?

Thanks,
Bruce
3
I haven't seen pre-processing directives generate that error before.
The only thing I can think of would be to add checks to make sure rowmod =
'A' or 'U'. Perhaps it's getting upset because you're changing rows that
aren't flagged as updates.

Conversely, you might be able to just set the rowmod to 'U' manually.
However I think there are issues with doing that in some cases. It's not a
method I use so I'm not too familiar with it.

On Mon, Jul 18, 2011 at 3:39 PM, brucewbrannan <bruce.brannan@...>wrote:

> **
>
>
> We're trying to add 2 method directives to the JobEntry screen. We'd simply
> like to record the time and date of when the JobEngineered and JobReleased
> fields are checked, the first time. I added them as pre-processing
> directives. They worked fine in the test company so I exported them and
> imported into our live database. After I enabled them, users started calling
> reporting an error, "Record has been modified by another user and couldn't
> be updated. Please press the Refresh button and re-enter your changes," when
> they try to save the job after clicking either JobEngineered or JobReleased.
> The workaround was to un-click Engineered and then save. Seems like it's a
> timing issue between the two directives.
>
> They are both added as Pre-Processing directives. Here they are...
>
> JobEngineered Conditions
> -------------------------
> the JobHead.JobEngineered field of the changed row is equal to the True
> value and the JobHead.Date04 field of the changed row is equal to the ?
> value
>
> JobEngineered Actions
> -------------------------
> for each ttJobHead where ttJobHead.JobEngineered = True no-lock. Assign
> ttJobHead.Date04 = Today. End.
>
> JobReleased Conditions
> -------------------------
> the JobHead.JobReleased field of the changed row is equal to the True value
> and the JobHead.Date05 field of the changed row is equal to the ? value
>
> JobReleased Actions
> -------------------------
> for each ttJobHead where ttJobHead.JobReleased = True no-lock. Assign
> ttJobHead.Date05 = Today. End.
>
> Any thoughts?
>
> Thanks,
> Bruce
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
4
I did a little testing. If you just check the boxes it does save the record and the dates but if you make a change to another field on the screen (like another custom date field we've added) then the error pops up when you click the save button.

I'll try the rowmod A/U, I think I accidentally left that out.

--- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
>
> I haven't seen pre-processing directives generate that error before.
> The only thing I can think of would be to add checks to make sure rowmod =
> 'A' or 'U'. Perhaps it's getting upset because you're changing rows that
> aren't flagged as updates.
>
> Conversely, you might be able to just set the rowmod to 'U' manually.
> However I think there are issues with doing that in some cases. It's not a
> method I use so I'm not too familiar with it.
>
> On Mon, Jul 18, 2011 at 3:39 PM, brucewbrannan <bruce.brannan@...>wrote:
>
> > **
> >
> >
> > We're trying to add 2 method directives to the JobEntry screen. We'd simply
> > like to record the time and date of when the JobEngineered and JobReleased
> > fields are checked, the first time. I added them as pre-processing
> > directives. They worked fine in the test company so I exported them and
> > imported into our live database. After I enabled them, users started calling
> > reporting an error, "Record has been modified by another user and couldn't
> > be updated. Please press the Refresh button and re-enter your changes," when
> > they try to save the job after clicking either JobEngineered or JobReleased.
> > The workaround was to un-click Engineered and then save. Seems like it's a
> > timing issue between the two directives.
> >
> > They are both added as Pre-Processing directives. Here they are...
> >
> > JobEngineered Conditions
> > -------------------------
> > the JobHead.JobEngineered field of the changed row is equal to the True
> > value and the JobHead.Date04 field of the changed row is equal to the ?
> > value
> >
> > JobEngineered Actions
> > -------------------------
> > for each ttJobHead where ttJobHead.JobEngineered = True no-lock. Assign
> > ttJobHead.Date04 = Today. End.
> >
> > JobReleased Conditions
> > -------------------------
> > the JobHead.JobReleased field of the changed row is equal to the True value
> > and the JobHead.Date05 field of the changed row is equal to the ? value
> >
> > JobReleased Actions
> > -------------------------
> > for each ttJobHead where ttJobHead.JobReleased = True no-lock. Assign
> > ttJobHead.Date05 = Today. End.
> >
> > Any thoughts?
> >
> > Thanks,
> > Bruce
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>
5
That was it, the Add/Update test. Here's the code that fixed it. I'm not sure of the difference between no-lock and exclusive-lock and the BPM manual is not clear but I went ahead and changed it to exclusive.

for each ttJobHead where (ttJobHead.RowMod= 'A' or ttJobHead.RowMod= 'U') and ttJobHead.JobEngineered = True Exclusive-lock. Assign ttJobHead.Date04 = Today. End.

Thank you for the help!

--- In vantage@yahoogroups.com, "brucewbrannan" <bruce.brannan@...> wrote:
>
> I did a little testing. If you just check the boxes it does save the record and the dates but if you make a change to another field on the screen (like another custom date field we've added) then the error pops up when you click the save button.
>
> I'll try the rowmod A/U, I think I accidentally left that out.
>
> --- In vantage@yahoogroups.com, Waffqle <waffqle@> wrote:
> >
> > I haven't seen pre-processing directives generate that error before.
> > The only thing I can think of would be to add checks to make sure rowmod =
> > 'A' or 'U'. Perhaps it's getting upset because you're changing rows that
> > aren't flagged as updates.
> >
> > Conversely, you might be able to just set the rowmod to 'U' manually.
> > However I think there are issues with doing that in some cases. It's not a
> > method I use so I'm not too familiar with it.
> >
> > On Mon, Jul 18, 2011 at 3:39 PM, brucewbrannan <bruce.brannan@>wrote:
> >
> > > **
> > >
> > >
> > > We're trying to add 2 method directives to the JobEntry screen. We'd simply
> > > like to record the time and date of when the JobEngineered and JobReleased
> > > fields are checked, the first time. I added them as pre-processing
> > > directives. They worked fine in the test company so I exported them and
> > > imported into our live database. After I enabled them, users started calling
> > > reporting an error, "Record has been modified by another user and couldn't
> > > be updated. Please press the Refresh button and re-enter your changes," when
> > > they try to save the job after clicking either JobEngineered or JobReleased.
> > > The workaround was to un-click Engineered and then save. Seems like it's a
> > > timing issue between the two directives.
> > >
> > > They are both added as Pre-Processing directives. Here they are...
> > >
> > > JobEngineered Conditions
> > > -------------------------
> > > the JobHead.JobEngineered field of the changed row is equal to the True
> > > value and the JobHead.Date04 field of the changed row is equal to the ?
> > > value
> > >
> > > JobEngineered Actions
> > > -------------------------
> > > for each ttJobHead where ttJobHead.JobEngineered = True no-lock. Assign
> > > ttJobHead.Date04 = Today. End.
> > >
> > > JobReleased Conditions
> > > -------------------------
> > > the JobHead.JobReleased field of the changed row is equal to the True value
> > > and the JobHead.Date05 field of the changed row is equal to the ? value
> > >
> > > JobReleased Actions
> > > -------------------------
> > > for each ttJobHead where ttJobHead.JobReleased = True no-lock. Assign
> > > ttJobHead.Date05 = Today. End.
> > >
> > > Any thoughts?
> > >
> > > Thanks,
> > > Bruce
> > >
> > >
> > >
> >
> >
> >
> > --
> > *Waffqle Driggers*
> > *High End Dev, System Design, Profit Drinking
> > *
> > *:: 904.962.2887*
> > *:: waffqle@*
> > *:: NO FAXES*
> >
> > *
> >
> > *
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
6
Per this code, it does successfully record the date but we'd like to record in date and time format. How would I change the "= Today" to have it store the date and time?

--- In vantage@yahoogroups.com, "brucewbrannan" <bruce.brannan@...> wrote:
>
> That was it, the Add/Update test. Here's the code that fixed it. I'm not sure of the difference between no-lock and exclusive-lock and the BPM manual is not clear but I went ahead and changed it to exclusive.
>
> for each ttJobHead where (ttJobHead.RowMod= 'A' or ttJobHead.RowMod= 'U') and ttJobHead.JobEngineered = True Exclusive-lock. Assign ttJobHead.Date04 = Today. End.
>
> Thank you for the help!
>
> --- In vantage@yahoogroups.com, "brucewbrannan" <bruce.brannan@> wrote:
> >
> > I did a little testing. If you just check the boxes it does save the record and the dates but if you make a change to another field on the screen (like another custom date field we've added) then the error pops up when you click the save button.
> >
> > I'll try the rowmod A/U, I think I accidentally left that out.
> >
> > --- In vantage@yahoogroups.com, Waffqle <waffqle@> wrote:
> > >
> > > I haven't seen pre-processing directives generate that error before.
> > > The only thing I can think of would be to add checks to make sure rowmod =
> > > 'A' or 'U'. Perhaps it's getting upset because you're changing rows that
> > > aren't flagged as updates.
> > >
> > > Conversely, you might be able to just set the rowmod to 'U' manually.
> > > However I think there are issues with doing that in some cases. It's not a
> > > method I use so I'm not too familiar with it.
> > >
> > > On Mon, Jul 18, 2011 at 3:39 PM, brucewbrannan <bruce.brannan@>wrote:
> > >
> > > > **
> > > >
> > > >
> > > > We're trying to add 2 method directives to the JobEntry screen. We'd simply
> > > > like to record the time and date of when the JobEngineered and JobReleased
> > > > fields are checked, the first time. I added them as pre-processing
> > > > directives. They worked fine in the test company so I exported them and
> > > > imported into our live database. After I enabled them, users started calling
> > > > reporting an error, "Record has been modified by another user and couldn't
> > > > be updated. Please press the Refresh button and re-enter your changes," when
> > > > they try to save the job after clicking either JobEngineered or JobReleased.
> > > > The workaround was to un-click Engineered and then save. Seems like it's a
> > > > timing issue between the two directives.
> > > >
> > > > They are both added as Pre-Processing directives. Here they are...
> > > >
> > > > JobEngineered Conditions
> > > > -------------------------
> > > > the JobHead.JobEngineered field of the changed row is equal to the True
> > > > value and the JobHead.Date04 field of the changed row is equal to the ?
> > > > value
> > > >
> > > > JobEngineered Actions
> > > > -------------------------
> > > > for each ttJobHead where ttJobHead.JobEngineered = True no-lock. Assign
> > > > ttJobHead.Date04 = Today. End.
> > > >
> > > > JobReleased Conditions
> > > > -------------------------
> > > > the JobHead.JobReleased field of the changed row is equal to the True value
> > > > and the JobHead.Date05 field of the changed row is equal to the ? value
> > > >
> > > > JobReleased Actions
> > > > -------------------------
> > > > for each ttJobHead where ttJobHead.JobReleased = True no-lock. Assign
> > > > ttJobHead.Date05 = Today. End.
> > > >
> > > > Any thoughts?
> > > >
> > > > Thanks,
> > > > Bruce
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > *Waffqle Driggers*
> > > *High End Dev, System Design, Profit Drinking
> > > *
> > > *:: 904.962.2887*
> > > *:: waffqle@*
> > > *:: NO FAXES*
> > >
> > > *
> > >
> > > *
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
7
I have created a BAQ Report in the BAQ Report Designer, everything works
fine until I want to create the Crystal Reports. When I click on "Design
Crystal Reports" Crystal Reports program starts then immediately
prompts that cannot find the .rpt file. Has anyone had this problem? Is
it possible to bypass this step and create the report manually?



Mike Tonoyan / Natel Engr.

mtonoyan@...


______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

[Non-text portions of this message have been removed]
8
Crystal Report Executable: C:\Program Files (x86)\Business
Objects\Crystal Reports 11.5\crw32.exe

Sample Data Directory: C:\_BAQReports\SampleData

Local Reports Directory: C:\_BAQReports\Reports



Server Reports Directory:
\\ntlcht-epiapp01\Epicor904\server\reports\CustomReports
<file:///\\ntlcht-epiapp01\Epicor904\server\reports\CustomReports>

BAQ Report Template: BAQReport.rpt

Copy Report Locally: Checked







Mike Tonoyan / Natel Engr.

mtonoyan@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of cooner_55421
Sent: Monday, July 18, 2011 3:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ Report Designer issues





Hi Mike,

Is the report name visible in the BAQ report designer?
If so, then I would look in the servers custom report directory & see if
the file is there.
Path is usually something like \\server\epicor\mfgsys\reports\custom
reports\

BTW... what do your options look like in the BAQ report designer?
Menu item - Actions, BAQ report options
The local and server reports directories.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Mike Tonoyan" <mtonoyan@...> wrote:
>
> I have created a BAQ Report in the BAQ Report Designer, everything
works
> fine until I want to create the Crystal Reports. When I click on
"Design
> Crystal Reports" Crystal Reports program starts then immediately
> prompts that cannot find the .rpt file. Has anyone had this problem?
Is
> it possible to bypass this step and create the report manually?
>
>
>
> Mike Tonoyan / Natel Engr.
>
> mtonoyan@...
>
>
> __________________________________________________________
> Notice: This email transmission may contain confidential information
and is intended only for the person(s) named. Any use, copying or
disclosure to/by any other person(s) is strictly prohibited. By
accepting this information, recipients confirm that they understand and
will comply with all applicable ITAR and EAR requirements.
> __________________________________________________________
>
> [Non-text portions of this message have been removed]
>




______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

[Non-text portions of this message have been removed]
9
Hi Bruce,



I searched both C:\ and D:\ drives on the appserver, nowhere to be
found.



Mike Tonoyan / Natel Engr.

mtonoyan@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of cooner_55421
Sent: Monday, July 18, 2011 3:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ Report Designer issues





Hi Mike,

Is the report name visible in the BAQ report designer?
If so, then I would look in the servers custom report directory & see if
the file is there.
Path is usually something like \\server\epicor\mfgsys\reports\custom
reports\

BTW... what do your options look like in the BAQ report designer?
Menu item - Actions, BAQ report options
The local and server reports directories.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Mike Tonoyan" <mtonoyan@...> wrote:
>
> I have created a BAQ Report in the BAQ Report Designer, everything
works
> fine until I want to create the Crystal Reports. When I click on
"Design
> Crystal Reports" Crystal Reports program starts then immediately
> prompts that cannot find the .rpt file. Has anyone had this problem?
Is
> it possible to bypass this step and create the report manually?
>
>
>
> Mike Tonoyan / Natel Engr.
>
> mtonoyan@...
>
>
> __________________________________________________________
> Notice: This email transmission may contain confidential information
and is intended only for the person(s) named. Any use, copying or
disclosure to/by any other person(s) is strictly prohibited. By
accepting this information, recipients confirm that they understand and
will comply with all applicable ITAR and EAR requirements.
> __________________________________________________________
>
> [Non-text portions of this message have been removed]
>




______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

[Non-text portions of this message have been removed]
10
When you start a new BAQ-based Crystal Report, Vantage 8 / Epicor 9 copies a file ( .....\Reports\CustomReports\BAQReport.rpt) to the path specified in Options (defaults to C:\_BAQReports\Reports). Possible problems are the original file was deleted or there is a permissions problem at the destination. The short term fix would be to copy BAQReport.rpt to the new file name and go to work. You would have to set a database location anyway so the additional work is minimal.

--- In vantage@yahoogroups.com, "Mike Tonoyan" <mtonoyan@...> wrote:
>
> Hi Bruce,
>
>
>
> I searched both C:\ and D:\ drives on the appserver, nowhere to be
> found.
>
>
>
> Mike Tonoyan / Natel Engr.
>
> mtonoyan@...
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of cooner_55421
> Sent: Monday, July 18, 2011 3:52 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BAQ Report Designer issues
>
>
>
>
>
> Hi Mike,
>
> Is the report name visible in the BAQ report designer?
> If so, then I would look in the servers custom report directory & see if
> the file is there.
> Path is usually something like \\server\epicor\mfgsys\reports\custom
> reports\
>
> BTW... what do your options look like in the BAQ report designer?
> Menu item - Actions, BAQ report options
> The local and server reports directories.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Mike Tonoyan" <mtonoyan@> wrote:
> >
> > I have created a BAQ Report in the BAQ Report Designer, everything
> works
> > fine until I want to create the Crystal Reports. When I click on
> "Design
> > Crystal Reports" Crystal Reports program starts then immediately
> > prompts that cannot find the .rpt file. Has anyone had this problem?
> Is
> > it possible to bypass this step and create the report manually?
> >
> >
> >
> > Mike Tonoyan / Natel Engr.
> >
> > mtonoyan@
> >
> >
> > __________________________________________________________
> > Notice: This email transmission may contain confidential information
> and is intended only for the person(s) named. Any use, copying or
> disclosure to/by any other person(s) is strictly prohibited. By
> accepting this information, recipients confirm that they understand and
> will comply with all applicable ITAR and EAR requirements.
> > __________________________________________________________
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> ______________________________________________________________________
> Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
> ______________________________________________________________________
>
> [Non-text portions of this message have been removed]
>
11
You can use 'Now' instead of 'Today' to get the current datetime. However,
if I recall correctly the type on Epicor's date fields is Date, not
DateTime. You'd need to stick the DateTime is one of the character fields.
Not too hard, but it makes it a bit less convenient to handle later.

On Mon, Jul 18, 2011 at 4:46 PM, brucewbrannan <bruce.brannan@...>wrote:

> **
>
>
> Per this code, it does successfully record the date but we'd like to record
> in date and time format. How would I change the "= Today" to have it store
> the date and time?
>
> --- In vantage@yahoogroups.com, "brucewbrannan" <bruce.brannan@...> wrote:
> >
> > That was it, the Add/Update test. Here's the code that fixed it. I'm not
> sure of the difference between no-lock and exclusive-lock and the BPM manual
> is not clear but I went ahead and changed it to exclusive.
> >
> > for each ttJobHead where (ttJobHead.RowMod= 'A' or ttJobHead.RowMod= 'U')
> and ttJobHead.JobEngineered = True Exclusive-lock. Assign ttJobHead.Date04 =
> Today. End.
> >
> > Thank you for the help!
> >
> > --- In vantage@yahoogroups.com, "brucewbrannan" <bruce.brannan@> wrote:
> > >
> > > I did a little testing. If you just check the boxes it does save the
> record and the dates but if you make a change to another field on the screen
> (like another custom date field we've added) then the error pops up when you
> click the save button.
> > >
> > > I'll try the rowmod A/U, I think I accidentally left that out.
> > >
> > > --- In vantage@yahoogroups.com, Waffqle <waffqle@> wrote:
> > > >
> > > > I haven't seen pre-processing directives generate that error before.
> > > > The only thing I can think of would be to add checks to make sure
> rowmod =
> > > > 'A' or 'U'. Perhaps it's getting upset because you're changing rows
> that
> > > > aren't flagged as updates.
> > > >
> > > > Conversely, you might be able to just set the rowmod to 'U' manually.
> > > > However I think there are issues with doing that in some cases. It's
> not a
> > > > method I use so I'm not too familiar with it.
> > > >
> > > > On Mon, Jul 18, 2011 at 3:39 PM, brucewbrannan <bruce.brannan@
> >wrote:
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > We're trying to add 2 method directives to the JobEntry screen.
> We'd simply
> > > > > like to record the time and date of when the JobEngineered and
> JobReleased
> > > > > fields are checked, the first time. I added them as pre-processing
> > > > > directives. They worked fine in the test company so I exported them
> and
> > > > > imported into our live database. After I enabled them, users
> started calling
> > > > > reporting an error, "Record has been modified by another user and
> couldn't
> > > > > be updated. Please press the Refresh button and re-enter your
> changes," when
> > > > > they try to save the job after clicking either JobEngineered or
> JobReleased.
> > > > > The workaround was to un-click Engineered and then save. Seems like
> it's a
> > > > > timing issue between the two directives.
> > > > >
> > > > > They are both added as Pre-Processing directives. Here they are...
> > > > >
> > > > > JobEngineered Conditions
> > > > > -------------------------
> > > > > the JobHead.JobEngineered field of the changed row is equal to the
> True
> > > > > value and the JobHead.Date04 field of the changed row is equal to
> the ?
> > > > > value
> > > > >
> > > > > JobEngineered Actions
> > > > > -------------------------
> > > > > for each ttJobHead where ttJobHead.JobEngineered = True no-lock.
> Assign
> > > > > ttJobHead.Date04 = Today. End.
> > > > >
> > > > > JobReleased Conditions
> > > > > -------------------------
> > > > > the JobHead.JobReleased field of the changed row is equal to the
> True value
> > > > > and the JobHead.Date05 field of the changed row is equal to the ?
> value
> > > > >
> > > > > JobReleased Actions
> > > > > -------------------------
> > > > > for each ttJobHead where ttJobHead.JobReleased = True no-lock.
> Assign
> > > > > ttJobHead.Date05 = Today. End.
> > > > >
> > > > > Any thoughts?
> > > > >
> > > > > Thanks,
> > > > > Bruce
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > *Waffqle Driggers*
> > > > *High End Dev, System Design, Profit Drinking
> > > > *
> > > > *:: 904.962.2887*
> > > > *:: waffqle@*
> > > > *:: NO FAXES*
> > > >
> > > > *
> > > >
> > > > *
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
12
You can just as well create a blank report in Crystal and give it your
dataset. We've done it lots of times.

On Tue, Jul 19, 2011 at 7:41 AM, al2trace <allen.larsen@...>wrote:

> **
>
>
> When you start a new BAQ-based Crystal Report, Vantage 8 / Epicor 9 copies
> a file ( .....\Reports\CustomReports\BAQReport.rpt) to the path specified in
> Options (defaults to C:\_BAQReports\Reports). Possible problems are the
> original file was deleted or there is a permissions problem at the
> destination. The short term fix would be to copy BAQReport.rpt to the new
> file name and go to work. You would have to set a database location anyway
> so the additional work is minimal.
>
>
> --- In vantage@yahoogroups.com, "Mike Tonoyan" <mtonoyan@...> wrote:
> >
> > Hi Bruce,
> >
> >
> >
> > I searched both C:\ and D:\ drives on the appserver, nowhere to be
> > found.
> >
> >
> >
> > Mike Tonoyan / Natel Engr.
> >
> > mtonoyan@...
>
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of cooner_55421
> > Sent: Monday, July 18, 2011 3:52 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: BAQ Report Designer issues
> >
> >
> >
> >
> >
> > Hi Mike,
> >
> > Is the report name visible in the BAQ report designer?
> > If so, then I would look in the servers custom report directory & see if
> > the file is there.
> > Path is usually something like \\server\epicor\mfgsys\reports\custom
> > reports\
> >
> > BTW... what do your options look like in the BAQ report designer?
> > Menu item - Actions, BAQ report options
> > The local and server reports directories.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "Mike Tonoyan" <mtonoyan@> wrote:
> > >
> > > I have created a BAQ Report in the BAQ Report Designer, everything
> > works
> > > fine until I want to create the Crystal Reports. When I click on
> > "Design
> > > Crystal Reports" Crystal Reports program starts then immediately
> > > prompts that cannot find the .rpt file. Has anyone had this problem?
> > Is
> > > it possible to bypass this step and create the report manually?
> > >
> > >
> > >
> > > Mike Tonoyan / Natel Engr.
> > >
> > > mtonoyan@
> > >
> > >
> > > __________________________________________________________
> > > Notice: This email transmission may contain confidential information
> > and is intended only for the person(s) named. Any use, copying or
> > disclosure to/by any other person(s) is strictly prohibited. By
> > accepting this information, recipients confirm that they understand and
> > will comply with all applicable ITAR and EAR requirements.
> > > __________________________________________________________
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > __________________________________________________________
> > Notice: This email transmission may contain confidential information and
> is intended only for the person(s) named. Any use, copying or disclosure
> to/by any other person(s) is strictly prohibited. By accepting this
> information, recipients confirm that they understand and will comply with
> all applicable ITAR and EAR requirements.
> > __________________________________________________________
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
13
I'll have to test this out. On the Job Entry screen we have the Date01 field for manual entry. When you enter a date, it does also enter the time (12:00:00 AM unless you manually override). When I run a BAQ test on it, it only shows the date but I bet Crystal will show the time. I changed the actions in our test company to reflect =Now instead of =Today. I'll post an update after I verify with a Crystal Report.

--- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
>
> You can use 'Now' instead of 'Today' to get the current datetime. However,
> if I recall correctly the type on Epicor's date fields is Date, not
> DateTime. You'd need to stick the DateTime is one of the character fields.
> Not too hard, but it makes it a bit less convenient to handle later.
>
> On Mon, Jul 18, 2011 at 4:46 PM, brucewbrannan <bruce.brannan@...>wrote:
>
> > **
> >
> >
> > Per this code, it does successfully record the date but we'd like to record
> > in date and time format. How would I change the "= Today" to have it store
> > the date and time?
> >
> > --- In vantage@yahoogroups.com, "brucewbrannan" <bruce.brannan@> wrote:
> > >
> > > That was it, the Add/Update test. Here's the code that fixed it. I'm not
> > sure of the difference between no-lock and exclusive-lock and the BPM manual
> > is not clear but I went ahead and changed it to exclusive.
> > >
> > > for each ttJobHead where (ttJobHead.RowMod= 'A' or ttJobHead.RowMod= 'U')
> > and ttJobHead.JobEngineered = True Exclusive-lock. Assign ttJobHead.Date04 =
> > Today. End.
> > >
> > > Thank you for the help!
> > >
> > > --- In vantage@yahoogroups.com, "brucewbrannan" <bruce.brannan@> wrote:
> > > >
> > > > I did a little testing. If you just check the boxes it does save the
> > record and the dates but if you make a change to another field on the screen
> > (like another custom date field we've added) then the error pops up when you
> > click the save button.
> > > >
> > > > I'll try the rowmod A/U, I think I accidentally left that out.
> > > >
> > > > --- In vantage@yahoogroups.com, Waffqle <waffqle@> wrote:
> > > > >
> > > > > I haven't seen pre-processing directives generate that error before.
> > > > > The only thing I can think of would be to add checks to make sure
> > rowmod =
> > > > > 'A' or 'U'. Perhaps it's getting upset because you're changing rows
> > that
> > > > > aren't flagged as updates.
> > > > >
> > > > > Conversely, you might be able to just set the rowmod to 'U' manually.
> > > > > However I think there are issues with doing that in some cases. It's
> > not a
> > > > > method I use so I'm not too familiar with it.
> > > > >
> > > > > On Mon, Jul 18, 2011 at 3:39 PM, brucewbrannan <bruce.brannan@
> > >wrote:
> > > > >
> > > > > > **
> > > > > >
> > > > > >
> > > > > > We're trying to add 2 method directives to the JobEntry screen.
> > We'd simply
> > > > > > like to record the time and date of when the JobEngineered and
> > JobReleased
> > > > > > fields are checked, the first time. I added them as pre-processing
> > > > > > directives. They worked fine in the test company so I exported them
> > and
> > > > > > imported into our live database. After I enabled them, users
> > started calling
> > > > > > reporting an error, "Record has been modified by another user and
> > couldn't
> > > > > > be updated. Please press the Refresh button and re-enter your
> > changes," when
> > > > > > they try to save the job after clicking either JobEngineered or
> > JobReleased.
> > > > > > The workaround was to un-click Engineered and then save. Seems like
> > it's a
> > > > > > timing issue between the two directives.
> > > > > >
> > > > > > They are both added as Pre-Processing directives. Here they are...
> > > > > >
> > > > > > JobEngineered Conditions
> > > > > > -------------------------
> > > > > > the JobHead.JobEngineered field of the changed row is equal to the
> > True
> > > > > > value and the JobHead.Date04 field of the changed row is equal to
> > the ?
> > > > > > value
> > > > > >
> > > > > > JobEngineered Actions
> > > > > > -------------------------
> > > > > > for each ttJobHead where ttJobHead.JobEngineered = True no-lock.
> > Assign
> > > > > > ttJobHead.Date04 = Today. End.
> > > > > >
> > > > > > JobReleased Conditions
> > > > > > -------------------------
> > > > > > the JobHead.JobReleased field of the changed row is equal to the
> > True value
> > > > > > and the JobHead.Date05 field of the changed row is equal to the ?
> > value
> > > > > >
> > > > > > JobReleased Actions
> > > > > > -------------------------
> > > > > > for each ttJobHead where ttJobHead.JobReleased = True no-lock.
> > Assign
> > > > > > ttJobHead.Date05 = Today. End.
> > > > > >
> > > > > > Any thoughts?
> > > > > >
> > > > > > Thanks,
> > > > > > Bruce
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > *Waffqle Driggers*
> > > > > *High End Dev, System Design, Profit Drinking
> > > > > *
> > > > > *:: 904.962.2887*
> > > > > *:: waffqle@*
> > > > > *:: NO FAXES*
> > > > >
> > > > > *
> > > > >
> > > > > *
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > >
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>
14
Good morning.

The Crystal document (.rpt) should be automatically created in the folder mentioned below ( <epicorserver>:\\epicor\mfgsys803\server\reports\customreports). I usually don't go through the "Design Crystal Report" path, this is what I do with very little problems:

1- I create my BAQ Report
2- From the Actions menu I do a "Test Report Form" (which creates the first xml file and the actual Crystal form).
3- I open Crystal and look for the "new" report in the mentioned directory.
4- I PrintPreview it and browse for my "fresh" xml file (in the ADO.NET(XML) dialog). This xml file will reside temporarily in the user's data file (<epicorserver>:\epicor\mfgsysdata\ reports\"username"\). Click Finish.
5- The preview will be empty. I go to the Database menu > Database Expert and move the Report Dataset below "Current Connections" to the right (Selecting "Report Dataset" and clicking on the ">>" button). This will actually put data into your Crystal form to start designing the report.

Let me know if you have any questions and call me if I can further assist you.

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES ™
www.sabretubularstructures.com
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705


--- In vantage@yahoogroups.com, "al2trace" <allen.larsen@...> wrote:
>
> When you start a new BAQ-based Crystal Report, Vantage 8 / Epicor 9 copies a file ( .....\Reports\CustomReports\BAQReport.rpt) to the path specified in Options (defaults to C:\_BAQReports\Reports). Possible problems are the original file was deleted or there is a permissions problem at the destination. The short term fix would be to copy BAQReport.rpt to the new file name and go to work. You would have to set a database location anyway so the additional work is minimal.
>
> --- In vantage@yahoogroups.com, "Mike Tonoyan" <mtonoyan@> wrote:
> >
> > Hi Bruce,
> >
> >
> >
> > I searched both C:\ and D:\ drives on the appserver, nowhere to be
> > found.
> >
> >
> >
> > Mike Tonoyan / Natel Engr.
> >
> > mtonoyan@
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of cooner_55421
> > Sent: Monday, July 18, 2011 3:52 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: BAQ Report Designer issues
> >
> >
> >
> >
> >
> > Hi Mike,
> >
> > Is the report name visible in the BAQ report designer?
> > If so, then I would look in the servers custom report directory & see if
> > the file is there.
> > Path is usually something like \\server\epicor\mfgsys\reports\custom
> > reports\
> >
> > BTW... what do your options look like in the BAQ report designer?
> > Menu item - Actions, BAQ report options
> > The local and server reports directories.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > "Mike Tonoyan" <mtonoyan@> wrote:
> > >
> > > I have created a BAQ Report in the BAQ Report Designer, everything
> > works
> > > fine until I want to create the Crystal Reports. When I click on
> > "Design
> > > Crystal Reports" Crystal Reports program starts then immediately
> > > prompts that cannot find the .rpt file. Has anyone had this problem?
> > Is
> > > it possible to bypass this step and create the report manually?
> > >
> > >
> > >
> > > Mike Tonoyan / Natel Engr.
> > >
> > > mtonoyan@
> > >
> > >
> > > __________________________________________________________
> > > Notice: This email transmission may contain confidential information
> > and is intended only for the person(s) named. Any use, copying or
> > disclosure to/by any other person(s) is strictly prohibited. By
> > accepting this information, recipients confirm that they understand and
> > will comply with all applicable ITAR and EAR requirements.
> > > __________________________________________________________
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> > ______________________________________________________________________
> > Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
> > ______________________________________________________________________
> >
> > [Non-text portions of this message have been removed]
> >
>
15
Thank you all for replying. I added the dataset manually, it worked.



Mike Tonoyan / Natel Engr.

mtonoyan@...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of al2trace
Sent: Tuesday, July 19, 2011 4:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ Report Designer issues





When you start a new BAQ-based Crystal Report, Vantage 8 / Epicor 9
copies a file ( .....\Reports\CustomReports\BAQReport.rpt) to the path
specified in Options (defaults to C:\_BAQReports\Reports). Possible
problems are the original file was deleted or there is a permissions
problem at the destination. The short term fix would be to copy
BAQReport.rpt to the new file name and go to work. You would have to set
a database location anyway so the additional work is minimal.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Mike Tonoyan" <mtonoyan@...> wrote:
>
> Hi Bruce,
>
>
>
> I searched both C:\ and D:\ drives on the appserver, nowhere to be
> found.
>
>
>
> Mike Tonoyan / Natel Engr.
>
> mtonoyan@...
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of cooner_55421
> Sent: Monday, July 18, 2011 3:52 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: BAQ Report Designer issues
>
>
>
>
>
> Hi Mike,
>
> Is the report name visible in the BAQ report designer?
> If so, then I would look in the servers custom report directory & see
if
> the file is there.
> Path is usually something like \\server\epicor\mfgsys\reports\custom
> reports\
>
> BTW... what do your options look like in the BAQ report designer?
> Menu item - Actions, BAQ report options
> The local and server reports directories.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Mike Tonoyan" <mtonoyan@> wrote:
> >
> > I have created a BAQ Report in the BAQ Report Designer, everything
> works
> > fine until I want to create the Crystal Reports. When I click on
> "Design
> > Crystal Reports" Crystal Reports program starts then immediately
> > prompts that cannot find the .rpt file. Has anyone had this problem?
> Is
> > it possible to bypass this step and create the report manually?
> >
> >
> >
> > Mike Tonoyan / Natel Engr.
> >
> > mtonoyan@
> >
> >
> > __________________________________________________________
> > Notice: This email transmission may contain confidential information
> and is intended only for the person(s) named. Any use, copying or
> disclosure to/by any other person(s) is strictly prohibited. By
> accepting this information, recipients confirm that they understand
and
> will comply with all applicable ITAR and EAR requirements.
> > __________________________________________________________
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> __________________________________________________________
> Notice: This email transmission may contain confidential information
and is intended only for the person(s) named. Any use, copying or
disclosure to/by any other person(s) is strictly prohibited. By
accepting this information, recipients confirm that they understand and
will comply with all applicable ITAR and EAR requirements.
> __________________________________________________________
>
> [Non-text portions of this message have been removed]
>




______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

[Non-text portions of this message have been removed]
16
Finally I was able to manually create the RI_Aging.rpt file, which I was
struggling with earlier.

Now I have another question, I need to create a calculated field to find
number of days the PO Receipt was in the Receiving Inspection area. One
of the BAQ report options is the cutoff date. Is there any way to
capture the cutoff date in Crystal Reports? I can see the date when I
browse the Filter1 in BAQReportParameters. Do I need to create a formula
to fetch the data I need or there is an easy way?



Mike Tonoyan / Natel Engr.

mtonoyan@...


______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________

[Non-text portions of this message have been removed]
17
Mike, is my approach too simplistic or should you just bring the RcvDtl.ReceiptDate and RcvDtl.InspectedDate and subtract the 1st from the 2nd for your "INSPECTION DAYS"? Sorry, I have not used Inspection in a very long time and might be completely off your purpose....

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mike Tonoyan
Sent: Tuesday, July 19, 2011 4:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQReportParameters - Filter1



Finally I was able to manually create the RI_Aging.rpt file, which I was
struggling with earlier.

Now I have another question, I need to create a calculated field to find
number of days the PO Receipt was in the Receiving Inspection area. One
of the BAQ report options is the cutoff date. Is there any way to
capture the cutoff date in Crystal Reports? I can see the date when I
browse the Filter1 in BAQReportParameters. Do I need to create a formula
to fetch the data I need or there is an easy way?

Mike Tonoyan / Natel Engr.

mtonoyan@...<mailto:mtonoyan%40natelengr.com>

__________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
__________________________________________________________

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



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