Understanding the Freight Update and Report Program
You must run the Freight Update and Report program [select Updates (G49112), Freight Update] before you run the Sales Update (R42800). You can update freight charges by these data selections:
Actual ship date
System dates
Weekly dates
Carrier
Note: The system must run Freight Update and Report in a specific sequence, which you cannot change. If you create a new version with a different data sequence, the system ignores the sequence.
Many companies set up a proof version and a final version of this program. After you run the proof version, you can check for accuracy, make corrections, and then run the final version. The final version updates the general ledger. You must set the appropriate processing option to designate proof and final versions.
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, the system writes information in the Freight Audit History table (F4981), which also contains all freight charge tax information. For both billable and payable charges, records in the Shipment Charges table are deleted and the Shipment Routing Steps table is updated with the information.
For payable charges, the system updates the Account Ledger table (F0911) in the general ledger. If the option for automatic payments is activated, the system updates the Accounts Payable Ledger table (F0411) in the JD Edwards EnterpriseOne Accounts Payable system. On the billable side, the system updates the Sales Order Detail File table (F4211) with the freight charges.
When you run Sales Update, the system creates the revenue entries in the JD Edwards EnterpriseOne Accounts Receivable system and the general ledger from detail lines on the sales orders, including detail lines for nonstock charges for billable freight.
For inbound shipments, the final update creates records for payable collect charges. You can also allocate freight for inbound shipments.