Conversion must be started from the support menu. If you are currently running the application, press F12=Cancel or F3=Exit until you return to the command line. Enter the following on the command line:
===> STRPACIOLI MENU(SUPPORT)
On menu ALSHELP, select “1 Go to the Restricted Mode Menu”. If someone else is using the application, you will not be able to proceed to the next menu. Everyone must exit from the application before you can continue.
On menu ALSHELPR, select “51 Migrate from Version 1 to Version 2” and the migration screen is displayed (refer to Screen 1 Migration from Version 1 on page 2). Enter the name of the library containing the Version 1 files in the “From Library” prompt. The default is FMS400F. The “To Library” shows the name of the files library that will receive the data.
Press Enter to continue or F3=Exit to quit. When you press Enter, this interactive job will be immediately signed off since the batch migration job must run in a restricted state. Sign back on with the same user ID and key WRKSBMJOB to view the status of the migration job.
If the batch job cannot perform the necessary Version II locks, it will place messages in the QSYSOPR message queue. You may either Cancel the files conversion job or you can Retry the locking process. If you cancel the files conversion job, you may restart from the menus.
Note: Please have all users exit your Version 1 files library before you perform file conversion. Use of the Version 1 files library during conversion process could cause unpredictable results.
When you press Enter, conversion is processed as a batch job. Use option 81 (Work with submitted jobs) on the menu to view the progress of the job. After the job completes, be sure to review the reports produced by the conversion. These reports describe any actions taken place when migrating your data from Version 1 to Version II.
Missing company information
When the conversion process finds records in files for a company number that does not exist in the company file, conversion adds the number to the list of companies. The title of the company is “V1 to V2 Conversion”.
Default company currency definition
Version II requires that each company have a default currency defined. For Version 1 companies without a currency code defined the currency code USD is inserted in the company master. If your company currency is other than USD, you need to add a currency record and change your company currency.
Screen 1 Migration from Version 1
PGLCVTPC Pacioli/400 Accounting Suite mm/dd/yy
XXXXXXXXXX Migration to ControllerVision Version 2 hh:mm:ss
Migrate Files:
From Library. . . . . . . . FMS400F
To Library. . . . . . . . : PACIOLIDTA
The Version 1 to Version 2 migration process runs as a restricted
state batch job. Therefore, this session will be signed off when
you press the Enter key. Sign back on and key WRKSBMJOB to view
the status of the migration job.
F3=Exit F12=Cancel
Interfacing application
Company configuration contains a new value to specify where a company gets some of its data. This is the interfacing application value. Previous versions of Power Ledger and ControllerVision could get data from MAPICS, MAPICS for IFM or DMAS. If conversion finds a reference to a MAPICS environment and company, conversion will set the interfacing value to “M”. If a reference to a MAPICS environment and company is not found, conversion sets the interfacing value to “P” (for Pacioli).
If your interface was to either MAPICS for IFM or DMAS, you will have to go to company configuration and modify the interface value to “I” or “D”.
Column heading differences
Column code conversion may produce difference in financial statement column headings. A number of duplicate Column Control Codes were consolidated. The heading used most frequently was retained.
Column Control Code “DES”
If your Version 1 application does not have a text description for the “DES” Column Control Code, a Version II text description for the “DES” Column Control Code is added. The Version II default description for “DES” is “ACCOUNT DESCRIPTION”. This Version II description can be blanked out if desired.
Account Code “Picture”
In Version II, the account code picture (mask) can only contain the number 9, the dash symbol (-), the period (.) or blanks. If the Version 1 account length is greater than the number of 9s in the picture, then 9s are added to the beginning of the mask. If the Version 1 account length is less than the number of 9s in the picture, then 9s are removed from the left of the mask. Any Version 1 character other than the number 9, the dash symbol, the period or blanks are changed to the dash symbol.
Application Security
In Version 1, you had to explicitly enable application security. If you did not, anyone could run any portion of the application. In Version II, application security is an integral part of the application and users must be given access to menu functions and company(s).
1. Start the migration. Sign on to the system with a UserID that has command line authority:
a. Run the command “STRPACIOLI MENU(SUPPORT)”
b. On menu ALSHELP, select option 1 “Go to the Restricted Mode Menu”
c. On menu ALSHELPR, select option 51 “Migrate from Version 1 to Version 2”
d. On screen PGLCVTPC, review / change the ‘From Library’ name. Press Enter to continue or press F3 or F12 to cancel.
e. If you pressed Enter on screen PGLCVTPC, the application signs you off the workstation.
2. Monitor the migration. Sign back on to your system with the same UserID as you used in the previous step:
a. Run the command WRKSBMJOB and look for the job name PGLCVTPC. This is the job to migrate data from Version 1 to Version 2.
b. When the job completes, review the output which may indicate data you will need to review in Version 2.
3. Initial setup of Company configuration. You should review the company configurations before starting to use the application.
a. Have a user that knows the QSECOFR password sign on to the system.
b. Run the command “STRPACIOLI”
c. On menu PACIOLI, select option 1 “System Administrator Menu”
d. On menu PXAMNU, select option 1 “Work with Company Setup”
e. On screen PXA010L “Work with Company Setup”, you should see the first entry of “COMMON SETTINGS--ALL COMPANIES” and then one or more individual companies.
f. Select option 8=Application Setup next to “COMMON SETTINGS--ALL COMPANIES” to display screen PXA011RL.
g. On screen PXA011RL “Work with Application Setup”, select CV ControllerVision IFM with option 2=Change Settings to display screen FS1521.
h. On screen FS1521 “General System Data”, you can select one or more of the applications from which you will be getting financial data. Choose from DMAS, MAPICS (non-IFM) and/or MAPICS IFM. Once an interfacing application is enabled, there will be additional configuration options.
i. You may also specify individual job queues for running certain types of ControllerVision batch jobs, but you will probably leave these blank for the time being. To use, you will need to discuss the details with your system administrators. Press F1 for additional information. Press Enter two times to accept your changes.
j. Exit the initial setup of the company configuration and proceed to step 4.
4. Initial setup of Application Security. As an organization, you have to decide how you want to manage Application Security. There should be one UserID, other than QSECOFR, who has the authority to manage Application Security for all ControllerVision users. Typically, the system QSECOFR is not knowledgeable about the functions within ControllerVision and should therefore delegate managing the Application Security to a primary user.
a. Have a user that knows the QSECOFR password, sign on to the system.
b. Run the command “STRPACIOLI”
c. On menu PACIOLI, select option 1 “System Administrator Menu”
d. On menu PXAMNU, select option 2 “Work with User Profiles”
e. On screen PXA030L “Work with User Profiles”, select the primary user who will manage application security with option 8=User Functions. If the user is not in the list, press F6 to add the user (then select the new user with option 8)
f. On screen PXA031L “Work with User Functions”, find ‘App ID’ = XA and ‘Function’ = SECADM. Authorize the user with option 1=Authorize.
g. You may want to give this user authority to all functions for all App IDs.
h. Back to screen PXA030L “Work with User Profiles”, select this same primary user with option 9=Company Access.
i. On screen PXA032L “Work with User Company Access”, give this primary user 5=Administration access to all companies.
j. You (QSECOFR) could repeat options 8 and 9 for other users.
k. When finished, press F12 until you completely exit the Pacioli Application Suite.
l. Exit the initial setup of the Application Security and continue with step 5.
5. Review individual Company configuration(s). You should review the company configurations before starting to use the application.
a. Have the primary user sign on to the system.
b. Run the command “STRPACIOLI”
c. On menu PACIOLI, select option 1 “System Administrator Menu”
d. On menu PXAMNU, select option 1 “Work with Company Setup”
e. On screen PXA010L “Work with Company Setup”, you should see the first entry of “COMMON SETTINGS--ALL COMPANIES” and then one or more individual companies.
f. On screen PXA010L “Work with Company Setup”, select a company to configure with option 2=Change Name. On screen PXA010E, review / change the name and the company currency code. The currency code must be defined even though you may not need to use it. Press Enter to return to screen PXA010L.
g. On screen PXA010L “Work with Company Setup”, select a company to configure with option 8=Application Setup. On screen PXA011RL, select CV ControllerVision IFM with option 2=Change Settings to display screen FS3021.
h. On screen FS3021 “Add/Change Company Information”, review each entry and especially the ‘Interfacing application’. Press Enter to display screen FS3023 for non-consolidation companies or screen FS3022 for consolidation companies.
i. For non-consolidation companies:
i. On screen FS3023 “G/L Company Information 2”, review each entry. Press Enter to display screen FS3026.
ii. On screen FS3026 “Edit Division/Department Template”, review each entry. Press Enter to display screen FS3025 or PXA011RL.
iii. Screen FS3025 displays if you are interfacing to an application. Review each entry. Press Enter to display screen PXA011RL.
j. For consolidation companies”
i. On screen FS3022 “Consolidate Companies”, review each entry. Press Enter to display screen PXA011RL.
k. On screen PXA011L, press Enter to return to screen PXA010L
l. Repeat these steps for each company. When finished with company setup, you must press F12 to return to the menu.
6. You can now use ControllerVision. You may need to review Application Authority for additional users. There are additional setups on menu PXAMNU which you may need to review. Please see the User’s Guide for additional information. There is a copy of the User’s Guide in PDF format on the CDROM that contains the installation files for ControllerVision.
** End of Document **