Landed Cost Line Classification of Payables Invoices from File-Based Data Import

Designate invoice lines in the Payables Invoice Import Spreadsheet to link landed cost charge references, helping Payables users easily mark them as landed costs during bulk processing.

When you import invoices using the Payables Invoice Import Spreadsheet, you can now set the Landed Cost Enabled flag on each invoice line. If the flag is set to Y, the line is treated as a landed cost line and is passed to Landed Cost Management for variance calculation and allocation. The flag accepts Y, N, or a null value (treated as N). The column is hidden by default in the spreadsheet and defaults to null, so lines are unchanged unless you explicitly set the flag. During import, existing validation rules for enabling/disabling Landed Cost Enabled Flag will still apply. If Landed Cost Enabled Flag on a line is marked as Y but also meets any condition that disables landed cost handling (for example, matched to a PO/receipt, prepayment line, cancelled invoice), the import job rejects the line with the standard error messages. No additional REST calls or manual updates are needed to update Landed Cost Enabled Flag after import from Payables Invoice Import FBDI Spreadsheet.

  • Simplifies Payables invoice processing with the introduction of the ‘Landed Cost Enabled’ attribute in the Payables Invoice Import FBDI template.
  • Enables Payables users to efficiently mark invoice lines as landed cost during bulk invoice import.
  • Eliminates the need for manual intervention or subsequent REST-based updates to set the landed cost flag within Payables invoices, streamlining operations.

Steps to enable and configure

You don't need to do anything to enable this feature.

Tips and considerations

  • The new Landed Cost Enabled column appears in the AP_INVOICE_LINES_INTERFACE sheet of the Payables Standard Invoice Import FBDI template.
  • Acceptable values are YN, or left blank (treated as N). The default is blank.
  • The column is hidden by default; you may need to unhide it to set values.
  • Import validations that previously prevented landed cost processing still apply. If a line is flagged Y but also meets any disabling condition (e.g., matched to PO/receipt, prepayment, withholding tax, cancelled, accounted, or discarded), the import will be rejected.
  • No changes to security or privileges are required.
  • This feature enables only the Landed Cost flag on Payables Invoice lines and does not facilitate the association or allocation of landed cost charges to Payables invoice lines.

Access requirements

No new access requirements.