261543
261543 PA-7N5KQW Add weight to EFX Export
Version :
|
Copyright OBS Logistics © 2009
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
Add a default Weight value to the EFX export data if no Weight is attached to the Order in MTS. To ensure that this is not understated I suggest that the default should be 1000kgs multiplied by the Pallet quantity. Alternative is to add a free-text box to the EFX pop-up window which will allow the user to add in a weight at the time of setting the deadline and Rate - Invoke an error window if no weight is added - Value always in KG's
EFX requires an entry in the weight field to process the posting.
Solution
After investigation, the total weight in the EFX export data is currently calculated by summing the weight (SCH_ORDER_LINE.WEIGHT) of all orders on the Trip in the EFX file, at the time the file is created. This may result in nothing being reported in the weight field position of the EFX file, if all orders on the trip do not have a weight entered.
Investigations show that capturing the weight within the EFX Pop-Up, by the user, is not feasible as there is no data element to hold the weight a user entered until the export is created.
Therefore, the total weight that appears in the EFX export data will be calculated at the time the file is created – in the following way:
- All orders loaded on the Trip that appears in the EFX file will be selected
- The weight (SCH_ORDER_LINE.WEIGHT) and RPE (SCH_ORDER_LINE.RPE_QTY) of each order will be checked.
- If the order line has a weight entered then this will be added to a global variable holding the total weight of the trip, to be displayed in the exported data
- If the order line has a weight that is 0.00 or NULL, then a default weight for that particular order will be calculated. This will be calculated by taking the RPE for that order and multiplying it by 1000kgs (To be held in a new system parameter EFX_ DEF_WEIGHT). Therefore if the order is for 3 RPE, then the default weight for that order will be 3000kgs. This weight will then be added to the global variable holding the total weight of the trip
- Once all orders on the trip have been queried, then the global variable holding the total weight of the trip will be output to the EFX file
This calculation will ensure an entry is displayed in the weight field position in the EFX file.
This will require an update to procedure PROCESS_EFX_TRIP_DTL within package INT_MSG.
Below is an example of a Trip with 5 orders loaded on it. 1 of which does not have the weight field entered and 1 that has a weight of 0.00. A breakdown of how the total weight of the trip will be calculated is shown:
Trip MAN-000123456 has:
| Order | RPE | Weight | Calculation | Weight for adding to Total Weight of Trip variable |
1
|
20
|
20000.00
|
N/A | 20000.00
|
2
|
3
|
0.00
|
3 X 1000.00 | 3000.00
|
3
|
1
|
318.00
|
N/A | 318.00
|
4
|
12
|
12000.00
|
N/A | 12000.00
|
5
|
9
|
9 X 1000.00 | 9000.00
| |
| Total Weight of trip to be displayed in EFX file = 44318.00 | ||||
The Total Weight that will be written to the EFX file will be 44318. No decimal places will be shown as they are not included in the current EFX file.
Set-up
Pre-requisites
Carrier of EFX set up in system.
Data
All orders in the EFX export, that do not have a weight, will have one automatically calculated at the time of the EFX file creation. This will be calculated by multiplying the RPE for that order by a kg value held in parameter EFX_DEF_WEIGHT. This will originally get set to 1000 but will be editable via the System Parameters form. Table ADM_SYSTEM_PARAM will be updated to include the following parameter:
| PARAM_NAME | VALUE | DATA_TYPE | MAX_LENGTH | DISPLAYED | USER_MODIFIABLE | DESCRIPTION |
| EFX_DEF_WEIGHT | 1000 | S | 256
|
Y | Y | Default EFX weight per RPE, used in calculation of trip weight for EFX export |
SQL script required to set up new parameter:
Functional Description
EFX Export Layout
The EFX Export file will not change in format and will remain the same as in the sample below:
The calculation used to obtain the trips total weight will change if the entered weight is 0 or no weight is entered by users.
References
| EST-261543 PA-7N5KQW Add weight to EFX Export v1.doc |
Document History
| Initial version | ||||
| Reviewed and Issued |
Authorised by
| Matt Crisford | Development Manager | |
| Suk Sandhu | TMSCC MTS Product Manager |
