Palazon

get BOM Item Rate based on summation of their individual line item

Install Palazon

bench get-app https://github.com/ashish-greycube/palazon

Add the Frappe Gems badge to your README

Maintain Palazon? Paste this into your README:

[![Listed on Frappe Gems](https://frappegems.com/api/method/frappe_gems.seo.badge?app=ashish-greycube%2Fpalazon)](https://frappegems.com/gems/apps/ashish-greycube/palazon)

About Palazon

# GreyCube Technologies Ltd. ## App Name - Palazon **Description** - Get BOM Item Rate based on summation of their individual line item for Sales Order and Quotation. Custom Print format which shows sub bom leaf items. ## How to install app - [ ] Go to bench directory i.e /home/ubuntu/frappe-bench - [ ] ~/frappe-bench$ bench get-app palazon https://github.com/ashish-greycube/palazon - [ ] ~/frappe-bench$ bench --site site1.local install-app palazon - [ ] ~/frappe-bench$ bench --site site1.local migrate - [ ] ~/frappe-bench$ bench clear-cache - [ ] ~/frappe-bench$ bench restart #### Edit sales_order.py and quotation.py Following line is to be added to sales_order.py and quotation.py ``` #start singapore - exploded bom from palazon.api import set_missing_item_details, set_items_amount, set_items #end singapore - exploded bom ``` [a] apps/erpnext/selling/doctype/sales_order/sales_order.py sales_order.py before changes ![Image](before_so.png) sales_order.py after changes ![Image](after_so.png) ``` class SalesOrder(SellingController): def __init__(self, *args, **kwargs): super(SalesOrder, self).__init__(*args, **kwargs) #start singapore - exploded bom from palazon.api import set_missing_item_details, set_items_amount, set_items #end singapore - exploded bom def validate(self): super(SalesOrder, self).validate() ``` [b] apps/erpnext/erpnext/selling/doctype/quotation.py quotation.py before changes ![Image](before_qo.png) quotation.py after changes ![Image](after_qo.png) ``` class Quotation(SellingController): #start singapore - exploded bom from palazon.api import set_missing_item_details, set_items_amount, set_items #end singapore - exploded bom def set_indicator(self): ``` ## For Print Format Customization changes required at below 3 places 1. Terms and Conditions in Quotation and Sales Order 2. LetterHead 3. Sales Taxes and Charges ### Step 1 Create Terms and Conditions for Sales Order Name : Standard Terms Sales Order ``` PRICE : IN SINGAPORE DOLLARS & SUBJECT TO {% if not taxes: %} 0 {%else%} {{taxes[0].rate}}{%endif%}% GST DELIVERY TERM : 2 WEEKS PAYMENT TERM : 30 DAYS ``` ### Step 2: Standard Terms Quotation ``` PRICE : IN SINGAPORE DOLLARS & SUBJECT TO {% if not taxes: %} 0 {%else%} {{taxes[0].rate}}{%endif%}% GST DELIVERY TERM : 2 WEEK VALIDITY OF QUOTE : 4 WEEKS FROM DATE OF QUOTATION PAYMENT TERM : 30 DAYS We look forward to receiving your purchase order soon. ``` ### Step 3: Go to Letterhead Add Header and Footer #### Header ```

WT WHITS TECHNOLOGIES

Blk 4012 , Ang Mo Kio Ave 10 #05-04A/04, Tech Place 1
Singapore 569628 ( GST Reg.No: 52-929615-B )
Tel :  6458 5707
Fax : 6458 5708

``` #### Footer ```
{% set u = frappe.get_doc("User", frappe.user) %} 
{{ u.first_name }} {{ u.last_name }}

``` ### Step 4: Go to Sales Taxes and Charges and make Singapore tax as default, it will load by default in new Sales Order /Quotation. To see the print format in action, go to New Sales Order/Quotation and select respective Term in Terms and Condition field. Go to Print Section. ## How to do bench update for future - [ ] ~/frappe-bench/apps/erpnext$ git status modified: erpnext/selling/doctype/sales_order/sales_order.py modified: erpnext/selling/doctype/quotation/quotation.py - [ ] ~/frappe-bench/apps/erpnext$ git stash - [ ] Once update, is done i.e. ~/frappe-bench$ bench update - [ ] Revert the stash changes back ~/frappe-bench/apps/erpnext$ git stash pop ## How to restore existing app data to new server - [ ] On new server with frappe and erpnext installed, install palazon app ~/frappe-bench$ bench get-app palazon https://github.com/ashish-greycube/palazon ~/frappe-bench$ bench --site site1.local install-app palazon - [ ] Restore DB from old server - [ ] Edit sales_order.py and quotation.py of erpnext (for detailed steps refer above) - [ ] ~/frappe-bench$ bench --site site1.local migrate - [ ] ~/frappe-bench$ bench clear-cache - [ ] ~/frappe-bench$ bench restart #### License MIT
#### Contact Us
1st ERPNext [Certified Partner](https://frappe.io/api/method/frappe.utils.print_format.download_pdf?doctype=Certification&name=PARTCRTF00002&format=Partner%20Certificate&no_letterhead=0&letterhead=Blank&settings=%7B%7D&_lang=en#toolbar=0) & winner of the [Best Partner Award](https://frappe.io/partners/india/greycube-technologies)
greycube.in
sales@greycube.in
LinkedIn
Blogs

Related Sales & CRM apps for Frappe & ERPNext

  • Crm — Fully featured, open source CRM
  • Flow — Frappe Flow — native AI agents, tools, and triggers for Frappe
  • Sales Kpi — Sales KPI app for ERPNext
  • Crm Override — An example Frappe app that demonstrates how to override Frappe UI based apps.
  • Eseller Suite — A comprehensive frappe app designed to help selling partners thrive on various online platforms like Amazon and Flipkart. With powerful tools for optimization, analytics, and automation, sellers can boost sales, optimize listings, and stay ahead of the competition effortlessly.
  • Sales Prediction — AI-powered sales forecasting using Prophet
  • Dlitscustom — Erpnext Custom Pricing rule , commission , tools etc..
  • Van Sales Pwa — Van Sales PWA: field sales app (customers, invoicing, payments, stock) with backend and frontend source in one app (like HRMS or POS Awesome). Install on any site, build, and open /pwa.