Zero Balance A/P Invoice

Yahoo Archive
41
George,

I don't think we actually have this report written, but it shouldn't
be to bad to do. On the invoice header table, there are fields for
invoice date and closed date (when paid). Just create a calculated
field that subtracts invoice date from closed date. This should give # of
days to close. Then aggregate by customer the number of days to close
and use an average field. Hope this helps (and works?).

Tim Care
Electro Chemical Finishing

----- Original Message -----
From: "George Brockman II" <gbrockman@...>
To: <vantage@egroups.com>
Sent: Wednesday, November 01, 2000 12:01 PM
Subject: [Vantage] Report Builder


> I have been challenged (politically correct word for 'Get it done or
else') to write a report for on of the VP's. He likes to look @ the invoice
aging on screen, and especially is interested in the 'Avg. Days to Pay'.
>
> Has anyone put together a report that shows 'Avg. Days' to Pay' that they
would be willing to share. It looks to be a fairly tricky calculation, so I
thought I would ask first.
>
> Thanks for any help!!
>
> George Brockman II
> Gasket Engineering
>
>
>
> 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.)
>
42
George,

Go to http://www.egroups.com/files/vantage/ and poke around
our library. There are several A/R reports there, one may
suit your needs.

have fun,
John


> -----Original Message-----
> From: George Brockman II [mailto:gbrockman@...]
> Sent: Wednesday, November 01, 2000 9:02 AM
> To: 'vantage@egroups.com'
> Subject: [Vantage] Report Builder
43
I have a couple of reports that might work for you. They show past dues,
with an automated dunning letter report.

Shirley H. Graver
Systems Administrator
Rubber Associates Inc. (Certified to QS9000/ISO9002)
Cleveland/Akron, Ohio

-----Original Message-----
From: George Brockman II [mailto:gbrockman@...]
Sent: Wednesday, November 01, 2000 12:02 PM
To: 'vantage@egroups.com'
Subject: [Vantage] Report Builder


I have been challenged (politically correct word for 'Get it done or
else') to write a report for on of the VP's. He likes to look @ the invoice
aging on screen, and especially is interested in the 'Avg. Days to Pay'.

Has anyone put together a report that shows 'Avg. Days' to Pay' that they
would be willing to share. It looks to be a fairly tricky calculation, so I
thought I would ask first.

Thanks for any help!!

George Brockman II
Gasket Engineering


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]
44
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.
Thanks
Chuck
45
How do I save a report in report builder so that someone else can
open it in MS Word. I would like to be able to save as a file, then
email it to a remote site. When I follow the directions in the help
file, it doesn't work correct.
Thanks
Chuck
46
All you RB Guru's. I would like to include the memo text on a report
that I have written, but I only want the text to the first carriage
return. Any ideas??
47
Charles -

Create a calculated field based on the memo field.
Use the SUBSTRING function and pull the portion
up to the first carriage return.

HTH,
Calvin
48
Does anyone know a formula for report builder to parse a text string
to the first carriage return.
Thanks
Chuck
49
Chuck,
Here's one I use for Part Descriptions:

SUBSTRING(Part.PartDescription, 1, INDEX(Part.PartDescription, CHR(10)))

HTH
================
Steve Sanders
Delta Centrifugal Corp.

-----Original Message-----
From: Charles Metcalf [mailto:chuck_metcalf@...]
Sent: Thursday, January 04, 2001 7:19 AM
To: vantage@egroups.com
Subject: [Vantage] Report Builder


Does anyone know a formula for report builder to parse a text string
to the first carriage return.
Thanks
Chuck



eGroups Sponsor

12 FREE CDs! Click for Details

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]
50
Steve,

Worked great, Thank You

Chuck

-----Original Message-----
From: Steve Sanders [mailto:ssanders@...]
Sent: Thursday, January 04, 2001 8:25 AM
To: vantage@egroups.com
Subject: RE: [Vantage] Report Builder


Chuck,
Here's one I use for Part Descriptions:

SUBSTRING(Part.PartDescription, 1, INDEX(Part.PartDescription, CHR(10)))

HTH
================
Steve Sanders
Delta Centrifugal Corp.

-----Original Message-----
From: Charles Metcalf [mailto:chuck_metcalf@...]
Sent: Thursday, January 04, 2001 7:19 AM
To: vantage@egroups.com
Subject: [Vantage] Report Builder


Does anyone know a formula for report builder to parse a text string
to the first carriage return.
Thanks
Chuck



eGroups Sponsor

12 FREE CDs! Click for Details

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]


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.)
51
I do not have a lot of Report Builder experience, and have not been
to school. I have been working on a Report Builder report, and almost
have it like I want it. I have one item that I have not been able to
resolve. Is there anyone that is willing to look at what I have done,
and the area I am having the problem with, and try to point me in the
right direction.
Thanks
Chuck
52
I piddle around with RB from time to time, I'll look if you like.

Shirley Graver (End User)
Sys Admin
Rubber Associates


[Non-text portions of this message have been removed]
53
Yes. Forward me your report & I will give it a try.

Patrick J. Winter
Information Services Manager
sSc Specialty Screw Corporation
Vantage 4.00.901

-----Original Message-----
From: Charles Metcalf [mailto:chuck_metcalf@...]
Sent: Thursday, January 04, 2001 12:58 PM
To: vantage@egroups.com
Subject: [Vantage] Report Builder


I do not have a lot of Report Builder experience, and have not been
to school. I have been working on a Report Builder report, and almost
have it like I want it. I have one item that I have not been able to
resolve. Is there anyone that is willing to look at what I have done,
and the area I am having the problem with, and try to point me in the
right direction.
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.)
54
In DCD Classic there was a field called LastOperationWorked. Is there
a similiar field in Vantage. I have not been able to find it.
Thanks
Chuck
55
In DCD Classic there was a field called Last Operation Worked. Is
there a similiar field in Vantage.
Thanks
Chuck
56
Chuck,

Specifically what are you trying to determine ? Having never worked with
Classic I'm not sure what you are asking for.

Todd Anderson

-----Original Message-----
From: Charles Metcalf [mailto:chuck_metcalf@...]
Sent: Thursday, January 11, 2001 1:54 PM
To: vantage@egroups.com
Subject: [Vantage] Report Builder


In DCD Classic there was a field called Last Operation Worked. Is
there a similiar field in Vantage.
Thanks
Chuck




eGroups Sponsor

<http://rd.yahoo.com/M=149861.1280212.2876301.2/D=egroupmail/S=1700007183:N/
A=473697/?http://www.newaydirect.com>

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.)
57
I don't know of a field like that. That doesn't mean there isn't one, but I
haven't seen it.

You could attempt to duplicate this field using report builder and
calculating a field based on the labor Detail dates and times to find the
last operation worked for a specific assembly of job. I think that would be
fairly simple to do if that is what you are looking for.



=============================================
In DCD Classic there was a field called Last Operation Worked. Is
there a similiar field in Vantage.
Thanks
Chuck
58
Todd,

I am trying to find a field that I can put on a status report that will
show where we are on the work order.
Seq Work Center Operation Status
10 40 Draw Material 20 Cut Complete
20 30 Cnc Machine 30 Profile Complete
30 85 Heat Treat 15 Age

In the above example we would know we were through Machine and the next
work center would be heat treat.

Thanks
Chuck



Chuck,

Specifically what are you trying to determine ? Having never worked with
Classic I'm not sure what you are asking for.

Todd Anderson



In DCD Classic there was a field called Last Operation Worked. Is
there a similiar field in Vantage.
Thanks
Chuck
59
Chuck,

Link JOBHEAD to JOBOPER

JOBHEAD.JOBCOMPLETE = 'Yes' indicates that the job is complete
JOBOPER.OPCOMPLETE = 'Yes' indicates that the operation is complete
JOBOPER.SETUPCOMPLETE = 'Yes" indicates that SETUP is complete

etc.

Does this help ?

Todd Anderson

-----Original Message-----
From: Charles Metcalf [mailto:chuck_metcalf@...]
Sent: Thursday, January 11, 2001 2:34 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Report Builder


Todd,

I am trying to find a field that I can put on a status report that will
show where we are on the work order.
Seq Work Center
Operation Status
10 40 Draw Material 20
Cut Complete
20 30 Cnc Machine 30
Profile Complete
30 85 Heat Treat 15 Age

In the above example we would know we were through Machine and the next
work center would be heat treat.

Thanks
Chuck



Chuck,

Specifically what are you trying to determine ? Having never worked with
Classic I'm not sure what you are asking for.

Todd Anderson



In DCD Classic there was a field called Last Operation Worked. Is
there a similiar field in Vantage.
Thanks
Chuck







eGroups Sponsor

<http://rd.yahoo.com/M=168381.1286195.2882029.2/D=egroupmail/S=1700007183:N/
A=539294/?http://subscribe.wsj.com/yahoo> Click here to subscribe.
Click here to subscribe.

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.)
60
There is a field 'OpComplete' on the JobOper table that you could use to get
what you are saying.