Do you resent the opening periods for each and every organization when the new year begins? Do you avoid opening for only one month at a time due to the work required? If you have many companies, it can be tiresome and time-consuming. Do you want a faster way to open periods?

To tackle this issue Sage X3 contains a new time-saving feature called Multi-company period opening (TRTPERMC).

In the below blog we are going to find out the best and the quickest ways to open periods for multiple companies together SageX3.

Multi-Company period opening(TRTPERMC) can be found under the below path:

Navigation Page > Common Data > General Accounting Tables > Analytical > Multi-Company Period Opening

Fig1: Navigation Page

Multi-company period opening eliminates the need to open periods for one company at a time and deselect or select particular periods. This new function allows you to open either all companies and their ledgers or a subset of them. You have the option to open all periods or just one. You can also run this either on demand or on a set schedule.

Note: This function was added in v12.0.21 but only processes one ledger at a time until v12.0.22.

Company NA20’s fiscal year is open till 2021 for Ledger Types: Ledger, Analytical, IAS, and Group. Periods are open until 12/2020. Refer the below screenshot:

Fig2: Fiscal year for NA20

Company NA10 has fiscal years open till 2023 with just Ledger Type: Ledger. Periods are open until 12/20. Refer the below screenshot:

Fig3: Fiscal year for NA10

Now we will look at the Multi-company period opening (TRTPERMC) function. We have the option of selecting All Companies, Groups, or a specific set of companies. We can select one or more Ledger Types, as well as a Period date.

In the following example, we will go from company NA10 to company NA20, all Ledger Types, and a Period date of 9/30/22. We choose all Ledger Types, but NA10 only has Ledger Type as Ledger. For the period ending 9/30/22, NA20 only has years available through 2021. Refer the below screenshot:

Fig4: Multi-Company Period Opening(TRTPERMC)

The below log indicates that all periods were unlocked for NA10. It also indicates that there were no Analytical, IAS, or Group ledgers for this organization:

Fig5: Log file for NA10

For company NA20, the below log indicates that periods in 2022 cannot be opened because the year has not yet been opened:

Fig6: Log file for NA20

Even though the fiscal year was closed, the function continues and opens the 2021 periods for the other ledgers:

Hope the above blog helps you with opening Period for multiple companies at once. Using the above mentioned ways, you can optimize your work and have a smooth experience, making it easier to open periods for multiple companies, saving time and boosting the productivity.