I'm looking for an on time ship complete to dock report that will
give me all the open order lines that have shipped as well as that
have not shipped.
I need to measure the difference and compare the values between the
[JobOper.DueDate (Date automatically calculated by the system that
the order must be on the dock to meet the customer NeedByDate) and
ShipHead.ShipDate] and [OrderRel.ReqDate (Date entered in the system
that the order needs to be at the dock to meet the Customers
NeedByDate) and the ShipHead.ShipDate]. I would like know which one
is the preferred method of measuring on time delivery to the dock.
I need to be able to measure:
The number open order lines that have not shipped.
The number of order lines that shipped early and by how many days.
The number of order lines that shipped on time.
The number of order lines shipped late and by how many days
Total order lines shipped for the period.
Total order lines shipped early for the period
Total order line shipped on time for the period
Total order line shipped late for the period
% on time ship complete
Other needed information is:
Customer Name
Sales order number
Order line number
Job number
The customer part number (Our part number)
Order line qty
Reqdate
Due date
Ship qty
Ship date
Days late early (Calc)reqdate-shipdate
Days late early (Calc)duedate-shipdate
UnitPrice
I have not been able to link the JobOper table the ShipHead table and
get reliable data back out or join error messages.
I have modified the OTS report with O.K. results but really need an
expert to look over what I have and if it makes sense.
If you have a report you can send me that would be great. Any
suggestions on joining ShipHead and JobOper.
Thanks in advance
Jim
give me all the open order lines that have shipped as well as that
have not shipped.
I need to measure the difference and compare the values between the
[JobOper.DueDate (Date automatically calculated by the system that
the order must be on the dock to meet the customer NeedByDate) and
ShipHead.ShipDate] and [OrderRel.ReqDate (Date entered in the system
that the order needs to be at the dock to meet the Customers
NeedByDate) and the ShipHead.ShipDate]. I would like know which one
is the preferred method of measuring on time delivery to the dock.
I need to be able to measure:
The number open order lines that have not shipped.
The number of order lines that shipped early and by how many days.
The number of order lines that shipped on time.
The number of order lines shipped late and by how many days
Total order lines shipped for the period.
Total order lines shipped early for the period
Total order line shipped on time for the period
Total order line shipped late for the period
% on time ship complete
Other needed information is:
Customer Name
Sales order number
Order line number
Job number
The customer part number (Our part number)
Order line qty
Reqdate
Due date
Ship qty
Ship date
Days late early (Calc)reqdate-shipdate
Days late early (Calc)duedate-shipdate
UnitPrice
I have not been able to link the JobOper table the ShipHead table and
get reliable data back out or join error messages.
I have modified the OTS report with O.K. results but really need an
expert to look over what I have and if it makes sense.
If you have a report you can send me that would be great. Any
suggestions on joining ShipHead and JobOper.
Thanks in advance
Jim