I'm sorry. I didn't mean to imply that version 8 would help solve
the existing problem. All I meant was that I wouldn't invest a lot
in developing a more permanent solution if I was planning to upgrade,
potentially forcing me to do it all again.
the existing problem. All I meant was that I wouldn't invest a lot
in developing a more permanent solution if I was planning to upgrade,
potentially forcing me to do it all again.
--- In vantage@yahoogroups.com, "amfabllc" <amfab@...> wrote:
>
> Great information, Thank you! You said if it will be awhile before
> we go to 8... what will 8 offer that could take care of this
problem?
>
> Thank you,
> Ann
>
> --- In vantage@yahoogroups.com, "al2trace" <allen.larsen@> wrote:
>
> Your problem is not easy to solve. The problem is with that last
> join "QuoteDtl - QuoteQty - L - Co, Quoteum, QuoteLine"
> Your data is doubling (tripling, quadrupling, ...) depending on how
> many price breaks you have. The ideal solution would have been to
> find a field in the OrderDtl table called "QuoteQtyNum" so that you
> could do a one to one join between OrderDtl and QuoteQty. As it
is,
> you are forced to do a one to many join.
>
> I do not think you can fix this in Report Builder. What you would
> need to do is group by company, orderNum, Part. The aggregate
> quantity at that level would then need to be compared to the
> quantity
> in the QuoteQty table. It could be done in Progress code but not
> Report Builder.
>
> What I stupidly do in this situation is the "brute force method".
I
> would export the aggregate data from orderdtl and orderHed to Excel
> or Access. Then would I export the results of your current query.
> Excel might be your best bet because your "join" between the two
> queries is not a "=" but a "last one less than" than Excel is more
> likely to get.
>
> If the users like the report, request it on a regular basis, and it
> will be awhile before you to to version 8, then I would consider
> writing it in Progress. Using the "brute force method" initially,
> allows you to find all the quirks in the data first.
>
> --- In vantage@yahoogroups.com, "amfabllc" <amfab@> wrote:
>
> It appears to me that I am getting 1 full set of quoted quantities
> for each SO line (which may be what I am actually asking for, but
> not what I want). I would think that if it were invcdtl repeating,
> I would get ie. one here and five there depending on the number of
> invoices that had been involved. I am getting one set of price
> breaks (ie. 1,5,10,25,50,100,250,500)for each SO line.
>
> All I really want to do is suppress the set of quoted quantity
> price
> breaks- all except the first set preferrably. It doesn't matter
> where the quoted price breaks print, just want it to print 1 time.
> Am I over looking something?
>
> Thanks much!!
> Ann
>
> --- In vantage@yahoogroups.com, "Bruce Butler" <bbutler@> wrote:
>
> You are probably getting extra details for orders with multiple
> invoices against them (InvcDtl).
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> I am writing a report that compares the price that was entered in
> the order or the invoice, comparing it to the quoted qty.
> The reason I am doing this is that often when one of our
> customers orders a part, he may order 5 lines of the same part
> number with different due dates. ie, 5 lines at 100 pcs. each, we
> give him a 500 pc price. We need to verify the comparision for
> various reasons. The order could have 200 lines of various
> quantities of various part numbers - no rule of thumb.
>
> I have a report builder report that doesn't look too bad except I
> have data repeating. I think it needs to be grouped but I am at a
> loss on what to group.
>
> Table joins:
> OrderDtl - OrderHed - I - Co, OrderNum
> OrderDtl - QuoteDtl - L - Co, Quotenum,QuoteLine
> OrderDtl - InvcDtl - L - Co, Ordernum, OrderLine
> QuoteDtl - QuoteQty - L - Co, Quoteum, QuoteLine
> Sort&Grouped by:
> OrderDtl.OrderNum - a
> OrderDtl.PartNum - a
> OrderDtl.OrderLine - a
> QuoteQty.OurQty - a
> Filter:
> Company matches (co name)
> OrderDtl.Ordernum=(one of the so numbers)
> OnReport:
> Title, Page Header,
> 1GH-OrderNum (OrderNum field),
> 2GH-PartNum (PartNum field,Rev field),
> 3GH-OrderLine (OrderNum, PoNum, POline, LineDesc, OrderQty,
> UnitPrice, OpenLine, Reference)
> 4GH-OurQuantity (QuoteNum, QuoteLine, Expired, Quoted, OurQty,
> UnitPrice)
> Aggregate on the 2GF-PartNum: Total, OrderQty, PartNum, OrderLne,
> Final Pass (tells me how many of each part number was ordered on
> the SO)
> In between each SO Line for each part number, all of the quoted
> quatities repeat themselves. It wastes lots of paper.
>
> If anyone has any suggestions, I'm all ears!!
>
> Also, if you know of a good thread on 8.03 user comments, sent me
> a date it was active and I will look it up.
>
> Thank you very much!
> Ann Rohyans
> Vantage version 5.00.329
>
> > > > [Non-text portions of this message have been removed]
>