Eric Lehti
VIP Member
The existing functionality in JDE described below has worked for 9 years and I was hopeful that A92 or you have a solution that is better than the resolution described below.
For the past nine years, at A73 release: When creating an order for LTL shipments, the Sales Order entry person must manually add up the weights for all line items, then apply those weights to the correct Freight Class.
In 4210 header screen, Press F14 key and enter Freight information into F4314 file.
e.g. 4 records in V401 screen (F4314 Sales Text file)
cl50-86#'s
cl70-147#'s
cl100-66#'s
cl55-13#'s
User enters the class and total weight in the notes section of the order. Besides the time and effort involved, it leads to errors due to miscalculation and misclassification of items. It is desired to do this process automatically, creating ‘T’ line type line items for each class with associated total weights
DELIVERABLE:
Revise logic in P4211. The field IMSHCN will be populated by item with the correct freight classification. The UDC will be created to include these freight classes: 50, 55, 60, 70, 80, 100, 200. Updating the item master with this information will allow every sales order item to populate with the proper code in the field SDSHCN.
At the completion of order entry, but before the ‘Y’ is taken to accept the order, multiply the item quantity (SDUORG) * Weight (SDITWT) for each item = Total Item Weight. Sum the Total Item Weights of each by Item Class. Then create new line items for each class that has a total and is not present on the sales order. Each class should be associated with a reserved line number, i.e.,
50 = line 601, 55 = line 602, 60= line 603, etc. The line type is ‘T’ for text and the opening status should be 520/525.
For order changes apply the same logic as above but do not change status, update total weights and add any new lines as needed.
The freight class calculation should be complete when the ‘Y’ is taken at order entry to accept the order or change.
Freight Class Lines should print on all documents except the invoice.
For the past nine years, at A73 release: When creating an order for LTL shipments, the Sales Order entry person must manually add up the weights for all line items, then apply those weights to the correct Freight Class.
In 4210 header screen, Press F14 key and enter Freight information into F4314 file.
e.g. 4 records in V401 screen (F4314 Sales Text file)
cl50-86#'s
cl70-147#'s
cl100-66#'s
cl55-13#'s
User enters the class and total weight in the notes section of the order. Besides the time and effort involved, it leads to errors due to miscalculation and misclassification of items. It is desired to do this process automatically, creating ‘T’ line type line items for each class with associated total weights
DELIVERABLE:
Revise logic in P4211. The field IMSHCN will be populated by item with the correct freight classification. The UDC will be created to include these freight classes: 50, 55, 60, 70, 80, 100, 200. Updating the item master with this information will allow every sales order item to populate with the proper code in the field SDSHCN.
At the completion of order entry, but before the ‘Y’ is taken to accept the order, multiply the item quantity (SDUORG) * Weight (SDITWT) for each item = Total Item Weight. Sum the Total Item Weights of each by Item Class. Then create new line items for each class that has a total and is not present on the sales order. Each class should be associated with a reserved line number, i.e.,
50 = line 601, 55 = line 602, 60= line 603, etc. The line type is ‘T’ for text and the opening status should be 520/525.
For order changes apply the same logic as above but do not change status, update total weights and add any new lines as needed.
The freight class calculation should be complete when the ‘Y’ is taken at order entry to accept the order or change.
Freight Class Lines should print on all documents except the invoice.
