Count Group Variance Report?

Yahoo Archive
1
I have a dashboard built on the following query with calculated cost & quantity variances if that would be of interest to you.

for each CountExp where ( CountExp.ExpectedQty <> CountExp.TotCountedQty) no-lock , each PartCost where (CountExp.Company = PartCost.Company and CountExp.PartNum = PartCost.PartNum) no-lock , each Part where (CountExp.Company = Part.Company and CountExp.PartNum = Part.PartNum) no-lock , each Plant where (PartCost.Company = Plant.Company and PartCost.CostID = Plant.PlantCostID) no-lock , each PartClass where (Part.Company = PartClass.Company and Part.ClassID = PartClass.ClassID) no-lock .

--- In vantage@yahoogroups.com, "Nigel Kerley" <nigel.kerley@...> wrote:
>
> I have a very basic Crystal Report I can send you, if you like. It's an ODBC report though, not BAQ, but it can still be exported.
>
> The fields you need are CountExp.ExpectedQty, CountExp.ActivityBeforeCount and CountExp.TotCountedQty.
>
> The same table holds the Warehouse and Bin codes of the counted stock. And you may want to link in CountGrp for the Count Header details.
>
>
> HTH,
>
> Nigel.
>
>
> --- In vantage@yahoogroups.com, "Norman Hutchins" <nhutchins@> wrote:
> >
> > Hello,
> >
> >
> >
> > We are currently doing a full year end inventory and I'm looking at getting
> > the information from the variance report into excel to do some analyzing of
> > the data. Would anyone have a crystal report, excel with ODBC, or something
> > that might replace the awful progress report, or maybe at least tables that
> > are involved if anyone knows...
> >
> >
> >
> > Thanks,
> >
> >
> >
> > Norman Hutchins
> >
> > Network Administrator
> >
> > Howell Laboratories, Inc.
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
2
Hello,



We are currently doing a full year end inventory and I'm looking at getting
the information from the variance report into excel to do some analyzing of
the data. Would anyone have a crystal report, excel with ODBC, or something
that might replace the awful progress report, or maybe at least tables that
are involved if anyone knows...



Thanks,



Norman Hutchins

Network Administrator

Howell Laboratories, Inc.





[Non-text portions of this message have been removed]
3
I have a very basic Crystal Report I can send you, if you like. It's an ODBC report though, not BAQ, but it can still be exported.

The fields you need are CountExp.ExpectedQty, CountExp.ActivityBeforeCount and CountExp.TotCountedQty.

The same table holds the Warehouse and Bin codes of the counted stock. And you may want to link in CountGrp for the Count Header details.


HTH,

Nigel.


--- In vantage@yahoogroups.com, "Norman Hutchins" <nhutchins@...> wrote:
>
> Hello,
>
>
>
> We are currently doing a full year end inventory and I'm looking at getting
> the information from the variance report into excel to do some analyzing of
> the data. Would anyone have a crystal report, excel with ODBC, or something
> that might replace the awful progress report, or maybe at least tables that
> are involved if anyone knows...
>
>
>
> Thanks,
>
>
>
> Norman Hutchins
>
> Network Administrator
>
> Howell Laboratories, Inc.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>