Zero Balance A/P Invoice

I export reports to excel and access, is there anyway to compare on
file to another to see the changes.
Thanks
Chuck
Does anybody have a report that combines the General Ledger Report with the
Inventory/WIP Account Reconcilliation Report? It's cumbersome to have to
keep bouncing between the two reports to see GL account activity.

Thank-you in advance
Linda
I am creating a report where in the filter I am specifying a date range.
How would I get that date range to show up in the report header as part of
the title?

Erica A. Steffens
System Administrator
Jerneen Micro Medical Technologies Inc.
ESteffens@...
Try the following. I keep this as a notepad file and cut/paste into cacal
and agregate fields each time I need it. You might need to play with the
starting points for initial search. This is NOT based on the RANGE filter
because I don't use that for performance reasons. ! indicates a comment I
have included. Use FromDate and ToDate in heading.

-------------------------------------- text file
---------------------------------
PrtFilter = Report-Filter() ! (system function)

ParseFilter = Minimum(PrtFilter) ! must pass thru aggregate due to indirect
use of function

! In the following adjust the starting point (60) as needed depending on the
filters
! and the position of the first date test

Start-From: INDEX(ParseFilter,'equal to',60) + 9
Start-To: INDEX(ParseFilter,'equal to',Start-From) + 9
FromDate: SUBSTRING(ParseFilter,Start-From,10)
ToDate: SUBSTRING(ParseFilter,Start-to,10)
-----------------------------end text
------------------------------------------

Todd C.
Harvey Vogel Mfg. Co.



-----Original Message-----
From: Erica Steffens [mailto:ESteffens@...]
Sent: Thursday, March 08, 2001 3:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder


I am creating a report where in the filter I am specifying a date range.
How would I get that date range to show up in the report header as part of
the title?

Erica A. Steffens
System Administrator
Jerneen Micro Medical Technologies Inc.
ESteffens@...



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=162801.1342103.2934627/D=egroupmail/S=1700007183:N/A=
599088/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_Comput
ersInternet_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/D=egroupmail/S=1700
007183:N/A=599088/rand=735212547>

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]
Erica
I include the report filter in the summary section of my reports. That
would include the date and other filter information. To do this I
create a calculated field "Filter" = ReportFilter( ) and then insert it in
the summary.

I also include a field that has the path and report name. When
someone comes in and says this report says "This report is wrong." I
have a starting point.

HTH

RRD



On 8 Mar 2001, at 15:41, Erica Steffens wrote:

I am creating a report where in the filter I am
specifying a date range.
How would I get that date range to show up in the
report header as part of
the title?

Erica A. Steffens
System Administrator
Jerneen Micro Medical Technologies Inc.
ESteffens@...



Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com
Need some help from all the Report Builder gurus.

Writing a report which links the InvcMisc table to the InvcHead table in order to subtract the InvcMisc.MiscAmt field from the InvcHead.InvoiceAmt field if the InvcMisc.MiscCode is 'S&H' or 'FREI'.

I am also gathering costs from the InvcDtl table using the Unit cost fields.

However, if there are 2 or more entries in the InvcMisc table for the InvcHead entry, then I get 2 or more detail records, thereby inflating my costs by a factor of 2 or more.

If I try filtering out all but the 'S&H' and 'FREI' codes, then I miss any other invoices which have miscellaneous charges. Is there a way to determine if there are more than 1 InvcMisc entries for a Invchead entry?

Thanks.

Jerry Brunner
Quala-Die, Inc.
1250 Brusselles Street
St. Marys, PA 15857
814.781.6280


[Non-text portions of this message have been removed]
I have used a multi step process to get around this. First create a Sum
where Count ExtPrice Reset by Line(I think...you will have to play around
with how you have it grouped). Then create a Function which says if Count
is = 1, then ExtPrice, else 0. Then your next Sum is to Total your new
function. (when I create an alter-ego of a field name I put a 'f' in front
of the name...kinda like faux ExtPrice...would be labled fExtPrice) Another
Function needs to be created to make all the Counts > 1 to be equal to Zero.
Once you are certain that you have all the above totaling correctly, go into
your line properties to suppress all 0's with that field name.

Sorry this isn't better written...but I'm buried in our Fiscal Year end.
Hope this helps...it took me months of learning RB to come up with it.

-----Original Message-----
From: Jerry Brunner [SMTP:jerry-qualadie@...]
Sent: Tuesday, March 13, 2001 10:50 AM
To: Vantage
Subject: [Vantage] Report Builder

Need some help from all the Report Builder gurus.

Writing a report which links the InvcMisc table to the InvcHead
table in order to subtract the InvcMisc.MiscAmt field from the
InvcHead.InvoiceAmt field if the InvcMisc.MiscCode is 'S&H' or 'FREI'.

I am also gathering costs from the InvcDtl table using the Unit cost
fields.

However, if there are 2 or more entries in the InvcMisc table for
the InvcHead entry, then I get 2 or more detail records, thereby inflating
my costs by a factor of 2 or more.

If I try filtering out all but the 'S&H' and 'FREI' codes, then I
miss any other invoices which have miscellaneous charges. Is there a way to
determine if there are more than 1 InvcMisc entries for a Invchead entry?

Thanks.

Jerry Brunner
Quala-Die, Inc.
1250 Brusselles Street
St. Marys, PA 15857
814.781.6280


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


------------------------ Yahoo! Groups Sponsor



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Jerry,

We were looking for the same thing. You have to look at it more than one
may. To get the total Misc. charge on an invoice the we did an aggregate
calculation that is Total(TotalMiscChrg, InvoiceNum, InvoiceLine, Pre-pass)
this calculation is put on an Group header line for InvoiceNum. If you want
the freight charges backed out of the Total Invoice Amount you need to
create another couple of calculated fields. Our freight codes begin with
"SH" so we did a calculated field called SH were IF(misc code begins
"SH",1,2) then do a calculated field SHVALUE IF(SH = 1,MiscAmt,0) this gives
value only when the SH is equal to 1. Then do an aggregate calcution called
TOTSHVAL Total(SHVALUE, InvoiceNum, Every, Pre-pass) . You can now subtract
that field from the Invoice Amount to give you the invoice amount less
shipping. What you have to watch for is grouping and sorting. You really
need to look at each invoice number as a group not a record. HTH.

Jim Frice

-----Original Message-----
From: Jerry Brunner [mailto:jerry-qualadie@...]
Sent: Tuesday, March 13, 2001 10:50 AM
To: Vantage
Subject: [Vantage] Report Builder

Need some help from all the Report Builder gurus.

Writing a report which links the InvcMisc table to the InvcHead table in
order to subtract the InvcMisc.MiscAmt field from the InvcHead.InvoiceAmt
field if the InvcMisc.MiscCode is 'S&H' or 'FREI'.

I am also gathering costs from the InvcDtl table using the Unit cost fields.

However, if there are 2 or more entries in the InvcMisc table for the
InvcHead entry, then I get 2 or more detail records, thereby inflating my
costs by a factor of 2 or more.

If I try filtering out all but the 'S&H' and 'FREI' codes, then I miss any
other invoices which have miscellaneous charges. Is there a way to
determine if there are more than 1 InvcMisc entries for a Invchead entry?

Thanks.

Jerry Brunner
Quala-Die, Inc.
1250 Brusselles Street
St. Marys, PA 15857
814.781.6280


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





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Jerry
I think the link should be InvHed to InvDtl using company and
InvNum. The InvDtl to InvMisc using company, InvNum and
InvLine. Make that join a "left outer" so you get InvDtl records that
don't have Misc charges. Once you have a left outer join don't filter
on the right table(s) (in this case InvMisc) or the left outer closes to
an inner. The only records that get through the filter have an
InvMisc record.

If you want to aggregate InvDtl fields sort and group on InvNum and
InvLine. Then use the "Options" button when setting up the
aggregate to accumulate with every InvLine. Your calculations can
be done in the group footer.

For the Misc records instead of using a filter use a calculated field
that has "IIF(MiscCode = "S&H" OR MiscCode = "FREI",
MiscAmt, 0 )" in the formula. When you total this per InvLine or
InvNum you should get the numbers you're looking for.


On 13 Mar 2001, at 11:49, Jerry Brunner wrote:

Need some help from all the Report Builder gurus.

Writing a report which links the InvcMisc table to the
InvcHead table in order to subtract the
InvcMisc.MiscAmt field from the InvcHead.InvoiceAmt
field if the InvcMisc.MiscCode is 'S&H' or 'FREI'.

I am also gathering costs from the InvcDtl table using
the Unit cost fields.

However, if there are 2 or more entries in the
InvcMisc table for the InvcHead entry, then I get 2 or
more detail records, thereby inflating my costs by a
factor of 2 or more.

If I try filtering out all but the 'S&H' and 'FREI'
codes, then I miss any other invoices which have
miscellaneous charges. Is there a way to determine if
there are more than 1 InvcMisc entries for a Invchead
entry?

Thanks.

Jerry Brunner
Quala-Die, Inc.
1250 Brusselles Street
St. Marys, PA 15857
814.781.6280


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



Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com
I run a product for comparing files called "Visual Difference" it is by
Mortice Kern Systems Inc. and it is in their "MKS Tool Kit" product. Its
great for comparing reports and for comparing vantage source code files for
maintaining your mods or looking at patches.

Patrick
sSc Specialty Screw Corp.

-----Original Message-----
From: chuck_metcalf@... [mailto:chuck_metcalf@...]
Sent: Thursday, March 08, 2001 9:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder


I export reports to excel and access, is there anyway to compare on
file to another to see the changes.
Thanks
Chuck





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Thank You

-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Wednesday, March 14, 2001 8:10 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Report Builder


I run a product for comparing files called "Visual Difference" it is by
Mortice Kern Systems Inc. and it is in their "MKS Tool Kit" product. Its
great for comparing reports and for comparing vantage source code files for
maintaining your mods or looking at patches.

Patrick
sSc Specialty Screw Corp.

-----Original Message-----
From: chuck_metcalf@... [mailto:chuck_metcalf@...]
Sent: Thursday, March 08, 2001 9:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder


I export reports to excel and access, is there anyway to compare on
file to another to see the changes.
Thanks
Chuck





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Patrick
Can you compare Excel Files
Chuck

-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Wednesday, March 14, 2001 8:10 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Report Builder


I run a product for comparing files called "Visual Difference" it is by
Mortice Kern Systems Inc. and it is in their "MKS Tool Kit" product. Its
great for comparing reports and for comparing vantage source code files for
maintaining your mods or looking at patches.

Patrick
sSc Specialty Screw Corp.

-----Original Message-----
From: chuck_metcalf@... [mailto:chuck_metcalf@...]
Sent: Thursday, March 08, 2001 9:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder


I export reports to excel and access, is there anyway to compare on
file to another to see the changes.
Thanks
Chuck





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
No, I also checked AutoVue's compare feature but it doesn't work for excel.

-----Original Message-----
From: Charles Metcalf [mailto:chuck_metcalf@...]
Sent: Wednesday, March 14, 2001 11:31 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Builder


Patrick
Can you compare Excel Files
Chuck

-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Wednesday, March 14, 2001 8:10 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Report Builder


I run a product for comparing files called "Visual Difference" it is by
Mortice Kern Systems Inc. and it is in their "MKS Tool Kit" product. Its
great for comparing reports and for comparing vantage source code files for
maintaining your mods or looking at patches.

Patrick
sSc Specialty Screw Corp.

-----Original Message-----
From: chuck_metcalf@... [mailto:chuck_metcalf@...]
Sent: Thursday, March 08, 2001 9:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder


I export reports to excel and access, is there anyway to compare on
file to another to see the changes.
Thanks
Chuck





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/





Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Thanks to all who answered my last question!

Now for an easy one. Is there a way to insert variable text into the header of a report. I am specifically thinking of text such as "Report Date from xx/xx/xx to xx/xx/xx.

Thanks.

Jerry Brunner
Quala-Die, Inc.
1250 Brusselles Street
St. Marys, PA 15857
814.781.6280


[Non-text portions of this message have been removed]
What we generally do is put the date as the first
field in the filter, and then create a formula field for
the Filter. Then put that field at the top or bottom of
the report, and format it only to show the number of
characters that display the date.

Tim Care
Electro Chemical Finishing
----- Original Message -----
From: "Jerry Brunner" <jerry-qualadie@...>
To: "Vantage" <vantage@yahoogroups.com>
Sent: Thursday, March 15, 2001 10:14 AM
Subject: [Vantage] Report Builder


> Thanks to all who answered my last question!
>
> Now for an easy one. Is there a way to insert variable text into the
header of a report. I am specifically thinking of text such as "Report Date
from xx/xx/xx to xx/xx/xx.
>
> Thanks.
>
> Jerry Brunner
> Quala-Die, Inc.
> 1250 Brusselles Street
> St. Marys, PA 15857
> 814.781.6280
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
Jerry,

Another possibility is to use the minimum and maximum aggregate calculation
say on the invoice date. The problem with this is if you are using period as
a filter and someone backdates something but posts to the current period.
HTH.

Jim Frice

> -----Original Message-----
> From: Jerry Brunner [mailto:jerry-qualadie@...]
> Sent: Thursday, March 15, 2001 9:15 AM
> To: Vantage
> Subject: [Vantage] Report Builder
>
>
> Thanks to all who answered my last question!
>
> Now for an easy one. Is there a way to insert variable text into
> the header of a report. I am specifically thinking of text such
> as "Report Date from xx/xx/xx to xx/xx/xx.
>
> Thanks.
>
> Jerry Brunner
> Quala-Die, Inc.
> 1250 Brusselles Street
> St. Marys, PA 15857
> 814.781.6280
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
I set up calculated fields like "Today() - 45" and then filter or fill
buckets on those fields. If you put those fields in the header with the
right text you should have what you want.

On 15 Mar 2001, at 10:14, Jerry Brunner wrote:

Thanks to all who answered my last question!

Now for an easy one. Is there a way to insert
variable text into the header of a report. I am
specifically thinking of text such as "Report Date
from xx/xx/xx to xx/xx/xx.

Thanks.

Jerry Brunner
Quala-Die, Inc.
1250 Brusselles Street
St. Marys, PA 15857
814.781.6280


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



Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com
What field do I put on the report builder to identify the person that
printed the report.

Thanks

Chuck
Does anyone in the group have a procedure on building a menu item from
reports built in RB??
I look forward to any insight.


Vantage 5.0
NTSBS
Win 98se Workstations


Best Regards,

Pablo Garza
Dix Metals, Inc.

pgarza@...
Do you mean that you want to have a report builder report be a menu item in Vantage?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Pablo Garza
To: 'vantage@yahoogroups.com'
Sent: Tuesday, October 09, 2001 2:34 PM
Subject: [Vantage] Report Builder


Does anyone in the group have a procedure on building a menu item from
reports built in RB??
I look forward to any insight.


Vantage 5.0
NTSBS
Win 98se Workstations


Best Regards,

Pablo Garza
Dix Metals, Inc.

pgarza@...




Yahoo! Groups Sponsor



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

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



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