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 laterInformation 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
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
| Goal |
| Solution |
| References |