03-15-2013 12:36 PM
I have learned how to edit all of the template for the quote.adt except I cannot seem to access the excel file within it until after I hit the "create quote" button. I want to be able to edit the excel on the Quote template permanently.
Also, is there a way you can create a work order template and have all the information go from the opportunity page to that work order (very similar to Create Quote option but i have to add more fields for internal use.
03-15-2013 01:13 PM
Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.
10-15-2013 10:18 AM
I read the following in the knowledge base ...
There are two separate files that create a quote template.
• Quote.adt - contains the mail merge fields and the embedded Excel Quote.xlt table.
• Quote.xlt - Microsoft Excel template that contains a pre-constructed table that is embedded in the Quote.adt file. Product information is inserted into this table when a quote is created.
Note: Removing (or adding) rows and/or columns from the table in this template is neither recommended nor supported.
My question is what concerns should we have regarding modifying the Excel spreadsheet. Frequently, because the product descriptions are long and wrap, the quote extends to 2 pages. I would like to take 3 or 4 lines out of the Excel template allowing for this. What affect would that have on the template?
10-15-2013 10:49 AM
You would probably break it. The way that I've seen it work in the past is to make the main sheet invisible and reference the sheet from a different sheet. Then you can make it look exactly the way you want it to and ACT! is happy because all of the fields it needs are exactly where they need to be.
03-06-2014 11:59 AM
Wellmet, can you provide a bit more detail on what you mean by "make the main sheet invisible and reference the sheet from a different sheet? I tried to "Hide" the sheet.
Also, when this is then saved, how do I get this to show in the Quote.adt body?
As much detail as you can provide. I am new to this.
08-16-2017 06:29 AM
I have lost the ability to populate the items in the quote.adt file (word). I edited the excel.xlt (excel) file and now I can not seem to get it back.
I need to know how to make the excel document populated the data from the opportunity or start with a new quote.xlt file? I am not sure the order of operation here but when I paste the excel table into the word quote it populates nothing from the opportunity in ACT.
My mistake for editing the quote.xlt file but now I need to solve this.
08-16-2017 08:06 AM
The quote template can be quite temperamental and is recommended to take a backup of it before editing it (Copy + Paste a copy)
If a copy was not taken you can usually copy the file from another database and move it to your database files (I would recommend taking a copy of your Quote.xlt.
I have attached a copy of the default Quote.xlt file that you can use.
08-16-2017 08:37 AM
Horn, thank you for your help. Yes sir I did pull another copy from an old data base and saved it to the templates in current data base. However, it did not populate the line items into the table in the quote. That is why I thought a fresh copy would help. But, I saved the xlt file you provided and saved it and copy & pasted into the word format. it again did not populate the items. It is utilizing the form you gave me because it shows blue top line so that is confirmed. Just not populating the items from the opportunity. Any other reason it is not populating items from the OPEN opportunity?
Thank you and look forward to hearing from you again.
08-16-2017 09:27 AM
After 25 years experience with ACT the Quote Template is still an area that I treat with caution as even after getting anything other than Minor changes it gives unexpected results.
I recommend using a very good add-on that allows far more flexibility and is robust and you can try before you buy-
08-16-2017 09:35 AM