By using this web site, you agree to all terms and conditions for acceptable use.

ServiceLedger KnowledgeBase Knowledgebase Home Page > ServiceLedger > Technical | Contact Us

Search the Knowledge Base Browse by Category

ServiceLedger provides this content as-is for self help support purposes. ServiceLedger assumes no liability for any steps you take based on the directions in our knowledge base, and assumes that you have the knowledge to determine whether a given step is appropriate for your situation. Certain solutions can affect third-party software that ServiceLedger relies on or integrates with; it is your responsibility to consult with the documentation or publishers of such third-party software to understand whether any changes suggested here will have negative effects on other applications.

(T0209) Updating all Service Charges for all accounts and locations

Would you like to...

Print this page
Email this to a friend

This should only be done after backing up your ServiceLedger database.  This function will set all accounts and account locations to the exact amount specified.  It affects all accounts and account locations, not just some.

  1. Go to Administration->Administration in SL
  2. Press Alt-F9 repeatably until you see a SQL tab
  3. Copy this command in the text area, replacing it with the amount:
    update client set service_charge = 100.00
    update client_location set service_charge = 100.00
  4. Press Exec
  5. Review your changes immediately.  Restore your backup if the changes are undesirable.


Related Questions:


No attachments were found.

ServiceLedger KnowledgeBase Copyright © 2020
Powered by AcitveKB Knowledgebase Software