Print of invoice

Previous Top Next

Formation of the invoice is made in the form of MS Excel spreadsheets on the basis of the prepared document template (List.xlt) included into installation of the Complex.

Customizing the templates of formed documents is made by means of program MS Excel.

The reason for use of beforehand created Excel template for formation of the final document consists in the following. With the help of MS Excel the document corresponding to established patterns or standards is created. To cells, into which results of performance of the program will be automatically placed, appropriate names are given.

The cell name is directly entered into the field «Name» of MS Excel control panel. The cell name is unique, there can not be two cells with the same name. In case of need of the value duplication into several cells, it is performed by means of formation of document MS Excel.

Calculation of the final sums also is made by means of MS Excel.

 

Description of the report template:

 

 

Keyword,

cell name

Displayed value

1

DATE

Date of document creation

2

NAME

Recipient name

3

ORDER

Document - the basis for delivery

4

MN1

Beginning the column of maps numbers

5

MF1

Beginning the column of maps nomenclatures

6

MD1

Beginning the column of change date of maps files

7

MS1

Beginning the sizes column of maps files

4

SN1

Beginning the column of the user's maps numbers

8

SF1

Beginning the column of the user's maps nomenclatures

9

SD1

Beginning the column of change date of user's maps files

10

SS1

Beginning the column of files sizes of user maps

11

RN1

Beginning the column of raster's maps numbers

12

RF1

Beginning the column of raster's maps nomenclatures

13

RD1

Beginning the column of change date of raster's maps files

14

RS1

Beginning the column of files sizes of raster maps

15

MTN

Beginning the column of numbers of matrix maps

16

MTF

Beginning the column of nomenclatures of matrix maps

17

MTD

Beginning the column of change date of matrix maps files

18

MTS

Beginning the column of files sizes of matrix maps

19

MAPCOUNT

Total of maps

20

SITCOUNT

Total of the user maps

21

RSWCOUNT

Total of raster maps

22

MTWCOUNT

Total of matrix maps

 

The document template should contain all keywords.

After editing the file, save it as a template.