Making Custom Fields Available to FinancialForce XL

You can populate custom fields on payable invoices, payable credit notes, sales invoices, sales credit notes, and journals using FinancialForce XL provided you complete the steps set out below. Custom fields on cash entries cannot currently be populated using FinancialForce XL.

Warning:

Make sure you are using the version of FinancialForce XL compatible with your version of FinancialForce Accounting. On the FinancialForce Community, go to App Info - Additional Applications - FinancialForce XL for compatibility information.

The following high-level steps explain how to make custom fields on the supported document types available within FinancialForce XL. If you need more detailed information about how to add custom fields, create integration rules, and use FinancialForce XL please refer to the resources suggested.

1. Add your custom fields to the custom objects for the relevant document type:
   • Journal and Journal Line Item
   • Payable Invoice (the Payable Expense Line Items and Payable Invoice Line Items must be listed)
   • Sales Credit Note and Sales Credit Note Line Item
   • Sales Invoice and Sales Invoice Line Item

   Refer to the Salesforce documentation if you need more information about how to add fields to custom objects.

2. Create an integration rule where your document type objects are the target objects. For example, if Sales Invoice is your Master Target object then Sales Invoice Line Item is your Detail Target object. Do not set source objects on the integration rule.
3. For both the master and detail objects, add your custom fields to the Target Fields grid. Select the For Reading and For Writing checkboxes to allow users to view and edit the custom fields on documents once they are loaded into FinancialForce Accounting.
4. Save the integration rule. See Creating Integration Rules - Type 1 if you need more information about how to create an integration rule to expose custom fields.
5. Now run Microsoft Excel. Go to Add-ins - FinancialForce - Document Input - <document type>, then log in using your Salesforce credentials.
6. On the FinancialForce Document Input <document type> dialog box:
• In the Header panel, click the drop-down in the Data Column to find the custom fields you added to the document header (at step 1) then map them to the appropriate columns in your Microsoft Excel worksheet.
• In the Line Items panel, click the drop-down in the Data Column to find the custom fields you added to the document line item (at step 1) then map them to the appropriate columns in your Microsoft Excel worksheet.

Refer to About FinancialForce XL Plus if you need more information about creating mappings.

Provided that your mappings are set up correctly, when you load your documents into FinancialForce Accounting the custom fields for the relevant document type are populated with the corresponding values from your Microsoft Excel worksheet.