I need to import or export accounting information on a requisition, invoice, or invoice reconciliation document.

To export accounting information:

1. Select the line items to include in the export.
2. Click Export Accounting.
3. On the Export Accounting Distributions page, enter the minimum number of accounting splits per line item.
4. Click OK.

To update the accounting information in the Microsoft Excel spreadsheet:

1. In column F, change the split accounting type by selecting Percentage, Amount, or Quantity from the pull-down menu. Make sure all lines in that column are the same to avoid errors.
2. Update only the column that corresponds to your selection: column H for Percentage, column I for Quantity, and column J for Amount.
3. Make any updates to the accounting values, beginning in column K.
4. Save another copy of the spreadsheet under a different name.
5. Click Cancel on the Export Accounting Distributions page to return to the document.
6. Click Import Accounting, then click OK.

This feature requires the following two parameters to be enabled in Intelligent Configuration Manager:

• Application.Procure.AllowAccountingExportAndImport
• Application.Approvable.AllowSplitAccounting

What are the requirements for importing or exporting accounting information on documents?

Core Procurement > Core Administration > Core Accounting
Purchasing > Requisition/Order Accounting