Difference between revisions of "Media Base registers/sv"
(Created page with "= Allmänt =") |
(Updating to match new version of source page) |
||
(15 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
__FORCETOC__ |
__FORCETOC__ |
||
+ | <div class="mw-translate-fuzzy"> |
||
− | = Allmänt = |
||
+ | == Allmänt == |
||
+ | </div> |
||
+ | Uppgifter på kund, medier, användare mm kan exporteras till Excel genom att klicka i rutanExport. |
||
− | All information about clients, media, users, etc., can be exported into Excel/Spreadsheet by clicking the box '''Export'''. Before printout you can select what parts of the information you want to export. The selections will be saved on your user settings. |
||
+ | Då får man upp en box med selekteringsmöjligheter för den information man önskar |
||
+ | få med. Detta val lagras på dig som användare. |
||
+ | Knappen Kopiera används för att kopiera uppgifter från ex annan kund vid ny-upplägg. |
||
− | The '''Copy''' function is used for copying information from e.g. an existing to a new client. |
||
+ | Genom att klicka på knappen Tillbaka kommer man åter till startsidan för Basregister. |
||
− | Click '''Back''' to return to the start page of Base registers. |
||
+ | På de flesta ställen finns valmöjlighet mellan Visa endast aktiva/endast egna som gör att man kan begränsa urvalet. |
||
− | In almost all lists there are possibilities to reduce the search results by ticking the boxes '''only active /only mine'''. |
||
− | = |
+ | = KUNDER = |
− | == |
+ | == Överkunder == |
+ | Används för att knyta samman flera kunder för att ta ut statistik. |
||
− | You can connect several clients to a collective client for statistics. |
||
− | + | <div class="mw-translate-fuzzy"> |
|
+ | {|class=mandeflist |
||
− | |Code |
||
+ | |Kod |
||
− | |Optional Collective client code. |
||
+ | |Valfri kod på Överkunden. |
||
|- |
|- |
||
+ | |Namn |
||
− | |Name |
||
+ | |Namnet på Överkunden. |
||
− | |Optional Collective client name. |
||
|- |
|- |
||
− | |VAT- |
+ | |VAT-nummer |
+ | |Kundens VAT-nr. Kan redovisas på faktura, plan. Finns som urval och summeringsnivå i rapporter. |
||
− | |This field can be printed on client invoice and in reports |
||
|- |
|- |
||
+ | |Organisationsnummer |
||
− | |Organisation no |
||
+ | |Kundens organisationsnummer. Kan redovisas på faktura, plan och i listor. |
||
− | |Can be printed out on client invoice |
||
|- |
|- |
||
+ | |Eget ID Valfri märkning. Kan skrivas ut i rapporter och i kundreskontran som egen kolumn. |
||
− | |Credit comment |
||
− | |Comment, printed out on credit check |
||
− | |- |
||
− | |Credit class |
||
− | |Credit classification of the Collective client. The classes are used in the Credit limit program. |
||
− | |- |
||
− | |Latest credit check |
||
− | |Date for latest credit check. Together with “days” (number of days) this function calculates the time for next credit check. |
||
− | |- |
||
− | |Days between |
||
− | |For calculation of next credit check |
||
− | |- |
||
− | |Insurance number |
||
− | |Printed out in media credit list |
||
− | |- |
||
− | |Credit limit |
||
− | |A credit limit can be set on collective client level, but not on a higher level. But if credit limit has been set on an individual client, it will be used. Credit limit is calculated each night. |
||
− | |- |
||
− | !Exceeded |
||
− | |If some of the clients connected to the collective client has exceeded the credit limit, it will be tagged with “exceeded”, and no new bookings are possible. You can un-tick the “exceeded” box to lift the blocking. |
||
− | |- |
||
− | |Days additional to |
||
| |
| |
||
+ | |||
+ | {| class=mandeflist |
||
+ | !''Kredit hantering'' |
||
+ | ''Se separat hur det fungerar med kunder / överkunder.'' |
||
+ | |} |
||
+ | |||
+ | {|class=mandeflist |
||
+ | |Kundansvarig |
||
+ | |Ansvarig för Överkunden. |
||
|- |
|- |
||
+ | |Kundkategori |
||
− | |cancellation date |
||
+ | |Ev. kundkategori som Överkunden tillhör. |
||
− | |''See separate description for credit handling and check'' |
||
|- |
|- |
||
+ | |Grupp Ev. grupp som Överkunden tillhör. |
||
− | !Notice days additional |
||
− | | |
||
|- |
|- |
||
+ | |Överkund Används för att koppla en överkund till en annan föratt på så sätt få en trädstruktur. Blir då Över-överkund. |
||
− | |To cancellation day |
||
− | |''See separate description for credit handling and check'' |
||
|- |
|- |
||
+ | |Rapporteringsnivå |
||
− | |Client manager |
||
+ | |Ett sätt att ange på vilken nivå i överkundstrukturen man vill rapportera på. På en del kunder på överkundsnivå och andra på kund-nivå. |
||
− | |Client manager for the collective client |
||
|- |
|- |
||
+ | |Spärrad |
||
− | |Client category |
||
+ | |Används för att avaktivera Överkunder som inte längre är aktiva. |
||
− | |Possible client category for the collective client. |
||
− | |- |
||
− | |Group |
||
− | |Possible group for the collective client. |
||
− | |- |
||
− | |Collective client |
||
− | |Connect collective clients to each other to get a tree structure. |
||
− | |- |
||
− | |Reporting level |
||
− | |A way of telling levels in the collective client structures for reporting |
||
− | |- |
||
− | |Blocked |
||
− | |Deactivation of collective clients. |
||
|} |
|} |
||
+ | </div> |
||
− | == |
+ | == Kunder == |
+ | Inne på Kunder kan man välja att se alla eller endast aktiva. |
||
− | Tick the box “Show Collective clients” if you want to see also collective clients in the client list. Click '''New''' to add a new client. You can copy information from a client with similar setup. |
||
+ | Vill man även se överkunder på samma sida klickar man i boxen Visa överkunder. Välj knappen ''Ny''för nyupplägg av kund. Därefter kan knappen Kopiera från användas för att hämta information från en annan kund som har ett liknande upplägg. |
||
{| class=mandeflist |
{| class=mandeflist |
||
Line 378: | Line 359: | ||
|Blocks new insertions from this agreement. |
|Blocks new insertions from this agreement. |
||
|- |
|- |
||
− | !Invoice whole plan at the |
+ | !Invoice whole plan at the first insertion |
− | | |
||
− | |- |
||
− | !first insertion |
||
|All approved insertions are invoiced at the first date of selected insertion period |
|All approved insertions are invoiced at the first date of selected insertion period |
||
|- |
|- |
||
− | !Invoice whole plan at the |
+ | !Invoice whole plan at the last insertion |
− | | |
||
− | |- |
||
− | !last insertion |
||
|All approved insertions are invoiced at the last date of selected insertion period |
|All approved insertions are invoiced at the last date of selected insertion period |
||
|- |
|- |
||
− | !Invoice whole order at |
+ | !Invoice whole order at the last insertion |
− | | |
||
− | |- |
||
− | !the last insertion |
||
|All insertions in the order are invoiced at the last date of selected insertion period. |
|All insertions in the order are invoiced at the last date of selected insertion period. |
||
|- |
|- |
||
Line 1,463: | Line 1,435: | ||
|- |
|- |
||
!External surcharges |
!External surcharges |
||
− | | |
||
|- |
|- |
||
!Default pending account |
!Default pending account |
||
Line 1,476: | Line 1,447: | ||
You can also select decimals for VAT and details regarding Reclamations. Reclamations (claims) require a certain print template, please |
You can also select decimals for VAT and details regarding Reclamations. Reclamations (claims) require a certain print template, please |
||
contact Kalin Setterberg. |
contact Kalin Setterberg. |
||
− | |||
− | [[Category:BAS-MED-EN]] |
Latest revision as of 19:30, 12 June 2017
Uppgifter på kund, medier, användare mm kan exporteras till Excel genom att klicka i rutanExport. Då får man upp en box med selekteringsmöjligheter för den information man önskar få med. Detta val lagras på dig som användare.
Knappen Kopiera används för att kopiera uppgifter från ex annan kund vid ny-upplägg.
Genom att klicka på knappen Tillbaka kommer man åter till startsidan för Basregister.
På de flesta ställen finns valmöjlighet mellan Visa endast aktiva/endast egna som gör att man kan begränsa urvalet.
KUNDER
Överkunder
Används för att knyta samman flera kunder för att ta ut statistik.
Kod | Valfri kod på Överkunden. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Namn | Namnet på Överkunden. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
VAT-nummer | Kundens VAT-nr. Kan redovisas på faktura, plan. Finns som urval och summeringsnivå i rapporter. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Organisationsnummer | Kundens organisationsnummer. Kan redovisas på faktura, plan och i listor. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Eget ID Valfri märkning. Kan skrivas ut i rapporter och i kundreskontran som egen kolumn. |
KunderInne på Kunder kan man välja att se alla eller endast aktiva. Vill man även se överkunder på samma sida klickar man i boxen Visa överkunder. Välj knappen Nyför nyupplägg av kund. Därefter kan knappen Kopiera från användas för att hämta information från en annan kund som har ett liknande upplägg.
See separate description of credit handling and check
Collective productsCollective products are used in a similar way as collective clients are - you can connect different products into one collective product. ProductsProducts are used for statistics and allocation on invoice.
Agreements
In this tab, percentage of commissions to advertising agencies and/or clients is set. Marathon follows what is written on each media and there are two ways of handling over commissions to the client.
Example: If you put 2, 00 “to client” on Commission 1 , the client receives up to 2 % of what we receive from the media. If the media gives us 3 % in commission 1, we give 2 % to the client and keep 1% to ourselves. If the media gives 1, 5 % the client gets all and we nothing. If the media gives 10 % the client receives 2 % and we 8 %. Commissions from media means that you write how much the client receives in format 50/50, 30/70, 80/20 etc. Example: if you set 40, 00 “to client” on Commission 1 and 60, 00 “to us” , forty percent of the commission from media will be sent to the client and 60 percent is for us to keep. If the media gives 3 % agency commission, we give 1, 2 % to the client and keep 1, 8 %. If the media gives 1, 5 % the client gets 0,6 % and we get 0,9 %. If the media gives 10 % the client gets 4 % and we get 6 %.
The tab capital cost shows how much fee mark-up the client shall have and how it shall be calculated. Capital cost: From client- how much in % we debit the client. To agency- how much fee we give to the agency. Shown on the agency reconciliation. Agency 2 - if we want to pass on fee to one more party. . Shown on the agency reconciliation. To other agency- if you use another agency for bookings on a certain client. A separate agreement is necessary at the booking. In this field you must write how much fee the other agent shall charge us. Example: We have a client whom we charge 5 % fee and write it in the field “from client”. Later the advertising agency shall have 1 % of this, and we write 1, 00 in the field “to agency”. In this case we keep 4 % for ourselves. If we additionally are going to use another agency who will add 3 % fee, write it in the field “To other agency”. This means that we charge 5 % from the client; the agency gets 1% of it, the other intermediary gets 3& of it and we can keep 1 %.
The difference between Net after left commission or Net after received commission is that all commissions not necessarily are forwarded to the client, but can be partly kept or forwarded to other intermediary.
Example: We negotiate an advantageous discount and can have a part of it through the agreement. The discount code in the parameters rules the size of our part.
The invoicing currency for the agreement is the one that is selected in the parameters. You can choose between own currency, the currency of the order, or an optional which you write in the field. You can also set a currency rate and a possible mark-up in order to cover currency discrepancies.
Example: The order is in USD, our own currency is SEK but the client wants the invoicing in EUR. The order will be recalculated into SEK and then into EUR. If the orders had been in EUR, the same amount would have been invoiced the client without recalculation to SEK.
Conversion from base currency to foreign currency when invoicing
Conversion from order currency to base currency when invoicing
For notes regarding the agreement, the client, etc. Note that this text only is available here.
Set own fields in base registers-general. The fields can be text fields or numerical fields. The content can be exported to Excel. Client categoriesGrouping clients in categories can be useful for statistics or e.g. for invoicing a certain client category at one time. Client category can be e.g. Cars, and be connected with clients as VOLVO, BMW, SAAB. Categories can also be used for different types of invoicing like current invoicing, once a week, once a fortnight, once a month, etc. Another example is to use categories to separate national/international clients. GroupsGroup can be used to separate clients belonging to different teams/departments/companies. Thus you can use groups for statistic purposes or to select and authorise the data. There are fields in the User register, where you can write the groups that the user is authorised to. Group can also be set on media. AgenciesHere all advertising agencies those clients are connected to are entered. They are used as information on the order to the media. For those clients whose agreement says that they shall have a part of a commission, fee and surcharges, the agency of the client is used to make an agency settlement. In order for this to work, the agency has to be a supplier in the Purchase Ledger.
MEDIAPublisherIf publishers are registered, media can later be connected to these. Useful in statistics and in yearly agreements between client and media/publisher. When a media is connected in the price list and the media in the price list is connected to a publisher, the publishers are automatically activated in this program. Media groupingsDifferent media can be connected to media groupings. Useful for different kinds of statistics A grouping can e.g be a special business.
MediaRegistration of media that then shall be connected to the Media database. When connecting, all information is coming with it. The information is. Address, fax, telephone, e-mail address, currency, type of media, publisher, included media if combination . If one of those are changed it will be overwritten in the update of the media database, that is made every night.
If the media shall be connected to the database, fetch it from the fields “media in the database” and the system will fill address from there.
The commissions that the agency gets from the media and how it shall be calculated.
(Similar for other commissions)
1. All on net 2. Mtrl.c + Agency c, other 3. Mtrl.c + Agency c, Info.c, Paym.c 4. All on gross 5. Mtrl.c + Agency. c on gross, other (on net) 6. Agency. c + Info. c + Payment c, Mtrl. c Description of calculation type 3 Material commission and agency commission are calculated on net. On the net after deduction of material commission and agency commission, information commission is calculated On the net after deduction of material commission. Agency commission and information commission, the payment commission is calculated. Types 2 and 6 work similarly. Type 5 as well, but material – and agency commissions are calculated on gross. This is later deducted from net before calculation of other commissions are made.
If the media is a combination, all included media is shown here. All included media in a combination must exist as individual media in the database to be able to set a combination. Media types
All new media have to belong to a media type. E.g. ad check and possible special postings are decided per media type. When a media is connected to the database the media type is coming automatically- the type that it has been registered to.
Table registration See separate description
ORDERSurcharge codesCodes that shall be used for registration of orders are entered in this tab. You can select other accounts if you don’t want the standard postings for surcharges. Some codes are entered by Kalin Setterberg (media cost and colour surcharge) but you are free to add new codes when needed.
(Same goes for cost account and book-away account)
For media cost and colour surcharge, select media’s VAT, for other codes, most often, client’s VAT.
Discount codesIn this tab discount codes are created and specified.
Placement codesThe placement codes that have been created can later be selected when adding placement manually into the order. By using the database, the codes are coming automatically. Format codesThe format codes that have been created can later be selected when adding formats manually into the order. By using the database, the codes are coming automatically Colour codesThe colour codes that have been created can later be selected when adding colours manually into the order. By using the database, the codes are coming automatically These codes are printed on the material list. Material codesNew material codes are created here, i.e. how the material shall be delivered. In the order –general. It is possible to write delivery and that will be printed out on the order. Material code can e.g. be Courier, ISDN or 999999 ”earlier inserted” which means that the material is available already. Reporting codesRegister for codes that can be used on insertions for statistics
Possibility to create own S-status codes. E.g. S2 for “wait for correction” OTHERUsersA person must be filed as a user in the media system before he/she can be an owner of a plan client manager or reference on an invoice
Name, telephone and fax References on plan printout.
Here you can restrain users’ authorisations.
Reconciling codesDiscrepancies that occur if the media invoice does not agree with client invoice are automatically marked with discrepancy codes- reconciliation codes- according to the rules that are set in the reconciliation codes.
(Same on booked away amounts and pending discrepancies).
The idea with these codes is that when printing lists , you can select to see certain reconciliation codes. It is also easy to book away all discrepancies of a certain type , e.g. approved discrepancies. Claim textsWhen claiming a media invoice you can fetch the text from the register. Report- and column templatesSee separate manual for these functions. Document typesIn this program document types are created, which are used for marking scanned documents in Documents. A document type can e.g. be AG= Agreement. DocumentsDocuments that are scanned can be picked up in Media client agreement in Frontoffice. ParametersThe general settings for the company are found in the parameters. These are set when starting to use Marathon, but can of course be changed.
Settings for the old authorisation system in Classic.
Standard values for creating Clients and Media
Standard values for plans and orders.
Standard settings for invoicing concerning e.g. vat rates, accounts for invoices with media costs, surcharges, etc. periodical tables are set here, if you want a certain invoice date interval to be booked in a certain period (not necessarily the same period).
The posting of media invoices is divided in three parts. First part shows sales and what goes to the client. It is media sales, additional sales, insertion fees and other fees. Also commission deductions are booked on different accounts. The first part concerns everything until Cash discount. In the other part accounts are chosen for commissions. It is good to post all commissions separately. The other part concerns everything until Media cost. Settlement surcharges Not in use Surcharge Not in use The third part conserns the parts that are left to the agency in agency settlements and concerns everything until Cash discount Cap cost from receivables Not in use Cap cost from revenues Not in use
These parameters concern entering of media invoices only if you have outsourced your invoice handling to Kalin Setterbergille. Kalin Setterberg sets the parameters
A special agreement calculates the cost/revenue automatically based on the turnover of the plan. First, enter media and surcharge code for the purchase price and then a second surcharge code (invoiced by media) that is used on the surcharge (no invoice from the media). After that the Special agreement tab will be activated. State the agreed percentage.
Setting for reconciliation and how to book away discrepancies.
Agency settlementSettings concerning Agency settlement are done in 08-71. An updated agency settlement can be booked and moved to the purchase ledger. You can also select decimals for VAT and details regarding Reclamations. Reclamations (claims) require a certain print template, please contact Kalin Setterberg. |