Previous icon

Next icon

luFund lookup table

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

luFund part 1

luFund part 2

luFund part 3

Fields

Field

Description

Code

Unique code for the fund.

Description

Description of the fund.

GLCode

General ledger code the fund is allocated to.

GLSubAllocation
Code

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

DefaultAppeal
Code

The default appeal code of the fund.

FundCode

The fund code.

ActiveFlag

Select if this fund can be used in your organisation.

AutoPledge
Allocate BPAYFlag

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

AutoPledge
Allocate DirectDebitFlag / AutoPledge
Allocate CreditCardFlag / AutoPledge
Allocate 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.

AutoPledge
Receipt 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.

Last modified: 29/09/2014 2:57:45 PM

See Also

Maintaining finance lookup tables

luAssetCategory lookup table

luBankCashflowGroup lookup table

luCreditorSupplierCategory lookup table

luCurrency lookup table

luDebtorArrangement lookup table

luDebtorAutoTuition lookup table

luDebtorCashPrepaidGeneralLedger lookup table

luDebtorConcessionType lookup table

luDebtorFeeCategory lookup table

luDebtorInstalmentFrequency lookup table

luDebtorStatementGroup lookup table

luDebtorSubLedger lookup table

luDebtorVoluntaryContributionOverride lookup table

luDeliveryPoint lookup table

luGeneralLedgerBudgetForecastPercents lookup table

luGeneralLedgerClassification lookup table

luGeneralLedgerFinanceReport lookup table

luGeneralLedgerHeadingLevel lookup table

luGeneralLedgerRcptAllocations lookup table

luGovernmentReturnCategory lookup table

luItemKitComponents lookup table

luItemUnitOfMeasurement lookup table

luPayrollCategory lookup table

luPayrollChangeReportColumn

luPayrollCodeType lookup table

luPayrollEmployeeLeaveApplicationStatus lookup table

luPayrollEmployeeStatus lookup table

luPayrollLeave lookup table

luPayrollLeaveAward lookup table

luPayrollLeaveSubCategory lookup table

luPayrollPayFrequency lookup table

luPayrollSuperannuationColumns lookup table

luPayrollSuperannuationFund lookup table

luPayrollSuperannuationList lookup table

luPayrollTaxationRate lookup table

luPayrollTerminationReason lookup table

luPortalPaymentPlans lookup table

luPurchaseOrderAuthorisationStatus lookup table

luPurchaseOrderUrgency lookup table

luSalesCashDrawer lookup table

luSalesCustomerDisplayUnit lookup table

luTax lookup table

luTaxClassification lookup table

luWestpacResponses lookup table

luWestpacSummaryCodes lookup table

© 2015 Synergetic Management Systems. Published 6 May 2015.

Top of page