Need help regarding gst and invoice

jaivifoods · August 30, 2017, 3:49am

How can i setup an invoice like this and i need it within one page and also i need cgst and sgst columns with product, i look forward for the help from the team and thank you!. I have attached the type of invoice i need with only items . I am ook with the custom billing and stuff. but items , i tried customizing but didnt work out well and tax breakup doesnt show the tax which i have included with item master.

Required invoice type is like this. Someone help me with this.

rohit_w · August 30, 2017, 5:09am

Hi @jaivifoods

Kindly check existing report Item-wise Sales Register report, it has already that fields which are showing in above image

github.com

frappe/erpnext/blob/develop/erpnext/accounts/report/item_wise_sales_register/item_wise_sales_register.js

// Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
// License: GNU General Public License v3. See license.txt

frappe.query_reports["Item-wise Sales Register"] = {
	"filters": [
		{
			"fieldname":"from_date",
			"label": __("From Date"),
			"fieldtype": "Date",
			"default": frappe.datetime.add_months(frappe.datetime.get_today(), -1),
			"reqd": 1,
		},
		{
			"fieldname":"to_date",
			"label": __("To Date"),
			"fieldtype": "Date",
			"default": frappe.datetime.get_today(),
			"reqd": 1,
		},
		{

This file has been truncated. show original

github.com

frappe/erpnext/blob/develop/erpnext/accounts/report/item_wise_sales_register/item_wise_sales_register.py

# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
# License: GNU General Public License v3. See license.txt


import frappe
from frappe import _
from frappe.model.meta import get_field_precision
from frappe.utils import cstr, flt
from frappe.utils.xlsxutils import handle_html

from erpnext.accounts.report.sales_register.sales_register import get_mode_of_payments
from erpnext.selling.report.item_wise_sales_history.item_wise_sales_history import (
	get_customer_details,
	get_item_details,
)


def execute(filters=None):
	return _execute(filters)

This file has been truncated. show original

jaivifoods · August 30, 2017, 6:10pm

Hey Rohit,

The image I attached was the kind of invoice I needed and not report. So
please consider helping me on it.

Thank you

jaivifoods · August 31, 2017, 3:32am

I need an invoice to be printed like that and sales report is fine, but my major need is invoice to be printed like that. i tried several options with print format. But now i think this kind of thing can be only done by code.