Tag Archives: microsoft
How do I fix QuickBooks Payroll Error 12002, 12007, 12009, 12029 and 12031?
Troubleshooting Solutions: QuickBooks Payroll Error 12002, 12007, 12009, 12029 and 12031
QuickBooks Payroll errors 12031, 12029, 12009, 12007, and 12002 often stem from network connectivity issues hindering QuickBooks Payroll updates or communication with servers. Here’s how to troubleshoot and resolve these errors effectively:
Check Internet Connection: Verify that your internet connection is stable and functioning correctly. Attempt to access other websites or applications to confirm connectivity.Configure Firewall and Security Software: Adjust firewall and security settings to allow QuickBooks Payroll access to the internet. Add QuickBooks Payroll to the list of trusted applications or temporarily disable firewall and security software to see if it resolves the issue.Update QuickBooks and Payroll: Ensure both QuickBooks and your Payroll service are up to date. Updates often contain fixes for known issues and enhancements to improve compatibility and stability.Use QuickBooks Connection Diagnostic Tool: Intuit provides a Connection Diagnostic Tool to diagnose and troubleshoot network-related problems. Download and run this tool to identify and fix connectivity issues affecting QuickBooks Payroll.Review Internet Explorer Settings: QuickBooks Payroll utilizes Internet Explorer settings for internet connectivity. Confirm that Internet Explorer is set as your default browser and that SSL (Secure Sockets Layer) is enabled. Clear browser cache and temporary internet files.Adjust Internet Explorer Security Settings: Modify Internet Explorer security settings to the default level or lower to ensure compatibility with QuickBooks Payroll. Navigate to Internet Options > Security tab, set the security level to Medium-High, and add intuit.com as a trusted site.Verify Router and Network Configuration: Ensure your router and network configuration are correctly set up. Check for any network issues such as DNS (Domain Name System) resolution problems or IP address conflicts.Restart Router and Computer: Sometimes, a simple restart of your router and computer can resolve temporary network issues. Turn off both devices, wait for a few minutes, and then power them back on.Test on a Different Network: If feasible, try connecting to a different network to determine if the issue persists. This can help identify whether the problem is specific to your current network configuration.Contact Internet Service Provider (ISP): If you’ve exhausted all troubleshooting steps and continue to experience connectivity problems, reach out to your ISP for assistance. They can help diagnose and resolve any network-related issues impacting your internet connection.
By following these troubleshooting solutions, you can effectively address QuickBooks Payroll errors 12031, 12029, 12009, 12007, and 12002, ensuring smooth processing of payroll tasks without interruptions. It’s essential to keep both QuickBooks and Payroll updated regularly and maintain a stable internet connection for optimal performance.
Troubleshooting Solutions: QuickBooks Payroll Error 12002, 12007, 12009, 12029 and 12031 QuickBooks Payroll errors 12031, 12029, 12009, 12007, and 12002 often stem from network connectivity issues hindering QuickBooks Payroll updates or communication with servers. Here’s how to troubleshoot and resolve these errors effectively: Check Internet Connection: Verify that your internet connection is stable and functioning correctly. Attempt to access other websites or applications to confirm connectivity.Configure Firewall and Security Software: Adjust firewall and security settings to allow QuickBooks Payroll access to the internet. Add QuickBooks Payroll to the list of trusted applications or temporarily disable firewall and security software to see if it resolves the issue.Update QuickBooks and Payroll: Ensure both QuickBooks and your Payroll service are up to date. Updates often contain fixes for known issues and enhancements to improve compatibility and stability.Use QuickBooks Connection Diagnostic Tool: Intuit provides a Connection Diagnostic Tool to diagnose and troubleshoot network-related problems. Download and run this tool to identify and fix connectivity issues affecting QuickBooks Payroll.Review Internet Explorer Settings: QuickBooks Payroll utilizes Internet Explorer settings for internet connectivity. Confirm that Internet Explorer is set as your default browser and that SSL (Secure Sockets Layer) is enabled. Clear browser cache and temporary internet files.Adjust Internet Explorer Security Settings: Modify Internet Explorer security settings to the default level or lower to ensure compatibility with QuickBooks Payroll. Navigate to Internet Options > Security tab, set the security level to Medium-High, and add intuit.com as a trusted site.Verify Router and Network Configuration: Ensure your router and network configuration are correctly set up. Check for any network issues such as DNS (Domain Name System) resolution problems or IP address conflicts.Restart Router and Computer: Sometimes, a simple restart of your router and computer can resolve temporary network issues. Turn off both devices, wait for a few minutes, and then power them back on.Test on a Different Network: If feasible, try connecting to a different network to determine if the issue persists. This can help identify whether the problem is specific to your current network configuration.Contact Internet Service Provider (ISP): If you’ve exhausted all troubleshooting steps and continue to experience connectivity problems, reach out to your ISP for assistance. They can help diagnose and resolve any network-related issues impacting your internet connection.By following these troubleshooting solutions, you can effectively address QuickBooks Payroll errors 12031, 12029, 12009, 12007, and 12002, ensuring smooth processing of payroll tasks without interruptions. It’s essential to keep both QuickBooks and Payroll updated regularly and maintain a stable internet connection for optimal performance. Read More
Calculated Column if any Column is Blank
I need a calculated column that Shows true if any columns are blank, not one but all columns. Any ideas?
I need a calculated column that Shows true if any columns are blank, not one but all columns. Any ideas? Read More
Azure backup, Invalid Credentials every time
Hi,
I am trying to setup the Azure Backup in WAC and all I get is Invalid Vault Credentials provided. Isn’t WAC supposed to download the vault credentials by itself during the provision? Or is there some step I am missing?
I’ve created a brand new recovery services vault. I am logged in to Azure in WAC using a subscription Owner. I open Azure Backup in wac and is presented with all the options, and the wanted vault is already selected. I chose System state backup and input a 16+ character recovery password.
The client is installed, a certificate is updated, I see that in the logs in Azure, but in the end it fails with Invalid Credentials.
Am I supposed to manually install something in the target machine? I understand that shouldn’t be necessary.
Hi,I am trying to setup the Azure Backup in WAC and all I get is Invalid Vault Credentials provided. Isn’t WAC supposed to download the vault credentials by itself during the provision? Or is there some step I am missing?I’ve created a brand new recovery services vault. I am logged in to Azure in WAC using a subscription Owner. I open Azure Backup in wac and is presented with all the options, and the wanted vault is already selected. I chose System state backup and input a 16+ character recovery password.The client is installed, a certificate is updated, I see that in the logs in Azure, but in the end it fails with Invalid Credentials.Am I supposed to manually install something in the target machine? I understand that shouldn’t be necessary. Read More
Why my Windows 10 laptop restarts randomly in sleep mode
My Windows 10 laptop sets to auto sleep after 30 minutes of being idle. For the past 5 days, The laptop PC reboots randomly when it is in sleep mode. I checked Event Viewer and it happens because of the same Critical Error every time.
My Windows 10 laptop sets to auto sleep after 30 minutes of being idle. For the past 5 days, The laptop PC reboots randomly when it is in sleep mode. I checked Event Viewer and it happens because of the same Critical Error every time. Read More
Outgoing mail and MTA
Hello all,
I’ve an internal Exchange 2019 server.
I’m hosting differents domains.
What I want to do is redirecting out mails on specific MTA based on domain source .
Thanks for helping.
Hello all, I’ve an internal Exchange 2019 server.I’m hosting differents domains.What I want to do is redirecting out mails on specific MTA based on domain source .Thanks for helping. Read More
Windows Explorer frozen from time to time
On my Windows 10 PC, Windows Explorer seems to freeze from time to time. I notice this because the clock in the lower right corner stays frozen.
When that happens, the Windows Explorer stops working. I can’t even close a lot of apps. Nor can I restart the PC. If I try and click on restart, nothing happens.
I have to manually hit the restart or power off on my tower.
Is there any way to fix it?
On my Windows 10 PC, Windows Explorer seems to freeze from time to time. I notice this because the clock in the lower right corner stays frozen. When that happens, the Windows Explorer stops working. I can’t even close a lot of apps. Nor can I restart the PC. If I try and click on restart, nothing happens. I have to manually hit the restart or power off on my tower. Is there any way to fix it? Read More
How do I fix QuickBooks Error 3371 status code 11118 after update?
Troubleshooting Solutions: QuickBooks Error 3371 status code 11118
QuickBooks Error 3371 status code 11118 often indicates a problem with the software’s license properties or damaged files. Here’s how you can troubleshoot and resolve this issue efficiently:
Update QuickBooks: Ensure that you’re using the latest version of QuickBooks. Updating the software can often resolve compatibility issues and bugs that may trigger Error 3371.Run QuickBooks Install Diagnostic Tool: Intuit provides a diagnostic tool designed to identify and fix installation issues. Download and run the QuickBooks Install Diagnostic Tool to automatically detect and resolve problems with your QuickBooks installation.Recreate EntitlementDataStore.ecml File: The EntitlementDataStore.ecml file stores your QuickBooks license information. Deleting this file and re-registering QuickBooks can resolve issues related to licensing. Close QuickBooks, press Windows + R to open the Run command, type “%ProgramData%IntuitEntitlement Clientv8” (without quotes), and hit Enter. Delete the EntitlementDataStore.ecml file, restart QuickBooks, and re-register the product.Update Windows Components: Ensure that your Windows operating system and related components like Microsoft .NET Framework, MSXML, and C++ are up to date. Outdated or damaged Windows components can interfere with QuickBooks functionality and trigger Error 3371.Perform a Clean Install of QuickBooks: If the issue persists, consider performing a clean reinstall of QuickBooks. Uninstall QuickBooks from your system, rename the installation folders, reinstall QuickBooks, and then update it to the latest version.Check for Third-Party Software Conflicts: Conflicts with antivirus or anti-malware software can interfere with QuickBooks operations. Temporarily disable these programs and try opening QuickBooks again to see if the error persists.Repair QuickBooks Installation: Use the Control Panel to repair your QuickBooks installation. Navigate to Control Panel > Programs and Features, select QuickBooks from the list, and click on Repair. Follow the on-screen instructions to complete the repair process.Seek Technical Support: If you’ve exhausted all troubleshooting steps and continue to encounter Error 3371 status code 11118, consider contacting QuickBooks technical support for further assistance. They can provide personalized guidance and help you resolve the issue.
By following these troubleshooting solutions, you can effectively address QuickBooks Error 3371 status code 11118 and resume normal operation of the software without further interruption. Remember to back up your company file before making any significant changes to ensure data integrity.
Troubleshooting Solutions: QuickBooks Error 3371 status code 11118 QuickBooks Error 3371 status code 11118 often indicates a problem with the software’s license properties or damaged files. Here’s how you can troubleshoot and resolve this issue efficiently: Update QuickBooks: Ensure that you’re using the latest version of QuickBooks. Updating the software can often resolve compatibility issues and bugs that may trigger Error 3371.Run QuickBooks Install Diagnostic Tool: Intuit provides a diagnostic tool designed to identify and fix installation issues. Download and run the QuickBooks Install Diagnostic Tool to automatically detect and resolve problems with your QuickBooks installation.Recreate EntitlementDataStore.ecml File: The EntitlementDataStore.ecml file stores your QuickBooks license information. Deleting this file and re-registering QuickBooks can resolve issues related to licensing. Close QuickBooks, press Windows + R to open the Run command, type “%ProgramData%IntuitEntitlement Clientv8” (without quotes), and hit Enter. Delete the EntitlementDataStore.ecml file, restart QuickBooks, and re-register the product.Update Windows Components: Ensure that your Windows operating system and related components like Microsoft .NET Framework, MSXML, and C++ are up to date. Outdated or damaged Windows components can interfere with QuickBooks functionality and trigger Error 3371.Perform a Clean Install of QuickBooks: If the issue persists, consider performing a clean reinstall of QuickBooks. Uninstall QuickBooks from your system, rename the installation folders, reinstall QuickBooks, and then update it to the latest version.Check for Third-Party Software Conflicts: Conflicts with antivirus or anti-malware software can interfere with QuickBooks operations. Temporarily disable these programs and try opening QuickBooks again to see if the error persists.Repair QuickBooks Installation: Use the Control Panel to repair your QuickBooks installation. Navigate to Control Panel > Programs and Features, select QuickBooks from the list, and click on Repair. Follow the on-screen instructions to complete the repair process.Seek Technical Support: If you’ve exhausted all troubleshooting steps and continue to encounter Error 3371 status code 11118, consider contacting QuickBooks technical support for further assistance. They can provide personalized guidance and help you resolve the issue. By following these troubleshooting solutions, you can effectively address QuickBooks Error 3371 status code 11118 and resume normal operation of the software without further interruption. Remember to back up your company file before making any significant changes to ensure data integrity. Read More
Delta Query Performance in Azure Synapse Serverless: Issues with Response Times using Serverless SQL
We are encountering significant performance issues with Delta query execution in Azure Synapse Serverless across multiple client setups. Specifically, we utilize views built on Delta tables within Synapse Serverless to deliver data via a Synapse on-demand SQL endpoint. When end users execute queries involving simple joins at this endpoint, we observe that the response times are 7-8 times slower compared to equivalent views created over Parquet files.
Efforts to optimize have included optimizing & vacuuming the Delta tables and explicitly defining data types during view creation, which resulted in only marginal improvements. We suspect the issue might be related to Synapse utilizing an outdated version of the Delta reader.
For comparison, using a Databricks SQL Warehouse dramatically enhances the query response times. However, this approach does not support querying via SQL Server Management Studio, which is a significant limitation for our end users.
Has anyone else experienced similar performance challenges with Delta in Synapse Serverless? Any recommendations or workarounds would be greatly appreciated. Also, maintaining duplicate datasets in both Delta and Parquet formats solely to support SQL endpoints feels inefficient.
Thoughts on this?
We are encountering significant performance issues with Delta query execution in Azure Synapse Serverless across multiple client setups. Specifically, we utilize views built on Delta tables within Synapse Serverless to deliver data via a Synapse on-demand SQL endpoint. When end users execute queries involving simple joins at this endpoint, we observe that the response times are 7-8 times slower compared to equivalent views created over Parquet files.Efforts to optimize have included optimizing & vacuuming the Delta tables and explicitly defining data types during view creation, which resulted in only marginal improvements. We suspect the issue might be related to Synapse utilizing an outdated version of the Delta reader. For comparison, using a Databricks SQL Warehouse dramatically enhances the query response times. However, this approach does not support querying via SQL Server Management Studio, which is a significant limitation for our end users. Has anyone else experienced similar performance challenges with Delta in Synapse Serverless? Any recommendations or workarounds would be greatly appreciated. Also, maintaining duplicate datasets in both Delta and Parquet formats solely to support SQL endpoints feels inefficient. Thoughts on this? Read More
How to fix QuickBooks License Error after update?
Troubleshooting Solutions : QuickBooks License Error
Encountering a QuickBooks License Error can be frustrating, but several troubleshooting solutions can help resolve this issue promptly.
Check Internet Connection: Ensure your device has a stable internet connection. QuickBooks requires an active internet connection to verify the license.
Update QuickBooks: Make sure you are using the latest version of QuickBooks. Outdated software may encounter license verification issues. Update QuickBooks to the latest release to resolve compatibility issues.
Verify License Information: Double-check the license information entered during installation. Any discrepancies in the license key or registration details can trigger a license error. Verify the accuracy of the license information in the QuickBooks license dialog box.
Reactivate QuickBooks: Try reactivating QuickBooks to refresh the licensing information. Go to the Help menu, select Activate QuickBooks, and follow the prompts to reactivate the software. This process can sometimes resolve license-related errors.
Repair QuickBooks Installation: Perform a repair installation of QuickBooks to fix any corrupted files or components. Navigate to the Control Panel, select Programs and Features, locate QuickBooks in the list of installed programs, and choose the Repair option. Follow the on-screen instructions to complete the repair process.
Reset Entitlement Data: Resetting the entitlement data can resolve license-related issues in QuickBooks. Close QuickBooks and navigate to the Windows Start menu. Search for “Run” and open it. Type “C:ProgramDataIntuitEntitlement Clientv8” in the Run dialog box and press Enter. Locate the “ecml” file, right-click on it, and select Delete. Restart QuickBooks and re-register the software.
Contact QuickBooks Support: If the issue persists after trying the above steps, it’s recommended to contact QuickBooks customer support for further assistance. Provide them with detailed information about the error message and the troubleshooting steps you’ve already taken. They can offer personalized support to resolve the license error efficiently.
By following these troubleshooting solutions, you should be able to resolve the QuickBooks License Error and resume using the software without any interruptions. Remember to regularly update QuickBooks and maintain accurate license information to prevent similar issues in the future.
Troubleshooting Solutions : QuickBooks License Error Encountering a QuickBooks License Error can be frustrating, but several troubleshooting solutions can help resolve this issue promptly. Check Internet Connection: Ensure your device has a stable internet connection. QuickBooks requires an active internet connection to verify the license.Update QuickBooks: Make sure you are using the latest version of QuickBooks. Outdated software may encounter license verification issues. Update QuickBooks to the latest release to resolve compatibility issues.Verify License Information: Double-check the license information entered during installation. Any discrepancies in the license key or registration details can trigger a license error. Verify the accuracy of the license information in the QuickBooks license dialog box.Reactivate QuickBooks: Try reactivating QuickBooks to refresh the licensing information. Go to the Help menu, select Activate QuickBooks, and follow the prompts to reactivate the software. This process can sometimes resolve license-related errors.Repair QuickBooks Installation: Perform a repair installation of QuickBooks to fix any corrupted files or components. Navigate to the Control Panel, select Programs and Features, locate QuickBooks in the list of installed programs, and choose the Repair option. Follow the on-screen instructions to complete the repair process.Reset Entitlement Data: Resetting the entitlement data can resolve license-related issues in QuickBooks. Close QuickBooks and navigate to the Windows Start menu. Search for “Run” and open it. Type “C:ProgramDataIntuitEntitlement Clientv8” in the Run dialog box and press Enter. Locate the “ecml” file, right-click on it, and select Delete. Restart QuickBooks and re-register the software.Contact QuickBooks Support: If the issue persists after trying the above steps, it’s recommended to contact QuickBooks customer support for further assistance. Provide them with detailed information about the error message and the troubleshooting steps you’ve already taken. They can offer personalized support to resolve the license error efficiently.By following these troubleshooting solutions, you should be able to resolve the QuickBooks License Error and resume using the software without any interruptions. Remember to regularly update QuickBooks and maintain accurate license information to prevent similar issues in the future. Read More
Recover activities from To do
Hi, yesterday I have deleted activities from my To do but now I need to recover them.
I have tried a restore following the instructions provided at this link
Creare, modificare, eliminare e ripristinare le attività – Supporto tecnico Microsoft
but the elements I have deleted are not present in the folder Deleted Mail (Posta Eliminata in italian).
I hope something can be found in the trash but I don’t know how to do.
Anyone can help?
Thanks
Alex
Hi, yesterday I have deleted activities from my To do but now I need to recover them.I have tried a restore following the instructions provided at this linkCreare, modificare, eliminare e ripristinare le attività – Supporto tecnico Microsoftbut the elements I have deleted are not present in the folder Deleted Mail (Posta Eliminata in italian).I hope something can be found in the trash but I don’t know how to do.Anyone can help?ThanksAlex Read More
How do I fix a QuickBooks Registration Error after update?
Troubleshooting Solutions : QuickBooks Registration Error
Encountering a QuickBooks Registration Error can be frustrating, but there are several troubleshooting steps you can take to resolve this issue and get back to using your software smoothly. Here are some potential solutions to try:
Check Internet Connection: Ensure that your computer has a stable internet connection. QuickBooks requires an active internet connection for registration. If your connection is unstable or not working, try restarting your router or connecting to a different network.
Update QuickBooks: Make sure you’re using the latest version of QuickBooks. Outdated software can sometimes encounter registration errors due to compatibility issues or bugs. Update QuickBooks to the latest version available, which may include fixes for registration-related issues.
Verify System Date and Time: Incorrect system date and time settings can sometimes interfere with QuickBooks registration. Verify that your computer’s date and time settings are accurate. If they’re incorrect, adjust them to the current date and time and then try registering QuickBooks again.
Disable Firewall and Antivirus: Sometimes, firewall or antivirus software installed on your computer can block QuickBooks from connecting to the registration servers. Temporarily disable any firewall or antivirus software and attempt to register QuickBooks again. Remember to re-enable them once the registration process is complete.
Run QuickBooks Tool Hub: QuickBooks Tool Hub is a collection of tools designed to troubleshoot various QuickBooks issues, including registration errors. Download and install the QuickBooks Tool Hub from the official Intuit website. Once installed, open the tool and navigate to the “Installation Issues” tab. Run the “QuickBooks Install Diagnostic Tool” to scan and repair any installation-related issues that may be causing the registration error.
Manually Register QuickBooks: If the automatic registration process fails, you can try registering QuickBooks manually. Visit the QuickBooks registration page on the official Intuit website and follow the instructions to manually enter your license and product information. Make sure to double-check the information you enter to avoid any typos or mistakes.
Contact QuickBooks Support: If you’ve tried all the above solutions and are still unable to resolve the registration error, it’s time to reach out to QuickBooks customer support for further assistance. They have dedicated professionals who can provide personalized help and guide you through the troubleshooting process.
By following these troubleshooting solutions, you should be able to resolve the QuickBooks Registration Error and regain access to your QuickBooks software without any further hindrance. If you encounter any difficulties along the way, don’t hesitate to seek assistance from QuickBooks support or consult online forums for additional guidance.
Troubleshooting Solutions : QuickBooks Registration Error Encountering a QuickBooks Registration Error can be frustrating, but there are several troubleshooting steps you can take to resolve this issue and get back to using your software smoothly. Here are some potential solutions to try: Check Internet Connection: Ensure that your computer has a stable internet connection. QuickBooks requires an active internet connection for registration. If your connection is unstable or not working, try restarting your router or connecting to a different network.Update QuickBooks: Make sure you’re using the latest version of QuickBooks. Outdated software can sometimes encounter registration errors due to compatibility issues or bugs. Update QuickBooks to the latest version available, which may include fixes for registration-related issues.Verify System Date and Time: Incorrect system date and time settings can sometimes interfere with QuickBooks registration. Verify that your computer’s date and time settings are accurate. If they’re incorrect, adjust them to the current date and time and then try registering QuickBooks again.Disable Firewall and Antivirus: Sometimes, firewall or antivirus software installed on your computer can block QuickBooks from connecting to the registration servers. Temporarily disable any firewall or antivirus software and attempt to register QuickBooks again. Remember to re-enable them once the registration process is complete.Run QuickBooks Tool Hub: QuickBooks Tool Hub is a collection of tools designed to troubleshoot various QuickBooks issues, including registration errors. Download and install the QuickBooks Tool Hub from the official Intuit website. Once installed, open the tool and navigate to the “Installation Issues” tab. Run the “QuickBooks Install Diagnostic Tool” to scan and repair any installation-related issues that may be causing the registration error.Manually Register QuickBooks: If the automatic registration process fails, you can try registering QuickBooks manually. Visit the QuickBooks registration page on the official Intuit website and follow the instructions to manually enter your license and product information. Make sure to double-check the information you enter to avoid any typos or mistakes.Contact QuickBooks Support: If you’ve tried all the above solutions and are still unable to resolve the registration error, it’s time to reach out to QuickBooks customer support for further assistance. They have dedicated professionals who can provide personalized help and guide you through the troubleshooting process.By following these troubleshooting solutions, you should be able to resolve the QuickBooks Registration Error and regain access to your QuickBooks software without any further hindrance. If you encounter any difficulties along the way, don’t hesitate to seek assistance from QuickBooks support or consult online forums for additional guidance. Read More
I can’t change the profile picture of my account
When I am trying to do that, an error pops up and says “Account Picture Error. This picture couldn’t be saved.”
Error code: 0x80070520
When I am trying to do that, an error pops up and says “Account Picture Error. This picture couldn’t be saved.” Error code: 0x80070520 Read More
Bookings Buffer Time – details noted within calendar appointment
We have a huge list of ‘Services’ in our company Bookings profile, where we use the links to send to clients to book appointments. We include buffer time for most of these services.
In the past, I’m pretty sure (though don’t quote me) that when an appointment was booked by a client, it would go into my colleagues calendar and within the notes section of the appointment it would always show the buffer time as per the example below:
Buffer time:
——————–
Before: 90min (10:15).
Time with customer: 11:45–13:45
After: 90min (15:15)
Time zone:(UTC+00:00) Dublin, Edinburgh, Lisbon, London
However, now, loads of the appointments being booked don’t detail the buffer time in my colleagues calendar appointments! Some do, some don’t.
For example, something could be booked for 9-9.30am by a client with 15 minutes buffer either side. It will go into my colleagues calendar as 8.45-9.45am, but the calendar appointment will not show any details of buffer time vs actual time with customer. So he thinks the call is starting at 8.45am, not 9am.
I’ve played around with settings but I cannot find the answer.
Please help!
We have a huge list of ‘Services’ in our company Bookings profile, where we use the links to send to clients to book appointments. We include buffer time for most of these services. In the past, I’m pretty sure (though don’t quote me) that when an appointment was booked by a client, it would go into my colleagues calendar and within the notes section of the appointment it would always show the buffer time as per the example below: Buffer time:——————–Before: 90min (10:15).Time with customer: 11:45–13:45After: 90min (15:15)Time zone:(UTC+00:00) Dublin, Edinburgh, Lisbon, LondonHowever, now, loads of the appointments being booked don’t detail the buffer time in my colleagues calendar appointments! Some do, some don’t. For example, something could be booked for 9-9.30am by a client with 15 minutes buffer either side. It will go into my colleagues calendar as 8.45-9.45am, but the calendar appointment will not show any details of buffer time vs actual time with customer. So he thinks the call is starting at 8.45am, not 9am. I’ve played around with settings but I cannot find the answer. Please help! Read More
Mobile device user accounts – Device or Human Worker
Scenario:
A client has several third party warehouses that will be added as a Supply Chain user with Microsoft Entra ID and an employee record. This follows the human worker approach as per the documentation below:
Mobile device user accounts – Supply Chain Management | Dynamics 365 | Microsoft Learn
Question:
If the third party warehouse is setup as a human worker, are we correct that a device license is not required? Only the SCM license?
Scenario:A client has several third party warehouses that will be added as a Supply Chain user with Microsoft Entra ID and an employee record. This follows the human worker approach as per the documentation below: Mobile device user accounts – Supply Chain Management | Dynamics 365 | Microsoft Learn Question:If the third party warehouse is setup as a human worker, are we correct that a device license is not required? Only the SCM license? Read More
Learn Azure Together in Microsoft Learn Learning Room
In the summer of 2023, Microsoft Learn introduced the Microsoft Learn Learning Room, a new addition that allows community members worldwide to interact online and learn about technology. The Learning Room is part of the Microsoft Learn Community, and each Learning Room is managed by Microsoft Learn experts. It serves as an online community where users can connect with experts to gain deeper insight into Microsoft products and services.
One of the Microsoft Learn experts is Hamid Sadeghpour Saleh, an Azure MVP from Azerbaijan, who is also a Microsoft MVP. He manages the Learning Room alongside fellow Microsoft Learn experts Saeid Dahl and Mohsen Akhavan. We spoke with Hamid about the significance of participating in the Microsoft Zero to Hero Community Learning Room. Whether you are already a member of the Learning Room or have yet to join, we invite you to read this article and explore the new learning opportunities that this community offers.
———-
Introduction of Microsoft Zero to Hero Community
Microsoft Zero to Hero Community is a Learning Room on Microsoft Learn and We’re here to cover all the aspects of Microsoft Cloud Services from Azure to Microsoft AI and Data – following our room title “Zero to Hero” We’re here together to grow as passionate Microsoft Cloud experts.
Who are the members in the Microsoft Zero to Hero Community?
We have a variety of members in the Learning Room, from students, learners, new starters to experienced professionals, MVPs, RDs and Microsoft FTEs who contribute all together with AMA sessions, Q/A, blogging, weekly and monthly sessions to all share together and that is the main idea of the Learning Room.
What topics are discussed in the Microsoft Zero to Hero Community?
Since we are covering Microsoft Cloud Technologies in general, we host sessions from Microsoft Azure services to Microsoft AI, Data, Security etc. as well as all of the activities and channels we have are Technology focused on different ways and areas and that helps us and learners to land on their favorite learning path and get specialized and certified.
How do you support the skill development of members?
As an MVP and learning room owner, I support the skill development of members by facilitating interactive discussions, organizing workshops, sharing resources, and providing mentorship. I create a supportive environment where members can learn from each other’s expertise, collaborate on projects, and stay updated on the latest technologies and best practices. Additionally, I offer personalized guidance and feedback to help members overcome challenges and achieve their learning goals.
Invitation for those who are interested in participating in your Learning Room
Join Microsoft Zero to Hero Learning Room!
Unlock endless opportunities for growth and collaboration. Engage in interactive discussions, attend workshops, and access resources curated for your success. Let’s learn and excel together!
Resources for learners who want to join
– Link to join to the Learning Room: https://aka.ms/JoinZerotoHero
– Learning Room LinkedIn: https://www.linkedin.com/company/azure-zero-to-hero/
– Learning Room YouTube Channel: https://www.youtube.com/@azurezerotohero
———-
For more insights into Azure skills development as discussed by Hamid, please refer to the article on the Microsoft Learn Blog: Discover Microsoft Azure learning, training, certifications, and career path opportunities – Microsoft Community Hub
In addition to the Microsoft Zero to Hero Community featured in this article, the Microsoft Learn Learning Room operates various Learning Rooms for different products, services, and languages. We encourage you to explore the Microsoft Learn – Learning Rooms Directory, find a Learning Room that matches your interests, connect with new peers, and deepen your technical knowledge as a part of this learning community.
Microsoft Tech Community – Latest Blogs –Read More
Add a signature field and restrict editing
Hi,
We’re looking for a way to add a signature box where a user can draw or sign while the document is restricted. The user should be able to sign using Word Online, Desktop App, Tablet and Mobile. Please let us know the best way to achieve this.
Hi, We’re looking for a way to add a signature box where a user can draw or sign while the document is restricted. The user should be able to sign using Word Online, Desktop App, Tablet and Mobile. Please let us know the best way to achieve this. Read More
How fix QuickBooks desktop 2023 running slow?
Troubleshooting Solutions : QuickBooks desktop 2023 running slow
Slow performance in QuickBooks desktop 2023 running slow can be frustrating, but several factors and solutions can address this issue and improve system responsiveness:
Check System Requirements: Ensure that your computer meets the minimum system requirements for running QuickBooks Desktop 2023. Inadequate hardware, such as insufficient RAM or an outdated processor, can contribute to sluggish performance.
Update QuickBooks: Make sure you are using the latest version of QuickBooks Desktop 2023. Intuit frequently releases updates that include performance improvements, bug fixes, and optimizations. Check for updates within QuickBooks and install any available updates.
Reduce Company File Size: Large company files can slow down QuickBooks performance. Consider condensing your company file or archiving old data to reduce its size. You can also remove unnecessary lists, such as customers or vendors, to streamline the file.
Optimize Data File: Use the built-in QuickBooks tools to optimize your data file. This process reorganizes data within the file, improving its performance. Go to the “File” menu, select “Utilities,” and then choose “Optimize Data File.” Follow the prompts to complete the optimization.
Limit Background Processes: Close any unnecessary programs and background processes running on your computer while using QuickBooks. Other applications consuming system resources can impact QuickBooks performance. Additionally, avoid running resource-intensive tasks simultaneously with QuickBooks.
Adjust Preferences and Settings: Review QuickBooks preferences and settings to optimize performance. Disable features or options that you don’t use frequently, such as automatic updates or reminders. Customizing preferences can reduce unnecessary processing overhead.
Rebuild Data: Rebuilding data can resolve issues with data integrity and improve QuickBooks performance. To rebuild data, go to the “File” menu, select “Utilities,” and then choose “Rebuild Data.” Follow the on-screen instructions to complete the rebuilding process.
Check for Network Issues: If QuickBooks is installed in a network environment, network issues can contribute to slow performance. Check network connectivity, router settings, and network congestion. Consider consulting with a network technician to optimize network performance.
Upgrade Hardware: If your computer hardware is outdated or insufficient for running QuickBooks Desktop 2023, consider upgrading components such as RAM, CPU, or storage. A faster and more capable hardware configuration can significantly improve QuickBooks performance.
Run QuickBooks Diagnostic Tool: Utilize the QuickBooks Diagnostic Tool to identify and resolve potential issues with QuickBooks Desktop 2023. This tool can diagnose and fix various performance-related problems, including database issues and network connectivity issues.
Contact QuickBooks Support: If the performance issues persist despite trying the above solutions, consider contacting QuickBooks support for further assistance. QuickBooks support representatives can provide personalized troubleshooting guidance and help resolve complex performance issues.
By implementing these troubleshooting solutions, you can address slow performance in QuickBooks desktop 2023 running slow and restore efficient operation, enhancing productivity for your business.
Troubleshooting Solutions : QuickBooks desktop 2023 running slow Slow performance in QuickBooks desktop 2023 running slow can be frustrating, but several factors and solutions can address this issue and improve system responsiveness: Check System Requirements: Ensure that your computer meets the minimum system requirements for running QuickBooks Desktop 2023. Inadequate hardware, such as insufficient RAM or an outdated processor, can contribute to sluggish performance.Update QuickBooks: Make sure you are using the latest version of QuickBooks Desktop 2023. Intuit frequently releases updates that include performance improvements, bug fixes, and optimizations. Check for updates within QuickBooks and install any available updates.Reduce Company File Size: Large company files can slow down QuickBooks performance. Consider condensing your company file or archiving old data to reduce its size. You can also remove unnecessary lists, such as customers or vendors, to streamline the file.Optimize Data File: Use the built-in QuickBooks tools to optimize your data file. This process reorganizes data within the file, improving its performance. Go to the “File” menu, select “Utilities,” and then choose “Optimize Data File.” Follow the prompts to complete the optimization.Limit Background Processes: Close any unnecessary programs and background processes running on your computer while using QuickBooks. Other applications consuming system resources can impact QuickBooks performance. Additionally, avoid running resource-intensive tasks simultaneously with QuickBooks.Adjust Preferences and Settings: Review QuickBooks preferences and settings to optimize performance. Disable features or options that you don’t use frequently, such as automatic updates or reminders. Customizing preferences can reduce unnecessary processing overhead.Rebuild Data: Rebuilding data can resolve issues with data integrity and improve QuickBooks performance. To rebuild data, go to the “File” menu, select “Utilities,” and then choose “Rebuild Data.” Follow the on-screen instructions to complete the rebuilding process.Check for Network Issues: If QuickBooks is installed in a network environment, network issues can contribute to slow performance. Check network connectivity, router settings, and network congestion. Consider consulting with a network technician to optimize network performance.Upgrade Hardware: If your computer hardware is outdated or insufficient for running QuickBooks Desktop 2023, consider upgrading components such as RAM, CPU, or storage. A faster and more capable hardware configuration can significantly improve QuickBooks performance.Run QuickBooks Diagnostic Tool: Utilize the QuickBooks Diagnostic Tool to identify and resolve potential issues with QuickBooks Desktop 2023. This tool can diagnose and fix various performance-related problems, including database issues and network connectivity issues.Contact QuickBooks Support: If the performance issues persist despite trying the above solutions, consider contacting QuickBooks support for further assistance. QuickBooks support representatives can provide personalized troubleshooting guidance and help resolve complex performance issues.By implementing these troubleshooting solutions, you can address slow performance in QuickBooks desktop 2023 running slow and restore efficient operation, enhancing productivity for your business. Read More
KQL query for non-matching entries
Hi,
I am trying to write a query to find out the devices that does not have MDE installed by comparing it with those devices found in CommonSecurity Table. The actual no. of devices is approx. 50, however I want to write a query to do this
When tried leftanti/leftantisemi the no. of devices it shows in the result is incorrect. (approx. 1000)
let mde_devices= materialize (
DeviceInfo
| where TimeGenerated >= ago(7d)
| where OSPlatform !has ‘server’
| summarize arg_max(TimeGenerated, PublicIP, LoggedOnUsers) by DeviceName
| parse-kv LoggedOnUsers as ( [‘UserName’]:string) with ( pair_delimiter=”,”, kv_delimiter=”:”, quote='”‘)
| where isnotempty(UserName)
| extend HostName = toupper(trim_end(char_trim,DeviceName))
| distinct HostName
);
let zscaler_devices = (
CommonSecurityLog
| where TimeGenerated >= ago(7d)
| where DeviceProduct == ‘NSSWeblog’
| where AdditionalExtensions !in~ (mde_devices)
| parse AdditionalExtensions with * ‘SourceTranslatedAddress=’ IPAddress ‘;UserAgent=’ * ‘;User=’ UserName_CS ‘;Department=’ * ‘DeviceHostname=’ Hostname_CS ‘;DeviceModel=’ *
| summarize arg_max(TimeGenerated,UserName_CS, IPAddress) by Hostname_CS
| distinct Hostname_CS
| extend HostName = tolower(Hostname_CS)
| project-away Hostname_CS);
zscaler_devices
//| where HostName in (mde_devices)
| join kind=leftanti mde_devices on HostName// == $right.HostName
So, I switched to using not() (refer line 14) and it is the closest match it’s output still shows devices that has MDE. It lists 80 devices as the output and the extra 30 its showing is having MDE
let mde_devices= materialize (
DeviceInfo
| where TimeGenerated >= ago(7d)
| where OSPlatform !has ‘server’
| summarize arg_max(TimeGenerated, PublicIP, LoggedOnUsers) by DeviceName
| parse-kv LoggedOnUsers as ( [‘UserName’]:string) with ( pair_delimiter=”,”, kv_delimiter=”:”, quote='”‘)
| where isnotempty(UserName)
| extend HostName = toupper(trim_end(char_trim,DeviceName))
| distinct HostName
);
CommonSecurityLog
| where TimeGenerated >= ago(7d)
| where DeviceProduct == ‘NSSWeblog’
| where not(AdditionalExtensions has_any (mde_devices))
| parse AdditionalExtensions with * ‘SourceTranslatedAddress=’ IPAddress ‘;UserAgent=’ * ‘;User=’ UserName_CS ‘;Department=’ * ‘DeviceHostname=’ Hostname_CS ‘;DeviceModel=’ *
| summarize arg_max(TimeGenerated,UserName_CS, IPAddress) by Hostname_CS
| extend HostName = tolower(Hostname_CS)
| project-away Hostname_CS
My question here are:
1. Although anti/semianti is supposed to give me the intended results, what is wrong with my query ?
2. While using the not() operator, what additional step I should carry out to make sure my results do not consist of devices having MDE ?
Hi, I am trying to write a query to find out the devices that does not have MDE installed by comparing it with those devices found in CommonSecurity Table. The actual no. of devices is approx. 50, however I want to write a query to do this When tried leftanti/leftantisemi the no. of devices it shows in the result is incorrect. (approx. 1000) let mde_devices= materialize (
DeviceInfo
| where TimeGenerated >= ago(7d)
| where OSPlatform !has ‘server’
| summarize arg_max(TimeGenerated, PublicIP, LoggedOnUsers) by DeviceName
| parse-kv LoggedOnUsers as ( [‘UserName’]:string) with ( pair_delimiter=”,”, kv_delimiter=”:”, quote='”‘)
| where isnotempty(UserName)
| extend HostName = toupper(trim_end(char_trim,DeviceName))
| distinct HostName
);
let zscaler_devices = (
CommonSecurityLog
| where TimeGenerated >= ago(7d)
| where DeviceProduct == ‘NSSWeblog’
| where AdditionalExtensions !in~ (mde_devices)
| parse AdditionalExtensions with * ‘SourceTranslatedAddress=’ IPAddress ‘;UserAgent=’ * ‘;User=’ UserName_CS ‘;Department=’ * ‘DeviceHostname=’ Hostname_CS ‘;DeviceModel=’ *
| summarize arg_max(TimeGenerated,UserName_CS, IPAddress) by Hostname_CS
| distinct Hostname_CS
| extend HostName = tolower(Hostname_CS)
| project-away Hostname_CS);
zscaler_devices
//| where HostName in (mde_devices)
| join kind=leftanti mde_devices on HostName// == $right.HostName So, I switched to using not() (refer line 14) and it is the closest match it’s output still shows devices that has MDE. It lists 80 devices as the output and the extra 30 its showing is having MDE let mde_devices= materialize (
DeviceInfo
| where TimeGenerated >= ago(7d)
| where OSPlatform !has ‘server’
| summarize arg_max(TimeGenerated, PublicIP, LoggedOnUsers) by DeviceName
| parse-kv LoggedOnUsers as ( [‘UserName’]:string) with ( pair_delimiter=”,”, kv_delimiter=”:”, quote='”‘)
| where isnotempty(UserName)
| extend HostName = toupper(trim_end(char_trim,DeviceName))
| distinct HostName
);
CommonSecurityLog
| where TimeGenerated >= ago(7d)
| where DeviceProduct == ‘NSSWeblog’
| where not(AdditionalExtensions has_any (mde_devices))
| parse AdditionalExtensions with * ‘SourceTranslatedAddress=’ IPAddress ‘;UserAgent=’ * ‘;User=’ UserName_CS ‘;Department=’ * ‘DeviceHostname=’ Hostname_CS ‘;DeviceModel=’ *
| summarize arg_max(TimeGenerated,UserName_CS, IPAddress) by Hostname_CS
| extend HostName = tolower(Hostname_CS)
| project-away Hostname_CS My question here are:1. Although anti/semianti is supposed to give me the intended results, what is wrong with my query ?2. While using the not() operator, what additional step I should carry out to make sure my results do not consist of devices having MDE ? Read More
How to fix QuickBooks desktop 2024 running slow?
Troubleshooting Solutions : QuickBooks desktop 2024 running slow
Slow performance in QuickBooks desktop 2024 running slow can stem from various factors, including system issues, company file size, network problems, or software conflicts. Here’s a comprehensive guide to troubleshoot and resolve this frustrating issue:
Check System Requirements: Ensure your computer meets QuickBooks Desktop 2024’s minimum system requirements. Inadequate hardware can significantly impact performance. Verify that your processor, RAM, and disk space meet the recommended specifications.
Update QuickBooks Desktop: Make sure you’re using the latest version of QuickBooks Desktop 2024. Intuit frequently releases updates that include performance enhancements and bug fixes. Go to the Help menu and select “Update QuickBooks” to download and install any available updates.
Optimize Company File: Over time, your QuickBooks company file can become bloated, leading to sluggish performance. Use the built-in utilities like Condense Data or Clean Up Company Data to remove outdated transactions and reduce file size. Make sure to create a backup before performing these actions.
Rebuild Data: Run the Rebuild Data utility to resolve data integrity issues within your company file. This process can identify and fix errors that might be contributing to the slowdown. To do this, go to the File menu, select Utilities, and then Rebuild Data.
Check for Network Issues: Slow network connectivity can affect QuickBooks performance, especially in multi-user environments. Verify that your network connection is stable and that all network devices are functioning correctly. Consider upgrading your network infrastructure if necessary.
Disable Background Applications: Other software running in the background can consume system resources and impact QuickBooks performance. Close unnecessary applications and disable startup programs to free up resources for QuickBooks.
Increase Performance Preferences: Adjust QuickBooks performance preferences to optimize speed. Go to the Edit menu, select Preferences, then click on Desktop View. Increase the number of rows to display in lists and decrease the number of company file backups to conserve system resources.
Run QuickBooks File Doctor: Utilize the QuickBooks File Doctor tool to diagnose and repair common file-related issues that may be causing slowdowns. This tool can identify network connectivity problems, data corruption, and other issues impacting performance.
Consider Hosting: If you’re experiencing performance issues in a multi-user environment, consider hosting your QuickBooks company file on a dedicated server or using Intuit’s QuickBooks hosting service. This can improve performance by offloading processing tasks to a more powerful server.
Contact QuickBooks Support: If the problem persists after trying these solutions, contact QuickBooks support for further assistance. They can provide personalized troubleshooting and guidance to resolve the issue.
By following these troubleshooting steps, you can effectively address the slowdown issue in QuickBooks desktop 2024 running slow and regain optimal performance for your accounting tasks.
Troubleshooting Solutions : QuickBooks desktop 2024 running slow Slow performance in QuickBooks desktop 2024 running slow can stem from various factors, including system issues, company file size, network problems, or software conflicts. Here’s a comprehensive guide to troubleshoot and resolve this frustrating issue: Check System Requirements: Ensure your computer meets QuickBooks Desktop 2024’s minimum system requirements. Inadequate hardware can significantly impact performance. Verify that your processor, RAM, and disk space meet the recommended specifications.Update QuickBooks Desktop: Make sure you’re using the latest version of QuickBooks Desktop 2024. Intuit frequently releases updates that include performance enhancements and bug fixes. Go to the Help menu and select “Update QuickBooks” to download and install any available updates.Optimize Company File: Over time, your QuickBooks company file can become bloated, leading to sluggish performance. Use the built-in utilities like Condense Data or Clean Up Company Data to remove outdated transactions and reduce file size. Make sure to create a backup before performing these actions.Rebuild Data: Run the Rebuild Data utility to resolve data integrity issues within your company file. This process can identify and fix errors that might be contributing to the slowdown. To do this, go to the File menu, select Utilities, and then Rebuild Data.Check for Network Issues: Slow network connectivity can affect QuickBooks performance, especially in multi-user environments. Verify that your network connection is stable and that all network devices are functioning correctly. Consider upgrading your network infrastructure if necessary.Disable Background Applications: Other software running in the background can consume system resources and impact QuickBooks performance. Close unnecessary applications and disable startup programs to free up resources for QuickBooks.Increase Performance Preferences: Adjust QuickBooks performance preferences to optimize speed. Go to the Edit menu, select Preferences, then click on Desktop View. Increase the number of rows to display in lists and decrease the number of company file backups to conserve system resources.Run QuickBooks File Doctor: Utilize the QuickBooks File Doctor tool to diagnose and repair common file-related issues that may be causing slowdowns. This tool can identify network connectivity problems, data corruption, and other issues impacting performance.Consider Hosting: If you’re experiencing performance issues in a multi-user environment, consider hosting your QuickBooks company file on a dedicated server or using Intuit’s QuickBooks hosting service. This can improve performance by offloading processing tasks to a more powerful server.Contact QuickBooks Support: If the problem persists after trying these solutions, contact QuickBooks support for further assistance. They can provide personalized troubleshooting and guidance to resolve the issue.By following these troubleshooting steps, you can effectively address the slowdown issue in QuickBooks desktop 2024 running slow and regain optimal performance for your accounting tasks. Read More
Searching text in Excel with CoPilot
I’m trying to get CoPilot to search thru a text column in a table and pull out certain data to another column, but I’m not succeeding. Instead it searches and replaces text. I’m trying prompts like “Search A column and copy text similar to “Sold 8 of product X” into C column. Any hints?
I’m trying to get CoPilot to search thru a text column in a table and pull out certain data to another column, but I’m not succeeding. Instead it searches and replaces text. I’m trying prompts like “Search A column and copy text similar to “Sold 8 of product X” into C column. Any hints? Read More