My Oracle Support Banner

How to display description on Invoice different than FREIGHT? (Doc ID 1464083.1)

Last updated on AUGUST 19, 2021

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.


Want to select an Item other than Item Type 'Freight', so that Autoaccounting will use Revenue account from AR Transaction Type during Invoicing.
If we use Freight Item type, Auto Invoice is using Freight account from AR Transaction Type based on the Item Type

Our Requirement is to apply Boxing charges as Charge On Sales Order and Interface it to AR as a Revenue line with Revenue Account. We are able to achieve this by setting up System Parameter 'Invoice Freight As Revenue' to 'Yes'. On the AR Transaction it is showing up with Description as 'Freight'. We want to see this description as Boxing Charge.

That's why we want to assign item called 'Boxing Charge' to the system parameter 'Inventory Item for Freight'. This field is not accepting any Item other than Freight Item Type. We can create Boxing Charge Item as 'Freight Item, but it is hitting the Freight account during Auto Invoicing. We want this account to be Revenue Account

Sample order was created with no value in OM Syste Parameter 'Inventory Item for Freight'
and 'Invoice Freight as Revenue' set to 'Yes' . In the Receivalbe Interface table, see a description as 'FREIGHT' for the second line without any Inventory Item.

Excerpt from output of:

select * from RA_INTERFACE_LINES_ALL    where line_type = 'LINE'   
and   interface_line_context = 'ORDER ENTRY' and sales_order = '136186'


0 Order Management 2023 LINE Plate Cover USD
0 Order Management 2023 LINE Freight USD

 Can we change this description ?


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

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