Sage X3

New fiscal year setup

Firstly we must open the fiscal year and periods.

Navigate to Common Data > G/L Accounting Tables > Fiscal Years.

Screenshot 1

Select the company from the left list and the ledger you wish to open, and then check the status of the ledgers.

If the next year is not already there select the Fiscal Year button, if it is, skip to the section on opening.

Screenshot 2

Choose Yes next to each of the years you wish to create, you may create years in advance and leave them closed if you wish.

Screenshot 3

We’re now ready to open the Fiscal Year.

Select Opening.

Screenshot 4

Ensure Yes is against the year you wish to open and click OK.

Screenshot 5

Next we must open the fiscal periods for the newly opened year.

Navigate to Common Data > G/L Accounting Tables > Fiscal Periods.

Screenshot 6

From here we select our company and ledger from the left list. Then select the relevant financial year. On this screen period starting and end dates can be modified.

By clicking on the ‘opening’ button on the top toolbar menu, we can open the period for all or just one ledger in this company.

Screenshot 7

 Select Yes against the periods you wish to open and click Ok.

Screenshot 8

 

Parameters

Next we must check a couple of parameters that act as an additional control.

Navigate to Parameters > General Parameters > Parameter Values.

Screenshot 9

From the left list select TC (Common Data). This parameter can be set at folder, legislation or company level.

Next click the action button on the line labelled CLO and select detail. Here are the parameters that limit the posting dates for various modules. You can either leave these blank or enter limiting values.

Screenshot 10

 

Screenshot 11

Another Parameter that needs checking is in the Supervisor module.

From the left list select SUP, within this we select DEF for default values. Click the action button on the line and select detail.

Screenshot 12

From here we need to check the default end date, which limits postings to the system.

We can also change default start and end date invoice and payment enquiries here to make them more relevant for the upcoming year.

Screenshot 13

Journal Codes

Another control that can also cause issues around the time of a New Year or Fiscal year starting is the ‘Status’ of the journal codes. These can be open or closed. The journal code will not accept postings outside of its opening dates.

 Navigate to Common Data > G/L Accounting Tables > General > Journal Codes.

Screenshot 14

Select Journal codes from the left list and check the status, using the status button on the top toolbar.

Screenshot 15

Set the Opening and closing date as relevant.

Screenshot 16

 

Need a helping hand?

If you're encountering any issues or require additional support when setting up the new fiscal year in Sage X3 make sure to get in touch with our support team.