How to Clear All Users in Infor Query & Analysis (When Maximum User Limit Is Reached)

 

If you receive a message indicating that the maximum number of users has been reached in Infor Query & Analysis, you can clear all active user sessions by following these steps:

  1. Open the Infor Query & Analysis Setup Menu.

    • Locate and launch the Infor Q&A Setup application from your system or Start menu.



  2. Log in without a password.

    • When the login window appears, leave the password field blank and click OK.



  3. Access the Users menu.

    • On the menu bar at the top of the window, click Users.

  4. Select “Clear All Users.”

    • From the drop-down menu, choose Clear All Users to remove all active user sessions from the system.



  5. Confirm the action.

    • A confirmation message will appear. Click Yes to proceed.

    • All current users will be cleared, allowing new users to log in again.

Posted by at

Cannot locate the Vision Agora XLB Add-in. Aborting.

  1. Open Excel Options.
  2. Navigate to Trust Center.
  3. Click on Trust Center Settings.
  4. Check the options for “Enable all macros” and “Trust access to the VBA project.”
Posted by at

Error Returned from Database Locator Service : 00210 Failed to connect MDB Locator services

To resolve the issue, ensure all services are running:

1. Log in to the server.

2. Open the Services application and verify that all SunSystems services are running.

Posted by at

Why am I unable to run depreciation calculations in SunSystems?

In SunSystems versions 6.2, 6.3, and 6.4, if even one asset register lacks an asset posting preset, the Depreciation Calculation will not function. The asset posting preset is where depreciation information is entered.

To resolve this issue, ensure that all asset registers have an asset posting preset.
Posted by at

Allocation in Progress - Cannot Amend in Account Allocation

  1. Open the Chart of Accounts Setup.
  2. Enter the Account Code.
  3. Click OK.
  4. Click Amend.
  5. Open the General tab.
  6. Set "Allocation in Progress" to No.
  7. Click OK.
  8. Completed.

Posted by at

Cannot Initialize Posting DLL Error - SunSystems

  1. Run Command Prompt as Administrator.
  2. Execute the following script: 
regsvr32.exe "C:\Program Files (x86)\Infor\Query and Analysis\Settings\LsAlchemy\SS6\Data Send Definitions\SS6_LedgerImport_103.dll"

Note: The Datalink folder location might vary depending on your setup. It is generally recommended to check the About tab in Maintenance to determine the location of the user's Settings folder.



Posted by at

How do I update the description of a journal in SunSystems?

  1. Open Account Allocation.
  2. Type the account code for the account you want to change.
  3. Enter any additional criteria (e.g., Journal Number, Accounting Period, etc.).
  4. Click "Extract."
  5. Change the description or any other information as needed.
  6. Click "Post By Base" to commit the changes.
Posted by at

How do I run Asset Depreciation Calculation in SunSystems?

Steps on how to run asset depreciation calculation in SunSystems?

  1. Open Asset Depreciation Calculation
  2. On the screen click OK
  3. Type the Depreciation Period
  4. Post Transactions = Yes
  5. Posting Period = Single
  6. Type Balance Sheet Account
  7. Type Profit and Loss Account
  8. OK
  9. Ok
  10. Print
  11. Ok
  12. Done
Posted by at

How do I upload an exchange rate in SunSystems?

  1. Prepare the template.
  2. Update the monthly and period rates.
  3. Upload and save the result as an XML file.
  4. Open Transfer Desk.
  5. Select the profile.
  6. Open the XML file.
  7. Run the process.
Posted by at

How do I post a transaction in SunSystems?

 Steps to post a transaction in SunSystems

  1. Open Ledger Entry
  2. Type Transaction Reference - OK
    1. Period
    2. Accouunt code
    3. Fill out all mandatory fields
    4. Description
    5. Amount
    6. Debit or Credit
    7. OK
  3. If you would like to add more transaction/line, click on new line. At the right top of screen, you will see either the journal is balance or not.
  4. Final step, click post button to post the transaction.
  5. Finish 

Posted by at

How do I post an asset transaction on SunPlus?

  1. Create an asset code on Fixed Asset Register/Fixed Asset Record Setup. Please remember to attach  "Asset posting preset".
  2. Follow the journal below. 



     3. When the fund taken from Allocated Resource, 
         You will need to transfer out from AFO to UFNT. 
         Please see the journal below.





Posted by at

How do I copy a business unit in SunSystems 6.3?

Copying a business unit should be done by Support Team. Please contact your local support team.
Posted by at

How do I start services in SunSystems 5.4.1?

1. Open Services
2. Navigate to SunSystems....... (Usually there are three services)

- SunSystems Connect Server
- SunSystems Security Service
- SunSystems Session Manager

3. Right click and start


* If you can not start SunSstems Security Service, follow the steps below
1. Unplug the LAN cable
2. Start the service
3. Plug in the LAN cable
Posted by at

How to unlock a locked user in SunSystems?

1. Login to User Manger

2. Double click on the username


3. Change Lock Status from Lock to Unlocked

4. Click on ... to change your password


5. Finish


Posted by at

Why I can't run depreciation calculation in SunSystems 6.3.1?

When at least One of the assets doesn't have Asset Posting Preset. SunSystems will not allow to run Depreciation Calculation because the Systems doesn't know where to post the transaction especial the analysis information. 

To Fix the issue,  make sure all of asset register has asset posting preset.
Posted by at

How do I restore SunPlus 541 databases?

Why do I need to restore databases?
- When you change the server
- When you need to restore to a specific date
 

What are the steps to restore the database?
1. Open and login to SQL Server Management Studio
2. Restore the Databases
3. Update the server name, ServerFiles and Example Report on DOMAIN database
4. Login to User Manager - Settings - SunSystems 5 - Configuration - Test Connection
   * If the server name is changing, please update the server name
5. Open Database Utility - Re-Link Database
Posted by at

Ledger Import Maping

Business Unit
Definition
Layout Identifier
Error Cell
Matrix-N
Skip Blanks-Y

Ledger Import Header
Create Date
Description
Posting Type-2
Write to hold file-N
Post to Rough Book-N
Allow balancing transaction-0
Suspense account-338501
Other account-338501
Default period
Report errors only-Y
Suppress substitute message-N
Journal Type
Post report account-338501
Post Ledger-A
Allow over budget-N
Allow posting to suspended accounts-N

Ledger Import Details
Account Code
Accounting Period
Transaction Date
Journal Source
Transaction Reference
Description
* Debit Credit Maker (Matrix)
* Memo Amount (Asset Quantity)
L1
L2
L3
L4
L5
L6
L7
L8
L9
L10
4th Currency Code
4th Currency Amount
Posted by at

SSC is not working in Ledger Import

1. Download the files on this link Software

2. Install the software on the server
Posted by at

How do I create Ledger H?

Open OLT


Ledger Bal = H
Held=No
Budget=H
BUL=H
Posted by at

SunPlus Upgrade Process

SunSystems Upgrade Process From 5.4 to 6.2 or 6.3


Example:
Upgrade for Period 006/2019
Beginning Balance 012/2017
Net Activity 001/2018 - 012/2018
Line by Line Transactions 001/2019 -006/2019

1. Convert GDCoA
2. Upload Beginning Balance (Balance Sheet and Net Asset)
3. Upload Net Activity
4. Upload Line by Line of Transactions.

Details
Net Activity (Filter by Period, Journal Number, Journal Source)
- Get net activity using summary report
- Convert the information to Ledger Import
- Upload Data

Line by Line Transactions (Filter by Period, Journal Number, Journal Source)
-Get Detail Report using Details Report
-Convert to Ledger Import
-Upload Data

For Multi Currency
Base from Base
Transaction from Transactions
4th from Base
Compare Base and Transaction, make sure it has the same sign (- or +)
Posted by at
Subscribe to: Posts (Atom)