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

• SIGAATF

Portals

• none

Countries

• All

Operating System
All
Database

• TopConnect

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:

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:

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

General notes
 

1. The types of assets representing accelerated depreciation and encouraged depreciation controls do not alter the value of the asset. For these types, the information from the Original Value field is used only for the calculation basis of the depreciation value to be generated by the system.

Examples:
 
a) Accelerated depreciation:

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:

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:

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