Zero Balance A/P Invoice

system · February 9, 2001, 10:52am

Assuming ValueDate is a date try this:
iif(PromDate < 2/28/01, PromDate, iif(inv >= QtyDue, today(),
03/01/01))

If ValueDate could be yes/no then the formula is:
iif(PromDate < 2/28/01, yes, iif(inv >= QtyDue, yes, no))

You could use that field to control whether a line would print or not.

HTH
RRD

On 9 Feb 2001, at 15:10, chuck_metcalf@... wrote:

I need help on a formula: My data looks like this;

PromDate Part# ProdQty QtyDue Inv
Value
2/9/01 12345 7 6 0
? 23456 0 5 15
3/1/01 45678 8 7 0
? 56789 0 8 10

I would like the value "Calculated Field in my report
is ValueDate"
to show up if the PromDate is before 2/28/01, or if
the unknown value
is in the PromDate, but there is enough inventory to
support the
QtyDue.

Any help would be appreciated.

Chuck

Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com

system · February 9, 2001, 12:07pm

Russ,
Thank You for your response. The valuedate is actually the $value of the qty
due.
Chuck

-----Original Message-----
From: Russ Dover [mailto:rdover@...]
Sent: Friday, February 09, 2001 9:52 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Report Builder

Assuming ValueDate is a date try this:
iif(PromDate < 2/28/01, PromDate, iif(inv >= QtyDue, today(),
03/01/01))

If ValueDate could be yes/no then the formula is:
iif(PromDate < 2/28/01, yes, iif(inv >= QtyDue, yes, no))

You could use that field to control whether a line would print or not.

HTH
RRD

On 9 Feb 2001, at 15:10, chuck_metcalf@... wrote:

I need help on a formula: My data looks like this;

PromDate Part# ProdQty QtyDue Inv
Value
2/9/01 12345 7 6 0
? 23456 0 5 15
3/1/01 45678 8 7 0
? 56789 0 8 10

I would like the value "Calculated Field in my report
is ValueDate"
to show up if the PromDate is before 2/28/01, or if
the unknown value
is in the PromDate, but there is enough inventory to
support the
QtyDue.

Any help would be appreciated.

Chuck

Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com

To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com

system · February 13, 2001, 9:36am

Does anyone have a report that will identify manufactured parts that
do not have methods available to pull into jobs.
Thanks
Chuck

system · February 13, 2001, 12:48pm

Is there anyway using Report Builder that you can tell if methods for
a part number have been approved.
Thanks
Chuck

system · February 13, 2001, 1:38pm

The easiest thing is to run a report that will show only those manufactured
parts that have no labor costs.

Greg Clauser
Lakin General Corp.

-----Original Message-----
From: chuck_metcalf@... [mailto:chuck_metcalf@...]
Sent: Tuesday, February 13, 2001 8:36 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder

Does anyone have a report that will identify manufactured parts that
do not have methods available to pull into jobs.
Thanks
Chuck

system · February 13, 2001, 4:27pm

Use the PartBOM table, filter for approved = Yes. That's about the only way
I can think of doing it, but I'm sure there must be some others.

Check the data dictionary to see if any other of the part tables list
"approved".

Lydia

-----Original Message-----
From: chuck_metcalf@... [mailto:chuck_metcalf@...]
Sent: Tuesday, February 13, 2001 9:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder

Is there anyway using Report Builder that you can tell if methods for
a part number have been approved.
Thanks
Chuck

To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com

system · February 13, 2001, 4:35pm

PartBOM is just a temp table. You'd have to start with partrev.

Lydia Coffman wrote:

>
> Use the PartBOM table, filter for approved = Yes. That's about the only way
> I can think of doing it, but I'm sure there must be some others.
>
> Check the data dictionary to see if any other of the part tables list
> "approved".
>
> Lydia
>
> -----Original Message-----
> From: chuck_metcalf@... [mailto:chuck_metcalf@...]
> Sent: Tuesday, February 13, 2001 9:48 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report Builder
>
> Is there anyway using Report Builder that you can tell if methods for
> a part number have been approved.
> Thanks
> Chuck
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com

system · February 13, 2001, 4:38pm

Absolutely correct. Didn't mean to steer anybody down the wrong path.

Lydia

-----Original Message-----
From: Joe Konecny [mailto:jkonecn@...]
Sent: Tuesday, February 13, 2001 1:36 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Report Builder

PartBOM is just a temp table. You'd have to start with partrev.

Lydia Coffman wrote:

>
> Use the PartBOM table, filter for approved = Yes. That's about the only

way

> I can think of doing it, but I'm sure there must be some others.
>

system · February 26, 2001, 11:37am

In a logical field when the results are Yes, No, ?, how can I pick up
the records that are No and ?. The unknown is because no data has
been entered into the field.
Thanks
Chuck

system · February 26, 2001, 11:45am

At 11:37 AM 2/26/2001 , you wrote:

>In a logical field when the results are Yes, No, ?, how can I pick up
>the records that are No and ?. The unknown is because no data has

Field <> true

-WC

system · February 26, 2001, 11:46am

if result <> YES or

if result = NO or result = ?

Hope this helps.

Tim Care
Electro Chemical Finishing

----- Original Message -----
From: <chuck_metcalf@...>
To: <vantage@yahoogroups.com>
Sent: Monday, February 26, 2001 11:37 AM
Subject: [Vantage] Report Builder

> In a logical field when the results are Yes, No, ?, how can I pick up
> the records that are No and ?. The unknown is because no data has
> been entered into the field.
> Thanks
> Chuck
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

system · February 26, 2001, 12:26pm

Thank You for your quick response, but it doesn't seem to work. I am working
with PartRev.Approved. If the field is blank, nothing shows up. Any other
ideas.
Thanks
Chuck

if result <> YES or

if result = NO or result = ?

Hope this helps.

> In a logical field when the results are Yes, No, ?, how can I pick up
> the records that are No and ?. The unknown is because no data has
> been entered into the field.
> Thanks
> Chuck

system · February 26, 2001, 12:38pm

Chuck,

Try creating a calculated field PR-Apr = IIF(partrev.approved =
?,No,partrev.approved)

Then filter on PR-Apr. The calc would force all unkown values to be a
logical NO while leaving all other values as is.

Todd Anderson

--Original Message-----
From: Charles Metcalf [mailto:chuck_metcalf@...]
Sent: Monday, February 26, 2001 11:26 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder

Thank You for your quick response, but it doesn't seem to work. I am working
with PartRev.Approved. If the field is blank, nothing shows up. Any other
ideas.
Thanks
Chuck

if result <> YES or

if result = NO or result = ?

Hope this helps.

> In a logical field when the results are Yes, No, ?, how can I pick up
> the records that are No and ?. The unknown is because no data has
> been entered into the field.
> Thanks
> Chuck

Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=140160.1334960.2924124.2/D=egroupmail/S=1700007183:N/
A=488695/?http://www.optionetics.com/free_tym.asp> Become a Better Trader!

<http://us.adserver.yahoo.com/l?M=140160.1334960.2924124.2/D=egroupmail/S=17
00007183:N/A=488695/rand=886884757>

To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

system · February 28, 2001, 12:28pm

Is there a way to search a string of text and only have the lines on
a report that have certain text.
Thanks
Chuck

system · February 28, 2001, 12:49pm

I have done this several times using SUBSTRING, INDEX and other functions to
set a logical and then test the logical on a conditioned line. You can have
several conditioned lines in the same group. I have also done this within a
line and set two calculated string fields to either be a value or spaces and
then place them on top of each other so that only the "true" one overprints
the spaces from the other. Handy for conditional bolding or color (red =
negative). Hope one of these are what you were looking for.
-Todd C.

-----Original Message-----
From: chuck_metcalf@... [mailto:chuck_metcalf@...]
Sent: Wednesday, February 28, 2001 11:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder

Is there a way to search a string of text and only have the lines on
a report that have certain text.
Thanks
Chuck

Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=179201.1342935.2933264.2/D=egroupmail/S=1700007183:N/
A=585621/*http://www.egghead.com/category/inv/00000870/03597619.htm?mid=yaho
o_cga153_cs> At Egghead.com...We Mean Business!

<http://us.adserver.yahoo.com/l?M=179201.1342935.2933264.2/D=egroupmail/S=17
00007183:N/A=585621/rand=602854443>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

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

system · February 28, 2001, 1:04pm

How are you doing conditional bolding or color in Report Builder?

Todd Caughey wrote:

>
> I have done this several times using SUBSTRING, INDEX and other functions to
> set a logical and then test the logical on a conditioned line. You can have
> several conditioned lines in the same group. I have also done this within a
> line and set two calculated string fields to either be a value or spaces and
> then place them on top of each other so that only the "true" one overprints
> the spaces from the other. Handy for conditional bolding or color (red =
> negative). Hope one of these are what you were looking for.
> -Todd C.
>
> -----Original Message-----
> From: chuck_metcalf@... [mailto:chuck_metcalf@...]
> Sent: Wednesday, February 28, 2001 11:27 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report Builder
>
> Is there a way to search a string of text and only have the lines on
> a report that have certain text.
> Thanks
> Chuck
>
> Yahoo! Groups Sponsor
>
> <http://rd.yahoo.com/M=179201.1342935.2933264.2/D=egroupmail/S=1700007183:N/
> A=585621/*http://www.egghead.com/category/inv/00000870/03597619.htm?mid=yaho
> o_cga153_cs> At Egghead.com...We Mean Business!
>
> <http://us.adserver.yahoo.com/l?M=179201.1342935.2933264.2/D=egroupmail/S=17
> 00007183:N/A=585621/rand=602854443>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · February 28, 2001, 1:27pm

RB, I noticed one time, allows printing fields over the top of each other.
Often by error and it looks very garbled. If I have a condition I want to
test for and print boldly I create a logical (perhaps PrintBold) and set it
to True. I can then create two calculated string fields for IIF(PrintBold
= True,STRING(value,'-format-'.' ') and the opposite IIF(PrintBold <>
True,STRING(value,'-format-'.' ') I then call one PrtValueBold and the
other PrtValueReg. On the report I format the bold one as bold and place
both fields on top of each other. It makes it a little hard to get decimals
to line up and to see one or the other but only one will print anything and
it will print over spaces (the other field). On the final report you can't
see the spaces even if they are bold :) so it looks OK. Ditto for font
colors instead of (or with) bold. On screen or on color printing this looks
really sharp for pointing out particular data.

-Todd C.

-----Original Message-----
From: Joe Konecny [mailto:jkonecn@...]
Sent: Wednesday, February 28, 2001 12:05 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Report Builder

How are you doing conditional bolding or color in Report Builder?

Todd Caughey wrote:

>
> I have done this several times using SUBSTRING, INDEX and other functions

to

> set a logical and then test the logical on a conditioned line. You can

have

> several conditioned lines in the same group. I have also done this within

a

> line and set two calculated string fields to either be a value or spaces

and

> then place them on top of each other so that only the "true" one

overprints

> the spaces from the other. Handy for conditional bolding or color (red =
> negative). Hope one of these are what you were looking for.
> -Todd C.
>
> -----Original Message-----
> From: chuck_metcalf@... [mailto:chuck_metcalf@...]
> Sent: Wednesday, February 28, 2001 11:27 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report Builder
>
> Is there a way to search a string of text and only have the lines on
> a report that have certain text.
> Thanks
> Chuck
>
> Yahoo! Groups Sponsor
>
> <

http://rd.yahoo.com/M=179201.1342935.2933264.2/D=egroupmail/S=1700007183:N/
<http://rd.yahoo.com/M=179201.1342935.2933264.2/D=egroupmail/S=1700007183:N/

>
> A=585621/*

http://www.egghead.com/category/inv/00000870/03597619.htm?mid=yaho
<http://www.egghead.com/category/inv/00000870/03597619.htm?mid=yaho>

> o_cga153_cs> At Egghead.com...We Mean Business!
>
> <

http://us.adserver.yahoo.com/l?M=179201.1342935.2933264.2/D=egroupmail/S=17
<http://us.adserver.yahoo.com/l?M=179201.1342935.2933264.2/D=egroupmail/S=17

>
> 00007183:N/A=585621/rand=602854443>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> < http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> >

.

>
> [Non-text portions of this message have been removed]
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

<http://docs.yahoo.com/info/terms/>

Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=162801.1342103.2934627.1280005/D=egroupmail/S=1700007
183:N/A=599088/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLer
t_ComputersInternet_Software_WhiteGridTime&t=ad> Click Here to Find Software
Faster
Click Here to Find Software Faster

<http://us.adserver.yahoo.com/l?M=162801.1342103.2934627.1280005/D=egroupmai
l/S=1700007183:N/A=599088/rand=879900813>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

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

system · March 1, 2001, 8:32am

Todd,
I have not had any success in making this formula. This is a typical text
line that I am dealing with.

Tractor MATERIAL: 2024-T42-0063-C F-17.26 + F-20.03 PER MilStd.
CERTIFICATIONS REQUIRED. THANK YOU.

I would like only the text lines that have F-17.26 to print and the info is
randomly spaced.
Any help would be appreciated.
Thanks
Chuck

I have done this several times using SUBSTRING, INDEX and other functions to
set a logical and then test the logical on a conditioned line. You can have
several conditioned lines in the same group. I have also done this within a
line and set two calculated string fields to either be a value or spaces and
then place them on top of each other so that only the "true" one overprints
the spaces from the other. Handy for conditional bolding or color (red =
negative). Hope one of these are what you were looking for.
-Todd C.

Is there a way to search a string of text and only have the lines on
a report that have certain text.
Thanks
Chuck

system · March 1, 2001, 9:19am

1. I loaded the whole message into TestValue (a caluclated field)
2. I created another calculated field: TestPositive:
IIF(INDEX(TestValue,'F-17.26',1) > 0,Yes,No)
Note you could load the string searched for into its own field to make
formula more universal
Such as: IIF(INDEX(TestValue,SearchFor,1) > 0,Yes,No)
3. Create a BandLine in a group, insert what you need into it (fields, text,
etc...)
4. Right click on bandline margin at far left edge to get to bandline
properties (there are other ways too)
5. In properties check mark Print Conditional Field and enter TestPositive
in it and select "Print When Field True"

This will print that line only when the TestValue string has 'F-17.26'
anywhere in it. I use the same test to check for jobs we set up with a T or
C in the ID (tooling jobs) and the SO group is not Engineering - I then
print a warning line on certain reports.

Good luck,
-Todd C.

-----Original Message-----
From: Charles Metcalf [mailto:chuck_metcalf@...]
Sent: Thursday, March 01, 2001 7:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder

Todd,
I have not had any success in making this formula. This is a typical text
line that I am dealing with.

Tractor MATERIAL: 2024-T42-0063-C F-17.26 + F-20.03 PER MilStd.
CERTIFICATIONS REQUIRED. THANK YOU.

I would like only the text lines that have F-17.26 to print and the info is
randomly spaced.
Any help would be appreciated.
Thanks
Chuck

I have done this several times using SUBSTRING, INDEX and other functions to
set a logical and then test the logical on a conditioned line. You can have
several conditioned lines in the same group. I have also done this within a
line and set two calculated string fields to either be a value or spaces and
then place them on top of each other so that only the "true" one overprints
the spaces from the other. Handy for conditional bolding or color (red =
negative). Hope one of these are what you were looking for.
-Todd C.

Is there a way to search a string of text and only have the lines on
a report that have certain text.
Thanks
Chuck

Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=162801.1342103.2934627.1280005/D=egroupmail/S=1700007
183:N/A=599089/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLer
t_ComputersInternet_Software_WhiteGridOptions&t=ad> Click Here to Find
Software Faster
Click Here to Find Software Faster

<http://us.adserver.yahoo.com/l?M=162801.1342103.2934627.1280005/D=egroupmai
l/S=1700007183:N/A=599089/rand=165901064>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

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

system · March 1, 2001, 9:28am

Charles,
Try this: create a calculated field called something like PrintThis using
this formula:

IIF(LOOKUP("F-17.26",Part.Description," ") > 0, True, False)

and then set conditional printing to print when PrintThis = True.
Hope this helps.
================
Steve Sanders
Delta Centrifugal Corp.
-----Original Message-----
From: Charles Metcalf [mailto:chuck_metcalf@...]
Sent: Thursday, March 01, 2001 7:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder

Todd,
I have not had any success in making this formula. This is a typical
text
line that I am dealing with.

Tractor MATERIAL: 2024-T42-0063-C F-17.26 + F-20.03 PER MilStd.
CERTIFICATIONS REQUIRED. THANK YOU.

I would like only the text lines that have F-17.26 to print and the info
is
randomly spaced.
Any help would be appreciated.
Thanks
Chuck

I have done this several times using SUBSTRING, INDEX and other functions
to
set a logical and then test the logical on a conditioned line. You can
have
several conditioned lines in the same group. I have also done this within
a
line and set two calculated string fields to either be a value or spaces
and
then place them on top of each other so that only the "true" one
overprints
the spaces from the other. Handy for conditional bolding or color (red =
negative). Hope one of these are what you were looking for.
-Todd C.

Is there a way to search a string of text and only have the lines on
a report that have certain text.
Thanks
Chuck

Yahoo! Groups Sponsor

Click Here to Find Software Faster

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

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