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.

(T0248) How do I prevent an invoice from being exported to Peachtree?

Would you like to...

Print this page
Email this to a friend

This method applies to a single invoice with a known invoice #.  An example is provided below.

This example uses invoice #2491, which you may substitute with the invoice number of your choice. The character before update and at the very end is a double quote, the characters around the invoice number are single quotes.

If you are not using the database engine we provide, and instead using your own version of sql server, you must change sldemosl to your current sa password, as well as remove or modify the -S parameter depending on if you have an instance (most systems with their own SQL version will not, so you would remove it)

  1. Log into your server as an administrator
  2. Go to Start->Run and type (It is recommend you copy & paste this as it must be exact)
    osql -S .\ServiceLedger -U sa -P sldemosl -d ServiceLedger -Q "update invoice set link_1='exported' where invoice_number = '2491' "
  3. Click run or ok, you may see a flash, then it will be marked as exported

Related Questions:


No attachments were found.

ServiceLedger KnowledgeBase Copyright © 2020
Powered by AcitveKB Knowledgebase Software