Skip to main content
January 14, 2025
Question

Open Purchase Orders by Item Due Date before PO Date

  • January 14, 2025
  • 1 reply
  • 0 views

When I run the Open Purchase Orders by Item report, I see a large amount of POs with due dates BEFORE the date the PO was created, some of which are YEARS prior. When I look at the target POs, these assigned Due Dates are nowhere to be seen. I do not suspect the Purchaser is entering these dates incorrectly. Instead, these appear to be generated by the system.

I've looked over all the affected POs and they are from various Vendors and Items, along with various differences in the date difference.

How can I find this gremlin in the system?

1 reply

January 14, 2025

That's an intriguing scenario, and I understand how puzzling this must be, DesantisJ.

 

Based on the description of the problem with the purchase order dates, it seems possible that there may be data integrity issues within your system. I'm here to help you resolve this.

 

Possible data damage can make QuickBooks Desktop (QBDT) behave unexpectedly. We can fix the issue using the Verify Rebuild Data tool available in QuickBooks Desktop. This feature is designed to detect and solve any data damage in your files. Utilizing this tool will allow us to determine whether the problem is rooted in data corruption.

 

Here's how you can run the Verify Data tool:

 

  1. Go to the File menu, then hover over Utilities and click on Verify Data.
  2. Follow the prompts to start the verification process.
  3. If the tool finds any issues with your data, it will prompt you to Rebuild Data
     

To rebuild your company data, I suggest checking this article: Verify and Rebuild Data in QuickBooks Desktop, which offers thorough guidance on how to properly execute the rebuilding process and maintain the accuracy of your company data in QuickBooks.

 

For help with paying your bills in QuickBooks Desktop, refer to this article: Pay bills in QBDT for easy-to-follow instructions on managing your payments efficiently.

 

Should you need any assistance while running the tool or if the problem persists after the verification, DesantisJ, please feel free to reach out.

DesantisJAuthor
January 15, 2025

Thank you for the quick response. I've forwarded the suggestion to my co-workers responsible for QB administration.