Árvore de páginas

Stock Site Maintenance - CD0611

Program Overview

You can use this function to control the specific Material Area parameters created when you add sites to the program Sites Maintenance (CD0602).

The companies that convert from other releases will already have defined their sites in program Sites Maintenance (CD0602). Thus, you are required to define the sites of materials for all sites with transactions in the materials area.

A relevant point is made about the ledger accounts implemented in folders Ledger Acct1, Ledger Acct2, Ledger Acct3, and Ledger Acct5, considering that module Receipt indicates their listing for updating incoming invoices, thus turning the maintenance of this function into a requirement for using the Receipt Module.

As the closing type parameters are set to By Sites in program Stock Parameters Maintenance (CE0101), which enables non-simultaneous stock closing, you must check the dates that indicate the progress of processes in this function.

Important:

You must set the parameters of all sites before closing stock, regardless of whether the closing type is by site or single, in accordance with the parameter in Stock Parameters Maintenance (CE0101).

You also need to set this parameter to generate purchase needs for restocking, because, from version 2.02 onwards, needs are managed and generated by always checking which is the main site linked to the site that needs to be resupplied.

After detecting the main site, the system locates whether any more sites have the same main site, generating a single order. Thus, the system detects the purchasing need to meet all sites sharing the same main site.

Rule:

  1. The factors affecting the calculation to generate orders, with Order Point, Economic Batch, etc., are from the main site.
  2. Sites registered as default sites cannot be registered in more than one main site.

Stock Site Maintenance

Purpose of the Screen:

To set the site parameters of default entity for controlling dates related to stock closing.


Main Fields and Parameters:

Field:

Description

Default Site

Select the site that characterizes a unit or registered industrial park.
Be mindful that the site to be set as default can only be linked to one main site.
The parameter entered is automatically assumed by the system when you enter it, if the Company has only one site, or the video displays it as default so you can either confirm it or change it.

Main site

The main site is the site of the parent company. In this field, select a site code.

Stock Site Maintenance - Data Folder

Purpose of the Screen:

To define some data to be assumed as default, which the Stock module suggests in site transactions, besides defining booking and apportionment criteria.


Main Fields and Parameters:

Field:

Description

QC Warehouse

To select the quality control warehouse of site.

QC Rejection Warehouse

To select the quality control warehouse of site.

Ledger Cost

To select the type of accounting cost used in the site. Accounting cost is the cost chosen by the user as the cost for booking stock transactions. Options available:

  • Monthly;
  • Online.

Use Online.

When selected, it determines that the type of managerial cost of the site is online.

Note:

This field is only enabled if the option selected in accounting cost is Monthly.

Apportion Business Unit Value

Select the option that defines whether the apportionment of values transferred in stock with business units for fractioned items is automatic in Average Price Calculation (CE0401) or manual through the Business Unit Apportionment Calculation – Batch (CE0913). Options available:

  • Automatic (Average Price Calculation);
  • Manual (Business Unit Apportionment Calculation – Batch).

    Note:

    This field is only enabled if in program Stock Parameters Maintenance (CE0101), folder Closing, the Closing Type selected is "By Site". When the option selected in this folder is Single, this field remains disabled.

Stock Site Maintenance - Consumption Folder

Purpose of the Screen:

Define item consumption criteria through classes A, B and C.


Main Fields and Parameters:

Field:

Description:

Minimum Days Class A
Minimum Days Class B
Minimum Days Class C

Enter the minimum period, in running days, required to purchase an Economic Batch of Class A, B, and C Items.

Important:

When considering the deadline for purchasing an Economic Batch, the system assumes the parameter entered as a limit if the calculation yields a number of days lower than the value specified.

Maximum Days Class A
Maximum Days Class B
Maximum Days Class C

Enter the maximum period, in running days, required to purchase an Economic Batch of Class A, B and C Items.

Important:

When considering the deadline for purchasing an Economic Batch, the system assumes the parameter entered as a limit if the calculation yields a number of days lower than the value specified.

Max % Class A
Max % Class B
Max % Class C

Enter the consumption percentage of Items belonging to Class A, B and C, used for calculating the ABC Classification, which takes into account the estimated consumption of the item and the percentage defined for each class.

Period orders

Enter the representative number of the actual quantity of Purchase Orders, which the Department is able to issue and manage per month.

This information is very important for sizing the quantity of economic batches of Items to be purchased in the period. If the capacity of the purchasing department of the company is too high, you must reduce the number of Batches. Otherwise, you must increase it.

Stock Site Maintenance - Ledger Acct1 Folder

Purpose of the Screen:

To define the default accounts to be suggested in stock transactions of the site.


Main Fields and Parameters:

Field:

Description:

Suppliers Suspense Acct

Enter the code of the ledger account that will receive suspense entries from suppliers.

It will be credited upon entry, by gross value (goods + IPI + expenses) and the balance account of items will be debited by the net value (goods - recoverable ICMS + unrecoverable IPI + expenses), yet debiting recoverable taxes in respective accounts.

By the entry of trade notes in Accounts Payable, there is a credit in suppliers account and a debit in suspense account, zeroing the balance at the end of the month.

Important:

You must check whether the suspense account is not set to zero at the end of the month, if an inversion of accounts occurred in invoice value entries (between Stock and Accounts Payable).

Physical Receipt Suspense Acct

Enter the suspense account code for updating the physical receipt executed by the Receipt Module.

Entry consignment

Enter the code of the ledger account used for material receipt entries from another company, on consignment.

Consignment Outflow

Enter the ledger account code for outflow entries of materials shipped on consignment.

Processing Inflow

Enter the code of the ledger account that receives entries of material transfers received for processing.

Processing Outflow

Enter the code of the ledger account that receives entries of material transfers sent for processing.

Customer return

In this field, enter the suspense account for returns, to be used if there is no accounts register for billing (CD0309).

The account entered herein must be defined.

Important:

To use the billing accounts listed in the program Billing Accounts Maintenance (CD0309), module Receipt will first search using the nature of the operation and the return invoice series (incoming).

 
If no billing account groups (CD0309) are found with incoming invoice data, a new search is conducted using the nature of the operation and the outgoing invoice series (source of return).

If none of the two sets of information is found, the system uses the Suspense Account of Return from the customer, defined in this field, in CD0611.

Stock Site Maintenance - Ledger Acct2 Folder

Purpose of the Screen:

To define the default accounts to be suggested in stock transactions of the site.


Main Fields and Parameters:

Field:

Description:

Inventory Inflow

Enter the code of the physical adjustment ledger account to be used for Stock Inflow debits. The Stock account must be of Type (Not Consumption). This pertains the need to correct inventory and to reconcile the current accounting status with the physical balance of Stock; by Inflow transactions, debiting the Balance in Stock Account and crediting the Inflow Inventory Variation Account.

Note:

To better understand how to use this ledger account parameter, we also recommend you read the concept of Inventory Adjustment Transaction Generated in Stock.

You may fill out the same Account for Inflows and Outflows, in Inventory Variation transactions, if interested in total variation.

Inventory Outflow

Enter the code of ledger account to receive entries in counterpart of inventory update of stock outflow (stock balance greater than physical balance). 

Note:

To better understand how to use this ledger account parameter, we also recommend you read the concept of Inventory Adjustment Transaction Generated in Stock.

Labor Account

Enter the code of labor suspense account for entering calculated values of Service and Production Orders in progress.

When calculating allocated labor values at each Production or Service Order, the need arises to debit Accounts of Orders in progress, and to credit the various Labor Accounts of Cost Centers. As there are several debits on one side and several credits on the other, making the relationship between these entries difficult, we have opted for a Suspense Account solution. Thus, there will be multiple debits in accounts of Service Orders in progress and only one credit in the Labor Suspense Account. On the other hand, there will be multiple credits in Labor Accounts of Cost Centers and only one debit in the Labor Suspense Account.

Transfer suspense

In this field, enter the suspense account to be used for transfers between warehouses (CE0206) and transfers between sites (RE1001).

Important:

In item transfers between warehouses, the system internally generates two transactions: outflow from origin warehouse of items and inflow in destination warehouse.

At time of outflow, a credit occurs in Stock balance account (at origin) and a debit in transfer suspense account.

At time of inflow, a credit occurs in transfer suspense account (at destination) and a debit in stock balance account.

The ending balance of the transfer suspense accounts, in the month, must be zero, with no difference between the entered debits and credits.

Physical Receipt Suspense Acct

In this field, enter the suspense account to be used in physical receipt of materials (RE2001).

Physical Receipt Count Difference

Enter the ledger account that receives entries of difference resulting from the quantity found in the invoice, with the count result in physical receipt.

Stock Site Maintenance - Ledger Acct3 Folder

Purpose of the Screen:

To define the default accounts to be suggested in stock transactions of the site.


Main Fields and Parameters:

Field:

Description:

Average Adjustment

The average adjustment calculation process determines whether the system must automatically update the adjustment entries; therefore, you must enter the code of the account to receive the counterpart of these adjustments in this field.

Note:

To better understand how to use this ledger account parameter, we also recommend reading the document that describes the Average Price Adjustment Transactions (CE0221).

Average Residual Absorption

Enter the ledger account to receive entries of material residues absorption, labor, or general manufacturing expenses. The residues are generated in valuation of items not subject to absorption, in the Cost Calculation process, which generates an adjustment transaction to set the value of this item to zero on the last day of the month, generating adjustments of type ACT 400, 500, and 600.

Important:

These residues must be within the average price absorption limit. Set the parameter for this limit in the Security folder of Item x Site Maintenance (CE0330).

Future Delivery

Enter the ledger account of future delivery to be used for invoice and remittance bookings.

Future Delivery Account

Enter the ledger account of future delivery to be used for future delivery bookings.

Future Delivery C. Center

Enter the code of cost center responsible for storing future delivery operation balances.

Invoice account Advanced

Enter the ledger account of advance billing, to be used for advance billing bookings.

Advance Billing C. Center

Enter the code of cost center responsible for storing advance billing operation balances.

Stock Site Maintenance - Ledger Acct4 Folder

Purpose of the Screen:

To define the default accounts to be suggested in stock transactions of the site.


Main Fields and Parameters:

Field:

Description:

Account entry processing

Enter the account code of unified processing inflow.

Cost Center

Enter the cost center code of unified processing inflow.

Processing Outflow Account

Enter the account code of unified processing outflow.

Cost Center

Enter the cost center code of unified processing outflow.

Physical Count Account

Enter the account code of unified physical count.

Cost Center

Enter the cost center code of unified physical count.

Absorption Account

Enter the account code of unified absorption.

Cost Center

Enter the cost center code of unified absorption.

Stock Site Maintenance - Ledger Acct5 Folder

Purpose of the Screen:

Define the default accounts to be suggested in closed warehouse and general warehouse transfers (Brazil only).

Main Fields and Parameters:

Field:

Description:

Closed Warehouse Inflow Account

Enter the account code of closed warehouse inflow.

Cost Center

Enter the cost center code of closed warehouse inflow.

Closed Warehouse Outflow Account

Enter the account code of closed warehouse outflow.

Cost Center

Enter the cost center code of closed warehouse outflow.

General Warehouse Inflow Account

Enter the account code of general warehouse inflow.

Cost Center

Enter the cost center code of general warehouse inflow.

General Warehouse Outflow Account

Enter the account code of general warehouse outflow.

Cost Center

Enter the cost center code of general warehouse outflow.

Stock Site Maintenance - Average Folder

Purpose of the Screen:

To set the Average Cost calculation criteria.


Main Fields and Parameters:

Field:

Description:

Average Calculation Phase

This field displays the phase up to which the Average Price was calculated. It is Automatically updated by the Average Price Calculation program if the average calculation in phases is chosen. The average price calculation is performed with intervals, each phase being executed sequentially.
The calculation occurs as follows:

  • Not Calculated: Not a single phase of the average calculation was performed.
  • Purchased Items: In the first phase, the average price of all items lacking production orders and maintenance orders in the month is calculated, valuating all material transactions appropriated in service/production orders.

Important:

After acquiring the costs of items calculated in the 1st Phase, the value of GGFs must be calculated, which are absorbed by the costing of production orders in the 4th Phase of calculation.

  • Maintenance Order: In the second phase, industrial maintenance orders are funded.
  • Investment Order: In the third phase, investment orders are valuated.
  • Production Orders: In the fourth phase, the average price of intermediate and finished products is calculated. Before determining the average price, the program calculates the manufacturing cost of each reporting transaction in accordance with related service/production order. This cost comprises the value of raw-materials, the value of direct labor and GGFs (hours x cost center hourly cost), the values of which were calculated in the first phase of average price calculation.

Important:

After calculating the average price of the item, all transactions without value are valuated at the calculated average price, including the transactions appropriated in service/production orders of other finished products.

Average price type

Select one of the options to determine which Average Cost type to use.

Options available:

  • Daily: to obtain an average cost for each day of the date range entered, using estimated values for GGF, although entered in field Cost Center Total of program Hourly Costs by Cost Center (refer to Cost Reference Manual – Data Preparation Process – Function Hourly Costs by Cost Center). For daily booking and reprocessing. This Average Price type cannot be in phases.
  • Monthly: to obtain a single average cost for the month. It may use actual GGF values entered in field Cost Center Total of program Hourly Costs by Cost Center (refer to Cost Reference Manual – Data Preparation Process – Function Hourly Costs by Cost Center), as it can only be processed after completing all stock and production transactions. You can reprocess it and its booking can be daily or monthly. The Average Price in Phases applies only to this Average Price type.

To better grasp the use of this parameter, we recommend reading the concept of Stock Items Batch Average Price Calculation.

Parameters

  • Generate Cost Adjustments Online: Use this parameter when you choose to calculate the average price online (this cost type applies only abroad), thus generating adjustment transactions online.
  • Generate Average Calculation Adjustments: When selected, the batch average calculation is performed regardless of adjustments generated in the average price calculation; otherwise, the calculation is performed all the way to the end. However, if adjustments are generated, the average calculation is automatically undone.

    Note:

    Adjustment transactions are generated by Average Price Calculation (CE0401).

    Refer to the Average Price Automatic Adjustment Transactions concept for details.

  • Average Price Started: Indicates to the system that the average price was started, not allowing any transaction dated the same or before the period being calculated.
  • Closing Started: Indicates to the system that the period closing was started, not allowing any transaction dated the same or before the period in which the closing is being executed.

Calculation decimals

Enter the number of decimal places for the internal average price during the calculation. The number of decimal places for the average calculation is only used in internal program calculations, aiming to reach greater accuracy in item prices, especially concerning items of reduced unit value.

Important:

The minimum number of decimal places used is four, a number used for the final recording of the item average price.

Valuate Transfer Inflow.

Use this parameter only when the Stock Closing Type is By Site. Do not use it when it is Group By Company nor if it is Single closing.

For other Stock Closing Types parameter "Valuate Transfer" of CE0101, Average folder, is used.

The initial value of this field is at Entered Price and you may change it to at Average Price. It determines how the NFT valuation will be for the Destination Site.

When you change the NFT valuation type from Entered to at Average Price, message 56560 announces the need to enter the relationship of Origin and Destination Sites for use in ce0132.

The NFT valuation type can be at Average or at Entered for each Site. There is no requirement for all to have the same valuation type.

If you do not change this parameter to valuate NFT at Average, what is found in the product remains, valuing at Entered, there being no need to enter the Site of origin and destination in ce0132.

Stock Site Maintenance - Periods Folder

Purpose of the Screen:

To display the periods pertaining the Stock Module closing routine, given that at Stock Site deployment you can fill out such fields. As the system runs the closing routines, it automatically updates this information, so that later maintenance is not possible.


Main Fields and Parameters:

Field:

Description:

Last day closed

Identify the date up to which the average price was calculated.

In module deployment, if the company chooses to work with monthly average price, you must enter the final date of the month corresponding to that which was calculated. If daily average price, you must enter the date of calculation day.

Last period closed

The date up to which stock transactions were summarized through program Accounting Summary (CE0407).

Monthly Average Date

Identify the date when stock transactions were integrated with accounting through Monthly Booking List (CE0412).

Summarized Until

Identify the last day of closed monthly period.

Important:

When working with monthly period closing, the last day of closed month is always displayed. If daily period, then it displays the last day closed.

Accounted to

Identify the last period closed. In module deployment, enter the last period closed and the system monthly updates at each closing in stock module.

Period Start

Identify the start of period pending.

End period

Identify the end of period pending.

Stock Site Maintenance - Scenarios Folder

Purpose of the Screen:

To view, add and delete accounting scenarios related to the site. Accounting scenarios are used for stock booking. With IFRS function parameter settings, the Stock Control module books the stock values by scenario, that is, an accounting batch is generated in module Tax Accounting for each accounting scenario set in parameters.
The International Financial Reporting Standards (IFRS) allow depreciating a fixed asset at a rate other than the rate expected by tax authorities. Thus, the depreciation value is apportioned between productive cost centers to compose the cost of finished products; hence, the depreciation value is considered part of the manufacturing overhead costs (MOH). Therefore, scenarios are necessary to harmonize Brazilian accounting with international standards.


Other Actions/Related Features:

Action:

Description:

Add

Activate this to add accounting scenarios.

Note:

The program Stock Parameters Maintenance (CE0101) automatically adds the IFRS and Tax scenarios for all sites.

Delete

Activate this to delete accounting scenarios.

Note:

You cannot delete IFRS scenarios. Program Stock Parameters Maintenance (CE0101) must delete them.


Main Fields and Parameters:

Field:

Description:

Scenario Code

Enter the code of accounting scenario.

Currency

Enter the currency considered for booking the accounting scenario.

Note:

The tax scenario and other manually added scenarios always consider currency (0).IFRS scenarios consider alternative currencies 1 or 2.

This field does not indicate the currency code, but whether it is currency (0), alternative currency (1) or alternative currency (2).

Accnt. To

Enter the last period booked.

Note:

When you associate a new scenario to the site, this field is updated with date "Booked To" of Site or, if the Stock Control module parameters are set to Single closing type, the date "Booked To" of stock parameter.

Tax Scenario

When selected, it sets the accounting scenario to Tax.

IFRS Scenario

When selected, it sets the accounting scenario to IFRS.


Related Content:
Constitution of Maximum % of ABC Class
Average Price Adjustment Transactions

DOCUMENT TRANSLATED

Spanish

English