luFund lookup table (Finance)

Owned by Former user (Deleted)
Last updated: Jun 22, 2020 by Richard Kennedy (Unlicensed)
2 min read

Description

The luFund lookup table defines funds that your organisation collects pledges and donations for. For example, the Building Fund.

It is used in conjunction with the Sub Ledgers sub-tab of Synergetic Financial Configuration to set up the automatic allocation of electronic banking payments against pledge receipts. See Configuring automatic pledge allocations in the Debtors manual.

Example





Fields

Field

Description

Code

Unique code for the fund.

Description

Description of the fund.

GLCode

General ledger code the fund is allocated to.

GLSubAllocationCode

General ledger sub-allocation code the fund is allocated to.

DefaultAppealCode

The default appeal code of the fund.

FundCode

The fund code.

ActiveFlag

Select if this fund can be used in your organisation.

AutoPledgeAllocate BPAYFlag

Correspond with options from electronic banking to specify which payment types can automatically allocate to pledges.

AutoPledgeAllocate DirectDebitFlag / AutoPledgeAllocate CreditCardFlag / AutoPledgeAllocate OtherFlag

Select to automatically assign excess debtor payments from the payment type to any pledges towards this fund.
Payments are only assigned to pledges:

  • of this type of fund
  • when any outstanding debtor payments with the same or earlier statement date have been paid in full.

    The amount assigned to pledges is equal to the to the next instalment amount of the oldest pledge of this fund.
    Note: Payments are assigned based on their Statement Date. If there is an outstanding debtor payment with a statement date before the pledge statement date, the debtor account is paid first and the excess is allocated to the pledge up to the amount of the outstanding instalment amount.
    Any excess payment after the pledge payment is allocated to:
  • the next instalment of any newer pledges of this type of fund
  • the debtor's Prepaid or Overpayment account.
    Note: The allocation of pledge receipts from electronic banking must also be configured using the Allow Auto Allocation of Pledge Receipts for Electronic Banking on the Synergetic Financial Configuration - Debtors - Sub Ledgers sub-tab. See Synergetic Financial Configuration - Debtors tab - Sub Ledgers sub-tab.

AutoPledgeReceipt AllocationPriority

Order in which funds are automatically allocated to from electronic payments. Funds with higher values in this field are allocated first.
Note: The automatic allocation order also depends on fee categories and statement dates. See Configuring pledge allocations for electronic banking in the Debtors manual.

ModifiedDate

Date and time the lookup table entry was last modified.

ModifiedUser

User that last modified the lookup table entry.