Can We Have Item Code Also In Sale Report Export

0

Hello support team,

we have a problem of finding the product and making report because the sale report when we export there is no item code mentioned or included in the excel exported, so it make us a bit hard to check against stock count.

--> please see my attachment --> it is hard for us to check cause no item code mentioned in the list

is there a way that we can also include item code in the exported sale report?

thanks.

Question Resolved For: Stock Manager Advance with All Modules 0 Votes 2 Answers 477 Views
Asked by Prom Vongchann 3 years ago

0

Answered by Enyinnaya Gift 3 years ago

I have done similar modification for a client. You will need to modify the following scripts Report.php, core.js, and sales report view file themes/default/admin/view/reports/sales.php.

In Report controller app/controllers/admin/Report.php modify getSalesReport method by adding product_code to the concatenated item_nane alias.

In Core js script themes\default\admin\assets\js\core.js you will need to create a replicate of pqFormat method/function as other scripts depend on the function.

Then modify the replicated function to include value for product code in the concatenated variable item_nane alias. See the example below.

	function pqcFormat(x) {
		if (x != null) {
			var d = '',
				pqc = x.split('___');
			for (index = 0; index < pqc.length; ++index) {
				var pq = pqc[index];
				var v = pq.split('__');
				d += v[0] + ' (Qty: ' + formatQuantity2(v[1]) + ') (Code: ' + v[2] + ')<br>';
			}
			return d;
		} else {
			return '';
		}
	}

0

Answered by Mian Saleem 3 years ago

Hello,

There is no option to add item code as you want. You will need to modify the item code to get desired results.

Thank you

We use Cookies

We use cookies to ensure that we give you the best experience on our website. By continuing to browse the site you are agreeing to our use of cookies.