Setting Up the Daybook Listing

Daybook Setup (DYB) enables you to determine the way daybook listings are produced. You can control the order in which the transactions are printed, exclude transactions for selected journal types and accounts, and determine how page numbers can be attributed to your listings.

If daybook sequence numbers are to be applied to the transactions you can also determine when a new sequence number is assigned.

Note:  You must set the Definitive Request option to Yes to assign daybook sequence numbers and to set provisional postings to permanent.

Daybook Listing (DYL) is used to produce a daybook listing report.

  1. Specify this information:
    Daybook Sequence Code
    The sequence number code used for sequencing the transactions and report. If daybook sequence numbering is required, this must be a Sequence Number Code defined using Ledger Sequence Setup (LEQ).

    If daybook sequence numbering is not required, this defaults to '-' (hyphen).

    Start of Current Fiscal Year
    The date of the start of the current financial year. This is used to ensure that the Transaction Date range entered on Daybook Listing is within the current year, and to calculate year-to-date figures.
    Prior Yr Adjustment Jnl Type
    The journal type used to identify prior year adjustment journals. This is passed to the Daybook Listing as a report parameter. You can use the SunSystems report writing tools to produce a tailored version of the Daybook Listing that uses this information, for example, to sort or subtotal these transactions.
    Sequence By
    The sequence in which the transactions are sorted and printed on the report. A predetermined set of sort options are available. This is important if daybook sequence numbers are being assigned because it determines the fields that can be used to control the sequence numbering.
    Numbering Method
    This identifies the transaction field that determines when the daybook sequence number should change. The transactions on the listing are sorted according to the Sequence By option, and when the value of the field chosen here as the Numbering Method changes, the next sequence number is assigned.

    If you do not wish to assign daybook sequence numbers, select the No Numbering option.

    If daybook sequence numbering is required, the numbering method you can choose depends on the chosen Sequence By method. The numbering method must be one of the fields identified in the Sequence By sort sequence. For example, if you choose to sequence the transactions by Transaction Date/Journal Number, you can only choose Transaction Date or Journal Number as the numbering method. You could not, for example, choose Transaction Reference as the numbering method.

    A daybook sequence number is assigned to each transaction included on the listing. When the field value you choose as the numbering method changes, the next daybook sequence number is assigned to this transaction. The transactions are reviewed in the order in which they are printed. This means that the transaction sort sequence can affect the sequence numbers that are assigned. For example, if you sequence the listing by Transaction Date/Journal Number/Transaction Reference and choose Transaction Reference as the numbering method, if the same transaction reference appears in two journals, different daybook numbers are assigned to each.

    Last Processed Date
    This is the last date for which transactions were printed on a definitive daybook listing. You must enter an initial date here before you can produce the Daybook Listing. Once you have entered this date you should not amend it. It is updated automatically each time you produce the Daybook Listing with the Definitive Request option set to Yes.
    Update Ledger 'Open Date From'
    This determines whether the Open dates field in Ledger Setup (LES) and the registration date on Ledger Sequences (LEQ) are updated when a definitive request for a daybook listing is made.
    Suppress 'Out of Balance' msg
    This suppresses the Out of Balance message.
    Exclude Journal Types From/To
    A journal type, or range of journal types, to be excluded from Daybook Listing reports. In many countries there are statutory regulations governing what must be included in and excluded from daybook listings.
    Exclude Account From/To
    An account, or range of accounts, to be excluded from Daybook Listing reports. In many countries there are statutory regulations governing what must be included in and excluded from daybook listings.
  2. Save your changes.