I deleted the Original Invoice and Quote PDF manager. How do I get them back?

Question

I was changing the Logo in the PDF editor and somehow deleted the pdf template layout. How can I restore the original out of the box templates for Quote and Invoice?

David Dlugosz · Accepted Answer

Hi David Dlugosz , You should be able to update these directly from the database setting the Deleted = 0 on the 'pdfmanager' table. I am not aware of any way to restore these templates from within Sugar. If you're using an On-Demand instance, please contact our Support team to have this value changed. To help you out, here is the HTML from a 7.7 Quote and Invoice template that you can try inserting into a new template: Quote:

	Quote
	Quote number:	{$fields.quote_num}
	Sales Person:	{if isset($fields.assigned_user_link.name)}{$fields.assigned_user_link.name}{/if}
	Valid until:	{$fields.date_quote_expected_closed}

Bill To	Ship To
{$fields.billing_contact_name}	{$fields.shipping_contact_name}
{$fields.billing_account_name}	{$fields.shipping_account_name}
{$fields.billing_address_street}	{$fields.shipping_address_street}
{if $fields.billing_address_city!=""}{$fields.billing_address_city},{/if} {if $fields.billing_address_state!=""}{$fields.billing_address_state},{/if} {$fields.billing_address_postalcode}	{if $fields.shipping_address_city!=""}{$fields.shipping_address_city},{/if} {if $fields.shipping_address_state!=""}{$fields.shipping_address_state},{/if} {$fields.shipping_address_postalcode}
{$fields.billing_address_country}	{$fields.shipping_address_country}

{foreach from=$product_bundles item="bundle"}

{$bundle.name}

Quantity	Part Number	Quoted Line Item	List Price	Unit Price	Ext. Price	Discount:
{if isset($product.quantity)}{$product.quantity}{/if}	{if isset($product.mft_part_num)}{$product.mft_part_num}{/if}	{if isset($product.name)}{$product.name}{/if}{if isset($product.list_price)} {$product.description}{/if}	{if isset($product.list_price)}{$product.list_price}{/if}	{if isset($product.discount_price)}{$product.discount_price}{/if}	{if isset($product.ext_price)}{$product.ext_price}{/if}	{if isset($product.discount_amount)} {if !empty($product.discount_select)} {sugar_number_format var=$product.discount_amount}% {else} {sugar_currency_format var=$product.discount_amount currency_id=$product.currency_id} {/if} {/if}

	Subtotal:	{$bundle.subtotal}
	Discount:	{$bundle.deal_tot}
	Discounted Subtotal:	{$bundle.new_sub}
	Tax:	{$bundle.tax}
	Shipping:	{$bundle.shipping}
	Total	{$bundle.total}

{/foreach}

Grand Total
Currency:	{$fields.currency_iso}	Subtotal:	{$fields.subtotal}
		Discount:	{$fields.deal_tot}
		Discounted Subtotal:	{$fields.new_sub}
Tax Rate:	{$fields.taxrate_value}	Tax:	{$fields.tax}
Shipping Provider:	{$fields.shipper_name}	Shipping:	{$fields.shipping}
		Total	{$fields.total}

Invoice:

	Invoice
	Invoice number:	{$fields.quote_num}
	Sales Person:	{if isset($fields.assigned_user_link.name)}{$fields.assigned_user_link.name}{/if}
	Valid until:	{$fields.date_quote_expected_closed}
	Purchase Order Num:	{$fields.purchase_order_num}
	Payment Terms:	{$fields.payment_terms}

Bill To	Ship To
{$fields.billing_contact_name}	{$fields.shipping_contact_name}
{$fields.billing_account_name}	{$fields.shipping_account_name}
{$fields.billing_address_street}	{$fields.shipping_address_street}
{if $fields.billing_address_city!=""}{$fields.billing_address_city},{/if} {if $fields.billing_address_state!=""}{$fields.billing_address_state},{/if} {$fields.billing_address_postalcode}	{if $fields.shipping_address_city!=""}{$fields.shipping_address_city},{/if} {if $fields.shipping_address_state!=""}{$fields.shipping_address_state},{/if} {$fields.shipping_address_postalcode}
{$fields.billing_address_country}	{$fields.shipping_address_country}

{foreach from=$product_bundles item="bundle"}

{$bundle.name}

Quantity	Part Number	Quoted Line Item	List Price	Unit Price	Ext. Price	Discount:
{if isset($product.quantity)}{$product.quantity}{/if}	{if isset($product.mft_part_num)}{$product.mft_part_num}{/if}	{if isset($product.name)}{$product.name}{/if}{if isset($product.list_price)} {$product.description}{/if}	{if isset($product.list_price)}{$product.list_price}{/if}	{if isset($product.discount_price)}{$product.discount_price}{/if}	{if isset($product.ext_price)}{$product.ext_price}{/if}	{if isset($product.discount_amount)} {if !empty($product.discount_select)} {sugar_number_format var=$product.discount_amount}% {else} {sugar_currency_format var=$product.discount_amount currency_id=$product.currency_id} {/if} {/if}

	Subtotal:	{$bundle.subtotal}
	Discount:	{$bundle.deal_tot}
	Discounted Subtotal:	{$bundle.new_sub}
	Tax:	{$bundle.tax}
	Shipping:	{$bundle.shipping}
	Total	{$bundle.total}

{/foreach}

Grand Total
Currency:	{$fields.currency_iso}	Subtotal:	{$fields.subtotal}
		Discount:	{$fields.deal_tot}
		Discounted Subtotal:	{$fields.new_sub}
Tax Rate:	{$fields.taxrate_value}	Tax:	{$fields.tax}
Shipping Provider:	{$fields.shipper_name}	Shipping:	{$fields.shipping}
		Total	{$fields.total}

I hope this helps! Alex