Troubleshooting NEOSYS Media System: Difference between revisions
Line 14: | Line 14: | ||
Cause: System error - possible an unresolved NEOSYS software error | Cause: System error - possible an unresolved NEOSYS software error | ||
Recovery: | 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 | F5 | ||
Line 21: | Line 23: | ||
[[Fixing wrong exchange rates in invoices]] | [[Fixing wrong exchange rates in invoices]] | ||
Recovery method 2: | |||
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. | |||
=== Removing unnecessary items from List of Schedules Pending Invoices === | === Removing unnecessary items from List of Schedules Pending Invoices === |
Revision as of 12:26, 24 November 2008
Client / Brand / Category change 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 etc) is frozen at the point of the last update. Running CREATEADS rebuilds the ads file and therefore gets/stores the latest client, supplier etc info into the ad records. Moving brands between clients and vehicles between suppliers is rare.
F5 CREATEADS
Note: 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.
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"
Fixing wrong exchange rates in invoices
Recovery method 2:
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.
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:
- Invoice the schedule. NEOSYS removes it from the pending invoicing list.
- Modify the schedule. NEOSYS puts it back onto the pending invoicing list.
- 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")