Hello,
Create Gross Profit on custom report create that time company list in Exists AAA name company and it json file in come
{
“add_total_row”: 0,
“columns”: ,
“creation”: “2024-06-21 13:04:11.318379”,
“disable_prepared_report”: 0,
“disabled”: 0,
“docstatus”: 0,
“doctype”: “Report”,
“filters”: ,
“idx”: 0,
“is_standard”: “Yes”,
“json”: “{"columns":[{"label":"Customer","fieldname":"customer","fieldtype":"Link","options":"Customer","width":100,"id":"customer","name":"Customer","editable":false,"compareValue":null},{"label":"Customer Group","fieldname":"customer_group","fieldtype":"Link","options":"Customer Group","width":100,"id":"customer_group","name":"Customer Group","editable":false,"compareValue":null},{"label":"Qty","fieldname":"qty","fieldtype":"Float","width":80,"id":"qty","name":"Qty","editable":false,"compareValue":null},{"label":"Avg. Selling Rate","fieldname":"avg.selling_rate","fieldtype":"Currency","options":"currency","width":100,"id":"avg.selling_rate","name":"Avg. Selling Rate","editable":false,"compareValue":null},{"label":"Valuation Rate","fieldname":"valuation_rate","fieldtype":"Currency","options":"currency","width":100,"id":"valuation_rate","name":"Valuation Rate","editable":false,"compareValue":null},{"label":"Selling Amount","fieldname":"selling_amount","fieldtype":"Currency","options":"currency","width":100,"id":"selling_amount","name":"Selling Amount","editable":false,"compareValue":null},{"label":"Buying Amount","fieldname":"buying_amount","fieldtype":"Currency","options":"currency","width":100,"id":"buying_amount","name":"Buying Amount","editable":false,"compareValue":null},{"label":"Gross Profit","fieldname":"gross_profit","fieldtype":"Currency","options":"currency","width":100,"id":"gross_profit","name":"Gross Profit","editable":false,"compareValue":null},{"label":"Gross Profit Percent","fieldname":"gross_profit%","fieldtype":"Percent","width":100,"id":"gross_profit%","name":"Gross Profit Percent","editable":false,"compareValue":null}],"filters":{"company":"AAA","from_date":"2023-11-01","to_date":"2023-12-01","group_by":"Customer"}}”,
“letter_head”: “HAMLAI”,
“modified”: “2024-06-24 15:54:45.208901”,
“modified_by”: “Administrator”,
“module”: “Hamlai”,
“name”: “Customer Wise Gross Profit”,
“owner”: “Administrator”,
“prepared_report”: 0,
“query”: “”,
“ref_doctype”: “Sales Invoice”,
“reference_report”: “Gross Profit”,
“report_name”: “Customer Wise Gross Profit”,
“report_type”: “Custom Report”,
“roles”: [
{
“role”: “Accounts Manager”
},
{
“role”: “Accounts User”
}
]
}
this json file in add AAA name company when company list from remove copany why AAA company not remove how to set default in custom report in company list from default comapny
Not possible from the custom report, you have to develop the new server script report then implement it according to the scenario.