Navigation:  Configuration > Journal Source >

Journal Setting

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic
Show/Hide Hidden Text

On this tab the following fields can be viewed:

 

hmtoggle_plus1Apply

With the click of the apply button the changes in the grid are updated on the Journal Source Setting table. Note that a previous financial period that is opened today will only be open for today, the system will close the period when program is run as set in system configuration.

hmtoggle_plus1Journal Settings

Populates with all the External Journal Sources from the Journal External Source table and the following Internal Journal Sources A,H,K,L,N,O,R,S and V. The grid is populated from the Journal Source Settings table.

 

This Tab populates with the previous 11 and current financial periods.

 

The current financial period is disabled as it is by default open for journal processing. For each Journal Source it can be specified, by clicking under the relevant financial period, that certain financial periods should be opened for journal processing.

 

 

 Source

 Table

 Field

 Comments

Assets

    A

Asset Financial History

Journal_Datetime

Calendar date on which asset depreciation is run

Creditors

    C

Invoice_line_link

Capture_Date

Journals processed when invoices linked

Creditors

    C

Invoice_line_link_status_hist

Status Change Date

All journals where link status = deleted

Creditors Settlement

    K

Creditor Settlement

Date_settled

 

Debtors

    D

Debtor_Line_Link_History

 Link_Changed_Date

 

Debtors Settlement

    L

Debtor_settlement

Date_settled

 

Cash Management

    S

Bank_transaction

Transaction_Date_time

All bank transactions processed from bank transaction function

(if processed from creditors payment then will have source = K)

Cash Management

    S

Bank_transaction

Cancel_Date

When bank transactions are cancelled

Cash Management

    S

Bank_transaction

Recon_Date

When bank transactions are reconciled

Hand journal

    H

HAND_JOURNAL

timestamp

 

External Journal

    E

journal_xref

 source_timestamp

 

Fluctuation Journal

    F

Debtor_settlement

Date_settled

 

Fluctuation Journal

    F

Creditor Settlement

Date_settled

 

Order operation Labour

    B

Order_Operation_Actuals

Date_Time_Completed

 

Movement

    M

Movement

date_time

 

NODE TIMESHEET

    N

 Timesheet_Status_History

 status_change_date

 

SALES PROVISION

    P

 Debtor_Line_Link_History

 Link_Changed_Date

 

REVERSE HAND JOURNAL

    R

HAND_JOURNAL

timestamp

 

COST CENTRE DIVISIONAL TRANSFER

    T

 Cost_Centre_Div_Transfer

 Journal_Datetime

 

PART REVALUATION

    U

part_revaluation_source

timestamp

 

NODE PROVISION

    V

node_journal_xref

 source_timestamp

 

Transport

    W

Transport_Requisition_History

 journal_Datetime