Linha Microsiga Protheus - Inglês

Páginas filhas
  • Batch Acceleration of Depreciation -- 112218


Technical Bulletin: Batch Acceleration of Depreciation

Occurrence

Improvement

Summary

We have implemented the routine Batch Acceleration of Depreciation, with the purpose of automating the addition of type 07 - Acceleration of Depreciation to a set of assets selected by the user. Thus, depreciation occurs on an accelerated basis, as the asset is depreciated using its regular acquisition rate plus the acceleration rate. You can also end the acceleration, which posts items of type 07 from the assets selected, canceling the acceleration of depreciation for the following months.

ID of Ticket

SCJZII

Products

  • Microsiga 11

Modules

    • SIGAATF

Portals

    • none

Countries

    • All

Operating System

  • All

Name + Source

Batch Acceleration of Depreciation (ATFA175), Postings (ATFA030), Postings (ATFA035)

FNC Number

00000002332/2010

Compatibility Tool Adjustments

No

Referential Integrity

No

Patch Application

Compatibility Tool 1

- U_UPDATF

Implementation Procedures

Before running the U_UPDATF compatibility program, you must:

a) Backup the database of the product to be executed by compatibility program (“\PROTHEUS_DATA\DATA” directory) and SXs data dictionaries (“\PROTHEUS_DATA\SYSTEM” directory).

b) The above directories are the default installation of Protheus and you should edit them to match the product installed at your company.

c) This routine must run in exclusive mode; that is, no user should be using the system.

d) If data dictionaries have customized indexes (created by the user), be sure to identify them by their nicknames prior to running the compatibility program. If the compatibility program needs to create indexes, it will add them from the original order installed by Protheus, which may overwrite any customized indexes not identified by their nicknames.

e) You must run the compatibility program with Referential Integrity deactivated*.

ATTENTION: The following procedure must be executed by a qualified personnel such as Database Administrator (DBA) or equal!

*         Improper activation of the Referential Integrity may drastically change the relationship between tables on the database. Therefore, before using it, note closely the following procedures:

             i.        In Configurator (SIGACFG), check whether the company uses Referential Integrity by selecting option Integrity/Checking (APCFG60A).

             ii.        If there is no active Referential Integrity, all companies and branches registered for the system are listed on a new window and none of them will be selected. In this case, AND ONLY IN THIS CASE, you do not need any other procedure of integrity activation or deactivation; just complete the checking and apply the compatibility program as usual, following the instructions.

            iii.        If Referential Integrity is active in all companies and branches, a message is displayed in window Relationship Checking Between Tables. Confirm the message to complete the checking, or;

           iv.        If Referential Integrity is active in one or more companies, though not to its full extent, all companies and branches registered for the system are listed in a new window, in which only those with integrity are selected. Write down which companies or branches have the integrity activated and save this note for later reference on reactivation (you may also contact our Framework Help Desk for a file with this information).

            v.       In the cases described in items “iii” or “iv”, AND ONLY IN THESE CASES, you must deactivate the integrity by selecting option Integrity/Deactivate (APCFG60D).

           vi.        Upon deactivation of the Referential Integrity, run the compatibility tool in accordance with the instructions.

          vii.        Once you have applied the compatibility program, use option Integrity/Activate (APCFG60) to reactivate the Referential Integrity, IF AND ONLY IF it has been deactivated. To do so, have the information of companies and/or branches that had integrity activation at hand, select them once again, and confirm the activation.

IF YOU HAVE ANY QUESTIONS, contact the Framework Help Desk!


1. In Microsiga Protheus TOTVS Smart Client, enter U_UPDATF in field Initial Program.



      Important:

To correctly update the data dictionaries, make sure the date on the compatibility program is equal to or after 1/11/2011.

2. Click OK to continue.

3. When you confirm it, a warning message is displayed about the backup and the need to run it in exclusive mode.

4. Click Process to start processing. The first execution step is file preparation.

An explanatory message is displayed onscreen.

5. Then, the window Update Completed is displayed with the log of all updates processed. This update log only shows the fields updated by the program. The compatibility program creates the fields that do not yet exist in the data dictionary.

6. Click Save to keep the log displayed.

7. Click OK to close processing.


The system is updated after applying the update package (patch) of this FNC.


Adjustments Description

  1. Creation in file SX6 – Parameters:

Variable Name

MV_ATFRTBX

Type

Character

Description

Asset Posting routine used in the System.

Default Value

ATFA030

Procedures for Configuration

  1. In Configurator (SIGACFG), access Environments / Register / Menu (CFGX013). Enter the new menu option of Fixed Assets by following these instructions:

Menu

Miscellaneous

Sub-menu

Processing

Routine Name

Batch Accel. of Depr.

Program

ATFA175

Module

Fixed Asset

Type

Protheus Function

Tables

SN1 – Fixed Assets, SN3 – Balances and Values

Procedures

1. In Fixed Assets (SIGAATF) access Miscellaneous / Processing / Batch Accel. of Depr. (ATFA175).

The system displays the Wizard for using the routine.

2. Click Next.

3. Select the desired option: Activation of Acceleration / End of Acceleration

4. Click Next.        

 

Activation of Acceleration

Requirements:

    • The acceleration of batch depreciation must take place in the month immediately following the last depreciation calculation.
    • Configure standard entry 80A to book the activation of batch acceleration of depreciation (addition of asset type 07).

1. The System displays the parameter screen.

2. Select acceleration activation options:

Method: acceleration method. In this option, select whether the acceleration item depreciation rate to be created should be calculated based on the Shift - with options of 50% and 100% (One Shift - 1.5 and Two Shifts 2.0, respectively) - or by a Percentage to be defined by the user.

    • Shift to accelerate: If the method is by shift, choose whether the depreciation rate is accelerated by 50% or 100%.
    • Percent to Accelerate: if the method is by Percentage, enter the acceleration rate

3. Click Next.

4. Enter the asset selection type:

    • By Range: questions (From/To) for selecting the range of assets to be processed.

In this case, enter the data required and click Next.

    • By Entity: select the entity (Asset Group, Depreciation Account, Cost Center, Accounting Items, Value Class) through which the assets will be processed.

In this case, select the assets for acceleration through the entities and click Next.

5. A confirmation window is displayed. Click Yes to confirm.

6. Select the booking type, which can be:

    • Booking: enter whether booking is online (Yes) or offline (No).
    • Display Entry: If booking is online, enter whether to display the accounting entry onscreen for confirmation.
    • Group Entry: If the accounting is online, enter whether to group the accounting entry.

7. Click Finish.

The System activates the batch acceleration of depreciation for the assets selected.

 

End of Acceleration

Requirements:

    • The assets to have the ended batch acceleration of depreciation must be of type 07.
    • Configure standard entry 81A to book the end of the batch acceleration of depreciation (posting of asset type 07).

1. The system displays the Option Selection screen of assets for which the batch acceleration of depreciation will end.

    • By Range: questions (From/To) for selecting the range of assets to be processed.

In this case, enter the data required and click Next.

    • By Entity: select the entity (Asset Group, Depreciation Account, Cost Center, Accounting Items, Value Class) through which the assets will be processed.

In this case, select the assets for acceleration through the entities and click Next.

2. The confirmation window is displayed. Click Yes to confirm it.

3. Select the accounting type:

    • Booking: enter whether booking is online (Yes) or offline (No).
    • Display Entry: If booking is online, enter whether to display the accounting entry onscreen for confirmation.
    • Group Entry: If the accounting is online, enter whether to group the accounting entry.

4. Click Finish.

5. The System ends the batch acceleration of depreciation for the assets selected.

Technical Data

Tables

SN1 – Fixed Assets, SN3 – Balances and Values

Notes

 Important:

This routine does not perform the depreciation calculation. To calculate depreciation, use the routine Monthly Calculation (ATFA050).

Database: TopConect.