Value Adjustments in Assets from Fixed Assets -- 118292

Technical Bulletin: Value Adjustments in Assets from Fixed Assets

Occurrence

Improvement

Summary

The improvement is the integration of modules Fixed Assets (SIGAATF) and Purchases (SIGACOM), which adjusts the value of an asset through the typing of credit or debit notes. To do so, enter the credit or debit notes, the data of the incoming document and invoice that originated the addition of the asset in Fixed Assets. Value adjustment by credit note. The credit notes (value reduction) execute the posting of the asset, reducing the original value of the asset to make the adjustment. The value of the credit note is apportioned in accordance with the quantity of assets generated by the incoming document, posting only for types 01 and 10 registered in the asset file. To post type 10, parameter MV_ATFNFIN must be set to True (.T.). Postings remain registered in the transaction table (SN4), with reason 14 – Credit Note. Adjust the value by debit note. Debit Notes (value increase) incorporate a new item to the original asset. For each asset the original incoming document generates, a new item is created with the same characteristics as the original asset, though with debit note value apportioned among the items incorporated. The incorporated item can be depreciated independently from the original item, being independent during the depreciation period or having its depreciation dependent on the original asset to finish depreciating at the same time; however, in this case a new depreciation rate is automatically calculated for the item incorporated. When deleting credit or debit notes that performed value adjustments to an asset from Fixed Assets, they are undone.

ID of Ticket

TDOGCZ

Products

• Microsiga 11

Modules

• SIGAATF

Portals

• none

Countries

• Argentina

Operating System

• All

Database

• All

Name + Source

ATFA010 - Fixed Assets, ATFA030 – Asset Posting, ATFA035 – Asset Posting, ATFA240 – Purchases Classification, MATA101N – Incoming Invoice, MATA466N – Debit/Credit Note

Parameters Involved

MV_ATFNCRD, MV_ATFNFIN, MV_ATFVDPR, MV_ATFDCBA

Compatibility Tool Adjustments

Yes

Referential Integrity

No

Patch Application

No

Compatibility Tool 1

- UPDATF

Implementation Procedures

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

Before running the compatibility tool UPDATF, you must:

a) Backup the database of the product to be executed by compatibility program (“\PROTHEUS11_DATA\DATA” directory) and SXs data dictionaries (“\PROTHEUS11_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*.

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

To correctly update the data dictionaries, make sure the date on the compatibility program is equal to or after 3/29/2012.

2. Click OK to continue.

3. The first step of the execution is file preparation. An explanatory message is displayed on screen.

4. 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.

5. Click Save to keep the log displayed.

6. Click OK to close processing.

Adjustments Description

1. Creation in file SX3 – Fields:

• • Table SN1 – Fixed Assets:

• • Table SD2 – Outgoing Document Items:

The size of the fields that have groups may vary according to the environment in use.

2. Creation of Indexes in file SIX – Indexes:

3. Creation in file SX6 – Parameters:

Configuration Procedures

1. In the Configurator (SIGACFG), access Environments/Registers/Parameters (CFGX017). Create/set the following parameter(s):

Utilization Procedures

Addition of Fixed Asset through Incoming Invoice

1. On Purchases (SIGACOM), go to Updates/Transactions/Incoming Invoice (MATA101N).

The system displays the parameters window.

2. Enter data in accordance with field help instructions.

The system displays the registered incoming invoices window.

3. Click Add.

4. Enter data in accordance with field help instructions and fill in the following fields:

• • Product (D1_COD): product identification code.

The product must be of type fixed asset – Tipo (B1_TIPO) = AI.

• • Inflow Type (D1_TES): invoice inflow type.

Configure the inflow type to update the fixed asset when adding the incoming invoice – Act. Inmov. (F4_ATUATF) = S.

5. Place the cursor on the incoming invoice item to use the fixed asset.

6. Enter data in accordance with field help instructions.

7. Check and Confirm the data.

Purchase Classification

1. In Fixed Assets (SIGAATF) access Updates/Files/Purchase Classif. (ATFA240).

The system displays the fixed assets purchase classification window.

1. Select the Fixed Asset desired.
2. Click Classify.

The system displays the fixed assets classification window.

1. Enter data in accordance with field help instructions.
2. Check and Confirm the data.

Value Adjustment by Debit Note

1. On Purchases (SIGACOM), go to Updates/Transactions/Credit Note/Debit Note (MATA466N).

The system displays the parameters window.

2. Enter data in accordance with field help instructions.

The system displays the parameters window.

3. Enter data in accordance with field help instructions.

The system displays the registered debit notes window.

4. Click Add.

5. Enter data in accordance with field help instructions and fill in the following fields:

• • Product (D1_COD): product identification code.

 The product must be of type fixed asset – Type (B1_TIPO) = AI.

• • Inflow Type (D1_TES): invoice inflow type.

Configure the outflow type to update the fixed asset when adding the debit note – Act. Inmov. (F4_ATUATF) = S.

• • Original Doc. (D1_NFORI): number of original document. Enter the number of the incoming invoice that originated the asset.
  • Orig. Series (D1_SERIORI): series of original document. Enter the series number of the incoming invoice that originated the asset.
  • Ori Doc Item (D1_ITEMORI): item of original document. Enter the item number of the incoming invoice that originated the asset.

6. Check and Confirm the data.

Value Adjustment by Credit Note

1. On Purchases (SIGACOM), go to Updates/Transactions/Credit Note/Debit Note (MATA466N).

The system displays the parameters window.

2. Enter data in accordance with field help instructions. The system displays the parameters window.

3. Enter data in accordance with field help instructions. The system displays the registered credit notes window.

4. Click Add.

5. Enter data in accordance with field help instructions and fill in the following fields:

• • Product (D2_COD): product identification code.

The product must be of type fixed asset – Type (B1_TIPO) = AI.

• • Outflow Type (D2_TES): invoice outflow type.

Configure the outflow type to update the fixed asset when adding the credit note – Act. Inmov. (F4_ATUATF) = S.

6. Select the credit note item.

7. Click Related Features and in Orig Doc.

The system displays the origin documents window for the entered supplier and product.

8. Select and Confirm the origin document.

9. Check and Confirm the data.

Technical Data