AutoInvoice lets you pass freight lines as individual transactions or as references to other transactions. The columns LINK_TO_LINE_ATTRIBUTE1-15 and LINK_TO_LINE_CONTEXT in RA_INTERFACE_LINES_ALL determine whether a freight line will become an individual freight-only transaction or part of another transaction.
To pass a freight line that refers to another transaction line, enter the Line Transaction Flexfield of the transaction to which you want this freight line to refer. To pass freight lines, RA_INTERFACE_LINES.LINE_TYPE must be set to 'FREIGHT'.
To pass a freight-only line, enter a Line Transaction Flexfield that refers to a 'dummy' line. This 'dummy' line must have a value in RA_INTERFACE_LINES.MEMO_LINE_ID or RA_INTERFACE_LINES.MEMO_LINE_NAME, and the memo line must have AR_MEMO_LINES.LINE_TYPE = 'FREIGHT'. In addition, the Quantity, Unit Price, and Amount fields for this line must be null or zero.
If AutoAccounting for Freight is based on Standard Lines, you will not be able to import invoices with header level freight. All freight lines in this case must be associated with a standard line for AutoAccounting to determine the account. If the transaction has a line type of "LINE" with an inventory item of freight ("FRT"), AutoAccounting will use the accounting rules for the freight type account rather than the revenue type account.
AutoInvoice ensures that there is at most one freight line for an imported invoice, or at most one freight line per transaction line, but not both. If multiple header freight lines applied to one invoice have been imported, AutoInvoice will validate that all of the freight lines apply to the same freight account and consolidate them to one line. This consolidated freight line will be the only freight line for this invoice that is passed to the core receivables tables. If all of the freight lines do not apply to the same freight account, AutoInvoice will reject the invoice.
The log file generated by AutoInvoice will list the following freight attributes for auditing purposes:
customer_trx_id
interface_line_id of the freight line chosen for consolidation
sum of the freight amounts
If you want to calculate tax on freight for orders created in Oracle Order Management, set the profile option Tax: Inventory Item for Freight to Yes. If you do this, Order Management creates a line item of type 'Line' on the invoice for the freight amount (in the Ship Confirm window) so that it can be taxed. When you print the invoice from Receivables, the tax amount appears as the last invoice line with the description 'Freight.'
If Tax: Inventory Item for Freight is set to Yes, also set the profile option Tax: Invoice Freight as Revenue to Yes. This profile option enables you to control the rate of tax applied to freight. To do this, define an inventory item of User Type "Freight" and set this option to your new inventory item. When Oracle Order Management identifies this inventory item, it uses the tax code assigned to it or any item exceptions to control the applicable tax rates and accounting for the freight service. On the printed invoice, Receivables derives the description of the freight line from the inventory item that you defined, rather than the default description 'Freight'.