ORIGINAL REPORTS SETUP BY PREVIOUS EMPLOYEE

kelper62 · ‎March 06, 2023

I was not the person who setup QB when the company started in 2006. There is a report called "OPEN BALANCE" setup somewhere that I would like to change. However I cannot determine where this report is. We use the Premier Contractor Edition if you need this information. I have to physically make these changes every month when I send out the open balance reports to the general contractors (which I have to do for each individual contactor) which is time consuming. I have attached a screen shot of how the report looks in the original format and the edited format.

Thank you in advance for your time and knowledge.

Anonymous · ‎March 06, 2023

Hi there, @kelper62.

I’m here to help you locate the report you are looking for and customize this according to your preference in QuickBooks Desktop (QBDT).

We can locate the Open Balance report in the easiest way. To start, please follow the steps below:

Navigate to the Reports menu and select Report Center.
Type in Open Balance in the search bar.
Look for the report in the Standard Reports.
Once located, click Run report.

Once done, let’s proceed with customizing your report to only show the data you prefer to display:

In the report window, click the Customize button.
Under the Display tab, mark check all the Columns you want to show in the report.
Then, click OK.

To keep you from making changes every time you use the report, you can utilize the Memorize Report in QuickBooks Desktop. This way, you can save your previous customize for future use.

Less you have more concerns about running reports, please let me know by clicking the Reply button. Have a good one!

kelper62 · ‎March 08, 2023

No I did not get the answer I was looking for. The report as well as several others have been embedded somewhere and will come up automatically when I setup a new customer. See example below customer (Service Calls). If I setup any new customer, the reports I have the red parentheses around populate the customer automatically. See the attached screen shot.

Rubielyn_J · ‎March 08, 2023

I can lay out some information about why this is happening on your end, @kelper62.

Before that, may I ask if you previously created a sub-customer or a parent customer?

Based on the screenshot you've provided, it is possible that you have created a sub-customer. And the parent customer profile's Payment Settings was already set up.

For the new customer profile you've created, it is best to review the Payment Settings and enter the necessary information:

Select Customers and choose Customer Center.
Click the name of the customer.
Choose the Edit icon.
Proceed to Payment Settings and enter the necessary information.
Lastly, click OK.

If the issue persists, we can utilize the Verify and Rebuild tools to self-identifies and resolve the most commonly known data issues within a company file.

To verify your file:

Select Window then Close All.
Choose File.
Select Utilities and click Verify Data.

To rebuild your data:

Select File and choose Utilities.
Click Rebuild Data.
You will receive a warning message to back up your company file, press OK.
Choose where you want to save your backup, then click OK at the bottom of the QuickBooks Desktop Backup window.
The Rebuild Data utility starts as soon as the backup is finished.
Select OK when you get the message "Rebuild has completed".

Moreover, I'll be sharing these links to help manage your reports in QuickBooks Desktop:

Feel at ease to let me know if you have further concerns with your reports in QuickBooks Desktop. I'm always around to lend a helping hand. Keep safde!

kelper62 · ‎March 08, 2023

The steps did not work for me. In answer to your question, whoever setup QB in 2006 setup a General Contractor as the customer and projects for the GC are setup as jobs. I have included a screen shot of how it is setup. The reports for all new customers and jobs are automatically populated. I need to know where the auto population is coming from. I cannot edit the reports per customer/per job because there is nowhere to save it that I can see.

If I save it under "memorized reports" then "customers" the report is there but it does not change the automated report under the customer's name. I am having to edit this report "everytime" I run it the way I want it to look. And if I try to save the edited version, the option to save under the individual customer is not available.

I know this weird, but I cannot explain it better.

JamaicaA · ‎March 08, 2023

I know that this hasn't been easy for you and your business, @Kelper. I appreciate you sharing complete details about your concern so I'll provide further troubleshooting to fix this.

QuickBooks Desktop 2006 has been discontinued. With this, you'll be unable to change how it was set up. As a workaround, you'll need to contact an IT professional to help you locate and edit the report.

Drop a reply anytime if you still have questions or concerns with your account. I'll be here for you. Take care.

JamaicaA · ‎March 08, 2023

I know that this hasn't been easy for you and your business, @Kelper. I appreciate you sharing complete details about your concern so I'll provide further troubleshooting to fix this.

QuickBooks Desktop 2006 has been discontinued. With this, you'll be unable to change how it was set up. As a workaround, you'll need to contact an IT professional to help you locate and edit the report.

Drop a reply anytime if you still have questions or concerns with your account. I'll be here for you. Take care.

Topics

Training

Community

Resources

ORIGINAL REPORTS SETUP BY PREVIOUS EMPLOYEE