PROCEDURE FOR THE CLOSURE OF BALANCES IN STOCK

1st Step - Check the content of the parameter MV_ULMES

With the support of the systems area, the content can be verified
parameter MV_ULMES that reports the date of the last stock closure performed.

This parameter blocks the inclusion of movements in the SD1–Items tables.

entry document, SD2 - Items of the exit document and SD3 - Movements
internals with dates equal to or earlier than the date recorded in its content.
Example:
MV_ULMES = 20190630
In this example, the last stock closing was on 06/30/2019. Thus, the
The system does not allow stock movements with a date equal to or earlier than today.
as of 30/06/2019.
The review of this parameter will be done through the configurator, in the option of
parameters

Step 2 - Recalculating the entry cost of goods (verify the need)

Check the need to run the Entry Cost routine.

This routine is intended to recalculate the entry cost of the goods.
registered in the materials reception. Execute it whenever some parameter
influence the modification of the product cost. For example, the modification of the TES:
tax rates, calculation of taxes, tax credits, etc.
For this, we should go to the Purchases/ Miscellaneous/ Entry Cost (2) module.
In the next window we will click on parameters (1)

And it shows us the parameters window, where we will indicate the date of when
we will carry out the cost reprocessing of input (1)

In the next window we click on ok

A confirmation window appears for the process we want to carry out and we give
click on Yes

In the following window, it indicates that the process will be carried out in shared mode,
according to the parameter MV_CUSTEXC. Which means that while it is
the entry cost process is running, other users may be
working in the system. If the parameter were to run in exclusive mode it would be
It was necessary for no one to be connected to the system in order to execute this routine.
This parameter ensures the integrity of the calculation made since if during the
calculation process would have users entering operations within the period that is
it is carrying out the calculation these can affect the correct calculation of the process, that's why
it is safer to carry out the process in exclusive mode.

Finally, a window appears where we will select the last price of

buy and click on Ok.
Step 3 - Product inventory (check for necessity)

In the case that the quantity, cost, and financial balance of the products in the system
If they were in agreement with reality, this step would not be necessary. But if not,
In that case, it would be advisable to conduct a physical count of the materials, confronting
the results with the balances recorded in the system.
When there is a need to make the inventory adjustment, the following must be carried out
next steps:
Blocking of products for physical counting, through the Bloq routine.
Inventory, located on the Stock and Costs route /Updates/ Processing/
Block. Inventory
Generate the list of products to count, using the Product List routine,
located on the route Stock and Costs/Reports/Inventory/Product List
Carry out the registration or upload of the physical count in the system through the routine.
Inventories, located on the Stock and Costs/Updates/Movements route
Inventory. The value of the count that is divergent must be typed in
the Inventory.
Print the divergence report, for which we will go to the Stock path and
Costs / Reports / Inventory / Verification, with this report we can know the
differences that exist between the physical count and the information recorded in the
system; and the adjustments that will be made
Process the Inventory Adjustment, for which we will go to the Stock route and
Costs/Miscellaneous/Processes/Inventory, with which we will have completed
the inventory adjustment.
Unlock the inventoried products
Note: it is necessary that this process has already been explained to the logistics personnel and
distribution

4th Step - Execute the Recreate Balances routine (check its necessity)

The Rehace Saldos routine aims to calculate and provide the situation.
of stock through the movements of the System (incoming and outgoing invoices as well as
internal movements in the stock). For each item in the stock, the System recalculates, in
quantity and value, the stock balances and the initial balances. Available in the Stock route and
Costs/Miscellaneous/Redo Balances
Entering the routine, the following parameters window will appear.

- From Warehouse to Warehouse: To indicate the codes of the warehouses in which

We want to calculate the current balance.
- From product to product: To indicate which products we wish to perform the calculation for
current balance. To indicate all products leave the first field blank and
put ZZZZZZZZZ in the second field.
- Set balances to zero in production. MOD: Identify if the program should set balances to zero.
of MOD product or not, since these products accumulate negative balance month by month.
Available Options:
oSi - Reset the balances of the MOD products to zero
oNo - Maintains the balances of MOD products
Recalculate - Recompose the balance of the MOD
- Set CM prod. MOD to zero: Identify if the program should set the balances to zero.
of MOD products or not, as these products accumulate negative balance month by month.
Available Options:
oSi - Reset the balances of the MOD products to zero
oNo - Maintains the balances of the MOD products
Recalculate - Recompose the balance of the MOD
- Block SB2 Records: Identify if the program should leave the balances at zero
MOD product or not, as these products accumulate negative balance month by month.
Available Options:
oSi - Leave the balances of the MOD products at zero
oNo - Keeps the balances of the MOD products
Recalculate - Recompiles the MOD balance
- Select Branches: Select the desired branches. If NO is selected, it
will affect the current branch.
5th Step - Recalculation of the average cost (mandatory procedure)

The objective of the Average Cost routine is to recalculate the average or accounting cost.
in each valuation of the product stock, based on the new entries of
raw materials added to the existing balances.
To do this, run the Average Cost routine, which allows you to recalculate the average cost of the
items moved in stock, where the final deadline requested in the configuration of
the parameters is the same date as the inventory entry date or the date used in
the parameter of the Inventory Adjustment routine.
The costing method defined in Bakels is monthly, so it will be done once.
registered all the operations of the month that you want to cost. Separately, it
Can generate the accounting entries for the operations involved in costing,
how is the production and the cost of sales.
For more details on how to carry out the costing, please refer to the manual sent by email on
the execution of the costing process and the generation of its accounting.

Step 6 - Results verification procedure

Before making the stock closure effective in the period and executing the Closure of the
balances, it is necessary to issue all stock verification reports that allow
analyze the stock situation, verify the daily movement of products by
In the middle of the kárdex, visualize all stock entries and exits by type of material.
etc.
Example:
Printing of the Analytical Stock Situation Report
Which allows us to obtain the balance of the products on a specific date. For its
We should go to the Stock and Costs/Reports/Balances/In Analytical Stock route
The following window appears where we can select in what format
we want the report to be generated. For our case, we will indicate in type Sheet(1),
so that it generates for us in Excel, then in the environment(2), we will choose local, so that it
save the file on our machine and not on the server, and in spreadsheet type (3),
we will indicate in table format, for a color visualization. Finally, we will go to
other actions and parameters (5)

We will be shown the list of parameters for

Where we will select the parameters according to those in the screenshot,
except for the following:
- From branch to branch, if we want to indicate the balance of the products of a single
we will enter the desired branch code in both text boxes,
for example for Lima it would be 0101, Chiclayo 0102 and Arequipa 0103. If we wish
all branches, we leave the parameter as shown in the screenshot
From product to Product, if we want to generate for all products
we will leave the first text box blank and we will complete the next one with
ZZZZZZZZZZZZZ, if we want a specific product like in the case of the
For example, we will repeat the product code in both text boxes.
Reference date, to which date we wish to display the balance of
the product(s)
We will click on Ok, this will not return to the previous window and we will click on
Confirm. The system will generate the report in Excel

Daily Kardex Report Printing

To do this we will need to go to the path Stock and Costs/Reports/Analysis/Movements/
Kardex/Daily Kardex

A window similar to the previous report will be displayed and we select the
same parameters and click on other actions/Parameters
In the following window, we can specify the parameters that we will use for the
creation of the report

Where we will select the parameters according to those in the screenshot,

except for the following:

From product to product, we can indicate a specific product for which

we will repeat in the two text boxes the product code or select
all products for which we will leave the first text box blank and
the second we will complete with ZZZZZZZZZZ
 From period to period, we indicate the date range for which we desire the
generation of the kardex.
- Document/Sequence, if we want to view the document number of the
operation, such as the referral number, invoice, etc.; or and if
we wish to indicate the registration sequence number, which is an identifier
in what sequence the documents were recorded.
Balance to consider, in case the period for which you wish to generate the kardex
if it is a closed period, select closed if it is a period that is still being
working to select current.

Note: This report will be generated by branch, with one being generated for each branch.
The sum of the three daily kardex must match the analytical stock report.
7th Step - Execute the Close Balances routine (mandatory procedure)

This routine allows for the final balances, calculated by the Cost Recalculation routine.
mid, they are transferred as initial balance from the date reported in the parameterDate
basis for executing the closing.

When performing the balance closure, the System updates the records of the file SB9–Balances.
initials, which make up the initial balances of the next period, with the final balance
obtained in the recalculation of the average cost.

In addition, update the MV_ULMES parameter with the reported closure date.
this way, it will not allow stock movements with an earlier date
or equal to the closing date.
To close the stock at the end of the period, run the Balance Closure routine.
which we locate on the path Stock and Costs/Miscellaneous/Close Periods/Closure of
Balances (4)

We are shown the following window, indicating that the parameter MV_CUSTEXC
is in shared mode. (*) In point 2 of this tutorial, it was explained the
functionality of this parameter. And we click on Yes.
In the following window, we have a list of parameters that we will leave as is.
image capture and we click on ok

The following window appears where we will select all the branches and
we click on OK.

We are shown the following window, where the date until which it will be carried out appears.
the close (1) and we will click on Ok (2)

With this, the system begins to carry out the closing process of the period by branch, to
finally a message will be displayed indicating that it was completed successfully.
closing process of subsidiary 0101, and upon confirming this window it will continue with the
closing process with the following branch and so on until finished.