{% extends "finance_and_banking_base.html" %} {% load static %} {% load crispy_forms_tags %} {% load humanizelib %} {% block title %} Performance Report {% endblock title %} {% block Style %} {% endblock Style %} {% block MainContent %} {% if messages %} {% for message in messages %} {% endfor %} {% endif %}

File Performance

{% csrf_token %}
{{form.file|as_crispy_field }}
{% comment %} {% if report_list and file and total_value and total_lc_value and total_consignment_value and total_request_value and total_acceptance_value and total_maturity_value and tatal_payment_value %} {% endcomment %} {% if file %}
{% comment %} {% endcomment %}

{{file.beneficiary_company}}

{% comment %}
File wise import position of {{file.beneficiary_company}}
{% endcomment %}
{{file.beneficiary_company.company.section_address}}
File Performance Report
File Number {{file}}
Buyer Name {% for item in buyer_name_list %} {{item}},{% endfor %}
MDR:
Updated Date:
SL NO. Particulars Amount ($) Amount (BDT) Remarks
A Contract Value ${{total_sales_contract_value |floatformat:3|intcomma}}
B Actual Value ${{grand_total_actual_value |floatformat:3|intcomma}}
For Existing File
C Exported Value
Exported
To be exported
Payment Received Value
D Less: Deduction made as follows:
BTB opened ${{total_btb_value|floatformat:3|intcomma}}
For Other File ${{other_file_value|floatformat:3|intcomma}}
ECC against Negotiate ${{ecc_negotiate_dollar|floatformat:3|intcomma}} {{ecc_negotiate|floatformat:3|intcomma}}
ECC against salary ${{adj_ecc_for_pcc_dollar|floatformat:3|intcomma}} {{adj_ecc_for_pcc |floatformat:3|intcomma}}
PCC for ECC adj ${{remain_ecc_salary_dollar|floatformat:3|intcomma}} {{remain_ecc_salary_tk|floatformat:3|intcomma}}
Fund from Bills realisation ( 1148 & 52574)
Fund from Bills realisation ( 1148 & 52574)
FDR Account -3542
ERQ Account- 7431
Commission 4%
Other Charges (2%)
Balance
{% for object in sales_contract_list %} {% if object.sales_contract_number and object.value %} {% else %} {% endif %} {% endfor %}
SL No Contract No. Contract Date Buyer/ Merchant Order Type QTY (Contract ) Contract Value QTY(Costing) Costing Value Req-BTB Buying comm Total BTB CM Replace Date Replace QTY Replace Value First Ship Date Last Ship Date Shipped QTY Shipped Value Balance QTY Balance Shipment Payment Received Payment Terms Tolerance Comm. Paid Balance comm. Remarks
{{forloop.counter}} {{object.sales_contract_number}} {{object.sales_contract_date}} {{object.get_order_type_display}} {{object.order_qty}} Pcs ${{object.revised_value.sc_value|floatformat:3|intcomma}} {{object.obj.file}}/{{object.obj.order_no}}/({{object.obj.sub_order}}) {{object.obj.budget}} {{object.obj.contract_date}} {{object.obj.budget.buyer_name}} {{object.obj.budget.get_mode_of_order_display}} {{object.order_qty}} {{object.budget_cost.total_gmt_qty|floatformat:3|intcomma}} ${{object.total_actual_value|floatformat:3|intcomma}} ${{object.lc_value|floatformat:3|intcomma}} ${{object.buying_commission|floatformat:3|intcomma}} ${{object.total_btb_value|floatformat:3|intcomma}} ${{object.budget_cost.grand_total_cm_cost|floatformat:3|intcomma}} {{object.obj.replacement_date}} {{object.budget_cost.total_gmt_qty|floatformat:3|intcomma}} {{object.SHIP_DATE_START}} {{object.SHIP_DATE_LAST}}
Grand Total ${{total_sales_contract_value|intcomma}} {{grand_total_gmt_qty|intcomma}} ${{grand_total_actual_value|floatformat:3|intcomma}} ${{grand_total_lc_value|floatformat:3|intcomma}} ${{grand_buying_commission|floatformat:3|intcomma}} ${{grand_btb_value|floatformat:3|intcomma}} ${{grand_total_cm_cost|floatformat:3|intcomma}} {{grand_total_gmt_qty|intcomma}}
{% endif %} {% endblock MainContent %} {% block meassage %} {% include 'notifications/notifications.html' %} {% endblock meassage %} {% block JS %} {% endblock JS%}