Previous icon

Next icon

luDebtorSubLedger lookup table

Description

The luDebtorSubLedger lookup table controls the sub ledgers that can be used with debtors to create multiple billing accounts for the same debtor.

The sub ledgers can also be maintained on the Debtors tab of Synergetic Financial Configuration. See Synergetic Financial Configuration - Debtors tab - Sub Ledgers sub-tab.

Example

luDebtorSubLedger lookup table part 1

luDebtorSubLedger lookup table part 2

luDebtorSubLedger lookup table part 3

luDebtorSubLedger lookup table part 4

luDebtorSubLedger lookup table part 5

luDebtorSubLedger lookup table part 6

luDebtorSubLedger lookup table part 7

Fields

Field

Description

Code

A code to represent the sub ledger.

Description

A description of the sub ledger.

Debtor-
StudentID

A number to unique identify the sub ledger.

Note: Each sub ledger must have its own unique DebtorStudentID. DebtorStudentIDs can be from 0 to 9.

ActiveFlag

If selected, the sub ledger is available for use.

Default-
Statement-
Group

Statement group that debtors with this sub ledger belong to, by default.

Override-
Debtor-
Statement-
Report-
Suffix

If you want to use a different Crystal Report for this sub ledger's Debtor Statements, type the report suffix here.

Override-
Invoice-
Stationary-
Suffix

If you want to use a different Crystal Report for this sub ledger's Invoices, type the report suffix here.

Debtor-
Statement-
UnderlayFile

If you want the Crystal Report merged with an underlay file, type the file location of the PDF (portable document format) underlay file here. For example, you want certain reports watermarked.

Note: The underlay file must not be more than one page long. Underlay files that span multiple pages are overlaid on top of each other on the first page, pushing the actual report to the second page. If you have more than one page of information to display, we recommend you provide a web link within the underlay file to the additional files so they can be downloaded by the recipient.

Override- DebtorStatement- EmailType

Send the emailed debtor statements in:

  • Plain Text
  • HTML raw (including tags).

OverrideDebtor
Statement- EmailFrom- Name

Name that appears as the sender.

OverrideDebtor
Statement- EmailFrom

Address that the debtor statements are sent from.

OverrideDebtor
Statement- EmailBCC

Type in any email addresses to send a blind carbon copy of the debtor statements to.

OverrideDebtor
Statement- EmailSubject

Subject line of the debtor statements.

OverrideDebtor
Statement- EmailBody

Body of the debtor statement email.

DebtorInvoice- UnderlayFile

The PDF underlay to use with normal invoices.

Debtor- Statement- Reminder1- UnderlayFile

The PDF underlay to use with first reminders for statements.

Debtor- Statement- Reminder2- UnderlayFile

The PDF underlay to use with second reminders for statements.

Debtor- Statement- Reminder3- UnderlayFile

The PDF underlay to use with final notice reminders for statements.

DebtorInvoice- Reminder1- UnderlayFile

The PDF underlay to use with first reminders for invoices.

DebtorInvoice- Reminder2- UnderlayFile

The PDF underlay to use with second reminders for invoices.

DebtorInvoice- Reminder3- UnderlayFile

The PDF underlay to use with final notice reminders for invoices.

DebtorStatement- ApplyUnderlay
Main

Type the code to apply the main statement PDF underlay to the following statement formats:

  • B - Both Electronic and Printed.
  • E - Electronic Only.
  • P - Printed Only.
  • D - Do Not Apply.

DebtorStatement- ApplyUnderlay
Header

Type the code to apply the statement header PDF underlay to the following statement formats:

  • B - Both Electronic and Printed.
  • E - Electronic Only.
  • P - Printed Only.
  • D - Do Not Apply.

DebtorStatement- ApplyUnderlay
Footer

Type the code to apply the statement footer PDF underlay to the following statement formats:

  • B - Both Electronic and Printed.
  • E - Electronic Only.
  • P - Printed Only.
  • D - Do Not Apply.

DebtorInvoice- ApplyUnderlay
Main

Type the code to apply the main invoice PDF underlay to the following statement formats:

  • B - Both Electronic and Printed.
  • E - Electronic Only.
  • P - Printed Only.
  • D - Do Not Apply.

DebtorInvoice- ApplyUnderlay
Header

Type the code to apply the invoice header PDF underlay to the following statement formats:

  • B - Both Electronic and Printed.
  • E - Electronic Only.
  • P - Printed Only.
  • D - Do Not Apply.

DebtorInvoice- ApplyUnderlay
Footer

Type the code to apply the invoice footer PDF underlay to the following statement formats:

  • B - Both Electronic and Printed.
  • E - Electronic Only.
  • P - Printed Only.
  • D - Do Not Apply.

AutoPledge- AllocationFlag

Select to allow excess debtor payments from this sub-ledger to be assigned to pledge receipts in electronic banking.

Note: The luFund lookup table must also be configured to allocate the payment type to pledges. See luFund lookup table.

ModifiedDate

Date and time the lookup table entry was last modified.

ModifiedUser

User that last modified the lookup table entry.

Last modified: 8/04/2015 12:08:46 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

luDebtorVoluntaryContributionOverride lookup table

luDeliveryPoint lookup table

luFund 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