Zero Balance A/P Invoice

Yahoo Archive
21
I know I read before how to do this and thought I had saved it, but alas I
can't come up with it. We are trying to add the Customer name to a report
that is compiled from JobOper and JobAsmbl tables. We linked to the JobHead
table then to the OrdDtl to the OrdHead to the Customer. This gives us the
company name but it also duplicates each line of the report. What am I
doing wrong. We tried left outer joins but got the same results.

We are on 4.0

Kathy Hambleton
Electron Energy Corporation
22
Simple question - How do you create a group footer band line?

Thanks in advance,

Dean
23
Dean,

First you have to assign a Group. Go up to Database then Group Order(it is
also the blue, yellow and red icon if you have it on your toolbar) then
select New and choose which field you want to Group by. When this is done
you can Create a Band Line and choose different type open the pull down menu
and you will see the different types of lines available for either a header
or footer depending on your needs.

Jim Frice

> -----Original Message-----
> From: Dean Brown, Jr. [mailto:dbrownjr@...]
> Sent: Friday, August 18, 2000 9:58 AM
> To: vantage@egroups.com
> Subject: [Vantage] Report Builder
>
>
> Simple question - How do you create a group footer band line?
>
> Thanks in advance,
>
> Dean
>
24
I am trying to write a report that will give me just the last
operation of a job that was clocked into. Something like:

Part Number Job Number Last Operation Worked

Any help would be appreciated.

Chuck Metcalf
25
Can anyone tell me how to get report builder to include Advance Billing
amounts on the Sales by State report.
I have tried everything that I can think of and am getting nowhere. Any
help would be appreciated.


Marvin R. Myers
Computer Systems Engineer
marvin@...
717-252-3667 ext. 231
26
I am working with the part bin report that is posted on the One List. I
can't seem to get
the report to print 0 on hand qty records. Does anyone know why this
happens. I know that
I am probably overlooking something simple.


Marvin R. Myers
Computer Systems Engineer
marvin@...
717-252-3667 ext. 231
27
Marvin,
We just worked with Vantage support concerning the issue of receiving 0
onhand qty for another report and this was the response:
Unfortunately, a part number has to have a least 1 in its quantity to be
able to pull info for a report. Report cannot be run. Best way to simulate
is to run a report of all inventory, also run a report of inventory with
qtys on hand and compare the two.
Hope this helps! We thought we were over looking something simple also! If
anyone knows some way to get that answer, please pass it on.

Kimberly Maxwell
Westwood Precision, Inc.
PH: 425-347-1303 Ext. 41
Fax: 425-353-8945
email: kimberly.maxwell@...
www.westwoodprecision.com

-----Original Message-----
I am working with the part bin report that is posted on the One List. I
can't seem to get
the report to print 0 on hand qty records. Does anyone know why this
happens. I know that
I am probably overlooking something simple.


Marvin R. Myers
Computer Systems Engineer
marvin@...
717-252-3667 ext. 231
28
If you start with the part table, and then join to
the Part Bin table with a left out join, you will
get all parts, whether or not they have an entry
in the Part Bin Table. The ones that do not
have a Part Bin record will have a ? for unknown
value. You can then set the unknown value to show
0 instead of ?.

Tim Care
Electro Chemical Finishing
----- Original Message -----
From: "Marvin Myers" <marvin@...>
To: <vantage@egroups.com>
Sent: Friday, September 22, 2000 10:14 AM
Subject: [Vantage] Report Builder


>
> I am working with the part bin report that is posted on the One List. I
> can't seem to get
> the report to print 0 on hand qty records. Does anyone know why this
> happens. I know that
> I am probably overlooking something simple.
>
>
> Marvin R. Myers
> Computer Systems Engineer
> marvin@...
> 717-252-3667 ext. 231
>
>
> 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.)
>
29
All you Report Builder Gurus out there - help! Help! Help!

I am trying to build a report sorted by SchedCode that lists all open jobs
(for stock and linked) that gives the following information:

JobNum ReqDueDate SchedCode OpenQty PartNum ExtPrice ExtCost Name

My problems are:

1. I get a separate line for each link in the Job. (I need one line per job
with a total open quantity.)
2. If the job is built to stock I get a ? in the ExtPrice, ExtCost, & Name
fields.
3. I am getting unreleased & non-engineered jobs even if I filter them out.

It seems as if I fix one problem two new ones crop up.

(Open Qty = JobProd.ProdQty - JobProd.ReceivedQty-JobProd.ShippedQty)


Thanks in advance.
Kathleen Harrington
SPS Non-Ferrous
Kharrington@...
30
Not guru class but getting there. A couple ideas off top of head.
I have to make some assumptions about your links so I may be way off base.
But some things to consider anyway which might shed some light on the issues
-
for #1 - Is master table JOBPROD and then linked to relevant tables in a
chain (one to another) or all linked to JOBPROD?
The linking is probably the key to this issue
Try doing all reporting in a group footer and none in detail
#2 - the above may also reduce the unknowns and get data for the
to-stock releases
#3 - if the link is the issue (JOBPROD not master) it may also affect
the filter
A couple times I have found I needed the details section for agregation but
did not want it to print so I suppress it by creating a calculated field
called NoPrint and set it to always be false and in the section control to
print only when NoPrint is true. This helps things to add up for the footer
(my main report line) as each release is enountered but not have to print
anything. It should roll up the totals for the footer.
Hope this is some help or sparks an idea.

-Todd Caughey
Harvey Vogel Mfg. Co.
Woodbury, MN

-----Original Message-----
From: Kathleen Harrington [mailto:kharrington@...]
Sent: Friday, September 22, 2000 2:33 PM
To: VANTAGE@...
Subject: [Vantage] Report Builder



<http://click.egroups.com/1/8974/13/_/411782/_/969651248/>


<http://adimg.egroups.com/img/8974/13/_/411782/_/969651248/WarningCollectibl
es468x602E.gif>
<http://www.egroups.com/> eGroups My
<http://www.egroups.com/mygroups> Groups | vantage Main
<http://www.egroups.com/group/vantage> Page | Start a new
<http://click.egroups.com/1/8150/13/_/411782/_/969651249/> group!


All you Report Builder Gurus out there - help! Help! Help!

I am trying to build a report sorted by SchedCode that lists all open jobs
(for stock and linked) that gives the following information:

JobNum ReqDueDate SchedCode OpenQty PartNum
ExtPrice ExtCost Name

My problems are:

1. I get a separate line for each link in the Job. (I need one line per job
with a total open quantity.)
2. If the job is built to stock I get a ? in the ExtPrice, ExtCost, & Name
fields.
3. I am getting unreleased & non-engineered jobs even if I filter them out.

It seems as if I fix one problem two new ones crop up.

(Open Qty = JobProd.ProdQty - JobProd.ReceivedQty-JobProd.ShippedQty)


Thanks in advance.
Kathleen Harrington
SPS Non-Ferrous
Kharrington@...






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.)




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

FTI: You can suppress the record lines on the report without doing the
calculation, by going to 'Properties','Record Layout', and checking off
'suppress all record lines'.

Sarah
32
Had not seen that before. Does it still treat them as if they are being
processed and supressed or does it skip agregation? I have had some strange
totalling before. I might try a couple simple reports each way to confirm.
Certainly the properties method is easier than creating yet another
calculated field. BTW - sorry about Crystal cross over - s/b Records
section not Details.
Thanks,
-Todd

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, September 22, 2000 3:35 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Report Builder



<http://click.egroups.com/1/9155/13/_/411782/_/969654207/>


<http://adimg.egroups.com/img/9155/13/_/411782/_/969654207/468x60_hate_searc
hing5.gif>
<http://www.egroups.com/> eGroups My
<http://www.egroups.com/mygroups> Groups | vantage Main
<http://www.egroups.com/group/vantage> Page | Start a new
<http://click.egroups.com/1/8150/13/_/411782/_/969654208/> group!


Todd,

FTI: You can suppress the record lines on the report without doing the
calculation, by going to 'Properties','Record Layout', and checking off
'suppress all record lines'.

Sarah

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.)




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

It still treats them the same way, the totals all come out right, I use it
in lots of reports.

Sarah
34
I am attempting to write a report in report builder. I have modified
an existing report and cannot get it to work. I have not had any
formal training and would like to talk to someone who has some
experience.
35
Gary,

If you email me the report and explain the problem, I'll try to help you
out.

Sarah
36
Does anyone have a report builder report that will show whether a job
made or lost money, based on sales price compared against actual
costs associated with a job such as such as labor, burden, material,
subcontracting.
Thanks
Chuck
37
I will be uploading a job cost report to egroups, hopefully this is what u need.
The name of the file is Sales Vs Costs-Closed Jobs.Prl.
----- Original Message -----
From: Charles Metcalf
To: vantage@egroups.com
Sent: Wednesday, October 11, 2000 12:48 PM
Subject: [Vantage] Report Builder


Does anyone have a report builder report that will show whether a job
made or lost money, based on sales price compared against actual
costs associated with a job such as such as labor, burden, material,
subcontracting.
Thanks
Chuck


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]
38
Thank You
Chuck


I will be uploading a job cost report to egroups, hopefully this is what u
need.
The name of the file is Sales Vs Costs-Closed Jobs.Prl.
----- Original Message -----
From: Charles Metcalf
To: vantage@egroups.com
Sent: Wednesday, October 11, 2000 12:48 PM
Subject: [Vantage] Report Builder


Does anyone have a report builder report that will show whether a job
made or lost money, based on sales price compared against actual
costs associated with a job such as such as labor, burden, material,
subcontracting.
Thanks
Chuck


eGroups Sponsor
39
Charles,

If you cannot upload the report for some reason, please send me a copy.

Thanks,
Steve

-----Original Message-----
From: Dennis Houghton [SMTP:dennis@...]
Sent: Thursday, October 12, 2000 9:16 AM
To: vantage@egroups.com
Subject: Re: [Vantage] Report Builder

I will be uploading a job cost report to egroups, hopefully this
is what u need.
The name of the file is Sales Vs Costs-Closed Jobs.Prl.
----- Original Message -----
From: Charles Metcalf
To: vantage@egroups.com
Sent: Wednesday, October 11, 2000 12:48 PM
Subject: [Vantage] Report Builder


Does anyone have a report builder report that will show
whether a job
made or lost money, based on sales price compared against
actual
costs associated with a job such as such as labor, burden,
material,
subcontracting.
Thanks
Chuck


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]


-------------------------- 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.)
40
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