Code for Asset Accounting for MOL.mdb

Affiliates: 0,1 $how to earn
Pay with:
i agree with "Terms for Customers"
Buy this item cheaper:
Sold: 12 last one 28.02.2019
Refunds: 0

Uploaded: 23.09.2014
Content: text 388 symbols

Product description

Code for Asset Accounting for MOL.mdb

Code for database "Asset Accounting for MOL" in MS Access

Download the report on the database screen forms for free

Title: Accounting for fixed assets MOL.mdb


Additional information

Ready database Access "Accounting of fixed assets for MOL"

1. Create tables:

Table 1. Group of fixed assets

Table structure: Group code, Group name, Annual depreciation rate (depreciation rate is set in% of the original cost)

Table 2. Subdivision

Table structure: Unit code, Unit name, name of materially responsible person (abbreviated as MOL)

Table 3. Property, plant and equipment

Table structure: Inventory number, Name, Group code, Initial value, Commissioning date, Unit code

Enter in Table 1 information about the five groups (machines, instruments, electrical equipment, copying machinery, computer equipment), in Table 2 - on three divisions.
Create the "Accounting Card" form to enter data into table 3. Use the combo boxes to enter the department code and group code. Enter 15 units of accounting.
Create a form (such as master / subordinate) "Information on fixed assets assigned to a financially responsible person". The main form should contain the name of the MOL, the code and the name of the unit and the total amount of depreciation from the beginning of operation. The subordinated form should contain in the table the list of fixed assets fixed for MOL and the amount of depreciation for each unit of account from the beginning of operation. Provide for the introduction of the MOL name on request. If the depreciation period has not expired (the expiration date of the depreciation exceeds the end date of the month), the amount of depreciation charges for the current date is calculated by the formula: A = S * N * M / (12 * 100), where S is the initial cost, N-annual rate depreciation in%, M - the number of months that have passed since the beginning of operation. Otherwise, the depreciation amount is S. The depreciation term is calculated by the formula:

Commissioning date + 365 * 100 / N

Create a form for transferring the accounting unit from one MOL to another. Materially responsible persons must be selected from the list box. The form should contain complete information about the transferred accounting unit.
Create a report "Summary statement of depreciation charges for all MOL" with an indication of the initial cost and the calculation of depreciation from the beginning of operation and the residual value for each denomination, group and all.


No feedback yet.
In order to counter copyright infringement and property rights, we ask you to immediately inform us at the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)