Media reports/en - Revision history

TR at 08:52, 3 November 2020

2020-11-03T08:52:20Z

TR at 08:51, 3 November 2020

2020-11-03T08:51:32Z

TR at 08:50, 3 November 2020

2020-11-03T08:50:20Z

TR at 08:49, 3 November 2020

2020-11-03T08:49:05Z

TR at 08:48, 3 November 2020

2020-11-03T08:48:35Z

TR at 08:45, 3 November 2020

2020-11-03T08:45:54Z

FuzzyBot: Updating to match new version of source page

2020-10-27T16:38:48Z

Updating to match new version of source page

Show changes

FuzzyBot: Updating to match new version of source page

2017-08-01T16:00:06Z

Updating to match new version of source page

FuzzyBot: Updating to match new version of source page

2017-07-24T10:00:05Z

Updating to match new version of source page

FuzzyBot: Updating to match new version of source page

2017-06-12T18:31:03Z

Updating to match new version of source page

@@ Line 126: / Line 126: @@
 '''Date fields at printout'''
-Depending on what the report shows, tehse are only for MED reports. The date fields are:
+Depending on what the report shows, these are only for MED reports. The date fields are:
 {|class= mandeflist

@@ Line 109: / Line 109: @@
 In the {{flik|Selection}} tab you find all the fields and registers that shall be available when the report is printed. Here you can state a standard value (optional). The value can be changed at the time for printout.
-In both MED and MED&PRO reports you can make a selection on several surcharge codea or an interval of codes by separating them with +. In the same way you can make selections and intervals on fee-, purchase- and other codes and categories. Below an example of column 3 Invoiced Net for surcharge codes 301-304 and 701. Row 9 shows invoiced fee and codes 101-120
+In both MED and MED&PRO reports you can make a selection on several surcharge codes or an interval of codes by separating them with +. In the same way you can make selections and intervals on fee-, purchase- and other codes and categories. Below an example of column 3 Invoiced Net for surcharge codes 301-304 and 701. Row 9 shows invoiced fee and codes 101-120
 == Print report ==

@@ Line 62: / Line 62: @@
 '''MED reports:'''
 {|class= mandeflist
 !TYP
 |E for Ether and P for Print (media) A for Fees, I for Purchases and O for Other (project)
 |-
 !KAT
-|Cost category in the project accounting (fees, purchases or other). TYP=A, KAT=01selects all fees in category 01.
+|Cost category in the project accounting (fees, purchases or other). TYP=A, KAT=01 selects all fees in category 01.
 |-
 !BPER

@@ Line 54: / Line 54: @@
 The column Round-off shows how to round the amounts. You can use the check box Show to hide certain columns, if they e.g. are used only to calculate the value in another column.
-You can write report header in one or two rows in columns Header 1 and Header 2.
+You can write report header on one or two rows in columns Header 1 and Header 2.
 == Selections ==

@@ Line 50: / Line 50: @@
 {{ExpandImage|MED-REP-EN-Bild1.png}}
-You can specify the selected definitions in the Selection column. In the above example thereport fetches statistics for Invoiced net media related, invoiced net specifically for surcharge codes 301-304, discount,commissions, capital cost and insertion fees.
+You can specify the selected definitions in the Selection column. In the above example the report fetches statistics for Invoiced net media related, invoiced net specifically for surcharge codes 301-304, discount,commissions, capital cost and insertion fees.
 The column Round-off shows how to round the amounts. You can use the check box Show to hide certain columns, if they e.g. are used only to calculate the value in another column.

@@ Line 5: / Line 5: @@
 == General ==
-A media report consists of a column template and a report template that are connected to each other. In the column template, the different columns of the report is defined and the report template defines those selections that shall be set when printing the report.
+A media report consists of a column template and a report template that are connected to each other. In the column template, the different columns of the report are defined and the report template defines those selections that shall be set when printing the report.
 == Column template ==

← Older revision		Revision as of 16:00, 1 August 2017
Line 58:		Line 58:
	The different selections are:		The different selections are:

		+	'''MED reports:'''
−	TYP E for Ether and P for Print (media), A for Fee, I for Purchases and O for Other (projects) KAT Cost category in the project accounting (fee, purchase or other) TYP=A, KAT=01 selects all fee from category 01.BPER Accounting period (e.g. BPER=1401-1412 for year 2014 or BPER=1412 for Dec. 2014) IPER Insertion period (e.g. IPER=1401-1412 for year 2014 or IPER=1412 for Dec. 2014)MTYP Media typeRKOD Discount codeTKOD Surcharge codeTKOD=M All that has been invoiced by the mediaTKOD=I All that hasn't been invoiced by the mediaHK=J All that is on the main client of the plan (used in allocations)HK=N All that is on other clients than the main client of a plan
		+	{\|class= mandeflist
		+	!VAL=O
		+	\|shows order currency in ordered columns
		+	\|-
		+	!TYP=E, TYP=P
		+	\|is a selection of the field Print on the media type, will be fetched to the order at the time of registration
		+	\|-
		+	!KAT=XX
		+	\|is a selection of client categories
		+	\|-
		+	!BPER=17
		+	\|is a selection of accounting year 2017
		+	\|-
		+	!BPER=1701
		+	\|is a selection on accounting month 2017-01
		+	\|-
		+	!BPER=1701-1703
		+	\|is a selection of accounting months 2017-01 - 2017-03
		+	\|-
		+	!IPER
		+	\|as BPER but for insertion date
		+	\|-
		+	!MTYP=01
		+	\|is a selection of media type 01
		+	\|-
		+	!MTYP=01-09
		+	\|is a selection of media types 01-09
		+	\|-
		+	!OMTY=P
		+	\|is a selection of collective media type P
		+	\|-
		+	!OMTY=P-S
		+	\|is a selection of collective media types P to S
		+	\|-
		+	!TKOD=M
		+	\|is a selection of all media related surcharge codes
		+	\|-
		+	!TKOD=I
		+	\|is a selection of all not media related surcharge codes
		+	\|-
		+	!TKOD=100
		+	\|is a selection of surcharge code 100
		+	\|-
		+	!TKOD=100-199
		+	\|is a selection of surcharge code 100-199
		+	\|-
		+	!TKOD=100+110+120
		+	\|is a selection of surcharge codes 100, 110 and 120 (max 10 pcs)
		+	\|-
		+	!TKOD=100-199+300-399
		+	\|is a selection of 100-199 and 300-399 (max 10 pcs, it is also possible to mix separate surcharge codes and intervals)
		+	\|-
		+	!RKOD=SP
		+	\|is a selection of discount code SP
		+	\|-
		+	!RKOD=MA-MZ
		+	\|is a selection of discount codes MA-MZ
		+	\|-
		+	!HK=J
		+	\|is a selection of the main client's share
		+	\|-
		+	!HK=N
		+	\|is a selection of other clients than the main client
		+	\|-
		+	!AVST=1
		+	\|is a selection of reconciling code 1
		+	\|-
		+	!AVST=1-4
		+	\|is a selection of reconciling codes 1-4
		+	\|}
		+
		+	'''MED&PRO-reports:'''
		+	{\|class= mandeflist
		+	!TKOD, MTYP, OMTY, BPER, AVST
		+	\|as above
		+	\|-
		+	!GRP=10
		+	\|is a selection of group 10
		+	\|-
		+	!GRP=10-19
		+	\|is a selection of groups 10-19
		+	\|-
		+	!KOD and KAT
		+	\|are selections of codes and categories in PRO and function as TKOD (i.e up to 10 separate codes ore intervals)
		+	\|-
		+	!FTG=XXX
		+	\|is a selection of company code XXX
		+	\|}

	You can use several surcharge codes or an interval of surcharge codes in both media reports and media project reports. Separate them with +. Similarly, you can have several selections of fee-, purchase- and other codes/categories or intervals of them.		You can use several surcharge codes or an interval of surcharge codes in both media reports and media project reports. Separate them with +. Similarly, you can have several selections of fee-, purchase- and other codes/categories or intervals of them.

@@ Line 13: / Line 13: @@
 Then, start with the columns. Use the search list to see the list of possible definitions. The list is divided into headers to facilitate your search:
 {| class=mandeflist
 !Invoiced – client cost
@@ Line 42: / Line 41: @@
 |registered media invoices on the orders.
 |}
 You can also use the quick search field for finding definitions. The comment column describes the definition.  A (MED&amp;PRO) definition can be used in a combined media – and project accounting report.
@@ Line 62: / Line 60: @@
 TYP E for Ether and P for Print (media), A for Fee, I for Purchases and O for Other (projects) KAT Cost category in the project accounting (fee, purchase or other) TYP=A, KAT=01 selects all fee from category 01.BPER Accounting period (e.g. BPER=1401-1412 for year 2014 or BPER=1412 for Dec. 2014) IPER Insertion period (e.g. IPER=1401-1412 for year 2014 or IPER=1412 for Dec. 2014)MTYP Media typeRKOD Discount codeTKOD Surcharge codeTKOD=M All that has been invoiced by the mediaTKOD=I All that hasn&apos;t been invoiced by the mediaHK=J All that is on the main client of the plan (used in allocations)HK=N All that is on other clients than the main client of a plan
-You can use several surcharge codes or an interval of surcharge codes in both media reports and media project reports. Separate them with  +. Similarly, you can have several selections of fee-, purchase- and other codes/categories or intervals of them. In the picture below column 3 shows invoiced net for the surcharge codes: 500 to 504, 010 to 099, 800 and 331-352.
+You can use several surcharge codes or an interval of surcharge codes in both media reports and media project reports. Separate them with  +. Similarly, you can have several selections of fee-, purchase- and other codes/categories or intervals of them.
@@ Line 107: / Line 105: @@
 [[Category:MED-REP-EN]]