Repost

system · December 7, 2000, 12:20pm

Just noticed this, so apologies for delay in response.

I suspect that you are finding a memo where the memouserid is some value other than the specified, and you in effect printing a blank line. To test this try changing the false entry to print something. e.g.

IIF(MemoUserID="chuckm",MemoText,"Not Mine")

and run your report. if the result looks like this:

WCCode Description PartNum JobNum StartDate Memo
12345 Fadal 30" 567834 234 12/04/2000 Not Mine
Ready to Machine

then you are selecting an other memo record. Review the way you select the memos that you want to print.

HTH.

Charles Metcalf wrote:

> The formula I use is:
>
> IIF(MemoUserID="chuckm",MemoText,"")
>
> The problem I am having is my report looks like this:
>
> WCCode Description PartNum JobNum StartDate Memo
> 12345 Fadal 30" 567834 234 12/04/2000
> Ready to Machine
>
> My memos are offset from the line they should be on. I have tried everything
> but the right thing.
>
> Thanks
> Chuck
>
> -----Original Message-----
> From: Jim Frice [mailto:Jim.Frice@...]
> Sent: Monday, December 04, 2000 12:38 PM
> To: vantage@egroups.com
> Subject: RE: [Vantage] Repost
>
> Chuck are you using the memodesc or do you have categoryID's set up? It
> would probably be easier if you have categoryID's. But you can use formula
> to print only the ones that = the categoryID's you desire. Descriptions
> would have to be exact which can be a problem sometimes.
>
> > -----Original Message-----
> > From: Charles Metcalf [mailto:chuck_metcalf@...]
> > Sent: Monday, December 04, 2000 9:28 AM
> > To: vantage@egroups.com
> > Subject: [Vantage] Repost
> >
> >
> > I did not receive any responses to this question.
> >
> > I have written a scheduling report using Report Builder. I am using
> > jobhead, joboper, wrkcenter, and memos. My problem is, if there is
> > more than one memo description it brings the memo from each memo
> > description. I want to specify which memo description to use, ie. if
> > the memo descriptions are "Purchasing", and "Scheduling", and I want
> > to use the memotext only from "Scheduling", how can I do this.
> >
> > I am stumped, can anyone help??
> >
> > Thanks
> > Chuck
> >
> >
> >
> > We no longer allow attachments to files. To access/share Report
> > Files, please go to the following link:
> > http://www.egroups.com/files/vantage/
> > (Note: If this link does
> > not work for you the first time you try it, go to
> > www.egroups.com, login and be sure to save your password, choose
> > My Groups, choose Vantage, then choose Files. If you save the
> > password, the link above will work the next time you try it.)
> >
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to
> www.egroups.com, login and be sure to save your password, choose My Groups,
> choose Vantage, then choose Files. If you save the password, the link above
> will work the next time you try it.)
>
>
> We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)

--
/* ============================================================== */

William E. Colls Tel 613 591 0079
PROComputer Systems Fax 613 591 3924
67 Willow Glen Dr www.procomsys.com
Kanata Ontario Canada PEG Member 1998051404

Specialists in Progress Software development since 1985

system · October 4, 2000, 11:01am

I have not received any feedback on this question. Is there any help?

We are having a slight problem with incoming inspection. We receive
one part from a purchase order into inspection. The inspector than
inspects the part and it passes. We then go into inspection
processing, po receipts to process the part to inventory. We get an
error message that "the quantity of passed and quantity failed must
equal the received quantity". They do match, but we cannot get past
this point. This is sorta random. Any Help Available.
Thanks
Chuck

system · October 4, 2000, 12:59pm

Just a thought, is there any conversion involved? Are you buying by the
pound and receiving by the piece?

Greg Clauser
Lakin General Corporation
gclauser@... <mailto:gclauser@...>

-----Original Message-----
From: Charles Metcalf [mailto:cmetcalf@...]
Sent: Wednesday, October 04, 2000 10:01 AM
To: vantage@egroups.com
Subject: [Vantage] Repost

I have not received any feedback on this question. Is there any help?

We are having a slight problem with incoming inspection. We receive
one part from a purchase order into inspection. The inspector than
inspects the part and it passes. We then go into inspection
processing, po receipts to process the part to inventory. We get an
error message that "the quantity of passed and quantity failed must
equal the received quantity". They do match, but we cannot get past
this point. This is sorta random. Any Help Available.
Thanks
Chuck

system · October 4, 2000, 2:15pm

No Conversions. Just 1 each.
Chuck

Just a thought, is there any conversion involved? Are you buying by the
pound and receiving by the piece?

I have not received any feedback on this question. Is there any help?

We are having a slight problem with incoming inspection. We receive
one part from a purchase order into inspection. The inspector than
inspects the part and it passes. We then go into inspection
processing, po receipts to process the part to inventory. We get an
error message that "the quantity of passed and quantity failed must
equal the received quantity". They do match, but we cannot get past
this point. This is sorta random. Any Help Available.
Thanks
Chuck

system · October 5, 2000, 11:53am

You said random so I assume it's not just a certain vendor(s) or part(s).
Have you checked the PO's themselves or the manner in which the receipts
were entered on the problem ones?

No Conversions. Just 1 each.
Chuck

Just a thought, is there any conversion involved? Are you buying by the
pound and receiving by the piece?

I have not received any feedback on this question. Is there any help?

We are having a slight problem with incoming inspection. We receive
one part from a purchase order into inspection. The inspector than
inspects the part and it passes. We then go into inspection
processing, po receipts to process the part to inventory. We get an
error message that "the quantity of passed and quantity failed must
equal the received quantity". They do match, but we cannot get past
this point. This is sorta random. Any Help Available.
Thanks
Chuck

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)

system · October 5, 2000, 12:20pm

conversions seem to be such a likely problem- are you certain that the
vendor qty = your qty on the po and that the conversion is set up 1ea = 1ea
in the part master file? sorry to flog the same horse if you've already
checked...

-----Original Message-----
From: Greg Clauser [mailto:gclauser@...]
Sent: Thursday, October 05, 2000 9:38 AM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] Repost

You said random so I assume it's not just a certain vendor(s) or part(s).
Have you checked the PO's themselves or the manner in which the receipts
were entered on the problem ones?

No Conversions. Just 1 each.
Chuck

Just a thought, is there any conversion involved? Are you buying by the
pound and receiving by the piece?

I have not received any feedback on this question. Is there any help?

We are having a slight problem with incoming inspection. We receive
one part from a purchase order into inspection. The inspector than
inspects the part and it passes. We then go into inspection
processing, po receipts to process the part to inventory. We get an
error message that "the quantity of passed and quantity failed must
equal the received quantity". They do match, but we cannot get past
this point. This is sorta random. Any Help Available.
Thanks
Chuck

system · December 4, 2000, 10:29am

I did not receive any responses to this question.

I have written a scheduling report using Report Builder. I am using
jobhead, joboper, wrkcenter, and memos. My problem is, if there is
more than one memo description it brings the memo from each memo
description. I want to specify which memo description to use, ie. if
the memo descriptions are "Purchasing", and "Scheduling", and I want
to use the memotext only from "Scheduling", how can I do this.

I am stumped, can anyone help??

Thanks
Chuck

system · December 4, 2000, 1:30pm

Chuck are you using the memodesc or do you have categoryID's set up? It
would probably be easier if you have categoryID's. But you can use formula
to print only the ones that = the categoryID's you desire. Descriptions
would have to be exact which can be a problem sometimes.

> -----Original Message-----
> From: Charles Metcalf [mailto:chuck_metcalf@...]
> Sent: Monday, December 04, 2000 9:28 AM
> To: vantage@egroups.com
> Subject: [Vantage] Repost
>
>
> I did not receive any responses to this question.
>
> I have written a scheduling report using Report Builder. I am using
> jobhead, joboper, wrkcenter, and memos. My problem is, if there is
> more than one memo description it brings the memo from each memo
> description. I want to specify which memo description to use, ie. if
> the memo descriptions are "Purchasing", and "Scheduling", and I want
> to use the memotext only from "Scheduling", how can I do this.
>
> I am stumped, can anyone help??
>
> Thanks
> Chuck
>
>
>
> We no longer allow attachments to files. To access/share Report
> Files, please go to the following link:
> http://www.egroups.com/files/vantage/
> (Note: If this link does
> not work for you the first time you try it, go to
> www.egroups.com, login and be sure to save your password, choose
> My Groups, choose Vantage, then choose Files. If you save the
> password, the link above will work the next time you try it.)
>

system · December 4, 2000, 3:16pm

The formula I use is:

IIF(MemoUserID="chuckm",MemoText,"")

The problem I am having is my report looks like this:

WCCode Description PartNum JobNum StartDate Memo
12345 Fadal 30" 567834 234 12/04/2000
Ready to Machine

My memos are offset from the line they should be on. I have tried everything
but the right thing.

Thanks
Chuck

-----Original Message-----
From: Jim Frice [mailto:Jim.Frice@...]
Sent: Monday, December 04, 2000 12:38 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Repost

Chuck are you using the memodesc or do you have categoryID's set up? It
would probably be easier if you have categoryID's. But you can use formula
to print only the ones that = the categoryID's you desire. Descriptions
would have to be exact which can be a problem sometimes.

> -----Original Message-----
> From: Charles Metcalf [mailto:chuck_metcalf@...]
> Sent: Monday, December 04, 2000 9:28 AM
> To: vantage@egroups.com
> Subject: [Vantage] Repost
>
>
> I did not receive any responses to this question.
>
> I have written a scheduling report using Report Builder. I am using
> jobhead, joboper, wrkcenter, and memos. My problem is, if there is
> more than one memo description it brings the memo from each memo
> description. I want to specify which memo description to use, ie. if
> the memo descriptions are "Purchasing", and "Scheduling", and I want
> to use the memotext only from "Scheduling", how can I do this.
>
> I am stumped, can anyone help??
>
> Thanks
> Chuck
>
>
>
> We no longer allow attachments to files. To access/share Report
> Files, please go to the following link:
> http://www.egroups.com/files/vantage/
> (Note: If this link does
> not work for you the first time you try it, go to
> www.egroups.com, login and be sure to save your password, choose
> My Groups, choose Vantage, then choose Files. If you save the
> password, the link above will work the next time you try it.)
>

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)

system · December 4, 2000, 3:44pm

Chuck, it looks as though your memos are starting with a carrage return/
line feed combination. Are the memos entered this way? If so, perhaps you
could strip out the leading characters.

Create a calculated field called CRLF defined as CHR(13) + CHR(10) ;
a string containing the ASCII values of Carriage return & line feed.

Then change calculation to: IIF(MemoUserID="chuckm",TRIM(MemoText,CRLF),"")
; this will trim both beginning and ending carriage return and line feed
characters.

Good Luck
Jim Stetter

-----Original Message-----
From: Charles Metcalf [mailto:chuck_metcalf@...]
Sent: Monday, December 04, 2000 3:16 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Repost

The formula I use is:

IIF(MemoUserID="chuckm",MemoText,"")

The problem I am having is my report looks like this:

WCCode Description PartNum JobNum StartDate Memo
12345 Fadal 30" 567834 234 12/04/2000
Ready to Machine

My memos are offset from the line they should be on. I have tried
everything
but the right thing.

Thanks
Chuck

-----Original Message-----
From: Jim Frice [mailto:Jim.Frice@...]
Sent: Monday, December 04, 2000 12:38 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Repost

Chuck are you using the memodesc or do you have categoryID's set up? It
would probably be easier if you have categoryID's. But you can use formula
to print only the ones that = the categoryID's you desire. Descriptions
would have to be exact which can be a problem sometimes.

> -----Original Message-----
> From: Charles Metcalf [mailto:chuck_metcalf@...]
> Sent: Monday, December 04, 2000 9:28 AM
> To: vantage@egroups.com
> Subject: [Vantage] Repost
>
>
> I did not receive any responses to this question.
>
> I have written a scheduling report using Report Builder. I am using
> jobhead, joboper, wrkcenter, and memos. My problem is, if there is
> more than one memo description it brings the memo from each memo
> description. I want to specify which memo description to use, ie. if
> the memo descriptions are "Purchasing", and "Scheduling", and I want
> to use the memotext only from "Scheduling", how can I do this.
>
> I am stumped, can anyone help??
>
> Thanks
> Chuck
>
>
>
> We no longer allow attachments to files. To access/share Report
> Files, please go to the following link:
> http://www.egroups.com/files/vantage/
> (Note: If this link does
> not work for you the first time you try it, go to
> www.egroups.com, login and be sure to save your password, choose
> My Groups, choose Vantage, then choose Files. If you save the
> password, the link above will work the next time you try it.)
>

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go
to
www.egroups.com, login and be sure to save your password, choose My
Groups,
choose Vantage, then choose Files. If you save the password, the link
above
will work the next time you try it.)

eGroups Sponsor

We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)

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