Anand Doshi anandpdoshi
View install_erpnext.py
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/python | |
| from __future__ import unicode_literals | |
| import os, commands, sys | |
| def install(): | |
| # get required details | |
| root_pwd = get_root_password() | |
| db_name, db_pwd = get_new_db_details() | |
| # install path |
anandpdoshi
/ total_in_query_report.sql
Created
January 4, 2013 06:55
Example: How to add a Total row in Query Report of ERPNext
View total_in_query_report.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select | |
| item.name as "ID:Link/Item:120", | |
| item.item_name as "Item Name::120", | |
| item_price.price_list_name as "Price List::80", | |
| item_price.ref_currency as "Currency::40", | |
| item_price.ref_rate as "Rate:Currency:80", | |
| item.description as "Description::160", | |
| item.item_group as "Item Group:Link/Item Group:100", | |
| item.brand as "Brand::100" | |
| from `tabItem` item, `tabItem Price` item_price |
anandpdoshi
/ custom_conditional_mandatory.js
Created
January 9, 2013 14:30
View custom_conditional_mandatory.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| cur_frm.cscript.custom_purpose = function(doc) { | |
| if(doc.purpose==="Sales Return") { | |
| cur_frm.toggle_reqd("sales_invoice_no", true); | |
| } else { | |
| cur_frm.toggle_reqd("sales_invoice_no", false); | |
| } | |
| } |
anandpdoshi
/ pending_to_deliver_with_bin_qty_query.sql
Last active
December 10, 2015 23:28
View pending_to_deliver_with_bin_qty_query.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select | |
| so.name as "SO No:Link/Sales Order:100", | |
| so.transaction_date as "SO Date::80", | |
| so_item.item_code as "Item Code:Link/Item:160", | |
| so_item.description as "Description::300", | |
| (so_item.qty - ifnull(so_item.delivered_qty, 0)) as "PEND QTY:Decimal:70", | |
| so_item.reserved_warehouse as "WH::80", | |
| bin.actual_qty as "ACT:Decimal:40", | |
| bin.reserved_qty as "RSVD:Decimal:40", | |
| so.customer as "Customer:Link/Customer:150" |
anandpdoshi
/ 2013-02.css
Last active
December 14, 2015 07:39
ERPNext Open Day Presentation - February 2013 - by Anand Doshi
View 2013-02.css
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| We start with a good ol' reset. | |
| That's the one by Eric Meyer http://meyerweb.com/eric/tools/css/reset/ | |
| You can probably argue if it is needed here, or not, but for sure it | |
| doesn't do any harm and gives us a fresh start. | |
| */ | |
| html, body, div, span, applet, object, iframe, | |
| h1, h2, h3, h4, h5, h6, p, blockquote, pre, |
anandpdoshi
/ colorbrewer.js
Last active
August 19, 2023 13:50
Relationships between DocTypes in ERPNext
View colorbrewer.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // This product includes color specifications and designs developed by Cynthia Brewer (http://colorbrewer.org/). | |
| var colorbrewer = {YlGn: { | |
| 3: ["#f7fcb9","#addd8e","#31a354"], | |
| 4: ["#ffffcc","#c2e699","#78c679","#238443"], | |
| 5: ["#ffffcc","#c2e699","#78c679","#31a354","#006837"], | |
| 6: ["#ffffcc","#d9f0a3","#addd8e","#78c679","#31a354","#006837"], | |
| 7: ["#ffffcc","#d9f0a3","#addd8e","#78c679","#41ab5d","#238443","#005a32"], | |
| 8: ["#ffffe5","#f7fcb9","#d9f0a3","#addd8e","#78c679","#41ab5d","#238443","#005a32"], | |
| 9: ["#ffffe5","#f7fcb9","#d9f0a3","#addd8e","#78c679","#41ab5d","#238443","#006837","#004529"] | |
| },YlGnBu: { |
anandpdoshi
/ 2013_03.css
Last active
December 15, 2015 12:29
ERPNext Open Day - March 2013 Presentation
View 2013_03.css
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| fallback-message display / hide | |
| */ | |
| .fallback-message { | |
| line-height: 1.3; | |
| width: 780px; | |
| padding: 10px 10px 0; | |
| margin: 20px auto; |
anandpdoshi
/ 2013_04.css
Last active
December 16, 2015 17:08
ERPNext Open Day - April 2013 by Anand Doshi
View 2013_04.css
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| fallback-message display / hide | |
| */ | |
| .fallback-message { | |
| line-height: 1.3; | |
| width: 780px; | |
| padding: 10px 10px 0; | |
| margin: 20px auto; |
anandpdoshi
/ 2013_05.css
Last active
December 18, 2015 00:29
ERPNext - Open Day - May 2013 - Anand Doshi
View 2013_05.css
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| html5doctor.com Reset Stylesheet | |
| v1.6.1 | |
| Last Updated: 2010-09-17 | |
| Author: Richard Clark - http://richclarkdesign.com | |
| Twitter: @rich_clark | |
| */ | |
| html, body, div, span, object, iframe, | |
| h1, h2, h3, h4, h5, h6, p, blockquote, pre, |
anandpdoshi
/ impress.js
Last active
February 6, 2017 15:36
ERPNext Open Day - June 2013 - by Anand Doshi
View impress.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * impress.js | |
| * | |
| * impress.js is a presentation tool based on the power of CSS3 transforms and transitions | |
| * in modern browsers and inspired by the idea behind prezi.com. | |
| * | |
| * | |
| * Copyright 2011-2012 Bartek Szopka (@bartaz) | |
| * | |
| * Released under the MIT and GPL Licenses. |
OlderNewer