SIC-JAC Inventory Control System Guide
SIC-JAC Inventory Control System Guide
System of
Information
Accountant
Inventory Module
INTRODUCTION:
The SIC JAC Inventory System allows for the control and valued physical tracking of the
items or products from a warehouse.
In SIC JAC Inventories, items are organized at the following levels: Category,
Subcategory and product (items). For this reason, the Inventory system allows you to manipulate
your information in an organized manner and minimizing the time for handling and controlling your
inventories.
The category code is 4 digits long, the sub-code of the
category has a length of 4 numeric digits and product or item code is
composed of the category code plus the sub-category code plus a sequential number
specific to the product or item, with a length of 4 digits. This coding allows for defining up to
9,999 items for each sub-category.
The entry of the product or item for different concepts: initial inventory, purchases
with invoice (F), assumed (R) (purchases without invoice) and None (N), which is neither with invoice nor
assumed.
The exit (departure) of the product or item is done at the weighted average price, in
function to the existing balances.
The movement of entries and exits allows for different reports: Daily report of
entries and exits, valued physical kárdex report, balance report and others.
The system, due to its acquisition cost and functionalities, is suitable for companies.
with very extensive inventories
The evaluation method of the system is the Weighted Average Cost method and the coding
The item is up to choice. We can choose between Manual Coding and Automatic Coding.
Various reports are generated ready for printing, and there is also the option to export to
I excel at those reports.
In the main menu of the system, you can create several companies, each independent of
the other. Each company with its corresponding management.
Among its main features, in addition to those already mentioned, is that for the purpose of
management can update its inventory by indices, applying Accounting Standard No. 3.
CONCEPT:
The Inventory System allows you to keep valued physical control of your warehouse.
versatile, since the user can register or parameterize according to their needs and
previous experience, the options of:
SYSTEM REQUIREMENTS
The hardware required for the installation of the Accounting System SIC - JAC must
to have the following characteristics (AT A MINIMUM).
INVENTORY MODULE
The Inventory System allows you to keep a valued physical control of your warehouse. It is
versatile, as the user can register or parameterize according to their needs and
previous experience, category options, subcategory, item, client, supplier,
personal and types of movement This parameterization and categorization of the items, is
will be reflected in the results, which are the reports generated by the system.
The valuation system used is the Weighted Average Cost and the coding
The item is a choice. We can choose between Manual Coding and Automatic Coding.
In all the reporting options that the system generates (except for entry notes and
exit), there is the option to export to Excel.
Export to Excel
You can export directly to Excel from the reporting options available in the system.
Index Update
For management purposes, you can update the balances by the Housing Promotion Index (UFV).
from their warehouse, in such a way to have all the products detailed reflected with their
corresponding inflation. This application is optional, in case you want to reflect your
inventario para la siguiente gestión con saldo actualizado por índices, o no.
Detailed control of Warehouse Inputs and Outputs
Before making a record of the warehouse movement, parameters are given that indicate the
supplier information, the destination of the product or item, and the personnel that authorize it
movement. With this data, we can see reports by destination, by provider, by
personal and in that way determine the correct movement of the registered products
in the system.
INSTALLATION:
1. PREVIOUS STEPS TO THE INSTALLATION OF THE "SIC-JAC" SYSTEM
Once the uninstallation of the inventory system is completed, YOU CAN PROCEED WITH
THE INSTALLATION of the new Inventory Control System.
On this screen, you will also find the tutorial video and the system operations manual.
of Inventories
Step 2) Click on 'Install Inventory Module':
Step 5) Press "Change...>", it is recommended to install the system on a different drive than the
unitC, follow the steps below to change the unit:
Enter the company data, the data you must enter is: Name,
City Year select period y then pulse Accept
4. ACCESS TO THE INVENTORY CONTROL SYSTEM
Once the company is created, click on the company name.
Next, the management will appear as shown in the following screen:
Double click on management and then the following screen will appear:
Enter the date, the exchange rate, and the UFV; if you have this data, enter it.
the opposite can place 0.
The username is "X" and the password is "Y". The password is not displayed, only
an asterisk (*). Press "Accept". Afterwards, you can create a new user with
the username and custom password.
5. ADD NEW MANAGEMENT
Step 1) Click on the name of the company, then press 'Add'
Management.
By default, the company name, city, year, and period appear; you can change it.
the name of the company and the city, cannot change the year and the period. Then press
Accept
OPERATION OF THE SYSTEM
WAREHOUSE ENTRY
To register an entry to the warehouse and print the movement of the entry, go to the menu
In 'Inventory', select 'Movement' and then click on 'Entry to
"Warehouse", will display the following screen:
On the main screen, you must select the Add button, in the first row place the
following data: the number of entries is a non-editable field, mark with or without VAT,
coloque elnúmero de factura o nota de recepción, según corresponda, laFecha, elTipo
Select: Source (Resources), Type of Income, and Provider.
Next, enter the Concept, select Authorized by, and Delivered to.
To add the items, you can place the item code in the code column, if not...
remember you can press the Search Item button or (F2), it will filter the item list, making
Double click on the code will pull the item to the main screen, then add the quantity and the
total amount of the invoice (if applicable) and finally press the Save button.
On the main screen you will find the Edit button, which allows you to modify all the
fields of the top part or header, that is to say you will be able to modify, Supplier Invoice,
Fecha,Tipo de Cambio,Fuente(recursos),Tipo de Ingreso,Proveedor,Concepto,
Authorized by and Delivered to.
You will not be able to modify the item fields (code, quantity, and total).
Next, select the Destination (customer), Authorized by, Delivered to, and place the
Concept of the output of the items.
To add the items, place the item code in the code column, if you don't remember it.
You can press the Search item button (F2), it will display the item list, double-clicking on
the item code will pull the item data to the main window. In the field, Quantity,
it will show the quantity available in stock, enter the required units and finally
press the Save button.
On the main screen, you will find the EDIT button, which allows you to modify all the ...
fields of the top or header, namely Delivery Note, Date, Type of
Cambio, Tipo de Salida,Destino (Cliente), Concepto, Autorizado PoryEntregado
a.
You will not be able to modify the fields of the items (code and quantity).
Another button that is VIEW, this allows you to have the report of the Exit Note.
from the Warehouse
To change an item, position the cursor on the code of the item you wish to change and
enter the correct code, if you don't remember you can press the Search Item button (F2),
It will display the item list; double-clicking the code will pull the data into the window.
principal.
If you want to add another product in this same window, use the keys of
addressing, and I moved down to the next blank row in the code column, I pressed the
searchButton Item (F2), repeat the previously indicated steps. Lastly,
press the save button.
MODIFICATION OF WAREHOUSE OUTPUTS
To Modify Warehouse Outputs, go to the 'Inventories' menu, select
"Movements" and then click on "Modification of Warehouse Outputs"
and you will get the following screen:
On the main screen, select the output you want to modify using the arrows.
addressing that is located at the top of the screen, then press the
Edit button, all data will be enabled except for the output No., the Date,
and the Exchange Rate.
To change an item, position the cursor over the item you want to change and place the
correct code, if you do not remember it you can press the Search Item button (F2), it will show the
item list, double click on the code and the data will be pulled.
If you want to add another product in this same window, use the keys of
addressing, go down to the next blank row in the code column, press the
Search Item button (F2), repeat the steps already mentioned above. Lastly,
press the save button.
SALES
To register a sale, go to the "Inventory" menu, select "Movement" and,
Next, click on "Sales."
On the main screen, press the Add button, enter the following data: No.
The output is a non-editable field, check with or without VAT, enter the invoice number or
Receipt (as appropriate), the Date, the Exchange Rate, select: Type of Output,
Destino(cliente),Concepto,autorizado poryentregado a(vendedor).
To add the items, you can enter the item code in the code column, if not...
remember you can go to the Search Item button or (F2), it will filter the item list by double clicking
In the code, it will pull the item to the main screen, then add the quantity that will be sold.
of the item and finally press the Save button.
On the main screen you will find the EDIT button, this allows you to modify all the
fields in the top part or header, that is, Invoice or Receipt, Date, Type of
Cambio, Tipo de Salida, Destino(cliente),Concepto, Autorizado PoryEntregado a.
You will not be able to modify the fields of the items (code and quantity).
Another button available is VIEW, this allows you to see the Sales Receipt report.
ITEMS
For the registration of items, we can differentiate two types of coding: the coding
manual and automatic, you must configure this in the "Inventories" menu select,
click on "others" then "encoding"
To register an item, go to the "Inventory" menu, select "Items," and then do
click on "items", it will display the following screen:
On the main screen, you will be able to see five buttons, which are: Add: allows you
add items, Modify: allows you to modify the item data, Delete: allows you to
delete items, as long as it has no movement, View: allows you to see a
Report of the items and Exit: which allows you to exit the item addition screen.
ADD ITEMS (PRODUCT)
To add an item, follow these steps: on the main screen, press the button
Add.
On the item deletion screen, it will show you the data of the item to be deleted, once
Once these fields are verified, press the Save button, otherwise Cancel.
You will delete the item if it has no activity; if it has activity, you will not be able to delete the item.
On the main screen you will see four buttons which are: Add: it allows you
adicionar categorías, Editar:le permite modificar los datos de las categorías,Visualizar:
it allows you to view the report of the categories and print, and Exit: it allows you to exit the
category screen.
ADD CATEGORY (PRODUCT):
To add a category, press the Add button.
On the add category screen, the field Code is not editable, in Name, enter the
category name. Finally, press the Save button.
EDIT CATEGORY (PRODUCT):
To edit a category, select the category you want to modify, click on the
code and press the Edit button.
In the edit category screen, you can only modify the Name field, once modified.
press the button Record.
To view the report of the categories, press the View button, and the report will appear.
the categories.
SUBCATEGORY OF PRODUCT
To create, edit, and print subcategories, in the 'Inventories' menu, select 'Items'
Then, click on 'Sub Category', and you will get the following screen:
On the main screen you will see four buttons which are: Add, Edit,
Visualizar y Salir.
ADD SUB-CATEGORY
To add a subcategory on the main screen, press the Add button and follow
the steps:
MANAGEMENT UNIT
To create, edit, and print management units, in the 'Inventory' menu, select
"Items" and then click on "Handling Unit", and you will get the following
screen
On the main screen you can see four buttons which are: Add, Edit,
View and Exit.
ADD MANAGEMENT UNIT:
To add a handling or measurement unit, press the Add button on the screen.
principal.
On the screen add unit of measurement, the field Code is NOT editable, in Name
Enter the name of the unit of management or measurement, and finally, press the Save button.
TYPES OF MOVEMENTS
TYPES OF INCOME To create, edit and print Types of Income, in the menu
In 'Inventory', select 'Types of Movement' and then click on 'Types of
"Login", and you will get the following screen
In the main screen, you will be able to see four buttons which are: Add: allows you to
Add, Edit: allows you to modify data, View: allows you to see the report, and Exit: allows you
allows you to exit the screen.
ADD INCOME TYPES:
To add a type of income, on the main screen press the Add button.
you will obtain the following screen.
On the screen for input type addition, the Code is not an editable field, in Name:
enter the name of the type of entry or movements. Finally, press the button
Save.
EDIT A TYPE OF INCOME:
To edit an income type on the main screen, select the income type you want.
Edit, click on the code, then press the Edit button.
In the income type editing screen, Code is a NON-editable field, you can modify the
name of the type of income, once modified press the Save button.
INCOME TYPE REPORT:
Press the Visualize button to obtain the Income Types report, previously
displays on screen and then can print if desired.
TYPES OF EXPENSE
To create, edit, and print Income Types, in the 'Inventory' menu, select 'Types'
of movement” and then click on “Types of Expenditure”, and you will get the following
screen
On the main screen, you will see four buttons which are: Add: allows you to
Add, Edit: allows you to modify data, View: allows you to see the report, and Exit: allows you
allows to exit the screen.
ADD EXPENDITURE TYPES:
To add a type of expense or exit, on the main screen press the Add button.
In the output type addition screen, the Code is a NON-editable field, in Name
Enter the name of the output type and press the Save button.
EDIT EXPENSE TYPE
To edit a type of expense or exit, on the main screen, select the type of expense to
Edit and click on your code, then press the Edit button.
In the output type modification screen, the field Code is NOT editable, you can
modify the name of the output type or Movement, once modified press the button
Record.
EXPENSE TYPE REPORT
Press the View button to obtain the Types of Expenditure report, previously.
Displays on screen and then you can print if you wish.
REPORTS
DAILY REPORT ENTRIES AND EXITS
To view the report, in the 'Inventories' menu, select 'Reports' and,
continue, click on
Daily report of entries and exits, and follow these steps:
Pressing the VISUALIZE REPORT button
2. GENERAL REPORT
To view the report, go to the "Inventories" menu and then "General Report", and follow the
next steps:
Pressing the button ACCEPT
Select any of the options to view the report of: Entries, Exits, Clients,
ProveedoresyPersonal, también puede verlos en un rango de fechas.
Pressing the ACCEPT button. It will show you the report according to what you selected.
To view the departure report with destination, it is necessary to select the item and you will be able to see the
report.
Pressing the button VIEW REPORT
This report is used to present the movement of controlled substances to the offices.
from the General Directorate of Controlled Substances.
The screen will display all the data of the selected item: quantity, cost, amount,
selling price and sale price amount.
Pressing the PREVIEW button
NEW USER
To create a new user, go to the 'Inventories' menu, select 'Utilities' and,
Next, click on 'New User', and you will see the following screen:
USER ACCESS
To grant access to a new user, go to the 'Inventories' menu, select 'Utilities' and,
Next, click on 'User Access', and you will get the following screen.
On the main screen, select the user name; once selected, you can check it.
the options that I want to give to each user, if all options will be provided they can check
at the bottom of the window and press the Apply Inventory button, this will mark you
all options. Then press save to save the data or otherwise
Cancel.
BACKUP OF THE INFORMATION
To generate a backup of the information, go to the 'Inventories' menu, select
"Utilities" and then click on "Information Backup (Backup)". This
the window has two options:
The first option will generate a backup in the default folder, this is located inside
from the folder generated by the system upon installation, for example, its location will be: E:\SCI-
JACV\XXEMPRE\201X\BACKUP\, you simply need to press the Get copy button
now.
The second option saves the information in a selected folder, for this you must
select the second option and the button will appear. Follow the steps:
A window will then appear where you can select the location for the backup, such as
you can observe in the following image:
Finally, press the Get copy now button, as shown in the following image:
The system will generate a compressed file with a .RAR extension, the name of the file will be
IN_011701_310717095745, depending on the company, date, and time.
The file is read as: Inventory company number + period + type of closure day month year hour
minutes seconds.
RECOVERY OF BACKUP DATA
This option allows us to import data from a previous inventory system or from a
backup. To enter this option you must go to the 'Inventories' menu. Select the option
"Utilities" click on "Import Data, Recovery of Backup Data"
(Backup)" and follow the following steps:
Press the Browse button. A new window will appear where you must select the
folder where the backup is located, as shown in the following image:
Please note that you must unzip the .rar file before looking for the folder, otherwise
if it were uncompressed it would not be visible at the time of searching. Once selected
folder press Import Data. See Previous. or the opposite Cancel.
INITIALIZE INVENTORY
To generate the initial inventory, in the 'Inventories' menu, select 'Others' and, to
Next, click on 'Initialize Inventories' and you will get the following screen:
This option allows you to generate the initial inventory, register the type of change of the date of
start of the period, select the Type of Income (Initial Inventory), you can mark if you want
updated balances to current values. Finally, press the Generate Inv button.
Initial.
This option can only be executed if the previous period was closed with the 'SCI' system.
JAC" (Inventory Control System).
INVENTORY UPDATE
To generate the inventory update, in the "Inventories" menu, select "Others".
and then click on 'Inventory Update' and you will get the following
screen
This screen shows two boxes: one option is used to update when the balances
They are not correct; if there were other users using the system, they must leave the network.
to execute this option.
The other option allows updating by indexes, that is, one must obtain a factor (UFV of the
closing date / UFV of the last purchase date), and multiply by the amount of the value
This option is executed at the end of each period.
TYPES OF CODING
To create the type of encoding, in the "Inventories" menu, select "Others" and,
Next, click on 'Encoding Type', and you will get the following screen:
Two groups of options are observed: Manual Coding and Automatic Coding.
If you select either of the two options, you will have two different ways to be able to
create a specific item, that is:
Manual coding; it allows you to create up to 20 alphanumeric characters, that is, between
number and letters within the item code.
Automatic Coding; this type of coding is composed of three types of
data that was created during the parameterization, namely: Category, Sub-Category and the
Corresponding correlativo of the item as such.
NOTE: Within the options seen on the screen, the Type can be changed.
Automatic coding manual and not thus manual automatic
ADVANTAGES:
He/She is friendly
Easy to use
We can modify the company's data.
We can add several companies, each one dependent on the other.
Allows personalizing users and determining access
Allows the entries and exits of the warehouse
We can modify the data of an added company
It allows us to select manual and/or automatic encoding.
Register an entry to the warehouse without a prior purchase order
Allows modifying supplier data
DISADVANTAGES:
Define management units for items, sale price, and minimum quantities.
maximums
We must fill in all the fields so that it allows us to save.
The code. It is not editable, you must enter the personnel data.
The code. It is not editable, you must enter the staff data.
IDENTIFIED DEFICIENCIES IN THE SYSTEM.
When adding, modifying, or deleting a registered company, the system requires that
the other users leave the system
When installing a new version, the folder must be renamed.
container of system files, in case of omitting this step, it can be
overwrite and lose all the information of companies from the previous version.
The system does not allow importing the UFV index from Excel, the filling of the data
the UFV must be done manually for the 365 days of the period.
(Delinquent Procedure)
The exchange rate must be entered manually for each day.
RECOMMENDATIONS:
CONCLUSION:
The system is very useful for controlling inventory entries and exits, in addition to having
very comprehensive features such as updates, inventory reports, reports by
type of product, etc.
BIBLIOGRAPHY:
[Link]
[Link]
[Link]
[Link]
SICJAC-2014-pdf
[Link]