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

Last updated on JUNE 28, 2017

Applies to:

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

Goal



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'

 

INTERFACE_LINE_ATTRIBUTE8 BATCH_SOURCE_NAME SET_OF_BOOKS_ID LINE_TYPE DESCRIPTION CURRENCY_CODE
0 Order Management 2023 LINE Plate Cover USD
0 Order Management 2023 LINE Freight USD


 Can we change this description ?

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms