How do I import or export accounting information on documents?

You must edit the requisition, invoice, or invoice reconciliation to import and export accounting information:

1. Select the line item(s) 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.

Save a copy of the Microsoft Excel spreadsheet that opens before making changes.

To update the accounting information within the Excel spreadsheet:

1. In column F, change the split accounting type by selecting Percentage, Amount, or Quantity from the pull-down menu. Make sure that all of the lines in that column are the same to avoid errors.
2. Update only the column which corresponds to your selection (column H is for Percentage, I is for Quantity, and J is 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, which takes you back to the document.
6. Click Import Accounting, then click OK.

Select the line item and click Edit to verify the accounting information updates.

This feature requires two parameters to be enabled.

The max amount of decimal precision that is acceptable in the application is 10.

Invoicing > Invoice Reconciliation
Purchasing > Requisition/Order Accounting