Dear Friends
There is a requirement for which we need to extract a report
Requirement
""Measure the carrieru2019s ability to pick up goods at the warehouse, on time, and measure the warehouse ability to have the items ready on time for collection by the carriers""
Formula
1) Turnaround time = the time between the truck arrives at the warehouse and the time between
it leaves the warehouse
2) % of refused trucks or containers = number of trucks or containers refused / the number of
trucks or containers that arrived at the warehouse gate
3) % on time pick up = collection on time / number of scheduled daily shipments
Friends please suggest me where can i take all the table & field names for developing a new report or any existing report is already available?
Required table & filed names
Company code (production plant or sales and distribution company)
Warehouse
Carrier
Turnaround time
% of refused trucks / containers
% on time pick up in hours
Month
Day
time truck arrival
time truck departure
Turnaround time
number of trucks or containers refused
number of trucks or containers total
% of refused trucks / containers
Number of collection on time
number of scheduled daily shipments
% on time pick up in hours
Regards
Prakash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.