Páginas filhas
  • Value Adjustments in Assets from Fixed Assets -- 118292

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

...

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.

...

Compatibility Tool 1

- UPDATF


Implementation Procedures

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

...

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

 


 

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, thoughtfully observe the following procedure:

 

                    i.                        In Configurator (SIGACFG), check whether the company uses Referential Integrity by selecting option Integrity/Verification (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 Smart Client, enter U_UPDATF in field Initial Program.

...

6. Click OK to close processing.


Adjustments Description

1. Creation in file SX3 – Fields:

    • Table SN1 – Fixed Assets:

Field

N1_NFESPEC

Type

C – Character

Size

5

Decimal

0

Format

@!

Title

Business Type

Description

Kind of document

Used

No

Required

No

Browser

No

Field

N1_NFITEM

Type

C – Character

Size

4

Decimal

0

Format

@!

Title

Item

Description

Document item.

Used

No

Required

No

Browser

No

    • Table SD2 – Outgoing Document Items:

Field

D2_CBASEAF

Type

C – Character

Size

14

Decimal

0

Format

@!

Title

Fixed Asset

Description

Fixed Asset Number

Used

No

Required

No

Browser

No


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

...

2. Creation of Indexes in file SIX – Indexes:

Index

SN1

Order

8

Key

N1_FILIAL + N1_FORNEC + N1_LOJA + N1_NFESPEC + N1_NFISCAL + N1_NSERIE + N1_NFITEM

Description

Code Suppl. + Suppl. Store + Kind + Invoice + Inv. Series + Item

Display Search

Yes


3. Creation in file SX6 – Parameters:

Variable Name

MV_ATFNCRD

Type

L - Logical

Description

Determine whether to use debit and credit notes to adjust asset values of Fixed Assets.

Default Value

.T.

Var. Name

MV_ATFNFIN

Type

L - Logical

Description

Determine whether the integration with credit or debit notes is done only for assets type 01 (.F.) or also for type 10 (.T.)

Default Value

.T.

Var. Name

MV_ATFVDPR

Type

L - Logical

Description

Determine whether the asset created by incorporation is independent (.T.) or dependent on the main asset. (.F.)

Default Value

.F.


Configuration Procedures for Configuration

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

Items/Folders

Description

Information

Name

MV_ATFDCBA

Type

 C

Description

Description

Determine how the asset is dismembered.

"0" - Dismember the item 

"1" - Dismember the base code of the asset.           


Utilization Procedures

Addition of Fixed Asset through Incoming Invoice

...

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

Tables

SN1 – Fixed Assets.

SN3 – Balances and Values.

SN4 – Fixed Assets Transactions.

SF1 – Incoming Invoice Header.

SD1 – Incoming Invoice Items.

SF2 – Outgoing Invoice Header.

SD2 – Outgoing Invoice Items.

...