If the ship by date on the release hasn't changed from the ship by date on the line, it will use OrderDtl.ReqDate instead.
--- In vantage@yahoogroups.com, Mike Abell <mabell@...> wrote:
>
> I have it working now for the most part but I am perplexed on what the "ship
> by" field on the canned Vantage "scheduled shipments" report is actually
> using. I thought it was OrderRel.Reqdate but I don't think it is as some of
> the data on our canned report shows a "blank" or "null" ship by date and I
> cannot find the matching data in the Vantage OrderRel.Reqdate that matches
> the "blank" data. Any ideas on what field in Vantage the "ship by" data is
> referring to?? Thanks!
>
>
>
> Mike..
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Miguel Santillan
> Sent: Monday, August 06, 2012 2:34 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Reverse engineer Vantage Scheduled Shipments report
>
>
>
>
>
> This is what we use... plus some crystal filtering and formulas
>
> for each OrderHed no-lock where OrderHed.OpenOrder = TRUE And
> OrderHed.OrderHeld = False , each OrderDtl no-lock where (OrderHed.Company =
> OrderDtl.Company and OrderHed.OrderNum = OrderDtl.OrderNum ) and
> OrderDtl.CheckBox01 = FALSE , each OrderRel no-lock where (OrderDtl.Company
> = OrderRel.Company and OrderDtl.OrderNum = OrderRel.OrderNum and
> OrderDtl.OrderLine = OrderRel.OrderLine ) and OrderRel.OpenRelease = TRUE
> And OrderRel.CheckBox03 = FALSE , each JobProd no-lock , each Customer
> no-lock , each JobHead no-lock , each JobPart no-lock outer-join where
> (JobHead.Company = JobPart.Company and JobHead.JobNum = JobPart.JobNum ) ,
> each Warehse no-lock , each PartWhse no-lock outer-join where
> (Warehse.Company = PartWhse.Company and Warehse.WarehouseCode =
> PartWhse.WarehouseCode ) and PartWhse.PartNum = OrderRel.PartNum And
> PartWhse.WarehouseCode = OrderRel.WarehouseCode , each Part no-lock , each
> PartClass no-lock where (Part.Company = PartClass.Company and Part.ClassID =
> PartClass.ClassID ) where (OrderHed.Company = Customer.Company and
> OrderHed.CustNum = Customer.CustNum ) outer-join where (JobProd.Company =
> JobHead.Company and JobProd.JobNum = JobHead.JobNum ) outer-join where
> (OrderDtl.Company = JobProd.Company and OrderDtl.OrderNum = JobProd.OrderNum
> and OrderDtl.OrderLine = JobProd.OrderLine ) outer-join where
> (OrderRel.Company = Warehse.Company and OrderRel.WarehouseCode =
> Warehse.WarehouseCode ) where (OrderDtl.Company = Part.Company and
> OrderDtl.PartNum = Part.PartNum ) by OrderRel.ReqDate by OrderRel.NeedByDate
> by Customer.CustID by OrderRel.OrderNum by OrderDtl.LineDesc .
>
> Miguel A. Santillan
> Compass Components, Inc.
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of flexial_ma
> Sent: Monday, August 06, 2012 12:12 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Reverse engineer Vantage Scheduled Shipments report
>
> I'm needing to reverse engineer and create my own version of the Vantage
> 8.03 scheduled shipments report. Looking in the Report data definition, it
> references some table called OMR50 which isn't a real Vantage table and
> seems to be some sort of combination of 3 or 4 vantage tables. Can anyone
> tell me how to figure out what tables this report is using so I can create
> my own version of it. Thanks!
>
> Mike..
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>