Infor Performance Management Query & Analysis 10 Serialization Instructions SunSystems 5.4.1

How to Enabling the Infor Q&A or Add-Ins in Excel

Open C:\Program Files (x86)\Infor\Query and Analysis\ExcelAddinRemoveAdd (double click)

Tick the Microsoft Excel Box and then the Apply Button

Open up Microsoft Excel and make sure “Infor Q&A” or “Add-Ins” appear

If Infor Q&A or Add-Ins doesn’t appear, follow the next steps. Open up Microsoft Excel, Click on File, then Options.

Choose the Add-ins tab on the left. At the bottom of box-Manage: COM Add-Ins and click the Go button.

Tick the Infor Query and Analysis Add-In box and click OK.

The following tab should then appear in your Menu Ribbon

How to Update Application Role

STEP 1

Open User Manager, Enter Username and Password then click OK

Settings – SunSystems 5- Manage Application Role

Fill Application Role Name, Application Role Password, Re-enter Password, OK, OK

STEP 2 

You need to continue with STEP 2 if you do fail in STEP 1

Usually, the problem was in Password Policy as you see in next image

continue next step.....

Search and Open Local Security Policy, "change Password must meet complexity requirement" from Enable to Disable

Change to Disable - Apply - OK

Go back to STEP 1

Reversal Journal SunSystems 5.4.1

Click the Ledgers horizontal tab  

Click to select Journal Reversal and Copy

Type the number of the journal you wish to copy into the Journal Number - From field.

Click the OK button

Click the Review All button

Click the dropdown arrow to the right of the Report Process field

Select Journal Reversal from the list

Click the OK button

Click the Use Original Transaction Date field , Select Yes from the list

Click the Use Original Period field  Select Yes from the list

For every Journal Reversal you will be required to enter an explanation, Click the Note text tab

Click the Post button

Click the OK button to begin the Reversal process

We have now finished reversing the journal, so we will click the Exit button

And again. Click the Exit button

End of Procedure

How to Install SunSystems 5.4.1

Installing SunSystems 5.4.1
Special for Adventist we call it SunPlus

Step by step for Windows Server 2008 and Windows 7

1. Install clean Windows
2. Set Computer name
3. Add Features .Net and Power Shell
4. Run Compressed Installer, it will create folder in C:\Windows\temp\Software
5. Run Command prompt as Administrator
6. C:\Windows\temp\software\setup.hta
7. Follow the step until finish installing patchset
8. Restart server and your SunSystems is ready

you can ask SunPlus Support for installer and serialization
after that you can restore your database if any

An error when open SunSystems 5.4

Why I cannot connect to SunSystems?

Make sure 3 Services is running or "Started" on server

    

Error on the running balance

Error on the running balance

Do you ever find when running a “Statement of Account”  but the running balance figures show that is not appropriate.

It can be caused by two things

1. Perform “Journal Reversal” through the menu of the systems, but at the time of selecting the "use original period" is NO, which supposedly is YES
2. Errors when replacing the "Allocation Maker" to "Correction" in different periods

How to Fix It

Use the Account Allocation menu. Instead of "Correction" to "Not Allocated" then press Post by Base. Then running a "Statement of Account" and it would be proper running balance.

============================================================

In Bahasa

Kesalahan pada running balance

Pernahkah anda temukan ketika menjalankan “statemen of account”, namun pada running balance menunjukan angka yang tidak tepat.

Hal ini bisa disebabkan oleh 2 hal:

1. Melakukan “Journal Reversal” melalui menu dari systems, tetapi pada saat memilih "Use Original Period" adalah NO, yang seharusnya adalah YES
2. Kesalahan ketika mengganti "Allocation Maker" menjadi "Correction" pada periode yang berbeda

Cara memperbaikinya

Gunakan menu Account Allocation ganti "Correction" menjadi "Not Allocated" setelah itu tekan tombol Post by Base

Apabila menjalankan "Statement of Account" maka running blance akan tepat