Use this function to manage periods for each fiscal year for a specific company. You can define periods by company, ledger type, and fiscal year. By default, 12 periods are created, one for each month, but you can change this as needed.

The start date for the first period is the same as the start date for the fiscal year and cannot be changed. The end date for the last period is also the same as the end date for the fiscal year and cannot be changed.

If the CTLCLOPER - Period closing balance ctrl. parameter (CPT chapter, CLO group) is set to Yes, the account balance controls are performed on all periods being closed. The account balance sign is also checked, and not exclusively when closing the last period of the fiscal year. Depending on the number of periods, this could impact performance.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

Notes:

The fiscal year needs to be open to open periods. You need to close all periods before you can run the Fiscal year end function.

You can open one or multiple periods, up to 20, at one time.

You need to open or close periods in order without skipping one.

The last line in the table can never be deleted.

For fixed assets when the ACCPERCTL - Accounting period control parameter (AAS chapter, CPT group) is set to Yes, modifying the periods results in desynchronizing the depreciation context for the company using this ledger. You cannot perform any actions on fixed assets for this company until you run the Context synchronization process. Actions include revaluation, depreciation, method change, closing, and so on.

Block number 1

Company (field CPY)

Enter or select the company, the manual ledger type, and the fiscal year number for the periods to display.

By default, 12 periods display in the Details grid, but you can change this.
General ledger type (field LEDTYP)
Fiscal year (field FIYNUM)
field DES

This field is used to link a description and its record.
This description can be:

  • Printed on the reports.
  • Displayed when the record code is entered in a screen.
  • Used in selection.

The description used by default in the print-outs is replaced by the short description depending on space available.
Fiscal year start (field FIYSTR)

This field displays the start and end date for the selected fiscal year number and cannot be modified.
Fiscal year end (field FIYEND)
Fiscal year status (field FIYSTA)

This field displays the fiscal year status:

  • Not open: You cannot post any entries until you open the fiscal year.
  • Open: You can post entries.
  • Closed: The fiscal year is closed and you can no longer post entries.

Grid Details

Period start (field PERSTR)

This field displays the period start date.

For the first period, the date is same as the fiscal year start date.

After that, the period start date is one day after the period end date of the previous period. This also applies when you insert a period, providing that the period on the line above is not open.
Period end (field PEREND)

Enter the period end date if the status is not open. You cannot modify this date for periods that are open or closed.

The end date for the last period is the same as the end date for the fiscal year.
Period status (field PERSTA)

This field displays the period status:

  • Not open: You cannot post any entries. You can modify the period end date and insert periods below this one.
  • Open: You can post entries.
  • Closed: The period is closed and you can no longer post entries.
Stock status (field PERSTOSTA)

Select the stock status for the period:

  • Open: The period is open to all movements.
  • Balance adjustment: The period is open to price adjustment movements only. If not absorbed movements exist, they are posted on the first open fiscal period available. This status is used to modify an existing stock transaction, such as shipments, receipts, and so no, and to launch the price adjustment process for issues and receipts.
  • Closed: The period is closed for any movement for the end of month process. The average cost and other value totals are not recalculated. Variances are considered to be not absorbed and are posted to the first open fiscal period available.
Closing date (field CLODAT)

This field automatically displays the date the period was closed.

If the FRADGI - French fiscal regulation parameter (TC chapter, CPT group) is set to No for a non-French company or a French company not in compliance with DGI rules, this date is rest to zero if you reopen a period or fiscal year.

Reports

By default, the following reports are associated with this function :

  CLOPER : Pre-closing verification

This can be changed using a different setup.

Specific buttons

Opening

Select this action to open one or several periods if the fiscal year is open.

In the Period opening window, you can select other ledgers with the same structure if available. You can select up to 20 periods to open by setting the Y/N column to Yes. Remember, you cannot skip a period. If you set a line to No, all subsequent lines take the same value.

Closing

Select this action to close one or several periods for the current ledger type and for the other ledger types with the same structure by fiscal year.

SEEWARNING When you close a period, you can only reopen it using the Reopen period function.

Controls when closing a period or a group of periods

The closing process triggers several controls that run automatically and some that depend on various parameter settings. Blocking controls generate a message and prevent a period or periods from being closed. Non-blocking controls generate a warning message, but do not prevent the close from continuing.

Blocking controls confirm that:

  • The next period is open.
  • The current date is after the period end date.
  • All the account posts are final. There are no temporary or simulated posts.
  • There are no items to be reversed.
  • The recurring journals are generated.
  • BP invoices and purchase and sales invoices are validated and posted with a final status.
  • Batch entries are validated and posted with a final status.
  • Remittances are validated and posted with a final status.
  • Accounts exist and the control and the BP accounts are consistent.

Non- blocking controls if:

  • The sign for the account balance is different from the default sign for the account.
  • An account for a specific currency includes posts in a different currency.

Blocking controls when closing the last period in the fiscal year confirm that:

  • The fixed asset charge post has been generated.
  • The account balances are controlled including balance verification and general ledger verification.
  • The pre-consolidated account balances are controlled. The pre-consolidated balance verification and the corresponding general ledger verification have been performed when the Consolidation checkbox is selected for the ledger.
  • The general ledger accounts are balanced.

SEEINFO When you run the CLOPER - Pre-closing verification report, the same controls are applied. The report shows which periods would be blocked from closing if you actually tried to close the periods. You can address any potential blocking errors before running a period close.

SEEINFOIf the CTLCLOPER - Period closing balance ctrl. parameter (CPT chapter, CLO group) is set to Yes, then these blocking account balance controls are applied to all periods being closed and are reflected in the Pre-closing verification report. This includes checking the account balance sign.

Additional controls can be applied depending on the following parameter settings:

If any of these parameters are set to Non-blocking, no related controls are applied.

STOCLOPER - Stock period control (STO chapter, ACC group):

  • Blocking by period: If there are any entries that are not posted to the stock journal (STOJOU) and whose posting date (IPTDAT) is within the current closing period.
    This is the default value for French companies.
  • Blocking by fiscal year: If there are any entries that are not posted in the stock journal (STOJOU) and whose posting date (IPTDAT) is within the current closing period.

FARCLOPER - Control of invoices receivable (ACH chapter, INV group):

  • Blocking by period: If there are any receipts whose invoice receivables have not been posted.
    This is the default value for French companies.
  • Blocking by fiscal year: If there are any receipts whose invoice receivables have not been posted. The control is only carried out when closing the last period of the fiscal year.

SVCCLOPER - Period closing accruals ctrl.(CPT chapter, CLO group):

  • Blocking: If there are any accruals that have not been posted.
    This is the default value for French companies.
  • Not blocking: If there are any accruals that have not been posted when closing the last period of the fiscal year.

ACCPERCTL - Accounting period control (AAS chapter, CPT group):

  • Yes: Several controls ensure that the periods for the fiscal year are consistent with the periods for fixed assets.
    This is the default value for French companies if the FRADGI - French fiscal regulation parameter (TC chapter, CPT group) is also set to Yes.
    The period cannot close if either of the following conditions exist:
    • The period to close is a period for the depreciation context for the company
    • The period to close is an open period for the depreciation context for the company and the posting for this period is Actual.
  • No: No consistency controls are applied.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation