13 Using Cost Object Tracking in Transportation

This chapter contains the following topics:

13.1 Understanding Cost Object Tracking in Transportation

You can capture cost object information when you update freight. Updating freight creates records of final payable and billable freight charges for shipments and loads. Payable charges are written to the general ledger by means of a journal entry and to the accounts payable for auto-pay carriers by means of a pay item. Billable charges are added to one or more orders on the shipment or load (depending on the customer freight preference). Freight is summarized at the charge code level.

After a shipment is created, the shipment-related information is stored in the Shipment Header (F4215) and the Shipment Routing Steps (F4941) tables. All freight charge information is stored in the Shipment Charges table (F4945). When you update freight, information from these three tables is written to the Freight Audit History table (F4981). For both billable and payable charges, the record in the Shipment Charges table is deleted, and the Shipment Routing Steps table is updated with the information run for both billable and payable table freight.

For payable charges, the Account Ledger table (F0911) is updated in the general ledger; and if the auto pay flag is on, then the Accounts Payable Ledger table (F0411) is updated in the JD Edwards EnterpriseOne Accounts Payable system. On the billable side, the Sales Order Detail File table (F4211) is updated with the freight charges. If the processing option for flex accounting is on, the system searches the flex accounting rules and populates the cost object fields accordingly.

To proportionately allocate shipment freight charges to each item that contributes to the total weight and volume of the shipment, you must have activated the freight allocations for the appropriate charge codes that you assign to rates.


Note:

You must activate the processing option for flex accounting in the Freight Update (R4981) program.

13.2 Using Cost Object Tracking in Transportation

Select Updates (G49112), Freight Update.

You can capture cost object information when you update freight. Updating freight creates records of final payable and billable freight charges for shipments and loads. Payable charges are written to the general ledger by means of a journal entry and to the accounts payable for auto-pay carriers by means of a pay item. Billable charges are added to one or more orders on the shipment or load (depending on the customer freight preference). Freight is summarized at the charge code level.

After a shipment is created, the shipment-related information is stored in the Shipment Header (F4215) and the Shipment Routing Steps (F4941) tables. All freight charge information is stored in the Shipment Charges table (F4945). When you update freight, information from these three tables is written to the Freight Audit History table (F4981). For both billable and payable charges, the record in the Shipment Charges table is deleted, and the Shipment Routing Steps table is updated with the information run for both billable and payable table freight.

For payable charges, the Account Ledger table (F0911) is updated in the general ledger; and if the auto pay flag is on, then the Accounts Payable Ledger table (F0411) is updated in the JD Edwards EnterpriseOne Accounts Payable system. On the billable side, the Sales Order Detail File table (F4211) is updated with the freight charges. If the processing option for flex accounting is on, the system searches the flex accounting rules and populates the cost object fields accordingly.

To proportionately allocate shipment freight charges to each item that contributes to the total weight and volume of the shipment, you must have activated the freight allocations for the appropriate charge codes that you assign to rates.


Note:

You must activate the processing option for flex accounting in the Freight Update (R4981) program.