{% block body %} {# #}

‘FIRST PART’
(Sales History Form will be considered for processing only after Finance confirms credit of payment in our account)

Offer & Order Details	Sales person/s	{{ salesConfirmation.account }}
	CW Offer No	{{ salesConfirmation.offer_code }}		Date	{{ salesConfirmation.offer_date_format }}
	Work Order No.	{{ salesConfirmation.po_no }}		Date	{{ salesConfirmation.po_date_format }}
	Order Type	{{ salesConfirmation.sales_price }}
	L/C No.		Date:		Last Date of Shipment as per LC:
	Repeat Order	Yes / No

Customer Details	Customer Name	{{ salesConfirmation.customer }}
	Office Address	{{ salesConfirmation.customer_address }}
	Contact Person	{{ salesConfirmation.customer_contactperson }}
	Mobile #	{{ salesConfirmation.customer_contactpersonphone }}	Email id	{{ salesConfirmation.customer_email }}
	Sector	{{ salesConfirmation.customer_sector }}

{% set counter = 0 %} {% for salesConfirmItem in salesConfirmationItem %} {% set counter = counter + 1 %} {% else %} {% endfor %}

CWPL Scope of Supply	Sl	Product Description	Model	Rating	Qty
	{{ counter }}	{{ salesConfirmItem.product_description }}	{{ salesConfirmItem.model_number }}	{{ salesConfirmItem.rating }}	{{ salesConfirmItem.quantity }} {{ salesConfirmItem.unit}}
	No records found

Delivery, Installation & Commissioning	Committed Delivery Date	{{ salesConfirmation.del_date_format }}	Committed Date of Shipment
	Delivery Arranged by		Port of Shipment
	Any Special Instructions
	Site Address
	Contact Person @ Site
	Mobile #		Email id
	Scheduled date of Installation		Scheduled date of Commissioning
	Any Special Instructions

{# Second Page Start Here #} {% if signatory > 1 %} {% endif %}

{% for salesConfirmItem in salesConfirmationItem %} {% if salesConfirmItem.category == 15 %} {% endif %} {% endfor %}

Genset Details
Brand	{{ salesConfirmItem.brand }}	Model	{{ salesConfirmItem.model_number}}
Type	Prime / Standby	kVA (Prime) : {{ salesConfirmItem.rating}}	kVA (Standby) : {{ salesConfirmItem.srating}}
Alternator	{{ salesConfirmItem.AlternatorBrand}}	Alternator Model	{{ salesConfirmItem.alt_model}}
Warranty	{{ salesConfirmation.warrenty_note }}
Warranty	Any other please specify -

{% for salesConfirmItem in salesConfirmationItem %} {% if salesConfirmItem.category == 20 %} {% endif %} {% endfor %}

ATS Details
Type	{{ salesConfirmItem.product_type}}	Make	ABB Schneider Telemechanique
Other -
Any special remark/ commitment

{% for salesConfirmItem in salesConfirmationItem %} {% if salesConfirmItem.category == 19 %} {% endif %} {% endfor %}

Canopy Details
Type	{{ salesConfirmItem.product_type}}	Body Type	Floor Type
Canopy Supplier Preference	SEL Bismillah Active	Other -
Hot Air Outlet	Front	Top	Customized
If customized, attach sketch
Sound Level	@ m	75dBA 85dBA	Others -
Any special remark/commitment

{% set counter = 0 %} {% for commMaterial in commMaterials %} {% set counter = counter + 1 %} {% else %} {% endfor %}

Items to be supplied together with Genset
SL	Code	Name	Unit	Quantity	Price	Total Price
{{ counter }}	{{ commMaterial.ProductCode }}	{{ commMaterial.ProductName }}	{{ commMaterial.Unit }}	{{ commMaterial.Quantity }}	{{ commMaterial.UnitPrice }}	{{ commMaterial.UnitPrice * commMaterial.Quantity }}
No records found

‘SECOND PART’

Details	Customer Name	{{ salesConfirmation.customer}}
	Work Order No.	{{ salesConfirmation.offer_code}}	Date	{{ salesConfirmation.po_date_format}}
	Sales Person	{{ salesConfirmation.account}}
	Order Type	{{ salesConfirmation.sales_price}}

{% set total_amount = 0 %} {% set grand_total_amount = 0 %} {% for salesConfirmItem in salesConfirmationItem %} {% set total_amount = salesConfirmItem.price * salesConfirmation.convertion_rate %} {% set grand_total_amount = grand_total_amount + total_amount %} {% set counter = ( counter | default(0) ) + 1 %} {% endfor %}

Pricing Details
Sl	Product Description	Model	Qty	Unit Price	Currency	Conv Rate	Amount in BDT
{{ counter }}	{{ salesConfirmItem.product_description}}	{{ salesConfirmItem.model_number}}	{{ salesConfirmItem.quantity}} {{ salesConfirmItem.unit}}	{{ salesConfirmItem.price}}	{{ salesConfirmation.currency_name}}	{{ salesConfirmation.convertion_rate}}	{{ total_amount }}
Total Amount (Excluding VAT & AIT)							{{ grand_total_amount }}
Add VAT & AIT on applicable items							{{ grand_total_amount }}
Final Amount							{{ grand_total_amount }}

Technical Assistance Fee (TAF) Details
TAF Percentage (if applicable)		TAF Amount	{{ salesConfirmation.mis_amount}}
TAF Beneficiary Name	{{ salesConfirmation.mis_name}}
TAF Beneficiary Contact Details
TAF Mode	Cash
Note: TAF approval has to be in place. TAF will be paid in BDT only within a week after receipt of full and final payment and completion certificate. The concerned Sales Person has to ensure compliance with this aspect strictly

{% if salesConfirmation.trunsaction_type == 1 %} {% else %} {% endif %} {% for paymentTerm in paymentTerms %} {% if salesConfirmation.trunsaction_type == 1 %} {% else %} {% endif %} {% endfor %}

Payment Details (Local)
Description	Ratio	Amount
Description	Amount
{{ paymentTerm.description }}	{{paymentTerm.ratio }}	{{ grand_total_amount * paymentTerm.ratio/100 }}
{{paymentTerm.description}} ( Amount)	{{paymentTerm.ratio}}

Payment Details (LC)
LC Type	{% if salesConfirmation.lc_no != '' %} Foreign {% endif %}	LC No	{{ salesConfirmation.lc_no}}
Date	{{ salesConfirmation.lc_date_format}}	Validity
LC Value		Last Date of Shipment as per LC

Prepared By	Checked By	Reviewed By	Reviewed By	Approved By	Confirmed by	Accepted By	Approved By
{{ salesConfirmation.account }} {{ salesConfirmation.create_date\|format_datetime() }}	{% if signatory == 1 and salesConfirmation.tl_approval is null %} Approved / Not-Approved {% elseif salesConfirmation.tl_approval is not null %} {{ salesConfirmation.team_leader }} {{ salesConfirmation.tl_approval_date\|format_datetime() }} {% endif %}	{% if signatory == 2 and salesConfirmation.crm_approval is null %} Approved / Not-Approved {% elseif salesConfirmation.crm_approval is not null %} {{ salesConfirmation.crm_person }} {{ salesConfirmation.crm_approval_date\|format_datetime() }} {% endif %}	{% if signatory == 3 and salesConfirmation.ppts_approval is null %} Approved / Not-Approved {% elseif salesConfirmation.ppts_approval is not null %} {{ salesConfirmation.ppts_person }} {{ salesConfirmation.ppts_approval_date\|format_datetime() }} {% endif %}	{% if signatory == 4 and salesConfirmation.hos_approval is null %} Approved / Not-Approved {% elseif salesConfirmation.hos_approval is not null %} {{ salesConfirmation.hos_person }} {{ salesConfirmation.hos_approval_date\|format_datetime() }} {% endif %}	{% if signatory == 5 and salesConfirmation.fin_manager_status == 0 %} Approved / Not-Approved {% elseif salesConfirmation.fin_manager_status != 0 %} {{ salesConfirmation.fin_person }} {{ salesConfirmation.fin_approve_date\|format_datetime() }} {% endif %}	{% if signatory == 6 and salesConfirmation.pmo_approval is null %} Approved / Not-Approved {% elseif salesConfirmation.pmo_approval is not null %} {{ salesConfirmation.pmo_person }} {{ salesConfirmation.pmo_approval_date\|format_datetime() }} {% endif %}	{% if signatory == 7 and salesConfirmation.ceo_approval is null %} Approved / Not-Approved {% elseif salesConfirmation.ceo_approval is not null %} {{ salesConfirmation.ceo_person }} {{ salesConfirmation.ceo_approval_date\|format_datetime() }} {% endif %}
Sales Person	Team Leader	CRM	PPTS	Head of Sales	Finance	PMO	CBO

{% endblock %}