General Ledger > Transaction Processing > GL Journal Entry

GL Journal Entry

You use this program to:

  • record, authorize and post General Ledger transactions which do not originate from integrated modules, including those created from entries imported from a third-party software application.
  • rectify errors on ledger journals created from the sub-modules. Refer to General Ledger Integration Error Handling for additional information.

The program enables you to process Normal journals, whereas the GL Recurring Journals and GL Standard Journals programs enable you to process Recurring and Standard journals respectively.

Toolbar and menu

Field Description
New Select this to process a new journal.
New Journal Select this to process a new journal.
New from Standard Journal

Select this to create a Normal journal from a Standard journal (see Copy From Standard Journal).

This option is not available for Statistical or Inter-company journals.

New from Existing Journal Select this to reverse an existing journal or to create a new journal by copying an existing journal.

The new journal is created with the same journal type as the journal being copied (see Copy an Existing Journal), unless you are copying a sub-module journal. When you copy a sub-module journal, the new journal is created as a Normal journal.

Save Select this to save the currently displayed journal.

You can only save the journal once the Undistributed amount is zero (i.e. When the journal balances).

If zero value lines exist on the journal, a message is displayed indicating that these lines will be discarded. If you select OK, the journal is saved, but the zero value lines are deleted. If you select Cancel, you are returned to the journal.

Print Select this to print a journal.
Print Current Jnl Select this to print the journal currently displayed.
Print Multiple Jnl Select this to print multiple journals according to the selection criteria you define (see Print General Ledger Journals).
Year

Indicates the financial year into which the journal must be posted. This defaults to the year in which your company is working and may not correspond to the calendar year.

Although this field defaults to your current ledger year, you can post entries to the previous ledger year.

As a precautionary measure, you can run the Balance function of the GL Period End program and select the option: Balance a prior year. This enables you to establish whether the ledger is in balance for the prior year into which you want to process the journal, before actually posting the journal. Once you have posted the journal into the prior year, you then rerun the Balance function for the prior year to ensure that the ledger is still in balance.

When posting into the previous year the transactions are posted into period 13 if you are using 12 accounting periods and into period 14 if you are using 13 accounting periods (Company Maintenance). The reason for this is that your General Ledger year is already closed. If the transaction was posted into period 12, then your revenue and expense accounts would have a closing balance for the year which would be incorrect. SYSPRO therefore posts the transaction into period 13 or 14 and automatically clears the expense and revenue accounts to the Retained Earnings account.

The International Accounting Standards rule IAS8 governs the posting of entries into prior periods/years.

Period

Indicates the financial period, within the Year indicted, into which the journal must be posted in the General Ledger.

This defaults to your current ledger period, but can be changed. You cannot select a ledger period which is closed.

This option is not available when processing Inter-company or Provisional journals as these must be posted into the current financial period.

The posting period does not necessarily correspond to the calendar month. e.g. If you have a 12 period financial year which starts on 1 March, then March is defined as period 1, April as period 2, May as period 3, etc.

If you post a journal to a period in the previous year after you have run the Year end function of the GL Period End program, then the system automatically updates the current year opening balances for the affected accounts and also the Retained Earnings account where applicable. i.e. It is not necessary to manually adjust account balances in the current year for such journals.

Inter-company journals cannot be posted into period 13 if you are using 12 accounting periods or into period 14 if you are using 13 accounting periods (Company Maintenance).

GL journal Indicates the number allocated to the journal.

Journal numbers are automatically assigned by the system, beginning with 00000 for the first journal of the financial year, through to 99999.

If you selected the setup option: Next journal number by period (General Ledger Setup - Journals tab), then journals are successively numbered from 00000 to 99999 for each period.

When maintaining existing journals, you use this field to enter the journal number you want to maintain.

You can only add or maintain journals for the current year, next year and previous year 1.

You cannot maintain a journal which is Cancelled, On hold or Posted. You can, however view the journal details.

Line

Select this to add or remove a line from the current journal.

Journals that are on hold or have been posted cannot be maintained.

Add Line Select this to add a line to the Journal Details list of entries for the journal.
Remove Line Select this to delete the currently highlighted entry from the Journal Details list of entries for the journal.
Functions  
Post Current Journal Select this to post the currently displayed journal into the General Ledger.

If the option: Authorization of journals before posting required (General Ledger Setup - Journals tab) is selected, then the journal must be authorized before you can post it into the ledger.

If zero value lines exist on the journal, a message is displayed indicating that these lines will be discarded. If you select OK, the journal is saved, but the zero value lines are deleted. If you select Cancel, you are returned to the journal.

The journal cannot be posted if any of its ledger codes are on hold (General Ledger Codes).

Hold Journal Select this to place the current journal on hold.

A journal which is on hold can only be printed or released from hold.

Release Journal Select this to release a journal which is currently on hold.
Cancel Journal Select this to cancel the entire current journal.
Authorize Journal

You use this option to authorize journals that have been captured but not yet posted (see Authorize Journals).

This option is only enabled if you selected the setup option: Authorization of journals before posting required (General Ledger Setup - Journals tab).

Cancel Authorization Select this to cancel the previous authorization of the current journal. This changes the status of the journal from Authorized to Unauthorized. This option is only enabled if the status of the current journal is Authorized.
Undistributed Select this to apply the amount displayed in the Undistributed amount field to the currently highlighted line in the Journal Details pane.

Copy From Standard Journal

This screen is displayed When you select the New > From Standard Journal option from the File menu.

Field Description
Standard journal code

Indicates the code of the Standard journal from which you want to create the normal journal.

Standard journal codes are maintained using the Browse on GL Standard Journals program.

Posting period Indicates the posting period into which you want to create the normal journal.
View G/L Periods

Uses the Change Posting Period program to view the periods’ Open/Closed status flags for the Current or Previous year in the relevant module.

You cannot change the status of the period. This can only be performed from within the each module's setup options.

Posting year Indicates the posting year into which you want to create the normal journal.
Copy

Select this to create the normal journal from the standard journal you selected.

Once the journal is copied, the G/L Journal Entry screen is displayed enabling you to perform various functions for this newly created journal.

Cancel Select this to return to the previous screen without copying the journal.

Copy an Existing Journal

This screen is displayed When you select the New > From Existing Journal option from the File menu. The options enable you to create a new journal as either an exact copy of an existing journal or as the reverse of an existing journal.

Field Description
From Journal These options enable you to define the details of the journal from which you want to create the new journal.
[Note]

This can be a sub-module journal, but the new journal created is a Normal journal, not a sub-module journal.

Year Indicate the year in which the original journal was captured.

Although only the current, previous 1 and future year are displayed in the dropdown, you can enter any year.

The program only validates the journal selected once you have entered a journal number, because the year, period and journal number are required for validation.

Period Indicate the period in which the original journal was captured.
Journal Indicate the journal number you want to copy.

You can select the Browse icon to use the GL Browse on Normal Journals program to select the required journal number.

To Journal These options enable you to indicate the details of the new journal that must be created.
Year Indicate the year in which the new journal must be created.

You can only create a GL journal in the current, previous 1 or future financial year.

Period Indicate the period into which the new journal must be created.
Date Enter the capture date for the new journal.
Group Box  
Reverse journal Select this to create the new journal as a reversal of the journal you selected in the From journal fields.
Copy Select this to create the journal from the journal you selected.

If you selected the option: Reverse journal, then the new journal is created as a reversal of the original journal (i.e. all debit amounts in the original journal are created as credit amounts and all credit amounts in the original journal are created as debit amounts in the new journal).

Cancel Select this to return to the previous screen without creating a new journal.

Print General Ledger Journals

This screen is displayed When you select the Print > Print Multiple Journal option from the File menu.

Field Description
Ledger year This indicates the financial year for which you want to print the journals.
Ledger period selection Indicate the financial period(s), within the financial year selected, for which you want to print the journals.
All Select this to print the journals for all ledger periods within the ledger year you selected.
Single Select this to print the journals for a single ledger period within the ledger year you selected.
Ledger period You use this field to enter the single ledger period for which you want to print the journals.
Journal number selection Indicate a selection of journal numbers to include in the report.
Authorized journals This is only enabled if you selected the setup option: Authorization of journals before posting required (General Ledger Setup - Journals tab).
Both Select this to include both authorized and unauthorized journals in the report.
Only authorized Select this to include only authorized journals in the report.
Only unauthorized Select this to include only unauthorized journals in the report.
Journal type selection

This option enables you to select the types of journals you want to include in the report.

All journal types are selected by default and you can deselect those that you do not require.

At least one journal type must be selected.

Journals captured in a sub-module prior to SYSPRO 6.1 are considered to be Normal journals.

Sub module journals This enables you to indicate the sub-module journals you want to include in the report.

The sub-module journals are created by the GL Integration programs in each sub-module.

These options are only enabled When you select the Journal type selection - Sub module journals.

[Note]

Journals captured in a sub-module prior to SYSPRO 6.1 are treated as Normal journals. Therefore, the selections you make here apply only to sub-module journals processed from SYSPRO 6.1 onwards.

Journal status selection

Select the journal statuses you want to include in the report.

All journal statuses are selected by default and you can deselect those that you do not require.

At least one journal status must be selected.

Print

Prints the journals according to your selections.

If the setup option: Limit view to capturer is selected (General Ledger Setup - Journals tab), then only the journals you captured are printed.

Close Returns to the previous screen without printing the journals.

Journal Header

Field Description
Journal type Before processing a journal, you must define a Retained earnings account (General Ledger Integration - General Ledger tab). This account is usually defined as a capital account, but cannot be defined as an expense or revenue type account.
Normal journal Select this to process a Normal journal.

Normal journals are traditional journals which you post once only to the General Ledger.

These journals are posted to the Ledger Detail file with a source code of JE.

Provisional journal A provisional journal is the same as a normal journal, except that it is reversed at period and/or year end and it can only be posted into your current period. Provisional journals are automatically reversed by the system at period/year end if you selected the setup option: Reverse out provision journals at period/year end (General Ledger Setup - General tab).

The journal is posted to the ledger detail file with a source code of PV. If you selected to automatically reverse provisional journals at period/year end (General Ledger Setup), then the reversing journal is posted with a source code of RV.

Provisional journals are typically processed for income accrued but not yet received, or expenses incurred but not yet paid in a specific accounting period.

Alternatively, they can be used for accruals of prepaid expenses.

For example:

Your financial year runs from Jan 05 to Dec 05 and you pay a R400 license fee in Dec 05 for the next 4 months (i.e. Dec 05 to Mar 06).

The entry When paying would be:

Debit License fees (expense a/c) R400 and Credit Creditors or Bank (Balance Sheet a/c)) R400.

When you process a year end in December 05, your profit/retained earnings will be understated by R300 as 3/4 of the R400 relates to 2006, not 2005.

You need a "mechanism" to take the R300 out of the expense account and into the balance sheet over the year-end. To do this, you can use a provisional journal as follows:

Debit Prepaid expenses (Balance Sheet a/c) R300 and Credit License fees (expense a/c) R300.

The year-end procedure sets all expense accounts to zero and transfers the balances to the Retained Earnings account. In this case, R100 is deducted from the profit for 2005 - which is correct.

After year end, in period 1 of 06, the provisional journal is reversed and the remaining R300 is put back into the expense account.

Debit License fees (expense a/c) R300 and Credit Prepaid expenses (Balance Sheet a/c) R300.

Having a provisional journal over year-end which affects income statement accounts only, makes no sense as the year end reduces the account' balances to zero anyway.

Inter-company journal Select this to process an Inter-Company journal.

This type of journal enables you to post entries to your current company and the matched debit and/or credit to one or more other companies.

The journal is posted to the ledger detail file with a source code of IC.

The following rules apply:

  • Inter-Company Journals can only be posted into the current period of each company involved in the transaction.
  • The local currency must be the same for both companies.
  • Inter-company journals cannot be posted into period 13 if you are using 12 accounting periods or into period 14 if you are using 13 accounting periods (Company Maintenance).
User-defined journal Select this to process a User Defined journal.

A user-defined journal is the same as a normal journal, except that you can specify your own source code for the journal.

User defined journal source codes are maintained using the Browse on Journal Source Codes program.

Period end adjustments Select this to process a Period End Adjustment journal.

This journal enables you to post adjustments to a prior period.

The journal is posted to the ledger detail file with a source code of PE.

Auditor's adjustments Select this to process an Auditor's Adjustment journal.

This journal enables you to process the final ledger adjustments for the year When you are in the last period of your General Ledger.

The journal is posted to the ledger detail file with a source code of AU. This journal can be password-protected.

Statistical journal Select this to process a Statistical journal.

If you select this, then you will only be able to process entries to accounts defined as Statistical (General Ledger Codes).

Statistical journals are used for reporting purposes only. Therefore, When processing statistical journals, these journals do not have to balance (i.e. total debits do not have to equal total credits).

When you create alternate currencies using the GL Alternative Currency Maintenance program, statistical journals are created in the alternate currency with an exchange rate of 1. If you are using alternate currency ledgers, then statistical journals update the alternate currency tables at an exchange rate of 1.

Alternate currency jnl Select this to process a normal journal in one of the alternate currency ledgers.

You must define the alternate currency ledger to which you want to process the journal. The available alternate currencies are those created using the GL Alternative Currency Maintenance program.

Alternate currency journals can be processed into any open GL period in the current or previous year.

The source code for alternate currency journals is AC.

Transactions processed in alternate currency journals are only posted to the alternate currency ledger selected. The local currency ledger is not updated with these journals.

The entries are posted at the exchange rate currently defined in the currencies table (Currencies).

The series of journal reference numbers created for alternate currency journals are the same as those for all other normal journals. This means that if you created alternate currency journals, that those journal numbers will not appear in your local currency ledger.

Journal date

This is the date you want to use as the transaction date for the journal.

This defaults to your current system date, but can be changed.

Reference

This enables you to attach a reference to the journal.

The entry made here is printed on the GL Journal Report and can be viewed within the GL Query program.

Notation

This enables you to enter additional text as a notation against the journal.

This entry is printed on the GL Journal Report and can be viewed within the GL Query program.

Batch total required Select this to enter the total value of the debit entries for the journal you are about to process.

A message is displayed if you try to end the journal and the debit entries do not match the batch total entered.

Batch total

Enter the debit value to be validated against the total debit entries in the journal When you end the journal. This field is only enabled if you selected the Batch total required option.

Currency Select the currency in which the journal must be processed.

This option is only enabled for Alternate currency journals.

You can use the Browse on Currencies program to select the alternate currency in which you want to process the journal.

Source

The source code indicates the source of transactions in the General Ledger.

The source code is defined by the system for all normal journals except for User-defined and Recurring journals. This field is therefore only available if you selected to process a user-defined or a recurring journal.

A User-defined source code and description must be created for user-defined and recurring journals using the Browse on Journal Source Codes program. The source code cannot be one of the standard source codes held on file.

Status This indicates the status of the journal (see Journal Status).
Authorized This indicates whether the journal has been authorized for posting. This is only applicable if you selected the setup option: Authorization of journals before posting required (General Ledger Setup - Journal tab).
Undistributed amount

This displays the difference between the value totals of the debit and credit entries.

When this value is zero, then the journal is in balance and can be posted.

This check is not applied to Statistical type journals. i.e. Statistical journals need not balance before they can be posted.

Message A message is displayed in this field if the journal is out of balance.

Journal Status

The status field indicates the status of the journal, which can be one of the following:

  • Not posted
  • On Hold
  • Cancelled
  • Posted

You cannot maintain a journal in a status of Cancelled, On hold or Posted. You can, however view the journal details.

The functions available for the journal depend on the journal status as follows:

Status Functions Available        
Not Posted Post Hold Cancel Print Journal Details
On Hold   Release   Print  
Cancelled       Print  
Posted       Print  

Journal Notes

You use this pane to add and maintain free format text for the journal.

Journal Details

The fields on this pane enable you to enter or maintain the journal lines.

[Note]

Although the grid is enabled, you cannot edit any fields for journals that are in a Status of Posted, Cancelled or on Hold.

Field Description
Ledger code

This indicates the Ledger code to which you want to post the journal amount.

If you enter a Statistical type ledger code, then a warning indicating that the account code you entered is a control account is displayed. This is because all statistical type accounts are automatically defined as control accounts to ensure that transactions are only posted to them from the General Ledger module.

If you are processing a statistical journal, then you can only enter a ledger code that is defined as a statistical account (General Ledger Codes).

If the ledger code is a Template account type, the template account itself is never updated. Transaction values are posted only to the accounts linked to the template account, based on the percentages defined against these linked accounts (see Template). Details of these postings are printed on the SRS version of the GL Journal Report providing you select the Report option: Include template details.

[Note]

If you enabled G/L Structure Definition (GL Structure Definition), and you attempt to post to a General Ledger account code which has not yet been created (General Ledger Codes), then the ledger code is automatically created based on the template defined.

As soon as a valid code is entered in the Ledger code field, it is immediately created in the General Ledger. It is not created only when the transaction is saved.

If GL analysis is required for the Ledger code you entered (General Ledger Codes), then you use the GL Analysis program to allocate the transaction amount to the respective analysis codes, providing you are not processing an Inter-company journal. G/L analysis is not available for Inter-company journals.

If a sub module journal could not be posted due to a missing ledger code, then **missing** is displayed in this column. You need to release the journal from hold before you can edit the line and enter the correct Ledger code. You use the Release Journal option from the Function menu to release the journal. The journal status is displayed in the Status field in the Journal Header pane.

Description This displays the description for the ledger code entered in the previous field.
Transaction date

This indicates the transaction date for the specific entry within the journal.

The date defaults from the Journal Header screen, but can be changed.

Reference

The entry made here is printed on the GL Trial Balance and can be viewed within the GL Query program.

This indicates the reference attached to the specific entry within the journal.

Debit amount Enter the debit value for the journal line.
Credit amount Enter the credit value for the journal line.
Comment

The entry made here (up to 60 characters) is printed on the GL Trial Balance and can be viewed within the GL Query program.

This comment is relative to the current entry being made.

Unit of measure

This is only displayed if you are processing a Statistical journal.

It indicates the unit of measure defined against the statistical account code (see General Ledger Codes).

G/L analysis If the Ledger code you entered requires General Ledger analysis (General Ledger Codes or GL Structure Definition), then you select the Edit option to use the GL Analysis program to enter the analysis details.
Inter company Select this to post this entry to another company.

This only applies to Inter-company journals.

Company This indicates the company into which you want to post the transaction.

You need to specify both the debit and the credit ledger code for the journal to be processed in the selected inter company.

You can only enter a company to which you have access (Operator Maintenance).

Debit ledger This indicates the ledger code in the company selected that must be debited with the amount entered.

This field is mandatory for an inter company journal.

Credit ledger This indicates the ledger code in the company selected that must be credited with the amount entered.

This field is mandatory for an inter company journal.

Rows This indicates the total number of entries in the journal.
Total These fields indicate the total value of debit entries and the total value of credit entries for the journal.

Authorize Journals

Details are displayed in this pane When you select the Authorize Journal option from the Functions menu.

Field Description
Year

Select the financial year for which you want to authorize the journals.

This field defaults to the current financial year.

Select All Select all journals displayed in the listview for authorization.
Unselect All Deselect all journals displayed in the listview from authorization.
Apply Authorization Authorize those journals displayed in the listview which you selected for authorization (A tick in the first column of the listview indicates that the journal is selected for authorization).
Options icon Select the journals you want to display in the listview.
Refresh Refresh the details in the listview.

Listview

Once you have selected a financial year, the following information is displayed in the listview:

Column Description
Col 1 A tick in the first column indicates that the journal is selected for authorization.
Journal Indicates the journal number.
Date Indicates the date captured on the journal header.
Period Indicates the ledger period to which the journal details must be posted. This is the period defined against the journal header.
Journal type Indicates the type of normal journal.
Status Indicates the current status of the journal (see Journal Status).
Printed Indicates whether or not the journal was printed.
Reference Indicates the reference entered on the journal header.
Captured by Indicates the operator who captured or last changed the journal.
Journal details Select the View option to use the GL Journal Zoom program to view details of the source entries for the journal.

Authorization options

This screen is displayed When you select the Options icon from the Authorize Journals pane.

Field Description
Period selection Indicate the financial periods for which you want to include journals in the listview.
Journal selection Indicate the journal numbers, within the selected period(s), to include in the listview.
Include  
Authorized Select this to display only authorized journals in the listview.
Unauthorized Select this to display only unauthorized journals in the listview.
Both Select this to display both authorized and unauthorized journals in the listview.
Apply Apply the options you selected and to return to the listview. Only those journals you selected are displayed.
Cancel Select this to ignore any options you defined and to return to the listview.

Operator Journal Access Tables

The following tables define operator access within the GL Journal Entry program, according to the access to activities defined against the operator code (Operators - Security tab) and your selections at the Journal options (General Ledger Setup - Journal tab).

  • Table A defines operator access when the Journal options (General Ledger Setup - Journal tab) are set as follows:

    • Authorization of journals before posting - not selected
    • Limit view of journals to capturer - not selected

Table 1. Table A - Operator Access to Journal Activities

Operator Activity Setting 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Capture Allow Allow Allow Allow Allow Allow Allow Allow Deny Deny Deny Deny Deny Deny Deny Deny
Authorize Allow Deny Allow Allow Deny Deny Deny Allow Allow Allow Allow Deny Deny Deny Allow Deny
Post Allow Deny Deny Allow Deny Allow Allow Deny Deny Allow Deny Allow Allow Deny Allow Deny
Print Allow Deny Deny Deny Allow Allow Deny Allow Deny Deny Allow Deny Allow Allow Allow Deny
Activity                                
Allowed to Capture Yes Yes Yes Yes Yes Yes Yes Yes No No No No No No No No
Allowed to View All All All All All All All All No All All All All All All None
Allowed to Post All None None All None All All None None All None All All None All None
Allowed to Print All None None None All All None All None None All None All All All None

  • Table B defines operator access when the Journal options (General Ledger Setup - Journal tab) are set as follows:

    • Authorization of journals before posting - not selected
    • Limit view of journals to capturer - selected

Table 2. Table B - Operator Access to Journal Activities

Operator Activity Setting 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Capture Allow Allow Allow Allow Allow Allow Allow Allow Deny Deny Deny Deny Deny Deny Deny Deny
Authorize Allow Deny Allow Allow Deny Deny Deny Allow Allow Allow Allow Deny Deny Deny Allow Deny
Post Allow Deny Deny Allow Deny Allow Allow Deny Deny Allow Deny Allow Allow Deny Allow Deny
Print Allow Deny Deny Deny Allow Allow Deny Allow Deny Deny Allow Deny Allow Allow Allow Deny
Activity                                
Allowed to Capture Yes Yes Yes Yes Yes Yes Yes Yes No No No No No No No No
Allowed to View All Own All All Own Own Own All None All None All All None All None
Allowed to Post All None None Own None Own Own None None All None All All None All None
Allowed to Print All None None None Own Own None All None None All None All None All None

  • Table C defines operator access when the Journal options (General Ledger Setup - Journal tab) are set as follows:

    • Authorization of journals before posting - selected
    • Limit view of journals to capturer - not selected

Table 3. Table C - Operator Access to Journal Activities

Operator Activity Setting 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Capture Allow Allow Allow Allow Allow Allow Allow Allow Deny Deny Deny Deny Deny Deny Deny Deny
Authorize Allow Deny Allow Allow Deny Deny Deny Allow Allow Allow Allow Deny Deny Deny Allow Deny
Post Allow Deny Deny Allow Deny Allow Allow Deny Deny Allow Deny Allow Allow Deny Allow Deny
Print Allow Deny Deny Deny Allow Allow Deny Allow Deny Deny Allow Deny Allow Allow Allow Deny
Activity                                
Allowed to Capture Yes Yes Yes Yes Yes Yes Yes Yes No No No No No No No No
Allowed to Authorize Yes No All All No No No All All All All No No No All No
Allowed to View All All All All All All All All All All All All All All All None
Allowed to Post All None None All None All All None None All None All All None All None
Allowed to Print All None None None All All None All None None All None All All All None

  • Table D defines operator access when the Journal options (General Ledger Setup - Journal tab) are set as follows:

    • Authorization of journals before posting - selected
    • Limit view of journals to capturer - selected

Table 4. Table D - Operator Access to Journal Activities

Operator Activity Setting 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Capture Allow Allow Allow Allow Allow Allow Allow Allow Deny Deny Deny Deny Deny Deny Deny Deny
Authorize Allow Deny Allow Allow Deny Deny Deny Allow Allow Allow Allow Deny Deny Deny Allow Deny
Post Allow Deny Deny Allow Deny Allow Allow Deny Deny Allow Deny Allow Allow Deny Allow Deny
Print Allow Deny Deny Deny Allow Allow Deny Allow Deny Deny Allow Deny Allow Allow Allow Deny
Activity                                
Allowed to Capture Yes Yes Yes Yes Yes Yes Yes Yes No No No No No No No No
Allowed to Authorize Yes No All All No No No All All All All No No No All No
Allowed to View All Own All All Own Own Own All All All All None None No All None
Allowed to Post All No None All No Own Own No No All No None None No All None
Allowed to Print All No None No Own Own No All No No All None None All All None

Posting Entries to Non-Current Year

This section provides information on posting transactions into a year other than the current year using SYSPRO.

The only reason you should need to post an entry into the previous year is to account for a change in Accounting Policies or Accounting Estimates, or to fix errors. The International Accounting Standard that deals with this issue is IAS8. There are very strict accounting rules around posting to a previous year and this should only happen in very rare circumstances. Generally, only auditor's entries should need to be posted into the previous year.

The way SYSPRO deals with posting to a non-current year is as follows:

  • You can post General Ledger journals to the previous year. Entries cannot be posted into any year prior to the previous year.
  • For the sub ledgers, which should rarely be affected by the change/correction and/or could have been purged and cannot affect the General Ledger longer, you can only post back to previous period 1 and previous period 2.

    Refer to Multi-period accounting and Change Posting Period for information on posting entries to prior periods.

  • The General Ledger system allows you to capture journals for a future period either in the current year or the next year.

    However, journals captured for a future period (for the current or next year) can only be posted when the General Ledger is in that period (i.e. when the journal becomes current).

Posting to Previous Year

Within SYSPRO, you need to close off the previous General Ledger year before you can post any of the subsidiary ledger entries into the new year.

Usually, however, auditors will not to have completed the previous year's financial reconciliations before the start of the new year. Once they have completed their audit, they will most likely require you to process additional entries into your General Ledger. However, most companies cannot wait for their auditors as they need to see their new year's Income Statement and other financial reports on a regular basis. The General Ledger year end will therefore have been run to roll the General Ledger into the new year. This means that the auditor's entries will have to be posted into the previous year.

[Note]

It is important that posting entries into the previous year is only done in agreement with management, as it obviously has an effect on the financial reports for the previous year end.

The process for posting journals into the previous year is as follows:

  1. Navigate to the Periods tab of the General Ledger Setup program.

    Select the Change Previous option and re-open the period into which you want to post the journal(s).

  2. Use the GL Journal Entry program to process the journal.

    Remember to select the previous financial year and the period required. This is usually the last period of the financial year (i.e. the 13th period – in a 12 period year), which is normally used for auditor's adjustments.

    Although the journal can be posted to any period, the changes mean that financial reports need to be re-printed from the period into which the journals were posted, so that they reflect the correct figures.

  3. Any entries posted to a revenue or expense account are automatically transferred into the Retained Earnings Account in the Balance Sheet, as they do not form part of the current year's revenue or expenses.

  4. Entries posted to a Balance Sheet account cause the account's closing balance and subsequent period's opening and closing balances to be adjusted. These entries have no effect on the previous year's Income Statement.

  5. The Retained Earnings account is adjusted accordingly for the previous and current year.

    For postings to Expense and Revenue account types, the Retained earnings account defined against the Ledger code is used (General Ledger Codes).If this is not defined, or is invalid, then the retained earnings account defined in the General Ledger Integration program is used.

  6. Once the journals are posted, you need to navigate to the Periods tab of the General Ledger Setup program and close the previous year periods currently open. This prevents further journal entries from being processed into the previous year.

The following example indicates the effect of posting a journal into the previous year:

You processed a Year end in December 2000 and your General Ledger is therefore now in Period 1 of 2001.

You now post a journal for 888.00 into Period 10 of 2000. You Credit an Expense account and Debit a Balance Sheet account.

The following journal entries are created:

Period/ year Account Debit Amount Credit Amount Comment
10 / 2000 Expense   888.00 Journal processed
10 / 2000 Balance Sheet account 888.00   Journal processed
13 / 2000 (or 14 if running 13 accounting periods) Expense 888.00   Transfer balance of Expense account to Retained Earnings account.

Balance of Expense account for year 2000 now zero.

13 / 2000 (or 14 if running 13 accounting periods) Retained Earnings   888.00 Transfer balance from Expense account

In addition, the Opening and Closing balances of the Balance sheet account and the Retained Earnings account are adjusted as follows:

Period/ year Account Opening Balance Closing Balance Comment
10 / 2000 Balance Sheet account   Add Debit of 888.00 Adjust Closing balance
11 / 2000 Balance Sheet account Add Debit of 888.00 Add Debit of 888.00 Adjust Opening and Closing balance
12 / 2000 Balance Sheet account Add Debit of 888.00 Add Debit of 888.00 Adjust Opening and Closing balance
13 / 2000 Balance Sheet account Add Debit of 888.00 Add Debit of 888.00 Adjust Opening and Closing balance
14 / 2000 (only if running 13 accounting periods) Balance Sheet account Add Debit of 888.00 Add Debit of 888.00 Adjust Opening and Closing balance
1 / 2001 Balance Sheet account Add Debit of 888.00   Adjust Opening for current year
13 / 2000 (or 14 if running 13 accounting periods) Retained Earnings   Add Credit of 888.00 Adjust Closing balance for previous year
1 / 2001 Retained Earnings Add Credit of 888.00   Adjust Opening balance for current year

Notes and warnings

Coding considerations

  • When you use the GL Journal Entry program to process a journal into the previous year (after you have run the Year end function of the GL Period End program), the system automatically updates the current year's opening balances for the affected accounts and also adjusts the Retained Earnings account where applicable. It is therefore not necessary to manually adjust account balances in the current year for such journals.

Restricted maintenance

Passwords

  • Passwords defined against ledger codes (General Ledger Codes) are not requested when copying or reversing journals. The logic is that the password would have been entered when the journal was originally created and saved.

    You could, however, use eSignatures to provide the required security (see Electronic Signatures).

GL Analysis

  • If the GL analysis required option is enabled for a ledger account used in this program (General Ledger Codes or GL Structure Definition) then the GL Analysis program is displayed when you post the transaction, so that you can enter the analysis details.

    The Ask Me Later function is only available when the option: Force GL Analysis - GL journal posting is enabled for the sub-module (General Ledger Integration - General Ledger tab).

    General Ledger analysis entries are always distributed in the local currency, regardless of the currency in which the original transaction is processed.

  • General Ledger analysis entries cannot be distributed to accounts in the target company when processing Inter Company journals.

eSignature considerations

Electronic Signatures provide security access, transaction logging and event triggering. This enables you to increase control over your system changes.

Access to the following eSignature transactions within this program can be restricted at Operator, Group, Role or Company level. You configure this using the Electronic Signatures program.

eSignature Transaction Description
GL Normal journal added

Controls access to the New functions in the GL Journal Entry program.

GL Normal journal maintained

Controls access to the maintenance of journals in the GL Journal Entry program.

GL Normal journal authorize

Controls access to the Authorize Journal functions in the GL Journal Entry program.

GL Normal journal print

Controls access to the Print functions in the GL Journal Entry program.

GL Normal journal unauthorize

Controls access to the Cancel Authorization function in the GL Journal Entry program.

GL Normal journal hold

Controls access to the Hold Journal function in the GL Journal Entry program.

GL Normal journal cancel

Controls access to the Cancel Journal function in the GL Journal Entry program.

GL Normal journal release

Controls access to the Release Journal function in the GL Journal Entry program.

GL Normal journal post

Controls access to the Post functions in the GL Journal Entry and GL Post Multiple Normal Journals programs.

GL Recurring journal add

Controls access to the addition of recurring journals in the GL Journal Entry program.

GL Recurring journal maintained

Controls access to the maintenance of recurring journals in the GL Journal Entry program.

GL Recurring journal authorized

Controls access to the authorization of recurring journals in the GL Journal Entry and GL Recurring Journals programs.

GL Recurring journal print

Controls access to the print functions for recurring journals in the GL Journal Entry and GL Recurring Journals programs.

GL Recurring journal unauthorize

Controls access to the cancelling of authorizations for recurring journals in the GL Journal Entry and GL Recurring Journals programs.

GL Recurring journal deleted

Controls access to the deletion of recurring journals in the GL Journal Entry and GL Recurring Journals programs.

GL Recurring journal posted

Controls access to the Post functions for recurring journals in the GL Journal Entry, GL Post Recurring Journals and GL Recurring Journals programs.

Activity considerations

Operator access to the following activities within this program can be restricted. You configure this using the Operator Maintenance program.

Activity Description
GL journal capture

Controls the adding, copying and changing of journals using the GL Journal Entry program.

This activity is ignored when capturing journals using a business object (i.e. using e.net).

GL Journal post

Controls the posting of journals using the GL Journal Entry and GL Post Multiple Normal Journals programs.

The Post function of the GL Journal Entry program is disabled and the GL Post Multiple Normal Journals program cannot be loaded.

This activity is ignored when posting journals using a business object (i.e. using e.net).

GL Journal authorize

Controls the authorizing and de-authorizing of journals in the GL Journal Entry and GL Recurring Journals programs.

The Authorize Journal and Cancel Authorization functions of the GL Journal Entry and GL Recurring Journals programs are disabled.

[Note]

For the setting of this activity to take effect, you must select the setup option: Authorization of journals before posting required (General Ledger Setup - Journals tab).

GL Journal print

Controls the printing of journals using the GL Journal Entry and GL Journal Report programs.

[Note]

For the setting of this activity to take effect, you must select the setup option: Limit view of journals to capturer (General Ledger Setup - Journals tab).

If you allow the activity: GL journal authorize, then disallowing this activity has no effect.

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

  1. Open the program for which you want to insert application help into a customized pane.

    This functionality is only available for a program that has panes.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. Select Insert Application Help from the context-sensitive menu.

    The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.