Páginas filhas
  • Exchange Difference Details -- 119146

Technical Bulletin: Exchange Difference Details

Occurrence

New Routine

Summary

We now offer the report Exchange Difference (ATFR161) to generate the record file of posting, depreciation and the exchange difference of assets acquired in foreign currencies, as required by SUNAT (http://www.sunat.gob.pe).

ID of Ticket

SDHUHG

Applicability

Exchange Difference Details

Products

  • Microsiga 11

Modules

    • SIGAATF

Countries

    • Peru

Translations

    • Spanish

Operating System

  • All

Database

    • All

Name + Source

Exchange Difference (ATFR161)

Compatibility Program Adjustments

Yes

Referential Integrity

Yes

Patch Application

Compatibility Program 1

- UPDATF

Implementation Procedures

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

Before running the U_UPDATF compatibility program, 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*.


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.

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

2. Click OK to continue.

3. After confirmation, a screen is displayed for selecting the company in which the data dictionary will be edited, or a window is displayed for selecting the compatibility program. Select the program U_UPDATF().

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

5. Click Process to start processing. The first execution step is file preparation.
An explanatory message is displayed onscreen.

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

7. Click Save to keep the log displayed.

8. Click Ok to close the process.

Adjustments Description

1. Creation of Questions in file SX1 – Questions Register:

Ask

MV_PAR01

Name

Fiscal Period

Group

ATR161

Order

01

Type

Numeric

Size

4

Ask

MV_PAR02

Name

Select Branches

Group

ATR161

Order

02

Type

Numeric

Size

1


2. Creation of Fields in file SX3 – Fields:

    • Table SN1 - Fixed Assets:

Field

N1_MARCA

Type

Character

Size

12

Decimal

0

Format

@!

Title

Brand

Description

Brand of Fixed Asset

Level

1

Used

Yes

Required

No

Browser

No

Help

Brand of Fixed Asset

Field

N1_MODELO

Type

Character

Size

12

Decimal

0

Format

@!

Title

Model

Description

Model of Fixed Asset

Level

1

Used

Yes

Required

No

Browser

No

Help

Model of Fixed Asset

Field

N1_MOEDAQU

Type

Numeric

Size

02

Decimal

0

Format

99

Title

Acquis. Currency

Description

Currency of Acquisition

Level

1

Used

Yes

Required

No

Browser

No

Val. System

AF010MOED()

Help

Currency with which the asset was acquired.

Field

N1_TXMOEDA

Type

Numeric

Size

11

Decimal

4

Format

@E 999,999.9999

Title

Currency Rate

Description

Acquisition Currency Rate

Level

1

Used

Yes

Required

No

Browser

No

Val. System

AF010MOED()

Help

Rate of currency at the time of acquisition.


  • Table SN3 - Balances and Values:

Field

N3_AUTDEPR

Type

Character

Size

12

Decimal

0

Format

@!

Title

Authoriz. Doc.

Description

Authorization Document

Level

1

Used

Yes

Required

No

Browser

No

Help

Number of authorization document for depreciation method change.

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

Procedures for Configuration

FOR MENUS

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


Menu

Fixed Assets

Sub-menu

Reports/Transactions

Routine Name

Exchange Diff.

Program

ATFR161

Module

SIGAATF

Type

Protheus Feature

Tables

SN0,SN1,SN3 and SN4

 

Procedures

1. In Fixed Assets (SIGAATF), access Report / Transactions / Exchange Difference (ATFR161).

The system displays the report configuration window.

2. Click Parameters and enter the fiscal period. If desired, filter the branches.

3. Check and Confirm the data.

Technical Data

Tables

SN0 – Fixed Assets Auxiliary Data

SN1 - Fixed Assets

SN3 – Balances and Values of Fixed Assets

SN4 – Fixed Assets Transactions

Related Features

ATFR161 - Exchange Difference

Operating Systems

Windows/Linux