CAPITAL Office Business Software
CAPITAL Support Forum
FAQSearchMembersGroupsRegisterProfilePM'sLogin/Out
Need list of quotes

 
Post new topic   Reply to topic    CAPITAL Office Business Software Forum Index -> Capital Office
View previous topic :: View next topic  
Author Message
Lizzy
Guest





PostPosted: Thu Jan 04, 2018 6:22 pm    Post subject: Need list of quotes Reply with quote

Is there some way I can create a list of all open quotes?
Back to top
COBS Tech Support



Joined: 09 Sep 2005
Posts: 639

PostPosted: Fri Jan 05, 2018 9:55 am    Post subject: Reply with quote

To create an open quote list:

1. Open Quotes
2. Click on "Open" tab (top right)
3. Right click on any quote on the list
4. Select Manage Queries
5. Click Rename button
6. Change the text to "Open Quotes" and press OK
7. Under "Column" change this to "Status"
8. Under "Value" change this to "open"
9. Press Update button
10. Press Apply
11. Press Save

All open quotes are now on the list. To export to Excel:

1. Right click on any quote on the list
2. Select Export
3. Save as an Excel Workbook or try OfficeLink (which will save as a spreadsheet then try to open it in Excel right away)

In the future all you need to do is click on right mouse, and select "Open Quotes"

If you want to add or remove columns for your report, right click and adjust presentation by selecting Column Properties.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    CAPITAL Office Business Software Forum Index -> Capital Office All times are GMT + 10 Hours
Page 1 of 1

 
Jump to:  
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

phpBB Template by Vereor
Protected by Anti-Spam ACP