Breaking News: Grepper is joining You.com. Read the official announcement!

fetch data from report in frappe

Repulsive Ratel answered on April 23, 2024 Popularity 1/10 Helpfulness 1/10

answer fetch data from report in frappe

fetch data from report in frappe

Comment

def get_profit_from_report(month, company, fiscal_year):
    from erpnext.accounts.report.profit_and_loss_statement.profit_and_loss_statement import execute
    
    
    year1, year2 = frappe.get_value("Fiscal Year", fiscal_year, ["year_start_date", "year_end_date"])
    
    fiscal_year_start = datetime.strptime(str(year1), "%Y-%m-%d").date()
    year_start = fiscal_year_start.year
    
    fiscal_year_end = datetime.strptime(str(year2), "%Y-%m-%d").date()
    year_end = fiscal_year_end.year
    
    filters = frappe._dict({ "company": company,
					"filter_based_on": "Fiscal Year",
					# "period_start_date": getdate("2023-04-01"),
					# "period_end_date": getdate("2024-01-31"),
					"periodicity": "Monthly",
					"accumulated_values": 1,
					"select_view": "Report View",
     				"from_fiscal_year" : fiscal_year,
					"to_fiscal_year": fiscal_year,
            		})
    data = execute(filters)
    return data

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: fetch frappe report whatever

Link to this answer
Share Copy Link

Contributed on Apr 23 2024

Repulsive Ratel

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

fetch data from report in frappe

Contents

More Related Answers

fetch data from report in frappe

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.