Category Archives : Uncategorized

Interesting Quickbooks Utilities

http://www.q2q.us/index.htm

 

1. Data Transfer Utility transfers transactions between QuickBooks files.
2. Beginning Balance Transfer Utility – transfers beginning trial balance, a/r, a/p and inventory.
3. Check Transfer Utility transfers payroll checks.
4. Data Remover – deletes list names and transactions.

5. Merge Customers merges customers with no sales in a user entered date range.
6. Report Combiner produces consolidated financial statements from multiple QuickBooks files.
7. Custom Financial Reporter produces presentation quality financial statements and budget comparisons.
8. Weekly Financial Reporter produces weekly comparative statements. (4-4-5, 13 weeks, 52/53)

9 . Invoice Duplicator create one invoice and send it to multiple customers. Useful for HOA’s.

10. Customer Payment Analyzer shows your customers payment patterns.

11. Mark Invoices – mark or unmark invoices to be printed or to be emailed with a few mouse clicks.

12. Intercompany Transfer Utility – transfers intercompany charges from a Parent to multiple Subsidiaries.

13. Dues Billing System Invoice all of you customers at once with a different amount per customer.

14. Inventory Turnover Calculate inventory turnover by item. Helps identify excess inventory.

15. Sales By Ship To Address Creates Summary and Detail Sales reports based on Ship To address.

16. Gross Profit Analyzer Creates summary and detail gross profit reports by customer, sales rep and item.

17. Drop Multicurrency Transfers data from a multicurrency file to a non multicurrency file.

18. Bank Draft Creator Creates checks on your customers bank accounts. These checks are faster and cheaper than credit cards and other payment methods because you can deposit them the same day that you create them and there are no fees for depositing the checks.

19. Job Cost Reporter Create job reports that include unbilled cost, open purchase orders, unbilled time, unpaid time and quantities.

20. Update Custom Fields – Items Allows you to compare sales price and average cost on items.

21. Invoice To Bill Allows vendors to send Invoice data, using the Cloud, to Customers who can download and import the data as Bills.

22. Electronic Order Transfer Transfers Purchase Orders to Vendors and imports them as Sales Orders.

23. Recover Deleted Transactions If you accidentally delete transactions from your current file, this program can recover them from any backup that contains those transactions.

24. Mass Updater – Mass update many different fields on transactions.

How to correct Windows 8 app stuck on pending

2 ways to address this that I’ve seen.

The first requires you open a command line with Administrator Priveleges and type in the following:

  1. net stop wuauserv
  2. rename c:\windows\SoftwareDistribution softwaredistribution.old
  3. net start wuauserv

The second is the open Services.msc and stop the Windows Update service (same as using the commands above, use this if that doesn’t work).

At a Run lines, type in services.msc

  1. Stop Windows Update service
  2. Browse to c:\windows\SoftwareDistribution and rename the folder to softwaredistribution.old
  3. Start Windows Update service

Restart Exchange 2007 Services From Powershell

Restart Exchange 2007 Services From Powershell

http://windowsserveradministration.blogspot.com/2011/03/restart-exchange-2007-services-from.html

If you are troubleshooting Exchange Server 2007 than it will be good to have a look at the Services on which Exchange Server 2007 depends.
Cut-Paste the following code in Powershell to RESTART Exchange Server 2007 services on your Exchange Server.
Stop-Service MSExchangeAdTopology
Stop-Service MSExchangeAntiSpamUpdate
Stop-Service MSExchangeEdgeSync
Stop-Service MSExchangeFDS
Stop-Service MSExchangeIMAP4
Stop-Service MSExchangeIS
Stop-Service MSExchangeMailSubmission
Stop-Service MSExchangeMailboxAssistants
Stop-Service MSExchangeMonitoring
Stop-Service MSExchangePOP3
Stop-Service MSExchangeRepl
Stop-Service MSExchangeSearch
Stop-Service MSExchangeServiceHost
Stop-Service MSExchangeSA
Stop-Service MSExchangeTransport
Stop-Service MSExchangeTransportLogSearch
Stop-Service msftesql-Exchange -Force
Start-Service MSExchangeAdTopology
Start-Service MSExchangeAntiSpamUpdate
Start-Service MSExchangeEdgeSync
Start-Service MSExchangeFDS
Start-Service MSExchangeIMAP4
Start-Service MSExchangeIS
Start-Service MSExchangeMailSubmission
Start-Service MSExchangeMailboxAssistants
Start-Service MSExchangeMonitoring
Start-Service MSExchangePOP3
Start-Service MSExchangeRepl
Start-Service MSExchangeSearch
Start-Service MSExchangeServiceHost
Start-Service MSExchangeSA
Start-Service MSExchangeTransport
Start-Service MSExchangeTransportLogSearch
Start-Service msftesql-Exchange

You do not have to start the services highlighted in GREEN if you are not using POP3 or IMAP4.

After running the above code give it a 30 seconds for all the services to come up.
————————————————————————————————-
YOU CAN DO THIS WAY TOO !!

Restart-Service MSExchangeAdTopology  -Force

Restart-Service MSExchangeAntiSpamUpdate  -Force
Restart-Service MSExchangeEdgeSync  -Force
Restart-Service MSExchangeFDS  -Force
Restart-Service MSExchangeIMAP4  -Force
Restart-Service MSExchangeIS  -Force
Restart-Service MSExchangeMailSubmission  -Force
Restart-Service MSExchangeMailboxAssistants  -Force
Restart-Service MSExchangeMonitoring  -Force
Restart-Service MSExchangePOP3  -Force
Restart-Service MSExchangeRepl  -Force
Restart-Service MSExchangeSearch  -Force
Restart-Service MSExchangeServiceHost  -Force
Restart-Service MSExchangeSA  -Force
Restart-Service MSExchangeTransport  -Force
Restart-Service MSExchangeTransportLogSearch  -Force
Restart-Service msftesql-Exchange -Force  -Force


———————————————————————————————————–

IF YOUR EXCHANGE SERVER IS UNSTABLE AFTER RESTARTING SERVICE THAN THIS CMDLET WILL MAKE SURE THAT ALL THE REQUIRED SERVICES ARE RUNNING


Test-ServiceHealth | Select-Object -Expand ServicesNotRunning | Start-Service

Time to go PST hunting with the new PST Capture 2.0

 

http://blogs.technet.com/b/exchange/archive/2013/02/22/time-to-go-pst-hunting-with-the-new-pst-capture-2-0.aspx

Ahoy, Exchange Ninjas! It’s time to buckle up and go PST hunting again with the new PST Capture 2.0!

Earlier this week, we released a brand new version of the free PST Capture tool that allows you to hunt down PST files on client computers across your network. After it finds PST files on users’ computers, the tool consolidates the PST files to a central location, and then easily injects PST data to primary or archive mailboxes on your on-premises Exchange Servers or Exchange Online.

What’s new in PST Capture 2.0?

PST Capture 2.0 includes the following improvements:

  • Support for Microsoft Exchange Server 2013
  • Updated profile generation code to use Outlook Anywhere (RPC over HTTP).
  • Fixed Exchange Online import failure issue when PST Capture is not installed on an Exchange server.
  • Removed User Interface limit of 1,000 users when performing an import to Exchange Online.
  • General performance improvements

Download PST Capture 2.0 from the Download Center (aka.ms/getpstcapture), check out the PST Capture documentation (aka.ms/pstcapture) and then go get those PSTs!

Exchange Team

SBS – Setup a Public Folders Shared Calendar

http://blog.mpecsinc.ca/2007/07/sbs-setup-public-folders-shared.html

 

This is our method for setting up a shared calendar, contacts list, task list, etc. at the root of the Exchange Public Folders.

  1. Start your web browser on any workstation or the SBS server.
  2. Open: https://mysbsserver/public
  3. Logon as the domain admin
  4. Right click on Public Folders and click New Folder
    Name it and select Appointment Items under the "This folder contains:"
  5. Click OK
  6. Log off of OWA.

We do this because adding the folder via Exchange Management does not give us the ability to share any content. It is strictly a storage folder.
We move on to:

  1. Log onto the SBS server as domain admin.
  2. Under the Server Management Console:
  3. Advanced Management
  4. Right click on First Organization (Exchange) and click on Properties
  5. Put a tick beside both "Display …."
  6. Click Apply and OK. (You may be warned to close the console)
  7. Close the Server Management Console.
  8. Open it again.
  9. Again, under Advanced Management:
  10. Expand the Exchange organization–>Administrative Groups–>first administrative group–>Folders
  11. Right Click on the above created folder and click on Properties.
  12. Click the Limits tab if you want to set limits to the folder.
  13. Click the Permissions tab.
  14. Click the Client permissions button.
  15. Add and set permissions for those users who need access to this folder.

Now we continue on to configure Outlook.
The process is quite straight forward for adding the new folder to Outlook:

  1. Open Outlook.
  2. Click on the Folders View button.
  3. Navigate to Public Folders–>All Public Folders.
  4. Right click on the folder created above, and "Add to Favorites".
  5. Name the Favorite and click ADD.
  6. Click on the Calendar button in Outlook.

You will now see the newly added calendar under "Other Calendars" in Outlook.
The user will be able to click on it and work with their own calendar and the shared calendar side by side.
Permissions on the folder can be quite granular. Be very careful about giving people Delete permissions on ALL items other than their own. Only a couple of key people who understand the process should have that permission.
It is also important to let the users know that updates to the shared calendar will not necessarily be reflected at the other workstations that are connected to it right away. It sometimes takes a bit of time before updates are shown across the organization.
This process is essentially the same for all types of Exchange Public Folders shared items.
For larger organizations, adding folders at the root may make sense for organizing their content.

Our Largest Disaster Recovery Navigated Successfully To Date

http://blog.mpecsinc.ca/2013/03/our-largest-disaster-recovery-navigated.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+MpecsIncBlog+%28MPECS+Inc.+Blog%29

 

The first heart stopping, cold hands inducing, and sinking stomach moment:

  • (SBS, ShadowProtect, and an Event ID 55 NTFS Error …)

The second heart stopping, cold hands inducing, and sinking stomach moment where server death was now known to be immanent:

  • (Images No Good … Catastrophic SBS Failure … Down What?!?)

Now, becoming less and less relevant but having a second DC on an SBS STD network can be a killer when recovering:

SBS – Exchange Information Store is Corrupt? Recreating the Store

  • Once we were down the line from point of recovery we still had issues with the Exchange databases we forklifted into place. This post outlines all of the steps to get content out of Exchange, create a new database set, and merge it back in. Exchange 2003.

SBS & ShadowProtect – Some Hardware Independent Restore considerations

  • This post is relevant for any full bare metal or hypervisor restore of a server.

SBS Disaster Recovery – Finished

« Previous PageNext Page »
Back to Top