cancel
Showing results for 
Search instead for 
Did you mean: 
LynnOfCarols
Level 2

Purchase Orders and Expected Dates

I'm very disappointed with the limitations of QuickBooks for our business. 

 

When I run an Open Purchase Order by Detail report, the "Expected date" for each line will default to the date input in my header. 

 

However, when i have items on back order, i want that to be reflected.  I have customized my PO to add a column in the body of the PO (i had to name it Expected Date) that being said, b/c that's a manually named field, it doesn't generate on any reports. 

 

This is very important. How can i get the information I need without having to open each purchase order to see the date we input for each line? 

Solved
Best answer January 08, 2021

Best Answers
MirriamM
Moderator

Purchase Orders and Expected Dates

I appreciate your input from every angle, LynnOfCarols.

 

Let me share information on how to show the Expected Date of the Purchase Order on the report.

 

When customizing the Purchase Order Template, you can have the Expected Date set up under the Columns tab in the Additional Customization window. From there, put a checkmark on the Screen and Print box for Other 1.

 

 

Once you create a Purchase Order, the Expected Date will be part of the Columns tab. 

 

Then, when pulling up the Open Purchase Orders Detail report, click the Customize Report button. On the Modify Report window, search Other 1 in the COLUMNS field and put a check-mark. 

 

After that, the Expected date will now show up under the Other 1 column on the report. 

 

For additional information on how to customized reports in QuickBooks Desktop (QBDT), you can check this article:  Customize reports in QuickBooks Desktop

 

For future help, here's A resource to help you get ready during tax season: QuickBooks Desktop Year End Prep and Resources.

 

Stay in touch with me if you any other questions by adding a comment below. I'm always here for you. 

View solution in original post

3 Comments 3
MirriamM
Moderator

Purchase Orders and Expected Dates

I appreciate your input from every angle, LynnOfCarols.

 

Let me share information on how to show the Expected Date of the Purchase Order on the report.

 

When customizing the Purchase Order Template, you can have the Expected Date set up under the Columns tab in the Additional Customization window. From there, put a checkmark on the Screen and Print box for Other 1.

 

 

Once you create a Purchase Order, the Expected Date will be part of the Columns tab. 

 

Then, when pulling up the Open Purchase Orders Detail report, click the Customize Report button. On the Modify Report window, search Other 1 in the COLUMNS field and put a check-mark. 

 

After that, the Expected date will now show up under the Other 1 column on the report. 

 

For additional information on how to customized reports in QuickBooks Desktop (QBDT), you can check this article:  Customize reports in QuickBooks Desktop

 

For future help, here's A resource to help you get ready during tax season: QuickBooks Desktop Year End Prep and Resources.

 

Stay in touch with me if you any other questions by adding a comment below. I'm always here for you. 

LynnOfCarols
Level 2

Purchase Orders and Expected Dates

Thank you but that's not what i'm asking. I know how to do that but that only gives me 1 expected date for the whole PO. if each line has a different expected date, how can i run a report indicating the expected date for each line? 

LynnOfCarols
Level 2

Purchase Orders and Expected Dates

OF COURSE! i Have to use the actual name of that field, which is "other" not what i named it! 

 

Thank you so much! that is exactly what i needed! 

Need to get in touch?

Contact us