Sagittarius Systems LLC

10/15/2019

High school of programming of Sagittarius Systems LLC.
We officially founded in 2017, but we started to train people since 2010.

01/15/2015

Dear User, welcome to Graphical Reporting!

Here you can see the amount of money you spent or earned on deals during the time on the Line Graph. Horizontal axis of the line graph shows the time frame, and the vertical axis shows the amount of money you spent/earned on the deals you accomplished during a specified or general time frame.

Here are some of the advantages of line graphs:

They are good for showing specific values of data, meaning that given one variable, the other can easily be determined.
They show trends in data clearly, meaning that they visibly show how one variable is affected by the other as it increases or decreases.
They enable the viewer to make predictions about the results of data not yet recorded.
So here, generated the Line graph will help you to get very clear vision of your business progress over time, and you can even make a prediction of possible steps you should take in the near future.
For example, you can see what was the amount of money you earned in January 2011, when your earned amount reached $1500,
or between which time periods the largest increase in amount of money was... etc.

You can generate Line Graph for several products only, as well as for all products, You can define a precise time period you want to be shown in the line graph, as well as to not set any precise period in order to see the graph for the entire duration of your business. You can define a time period grouping value - this is the period which corresponds to a single point in the horizontal axis of the line graph.
Also you can define the deal type - a Buying deal or a Selling deal. Based on the selected deal type, the amount of money in the vertical axis will correspond to the money you have spent (buying deals) or earned (selling deals).

So, try to generate line graph right now by clicking on the "Show" button!
After that you can try to set some criteria in the Criteria Panel and then again to generate a graph to see how those criteria affected the line graph.

01/15/2015

This is almost one of the most important reports you will ever need in your business. The purpose of this report is to show you the Profit you earned during a defined time range.

Each row of report corresponds to a single product which has been sold at least once during the defined time range. It shows the total sold quantity, actual cost of that quantity, sum total of the money received for the sales of the respective product and finally the Profit you earned after those selling deals.
As it might already be clear - Profit equals to the subtraction of the the actual cost of the product from the sum total of the money received for the sales.

Please pay attention to 'Profit Report Criteria' panel in the right side of the page. Here you can select product(s) which you want to see in the report and also the time range for which a report will be generated.

To generate the report please click on 'Generate' button. After that you will see the result generated in a table view. Each column of the table is sortable! So you can just click on the header of the column and get the table sorted according to that column.
You can download the result as an Excel or CSV file! You just have to select the needed file format from the combo-box (default value is XLS - excel file) and click on the 'Download' button next to it (header part of the table)!

Here are more detailed description of the components in 'Profit Report Criteria' panel:

Product: This is the Product Selector component which allows you to select the products/catalogs whose profits You want to see. By default, no product is available in this component, which means that the generated report will contain all products in the storehouse.
To add products/catalogs in the component, please click on 'Select' button. Further You will see that instead of this help topic, a product tree will appear, and also instead of 'Select' button (which You have clicked), two new buttons - 'Add' and 'Cancel' - will appear. Now you can select any product or catalog from the tree and then press on 'Add'button. You will see that the selected product/catalog will be added in the product selector component! It's so easy, isn't it?! So You can add as many products as You want in the way described above. Generated report will contain only those products which have been added in the product selector component! You can also delete added products from the component: You just have to click on 'Delete image' in front of product/catalog name.

Start Date: The report will show your profit on and after this date.

End Date: The report will show your profit on and before this date.

01/15/2015

This report gives You a possibility to see products statuses based on their remaining stock in the storehouse. So you will always be able to find out which products are critically few in the storehouse (to call Your suppliers for additional delivery), which products are still a lot in your storehouse (maybe you have to pay attention to the fact why they are not being sold, for their status has been 'green for a long time) and which are in sufficient status, i.e. in stock quantity which you considered to be sufficient.

Here is the principle for defining each type of product status.
Please remember, that when you add a product into your storehouse (Settings -> Product Management section), you set these two properties for each product - Critical quantity and Sufficient quantity.
So based on these two values, status lights are defined.

Green light (lot of) - status corresponds to the case when the remaining stock of a product is greater than its Sufficient quantity.

Yellow light (sufficient) - status corresponds to the case when the remaining stock of a product is between its Critical and Sufficient quantities.

Red light (critical) - status corresponds to the case when the remaining stock of a product is less than or equal to its Critical quantity.

Please pay attention to 'Product Status Report Criteria' panel in the right side of the page. Here you can choose the products for which you want to generate status report(by default for all products) and also you are able to choose the statuses you need to display in the report(by default all statuses are selected). Later in this topic you can find more detailed description for each component in the panel.
To generate the report, please click on 'Generate' button. After that you will see the result generated in the table view. Each column of the table is sortable! So you can just click on the header of the column and get the table sorted according to that column.
You can download the result as an Excel or CSV file! You just have to select the needed file format from the combo-box (default value is XLS - excel file) and click on the 'Download' button next to it (header part of the table)!

Here are more detailed description of the components in 'Product Status Report Criteria' panel:

Product: This is the Product Selector component which allows you to select the products/catalogs whose statuses You want to see. By default, no product is available in this component, which means that the generated report will contain all products in the storehouse.
To add products/catalogs in the component, please click on 'Select' button. Further You will see that instead of this help topic, a product tree will appear, and also instead of 'Select' button (which You have clicked), two new buttons - 'Add' and 'Cancel' - will appear. Now you can select any product or catalog from the tree and then press on 'Add' button. You will see that the selected product/catalog will be added in the product selector component! It's so easy, isn't it?! So You can add as many products as You want in the way described above. Generated report will contain only those products which have been added in the product selector component! You can also delete added products from the component: You just have to click on 'Delete image' in front of product/catalog name.

Product Status Lights: Next to each status light you can see a checkbox. By default all checkboxes are selected. So the idea of each checkbox is to show the products in the report under the corresponding status light.
So to make it more clear, let's take a look at an example. Let's say we have added 3 products in the product selector which have 3 different statuses - green, yellow and red. When we generate the report and we have all 3 checkboxes selected - then all 3 products will be shown. When we uncheck, e.g. the checkbox beside the 'Red' status light - the report will contain only 2 rows/products, the product under the 'Red' status will not be shown. And finally, if we also uncheck the checkbox next to the 'Yellow' status light (only one checkbox will be selected in this case - beside the 'Green' status light), then the report will contain only one row/product - the product under the status 'Green'.

01/14/2015

Here You can generate reports which contain statistics of the completed buying/selling deals. It is possible to set different criteria to the generated report adjusting it to your needs.

Please pay attention to 'Deal Report Criteria' panel in the right side of the page. It contains components for setting report criteria (later in this topic you can find a more detailed description for each component). To generate the report please click on 'Search' button. After that you will see the result generated in the table view. Each column of the table is sortable! So you can just click on the header of the column and get the table sorted according to that column.
You can download the result as an Excel or CSV file! You just have to select the needed file format from the combo-box (default value is XLS - excel file) and click on the 'Download' button next to it (header part of the table)!

Here are more detailed descriptions of the components in 'Deal Report Criteria' panel:

Product: This is the Product Selector component which allows you to select the products/catalogs whose deal statistics You want to see. By default, no product is available in this component, which means that the generated report will contain deals for All products in the storehouse.
To add products/catalogs in the component, please click on 'Select' button. Further You will see that instead of this help topic, a product tree will appear, and also instead of 'Select' button (which You have clicked), two new buttons - 'Add' and 'Cancel' - will appear. Now you can select any product or catalog from the tree and then press on 'Add' button. You will see that the selected product/catalog will be added in the product selector component! It's so easy, isn't it?! So You can add as many products as You want in the way described above. After adding the needed products/catalogs the report will contain deals made with those products only! You can also delete added products from the component: You just have to click on 'Delete image' in front of product/catalog name.

Group by: Here You can select the time period by which you want to group deals in the report. By default, the 'Deal' item is selected, which means that each row in the report will correspond to a single deal. As a value for the 'Group by' combo-box it is possible to choose between the following items: 'Deal', 'Day', 'Month' or 'Year'. For example, if You select 'Day', then each row of the report will correspond to the summary of deals per day implemented for the selected product, e.g. during this day You have sold 10 bottles of orange juice - 5 bottles to 'buyer1' at 3$ a bottle, 4 bottles to 'buyer2' at 4$ a bottle and 1 bottle to 'buyer3' at 5$. In this case, when the 'Group by' is set to 'Deal', then for 'Orange juice' product for this day the report will contain 3 rows and each row will correspond to one deal you have made (first row - selling deal to buyer1, second row - selling deal to buyer2, third row - selling deal to buyer3). When 'Group by' is set to 'Day', then in the report you will have only ONE row for this day - which will contain a summary of the 3 deals mentioned above!
The same logic applies to 'Month' and 'Year' values - each row of the report will show the summary of a month (group by month), or it will show the summary of a year (group by year).

Deal type: Here You have to select the deal type (Buying deals or Selling deals) for which you want to generate a report.

Quantity: This field is available only when 'Deal' is selected as a 'Group by' value. The report will contain only the deals with the quantity (buying quantity or selling quantity) specified in this field.

Price: This field is available only when 'Deal' is selected as a 'Group by' value. The report will contain only the deals with the price specified in this field.

Supplier(or Buyer): The report will contain only the deals with the Supplier/Buyer you have selected.

Store Worker: The report will contain only the deals which have been made by the store worker you have selected.

Start Date: The report will contain only the deals which have been made on and after this date.

End Date: The report will contain only the deals which have been made on and before this date.

04/01/2014

This section of the system allows to make Buying Deals (buy products for the storehouse), and also manage already completed deals.
In the left side of the page, there is a list of all available products/catalogs represented in a tree structure (which is manageable in Product Management section).
First thing that should be done for buying any product, is to find that product in the tree and select it (to easily find any catalog/product in the tree, just type its name in the text field above the tree, and click 'loop' image or just press 'Enter'. The same search option is available in all sections where the product tree is available).
After selecting the needed product in the tree, in the right side of the page You will see data related to the selected product (remaining stock in the storehouse, name, unit of measure...). Also other controls will be generated for creating/updating buying deals for the selected product. To perform a buying deal for a selected product, just fill in all mandatory fields in the generated controls and press the 'Buy' button.

E.g. If You need to buy 10 bottles of orange juice, each for 1$, You have to select Orange juice from the product tree, then to enter '10' in the 'Quantity' text-field, '1' in the 'Price' text field, to choose the date of the deal (by default the date is set to current date) in the 'Date' calendar, also You can select the supplier of the Orange juice by typing his/her name in the 'Supplier' suggestion box (after typing any character in the suggestion box, all suppliers whose names start with the typed character, will appear in the suggested list. Just select the supplier You are searching for from that list. If the needed supplier is not shown in the suggested list, You have to create that person in the Person Management section, of course by setting the latter as 'Supplier/Buyer'. After that the person will be available in the suggested list of the suppliers...) and selecting him/her from the suggested suppliers list. When all needed fields are filled in, press the 'Buy' button. Further, if the validation for performing a 'Buying Deal' is passed, the deal will be accomplished, and You can see that 'Remaining stock' property for that product will grow by the quantity You have entered in the Buying Deal.

This section also allows to manage already made buying deals. E.g. if there is a buying deal which contains wrong data, i.e. the quantity or supplier is wrong, or the deal has to be deleted because it was performed for the wrong product. In such cases You will have to edit the wrong Buying Deal. For that purpose, again, the first step is to select the product from the tree. As You already know, controls will be generated in the right side of the page to perform a Buying Deal. Now please pay attention to the 'Search' button which is beside the 'Buy' button and is in disabled mode. Near each button, there is a check-box. The check-box near the 'Buy' button is selected, and the other one near the 'Search' button is not. As You may have understood, these check-boxes define the main action which should be performed for the selected product. So, if the 'Buy' check-box is selected, then the controls generated above are for performing a Buying Deal (as described above...). Now select the 'Search' check-box. You will see that 'Buy' button will become disabled, and 'Search' button will become enabled. Also some of the controls above the buttons will change. You will see that instead of 'Note' text area, 'Store Worker' suggestion box will appear and also the 'Date' calendar will change to 'Start Date' calendar, and below it, a new 'End Date' calendar will be generated. These dates are for selecting a search period for Buying Deals. Thus, the generated controls are for setting search criteria for the Buying Deals. After clicking on the 'Search' button, Buying Deals corresponding to the search criteria will be shown under the Buy/Search buttons.

E.g. If You want to see all buying deals performed from '01.09.2010' to '01.10.2010' for the selected product, You just need to set the 'Start Date' to '01.09.2010' and the 'End Date' to '01.10.2010' and click on the 'Search' button. After searching, the table containing 'Buying Deals' will be generated. Each row of the table corresponds to a single Buying Deal. The last 2 columns of the table are for editing and deleting the Buying Deals. So, if You want to delete a deal, just click on 'Delete' image, and select 'OK' in the generated confirmation box. If You want to edit a deal, You should click on 'Edit'. Further, the search UI above the buttons will change to a Create/Edit Buying Deal UI. After clicking on 'Edit' image, controls will contain the current data of the selected buying deal. Also in Edit mode, the 'Buy, Search' buttons will be replaced by 'Update, Cancel' buttons. For updating a deal, just enter the new data in the generated controls and click on the 'Update' button.

That's all, Good Luck!

07/24/2013

This section of the system allows to create archives of your current system. So you can always create backup archives and be able to restore previously created archives. This mechanism will provide a more secure and flexible usage of the system enabling a retrospective reference to your system data created any time in the past! It is recommended to create backup archives periodically so as in case of a problem you would be able to restore your system data to previously created archives.

Creating and Restoring archives is quite easy! In the right side of the page You can see a "Create New Archive" panel comprising two text areas - Archive Name and Note. All You need is just to enter the Name you want for the archive (e.g. 'monthly_archive_june_2010') and you can also enter any Note regarding the archive you want to create (e.g. 'This is the monthly archive for month June of the year 2010...'). Afterwards, you have to click on 'Backup' button which will create an archive by the name (and note) You have entered!

Below the "Create New Archive" panel you can see the list of already created archives. To restore any archive you just need to click on 'Restore' image of the archive. WARNING! After restoring any archive you will LOSE all data of your CURRENT system and the system will acquire the data of the restored archive! So before Restoring any archive we strongly recommend to first Backup your current system data and then restore any archive you want (the same warning you will get when you click on 'Restore' image of an archive). Of course, if You are completely sure that your current system data are useless, you can always restore previously created archives without creating a backup of your current system data... Hence, this is an optional rather than a mandatory step.

Also it is possible to delete already created archives! All you need is just to click on 'Delete' image (the last column of the archive list) of the archive you want to delete.

That's all, Good Luck! And remember to be very careful when restoring an archive!

07/23/2013

This section allows to manage Persons,
which are somehow related to current system.
Persons can have two general types:

System User. This type is the person who is using the system.
These persons (users) can have roles assigned to them.
There are two kinds of roles:
1. Admin: Admin Users have access to 'System Settings Administration'.
e.g. Product Management, Person Management, etc...
Also other sections of the system are open to Admin users.
2. Manager: Managers have access to all sections of the system, except 'System Settings Administration'.
The main purpose of Managers is to control product related processes: e.g. Buy Product, Sell Product,
generate different statistic reports on the mentioned processes, etc...
System Users should have their own login and password to log into this system.

Supplier/Buyer. These are the persons related to the product.
E.g. The person who supplies Orange Juice, or another one who buys
50 barrels of beer every week.
When Admin/Manager is going to buy/sell any product, he can also select its supplier/buyer (See Buy Product or Sell Product sections).
So it would be very helpful to generate a report on the bought/sold products and see the statistics of the Supplier/Buyer activity.

In the right side of the page there are two panels:
1. Add New Person. This panel is for creating a new person.
It contains all the required fields covering the person related data.
To create a new person you have to fill all mandatory fields of the panel
and press the 'Add' button. Following this action, if no validation errors occur,
the new person will be created.
This Panel is also designed for updating person data, i.e. when You select a person from the 'persons list',
this panel will be renamed to 'Edit Person', and the input fields will contain the selected person's data. In this case, the "Add" button will become invisible and
two new buttons will appear: 'Update' and 'Cancel'. The 'Update' button will update person data with the newly entered values. The 'Cancel' button will change 'Edit Person' panel
back to 'Add New Person'.
2. Persons List. This is the data table of already available persons.
Each row of the table corresponds to a single person. Under the column headers there are
text fields for Filtering purposes. E.g. type something in the text field under the
'First Name' column header, and the table will filter its rows based on the entered value, so
if You type 'A', the table will show the persons whose First Name starts with an 'A'.
To update any person You have to click on 'Edit' image of the corresponding row
and follow the steps mentioned above in the 'Add New Person' section.
The last column of the table is for Person Deleting. To delete a person just click on 'Delete' image
and select 'OK' in the generated confirmation box.

That's all, Good Luck!

07/22/2013

This section of the system allows to manage the list of products and catalogs
which are available in the storehouse.
In the left side of the page there is a list of all available products/catalogs represented
in a tree structure. The root element of the tree is your current Storehouse.
All other sub items of the tree are Catalogs/Products which are available in the Storehouse.
Below are descriptions of the Product Management properties:

Catalog: this element is the general type of all its sub items.
e.g. 'Drinks', is a catalog for Juice, Beer and other beverages.
Catalog can have another catalog as its sub item, e.g. 'Alcohol Drinks' can be a
sub-catalog of the 'Drinks' catalog mentioned above.
It is possible to add any type of item (catalog, product) as a sub-item for the catalog.
Tree items which correspond to the Catalog item have an orange catalog icon next to their names.

Empty Catalog: this is a catalog which contains no sub items yet.

Product: this element is the actual product in the storehouse, which can be checked in (buy product) or out (sell product). Products can not contain any sub element - they are the last level of the tree hierarchy.
Tree items which correspond to the Product item have a box icon next to their names.

To easily find any catalog/product in the tree, just type its name or code in the text field above the tree, and click on a 'loop' icon or just press 'Enter'. It is also possible to use a bar code scanner to search a needed
product by its code. You just need to set the cursor focus on the search field,
and read the product code by the bar code scanner. You will see that the bar code will be shown
in the search field, and also the product with that code will be highlighted on the tree.
The same search option is available in all sections where the product tree is available

Following actions are available for the Product tree: Add Item, Edit Item and Delete Item.
For each action, a respective button is available in the left side of the page - above the tree.
To initiate any action, You should first select any item of the tree.
After selecting the item, action buttons will change their status, e.g. when no item is selected,
all buttons are in disabled mode, after selecting an item, some of them will become enabled/disabled
based on the selected tree item(element).
In addition to the mentioned buttons, the same functionality is possible to implement by means of help
topics which are generated after any tree item selection. Help topics contain information
about actions which are possible to implement for a selected item. Before each action
definition, a corresponding link is available for its performance.

07/02/2013