def uom_columns(x):
return [
make_column("uom{}".format(x), "UOM {}".format(x), width=90),
make_column(
"cf{}".format(x),
"Coversion Factor {}".format(x),
type="Float",
width=90,
),
make_column("qty{}".format(x),
"Qty {}".format(x),
type="Float",
width=90),
]
def _get_columns():
return list(
concatv(
[
make_column(
"parent_item_group",
"Parent Item Group",
"Link",
options="Item Group",
),
make_column(
"item_group",
"Item Group",
"Link",
options="Item Group",
),
make_column(
"name",
"Item Code",
"Link",
options="Item",
),
make_column("description", "Description", width=350),
make_column("barcode", "Barcode", width=180),
],
[make_column(_get_key(x), x, "Float") for x in _get_warehouses()],
[
make_column("qty_sold", "Qty Sold", "Float"),
make_column("sold_valuation", "Sold Valuation", "Currency"),
],
))
def _get_columns(columns):
return list(
concatv(
columns,
[
make_column(
"parent_item_group",
"Parent Item Group",
"Link",
options="Item Group",
),
make_column("ret_val", "Retail", "Currency"),
make_column("sku_counts", "SKU Counts", "Float"),
],
)
)
def _get_columns():
return [
make_column("hours", "Hours", "Data", 210),
make_column(
"no_of_sales",
"No. of Sales",
"Int",
),
make_column(
"total_qty",
"Total Qty",
"Int",
),
make_column(
"total",
"Total",
"Currency",
),
make_column(
"taxes_and_charges",
"Taxes",
"Currency",
),
make_column(
"discount_amount",
"Discount",
"Currency",
),
make_column(
"grand_total",
"Grand Total",
"Currency",
),
]
def _get_columns(doctype, filters):
return [
make_column("vat_return_no", "VAT return field number", width=150),
make_column("invoice", "Invoice number", width=150),
make_column("date", "Invoice date", type="Date", width=90),
make_column("vat_account_no", "VAT Account Number", width=150),
make_column("party_name", "Client name", width=150),
make_column("description", "Good/Service description", width=180),
make_column("taxable_amount",
"Total BHD (exclusive of VAT)",
type="Float"),
make_column("vat_amount", "VAT amount", type="Float"),
make_column("total_amount",
"Total BHD (inclusive of VAT)",
type="Float"),
]
def _get_columns(filters):
join_columns = compose(list, concatv)
columns = [
make_column("item_code", type="Link", options="Item"),
make_column("item_name", width=150),
make_column("item_group", type="Link", options="Item Group"),
make_column("brand", type="Link", options="Brand"),
make_column("supplier", "Default Supplier", type="Link", options="Supplier"),
make_column("supplier_part_no"),
make_column("stock_uom", "Stock UOM", width=90),
make_column("qty", "Balance Qty", type="Float", width=90),
]
return (
join_columns(columns, get_uom_columns(NUM_OF_UOM_COLUMNS))
if filters.get("show_alt_uoms")
else columns
)
def _get_columns(filters):
join_columns = compose(list, concatv)
return join_columns(
[
make_column("posting_date", "Date", type="Date", width=90),
make_column("voucher_type", hidden=1),
make_column(
"voucher_no",
"Bill No",
type="Dynamic Link",
options="voucher_type",
width=150,
),
make_column("particulars"),
make_column("expiry_date", type="Date", width=90),
make_column("receipt", type="Float", width=90),
make_column("issue", type="Float", width=90),
],
)
def _get_columns(args):
join_columns = compose(list, concatv)
columns = [
make_column("supplier", type="Link", options="Supplier"),
make_column("brand", type="Link", options="Brand"),
make_column("item_code", type="Link", options="Item"),
make_column("item_name", width=200),
make_column("batch_no", "Batch", type="Link", options="Batch"),
make_column("expiry_date", type="Date", width=90),
make_column("expiry_in_days", "Expiry in Days", type="Int", width=90),
make_column("qty", "Quantity", type="Float", width=90),
make_column("stock_uom", "Stock UOM", width=90),
make_column("price1", args.get("price_list1"), type="Currency"),
make_column("price2", args.get("price_list2"), type="Currency"),
make_column("warehouse"),
]
return (
join_columns(columns, get_uom_columns(NUM_OF_UOM_COLUMNS))
if args.get("show_alt_uoms")
else columns
)
def _get_columns(filters):
return [
make_column("description", "Description", width=480),
make_column("taxable_amount", "Amount (BHD)", type="Float"),
make_column("vat_amount", "VAT amount (BHD)", type="Float"),
]
