Páginas filhas
  • Report of Position Valued on the Date – 111972

Versões comparadas

Chave

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

Report of Position Valued on the Date – 111972

Technical Bulletin: Report of Position Valued on the Date
Occurrence
Improvement
Summary
An improvement was implemented with the creation of the Position Valued on the Date report (ATFR072) that allows the printing of the valued position of the assets on a specific date based on the transactions and not on the basis of the accounting balance of the asset. The purpose of the report is to demonstrate the values of the assets on the date entered by the user according to the transactions and their impacts on the balances of the accounts that make up the asset. This report is extremely necessary in audit processes because it allows the issuance of the position of the company's fixed asset based on the closure of the last year.
ID of Ticket
SCZMUL
Products
Microsiga 11
Modules

...

Name + Source
Position Valued on the Date (ATFR072)
FNC Number
00000025565/2010
Compatibility Tool Adjustments
No
Referential Integrity
No
Patch Application
Implementation Procedures
The system is updated after applying the update package (patch) of this FNC.
Adjustments Description
Questions will be created the first time the report is accessed after the Patch is applied.
1. Creation of Questions in file SX1 – Questions:

Question

Date of balance

Name

AFR07201

Group

AFR072

Order

01

Type

D

Size

8

...

Question

Type

Name

AFR07202

Group

AFR072

Order

02

Type

N

Size

1

 

Question

Select Currency

Name

AFR07203

Group

AFR072

Order

03

Type

N

Size

1

...

Question

From Acquisition Date

Name

AFR07204

Group

AFR072

Order

04

Type

D

Size

8

 

Question

To Acquisition Date

Name

AFR07205

Group

AFR072

Order

05

Type

D

Size

8

...

Question

From Base Code

Name

AFR07206

Group

AFR072

Order

06

Type

C

Size

10

...

Question

From Item

Name

AFR07207

Group

AFR072

Order

07

Type

C

Size

4

 

Question

To Base Code

Name

AFR07208

Group

AFR072

Order

08

Type

C

Size

10

...

Question

To Item

Name

AFR07209

Group

AFR072

Order

09

Type

C

Size

4

 

Question

From Group

Name

AFR07210

Group

AFR072

Order

10

Type

C

Size

4

...

Question

To Group

Name

AFR07211

Group

AFR072

Order

11

Type

C

Size

4

...

Question

From Account

Name

AFR07212

Group

AFR072

Order

12

Type

C

Size

20

 

Question

To Account

Name

AFR07213

Group

AFR072

Order

13

Type

C

Size

20

 
 

Question

From Cost Center

Name

AFR07214

Group

AFR072

Order

14

Type

C

Size

9

...

Question

To Cost Center

Name

AFR07215

Group

AFR072

Order

15

Type

C

Size

9

 

Question

From Accounting Item

Name

AFR07216

Group

AFR072

Order

16

Type

C

Size

9

 

Question

To Accounting Item

Name

AFR07217

Group

AFR072

Order

17

Type

C

Size

9

 

Question

From Value Class

Name

AFR07218

Group

AFR072

Order

18

Type

C

Size

9

 

Question

To Value Class

Name

AFR07219

Group

AFR072

Order

19

Type

C

Size

9

...

Question

Select Branches

Name

AFR07220

Group

AFR072

Order

20

Type

N

Size

1

 

Question

Initial Sheet

Name

AFR07221

Group

AFR072

Order

21

Type

N

Size

4

...

Question

Final Sheet

Name

AFR07222

Group

AFR072

Order

22

Type

N

Size

4

...

Question

Restart Page No.

Name

AFR07223

Group

AFR072

Order

23

Type

N

Size

4

 

Question

Display information?

Name

AFR07224

Group

AFR072

Order

24

Type

N

Size

1

Procedures for Configuration
1. On the Configuration Tool (SIGACFG), access Environments/Files/Parameters (CFGX017). Enter the new menu option of Fixed Assets by following these instructions:

Menu

Fixed Assets

Sub-menu

Reports/Transactions

Routine Name

Position Val. Date

Program

ATFR072

Module

Fixed Asset

Type

Protheus Function

Tables

SN1, SN3, CTT, CTH, CTD, CT1,SN4

Usage Procedures

1. Go to the Fixed Asset and select Reports /Transactions/Position Valued on the Date (ATFR072).

A screen is displayed with the routine's parameters.


2. Enter the parameters according to the field help, observing:

Type: Indicates the report format, which can be:

...

    • Detailed: displays the information of the balances of the assets and the types of assets and their information in detail.

...

    • Synthetic by account: omits the information of the assets, differentiating the information of the accounts in tax, managerial, and encouraged balances.

...

    • Synthetic by good: omits the information of the types of balance of the assets, differentiating the information of the accounts in tax, managerial, and encouraged balances.


Display information: the format of the display of information, which can be:

...

    • Tax: demonstrates the tax information of the asset in detail. Taxes and contributions can be viewed in detail. Total of assets of the types (01, 02, 03, 04, 05, 06, 07, 11, 13).

...

    • Managerial: demonstrates the managerial information of the assets, merging the information of the accounts so that all values can be visualized. Total assets of the types (10, 12, 17, 4X, 5x)

...

    • Encouraged: demonstrates the information on the encouraged depreciation of the assets, bringing together the information of the accounts so that all values can be viewed. Total Assets of the types (08 and 09)

...

    • All: demonstrates the asset information with detailed and total values.


3. Click OK.
Image Removed        Note

When you enter Yes in the Select Branches parameter, choose the branches that will compose the report.

When you enter Yes in the Select Currencies parameter, choose the currencies that will compose the report.


4. Select the printing format and click OK.

The data of the assets in the position valued on the date will be printed or displayed onscreen.

The report will display blocks showing the details of the assets according to the information in the parameters.

The first block displays the values on the selected date of the asset, its characteristics, and its current status.

Example:

Column 1 – Branch: the branch of the asset.

Column 2 – Base Code: the registered code of the asset.

Column 3 – Item Code: the item of the asset registered.

Column 4 – Asset Type: the type of the asset.

Column 5 – Asset Type Descr.: the description of the asset type.

Column 6 – Classification: the classification of the asset.

Column 7 – Summar. Desc.: the summarized description of the asset.

Column 8 – Acquisition Dt.: Date of acquisition of the asset.

Column 9 – Posting Date: the posting date of the asset.

Column 10 – Quantity: the quantity of items of the asset.

Column 11 – Plaq. No. The number of the asset plaque.

Column 12 – Account: the account of the chart of accounts of the asset.

Column 13 – Original Value the original value of the asset.

Column 14 – Exp. Val.: Expansion of the asset

Column 15 – Updated Value: the updated value of the asset.

Column 16 – Accrued Depr.: the accrued depreciation of the asset.

Column 17 – Residual Value: The residual value of the asset.

Column 18 – Accr. Dep. Corr.: Correction of the depreciation of the asset.

Column 19 – Accr. Corr. M1: the accrued correction of the asset.

The second block displays the final values per branch, and the third, the general values of the assets.

...

Examples:
 
a) Accelerated depreciation:

Asset Form

 

 

Type

Original Value

Accrued Depreciation

01

1000.00

100.00

07

1000.00

50.00

Report: In this case, the original value of the asset will be demonstrated as 1000.00, and the accrued depreciation as 150.00.
 

        • Original Value: 01 -> 1000.00
        • Accrued Depr.: 01+07 --> 150.00 (100.00 + 50.00)
  •  


b)  Positive encouraged depreciation:

Asset Form

 

 

Type

Original Value

Accrued Depreciation

01

1000.00

100.00

08

1000.00

75.00

Report: In this case, the original value of the asset will be demonstrated as 1000.00, and the accrued depreciation as 175.00.

        • Original Value: 01 -> 1000.00
        • Accrued Depr.: 01+08 --> 175.00 (100.00 + 75.00)

 
c) Reverse (negative) encouraged depreciation:

Asset Form

 

 

Type

Original Value

Accrued Depreciation

01

1000.00

350.00

08

1000.00

250.00

09

1000.00

50.00

Report: In this case, the original value of the asset will be demonstrated as 1000.00, and the accrued depreciation as 550.00.

        • Original Value: 01 -> 1000.00
        • Accrued Depr.: 01+08-09 --> 550.00 (350.00 + 250.00 – 50.00)

Technical Data

Tables

SN1 – Fixed Assets; SN3 – Balances and Values; SN4 – Fixed Asset Transactions