Importing Freight Lines
AutoInvoice lets you pass freight lines as individual transactions or as references to other transactions. The RA_INTERFACE_LINES, LINK_TO_LINE_ATTRIBUTE1-15, and LINK_TO_LINE_CONTEXT columns 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.
Using AutoAccounting for Freight
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.
Importing Multiple Header Freight Lines
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.
Audit Trail for Consolidated Freight Lines
The log file generated by AutoInvoice will list the following freight attributes for auditing purposes:
- interface_line_id of the freight line chosen for consolidation
- sum of the freight amounts
See Also
Entering Freight Information
Importing Tax Lines
AutoAccounting
Freight Carriers
