My Oracle Support Banner

E1: 49: Freight Update/Freight to Match/Transportation Accounting FAQs (R4981, P4981, P4314, P4205) (Doc ID 1454747.1)

Last updated on MAY 22, 2018

Applies to:

JD Edwards EnterpriseOne Transportation Management - Version XE and later
Information in this document applies to any platform.

Purpose

This document contains the answers to a number of frequently asked questions regarding Freight Update/Freight to Match and Accounting entries within the Transportation module.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Freight Update (R4981)
 Question 1 - For billable adjustment/billable charges, a user can create a non-stock sales order to bill for the extra freight charges and this will not create any extra shipment number.  An Invoice can be generated and sales update can be performed to the customer ledger and create journal entries.
After creating a non stock sales order for billable charges as above, can a Billable Adjustment still be done through Work with freight audit history (P4981) as per the above entry. The purpose is to capture billable adjustment in F4981 for reporting purpose, is there any impact.
 Question 2 – What is the purpose of the Item Cost update processing option behind the Freight Update (R4981) program?
 Question 3 - Instead of running the Freight Update (R4981) process, is it possible to Freight Update 'on the fly' per any shipment being ship confirmed?  Instead of running the report, printing, verifying and then updating, can freight update be run as part of Ship Confirm (P4205)?
 Question 4 - Where is the next number located for the Original Document Number (ODOC) in the P4981 Freight history that is generated by the R4981 Freight Update?
 Question 5 - What determines the document company (GlKCO) on a freight update GL Transactions?
 Question 6 – Why would payable freight details not be combined into one pay item when the payable freight detail (PFSD) is unchecked in the Carrier Master (P4906)?
 Question 7 - User is manually adding shipping charges within the P4945 program.  Once that order runs through the R4981 Freight Update program the system deletes the freight charges from the F4945 table and there are no resulting updates to the F4981 table.  We would like the manual charges to end up in the F4981 along with the appropriate journal in the F0911.  How can that be accomplished?
 Question 8 - The F4981 FHUKID Field isn't always populated by Freight Update (R4981).  What is the purpose of this field, how it should be populated and the risk if left to zero?
 Question 9 - How can a reversal of a freight voucher be performed after Freight Update (R4981) was run?
 Question 10 - Error "Fetch from Table Failed" occurs when  attempting to do an adjustment in P4981 for a payable accrual?
 Freight to Match
 Question 1 - How are freight voucher matching accounting entries generated when there is an exchange rate variance at the time the P4314 application is executed, and also at R09801 posting time?
 Question 2 - At freight to match, the tax area is not populated correctly – what drives this field being populated?
 Question 3 - When trying to record a distribution voucher for both receipt and freight lines, error message "G/L Interface Flag Mismatch" Error Id "44A8" is received.
 Question 4 - Is there a way to delete the payable record in the F4981 so it cannot be vouchered? The shipment was mistakenly routed to a wrong carrier and then approved, confirmed and ran through freight update. When receiving the invoice, it was from a different carrier that was paid by creating a manual voucher.
 Question 5 - The client is not seeing their F0411 summarized when they adjust the freight to match amount.  Their steps to duplicate are the following:  The run the shipment through freight update without using autopay.  They go into the P4314 to match the freight.  When the select the freight to pay, they take the row exit to adjust the freight amount.  After doing this, they complete the process, but when they inquire on the F0411 record, they see two entries, as opposed to one.  The processing options behind the P4314 are setup to allow the records to summarize.
 Question 6: Does the Tolerance functionality (application P4322) work with Freight to Match?
 Transportation Accounting
 Question 1 - Trying to book a freight variance in a purchase order that has been created through transportation by taking the row exit to Line Amounts, but this is not working.  What is the correct way to do this?
 Question 2 - What is the purpose of the Freight AAI 4922 Freight Expense?
 Question 3 - If the Branch Plant field is blank on the DMAAI 4922 and no flexible accounting is set up, where does the Business Unit get pulled from for this AAI?
 Question 4 - What is DMAAI 4233 used for and why would customers receive errors related to it if they have never used it?
 Question 5 - Can the freight variance (AAI 4922) be allocated to items on a shipment based on item GL class and weight?
 Question 6:  What are the AAIs being called when using Work With Freight Audit History in P4981 to make an adjustment to the freight voucher?
 Question 7:  When should AAI 4922 be used for freight variance, e.g. at Voucher Match or Freight Audit History Adjustment?
 Question 8:  Does Flexible Accounting work with Freight Update (R4981)?
 Question 9:  Freight charges not displayed for return orders, why?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.