280938
280938 - DU-896KHA/ Changes to Trip Costs
Copyright OBS Logistics © 2010
The information contained herein is the property of OBS Logistics and is supplied without liability for errors or omissions. No part may be reproduced or used except as authorised by contract or other written permission. The copyright and foregoing restriction on reproduction and use extend to all media in which the information may be embodied
FUNCTIONAL OVERVIEW
Client Requirement
Unfortunately the user request to be able to enter Trip Cost at planned status has caused an additional problem, with the way costs and profits are displayed. Currently C-TMS has two cost fields 1.Carrier Cost 2.Trip Cost (Sum of all Carrier Costs for a cross docked trip) The profit field is calculated by taking Trip Cost from Trip Revenue (see below)
The cost column displayed above is the Trip Cost, in the Execution Screen the user can enter a Carrier Cost by double click functionality over the Trip Cost Column. Currently if the user enters a Carrier Cost using this functionality neither that cost or the correct profit will display until the status is set to accepted (Trip cost is calculated when status changed to accepted as it is known to slow the system down looking for contracts). There are three options : 1. Leave the system as it is accepting that unless status is set to Accepted the information displayed in the Trip Cost and Profit columns will be blank (even when a Carrier Cost has been entered). 2. Add a Carrier Cost column into the configurable layout options, move the cost entry functionality to the Carrier Cost column. Carrier Cost will then display immediately although due to the way the system calculates Trip Cost, the Trip Cost and resulting profit this will still not be displayed until the status is changed to Accepted. 3. As Option 2 but Profit is calculated prior to change to Accepted Status (profit calculated by current information entered for orders Cross Docked through a Internal Consol Centres revenue will be updated by contracts when status is changed to Accepted) Option 2 would require an extra 0.75 days development charge Option 3 would require an extra 1.5 days development charge (includes the development charge for Option 2) It would not be possible to have option three without option two. We want Option 3 please
Solution
Add Carrier Cost field into the configurable layout for the main Execution screen. To add the field we must also create a sort and filter field, as with other amount fields, the filter will not be available. The field will be added to the configurable block next to the existing cost fields.
When a new field is added to the configurable block, any existing configurations will be manipulated to include the added field. This is because the field will be added into the middle of the block and not at the end.
From this field users will be able to create a fast track cost payment against the trip. As previously, the user will only be able to add the payment if the cost is currently zero.
Once a cost has been entered, this will be reflected in the Carrier Cost field on the main Execution screen when the fast track pop-up is closed. The amount will also be displayed in the main cost field and the profit/ loss field will be re-calculated to reflect the new cost.
The data on the main execution screen will be updated automatically and will not require any actions from the user.
As the user selects on the Fast Track Payment screen, the refresh query will automatically run.
New code will be added to the run query trigger. If the trip is Status PLANNED, the Cost field and Profit field will be updated to include any CARRIER COST values which have been applied to the trip. Once the Trip is set to Accepted and above, the existing FINANCIAL functionality will incorporate the Carrier Cost into the Total Cost and Profit of the trip.
REFERENCES
Not Available
DOCUMENT HISTORY
Not Available
