Category: Microsoft
Category Archives: Microsoft
SUM Employees using condition formula
HI
I have an issue with one formula. I created a formula to know the number of projects i have within a FY
Definition of project:
IF SAME CUSTOMER, IF SAME COUNTRY and Same GO Live Date = 1, otherwise 0
I custom sorted my file with Customer, Country and Go lIve Date and used the formula below comparing previous row.
=IF(B2<>B3,1,IF(AND(B2=B3,BE2<>BE3),1,IF(AND(B2=B3,D2=D3,BE2=BE3),0,1)))
I have a column called Contract EE (Employees) and I have been asked to filter projects with max 50employees, 100 employees and + 100 employees but I am struggling to add this SUM in my formula. Any help? What I need is the image below showing number of employees for every count of “1” using the formula with the 3 conditions.
Client NameCIDCountryContract EEOps Forecast & ActualsNum of Projects EE SizeCustomer A010002United States209/1/202203 conditions = 1 Project300Customer A010002United States2809/1/20221Customer B010022Sweden405/1/20241 40Customer C010038Egypt604/1/20241 60Customer D010047Singapore337/1/20221 33Customer E010072Spain13/1/20241 1Customer F010109Austria758/1/20221 75Customer G010109Brazil2006/1/202303 conditions = 1 Project358Customer G010109Brazil1506/1/20230Customer G010109Brazil86/1/20231
HI I have an issue with one formula. I created a formula to know the number of projects i have within a FY Definition of project:IF SAME CUSTOMER, IF SAME COUNTRY and Same GO Live Date = 1, otherwise 0 I custom sorted my file with Customer, Country and Go lIve Date and used the formula below comparing previous row. =IF(B2<>B3,1,IF(AND(B2=B3,BE2<>BE3),1,IF(AND(B2=B3,D2=D3,BE2=BE3),0,1))) I have a column called Contract EE (Employees) and I have been asked to filter projects with max 50employees, 100 employees and + 100 employees but I am struggling to add this SUM in my formula. Any help? What I need is the image below showing number of employees for every count of “1” using the formula with the 3 conditions. Client NameCIDCountryContract EEOps Forecast & ActualsNum of Projects EE SizeCustomer A010002United States209/1/202203 conditions = 1 Project300Customer A010002United States2809/1/20221Customer B010022Sweden405/1/20241 40Customer C010038Egypt604/1/20241 60Customer D010047Singapore337/1/20221 33Customer E010072Spain13/1/20241 1Customer F010109Austria758/1/20221 75Customer G010109Brazil2006/1/202303 conditions = 1 Project358Customer G010109Brazil1506/1/20230Customer G010109Brazil86/1/20231 Read More
Microsoft Cloud Exceeds 50% of Microsoft Total Revenues
The Microsoft FY24 Q3 results didn’t contain any new user numbers for Office 365 or Teams. However, we did learn that Copilot and Azure are popular words in the Microsoft lexicon. As usual, statistics were introduced without context, but investors won’t really care too much as Microsoft continues to generate tons of revenue at a healthy margin, especially from its cloud business.
https://office365itpros.com/2024/04/26/microsoft-fy24-q3-results/
The Microsoft FY24 Q3 results didn’t contain any new user numbers for Office 365 or Teams. However, we did learn that Copilot and Azure are popular words in the Microsoft lexicon. As usual, statistics were introduced without context, but investors won’t really care too much as Microsoft continues to generate tons of revenue at a healthy margin, especially from its cloud business.
https://office365itpros.com/2024/04/26/microsoft-fy24-q3-results/ Read More
Sharing screens giving 2 flashing black bars at the top and bottom of the shared content?
When sharing the recipients screen will have 2 bars at the bottom and top of the shared content which are continuously flashing.
I have tried clearing the cache, and even going as far to remove and reinstall teams to no avail.
This is something affecting multiple issues in our organisation
When sharing the recipients screen will have 2 bars at the bottom and top of the shared content which are continuously flashing.I have tried clearing the cache, and even going as far to remove and reinstall teams to no avail.This is something affecting multiple issues in our organisation Read More
Viva Learning as an activity source
Hello,I’m exploring options to create a custom learning management system for my company. The first thing I would like to do is to pull data from Microsoft Viva Learning via the Microsoft Graph API, for example to see which courses the employees have completed. The next step will be to write that data on a SharePoint site. However, the use cases described in the docs seem to implicate that the data should only flow from the LMS to Viva, and not in the opposite direction. Since Viva Learning has a UI for searching for and completing courses, I would like to use that activity data into my custom LMS. Is this use case possible and does it make sense?Thank you in advance Read More
Only browser activities can be found in Activity Log for Conditional Access App control App
We have add Deskbird into Microsoft Defender for Cloud Apps via Entra ID CA policy, and it is listed in MDCA – Cloud apps – Activity log now. However, we found only the activities via web browser were logged, the activities trigged from mobile Apps are not. But those activities can be found in Sign-in Logs from Azure enterprise application portal.
How to make MDCA receive all activities include both browser and App? We want to setup access control policy, without the visibility to Mobile App activities, the policy can’t cover all scenarios.
We have add Deskbird into Microsoft Defender for Cloud Apps via Entra ID CA policy, and it is listed in MDCA – Cloud apps – Activity log now. However, we found only the activities via web browser were logged, the activities trigged from mobile Apps are not. But those activities can be found in Sign-in Logs from Azure enterprise application portal. How to make MDCA receive all activities include both browser and App? We want to setup access control policy, without the visibility to Mobile App activities, the policy can’t cover all scenarios. Read More
Need Help in Project Operations connection with Project for Web
Can anyone suggest which Environment they are using in Dynamics 365 to use Project operations, is it CDS or CRM?
or Does anyone knows how we can connect Project for Web and Dynamics 365 project Operations to see Projects and Tasks??
Can anyone suggest which Environment they are using in Dynamics 365 to use Project operations, is it CDS or CRM?or Does anyone knows how we can connect Project for Web and Dynamics 365 project Operations to see Projects and Tasks?? Read More
How to fix QuickBooks error 3371 status code 11118 windows 11?
Troubleshooting Solutions: QuickBooks error 3371 status code 11118
QuickBooks error 3371 with status code 11118 is a common issue that can occur due to various reasons, such as damaged or missing QuickBooks components, issues with the Windows operating system, or problems with the QuickBooks license. Here are some troubleshooting steps to resolve QuickBooks error 3371 status code 11118:
Update Windows Operating System: Ensure that your Windows operating system is up to date. Outdated Windows versions may lack necessary updates and patches, leading to compatibility issues with QuickBooks. Go to Settings > Update & Security > Windows Update to check for and install any available updates.Install QuickBooks Tool Hub: Download and install the QuickBooks Tool Hub, a collection of tools designed to diagnose and fix common QuickBooks errors. Open the Tool Hub and select the “Installation Issues” tab. Run the Quick Fix my Program tool to resolve issues related to QuickBooks installation, including error 3371 status code 11118.Recreate EntitlementDataStore.ecml File: The EntitlementDataStore.ecml file contains information about your QuickBooks license and registration details. Deleting and recreating this file can resolve error 3371 status code 11118. Close QuickBooks and navigate to C:ProgramDataIntuitEntitlement Clientv8. Delete the EntitlementDataStore.ecml file, then reopen QuickBooks to automatically recreate the file.Update QuickBooks: Ensure that you are using the latest version of QuickBooks. Outdated software versions may contain bugs or compatibility issues that trigger error 3371 status code 11118. Open QuickBooks and go to Help > Update QuickBooks to check for and install any available updates.Run QuickBooks Diagnostic Tool: Download and run the QuickBooks Install Diagnostic Tool to identify and fix issues related to QuickBooks installation. This tool automatically scans and repairs common installation problems, including error 3371 status code 11118. After running the diagnostic tool, restart your computer and try opening QuickBooks again.Manually Resolve Microsoft.NET Framework Issues: QuickBooks error 3371 status code 11118 may occur due to issues with Microsoft.NET Framework, a software framework required for QuickBooks to function properly. Repair or reinstall Microsoft.NET Framework by following the instructions provided by Microsoft on their official website.Contact QuickBooks Support: If none of the above troubleshooting steps resolve the issue, contact QuickBooks customer support for further assistance. QuickBooks experts can provide personalized support and guidance to help you troubleshoot and resolve error 3371 status code 11118, ensuring that you can resume using QuickBooks without interruptions.
By following these troubleshooting solutions, you can effectively resolve QuickBooks error 3371 status code 11118 and get back to using QuickBooks smoothly for your accounting and financial management tasks. Regularly updating QuickBooks and maintaining your system’s software can help prevent such errors in the future, ensuring seamless operation of the software for your business needs.
Troubleshooting Solutions: QuickBooks error 3371 status code 11118 QuickBooks error 3371 with status code 11118 is a common issue that can occur due to various reasons, such as damaged or missing QuickBooks components, issues with the Windows operating system, or problems with the QuickBooks license. Here are some troubleshooting steps to resolve QuickBooks error 3371 status code 11118: Update Windows Operating System: Ensure that your Windows operating system is up to date. Outdated Windows versions may lack necessary updates and patches, leading to compatibility issues with QuickBooks. Go to Settings > Update & Security > Windows Update to check for and install any available updates.Install QuickBooks Tool Hub: Download and install the QuickBooks Tool Hub, a collection of tools designed to diagnose and fix common QuickBooks errors. Open the Tool Hub and select the “Installation Issues” tab. Run the Quick Fix my Program tool to resolve issues related to QuickBooks installation, including error 3371 status code 11118.Recreate EntitlementDataStore.ecml File: The EntitlementDataStore.ecml file contains information about your QuickBooks license and registration details. Deleting and recreating this file can resolve error 3371 status code 11118. Close QuickBooks and navigate to C:ProgramDataIntuitEntitlement Clientv8. Delete the EntitlementDataStore.ecml file, then reopen QuickBooks to automatically recreate the file.Update QuickBooks: Ensure that you are using the latest version of QuickBooks. Outdated software versions may contain bugs or compatibility issues that trigger error 3371 status code 11118. Open QuickBooks and go to Help > Update QuickBooks to check for and install any available updates.Run QuickBooks Diagnostic Tool: Download and run the QuickBooks Install Diagnostic Tool to identify and fix issues related to QuickBooks installation. This tool automatically scans and repairs common installation problems, including error 3371 status code 11118. After running the diagnostic tool, restart your computer and try opening QuickBooks again.Manually Resolve Microsoft.NET Framework Issues: QuickBooks error 3371 status code 11118 may occur due to issues with Microsoft.NET Framework, a software framework required for QuickBooks to function properly. Repair or reinstall Microsoft.NET Framework by following the instructions provided by Microsoft on their official website.Contact QuickBooks Support: If none of the above troubleshooting steps resolve the issue, contact QuickBooks customer support for further assistance. QuickBooks experts can provide personalized support and guidance to help you troubleshoot and resolve error 3371 status code 11118, ensuring that you can resume using QuickBooks without interruptions.By following these troubleshooting solutions, you can effectively resolve QuickBooks error 3371 status code 11118 and get back to using QuickBooks smoothly for your accounting and financial management tasks. Regularly updating QuickBooks and maintaining your system’s software can help prevent such errors in the future, ensuring seamless operation of the software for your business needs. Read More
Dynamic Approval Workflow based on Serial Number
Generated a form for disposing of scrap in Power Apps, indicating that I wish to develop a dynamic approval flow in power automate.
Integrated with SharePoint .
Approval Levels are dependent on departments; for example, RS D4 two level set, for RS D1 one level permission set, and similarly levels are set to departments in department table.
In that form, the serial number is generated by Power Apps . For a single serial number, multiple items can be added, and the department should remain constant since only one department can be selected.
for example if i made entry generated serial number is 1 then for 1 multiple items can added like for 1 we cab add 4 items for RS D1 department .
Department should not fluctuate after a department is chosen; we cant add multiple department for a single serial number . new department entry should be created with new serial number .
Based on each serial number, the approval request should be sent to the appropriate approver. Instead of triggering for every item or record, the approval request should only be sent to the approver once for each item created for that serial number.
Thus, what can we do in this scenario and what kind of condition and action can we apply?
please suggest flow……!!!!
Details:-
Sharing snap of Disposal Form
Disposal_table is main table
Department table is set to Level department wise
Generated a form for disposing of scrap in Power Apps, indicating that I wish to develop a dynamic approval flow in power automate.Integrated with SharePoint .Approval Levels are dependent on departments; for example, RS D4 two level set, for RS D1 one level permission set, and similarly levels are set to departments in department table.In that form, the serial number is generated by Power Apps . For a single serial number, multiple items can be added, and the department should remain constant since only one department can be selected.for example if i made entry generated serial number is 1 then for 1 multiple items can added like for 1 we cab add 4 items for RS D1 department .Department should not fluctuate after a department is chosen; we cant add multiple department for a single serial number . new department entry should be created with new serial number .Based on each serial number, the approval request should be sent to the appropriate approver. Instead of triggering for every item or record, the approval request should only be sent to the approver once for each item created for that serial number.Thus, what can we do in this scenario and what kind of condition and action can we apply?please suggest flow……!!!! Details:-Sharing snap of Disposal Form Disposal_table is main table Department table is set to Level department wise Read More
Unable to import files to smss
===================================
This wizard will close because it encountered the following error: (Microsoft SQL Server)
——————————
For help, click: https://go.microsoft.com:80/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=16.0.5491.4&Evtsrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476
===================================
The ConnectionString property has not been initialized. (System.Data)
——————————
Program Location:
at System.Data.Odbc.OdbcConnection.PermissionDemand()
at System.Data.Odbc.OdbcConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetOpenedConnection(WizardInputs wizardInputs, String connEntryName)
at Microsoft.SqlServer.Dts.DtsWizard.TransformInfo.PopulateMetadata(WizardInputs wizardInputs)
at Microsoft.SqlServer.Dts.DtsWizard.StepFlatFileTables.OnLeavePage(LeavePageEventArgs e)
at Microsoft.SqlServer.Management.UI.WizardPage.RaiseLeavePage(WizardButton button)
at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage nextPage)
at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender, EventArgs e)
===================================This wizard will close because it encountered the following error: (Microsoft SQL Server)——————————For help, click: https://go.microsoft.com:80/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=16.0.5491.4&Evtsrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476===================================The ConnectionString property has not been initialized. (System.Data)——————————Program Location:at System.Data.Odbc.OdbcConnection.PermissionDemand()at System.Data.Odbc.OdbcConnectionFactory.PermissionDemand(DbConnection outerConnection)at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)at System.Data.Odbc.OdbcConnection.Open()at Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetOpenedConnection(WizardInputs wizardInputs, String connEntryName)at Microsoft.SqlServer.Dts.DtsWizard.TransformInfo.PopulateMetadata(WizardInputs wizardInputs)at Microsoft.SqlServer.Dts.DtsWizard.StepFlatFileTables.OnLeavePage(LeavePageEventArgs e)at Microsoft.SqlServer.Management.UI.WizardPage.RaiseLeavePage(WizardButton button)at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage nextPage)at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender, EventArgs e) Read More
How fix QuickBooks error 3371 status code 11118 windows 10?
Troubleshooting Solutions: QuickBooks error 3371 status code 11118
QuickBooks error 3371 with status code 11118 typically indicates an issue with the software’s licensing information. It can occur due to various reasons such as damaged or missing files, outdated Windows components, or issues with the QuickBooks license. Here’s how you can troubleshoot and resolve this error:
Update Windows Operating System: Ensure your Windows operating system is up to date. Go to Settings > Update & Security > Windows Update and check for any available updates. Installing the latest updates can resolve compatibility issues that may trigger error 3371.Install QuickBooks Tool Hub: Download and install the QuickBooks Tool Hub, a diagnostic tool designed to fix common QuickBooks errors. Open the Tool Hub, go to the “Installation Issues” tab, and run the Quick Fix my Program tool. This tool can repair issues related to QuickBooks installation, including error 3371.Recreate EntitlementDataStore.ecml File: This file stores your QuickBooks license information. Deleting and recreating it can resolve licensing-related errors. Close QuickBooks, navigate to C:ProgramDataIntuitEntitlement Clientv8, and delete the EntitlementDataStore.ecml file. Afterward, reopen QuickBooks, and the file will be recreated automatically.Update QuickBooks: Ensure you’re using the latest version of QuickBooks. Open QuickBooks, go to Help > Update QuickBooks, and check for updates. If updates are available, install them. Updating QuickBooks can resolve bugs and compatibility issues that may trigger error 3371.Run QuickBooks Diagnostic Tool: Download and run the QuickBooks Install Diagnostic Tool from the QuickBooks website. This tool can automatically detect and fix a wide range of installation-related issues, including error 3371. After running the tool, restart your computer and try opening QuickBooks again.Repair or Reinstall Microsoft .NET Framework: QuickBooks relies on Microsoft .NET Framework to function properly. Issues with .NET Framework can trigger error 3371. You can repair or reinstall .NET Framework using the Microsoft .NET Framework Repair Tool or by downloading the latest version from the Microsoft website.Contact QuickBooks Support: If the above solutions don’t resolve the error, reach out to QuickBooks customer support for further assistance. They have specialized tools and expertise to help you troubleshoot and fix complex QuickBooks errors like 3371 status code 11118.
By following these troubleshooting steps, you can resolve QuickBooks error 3371 status code 11118 and resume using QuickBooks without any disruptions. Regularly updating QuickBooks and your system’s software can help prevent similar errors in the future, ensuring smooth operation of the software for your business needs.
Troubleshooting Solutions: QuickBooks error 3371 status code 11118 QuickBooks error 3371 with status code 11118 typically indicates an issue with the software’s licensing information. It can occur due to various reasons such as damaged or missing files, outdated Windows components, or issues with the QuickBooks license. Here’s how you can troubleshoot and resolve this error: Update Windows Operating System: Ensure your Windows operating system is up to date. Go to Settings > Update & Security > Windows Update and check for any available updates. Installing the latest updates can resolve compatibility issues that may trigger error 3371.Install QuickBooks Tool Hub: Download and install the QuickBooks Tool Hub, a diagnostic tool designed to fix common QuickBooks errors. Open the Tool Hub, go to the “Installation Issues” tab, and run the Quick Fix my Program tool. This tool can repair issues related to QuickBooks installation, including error 3371.Recreate EntitlementDataStore.ecml File: This file stores your QuickBooks license information. Deleting and recreating it can resolve licensing-related errors. Close QuickBooks, navigate to C:ProgramDataIntuitEntitlement Clientv8, and delete the EntitlementDataStore.ecml file. Afterward, reopen QuickBooks, and the file will be recreated automatically.Update QuickBooks: Ensure you’re using the latest version of QuickBooks. Open QuickBooks, go to Help > Update QuickBooks, and check for updates. If updates are available, install them. Updating QuickBooks can resolve bugs and compatibility issues that may trigger error 3371.Run QuickBooks Diagnostic Tool: Download and run the QuickBooks Install Diagnostic Tool from the QuickBooks website. This tool can automatically detect and fix a wide range of installation-related issues, including error 3371. After running the tool, restart your computer and try opening QuickBooks again.Repair or Reinstall Microsoft .NET Framework: QuickBooks relies on Microsoft .NET Framework to function properly. Issues with .NET Framework can trigger error 3371. You can repair or reinstall .NET Framework using the Microsoft .NET Framework Repair Tool or by downloading the latest version from the Microsoft website.Contact QuickBooks Support: If the above solutions don’t resolve the error, reach out to QuickBooks customer support for further assistance. They have specialized tools and expertise to help you troubleshoot and fix complex QuickBooks errors like 3371 status code 11118.By following these troubleshooting steps, you can resolve QuickBooks error 3371 status code 11118 and resume using QuickBooks without any disruptions. Regularly updating QuickBooks and your system’s software can help prevent similar errors in the future, ensuring smooth operation of the software for your business needs. Read More
Crypto Login Issues +1(818) 725 1009 Why can’t I login my Crypto?
If you are unable to log in it may be due to:
Incorrect email address – Type in the email address that you used to register with;
Incorrect SMS Verification code – Re-send the SMS Verification code and try again;
New Phone Number – Didn’t receive a code? Change your phone number.
Incorrect Passcode – Type in your passcode. If you need to reset it. Call For Help: +1(818) 725 1009
Invalid or expired Magic Link – Click on the latest link or send a new one and try again.
If you are unable to log in it may be due to:Incorrect email address – Type in the email address that you used to register with;Incorrect SMS Verification code – Re-send the SMS Verification code and try again;New Phone Number – Didn’t receive a code? Change your phone number.Incorrect Passcode – Type in your passcode. If you need to reset it. Call For Help: +1(818) 725 1009Invalid or expired Magic Link – Click on the latest link or send a new one and try again. Read More
Outlook unable to reply/forward encrypt-only email.
Hi,
I was unable to reply or forward to email I received with encrypt-only permission. Received error message “Microsoft Outlook was not able to create message with restricted permission”. This only happen this week. I was able to reply/forward this kind of email last week. This only happen using 1 device of windows Microsoft Outlook application. I’ve tried using mac, web outlook, new outlook & other device and it was working fine.
Here some troubleshoot I have done.
– Update Microsoft Application.
– Windows Update.
– Clear all Outlook profile cache and create new profile.
– Microsoft 365 quick repair & online repair.
Appreciated if anyone could help me.
Thank you.
Hi, I was unable to reply or forward to email I received with encrypt-only permission. Received error message “Microsoft Outlook was not able to create message with restricted permission”. This only happen this week. I was able to reply/forward this kind of email last week. This only happen using 1 device of windows Microsoft Outlook application. I’ve tried using mac, web outlook, new outlook & other device and it was working fine.Here some troubleshoot I have done.- Update Microsoft Application.- Windows Update.- Clear all Outlook profile cache and create new profile.- Microsoft 365 quick repair & online repair.Appreciated if anyone could help me.Thank you. Read More
Sentinel Playbook: Lock suspicious User Account
Hello toghether,
I hope somebody had the same Use case.
In Sentinel I like to run an Playbook which lock an User in the Azure (Cloud) and on Prem (AD), after an Analytic rule has triggerd / found suspicious activity.
Best regards
Kevin
Hello toghether, I hope somebody had the same Use case. In Sentinel I like to run an Playbook which lock an User in the Azure (Cloud) and on Prem (AD), after an Analytic rule has triggerd / found suspicious activity. Best regards Kevin Read More
How to fix QuickBooks desktop 2024 keeps crashing after update?
Troubleshooting Solutions: QuickBooks desktop 2024 keeps crashing
Experiencing frequent crashes in QuickBooks Desktop 2024 can be frustrating. Here’s a comprehensive guide to troubleshoot and resolve this issue:
Update QuickBooks: Ensure that QuickBooks Desktop is updated to the latest version. Updates often include bug fixes and stability improvements that can address crashing issues.
Check System Requirements: Verify that your computer meets the minimum system requirements for running QuickBooks Desktop 2024. Inadequate hardware or software specifications can lead to instability and crashes.
Review Company File Size: Large company files can strain system resources and cause crashes. Consider condensing or archiving old data to reduce the file size and improve performance.
Run QuickBooks File Doctor: Use the QuickBooks File Doctor tool to diagnose and repair common data-related issues that may be contributing to crashes.
Disable Antivirus/Firewall: Temporarily disable your antivirus or firewall software and see if QuickBooks continues to crash. Sometimes, security software can interfere with the application’s operation.
Check for Data Corruption: Perform a data integrity check using the Verify Data utility within QuickBooks. If corruption is detected, attempt to rebuild the company file to resolve issues causing crashes.
Update Drivers and Software: Ensure that your computer’s drivers (especially graphics and audio drivers) and other software are up-to-date. Outdated drivers or conflicting software can trigger crashes in QuickBooks.
Restart QuickBooks and Computer: Close QuickBooks and restart both the application and your computer. This simple step can often resolve temporary glitches that lead to crashes.
Check Event Viewer for Errors: Use the Event Viewer tool in Windows to check for any error messages or events related to QuickBooks crashes. These logs can provide valuable insight into the root cause of the issue.
Recreate Preferences File: Corrupted preferences files can cause instability in QuickBooks. Rename the QBWUSER.INI file to QBWUSER.INI.old to create a new preferences file and see if it resolves the crashing problem.
Perform Clean Installation: Uninstall QuickBooks Desktop completely and then reinstall it using a clean installation method. This ensures that any corrupted files or settings are removed.
Contact QuickBooks Support: If none of the above solutions resolve the issue, contact QuickBooks customer support for further assistance. They can provide personalized troubleshooting and escalate the issue if necessary.
By following these troubleshooting solutions, you should be able to identify and resolve the frequent QuickBooks desktop 2024 keeps crashing, allowing you to work smoothly without interruptions. Remember to regularly backup your company file to prevent data loss in case of unexpected crashes.
Troubleshooting Solutions: QuickBooks desktop 2024 keeps crashing Experiencing frequent crashes in QuickBooks Desktop 2024 can be frustrating. Here’s a comprehensive guide to troubleshoot and resolve this issue: Update QuickBooks: Ensure that QuickBooks Desktop is updated to the latest version. Updates often include bug fixes and stability improvements that can address crashing issues.Check System Requirements: Verify that your computer meets the minimum system requirements for running QuickBooks Desktop 2024. Inadequate hardware or software specifications can lead to instability and crashes.Review Company File Size: Large company files can strain system resources and cause crashes. Consider condensing or archiving old data to reduce the file size and improve performance.Run QuickBooks File Doctor: Use the QuickBooks File Doctor tool to diagnose and repair common data-related issues that may be contributing to crashes.Disable Antivirus/Firewall: Temporarily disable your antivirus or firewall software and see if QuickBooks continues to crash. Sometimes, security software can interfere with the application’s operation.Check for Data Corruption: Perform a data integrity check using the Verify Data utility within QuickBooks. If corruption is detected, attempt to rebuild the company file to resolve issues causing crashes.Update Drivers and Software: Ensure that your computer’s drivers (especially graphics and audio drivers) and other software are up-to-date. Outdated drivers or conflicting software can trigger crashes in QuickBooks.Restart QuickBooks and Computer: Close QuickBooks and restart both the application and your computer. This simple step can often resolve temporary glitches that lead to crashes.Check Event Viewer for Errors: Use the Event Viewer tool in Windows to check for any error messages or events related to QuickBooks crashes. These logs can provide valuable insight into the root cause of the issue.Recreate Preferences File: Corrupted preferences files can cause instability in QuickBooks. Rename the QBWUSER.INI file to QBWUSER.INI.old to create a new preferences file and see if it resolves the crashing problem.Perform Clean Installation: Uninstall QuickBooks Desktop completely and then reinstall it using a clean installation method. This ensures that any corrupted files or settings are removed.Contact QuickBooks Support: If none of the above solutions resolve the issue, contact QuickBooks customer support for further assistance. They can provide personalized troubleshooting and escalate the issue if necessary.By following these troubleshooting solutions, you should be able to identify and resolve the frequent QuickBooks desktop 2024 keeps crashing, allowing you to work smoothly without interruptions. Remember to regularly backup your company file to prevent data loss in case of unexpected crashes. Read More
Creating a finance calculator
Hi all, I work in the finance industry and I want to create a calculator to assist in working how much brokerage / commission is earnt on each transaction.
The commission we earn is based on a percentage of the loan amount which is easy enough to do. What I need to do is reverse engineer what the commission is based on certain criteria.
As an example, I know the following.
Loan amount: $18,950.00.Term: 5 yearsMonthly repayments (original): $430.35Interest rate to the customer is 13.41%.
I now need to calculate what the commission is based on.
Other than the interest rates the above parameters remain the same.The interest rate is now 9.95%I need to reverse calculate what commission I would get based on receiving the commission upfront.
In summary, assuming the loan term, repayments and amount stay the same and the only thing that changes is the interest rate, what would be my commission is it was paid to me upfront.
Notes, I have used an 3rd party software tool to establish that the commission would be 7.1777%, I just cant do it in excel.
Asny help would be greatly appreciated.
Hi all, I work in the finance industry and I want to create a calculator to assist in working how much brokerage / commission is earnt on each transaction. The commission we earn is based on a percentage of the loan amount which is easy enough to do. What I need to do is reverse engineer what the commission is based on certain criteria.As an example, I know the following.Loan amount: $18,950.00.Term: 5 yearsMonthly repayments (original): $430.35Interest rate to the customer is 13.41%. I now need to calculate what the commission is based on.Other than the interest rates the above parameters remain the same.The interest rate is now 9.95%I need to reverse calculate what commission I would get based on receiving the commission upfront. In summary, assuming the loan term, repayments and amount stay the same and the only thing that changes is the interest rate, what would be my commission is it was paid to me upfront.Notes, I have used an 3rd party software tool to establish that the commission would be 7.1777%, I just cant do it in excel. Asny help would be greatly appreciated. Read More
Different AVD Gateway Region
I have one query our all AVD servers are in Central India Location and all users are working office in same location but still you can see in above snapshot gateway is showing different different so any idea about that
I have one query our all AVD servers are in Central India Location and all users are working office in same location but still you can see in above snapshot gateway is showing different different so any idea about that Read More
Avoid Duplication
Hi can someboday please help?
I am working in Sheet 2 in Column A and I am copying entries from Sheet 1 in column A by pressing “=” in Column A of Sheet 2 so all data from Sheet1 column A is coming to sheet 2 colum A.
By doing so I want to avoid duplicate entry in sheet 2 column A.
How I can do so please?
Hi can someboday please help? I am working in Sheet 2 in Column A and I am copying entries from Sheet 1 in column A by pressing “=” in Column A of Sheet 2 so all data from Sheet1 column A is coming to sheet 2 colum A. By doing so I want to avoid duplicate entry in sheet 2 column A. How I can do so please? Read More
Color display issues
The computer system is on win11 version 23h2. in some apps (e.g. Steam) the white color shows up as yellow on the only monitor. Tried changing the HDR settings but it doesn’t work. It only goes back to normal when uninstalling the graphic card.
Please advise, thanks!
The computer system is on win11 version 23h2. in some apps (e.g. Steam) the white color shows up as yellow on the only monitor. Tried changing the HDR settings but it doesn’t work. It only goes back to normal when uninstalling the graphic card.Please advise, thanks! Read More
Intune not found
Hi,
I was about to enable Intune Connection but it says that a Intune license was not found. The customer has Microsoft 365 Business Premium which include Intune. Is their any other prerequisites needed or is there something else that i’m missing?
Hi, I was about to enable Intune Connection but it says that a Intune license was not found. The customer has Microsoft 365 Business Premium which include Intune. Is their any other prerequisites needed or is there something else that i’m missing? Read More
Authenticator app not working
I am the admin of my organization and I cleared my computer’s cache and it asked me to log in again to my professional account. Once I entered the email and password, it told me to write a code in the authentication app, but the app does not give me any option to enter the digit of two numbers, in fact it asks me to enter my account and from the same app it asks me to enter the two-digit code in the app, which has no sense. Since it is a professional account, the only option to log in is to use the authenticator app, either by typing in the app the two-digit code that appears on the computer or by typing a six-digit digit on the computer that should appear on the application, which does not happen.
I am the admin of my organization and I cleared my computer’s cache and it asked me to log in again to my professional account. Once I entered the email and password, it told me to write a code in the authentication app, but the app does not give me any option to enter the digit of two numbers, in fact it asks me to enter my account and from the same app it asks me to enter the two-digit code in the app, which has no sense. Since it is a professional account, the only option to log in is to use the authenticator app, either by typing in the app the two-digit code that appears on the computer or by typing a six-digit digit on the computer that should appear on the application, which does not happen. Read More