1. If the hotel or the Ministry changes the API credentials (Hotel ID, User Name, Password or API Key) of the NTMP platform (Fig.2)
2. If the hotel changes the Windows username or their password which is set to run the task scheduler
3. If the hotel add or edit firewall rules that would block the uploading of data to the NTMP platform
4. If the hotel wants to add, edit or change any of the following configurations in the PMS systems
   
   1. Room Types
   2. Nationality Codes
   3. Payment Types
   4. Cancellation Reasons
5. If the hotel finds out any abnormal logs generated in the PMS Interface PC where the NTMP is configured
6. If the NTMP portal’s “View Integration Data” section is not showing an updated record of the recent activity (date/time)

Please feel free to contact us, if you need any clarifications or explanations on this subject. Please be aware that Saudico Electronic Systems will not take any responsibilities and/or liabilities in the issues that are caused beyond its control. Every hotel is expected to closely monitor the integration on a daily basis and keep us informed about any abnormality, to avoid any actions by the ministry.


Fig.1 / Fig.2

After Login Screen Client was not able to connect and error message 

"Cannot start the server-side process. Check the server is switched on.
The application server did not respond to a command after 60 seconds. The server may be or overloaded or not started."

Solutions :

1. SunSystems Server and Clients are on the Same Patch Set.

2. The client is able to connect resolve the Server hostname ( even if you setup the client using IP).

1) A Payment Method in the Chart of Accounts/Supplier Setup that doesn’t match the Payment Profile’s Payment Method.
2) Payment Method of Due Date and an invoice that is dated in the future.
3) Payment Option in the Payment Profile that doesn’t match the transaction’s allocation marker (as seen in AQ-Account Inquiry).
4) Supplier with an allocation in progress on their account.
5) Current period that is earlier than the period the transaction posted to.
6) An amount limit in the payment profile.
7) An open period or date limit in the payment profile that is incorrect.
8) An open period or date limit in the Ledger Setup that is incorrect.
9) An open period or date limit in the user group’s Miscellaneous Permissions, even if correct. This may need to be cleared and re-entered after running checks.
10) A supplier with payment method B-Bank Payments whose BK-Bank Details are not set up.
11) A transaction that does not contain analysis codes that are set to mandatory.
12) No proper rate set up in CNP (correct currencies or dates)
13) No default rate (rate with no period) set up in CNP
14) Rate in CNP with improper range of accounts
15) The Priority on the payment tab on the Supplier Setup does not match the Account Priority on the general tab on the Payment Profile.

Regards

Resolution:
At the start of a new year, you normally transfer the old year's net profit or loss to a balance sheet account. Before this is done, a trial balance printed for the new year shows the relevant amount. SunSystems automatically prints a line, 'Total Prior Year's Profit/Loss', immediately before the report totals.

Once you have reconciled and confirmed this value the transfer is carried out as follows:

Ensure you have a profit and loss account called, for example, Prior Year Profit/Loss. This account should not have an account code within the range normally included on any financial reports. This is required for system technical reasons.

Create your balance sheet account called, for example, Retained Earnings, which forms part of the balance sheet.

Print a Trial Balance for the first period in the new year, and note the amount called prior year's net profit/loss.

If the trial balance shows a profit, use Ledger Entry to debit the profit and loss account and credit the balance sheet account with this amount. If you are posting a loss, reverse these signs. Post this journal to the last period of the old year. 

The profit and loss entry is ignored in the new year's trial balance, but the balance sheet entry is included. 

This method assumes that SunSystems financial statements, analysis and tables are used for reporting.

An alternate method is to zeroise the profit and loss accounts by posting a journal to each of the P&L accounts using the trial balance as a journal voucher and using the Retained Earnings accont for the corresponding balance sheet account in the conventional way.

Customer is getting Error Message : "Query Excuation Failed for Dataset "EvorReportDataSet"" when execute in Report in SunSystems 6.X

Solutions is :

Create A model for any new created Bussiness unit ( DB)

1. Run Data Access Manager 

2. from configure select the BU.

3 . RUN from play button.

4 Save from Save button.

Regards

Samer Ajlawi
Mobile No. 0500541902

1. Login in Sunsystem with ‘clear’ user with password ‘sunsys’.
2. Once logged In enter ‘ZC’ in the search box and press enter.
3. A window popup will appear asking to enter the user id ( you can enter the user id if you know which user you need to clear else click on the button to view the list of all user and select the particular user to clear it. If you want to clear all the user just leave it blank without entering any id and press enter, it will prompt asking do you want to clear all the users, say yes then it will clear all the users).

1. Login in User manager with user name ‘admin’ and password ‘sunsys’.
2. Once logged In, you will find list of all the users.
3. Select the particular user which you want to unlock and press right click on it and select edit user.
4. A window with the user details will appear.
5. At the bottom of the user details screen the last field is Lock status (if it is locked it will show ‘locked’ else ‘unlocked’).
6. To change the status click on the ellipse button provided and changed to unlocked if it is locked.
7. Once changes are done click on apply and close it.

1) Pre Requisites:

- Create Groups "SunSystemsClient", SunSystemsServices"
- Create USers "SunSystems"
- Add SunSystems and administrator user to each above groups
- Add SunSystems to administrator group also.
- Run SECPOL.MSC -> Local Policies->USer Rights Assignment->logon service->add user SunSystems
- Install IIS and other features and roles. please see samer video converted slides for the same.

2) Install SQL. RUN the iso file:

- install sql
- start sql server managment studio->login as SA user->go to Security->login->NT Authority\systems->properties ->server roles->sysadmin must be select
- open configuration tool->SQL Server configurtaion manager->enable client protocols
- Open SQL server reporting service configuration
- add Service Account (SunSystems) and press apply
- once above done, then go to webservice URL and click on link at the bottom
- Once URL working, click on Database -> and check the settings
- click on report manager url->click on link to open it.
- Once URL opened->CLick on site setting on top->Security->Click new role assignment->add SunSystemsServices and select both system administrator and system user
- click on Database -> and click on change credientials and test it wit both sa adn windows logins

3) Install all the prequisites under the pre requisites folder.

4) Install infor. click the setup or autorun:

- install infor SunSystems
- Install SunSystems Reporting Services.
- Install Sun Patches
- Install sun patch client tier all three sql, help, srs fpr server.
- User migration.
- give right to the pk1 and pk1 group
- try accessing the SUN systems, it sould work

5) Configure Data Access Module:

- Goto DAR(DATA ACESS MANAGER) ->Configure business unit->run(play button) ->select pk1
- ->Synchorize data module->run(play button) ->select pk1
- Once done-> Click on save button to deploy (must step)
- report manager,

6) Q&A Installation:

- Create DB"QADB" in sql.
- Run the QA exe. ->next->next->untill install -> once install done, click finish (dont go next)
- Select only QnA and Sun6
- First QnA -> Datasource = *<computername> and datavase = QADB ->test the connection by widnowns and sql
- Then, select Sun6 -> Datasource = *<computername> and datavase = SunSystemsDomain ->test the connection by widnowns and sql
- Then goto start->infor QnA-> Maintainance->setup->configure Microsoft office->seleect office->click on apply

7) Creating new DB -> goto BUA:

- Select "BUGROUP" ->click create->
- put TRN as BU code, put format, date details, maximum number of peroids 12,
- under value1 seclect base currecny qatari riyal.
- Press ok->ok-> to create the new BU.
- make TRN online-----by clicking on the put online button.
- CURRENCY CODE-> give other details to QAR like dirham etc..
- Configure the data model then same like on step 5.

8)MIgration of SUn4 DB to Sun6:

Pre-Requisites:

- Copy the Sun4 backup into C:\ProgramData\Infor\Logs\SunSystems\Cobol
- New BU should Exit, Create like Step 7 and do configure the data model like step 5.
- Create Analysis Dimension same like in SUN4. you can locate the SSRF backup file to find the T0,T1 ... please note only create the names, description, lookup, length, validate..
- Analysis Structure -> map the analysis dimensions to analsys structure. e,g 901(ledger) to t0 is what t1 is what ....
MIgration:
- Search for Data Migration Wizard-> follow the instruction, imp point are below in sequence.
- Give path for the SUN4 backup file (C:\ProgramData\Infor\Logs\SunSystems\Cobol) adn BU code = name of the BU code in SUN4 (you can check in the backup file usual creates like SSRF-zzz where zzz is the SUN4 BU code.
- Next -> Payment Terms -> Enter Group Code and descriptoon here; For example: Code: P030 Description: 30 days
- Next -> Anaylsis Category Code -> Enter/map here the Analysis dimension ID to SUn4 Analysis Catergory, leave theDefault Analysis code empty.
- Next -> Bank Sub Codes -> Enter like this -> Bank Sub-code: BANK ; Asset Diary Codes: 00001 ; Default Transaction Account code: here put the real ledger G/L Code. you can find it under the SSRF file ; look for the suspense account and put the same code there
- Next -> SunSystems Migration Files -> give this path C:\ProgramData\Infor\Logs\SunSystems\Cobol
- Finish -> param and pay files are created on the above location. you can edit them incase if you put any wrong info in above steps.

Now:

- Search for Data Migration (DMG) -> Select Sun4 BU Code and SUN6 BU code where it would migrate.
- First Check datacheck -> any error / warnings will ne shown under cobol fodler.
- once okay, click on static; it will migrate masterdata from sun4(chart of account etc).
- once migrated successfully, click on TRANS to migrate transactions.
- Once done, check TB(trail Balance) report in sun4 and sun6. both should be tellyed.
- Now check referncial Integrity; goto ->BUA-> Select BU(TRN)->Action ->check referncial Integrity.

9) Ledger Setup -> set open period and open dates.

Please do find the required files in Attachment.

Regards

1)Pre-requisite: COA codes

- Asset G/L Code (Balance Sheet: Assets)
- Asset G/L Depreciation (Balance Sheet: Lability)
- Asset G/L Depreciation (P&L: Expense)
- Assets Disposal g/L (P&L: Expense)

Pre-requisite: BUA and Ledger Setup

- BUA ->Memo account must be entered. to any value the qty (memorandum field in LE.
- Ledger Setup: select " User Assets QTY"

2) Assets Class: to create the grouping of the assets like vehicle furniture.
- Assets class code.
-Depreciation Account:
- Balance Sheet. =liability
- Profit & Loss = P&L Expense
-Value 1 Depreciation ->Deprecation Setting:
- Base Depreciation method: Straight Line
- Base percentage (depreciation percentage): to depreciate the assets
- press okay to create.

3) Assets Note: just optional to write all details about below assets record.

4) Assets Records: To create the assets, you can call the class so all the above setting will come from the class automatically.

- Assets Code.
- Select Assets Class (it will update above values automatically)
- make it active.
- Depreciation Account: B/S and P&L will come from class or otherwise can put manually.
- Depreciation Period: Start period from where the period start to depreciate the assets
- Base depreciation method: it could come from assets classes or you can put it manually.
- Base percentage: like how much percentage, assets will depreciate each MONTH.
- Base Final Value: Also, known as Salvage value: means at what value when it reaches then we need to dispose the assets. usually select 1
- FORMULA TO CALCUTE THE STRAIGHT LINE DESPRECIATION:
- (Base percentage of (total value of assets-Base Final Value)/12 month (as per the period)
e.g.: total Value assets= 100,000 and Dep%=10% then-> then 10% of assets value is 10,000 per annum so for each month divide 10,000 by 12 that is: 833.33. (this example if you don’t have base final value, if you have you must minus it from total assets value then calculate percentage)
if you want to exclude the final value to be calculated while calculating the depreciating ->go to ledger setup and select "exclude final value from dep".

Other NOTES:
-base days for first peroid : 31
-base active data: 15 (as 15 days left for this month, as I receive item on 16th)
Both above option is useful if you receive asset on 16th Jan, and you would like to start the depreciation from this month only then vale would be like above,

5) WORKFLOW: we will receive the assets from LE and once we receive we can see it in assets inquiry as well as in assets records the total value of assets.
then we will run depreciation on this asset that we receive so it will show that assets are depreciated by the above formula.
also, once your asset is totally depreciated or damaged, we can even dispose it by using the disposing functionality.
In disposing: when you receive the asset, you receive by the qty (memorandum). so, when disposing you need to mention the qty and that qty will be disposed and value will be calculated accordingly. see below in details:

I) Ledger Enter: Asset GL code will be debit with asset code (that is car and other, which you create under asset records). also, put asset value and qty(memorandum) also, select asset indicator: initial; Supplier will be credit as normal.

II) To run the depreciation, you can create first the preset that will depreciate the assets value by department wise. (like I have 1 asset in hotel and then it is depreciated by room, hk etc so we can set the %factor for each dept.)
- Creating preset: go to Asset records->click on assets posting preset-> put asset sub code, description, lookup. factor(ratio) and analysis (to select which dept. it goes)

III) Once asset preset is done then, run the asset depreciation calculation:
- go to the asset depreciation calculation->select assets code, depreciation period, post transaction=yes, posting period single/historic (single mean it will calculate the dep for the remaining period and post it in this period. but if you select historic then, it will calculate all the previous miss derivatization and post it in each missed months)
also, put balance sheet code and P&L (same like the one we put in assets record for this asset. -> press ok and print to display the report
please note if you select post transaction=NO then it will not be posted but only you can only print.
once you press ok asset will be depreciated base the distribution in preset posting.
you can check the report under asset inquiry.

IV) dispose the partial asset or full asset:
- first dispose part: go to the asset record-> and select asset code and change->asset status to assets to disposal (you can do the same in asset disposal selection)
- Then go to asset part disposal-> select asset code->disposal quantity->part disposal period, P&L disposal account, post transaction=yes, suspense disposal account= same like p&L disposal account.
- Once okay it will be disposed.

Report Manager:
- asset book listing
- Asset Record Setup
- Assets Posting preset setup.

Solution :

Accounts need to close the previous years by doing the following Steps.

1. Run Trial Balance for the first period of the new year ( Example 01/2017).
2. check under for line with named total Previous year profit/loss.
3. transfer profit/Loss to your Balance Sheet account (example, Retained earnings.

        In the case of profit:
         3.1 if it shows Profit Credit the retain Earning (Balance Sheet account) and Debit the profit and loss Account ( example Prior error profit and loss - make sure this account is outside your range of normal P&L Accounts).
        In the case of Loss:
         3.2 if it shows Loss do the opposite and debit the Retain earnings and credit the Profit and loss account.


Regards
Samer Ajlawi
Mobile No. 0500541902