Example for Leased Land
 |
Example:
Example for land Leased from
|
1. Step:
After we set the settings in Land lease ( Land Lease Settings) we can start entering the parcels.
We can import Cadastral parcel in tu the database or we put them manually. In this example we will import cadastral parcel in to the database.
On mask for Cadastral parcel we click 
and choose Import parcels - full data from Excel
The program open pap-up windows and we click on button Export excel template file 
. The program create empty excel file
 |
This excel is for now adapt for Romanian localization. But we will adapt for each localization. |
Than we have to enter data in this excel.
Here I have divided excel in to three print screens, that you can see all data.
Explanation of the columns:
| acTarla (RO loc.) |
|
This is the number for parcel, this is specific for RO localization. The cadastral parcel number is generated form ac Tarla and acParcel. In field Cadastral parcel No. we get data for example T51P27
|
|
acParcel (RO loc.)
acCloc.)adparcel ( other
|
|
Number of the parcel |
|
acParcel Name ( RO loc.)
acCadParcelName ( other loc.)
|
|
The name of the Parcel. This data is not obligatory |
|
acCountie ( RO loc.)
acCadMuniCode (other loc.)
|
|
For RO localization we put here data about Countie, for other localization we have data about Cadastral municipality code. This data si not obligatory. |
|
ac Village (RO loc.)
|
|
We put the name of the village. This data is not obligatory. |
| acPropertyType |
|
For now this data do not have any meaning. It data about property type, for us is important data about acSetOfUse |
| anArea |
|
This is data about the surface of cadastral parcel which we are leased. |
| acLessee |
|
Name of a person who has the cadastral parcel in leased. |
| acCode |
|
This is data about VAT no. of the Subject. This data is not obligatory. We see this data in General data for Subject
|
| acPhone |
|
Telephone number of the Lessee. This data is not obligatory. We see this data in General data for Subject ( look the picture by explanation of acCode)
|
| acAddress |
|
Address of the Lessee. We see this data in General data for Subject ( look the picture by explanation of acCode) |
| acLessor Quality |
|
For now this data do not have any meaning. |
| acCompany |
|
This is data about company, who gave us land in lease. This information is imported to module Subject. |
| acDepartment |
|
This information is imported to module Subject.This information is not obligatory |
| acContractNo |
|
This is the number of the contract. This information we see in module Leased From and Leased To |
| adDateFrom /acDateTo |
|
This is the expiration date of the contract. We also see this data on mask for Leased From and Leased To.
|
| anReacuringPayment |
|
This is date how many time we create the invoice Example: if you have in acPeacuring Type M ( month ) and in this field it means that we will create invoice once a month. If we put 2 then we will create invoice every second month. |
| acReacurringType |
|
We have this type of recurring:
L - year (we do periodicals invoices once a year)
M - month ( we do monthly periodical invoices)
K - quarter ( we do quarterly periodical invoices)
T - week ( we do weekly periodical invoices)
D - day ( we do daily periodical invoices)
|
| acPaymentType |
|
Here we have three types of payments:
P- payment (we pay rent with cash)
R - payment and barter ( we pay the rent with cash and goods)
B- barter ( we pay rent only with goods)
|
| acGoods |
|
If we pay rent with barter, than we have to enter also data about goods. This item must be already in database. The data about goods is seen in Leased From and Leased To.
In the table for barter in the lower right corner of the screen.
|
| anGoodQuantity |
|
Here we enter the quantity of goods that we will pay the rent.
The data about goods is seen in Leased From and Leased To.
In the table for barter in the lower right corner of the screen.
|
| anGoodsPrice |
|
Here we enter the price of goods that we will pay the rent.
The data about goods is seen in Leased From and Leased To.
In the table for barter in the lower right corner of the screen.
|
| acGoodsUM |
|
This is data about unit of measures. Usually we have this data already on the item in database |
| anPrice |
|
This is the data of the price if we pay the rent with money. We see this data in module Leased From and Leased To.
In tab Payments, column Price/ha
|
| acNote |
|
If we have any note for the contract or parcel we can enter this data in to this field. We see this note in module Cadastral Parcel in tab Parcel Owner |
| acField |
|
If we have data about Field, we can enter in this column. If Field does not exist, it will create automatically when we will import data from excel to database. This data we see in module Cadastral Parcel tab Field on parcel
|
| acBlock |
|
If we need this data then we can enter the data. Block is a number that combines fields that are side by side. This is the general data in module Cadastral Parcel. |
| acStatus |
|
This is the status of the field. Is this field in leased( L), Owned (O), Rented (R). Sold (S), Common use (C). This data is on mask for Cadastral Parcel.and Field. |
| acSetOfUse |
|
This is data about land use . This data is on mask for Field. |
When we have enter all data in to excel, we import this excel back to the database. On mask for Cadastral parcel we click and choose Import parcels - full data from Excel.
When the pap-up opens, we click on button Import from excel 
. From our computer we choose the excel that we have prepare.
The program import parcels.
Now we have to click on button Save 
. With this operation the parcel will be saved in to our database. If everything is correct, the column Save will be checked.
2. Step:
Now that we import parcel in to database we can start creating the invoices for Periodical payment.
First we will look if the data for parcels are ok.
So we will look, if the general data and data on tab Field ( LPIS) on parcel and Parcel Owner are ok.
Like we see we have all data and also data about Field. This parcel is on Filed 32230.
The same time when we import the parcel, program also create all data for periodical payments. The periodic is created from start of the contract till the end. In our case from 18.11.2011 till 7.9.2027
In this case we see that we have to pay rent with barter. We see in table Barter how much corn by hectare in kilos we have to pay for rent and the price.
3. Step
Now we have to create the invoice. We go on Land Lease or just click kon button Billing 
on mask Leased from.
On mask Land Lease we enter data about Subject, if we click on button Billing the data are already filed up. We chose Fill in Last Document Data, Billing type and payment and we click Button Refresh
No we click on button create 
and invoice is created.
And invoices are creating automatically.
