{% extends "finance_and_banking_base.html" %} {% load static %} {% load crispy_forms_tags %} {% block title %} BTB LC Budget Report {% endblock title %} {% block Style %} {% endblock Style %} {% block MainContent %}
{% csrf_token %}
BTB LC Budget Report
{{form.file|as_crispy_field}}
{{form.budget|as_crispy_field}}
{% if budget %}

{{ budget }}

{{ budget.finance_company }}

Mode of Price: {{budget.get_mode_of_price_display}}     Team: {{budget.team}}

BTB LC Budget Report {% comment %} {% if department %} {{department}} {% endif %} {% if designation %}   -   {{designation}}{% endif %}

{{year}}  -  {{month}} {% endcomment %} {% if department %}( Department : {{department}}) {% endif %} {% if designation %} (Designation : {{designation}}) {% endif %} {% if from_date %} {{from_date}}   to   {{to_date}} {% endif %} {% comment %} {% endcomment %} {% for item in fabric_lists %} {% for details in item.details %} {% comment %} {% endcomment %} {% endfor %} {% endfor %} {% for item in accessory_lists %} {% for details in item.details %} {% comment %} {% endcomment %} {% endfor %} {% endfor %}
SL No Supplier Tenor LC No LC Date LC Tenor Costing ValueBTB DueBTB Value Amendment Total Total Paid Amount Due Balance
Fabrics
{{item.goods}}
{{forloop.counter}} {{details.supplier}} {{details.pi.pi.tenor.terms_short_name}} {% if details.btb_lc %} {{details.btb_lc}} {% else %} LC not opened {% endif %} {% if details.btb_lc %} {{details.btb_lc.opening_date}} {% else %} LC not opened {% endif %} {% if details.btb_lc %} {{details.btb_lc.tenor.terms_short_name}} {% else %} LC not opened {% endif %} ${{details.pi.fabric_pi_value|floatformat:3}}${{details.opening_due|floatformat:3}}{% if details.btb_lc %} ${{details.btb_lc.value|floatformat:3}} {% else %} LC not opened {% endif %} {% if details.btb_lc %} {% for amendment in details.lc_info.amendments %} {{amendment.value}} + {% endfor %} = {{details.lc_info.total_amendments}} {% else %} LC not opened {% endif %} {% if details.btb_lc %} ${{details.lc_info.total_lc_value|floatformat:3}} {% else %} LC not opened {% endif %} {% if details.btb_lc %} ${{details.lc_info.paid_amount|floatformat:3}} {% else %} LC not opened {% endif %} {% if details.btb_lc %} ${{details.lc_info.balance|floatformat:3}} {% else %} LC not opened {% endif %}
Accessories
{{item.goods}}
{{forloop.counter}} {{details.supplier}} {{details.pi.pi.tenor.terms_short_name}} {% if details.btb_lc %} {{details.btb_lc}} {% else %} LC not opened {% endif %} {% if details.btb_lc %} {{details.btb_lc.opening_date}} {% else %} LC not opened {% endif %} {% if details.btb_lc %} {{details.btb_lc.tenor.terms_short_name}} {% else %} LC not opened {% endif %} ${{details.pi.accessory_pi_value|floatformat:3}}${{details.opening_due|floatformat:3}}{% if details.btb_lc %} ${{details.btb_lc.value|floatformat:3}} {% else %} LC not opened {% endif %} {% if details.btb_lc %} {% for amendment in details.lc_info.amendments %} {{amendment.value}} + {% endfor %} = {{details.lc_info.total_amendments}} {% else %} LC not opened {% endif %} {% if details.btb_lc %} ${{details.lc_info.total_lc_value|floatformat:3}} {% else %} LC not opened {% endif %} {% if details.btb_lc %} ${{details.lc_info.paid_amount|floatformat:3}} {% else %} LC not opened {% endif %} {% if details.btb_lc %} ${{details.lc_info.balance|floatformat:3}} {% else %} LC not opened {% endif %}
{% endif %} {% endblock MainContent %} {% block meassage %} {% include 'notifications/notifications.html' %} {% endblock meassage %} {% block JS %} {% endblock JS %}