Table of Contents

 


1. Common information


1.1. The Report Designer is built in program of Store House 4.

1.2. With its help it is possible to edit existing forms of reports or create new reports (documents and layouts).

1.3. The Report Designer represents the popular application module «Fast Report» widely used for construction of various complexity of print forms of reports.  

1.4. To start Report Designer in SH4, it is necessary in SHSetup.exe select parameter «resolve the Report Designer». After that, Report Designer becomes accessible in SH.exe.

1.5. Accordingly, it is necessary to know how to work, or something about how forms in this program are edited. The additional information on the given product («Fast Report») can be downloaded from the web site of its manufacturer http://www.fast-report.com .  

1.6. The information in the given manual is not full, but will be completely ready soon. It was published in this edition only because of the urgent request of our foreign colleagues. So, some errors are possible


2. How to start Report Designer


 

1. It is started SH4.
2. We open the list of documents or the necessary report. Thus there is accessible button - “Preview”. Having pressed its revealing list, it is possible to select the necessary printed form from the list accessible to the given document or report.
3. The Same forms will be editable if we shall start \File\Report designer. Here it is possible to create absolutely new report, which then can be saved in this group of printed forms.
4. Having started Report Designer it is necessary or to create the new form, or to open existing. By default, all forms of templates of printing placed in a working folder of SHouse 4 client - C: \UCS \SH4 \RPT \*.frf. 
 


3. For construction of reports in SH4


3.1. Printing of attributes in reports

3.1.1. Use the folowing functions:

function description details
OPV (OA, A, 0) Own accessories (are certain for any report) where A - attribute
OPV (CA, A, RID) Additional attributes of correspondents where A - attribute, the RID-identifier of the correspondent
OPV (GA, A, RID) Additional attributes of goods where A - attribute, the RID-identifier of the goods
OPV (CHA, A, RID) Additional attributes of sets headers where A - attribute, the RID-identifier of sets header
OPV (DSA, A; S, RID) Attributes of specifications of documents (numerical) where A - attribute, S - type of the accounting (the 0 - account, 1 - special account), the RID-identifier of the specification of a document

3.1.2. Examples:

3.1.2.1. for document attribute with number 100 for both accounts you can get with:

[IF (SysFlag=0, [OPV (DSA, 100; 0, [Specs. "Specs.105.1.1"])], [OPV (DSA, 100; 1, [Specs. "Specs.105.1.1"])])]

3.1.2.2. for correspondent attribute usage function will be like this:

[OPV(CA,$INN,[Header."Header.102.1.2"])]

3.1.2.2. where: $INN - variable name (attribute); [Header."Header.102.1.2"] - correspondent RID .

3.2. Values of DocRec :: Type field - type of a document (see also sh_tags.h)

0 – receiving report
4 – issue slip
5 – product subtraction
8 – collaton statement
10 – act of remaking
11 – internal transference
12 – complectation
13 – decomplectation

Bit mask of document options DocRec:: Options (a set of the values incorporated on OR; see also sh_tags.h)

1 - the selector of the accounting type of a document (special accounting if bats 0 it is installed, differently - the normal accounting)
2 - a flag of activity (the document is active if bats 1 is installed)
4 - a tag of locking of a waybill (the waybill is locked by the user, created a documentl if bats - 2 is installed
16 - a tag of link of a document with other documents (if bats 4 it is installed then document is generated automatically - modification of the list is inadmissible goods, dates, correspondents, currency and course of a waybill, a flag usages of mutual substitutions)
32 - a flag of usage of mutual substitutions - only complete sets (if bats 5 it is installed, that in a complete set the flag "is installed to use mutual substitutions")

Bit mask of options of record of document DocSpecRec:: Options (see also sh_tags.h)

2 - record concerns to the active document (it can be invalid at editing a waybill)
4 - to use the rate for calculation of the tax 1 (VAT) (RR, IS. If value of the field – “Null” - the rate is used)
8 - to use the rate for calculation of the tax 2 (sales tax rates) (RR, IS. If value of the field – “null” - the rate is used)
16 - automatically to calculate the price of excesses (for inventory. If value “Null” - field the price settles up automatically); - to write off under the cost price (for issue slip)
32 - on the given record excesses/shortages (only inventarisation; it can be invalid at editing a document)
64 - it is used additional quantity for inventory (only inventarisation; it can be invalid at editing a document)

Values of PDocRec :: Type field - type of the payment document (see also sh_tags.h)

0 – cash warrant
1 – account cash warrant
2 – payment commission
3 – account payment commission
4 – payment operation
5 – account payment operation

Bit mask of options of payment document PDocRec:: Options (a set of the values incorporated on OR; see also sh_tags.h)

1 - document concerns to special accounting
2 – active document
4 - document is locked by the creator of the document
8 - automatically to calculate the sum of the payment document on the basis of the linked waybill
16 - a tag of link of the payment document with other documents (if bats 4 it is installed the payment document is generated automatically - modification of the list of the sums, currencies, course of a waybill is inadmissible)

Types of classifications of reports gsfg... (see also sh_tags.h)

1 - on a tree of the goods
2 - on storages
3 - on goods categories
4 - on accounting categories
5 - under the bill-debit
6 - under the bill-credit
 

Flags of reports drpt... (see also sh_tags.h)

0x1 - a tag of the accounting
0x2 - to show active documents, specifications
0x4 - to show inactive documents, specifications
0x8 - to calculate the sums
0x10 - to unite correspondents on AND (the list documents)
0x10 - to group on warehouses (the commodity report)
0x10 - to group on correspondents (the analysis of correspondents)
0x20 - to calculate the rests
0x40 - to show from what arrivals/on what expenditures it is subtracted
0x80 - to include the subtree of goods group
0x100 - only not empty queues Fifo
0x8 - to calculate numbers for created documents
0x10 - to block the created documents
0x20 - to use the filter by quantity
0x10 - in the book of sales to use at filtering date of a waybill

The filter of the sum on specifications of bookkeeping operations of waybills dsf... (see also sh_tags.h)

0 - purchasing without taxes (arrival)
1 - the purchasing VAT (arrival)
2 - purchasing НСП (arrival)
3 - purchasing with taxes (arrival)
4 - purchasing without taxes (expenditure)
5 - the purchasing VAT (expenditure)
6 - purchasing НСП (expenditure)
7 - purchasing with taxes (expenditure)
8 - selling without taxes
9 - the selling VAT
10 - selling moneys НСП
11 - selling with taxes
12 - extra charge without taxes
13 - extra charge with taxes

Parameters which are certain in any report

"RptDate" - To print date of printing of the report (numerical significance): 0 - to not print, 1 - to print
"User" - the User name of the DB, connected to a server
"DbAlias" - the Name of a server
"FCaption" - Header of the form for which the report is called
"FVState" the State of the form for which the report (numerical significance) is called: 1 - it is not updated, 2 - it is updated, 4 - new (not saved), 16 - only for reading, 32 - the object displayed by the form, is remove.
"SysFlag" - Type of the account of the form (numerical significance): 0 - the account, 1 – special accounting, “-1” - does not support sharing under accounts.
"UDepart" - a storage certain for the user
"SumOpts" - the Bit mask of options of mapping of the sums for the account defined by printed form (numerical significance):

0x1 - to show purchase sum without taxes
0x2 - to show the purchasing VAT
0x4 - to show purchasing НСП
0x8 - to show purchase sum with taxes
0x10 - to calculate purchase price on the sum with taxes
0x100 - to show selling sum without taxes
0x200 - to show the selling VAT
0x400 - to show selling НСП
0x800 - to show selling sum with taxes
0x1000 - to calculate selling price on the sum with taxes
"BaseCurr" - the Code of a base currency
"OrgName" - the Name of the organization
"EntName" - the Name of firm

Classes of additional parameters

"OA" - Own essential elements (are certain for any report)
"CA" - Additional attributes of correspondents (are certain in the form of a waybill, the form of the account/invoice)
"GA" - Additional attributes of correspondents (are certain in the form of a waybill, the form of the account/invoice)

Additional parameters

"$corr_type" - type of the correspondent (only for a class "CA"): "0" - a storage, "1" - juridical person, "2" - natural person, "3" – special corr.

List of currencies; Properties of currency

Report List of currencies (properties of currency)
100.1.0 - Key (Rid) currencies - internal key of currency. 
100.2.0 - Properties of currency. If bats 0 it is installed, currency base. If bats “1” - is installed, the currency can be used for calculation in reports.
100.3.0 - Currency code (for example - "RBL"). It is used for identification of currency.
100.4.0 - Bank currency code (example, - "002").
100.5.0 - Name of currency (example, - "Russian ruble")
 

Exchange rates 

Params             Filter

100.1.1- Key (Rid) currencies
100.3.1 - Currency code (example, "RBL"). It is used for identification of currency
0.5.0 - Date of course with
0.6.0 - Date of course on

Report             Courses

104.1.0 - Date of course
104.2.0 - Sum of a base currency
104.3.0 - Sum of currency for which the history of course is under construction

 

List of correspondents, a card of the correspondent

Groups List of groups of correspondents (only the list of correspondents)
 

101.1.0 - Key (Rid) groups
101.1.2 - Link to a parent group (on Rid)
101.1.3 - Name of group
 

Report List of correspondents, a card of the correspondent
 

101.1.1 - Link to a parent group (on Rid in groups)
101.3.1 - Name of group to which posesses the correspondent (only a card of the correspondent)
102.1.0 - Key (Rid) the correspondent
102.2.0 - Type of the correspondent: 0 - storage, 1 - juridical person, 2 - natural person, 3 – special correspondent
102.3.0 - code of the correspondent
102.4.0 - name of the correspondent
102.5.0 - Internal number of a storage

Attrs       Attributes of the correspondent (only a card of the correspondent)

111.1.0 - Numerical ID of the correspondent
111.5.0 - Name of attribute
0.1.0 - Significance of attribute

 

Balance sheet

Params             Filter

------
Corresponds Params of remains sheet (see above), EXCEPT TWO FIELDS:
0.1.0 Date from
0.2.0 Date till

Groups List of groups for grouping
------
Corresponds Groups of balance sheet (see above)
 

Report             Report

------
0.1.0 - Field of correspondence group (point on {0.1.0} from Groups)
. Key (Rid) of good 
210.3.9 Text part of good’s code
210.4.9 Numerical part of good’s code
210.2.9 Title of the good
206.1.9 Key (Rid) of measure unit
206.2.9 Title of measure unit 
0.2.N * Quantity
0.3.N * Sum w/t
0.4.N * VAT
0.5.N * ST
0.10.N * Sum i/t

* - N accepts following meanings:
  0 – incoming remains
  1 - receipts
  2 - expenses
  3 - r/p
  4 - excess
  5 - shortage
  6 – outgoing remains

 

Extended balance sheet
 

Analog of balance sheet, with the difference that N accepts following meanings:
  0 - incoming remains
  1 - receiving report
  2 - issue slip
  3 - return to supplier
  4 - product subtraction
  5 - collation statement – excess  
  6 - collation statement - shortage
  7 - act of remaking
  8 - internal transference
  9 - complectation 
  10 - decomplectation
  16 - outgoing remains
 

Remains sheet, quantitative sheet of remains, remains on measure units, remains on benefit
 

Params       Filter

------
0.1.0 Date
0.3.0 Options of drpt report...
209.1.5 Key (Rid) of trade group
209.3.5 Title of trade group 
208.1.8 Key (Rid) of good category 
208.2.8 Title of good category 
219.1.9 Key (Rid) of accounting category of goods
219.2.9 Title of accounting category of goods
102.1.6 Key (Rid) of stock
102.4.6 Title of stock 
101.1.7 Key (Rid) of stock group
101.3.7 Title of stock group 
1.1.0 After code of grouping type: 
  0 – do not group
  1 – acc. Tree of goods
  2 – acc. stocks
  3 – acc. Trade categories
  4 – acc. Accounting categories
1.2.0 Title of grouping type: 
0.6.0 * Comparison type of q-ty (<, >, etc.): bit 1 <, bit 2 ==, bit 3 >
0.7.0 * What should compare the q-ty: 0 – with zero, 1 – with min reserve, 2 – with max reserve
100.1.4 ** Key (Rid) of currency, where to built report
100.3.4 ** Currency code, where to built report
 

Groups List of groups for grouping

------
0.1.0 Group identifier (for stocks – stock identifier, for other objects - key (Rid))
0.2.0 Additional parameter (for stocks - Rid, for tree of goods -
  Rid of parent, for other objects is not specified)
0.3.0 Title of group
0.9.0 Modified title of group (during grouping by tree)
 

Report       Report

------
0.1.0 Correspondence field to group (indicate to {0.1.0} from Groups)
210.1.9 Key (Rid) of good
210.3.9 Text part of good’s code
210.4.9 Numeric part of good’s code
210.2.9 Name of good
206.1.9 Key (Rid) of measure unit
206.2.9 Name of measure unit
0.2.0 Quantity
0.3.0 ** Sum w/t
0.4.0 ** VAT
0.5.0 ** Sale tax
0.10.0 ** Price
0.11.0 ** Sum i/t
0.21.0 *** Min inventory
0.22.0 *** Max inventory
103.1.14 **** Key (Rid) of bill
103.10.14 **** Type of bill
103.4.14 **** Bill number – symbol part
103.5.14 **** Bill number – numeric part
103.14.14 **** Stamp of date of the bill
103.3.14 **** Date of bill 
102.1.15 **** Key (Rid) of supplier
102.4.15 **** Supplier name
102.1.16 **** Key (Rid) of receiver 
102.4.16 **** Receiver name
105.1.14 **** Remains on income

* - only remains sheet, quantitative remains sheet; comparison with quantity is fulfilled, when
  In the field {0.3.0} Params is fixed bit that corresponds the number 0x20;
** - only remains sheet, remains on benefits
*** - only remains sheet, quantitative remains sheet
**** - quantitative remains on benefits

 

Bill

Header Bill title

------
103.1.1 Key (Rid) of bill
103.10.1 Type of bill DocRec::Type
103.11.1 Bite option mask of the bill DocRec::Options
103.2.1 Younger word of stamp of date of the bill
103.3.1 Date of the bill
103.4.1 Lined part of bill’s number
103.5.1 Numeric part of bill’s number
103.14.1 Date stamp of bill
103.12.0 Rate to basic currency (section "Rate: such amount of RBL for such amount of USD", only r/r, i/s)
103.13.0 Rate to currency of bill (section "Rate: such amount of RBL for such amount of USD", only r/r, i/s)
103.15.0 Comments
102.1.2 Key (Rid) of correspondent-supplier
102.4.2 Name of correspondent-supplier
102.1.3 Key (Rid) of correspondent-receiver
102.4.3 Name of correspondent-receiver
102.1.4 Key (Rid) of respon. person "Released"
102.4.4 Name of respon. person "Released"
102.1.5 Key (Rid) of respon. person "Received"
102.4.5 Name of respon. person "Received"
100.1.6 Key (Rid) of document currency 
100.3.6 Code of document currency 
100.6.6 Name of whole part of currency
100.7.6 Name of fractional part of currency 
107.1.9 Key (Rid) of acc. operation 
107.1.9 Lined part of no. of acc. operation 
107.1.9 Numeric part of no. of acc. operation 
107.1.10 Key (Rid) of invoice (only r/r, i/s, r/g)
107.4.10 Lined part of invoice (only r/r, i/s, r/g)
107.5.10 Numerical part of invoice (only r/r, i/s, r/g)
0.1.7 history: date of creation 
0.2.7 history: date of creation in seconds
0.3.7 history: date of last change
0.4.7 history: date of last change in seconds
0.5.7 history: min date of active document
0.6.7 history: user that created bill 
 

Specs      List of goods

------
105.1.1 Key (Rid) of record
210.1.1 Key (Rid) of good 
210.3.1 Text part of good’s code 
210.4.1 Numeric part of good’s code
210.2.1 Name of good
206.1.1 Key (Rid) of measure unit
206.2.1 Name of measure unit 
105.3.0 Quantity of goods
105.15.1 Record options DocSpecRec::Options
105.14.0 Alternative date for calculation the rate of non-basic currency (only r/r)
212.2.0 Rate/sum of VAT (depends upon DocSpecRec::Options)
213.2.0 Rate/sum of sale tax (depends upon DocSpecRec::Options)
105.3.14 Quantity of remains
206.2.14 Name of measure unit of remains
0.201.0 Line No. in bill 
105.4.15 * Prime cost: Sum w/t
105.5.15 * Prime cost: VAT
105.6.15 * Prime cost: Sale tax
105.7.15 * Prime cost: Price
105.8.15 * Prime cost: Sum i/t
105.4.0 Sum w/t
105.5.0 VAT
105.6.0 Sale tax
105.7.0 Price
105.8.0 Sum i/t
105.1.2 Key (Rid) of benefit for writing-off
103.3.2 Date of bill for writing-off (only p/s, r/g)
103.4.2 Lined part of bill no. For writing-off (only p/s, r/g)
103.5.2 Numeric part of bill no. For writing-off (только p/s, r/g)
103.11.2 Bit mask of options of the bill DocRec::Options for writing-off (только p/s, r/g)
103.10.2 Type of bill DocRec::Type for writing-off (только p/s, r/g)
210.1.6 Key (Rid) of good # 2 (only a/r)
210.3.6 Text part of good’s code # 2 (only a/r)
210.4.6 Numeric part of good’s code # 2 (only a/r)
210.2.6 Name of good # 2 (only a/r)
206.1.6 Key (Rid) of measure unit # 2 (only a/r)
206.2.6 Name of measure unit # 2 (only a/r)
105.3.7 Quantity of goods # 2 (only a/r)
200.1.1 Key (Rid) of set (only k, d/k)
200.2.1 Name of set (only k, d/k)
206.1.4 Key (Rid) of add. Measure unit (only c/s)
206.2.4 Name of add. measure unit (only c/s)
105.3.5 Add. Quantity (only c/s)
105.3.16 Calculated add. Quantity in c/s. (only c/s; specified, if add. measure unit is
  specified – better to use instead of 105.3.5 during printing)
105.7.17 Calculated price (only c/s)
212.2.17 Calculated VAT (only c/s)
213.2.17 Calculated sale tax (only c/s)
 

Rpt2   Grps extended groups Detailed expense of complectation,

---------
0.9.0 Name of group  
105.1.1 Key (Rid) of record (for Rpt2 corresponds the field 105.1.1 in Specs – group identifier)
105.1.2 Reference on parent  
210.1.1 Key (Rid) of good
210.3.1 Text part of good’s code
210.4.1 Numerical part of good’s code
210.2.1 Name of good 
206.1.1 Key (Rid) of measure unit
206.2.1 Name of measure unit
105.3.0 Quantity of good in measure units of bill 

Rpt1, Rpt2 Expense of complectation, benefit of decomplectation (Rpt1);
----------Detailed expense of complectation, benefit of decomplectation (Rpt2) – only c, d/c **, ***

105.1.1 Key (Rid) of record (for Rpt2 corresponds the field 105.1.1 in Specs – group identifier)
210.1.1 Key (Rid) of good
210.3.1 Text part of good’s code
210.4.1 Numeric part of good’s code
210.2.1 Name of good
206.1.1 Key (Rid) of measure unit
206.2.1 Name of measure unit 
105.3.0 Quantity of good
105.4.0 Sum w/t
105.5.0 VAT
105.6.0 Sale tax
105.7.0 Price
105.8.0 Sum i/t
102.1.1 Key (Rid) of stock
102.4.1 Name of stock

Rpt1, Rpt2 Excess of shortage, Excess of shortage by measure units (only c/s) ***
----------
105.1.5 Key (Rid) of pricing factor 
210.1.5 Key (Rid) товара
210.3.5 Text part of good’s code
210.4.5 Numeric part of good’s code
210.2.5 Name of good
206.1.5 Key (Rid) of measure unit
206.2.5 Name of measure unit
105.3.0 Calculated quantity of good
105.4.0 Calculated sum w/t (only Rpt1)
105.5.0 Calculated VAT (only Rpt1)
105.6.0 Calculated sale tax (only Rpt1)
105.7.0 Calculated price (only Rpt1)
105.8.0 Calculated sum i/t (only Rpt1)
105.3.2 Actual quantity of goods
105.4.2 Actual sum w/t (only Rpt1)
105.5.2 Actual VAT (only Rpt1)
105.6.2 Actual sale tax (only Rpt1)
105.7.2 Actual price (only Rpt1)
105.8.2 Actual sum i/t (only Rpt1)
105.3.1 Quantity of excess/shortage
105.4.1 Sum w/t of excess/shortage (only Rpt1)
105.5.1 VAT of excess/shortage (only Rpt1)
105.6.1 Sale tax of excess/shortage (only Rpt1)
105.7.1 Price of excess/shortage (only Rpt1)
105.8.1 Sum i/t excess/shortage (only Rpt1)
102.1.5 Key (Rid) of stock
102.4.5 Name of stock

RptAccs Transactions on bills ****
-------
106.1.1 Key (Rid) of invoice-yield
106.3.1 Code of invoice-yield
106.1.2 Key (Rid) of invoice-credit 
106.3.2 Code of invoice-credit
0.1.4 Sum
219.2.3 Acc. category
108.4.0 Operation description 

RptPDocs List of payment documents, connected with bill (only r/r, i/s, r/g) *****
--------
112.1.9 Key (Rid) of payment documents 
112.3.9 Date of payment documents 
112.4.9 Lined part of no. of payment document
112.5.9 Numeric part of no. Of payment document
112.10.9 Type of payment document PDocRec::Type
112.11.9 Bit mask of options of payment documents PDocRec::Options
103.1.1 Key (Rid) of connected bill 
107.1.3 Key (Rid) of acc. operation
107.2.3 Name of acc. operation
0.1.0 Sum w/t in basic currency
0.2.0 VAT in basic currency
0.3.0 Sale tax in basic currency 
0.4.0 Sum i/t in basic currency 

* - add parameter "chkSums" to the model, then field of prime cost in the report will be specified; 
** - use Specs with key field 105.1.1 instead of group for Rpt2 м.
*** - if you want data for report Rpt1 to be loaded before printing, add parameter "chkRpt1" to the model; 
  - if you want data for report Rpt2 to be loaded before printing, add parameter "chkRpt2" to the model; 
**** - - if you want data for report RptAccs to be loaded before printing, add parameter"chkRptAccs" to the model; 
***** - - if you want data for report RptPDocs to be loaded before printing, add parameter "chkRptPDocs" to the model;