Tessitura controls

Create a Tessitura control

1. In the Navigation pane, highlight the Accounts Receivable > Setup > Tessitura Controls folder.
2. Click . The New Tessitura Control window opens.

   

3. Enter a unique Code for the Tessitura control.
4. Enter a Description of the Tessitura control.
5. In the Base URL field, enter the path for connecting to the Tessitura REST website.
6. In the Procedure ID field, enter the number associated with the Tessitura custom procedure which returns selected postings.
7. In the Activity section in the Customer field, select the customer to use for imported AR invoices.
8. In the Charge Invoice Type field, select the invoice type to use for imported charge invoices.
9. In the Credit Invoice Type field, select the invoice type to use for imported credit invoices.
10. In the ARCode field, select the ARCode for invoice detail to use on imported invoices.
11. In the Note Type field, select the note type to associate with imported invoices.

Expressions

The remaining fields on this tab use expressions to derive the values which appear in the results. You can combine literals, portions of the Tessitura GL account, and/or portions of the deposit date to build these values.

Two tokens are available to embed in these expressions: <GLAccount> and <Deposit Date>.

You can extract a portion of a token by adding special notation to the end of the token. In parentheses, type the starting position within the value that you want to show, followed by a colon (:), followed by the number of characters to show. For example, given the date 11/30/2018, <Deposit Date(7:4)> produces a result of "2018".



Examples

Sales Account

<GLAccount(2:1)><GLAccount(4:2)>-<GLAccount(8:1)>-00-00000-A

Given an account 12-456-89, this expression builds an ActivityHD GL account of "245-8-00-00000-A".

Invoice Batch

Dep <Deposit Date>

Given a deposit date of "11/30/18", this expression builds a value of "Dep 11/30/2018".

12. In the Invoice Description field, enter an expression for building the invoice description on the imported invoices.
13. In the Invoice Batch field, enter an expression for building the AR invoice batch code.
14. In the GL Batch field, enter an expression for building the AR invoice GL batch code.
15. In the Sales Account field, enter an expression to convert the Tessitura GL account to the invoice detail sales account.
16. In the Bank Account field, enter an expression to convert the bank account from the Tessitura feed to the ActivityHD bank account for receipts posting.
17. Select the Payment Methods tab.

    

18. For each payment method you need to set up, provide the following information in the Payment Methods table:
    1. In the Payment Method column, enter the code for the Tessitura payment method you are defining. These codes are dictated by Tessitura.
    2. In the Payment Method Name column, enter a descriptive name for the payment method.
    3. In the Receipt Type column, select the receipt type to associate with the payment method.
    4. In the Deposit Type column, select the deposit type to associate with the payment method.
19. Select the Extra GL tab.

    

20. For each extra GL definition you need to set up, provide the following information in the Extra GL table:
    1. In the Invoice Sales column, select the deferred revenue account. When the import process finds a match on this account, an extra GL entry is automatically created that debits this account and credits the extra GL account specified in the adjacent column.
    2. In the Revenue column, select the actual revenue account. This is the account that is credited when the import process automatically creates the extra GL entry.
21. Select the Exclusions tab.

    

22. For each range of postings you need to exclude from import processing, provide the following information in the Exclusions table:
    1. Enter the first posting of the range of postings to exclude in the Begin Post # column.
    2. Enter the last posting of the range of postings to exclude in the End Post # column.
    3. In the Description field, explain why the range of postings is excluded.
23. When you finish, save the new control.