|
|
|
Forum Member
 
Group: Forum Members
Last Login: 9/30/2008 7:49:59 AM
Posts: 35,
Visits: 225
|
|
| After upgrading to Ayanova 4 all the rates that are listed as contract no longer show up as an available rate to select in labor on clients with the specified contract. This is huge as we listed all our clients under different contracts so we could reflect different rates for them.
|
|
|
|
|
AyaNova Sales & Support
Group: Administrators
Last Login: Yesterday @ 2:10:09 PM
Posts: 1,834,
Visits: 4,252
|
|
| Hi Please provide the following for one of these clients so that we can confirm with you: - the client name
- The contract selected in that client's entry screen
- What is the contract expiry date entered in that client's entry screen (as an expiry date is required to initiate the contract settings)
- The contract itself - is Active checkedmarked?
- The contract itself - is Limit to Contract rates checkmarked or not?
- the rates that are displaying - are any of them set as Contract Rate in the rates subgrid?
- when you view the workorder for this client, is the Contract menu option showing in the workorder menu bar?
- Joyce
- AyaNova Sales & Technical Support
- http://www.ayanova.com
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/30/2008 7:49:59 AM
Posts: 35,
Visits: 225
|
|
| Well that would be the problem. Contract expiry date did not used to be a requirement and it is set as NULL for everyone. Why did this change and what options do we have other than manually editing each of these one by one to a distant date?
|
|
|
|
|
AyaNova Sales & Support
Group: Administrators
Last Login: Yesterday @ 2:10:09 PM
Posts: 1,834,
Visits: 4,252
|
|
| Hello again Chris No expiry date is viewed by the code the same as an expired contract date - therefore the contract settings are not enforced. I've asked development to come in from their weekend, and make a utility that those AyaNova 3 users that have upgraded that never entered an expiry date can run to enter it automatically. Will post back as soon as it is done. - Joyce
- AyaNova Sales & Technical Support
- http://www.ayanova.com
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/30/2008 7:49:59 AM
Posts: 35,
Visits: 225
|
|
| At this point I wouldn't even just mind a SQL query to run manually on the server since we're using MSSQL. Or if it can just be confirmed the location that needs to be updated and if there's any special references that I need to worry about I can just write it on my own.
|
|
|
|
|
AyaNova Sales & Support
Group: Administrators
Last Login: Yesterday @ 2:10:09 PM
Posts: 1,834,
Visits: 4,252
|
|
| Hi again It is the ACONTRACTEXPIRES column in the ACLIENT table that this is in relation to. If you do a SQL query, do be sure to: - Have everyone out
- Make a backup
- run your query and update the client records
- Log in as one user only, and check a number of them
- If an issue, restore from backup and use the utility instead that we will be releasing.
- Joyce
- AyaNova Sales & Technical Support
- http://www.ayanova.com
|
|
|
|
|
AyaNova Sales & Support
Group: Administrators
Last Login: Yesterday @ 2:10:09 PM
Posts: 1,834,
Visits: 4,252
|
|
| Hi again 1. Download UpdateContracts.zip 2. Extract to the AyaNova 4 program folder 3. Make sure no one else is accessing the AyaNova 4 database 4. Run the UpdateContracts.exe utility 5. Log in as the AyaNova Administrator 6. It will apply the date of year 2100 UTC time zone to all client's that have a contract selected but do not have a contract entry date selected. It won't change existing Contract Expiry Dates for existing selected contracts. I will also post about this to the Known Issues & Updates section of this forum in a bit as a common place for AyaNova 4 users to see this. - Joyce
- AyaNova Sales & Technical Support
- http://www.ayanova.com
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/30/2008 7:49:59 AM
Posts: 35,
Visits: 225
|
|
| Fine, so I had just done 12/31/2099 12:00 AM UTC and was pasting the query when this was uploaded. UPDATE ACLIENT
SET ACONTRACTEXPIRES = '2099-12-31 00:00:00.000'
WHERE ACONTRACTEXPIRES IS NULL; Thanks for the quick response.
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/30/2008 7:49:59 AM
Posts: 35,
Visits: 225
|
|
One more thing, I didn't use the updater but you also need to run this against head offices:UPDATE AHEADOFFICE
SET ACONTRACTEXPIRES = '2099-12-31 00:00:00.000'
WHERE ACONTRACTEXPIRES IS NULL;Thanks, Chris
|
|
Posted 1/12/2008 8:42:06 AM
