Open topic with navigation

Making Custom Fields Available to FinancialForce XL

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

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:
   • Sales Invoice and Sales Invoice Line Item
   • Sales Credit Note and Sales Credit Note Line Item
   • Journal and Journal Line Item 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 the FinancialForce XL Help 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.

© Copyright 2009-2018 FinancialForce.com, inc. All rights reserved.
Various trademarks held by their respective owners.

Open topic with navigation