Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi,
I am a contractor and hire subcontractors to do the work and they are all paid 30% at the beginning of their work and then 70% at the end. Before a job starts, I enter a PO for each of the subcontractors into QB. I enter one line for the first 30% payment and enter the expected date of payment under the Service Date. I then enter a second line for the other 70% along with the expected date of payment under the Service Date.
I'm trying to run a PO report that shows the actual Service Dates, Source Name, Memo, and the Amount. This way I can see what costs I have in the future and when. So far, every PO report that I run shows each line, but the only date it will show is the date I created the PO, not the Service Date.
Can anybody help with this?
Thanks
Solved! Go to Solution.
Hello there, skoz5555. Thanks for getting back to this thread.
I appreciate you for providing further details of your concern, as well as the screenshot.
The Other 1 or 2 columns of the report will not be changed, it'll still remain as the title of the column. Though, anything that you have entered from the PO will show up to that column.
It requires a bit more effort on our part to verify the things that we've added and recorded on the PO. Let me help you customizing the Transaction Detail Report as my colleague suggested above. This way, we'll be able to display and get the necessary information that we need from the report.
To do so, follow these steps:
For more tips and information about customizing the reports in QBDT, you can check out here: Personalizing QuickBooks Desktop reports.
Please get back to me if you have more questions. I'm right here together with the Community people to help you out. Hope you're well and safe!
I'd like to know more about this, Skoz5555. This way, I can provide an accurate answer.
Where did you enter the service date? Did you add it in the fields or line item?
In the meantime, you can create custom transaction detail reports. This uses different combinations of display and filters tab. Here's how:
You can check this reference about customizing reports in QuickBooks Desktop for more information.
We're just around if you need our help. Feel free to visit us anytime.
Hi Kristine,
I tried your suggestion at just running a Transaction Detail report for the job and none of the PO's showed up on that either.
I've attached four screenshots in a zip file. Here is what I've done throughout the process:
1. PO Columns - I created a customized PO template and it has the "Service Date" column available. (I also created a custom one "Exp Pay Date" under the "Other 1" title, hoping I could include that in a report but no luck.)
2. PO Created - I created a PO and you'll see that I have different dates in the "Service Date", for these are the days I expect to actually pay the sub
3. Trans Detail Report - I ran a Transaction Detail report for the months that cover the " Services Dates" for the job name and you can see that none of these PO's even showed up
4. Trans Detail Settings - These are the settings I used.
Thanks again for your persistence with this. It would be extremely helpful if I could figure a way to make this work.
Hello there, skoz5555. Thanks for getting back to this thread.
I appreciate you for providing further details of your concern, as well as the screenshot.
The Other 1 or 2 columns of the report will not be changed, it'll still remain as the title of the column. Though, anything that you have entered from the PO will show up to that column.
It requires a bit more effort on our part to verify the things that we've added and recorded on the PO. Let me help you customizing the Transaction Detail Report as my colleague suggested above. This way, we'll be able to display and get the necessary information that we need from the report.
To do so, follow these steps:
For more tips and information about customizing the reports in QBDT, you can check out here: Personalizing QuickBooks Desktop reports.
Please get back to me if you have more questions. I'm right here together with the Community people to help you out. Hope you're well and safe!
It was the posting status that I had to change.
Thanks for your help.
This solution does not help me to pull in the service date on any of the reports. I was able to add "Service Date" to a column on my Purchase Order, but I cannot pull this into any reports. Please help. We are using this field to represent multiple lines on a PO that has several different ship dates.
We always strive to provide the best experience with the product, mcastor_esi.
I know how beneficial it is to your business to pull up a Service Date on the report. However, this option is unavailable in QuickBooks. What we can do is run a Transaction List by Vendor report and customize it to purchase order and posting status. We can also export the report to Excel to add a column for the service date. Here's how:
To export the report to Excel, tap the Excel drop-down, and choose Create New Worksheet. From there, you can modify the report to come up with the data you need. For more details about modifying reports, see Customize reports in QuickBooks Desktop article.
Feel free to visit our Reports page for more insight s about creating and managing reports with QuickBooks.
The Community will always have your back if you need a hand with reconciling your accounts or any QuickBooks related. Assistance is just one post away. Have a great weekend.
Hello RCV,
I am working on reporting with purchase order details and service date.
I am following your instruction, posted December 12, 2020 09:15 PM.
But I cannot pull in service date on list.
There is no "service date" on the list of Display tab, Customize Report window.
Do you have any idea if anything I made wrong?
@RCV wrote:We always strive to provide the best experience with the product, mcastor_esi.
I know how beneficial it is to your business to pull up a Service Date on the report. However, this option is unavailable in QuickBooks. What we can do is run a Transaction List by Vendor report and customize it to purchase order and posting status. We can also export the report to Excel to add a column for the service date. Here's how:
- Go to Reports on the top menu.
- Choose Vendors & Payables.
- Select Transaction List by Vendor.
- Tick the Customize Report button.
- Tap Filters.
- In the Choose Filter box, with the Posting Status highlighted, choose Either from the drop-down list.
- Then, select Transaction Type in the Choose Filter box. Tick the Transaction Type drop-down and select Purchase Order.
- Click OK and OK.
To export the report to Excel, tap the Excel drop-down, and choose Create New Worksheet. From there, you can modify the report to come up with the data you need. For more details about modifying reports, see Customize reports in QuickBooks Desktop article.
Feel free to visit our Reports page for more insight s about creating and managing reports with QuickBooks.
The Community will always have your back if you need a hand with reconciling your accounts or any QuickBooks related. Assistance is just one post away. Have a great weekend.
Hello @RCV
I am working on creating reports of open purchase order with Service Date.
Though I followed your instruction, posted on Dec 24 2020, I cannot find Service Date on the list of Display tab, Customization window.
DO you have any Idea if anyting I made wrong?
For your ref, attached my screen on Display and Filter tub.
CHRN
@RCV wrote:We always strive to provide the best experience with the product, mcastor_esi.
I know how beneficial it is to your business to pull up a Service Date on the report. However, this option is unavailable in QuickBooks. What we can do is run a Transaction List by Vendor report and customize it to purchase order and posting status. We can also export the report to Excel to add a column for the service date. Here's how:
- Go to Reports on the top menu.
- Choose Vendors & Payables.
- Select Transaction List by Vendor.
- Tick the Customize Report button.
- Tap Filters.
- In the Choose Filter box, with the Posting Status highlighted, choose Either from the drop-down list.
- Then, select Transaction Type in the Choose Filter box. Tick the Transaction Type drop-down and select Purchase Order.
- Click OK and OK.
To export the report to Excel, tap the Excel drop-down, and choose Create New Worksheet. From there, you can modify the report to come up with the data you need. For more details about modifying reports, see Customize reports in QuickBooks Desktop article.
Feel free to visit our Reports page for more insight s about creating and managing reports with QuickBooks.
The Community will always have your back if you need a hand with reconciling your accounts or any QuickBooks related. Assistance is just one post away. Have a great weekend.
I have the same issue. We have several contractors with varying service periods. Some are a year, some 6 months, some based on benchmarks. I have added the service dates to the POs in the system but it is of no use if I can't produce reports based on this information. Accounting staff can see it on the screen but we need it in a report.
Why can this information not be filtered in the same way other information is filtered such as delivery dates? Does it relate to the information being in the detail rather than the header of the document?
Hello, cabw.
I'll give some overview on why the Service Date column won't show when you filter and customize the report.
The Columns list (on the Customize Report screen) will only show some of the major columns on a transaction.
This article also explains what is reflected and what can be filtered in your reports: Understand reports.
That said, what you can do is to use the Other 1 or 2 field when adding the service date. You'll want to enable it first on the Customize Data Layout screen. Here's how:
You can edit or create a purchase order, then manually enter the serviced date.
When running the report, you'll want to include the Other 1 or 2 columns data to show it.
Our developers are working to improve the Desktop platform. They might add more columns under the Columns list for the Customization window.
Ready to record other transactions or need to take care of your customers and vendors? We have articles to guide you in handling your books. Take a look at them in the articles list page.
Don't forget to visit our Community forums if you have other questions about your reports and other areas in QuickBooks. I'm always here to help.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here