Troubleshooting NEOSYS Media System: Difference between revisions

From NEOSYS User Support Wiki
Jump to navigationJump to search
No edit summary
Line 31: Line 31:


Recovery method 1:
Recovery method 1:
This can take a long time on a large database and requires all users/neosys processes for the same database to be shut down.
This can take a long time on a large database and requires all users/neosys processes for the same database to be shut down.


Line 38: Line 37:
  choose "Reindex the Ads File"
  choose "Reindex the Ads File"


Recovery Method 2:
To run CREATEADS while users are online, you can follow the procedure mentioned below:
SELECT SCHEDULES
CREATEADS


Recovery method 3:
Re-save the schedule(s) that show the problem. This is identical to CREATEADS but is much quicker and doesnt require all users to logoff. Of course if there are many errors then this isnt a practical solution.


[[Fixing wrong exchange rates in invoices]]
Recovery Method 4:
The following method can be used for selected schedules instead of re-saving them:


Recovery method 2:
SELECT SCHEDULES “XYZ1201R” “XYZ1201T”
CREATEADS


Resave the schedule(s) that show the problem. This is identical to CREATEADS but is much quicker and doesnt require all users to logoff. Of course if there are many errors then this isnt a practical solution.
[[Fixing wrong exchange rates in invoices]]


=== Removing unnecessary items from List of Schedules Pending Invoices ===
=== Removing unnecessary items from List of Schedules Pending Invoices ===

Revision as of 11:38, 17 May 2012

Correcting order of ads in media diary

After changing any reference files like clients, suppliers and media vehicles the order of ads may be incorrect.

For example changing the supplier of a vehicle may result in a media diary ordered by vehicle to incorrectly show ads from one vehicle in two separate places in the report instead of together.

The solution is to run the CREATEADS program in maintenance mode.

F5
CREATEADS

Details missing in Media Diary or Changes in Files does not reflect in Media Diary

Unusually for NEOSYS, in the ADS file (on which the media diary and all "List of Ads" type reports and files are based) lots of referential information (like client/supplier/cost etc) is frozen at the point of the last update. Running CREATEADS rebuilds the ads file and therefore gets/stores the latest client, supplier, cost etc info into the ad records. Moving brands between clients and vehicles between suppliers is rare.

F5
CREATEADS

Note: This can take a long time on a large database and requires all users/neosys processes for the same database to be shut down. When you run CREATEADS, it asks you to confirm a period from when to run this task. You need to be aware that any period before the input period will not show in any Media Diary Reports. Eg.if you input 2006, then you cannot generate a Media Diary for 2005 or any year backwards.

In most files other files, NEOSYS only stores the main codes like brand code and vehicle code and every time a report needs the client or supplier code it looks up that information from the separate brand or vehicle file so it always gets the latest info. This is how databases usually work. Actually some people would like the reports based on the ORIGINAL codes rather than the latest codes.


Ads are missing from Some but not All Media Diary and/or related Reports/Screens or you get some errors like "The ad has not been booked. Are you sure that you want to certify this ad?"

Cause: Possibly caused by user action

Explanation:May be user have changed the dates on the calendar and selected to NOT rebook the changes. Then the ads on the new dates would NOT have booking order numbers. It can be checked by inspecting the List of Booking Orders to find the time and date that the booking order was created and the time and date of all schedules file modifications.


Cause: System error - possible an unresolved NEOSYS software error

Recovery method 1: This can take a long time on a large database and requires all users/neosys processes for the same database to be shut down.

F5
CREATEADS
choose "Reindex the Ads File"

Recovery Method 2: To run CREATEADS while users are online, you can follow the procedure mentioned below:

SELECT SCHEDULES
CREATEADS

Recovery method 3: Re-save the schedule(s) that show the problem. This is identical to CREATEADS but is much quicker and doesnt require all users to logoff. Of course if there are many errors then this isnt a practical solution.

Recovery Method 4: The following method can be used for selected schedules instead of re-saving them:

SELECT SCHEDULES “XYZ1201R” “XYZ1201T”
CREATEADS

Fixing wrong exchange rates in invoices

Removing unnecessary items from List of Schedules Pending Invoices

Sometimes, schedules which don't need invoicing appear on the List of Schedules Pending Invoicing. This occurs if you do the following:

  1. Invoice the schedule. NEOSYS removes it from the pending invoicing list.
  2. Modify the schedule. NEOSYS puts it back onto the pending invoicing list.
  3. Modify the schedule back to as it was invoiced in. NEOSYS *doesn't* remove it from the pending invoicing list.

The solution is to ask for a proforma invoice for the schedule (in the invoice options page - select Certified-All Ads). This will give you a "nothing to invoice" message and remove it from the list. Asking for a proforma instead of an invoice is a precaution to avoid accidentally raising an invoice if there really is something to invoice on the schedule that you didn't expect, and will show you exactly what is pending invoicing.

If you are using the X option in the discounts/charges section to generate separate discount/fee invoices then you probably want to use Invoice Type: "Final" otherwise you will get an invoice that reverses the final invoice/credit note (since the default Invoice Type is "Initial")

Why do my two media vehicles/clients/etc come out as one line on the media analysis reports ?

Because you have given them exactly the same name. If you do this then NEOSYS assumes that you wish two vehicles/clients/etc. to be treated as one at least for analysis.

If you still want to see them separately and retain the similarity of name make some minor change in the name of one vehicle/client/etc. Even adding just a dot to one will cause them to appear as separate lines.

Hitting F9 is not giving the excel media diary but clicking "List" is

It seems that IE default security settings won't open an Excel file in response to pressing a key but only to a real click from the user.

A comment has been added on the screen to warn people about this in the new version of NEOSYS as shown below:

o Normal
o Excel Worksheet (must actually click the "List" button) 
o Tabbed Text File

You can also enable the download as follows:

IE Tools Dropdown, Internet Options, Security Tab, Internet Zone, Custom Level, Downloads, Automatic Prompting for Downloads: ENABLE

Error: Document too large to save

NEOSYS media schedules have a technical restriction to be within 60000 bytes. TV Campaigns which generally are large in size (many spots, across many days etc) and hence could well go over 60000 bytes after a series of rebookings or changes. It is best that TV schedules are done PER MONTH to avoid this error, however this can't guarantee that the size couldn't go way over the limit. At the moment there is no visual indicator on the schedule to see the current size and if the size hits the ceiling, the schedule can no longer be saved.

Documenttoolarge.jpg

Error Message:
Cannot Save "***********" because:
Error: Document too large to save (73712 bytes/max 60000)
Edit some characters from the document and try again

If the user encounters this error, the very next step is to abandon using the schedule for any future dates and clear the schedule of the same to free up space. An example of how to reduce the size is explained below:

  1. Copy the schedule to a new one first to utilise the future dates (you may remove the past dates from the new schedule thereafter)
  2. Go to each vehicle line which has future ads and clear these lines by clicking on the date grid box and removing the dates manually
  3. Remember not to rebook the cancellation for the removed ads as this will inflate the size of the schedule again
  4. If the vehicle line has only future dates, it is best to remove all further details in the line which are Position/Program, Bill & Cost values etc
  5. Look for any vehicles lines which have been cancelled in the past and remove all the details in those lines
  6. Save the schedule after you edit every line to ensure the size of the schedule is indeed dropping
  7. The key to reduce the size of the file is by NOT REBOOKING any edits you do

Why doesn’t the Total Amount column equal to Number of Ads x Unit Price ?

Case 1

After invoicing, if you change the number of ads AND also change the unit cost then the net change to be debited or credited is an average unit price.

It is better to show the total number of ads changed and the total change in the net unit price because clients understand this better despite the apparent lack of numerical accuracy.

NEOSYS warns you during data entry not to change the unit price on lines with any invoiced ads. However, some users may be authorised to ignore the warning. The message advises that instead of changing the unit price, you should cancel all the ads at the old rate and insert a new line at the new rate. If you follow this suggestion then the issue does not arise.

If you do not want to cancel the old line/rate and re-enter a new line/rate but still require that the columns agree arithmetically, you can to do the changes in stages as follows:

  1. Change the unit price
  2. Generate credit note for the change in unit price

  3. Change the number of ads
  4. Generate credit note for the change in number of ads

(or vice versa)

NEOSYS could in theory do this automatically by presenting a double change as TWO lines on the credit note (one line crediting all the invoicing to date and one line debiting as per schedule currently) but it hasn’t got this facility at the moment and the current practice has been broadly accepted by clients for many years.

Case 2

Mediaconfigbooktobillcurr.jpg

When using the media configuration file options to conceal booking currency from clients by converting it to billing currency, it is possible to have rounding errors as follows:

NEOSYS converts the following columns from Media Booking Currency to Client/Bill Currency:

  • Gross Unit Amount
  • Net Unit Amount

Rounding errors in the Net Unit Amount:
NEOSYS does not recalculate the Net Unit Amount from the new Gross Unit Amount based on the discounts and charges therefore there can be rounding errors if you manually check the calculation of the Net Unit Amount from the previous columns.

Rounding errors in the final Net Amount column:
NEOSYS does not recalculate the final Net Amount column as the new Net Unit Amount (Billing Currency) x Number of Ads therefore there can be rounding errors if you manual check the calculation of the final column from the previous columns.

This is due to the complexity of changing all the billing calculations in the software.

Why is my schedule printout showing Net column as Gross ?

Schedule net shows gross.jpg

This only happens when you have entered values at the bottom of the schedule for either Agency Discount (%), Fee (%) or Tax Code/Tax (%); as logically the Net amount can only be derived after you add/subtract the amounts from below the schedule.

Schedule net bottom.jpg

Error: Free is not supported for Mass Advertising

While trying to mark Internet Ads as Free in NEOSYS, you come across the error message, Free is not supported for Mass Advertising , as follows:

Error In Free Ads Digital Media.jpg

Error Message:

Free is not supported for mass advertising
(Vehicle "FACEA" certification mode is "summary")

The above error appears because Online media vehicle types are tagged as "Summary", they are recorded as a single ad to save space and speed up processing and hence cannot be used for the Free option. This is done because online ads are just impressions and not actual ads which are required to be tracked individually.

Click on Free Internet Ads to learn how to do Free Ads for Digital Media.

Error: No output file in MEDIAPROXY SCHEDULEPRINT

This error occurs while creating media invoices with Paging: By Line.

The solution is to enter some vehicles and not leave it the option blank.

Select the vehicle or vehicles that you want to invoice, or all vehicles if you want to invoice everything, but don’t leave vehicles blank.