Tag Archives: microsoft
What to do When QuickBooks Direct Deposit Not Working after update?
Troubleshooting Solutions: QuickBooks Direct Deposit not working
Direct deposit issues in QuickBooks can be frustrating, but there are several troubleshooting steps you can take to resolve them. Here’s a comprehensive guide to help you identify and fix the problem:
Check Bank Account Information: Ensure that the bank account information entered in QuickBooks is accurate. Even a small typo can cause direct deposit failures. Verify the account number, routing number, and account type.Confirm Payroll Subscription: Verify that your QuickBooks subscription includes payroll services. If your subscription has expired or does not include payroll, you won’t be able to process direct deposits.Review Payroll Setup: Double-check your payroll settings in QuickBooks. Ensure that direct deposit is enabled for the affected employees and that their bank account information is correctly entered.Check Payroll Processing Date: Direct deposit payments must be submitted to Intuit before 5:00 PM (PT) two banking days before the paycheck date. If you miss this deadline, payments may not process on time.Verify Employee Information: Ensure that each affected employee’s information, including their name, address, Social Security number, and bank account details, is accurate and up to date in QuickBooks.Review Payment Amounts: Make sure the payment amounts entered in QuickBooks match the amounts you intend to deposit into your employees’ accounts. Discrepancies can lead to payment failures.Check for Payroll Updates: Ensure that your QuickBooks software is up to date with the latest payroll updates. Outdated software may encounter compatibility issues with direct deposit processing.Check Bank Account Status: Verify the status of your business bank account. If the account is closed, frozen, or experiencing any issues, direct deposit transactions may fail.Contact QuickBooks Support: If you’ve exhausted all troubleshooting steps and are still experiencing issues, reach out to QuickBooks customer support for assistance. They can provide further guidance and help resolve the issue.Resend Direct Deposits: In QuickBooks, you have the option to resend direct deposits that have failed. Navigate to the paycheck list, locate the failed direct deposit, and choose the option to resend it.Monitor Error Messages: Pay attention to any error messages or notifications you receive when processing direct deposits. These messages can provide valuable clues about the root cause of the issue.Consider Alternative Payment Methods: If you’re unable to resolve the direct deposit issue promptly, consider using alternative payment methods, such as paper checks, to ensure your employees receive their wages on time.
By following these troubleshooting steps, you should be able to identify and resolve the issue with QuickBooks direct deposit not working. If you continue to experience problems, don’t hesitate to seek assistance from QuickBooks support or consult with a financial professional for further guidance.
Troubleshooting Solutions: QuickBooks Direct Deposit not working Direct deposit issues in QuickBooks can be frustrating, but there are several troubleshooting steps you can take to resolve them. Here’s a comprehensive guide to help you identify and fix the problem: Check Bank Account Information: Ensure that the bank account information entered in QuickBooks is accurate. Even a small typo can cause direct deposit failures. Verify the account number, routing number, and account type.Confirm Payroll Subscription: Verify that your QuickBooks subscription includes payroll services. If your subscription has expired or does not include payroll, you won’t be able to process direct deposits.Review Payroll Setup: Double-check your payroll settings in QuickBooks. Ensure that direct deposit is enabled for the affected employees and that their bank account information is correctly entered.Check Payroll Processing Date: Direct deposit payments must be submitted to Intuit before 5:00 PM (PT) two banking days before the paycheck date. If you miss this deadline, payments may not process on time.Verify Employee Information: Ensure that each affected employee’s information, including their name, address, Social Security number, and bank account details, is accurate and up to date in QuickBooks.Review Payment Amounts: Make sure the payment amounts entered in QuickBooks match the amounts you intend to deposit into your employees’ accounts. Discrepancies can lead to payment failures.Check for Payroll Updates: Ensure that your QuickBooks software is up to date with the latest payroll updates. Outdated software may encounter compatibility issues with direct deposit processing.Check Bank Account Status: Verify the status of your business bank account. If the account is closed, frozen, or experiencing any issues, direct deposit transactions may fail.Contact QuickBooks Support: If you’ve exhausted all troubleshooting steps and are still experiencing issues, reach out to QuickBooks customer support for assistance. They can provide further guidance and help resolve the issue.Resend Direct Deposits: In QuickBooks, you have the option to resend direct deposits that have failed. Navigate to the paycheck list, locate the failed direct deposit, and choose the option to resend it.Monitor Error Messages: Pay attention to any error messages or notifications you receive when processing direct deposits. These messages can provide valuable clues about the root cause of the issue.Consider Alternative Payment Methods: If you’re unable to resolve the direct deposit issue promptly, consider using alternative payment methods, such as paper checks, to ensure your employees receive their wages on time.By following these troubleshooting steps, you should be able to identify and resolve the issue with QuickBooks direct deposit not working. If you continue to experience problems, don’t hesitate to seek assistance from QuickBooks support or consult with a financial professional for further guidance. Read More
What should I do if QuickBooks Desktop Error code 6190 and 816?
Troubleshooting Solutions: QuickBooks Desktop Error code 6190 and 816
QuickBooks Desktop Error code 6190 and 816 typically occur when there is a mismatch between the company file and the transaction log file. This can happen due to various reasons, such as network issues, multiple users accessing the company file simultaneously, or the company file being stored in a read-only network folder. However, resolving this issue involves several troubleshooting steps:
Check for Single-User Mode: Ensure that no other user is accessing the company file in multi-user mode. If any user is currently logged in, ask them to log out. Then try opening the file again to see if the error persists.Rename .ND and .TLG Files: Locate the folder containing the company file and look for files with the same name as your company file but with extensions .ND and .TLG. Rename these files by adding “.old” at the end of each file name. This action forces QuickBooks to create new .ND and .TLG files when you open the company file next time.Use QuickBooks File Doctor: Intuit provides a tool called QuickBooks File Doctor, which is designed to diagnose and repair various QuickBooks-related issues, including Error code 6190 and 816. Download and run this tool, following the on-screen instructions to scan and fix any detected issues with your company file.Copy Company File to Desktop: Copy the company file from its current location to the desktop. Then, try to open it directly from the desktop. If the file opens without any error, it indicates that the issue may be related to the folder location or file path.Update QuickBooks: Ensure that your QuickBooks Desktop software is up to date. Intuit regularly releases updates and patches to fix known issues and improve the stability of the software. Check for updates within QuickBooks and install any available updates.Recreate Damaged Transaction Log File: If the issue persists, you may need to recreate the transaction log file. To do this, open the folder containing your company file and locate the transaction log file (.TLG). Delete this file and then try opening the company file again. QuickBooks will recreate the transaction log file automatically.Check for Hosting Settings: If you are using QuickBooks in a multi-user environment, ensure that hosting settings are correctly configured. The hosting should be enabled only on the server computer and disabled on workstations. To check hosting settings, go to the File menu within QuickBooks and select Utilities > Stop Hosting Multi-User Access on workstations.
By following these troubleshooting solutions, you should be able to resolve QuickBooks Desktop Error code 6190 and 816 and regain access to your company file without any further issues. If the problem persists after trying these solutions, consider reaching out to QuickBooks support for further assistance and guidance tailored to your specific situation.
Troubleshooting Solutions: QuickBooks Desktop Error code 6190 and 816QuickBooks Desktop Error code 6190 and 816 typically occur when there is a mismatch between the company file and the transaction log file. This can happen due to various reasons, such as network issues, multiple users accessing the company file simultaneously, or the company file being stored in a read-only network folder. However, resolving this issue involves several troubleshooting steps:Check for Single-User Mode: Ensure that no other user is accessing the company file in multi-user mode. If any user is currently logged in, ask them to log out. Then try opening the file again to see if the error persists.Rename .ND and .TLG Files: Locate the folder containing the company file and look for files with the same name as your company file but with extensions .ND and .TLG. Rename these files by adding “.old” at the end of each file name. This action forces QuickBooks to create new .ND and .TLG files when you open the company file next time.Use QuickBooks File Doctor: Intuit provides a tool called QuickBooks File Doctor, which is designed to diagnose and repair various QuickBooks-related issues, including Error code 6190 and 816. Download and run this tool, following the on-screen instructions to scan and fix any detected issues with your company file.Copy Company File to Desktop: Copy the company file from its current location to the desktop. Then, try to open it directly from the desktop. If the file opens without any error, it indicates that the issue may be related to the folder location or file path.Update QuickBooks: Ensure that your QuickBooks Desktop software is up to date. Intuit regularly releases updates and patches to fix known issues and improve the stability of the software. Check for updates within QuickBooks and install any available updates.Recreate Damaged Transaction Log File: If the issue persists, you may need to recreate the transaction log file. To do this, open the folder containing your company file and locate the transaction log file (.TLG). Delete this file and then try opening the company file again. QuickBooks will recreate the transaction log file automatically.Check for Hosting Settings: If you are using QuickBooks in a multi-user environment, ensure that hosting settings are correctly configured. The hosting should be enabled only on the server computer and disabled on workstations. To check hosting settings, go to the File menu within QuickBooks and select Utilities > Stop Hosting Multi-User Access on workstations.By following these troubleshooting solutions, you should be able to resolve QuickBooks Desktop Error code 6190 and 816 and regain access to your company file without any further issues. If the problem persists after trying these solutions, consider reaching out to QuickBooks support for further assistance and guidance tailored to your specific situation. Read More
How to proceed when Direct Deposit is not working in QuickBooks desktop?
Troubleshooting Solutions: Direct Deposit is not working in QuickBooks Desktop
Direct Deposit not working in QuickBooks Desktop can be frustrating, but several troubleshooting steps can help resolve the issue.
Verify Bank Information: Double-check that the bank account information entered in QuickBooks matches the actual account details. Even a minor discrepancy can lead to payment failures.Check for Payroll Service Subscription: Ensure that your QuickBooks subscription includes a payroll service. Without an active subscription, direct deposit functionality won’t work.Confirm Employee Setup: Review employee profiles to ensure that direct deposit information is accurately entered, including bank account details and authorization for direct deposit.Update QuickBooks Desktop: Make sure you’re using the latest version of QuickBooks Desktop. Updates often include bug fixes and enhancements that could address direct deposit issues.Run Payroll Updates: Run payroll updates within QuickBooks to ensure that you have the latest tax tables and payroll features installed, which can help resolve compatibility issues.Check Internet Connection: A stable internet connection is essential for processing direct deposits. Ensure your internet connection is strong and stable to avoid communication errors.Review Payroll Preferences: Verify that your payroll preferences are set up correctly within QuickBooks Desktop. Check settings related to direct deposit, bank accounts, and payroll processing.Reauthorize Direct Deposit: Sometimes, reauthorizing direct deposit for affected employees can resolve issues. Ask employees to fill out new direct deposit authorization forms if necessary.Test Direct Deposit with Small Amounts: Test direct deposit functionality by processing small payment amounts for a few employees. This can help identify if the issue is widespread or isolated.Contact QuickBooks Support: If the issue persists after trying the above steps, reach out to QuickBooks support for assistance. They can provide personalized troubleshooting and guidance.Check Bank’s Direct Deposit Policies: Verify if your bank has any specific requirements or restrictions for direct deposit transactions. Ensure that your process aligns with their guidelines.Inspect Error Messages: Pay attention to any error messages or codes received during the direct deposit process. These can provide valuable clues about the root cause of the issue.Run Payroll Reports: Generate payroll reports to review transaction histories and payment statuses. This can help identify any patterns or discrepancies that may be causing direct deposit failures.Temporarily Disable Security Software: Security software or firewalls on your computer may sometimes interfere with QuickBooks’ ability to process direct deposits. Temporarily disable them and try processing direct deposits again.Consider Alternate Payment Methods: If direct deposit continues to pose challenges, consider using alternative payment methods such as paper checks or electronic fund transfers (EFTs) until the issue is resolved.
By following these troubleshooting steps, you can effectively address Direct Deposit issues in QuickBooks Desktop and ensure seamless payroll processing for your business. If problems persist, don’t hesitate to seek assistance from QuickBooks support or consult with a qualified financial advisor.
Troubleshooting Solutions: Direct Deposit is not working in QuickBooks Desktop Direct Deposit not working in QuickBooks Desktop can be frustrating, but several troubleshooting steps can help resolve the issue. Verify Bank Information: Double-check that the bank account information entered in QuickBooks matches the actual account details. Even a minor discrepancy can lead to payment failures.Check for Payroll Service Subscription: Ensure that your QuickBooks subscription includes a payroll service. Without an active subscription, direct deposit functionality won’t work.Confirm Employee Setup: Review employee profiles to ensure that direct deposit information is accurately entered, including bank account details and authorization for direct deposit.Update QuickBooks Desktop: Make sure you’re using the latest version of QuickBooks Desktop. Updates often include bug fixes and enhancements that could address direct deposit issues.Run Payroll Updates: Run payroll updates within QuickBooks to ensure that you have the latest tax tables and payroll features installed, which can help resolve compatibility issues.Check Internet Connection: A stable internet connection is essential for processing direct deposits. Ensure your internet connection is strong and stable to avoid communication errors.Review Payroll Preferences: Verify that your payroll preferences are set up correctly within QuickBooks Desktop. Check settings related to direct deposit, bank accounts, and payroll processing.Reauthorize Direct Deposit: Sometimes, reauthorizing direct deposit for affected employees can resolve issues. Ask employees to fill out new direct deposit authorization forms if necessary.Test Direct Deposit with Small Amounts: Test direct deposit functionality by processing small payment amounts for a few employees. This can help identify if the issue is widespread or isolated.Contact QuickBooks Support: If the issue persists after trying the above steps, reach out to QuickBooks support for assistance. They can provide personalized troubleshooting and guidance.Check Bank’s Direct Deposit Policies: Verify if your bank has any specific requirements or restrictions for direct deposit transactions. Ensure that your process aligns with their guidelines.Inspect Error Messages: Pay attention to any error messages or codes received during the direct deposit process. These can provide valuable clues about the root cause of the issue.Run Payroll Reports: Generate payroll reports to review transaction histories and payment statuses. This can help identify any patterns or discrepancies that may be causing direct deposit failures.Temporarily Disable Security Software: Security software or firewalls on your computer may sometimes interfere with QuickBooks’ ability to process direct deposits. Temporarily disable them and try processing direct deposits again.Consider Alternate Payment Methods: If direct deposit continues to pose challenges, consider using alternative payment methods such as paper checks or electronic fund transfers (EFTs) until the issue is resolved.By following these troubleshooting steps, you can effectively address Direct Deposit issues in QuickBooks Desktop and ensure seamless payroll processing for your business. If problems persist, don’t hesitate to seek assistance from QuickBooks support or consult with a qualified financial advisor. Read More
How to Fix Quickbooks Multi-User Mode Not Working?
Troubleshooting Solutions: Quickbooks Multi-User Mode Not Working
QuickBooks Multi-User Mode allows multiple users to access the same company file simultaneously. When this feature encounters issues, it can disrupt collaborative work processes. Here are some troubleshooting steps to resolve QuickBooks Multi-User Mode issues:
Check Network Connectivity: Poor network connectivity or network configuration issues can prevent QuickBooks from functioning correctly in Multi-User Mode. Ensure that all computers are connected to the same network and that the network is stable.Verify Hosting Settings: In Multi-User Mode, only the server hosting the company file should be set to host multi-user access. Check the hosting settings on each computer to ensure that only the server is hosting multi-user access.Restart QuickBooks Database Server Manager: QuickBooks Database Server Manager manages access to the company files in multi-user mode. Restarting this service can resolve issues related to Multi-User Mode. Open the Windows Start menu, search for “QuickBooks Database Server Manager,” and select “Restart.”Update QuickBooks to the Latest Release: Outdated versions of QuickBooks may have compatibility issues with Multi-User Mode. Ensure that QuickBooks on all computers is updated to the latest release by navigating to the Help menu and selecting “Update QuickBooks Desktop.”Check Firewall and Antivirus Settings: Firewall or antivirus software may block QuickBooks from accessing the network in Multi-User Mode. Configure firewall and antivirus settings to allow QuickBooks access to the network, or temporarily disable them to check if they are causing the issue.Recreate Network Data File: Corrupted network data files can cause issues with Multi-User Mode. Recreate the network data file by accessing the company file in single-user mode on the server computer and selecting “File” > “Utilities” > “Host Multi-User Access.”Repair QuickBooks Installation: A corrupted QuickBooks installation can cause Multi-User Mode issues. Repair QuickBooks installation by navigating to the Control Panel, selecting “Programs and Features,” selecting QuickBooks from the list, and choosing “Repair.”Check File Permissions: Incorrect file permissions can prevent users from accessing company files in Multi-User Mode. Ensure that all users have the appropriate permissions to access the company file and its folder.Use QuickBooks File Doctor: QuickBooks File Doctor is a diagnostic tool that can identify and resolve Multi-User Mode issues. Download and run QuickBooks File Doctor, select “Check your file” and “Network connectivity,” and follow the on-screen instructions.Contact QuickBooks Support: If the issue persists after attempting the above steps, contact QuickBooks support for further assistance. Provide details about your setup and the steps you’ve taken to troubleshoot the problem for personalized assistance.
By following these troubleshooting steps, you should be able to resolve issues with QuickBooks Multi-User Mode and resume collaborative work on your company file without disruptions.
Troubleshooting Solutions: Quickbooks Multi-User Mode Not WorkingQuickBooks Multi-User Mode allows multiple users to access the same company file simultaneously. When this feature encounters issues, it can disrupt collaborative work processes. Here are some troubleshooting steps to resolve QuickBooks Multi-User Mode issues:Check Network Connectivity: Poor network connectivity or network configuration issues can prevent QuickBooks from functioning correctly in Multi-User Mode. Ensure that all computers are connected to the same network and that the network is stable.Verify Hosting Settings: In Multi-User Mode, only the server hosting the company file should be set to host multi-user access. Check the hosting settings on each computer to ensure that only the server is hosting multi-user access.Restart QuickBooks Database Server Manager: QuickBooks Database Server Manager manages access to the company files in multi-user mode. Restarting this service can resolve issues related to Multi-User Mode. Open the Windows Start menu, search for “QuickBooks Database Server Manager,” and select “Restart.”Update QuickBooks to the Latest Release: Outdated versions of QuickBooks may have compatibility issues with Multi-User Mode. Ensure that QuickBooks on all computers is updated to the latest release by navigating to the Help menu and selecting “Update QuickBooks Desktop.”Check Firewall and Antivirus Settings: Firewall or antivirus software may block QuickBooks from accessing the network in Multi-User Mode. Configure firewall and antivirus settings to allow QuickBooks access to the network, or temporarily disable them to check if they are causing the issue.Recreate Network Data File: Corrupted network data files can cause issues with Multi-User Mode. Recreate the network data file by accessing the company file in single-user mode on the server computer and selecting “File” > “Utilities” > “Host Multi-User Access.”Repair QuickBooks Installation: A corrupted QuickBooks installation can cause Multi-User Mode issues. Repair QuickBooks installation by navigating to the Control Panel, selecting “Programs and Features,” selecting QuickBooks from the list, and choosing “Repair.”Check File Permissions: Incorrect file permissions can prevent users from accessing company files in Multi-User Mode. Ensure that all users have the appropriate permissions to access the company file and its folder.Use QuickBooks File Doctor: QuickBooks File Doctor is a diagnostic tool that can identify and resolve Multi-User Mode issues. Download and run QuickBooks File Doctor, select “Check your file” and “Network connectivity,” and follow the on-screen instructions.Contact QuickBooks Support: If the issue persists after attempting the above steps, contact QuickBooks support for further assistance. Provide details about your setup and the steps you’ve taken to troubleshoot the problem for personalized assistance.By following these troubleshooting steps, you should be able to resolve issues with QuickBooks Multi-User Mode and resume collaborative work on your company file without disruptions. Read More
How to fix QuickBooks Desktop Crashing When Opening Company File?
Troubleshooting Solutions: QuickBooks Desktop Crashing When Opening Company File
Run QuickBooks File Doctor: Utilize the QuickBooks File Doctor tool to diagnose and repair any file-related issues causing crashes. This tool can be downloaded from the QuickBooks website and will guide you through the troubleshooting process.Update QuickBooks Desktop: Ensure your QuickBooks Desktop software is up to date with the latest patches and updates. Go to the Help menu and select “Update QuickBooks Desktop” to install any available updates. Outdated software may have compatibility issues leading to crashes.Check System Requirements: Verify that your computer meets the minimum system requirements for running QuickBooks Desktop. Inadequate hardware or outdated operating systems can cause instability and crashes. Refer to the official QuickBooks system requirements documentation for compatibility information.Recreate QBWUSER.INI File: Close QuickBooks Desktop and navigate to the folder where QuickBooks stores user settings. Rename the QBWUSER.INI file to QBWUSER.INI.old and then restart QuickBooks. A new QBWUSER.INI file will be created automatically, potentially resolving any configuration-related issues.Disable Antivirus/Firewall: Temporarily disable your antivirus or firewall software and attempt to open the company file again. Sometimes, overzealous security software can mistakenly flag QuickBooks processes as threats, leading to crashes. Ensure to re-enable these protections after troubleshooting.Run QuickBooks Install Diagnostic Tool: Download and run the QuickBooks Install Diagnostic Tool from the official Intuit website. This tool can identify and resolve common installation-related issues that may be causing QuickBooks Desktop to crash when opening company files.Verify Data Integrity: Launch QuickBooks Desktop and press Ctrl + O to open a company file. Select the company file and press Ctrl + F3 to run the Verify Data utility. Follow the prompts to check for any data integrity issues within the company file and resolve them accordingly.Check Event Viewer Logs: Open the Event Viewer on your computer and navigate to the Windows Logs > Application section. Look for any error messages or events related to QuickBooks Desktop crashes. These logs may provide valuable insights into the underlying cause of the issue.Reinstall QuickBooks Desktop: If all else fails, consider reinstalling QuickBooks Desktop to ensure a clean installation. Uninstall QuickBooks from your computer, then download and install the latest version from the official QuickBooks website. Be sure to back up your company files before proceeding with the reinstall.Contact QuickBooks Support: If you’re unable to resolve the crashing issue on your own, don’t hesitate to contact QuickBooks customer support for further assistance. They have trained professionals who can provide personalized troubleshooting steps and guidance tailored to your specific situation.
Following these troubleshooting solutions should help you address the recurring issue of QuickBooks Desktop crashing when attempting to open company files, allowing you to resume your work without interruption.
Troubleshooting Solutions: QuickBooks Desktop Crashing When Opening Company File Run QuickBooks File Doctor: Utilize the QuickBooks File Doctor tool to diagnose and repair any file-related issues causing crashes. This tool can be downloaded from the QuickBooks website and will guide you through the troubleshooting process.Update QuickBooks Desktop: Ensure your QuickBooks Desktop software is up to date with the latest patches and updates. Go to the Help menu and select “Update QuickBooks Desktop” to install any available updates. Outdated software may have compatibility issues leading to crashes.Check System Requirements: Verify that your computer meets the minimum system requirements for running QuickBooks Desktop. Inadequate hardware or outdated operating systems can cause instability and crashes. Refer to the official QuickBooks system requirements documentation for compatibility information.Recreate QBWUSER.INI File: Close QuickBooks Desktop and navigate to the folder where QuickBooks stores user settings. Rename the QBWUSER.INI file to QBWUSER.INI.old and then restart QuickBooks. A new QBWUSER.INI file will be created automatically, potentially resolving any configuration-related issues.Disable Antivirus/Firewall: Temporarily disable your antivirus or firewall software and attempt to open the company file again. Sometimes, overzealous security software can mistakenly flag QuickBooks processes as threats, leading to crashes. Ensure to re-enable these protections after troubleshooting.Run QuickBooks Install Diagnostic Tool: Download and run the QuickBooks Install Diagnostic Tool from the official Intuit website. This tool can identify and resolve common installation-related issues that may be causing QuickBooks Desktop to crash when opening company files.Verify Data Integrity: Launch QuickBooks Desktop and press Ctrl + O to open a company file. Select the company file and press Ctrl + F3 to run the Verify Data utility. Follow the prompts to check for any data integrity issues within the company file and resolve them accordingly.Check Event Viewer Logs: Open the Event Viewer on your computer and navigate to the Windows Logs > Application section. Look for any error messages or events related to QuickBooks Desktop crashes. These logs may provide valuable insights into the underlying cause of the issue.Reinstall QuickBooks Desktop: If all else fails, consider reinstalling QuickBooks Desktop to ensure a clean installation. Uninstall QuickBooks from your computer, then download and install the latest version from the official QuickBooks website. Be sure to back up your company files before proceeding with the reinstall.Contact QuickBooks Support: If you’re unable to resolve the crashing issue on your own, don’t hesitate to contact QuickBooks customer support for further assistance. They have trained professionals who can provide personalized troubleshooting steps and guidance tailored to your specific situation.Following these troubleshooting solutions should help you address the recurring issue of QuickBooks Desktop crashing when attempting to open company files, allowing you to resume your work without interruption. Read More
DateTime column imported from CSV is not displayed on SharePoint site.
I imported a CSV in PowerShell to create data for a SharePoint list.
The date1 in the CSV is “2024-05-02 11:58:28”.
foreach ($row in $csvData) {
$parsedDate1 = [datetime]::ParseExact($row.date1, “yyyy-MM-dd HH:mm:ss”, [System.Globalization.CultureInfo]::InvariantCulture)
$parsedDate2 = [datetime]::ParseExact($row.date2, “yyyy-MM-dd HH:mm:ss”, [System.Globalization.CultureInfo]::InvariantCulture)
$jstZone = [System.TimeZoneInfo]::FindSystemTimeZoneById(“Tokyo Standard Time”)
$utcDate1 = [System.TimeZoneInfo]::ConvertTimeToUtc($parsedDate1, $jstZone)
$utcDate2 = [System.TimeZoneInfo]::ConvertTimeToUtc($parsedDate2, $jstZone)
$formattedDate1 = $utcDate1.ToString(“yyyy-MM-ddTHH:mm:ss”) + “Z”
$formattedDate2 = $utcDate2.ToString(“yyyy-MM-ddTHH:mm:ss”) + “Z”
Add-PnPListItem -List $ListName -Values @{
“date1” = $formattedDate1;
“date2” = $formattedDate2;
}
}
However, nothing appears on the SharePoint site, as shown below:
The following script confirms that the data is included.
$items = Get-PnPListItem -List $listName
foreach ($item in $items) {
$date1Value = $item[“date1”]
if ($date1Value -ne $null) {
Write-Host “Date1: $date1Value”
} else {
Write-Host “Date1: No date available”
}
}
[Result]
Date1: 05/02/2024 02:58:28
* DateTime is also displayed on Galley in Power Apps.
How can I get the DateTime to display correctly on the SharePoint site as well,
What format should I specify in Add-PnPListItem?
I imported a CSV in PowerShell to create data for a SharePoint list. The date1 in the CSV is “2024-05-02 11:58:28”. foreach ($row in $csvData) {
$parsedDate1 = [datetime]::ParseExact($row.date1, “yyyy-MM-dd HH:mm:ss”, [System.Globalization.CultureInfo]::InvariantCulture)
$parsedDate2 = [datetime]::ParseExact($row.date2, “yyyy-MM-dd HH:mm:ss”, [System.Globalization.CultureInfo]::InvariantCulture)
$jstZone = [System.TimeZoneInfo]::FindSystemTimeZoneById(“Tokyo Standard Time”)
$utcDate1 = [System.TimeZoneInfo]::ConvertTimeToUtc($parsedDate1, $jstZone)
$utcDate2 = [System.TimeZoneInfo]::ConvertTimeToUtc($parsedDate2, $jstZone)
$formattedDate1 = $utcDate1.ToString(“yyyy-MM-ddTHH:mm:ss”) + “Z”
$formattedDate2 = $utcDate2.ToString(“yyyy-MM-ddTHH:mm:ss”) + “Z”
Add-PnPListItem -List $ListName -Values @{
“date1” = $formattedDate1;
“date2” = $formattedDate2;
}
} However, nothing appears on the SharePoint site, as shown below: The following script confirms that the data is included. $items = Get-PnPListItem -List $listName
foreach ($item in $items) {
$date1Value = $item[“date1”]
if ($date1Value -ne $null) {
Write-Host “Date1: $date1Value”
} else {
Write-Host “Date1: No date available”
}
} [Result]Date1: 05/02/2024 02:58:28 * DateTime is also displayed on Galley in Power Apps. How can I get the DateTime to display correctly on the SharePoint site as well,What format should I specify in Add-PnPListItem? Read More
New Planner tasks are not synchronized from (old) Project for the web
Hello,
The new Planner has been available in Teams since this week. We have many (old) Project for the web projects.
We hoped that the tasks would now appear for each user under My tasks.
Unfortunately, this is not the case. Even marked mails do not appear.
Brief background of our infrastructure:
We have an Exchange in hybrid mode. Our project management (based on the project accelerator) also runs in an extra environment, and not in the standard environment.
Could this be a problem, or will it simply take a little longer?
We have also tried it with a user who also has an online mailbox. It didn’t work here either.
Does anyone have any advice and can help us?
Greetings from Germany
Oliver
Hello, The new Planner has been available in Teams since this week. We have many (old) Project for the web projects.We hoped that the tasks would now appear for each user under My tasks.Unfortunately, this is not the case. Even marked mails do not appear.Brief background of our infrastructure:We have an Exchange in hybrid mode. Our project management (based on the project accelerator) also runs in an extra environment, and not in the standard environment.Could this be a problem, or will it simply take a little longer?We have also tried it with a user who also has an online mailbox. It didn’t work here either.Does anyone have any advice and can help us?Greetings from Germany Oliver Read More
Azure Pipelines are offline
Hi all,
I am currently facing some issue with the Azure devops pipeline used for deployment.
The agents are offline and it looked like the PAT had expired.
We created new PAT and assigned it to the secrets as the token and tried restarting the services.
However it looks like there is some issue and the agents are still offline.
After validating the logs generated I could find the below error –
Before changing the PAT error logs
– cp: target ‘/etc/pki/ca-trust/source/anchors’ is not a directory
– jq: error (at <stdin>:1): Cannot iterate over null (null)
After changing the PAT, error logs
– cp: target ‘/etc/pki/ca-trust/source/anchors’ is not a directory
Can someone help me understand what is causing this issues and help me resolve it ?
Many thanks !
Hi all,I am currently facing some issue with the Azure devops pipeline used for deployment.The agents are offline and it looked like the PAT had expired.We created new PAT and assigned it to the secrets as the token and tried restarting the services.However it looks like there is some issue and the agents are still offline.After validating the logs generated I could find the below error -Before changing the PAT error logs – cp: target ‘/etc/pki/ca-trust/source/anchors’ is not a directory- jq: error (at <stdin>:1): Cannot iterate over null (null)After changing the PAT, error logs- cp: target ‘/etc/pki/ca-trust/source/anchors’ is not a directory Can someone help me understand what is causing this issues and help me resolve it ?Many thanks ! Read More
What to do when QuickBooks Administrator Permissions Needed issues?
Troubleshooting Solutions: QuickBooks Administrator Permissions Needed
Verify Administrator Status: Ensure that your user account is indeed designated as an administrator in QuickBooks. Go to the “Company” menu, select “Users,” and then “Set Up Users and Roles” to confirm your permissions. If not, update your user role to administrator.Check User Permissions: Review the specific permissions assigned to your user account. Navigate to “Company” > “Users” > “Set Up Users and Roles” and verify that the required permissions are enabled for your account. Ensure that you have permissions for tasks such as creating transactions, accessing sensitive financial data, and modifying company settings.Reboot QuickBooks and System: Sometimes, technical glitches can cause permission issues. Close QuickBooks and restart your computer to refresh the system. Then, relaunch QuickBooks and attempt the task again to see if the problem persists.Update QuickBooks: Ensure that you’re using the latest version of QuickBooks. Outdated software may contain bugs or compatibility issues that could interfere with administrator permissions. Check for updates by selecting “Help” > “Update QuickBooks” and follow the prompts to install any available updates.Run QuickBooks as Administrator: Try running QuickBooks with elevated privileges by right-clicking the QuickBooks shortcut icon and selecting “Run as administrator.” This action grants the program additional permissions that may resolve the issue you’re experiencing.Review Security Software Settings: Antivirus or firewall software on your system could potentially block QuickBooks from accessing certain features or files, leading to permission issues. Temporarily disable or adjust the settings of your security software to allow QuickBooks full access, then attempt the task again.Create a New Admin User: As a workaround, create a new user account with administrator privileges. Navigate to “Company” > “Users” > “Set Up Users and Roles” and add a new user with full admin permissions. Log in with the new account and see if you can perform the desired tasks without any issues.Check Windows User Account Control (UAC) Settings: Windows User Account Control settings may restrict certain actions in QuickBooks. Adjust the UAC settings by typing “UAC” in the Windows search bar, selecting “Change User Account Control settings,” and moving the slider to the lowest (never notify) setting. Restart your computer and attempt the task again.Repair QuickBooks Installation: If none of the above solutions resolve the issue, repair your QuickBooks installation. Close QuickBooks, open the Control Panel, navigate to “Programs” > “Programs and Features,” select QuickBooks from the list, and choose “Repair.” Follow the on-screen instructions to repair the installation.Contact QuickBooks Support: If the problem persists after trying the troubleshooting steps above, reach out to QuickBooks customer support for further assistance. Provide detailed information about the issue you’re experiencing, including any error messages or specific tasks you’re unable to perform. They can offer personalized guidance to help resolve the permissions issue.
Troubleshooting Solutions: QuickBooks Administrator Permissions Needed Verify Administrator Status: Ensure that your user account is indeed designated as an administrator in QuickBooks. Go to the “Company” menu, select “Users,” and then “Set Up Users and Roles” to confirm your permissions. If not, update your user role to administrator.Check User Permissions: Review the specific permissions assigned to your user account. Navigate to “Company” > “Users” > “Set Up Users and Roles” and verify that the required permissions are enabled for your account. Ensure that you have permissions for tasks such as creating transactions, accessing sensitive financial data, and modifying company settings.Reboot QuickBooks and System: Sometimes, technical glitches can cause permission issues. Close QuickBooks and restart your computer to refresh the system. Then, relaunch QuickBooks and attempt the task again to see if the problem persists.Update QuickBooks: Ensure that you’re using the latest version of QuickBooks. Outdated software may contain bugs or compatibility issues that could interfere with administrator permissions. Check for updates by selecting “Help” > “Update QuickBooks” and follow the prompts to install any available updates.Run QuickBooks as Administrator: Try running QuickBooks with elevated privileges by right-clicking the QuickBooks shortcut icon and selecting “Run as administrator.” This action grants the program additional permissions that may resolve the issue you’re experiencing.Review Security Software Settings: Antivirus or firewall software on your system could potentially block QuickBooks from accessing certain features or files, leading to permission issues. Temporarily disable or adjust the settings of your security software to allow QuickBooks full access, then attempt the task again.Create a New Admin User: As a workaround, create a new user account with administrator privileges. Navigate to “Company” > “Users” > “Set Up Users and Roles” and add a new user with full admin permissions. Log in with the new account and see if you can perform the desired tasks without any issues.Check Windows User Account Control (UAC) Settings: Windows User Account Control settings may restrict certain actions in QuickBooks. Adjust the UAC settings by typing “UAC” in the Windows search bar, selecting “Change User Account Control settings,” and moving the slider to the lowest (never notify) setting. Restart your computer and attempt the task again.Repair QuickBooks Installation: If none of the above solutions resolve the issue, repair your QuickBooks installation. Close QuickBooks, open the Control Panel, navigate to “Programs” > “Programs and Features,” select QuickBooks from the list, and choose “Repair.” Follow the on-screen instructions to repair the installation.Contact QuickBooks Support: If the problem persists after trying the troubleshooting steps above, reach out to QuickBooks customer support for further assistance. Provide detailed information about the issue you’re experiencing, including any error messages or specific tasks you’re unable to perform. They can offer personalized guidance to help resolve the permissions issue. Read More
What to do when Quickbooks payroll update error ps038?
Troubleshooting Solutions: QuickBooks payroll update error ps038
QuickBooks users occasionally encounter errors like PS038 during payroll updates. This issue may arise due to various reasons, such as incorrect tax table installation, damaged QuickBooks company file, or outdated software. Here’s a comprehensive guide to troubleshoot and resolve QuickBooks Payroll Update Error PS038:
1. Verify Payroll Subscription:
Ensure that your QuickBooks payroll subscription is active and up-to-date. Navigate to the ‘Employees’ menu, select ‘My Payroll Service’, and then click on ‘Account/Billing Information’. Confirm the subscription status and update if necessary.
2. Check Internet Connection:
A stable internet connection is crucial for successful payroll updates. Verify your internet connectivity and ensure that there are no network interruptions. If using a wireless connection, consider switching to a wired connection for stability.
3. Update QuickBooks Software:
Ensure that your QuickBooks software is updated to the latest version. Go to the ‘Help’ menu and select ‘Update QuickBooks Desktop’. Follow the prompts to install any available updates. Updated software often includes fixes for known issues like PS038.
4. Verify User Account Control (UAC) Settings:
Adjust User Account Control settings to allow QuickBooks to perform updates smoothly. Navigate to the Control Panel, select ‘User Accounts’, and click on ‘Change User Account Control settings’. Set the slider to a lower level (not recommended to disable UAC entirely) and click ‘OK’.
5. Download and Install Payroll Tax Table Updates Manually:
If the automatic update fails, download the latest payroll tax table update manually from the Intuit website. Save the file to your computer and install it following the on-screen instructions. After installation, attempt to update payroll again.
6. Run QuickBooks File Doctor:
QuickBooks File Doctor is a diagnostic tool that can repair various QuickBooks-related issues, including PS038. Download and run the tool from the Intuit website. Follow the prompts to scan and repair your QuickBooks company file. After the repair process, attempt to update payroll again.
7. Check Firewall and Security Software Settings:
Ensure that your firewall or security software isn’t blocking QuickBooks updates. Configure firewall settings to allow QuickBooks connections and exceptions. Consult your security software documentation for instructions on how to add QuickBooks as a trusted application.
8. Verify Payroll Settings and Preferences:
Double-check your payroll settings and preferences to ensure everything is configured correctly. Navigate to the ‘Edit’ menu, select ‘Preferences’, and choose ‘Payroll & Employees’. Review each section for accuracy, especially tax-related settings.
9. Temporarily Disable Antivirus Software:
Sometimes, antivirus software can interfere with QuickBooks updates. Temporarily disable your antivirus program and attempt to update payroll again. Remember to re-enable it after the update process is complete.
10. Contact QuickBooks Support:
If the issue persists after trying the above solutions, contact QuickBooks support for further assistance. Provide them with detailed information about the error and steps you’ve taken to troubleshoot. They can offer personalized guidance to resolve the PS038 error.
By following these troubleshooting steps, you should be able to resolve QuickBooks Payroll Update Error PS038 and successfully update your payroll without any further issues.
Troubleshooting Solutions: QuickBooks payroll update error ps038 QuickBooks users occasionally encounter errors like PS038 during payroll updates. This issue may arise due to various reasons, such as incorrect tax table installation, damaged QuickBooks company file, or outdated software. Here’s a comprehensive guide to troubleshoot and resolve QuickBooks Payroll Update Error PS038: 1. Verify Payroll Subscription:Ensure that your QuickBooks payroll subscription is active and up-to-date. Navigate to the ‘Employees’ menu, select ‘My Payroll Service’, and then click on ‘Account/Billing Information’. Confirm the subscription status and update if necessary.2. Check Internet Connection:A stable internet connection is crucial for successful payroll updates. Verify your internet connectivity and ensure that there are no network interruptions. If using a wireless connection, consider switching to a wired connection for stability.3. Update QuickBooks Software:Ensure that your QuickBooks software is updated to the latest version. Go to the ‘Help’ menu and select ‘Update QuickBooks Desktop’. Follow the prompts to install any available updates. Updated software often includes fixes for known issues like PS038.4. Verify User Account Control (UAC) Settings:Adjust User Account Control settings to allow QuickBooks to perform updates smoothly. Navigate to the Control Panel, select ‘User Accounts’, and click on ‘Change User Account Control settings’. Set the slider to a lower level (not recommended to disable UAC entirely) and click ‘OK’.5. Download and Install Payroll Tax Table Updates Manually:If the automatic update fails, download the latest payroll tax table update manually from the Intuit website. Save the file to your computer and install it following the on-screen instructions. After installation, attempt to update payroll again.6. Run QuickBooks File Doctor:QuickBooks File Doctor is a diagnostic tool that can repair various QuickBooks-related issues, including PS038. Download and run the tool from the Intuit website. Follow the prompts to scan and repair your QuickBooks company file. After the repair process, attempt to update payroll again.7. Check Firewall and Security Software Settings:Ensure that your firewall or security software isn’t blocking QuickBooks updates. Configure firewall settings to allow QuickBooks connections and exceptions. Consult your security software documentation for instructions on how to add QuickBooks as a trusted application.8. Verify Payroll Settings and Preferences:Double-check your payroll settings and preferences to ensure everything is configured correctly. Navigate to the ‘Edit’ menu, select ‘Preferences’, and choose ‘Payroll & Employees’. Review each section for accuracy, especially tax-related settings.9. Temporarily Disable Antivirus Software:Sometimes, antivirus software can interfere with QuickBooks updates. Temporarily disable your antivirus program and attempt to update payroll again. Remember to re-enable it after the update process is complete.10. Contact QuickBooks Support:If the issue persists after trying the above solutions, contact QuickBooks support for further assistance. Provide them with detailed information about the error and steps you’ve taken to troubleshoot. They can offer personalized guidance to resolve the PS038 error.By following these troubleshooting steps, you should be able to resolve QuickBooks Payroll Update Error PS038 and successfully update your payroll without any further issues. Read More
Conditional formatting in Excel
I have a workbook saved for members of our racing team (each person on a row) to signify their availability for each week’s racing during the season (columns). I’ve set it up with a data validation (for yes/no/no response) and once they make their choice, I’d like the conditional formatting to kick in and make it easier to see how many are in for a given week, so I was thinking a YES entry would -> green fill/dark green text, NO-> red fill/dark red text, no response would stay with no fill. We have 20 people/rows, 22 weeks of racing/columns, and I want to try and do something once that would apply to all. When I went to conditional formatting, I couldn’t see how I set multiple options or specify the range of cells to which I want it to apply. Can someone help? Thanks in advance.
I have a workbook saved for members of our racing team (each person on a row) to signify their availability for each week’s racing during the season (columns). I’ve set it up with a data validation (for yes/no/no response) and once they make their choice, I’d like the conditional formatting to kick in and make it easier to see how many are in for a given week, so I was thinking a YES entry would -> green fill/dark green text, NO-> red fill/dark red text, no response would stay with no fill. We have 20 people/rows, 22 weeks of racing/columns, and I want to try and do something once that would apply to all. When I went to conditional formatting, I couldn’t see how I set multiple options or specify the range of cells to which I want it to apply. Can someone help? Thanks in advance. Read More
How Partitioning works
Good afternoon,
I can’t find any information about how partitioning works inside SQL Server.
Faced with a situation. Example:
There is a table with lists (id,category,price,idPart), where there is an identifier that works for partitioning.
12 partitions from 0 to 12
Please tell me why the query for the partition field is slower
SELECT id,category,price FROM dbo.myTable WHERE id Part = 1
And the query using the partition function works faster
SELECT id,category,price FROM dbo.myTable WHERE $PARTITION.pf(idPart) = 1
Good afternoon,I can’t find any information about how partitioning works inside SQL Server.Faced with a situation. Example:There is a table with lists (id,category,price,idPart), where there is an identifier that works for partitioning.12 partitions from 0 to 12Please tell me why the query for the partition field is slowerSELECT id,category,price FROM dbo.myTable WHERE id Part = 1And the query using the partition function works fasterSELECT id,category,price FROM dbo.myTable WHERE $PARTITION.pf(idPart) = 1 Read More
How to Fix Quickbooks Multi-User Mode Not Working After Update?
Troubleshooting Solutions: Quickbooks Multi-User Mode Not Working After Update
Quickbooks Multi-User Mode Not Working After Update can be frustrating but usually has straightforward fixes. Here are steps to troubleshoot the issue:
Check Network Connectivity: Ensure all computers are connected to the same network. If there are any network issues, resolve them first. You can restart your router or switch to a wired connection if possible.Update QuickBooks: Confirm that all computers have the latest QuickBooks update installed. Sometimes, outdated software can lead to compatibility issues, causing Multi-User Mode to malfunction.Restart QuickBooks Database Server Manager: Navigate to the computer hosting the company file and restart the QuickBooks Database Server Manager. Go to the Start menu, search for “QuickBooks Database Server Manager,” and select it. Then, click on “Scan Folders” to rescan the company file. This should refresh the connection for Multi-User Mode.Check Firewall and Antivirus Settings: Firewalls or antivirus software may block QuickBooks from accessing the network, causing Multi-User Mode to fail. Temporarily disable these programs and check if Multi-User Mode works. If it does, you’ll need to configure firewall and antivirus settings to allow QuickBooks access.Verify Hosting Settings: Ensure that only the server or host computer is set to host Multi-User access. Open QuickBooks on the host computer, go to the File menu, select “Utilities,” and then click “Host Multi-User Access.” On client computers, this option should be disabled.Check File Permissions: Verify that the user permissions are set correctly for the company file. Go to the location where the company file is stored, right-click on it, select “Properties,” and then navigate to the “Security” tab. Ensure that all users have the necessary permissions to access the file.Use QuickBooks File Doctor: QuickBooks File Doctor is a tool provided by Intuit to diagnose and repair common QuickBooks issues. Download and run QuickBooks File Doctor, select your company file, and follow the on-screen instructions to fix any detected issues.Create a New User: Sometimes, user profiles can become corrupted, causing Multi-User Mode problems. Create a new user profile on the affected computer and try accessing Multi-User Mode with the new profile.Recreate Network Data File: If none of the above solutions work, try recreating the network data file. Go to the computer hosting the company file, open QuickBooks Database Server Manager, and select “Start Scan.” This will recreate the network data file and might resolve the Multi-User Mode issue.
Following these troubleshooting steps should help you resolve the Quickbooks Multi-User Mode Not Working After Update problem efficiently, ensuring smooth collaboration among users. If the issue persists, contacting QuickBooks support might be necessary for further assistance.
Troubleshooting Solutions: Quickbooks Multi-User Mode Not Working After UpdateQuickbooks Multi-User Mode Not Working After Update can be frustrating but usually has straightforward fixes. Here are steps to troubleshoot the issue:Check Network Connectivity: Ensure all computers are connected to the same network. If there are any network issues, resolve them first. You can restart your router or switch to a wired connection if possible.Update QuickBooks: Confirm that all computers have the latest QuickBooks update installed. Sometimes, outdated software can lead to compatibility issues, causing Multi-User Mode to malfunction.Restart QuickBooks Database Server Manager: Navigate to the computer hosting the company file and restart the QuickBooks Database Server Manager. Go to the Start menu, search for “QuickBooks Database Server Manager,” and select it. Then, click on “Scan Folders” to rescan the company file. This should refresh the connection for Multi-User Mode.Check Firewall and Antivirus Settings: Firewalls or antivirus software may block QuickBooks from accessing the network, causing Multi-User Mode to fail. Temporarily disable these programs and check if Multi-User Mode works. If it does, you’ll need to configure firewall and antivirus settings to allow QuickBooks access.Verify Hosting Settings: Ensure that only the server or host computer is set to host Multi-User access. Open QuickBooks on the host computer, go to the File menu, select “Utilities,” and then click “Host Multi-User Access.” On client computers, this option should be disabled.Check File Permissions: Verify that the user permissions are set correctly for the company file. Go to the location where the company file is stored, right-click on it, select “Properties,” and then navigate to the “Security” tab. Ensure that all users have the necessary permissions to access the file.Use QuickBooks File Doctor: QuickBooks File Doctor is a tool provided by Intuit to diagnose and repair common QuickBooks issues. Download and run QuickBooks File Doctor, select your company file, and follow the on-screen instructions to fix any detected issues.Create a New User: Sometimes, user profiles can become corrupted, causing Multi-User Mode problems. Create a new user profile on the affected computer and try accessing Multi-User Mode with the new profile.Recreate Network Data File: If none of the above solutions work, try recreating the network data file. Go to the computer hosting the company file, open QuickBooks Database Server Manager, and select “Start Scan.” This will recreate the network data file and might resolve the Multi-User Mode issue.Following these troubleshooting steps should help you resolve the Quickbooks Multi-User Mode Not Working After Update problem efficiently, ensuring smooth collaboration among users. If the issue persists, contacting QuickBooks support might be necessary for further assistance. Read More
How fix QuickBooks Crashing When Opening Company File after update?
Troubleshooting Solutions: QuickBooks Crashing When Opening Company File
Run QuickBooks File Doctor: QuickBooks File Doctor can diagnose and repair company file issues causing crashes. Download and run the tool from the QuickBooks website. Follow the on-screen instructions to scan and fix any detected problems.Update QuickBooks: Ensure you’re using the latest version of QuickBooks. Open QuickBooks and go to the Help menu. Select “Update QuickBooks Desktop” and install any available updates. Outdated software can lead to compatibility issues and crashes.Check for Windows Updates: Make sure your operating system is up to date with the latest Windows updates. Press Win + I to open the Settings app, then go to Update & Security > Windows Update and click “Check for updates.”Disable Compatibility Mode: Right-click the QuickBooks shortcut or executable file, select “Properties,” and go to the Compatibility tab. If “Run this program in compatibility mode” is checked, uncheck it. Compatibility mode can cause conflicts with modern operating systems.Verify Company File: Check if the company file is damaged or corrupted. Open QuickBooks and press Ctrl + O to open a company file. Select the company file and press Ctrl + F3 to run the Verify Data utility. Follow the prompts to check for and repair any data issues.Recreate QBWUSER.INI file: Close QuickBooks, press Win + R, type “%AppData%” (without quotes), and press Enter. Navigate to Intuit > QuickBooks (year) and locate the QBWUSER.INI file. Rename it to QBWUSER.INI.old and restart QuickBooks. A new QBWUSER.INI file will be created.Run QuickBooks Install Diagnostic Tool: Download and run the QuickBooks Install Diagnostic Tool from the QuickBooks website. This tool can resolve common installation issues and repair components that may be causing QuickBooks to crash.Disable Add-ons and Extensions: Third-party add-ons or extensions can sometimes conflict with QuickBooks and cause crashes. Disable all add-ons and extensions, then try opening the company file again. If QuickBooks opens without crashing, gradually re-enable each add-on to identify the problematic one.Create a New Windows User: User profile corruption can lead to QuickBooks crashes. Create a new Windows user account with administrative privileges. Log in with the new account and try opening the company file. If QuickBooks works fine, the original user profile may be corrupted.Contact QuickBooks Support: If the issue persists after trying the above solutions, contact QuickBooks customer support for further assistance. They can provide personalized troubleshooting steps and guidance based on your specific situation.
By following these troubleshooting steps, you should be able to resolve the issue of QuickBooks crashing when opening a company file and continue using the software smoothly.
Troubleshooting Solutions: QuickBooks Crashing When Opening Company File Run QuickBooks File Doctor: QuickBooks File Doctor can diagnose and repair company file issues causing crashes. Download and run the tool from the QuickBooks website. Follow the on-screen instructions to scan and fix any detected problems.Update QuickBooks: Ensure you’re using the latest version of QuickBooks. Open QuickBooks and go to the Help menu. Select “Update QuickBooks Desktop” and install any available updates. Outdated software can lead to compatibility issues and crashes.Check for Windows Updates: Make sure your operating system is up to date with the latest Windows updates. Press Win + I to open the Settings app, then go to Update & Security > Windows Update and click “Check for updates.”Disable Compatibility Mode: Right-click the QuickBooks shortcut or executable file, select “Properties,” and go to the Compatibility tab. If “Run this program in compatibility mode” is checked, uncheck it. Compatibility mode can cause conflicts with modern operating systems.Verify Company File: Check if the company file is damaged or corrupted. Open QuickBooks and press Ctrl + O to open a company file. Select the company file and press Ctrl + F3 to run the Verify Data utility. Follow the prompts to check for and repair any data issues.Recreate QBWUSER.INI file: Close QuickBooks, press Win + R, type “%AppData%” (without quotes), and press Enter. Navigate to Intuit > QuickBooks (year) and locate the QBWUSER.INI file. Rename it to QBWUSER.INI.old and restart QuickBooks. A new QBWUSER.INI file will be created.Run QuickBooks Install Diagnostic Tool: Download and run the QuickBooks Install Diagnostic Tool from the QuickBooks website. This tool can resolve common installation issues and repair components that may be causing QuickBooks to crash.Disable Add-ons and Extensions: Third-party add-ons or extensions can sometimes conflict with QuickBooks and cause crashes. Disable all add-ons and extensions, then try opening the company file again. If QuickBooks opens without crashing, gradually re-enable each add-on to identify the problematic one.Create a New Windows User: User profile corruption can lead to QuickBooks crashes. Create a new Windows user account with administrative privileges. Log in with the new account and try opening the company file. If QuickBooks works fine, the original user profile may be corrupted.Contact QuickBooks Support: If the issue persists after trying the above solutions, contact QuickBooks customer support for further assistance. They can provide personalized troubleshooting steps and guidance based on your specific situation.By following these troubleshooting steps, you should be able to resolve the issue of QuickBooks crashing when opening a company file and continue using the software smoothly. Read More
Import file as an array
Hi,
I have the following in a script that is working fine using the following:
$string = @ (“xxx”, “yyy”, “zzz”)
After I changed to the following that get from a file, it does not work:
$string = @()
$string += import-csv C:tempfile.csv
The content of file.csv
xxx
yyy
zzz
Can anyone advise how to resolve?
Hi, I have the following in a script that is working fine using the following:$string = @ (“xxx”, “yyy”, “zzz”) After I changed to the following that get from a file, it does not work:$string = @()$string += import-csv C:tempfile.csv The content of file.csvxxxyyyzzz Can anyone advise how to resolve? Read More
Microsoft Defender for Open-Source Relational Databases Now Supports Multicloud (AWS RDS)
Introduction:
Many organizations use multiple cloud providers today, which makes security misconfigurations more likely due to the solution scale and complexity. Moreover, different practices and concepts among each cloud provider’s implementation create bigger internal knowledge gaps.
No matter how many cloud providers an organization uses, a database is the core of each application, storing the organization’s most valuable data: PII, financial and payment information, medical information, and other sensitive data. This makes databases the most attractive attack target for any threat actor – from inside or outside.
Even though there is more awareness of exposure misconfigurations (thanks to cybersecurity education and posture management products that reveal these issues), public datasets show that the most risky database misconfiguration – exposing databases to the internet is not going down. This fact emphasizes the importance of threat protection that will act as a last line of defense and help detect, in near real-time, attacks that endanger databases and the critical data they contain.
Internet exposed databases count through time.
(Source: Time series · General statistics · The Shadowserver Foundation)
Announcement:
Microsoft Defender for open-source relational databases have been long focusing on providing comprehensive protection for Azure databases.
Today, we’re excited to announce another significant milestone in our cloud database security journey: Microsoft Defender for open-source relational databases plans now extend their protection to multicloud environments, starting with Amazon RDS on AWS. The workloads supported in AWS RDS are:
Aurora PostgreSQL
Aurora MySQL
PostgreSQL
MySQL
MariaDB
This release includes full parity with the alert types of support for managed Azure OSS databases:
Anomalous database access and query patterns – For example, a logon from a suspicious location or from a domain not seen in the past 60 days.
Suspicious database activities – For example, a user accessing a database service from a breached computer which communicated with a crypto-mining C&C server.
Brute-force attacks – With the ability to separate simple brute force attempt from a successful brute force.
Under public preview, you can turn on the Defender for open-source relational databases plan for AWS RDS at no cost. This marks a pivotal moment in our commitment to securing your business-critical data across cloud environments.
This announcement makes Microsoft the sole major security provider offering multicloud database protection, a significant step forward in building an end-to-end multicloud & Cloud native application protection platform (CNAPP).
Defender for Cloud stands out with its comprehensive approach, covering a diverse range of databases and leveraging Microsoft’s dual role as a cloud and security provider. This integration enables us to provide unparalleled scanning depth and real-time threat detection capabilities, enhancing security across multicloud environments.
This multicloud database protection announcement is part of Microsoft’s commitment to build a comprehensive Cloud Native Application Protection Platform (CNAPP). CNAPP integrates advanced data threat intelligence, , and data threat protection to provide in depth cloud data security insight and breadth of data security protection across various cloud platforms.
Microsoft’s CNAPP infographic
Features
You will now have full flexibility to mix and match the protection on your multicloud databases:
Protection layers for multicloud database protection
Foundational CSPM – Free out of the box (OOTB) control plane recommendations are generated once you connect your account to Microsoft Defender for Cloud.
Recommendations are evaluated and generated OOTB for all connected cloud environments.
Advanced posture management with Defender CSPM (DCSPM) – Discovers your databases, what types of sensitive data they contain and assesses risk to that data based on context gathered across all the clouds in the customer’s scope.
Misconfigurations and sensitive data are discovered and displayed as part of an attack path
Advanced threat protection with Defender for open-source relational databases – Provides threat protection by generating near real-time alerts based on suspicious and anomalous access patterns to your databases.
Attack path also highlights active attack on the vulnerable resources
MDC lists the alert history on the resource we can see brute force attacks, connections from harmful applications and more
Brute force attack detected from an IP that was reported as a Tor exit node
Finally, Microsoft Defender for Cloud offers seamless integration with Defender XDR, which offers enhanced threat detection and response capabilities. It’s crucial for organizations to adopt both Defender for Cloud and Defender XDR personas to effectively manage and mitigate security risks across their multicloud environments.
Defender XDR identified an incident where the same IP tried to brute force cloud databases in AWS and Azure
Sensitive data discovery is built-in!
Defender for open-source databases on AWS will be the first database threat protection plan to bundle sensitive data discovery as part of its core value, without depending on other plans (such as DCSPM) or incur additional costs. Once the plan is enabled the discovery process will be scheduled weekly and you will be able to consume the findings in all the main MDC experiences:
Alerts – filter alerts by resources with findings, alert page enrichment
Inventory – filter resources with findings
Resource health – enrichment with findings
Security explorer (new!) – You will also be able to query the findings using security explorer even without enabling DCSPM.
Only findings’ data will be queryable – other pieces of context require enabling DCSPM.
Conclusion
In conclusion, Microsoft Defender for open-source relational databases now support multicloud database protections in AWS RDS environments. This change signifies a pivotal advancement in cloud security. Through its holistic approach embodied by CNAPP, Microsoft empowers organizations to safeguard their critical data assets consistently across diverse cloud platforms.
Resources:
To learn more about Defender for Cloud, click here.
Read about Defender for open-source relational databases documentation here.
Read about sensitive data discovery.
Defender for open-source relational databases alerts reference.
Start free trial here.
Microsoft Tech Community – Latest Blogs –Read More
Windows server 2022 failover cluster
In a single Windows Failover cluster of 4 nodes can we have different storage for two nodes and for other two nodes different storage is it possible or not?
In a single Windows Failover cluster of 4 nodes can we have different storage for two nodes and for other two nodes different storage is it possible or not? Read More
Outlook changes the “Modified” field when moving/copying a Contact.
Hi friends!
I use Outlook 2021.
When I copy/move a Contact item from one Contacts folder to another Contacts folder, the “Modified” field gets updated to the current date. I don’t modify the Contact itself… I only move it or copy it.
Is there a way to keep the “Modified” field unchanged?
Thank you for your help,
Martin
Hi friends!I use Outlook 2021.When I copy/move a Contact item from one Contacts folder to another Contacts folder, the “Modified” field gets updated to the current date. I don’t modify the Contact itself… I only move it or copy it.Is there a way to keep the “Modified” field unchanged?Thank you for your help,Martin Read More
Unlink OneDrive account from PC
Hi Team,
Is there a way to automate the process of unlinking of OneDrive account?
As for 1-2 accounts, we perform manual steps: open the OneDrive settings, go to the account tab, and click Unlink this PC.
But for thousands Laptops/desktop we don’t want our techs to have to do the same. The idea is to stop the sync, unlink the account from this PC and from explorer remove OneDrive.
Hi Team,Is there a way to automate the process of unlinking of OneDrive account?As for 1-2 accounts, we perform manual steps: open the OneDrive settings, go to the account tab, and click Unlink this PC.But for thousands Laptops/desktop we don’t want our techs to have to do the same. The idea is to stop the sync, unlink the account from this PC and from explorer remove OneDrive. Read More
Surface Pro 7 not booting off USB for Ubuntu install
Hi all.
I’ve got a Surface Pro 7 that’s getting a bit long in the tooth. I’ve read that various Linux distros run well on it. Ubuntu in particular has quite a few detailed set-up guides. So I decided to give it a shot.
The problem is, the Surface won’t boot from a USB key. The UEFI/BIOS is set to boot from USB first, before anything else. I’ve tried:
— 5 different USB keys (various sizes (apparently 64GB don’t work) from 32GB down to 8)
— writing the Ubuntu ISO to the key using balenaEtcher, Rufus, and the dd command from a command prompt in a Linux virtual machine.
— setting the security setting in the Surface’s UEFI/BIOS to off and third party (not Microsoft Only)
— turned off all other boot devices, so that it ONLY tries booting from the USB
— openSUSE Tumbleweed instead of Ubuntu
— Windows 11 (for poops and giggles, just to see) instead of Linux
— turned on the Surface normally, and while holding the down volume button.
Nothing works. It just sits there with the white Surface/Windows logo on a black screen, like it’s mockingly judging me, until I eventually turn it off. I’ve left it like that for as long as an hour, just to see if the trhing would figure out what I wanted it do do.
How on earth to I get the thing to actually boot off USB and into the Ubuntu installer?
Hi all. I’ve got a Surface Pro 7 that’s getting a bit long in the tooth. I’ve read that various Linux distros run well on it. Ubuntu in particular has quite a few detailed set-up guides. So I decided to give it a shot. The problem is, the Surface won’t boot from a USB key. The UEFI/BIOS is set to boot from USB first, before anything else. I’ve tried: — 5 different USB keys (various sizes (apparently 64GB don’t work) from 32GB down to 8)– writing the Ubuntu ISO to the key using balenaEtcher, Rufus, and the dd command from a command prompt in a Linux virtual machine.– setting the security setting in the Surface’s UEFI/BIOS to off and third party (not Microsoft Only)– turned off all other boot devices, so that it ONLY tries booting from the USB– openSUSE Tumbleweed instead of Ubuntu– Windows 11 (for poops and giggles, just to see) instead of Linux– turned on the Surface normally, and while holding the down volume button. Nothing works. It just sits there with the white Surface/Windows logo on a black screen, like it’s mockingly judging me, until I eventually turn it off. I’ve left it like that for as long as an hour, just to see if the trhing would figure out what I wanted it do do. How on earth to I get the thing to actually boot off USB and into the Ubuntu installer? Read More