SunSystems

The definition provided by Infor for SunSystems is that it represents an integrated financial management system, purchasing, inventory and sales system that is used by more than 9000 clients worldwide. What I can say about it is that SunSystems is a great integrated system for small and middle businesses even for those that have multi-site […]

Read More>>

Excel tutorials

These are a few tutorials that I think everybody needs to be aware of when working with Microsoft Excel. The tips and tricks available here were studied and developed by people in need of a solution to their problems and is not just a collection of information translated from other internet websites. See bellow the […]

Read More>>
The definition provided by Infor for SunSystems is that it represents an integrated financial management system, purchasing, inventory and sales system that is used by more than 9000 clients worldwide. What I can say about it is that SunSystems is a great integrated system for small and middle businesses even for those that have multi-site subsidiaries. It is very easy to setup, flexible enough and has enough resources left to add further developments long after the implementation team has left. It is great at financial and operational reporting and it enables management to take timely swift and precise decision. Information data available in the systems database can be extracted, processed and delivered to management in a very flexible manner. SunSystems There are available on the internet many articles and even a forum for SunSystems enthusiast to share solutins for the most diverse problems and the system itself is evolving constantly to get better and better in satisfying the needs of all users and business industries. Business Inteligence systems like Infor ION can be implemented to unify and integrate financial with operational and public available data in order to deliver an integrated structure of information that is both accurate and ready to be used in decision making.
Hide an excel sheet so that nobody can see it

Hide an excel sheet so that nobody can see it

To hide an excel sheet so nobody could see it, like the results of a database query when you want just to show a summary based on it, select that sheet and do the following: Making an excel sheet very hidden Right click on the sheet name View Code In the VBA project window that […]
Include a dynamic variable text box in a chart or graph

Include a dynamic variable text box in a chart or graph

Trying to make charts more expressive is anyone’s objective so that he/she doesn’t have to modify the chart every time a piece of data changes in the source of the graph. Do this by adding variable text boxes inside the chart template. As you can see in the picture, there is an average calculated and […]
Mortgage Loan Calculator Simulator

Mortgage Loan Calculator Simulator

Before signing a mortgage loan contract we all must simulate the amounts that we need to repay every month based on the contract conditions. Nobody should accept to sign a loan contract before doing the financial analysis job to understand the full consequences of the contract he is about to enter into. I had to […]
What does it mean and what is NFC

What does it mean and what is NFC

Does NFC icon appear on the screen of your smartphone, or are you reading the specifications of some electronic device and you do not know what is NFC and what does it mean? In few words, the abbreviation comes from Near Field Communication and is a type of RFID technology (Radio Frequency Identification). What does […]
Excel macro for loop

Excel macro for loop

This is a tutorial for beginners to learn excel macro for loop. Loop sequences may be achieved by using a FOR block or a WHILE. Macro for loop using FOR A FOR block looks like this: For i = 1 To 100     Range(“A” & i) = “Number” & i Next i Where i is […]
Run macro on open file event

Run macro on open file event

In order to run macro on open file event you need to have the VBA code (macro) inside the Workbook_Open() event in ThisWorkbook element on Project Explorer. You must first open the VBA editor in Excel and type your macro code inside the Sub Workbook_Open(). I attach a picture for you to see what I […]

Language