World's best free and open source ERP.

Frappe

Last update: Jan 7, 2023

Related tags

Miscellaneous support python distribution integrations localization agriculture erp profit accounting crm healthcare project-management manufacturing frappe erpnext procurement retail trademarks hrms asset-management

Overview

ERPNext

ERP made simple

https://erpnext.com

ERPNext as a monolith includes the following areas for managing businesses:

ERPNext requires MariaDB.

ERPNext is built on the Frappe Framework, a full-stack web app framework built with Python & JavaScript.

Full Install

The Easy Way: our install script for bench will install all dependencies (e.g. MariaDB). See https://github.com/frappe/bench for more details.

New passwords will be created for the ERPNext "Administrator" user, the MariaDB root user, and the frappe user (the script displays the passwords and saves them to ~/frappe_passwords.txt).

Virtual Image

You can download a virtual image to run ERPNext in a virtual machine on your local system.

ERPNext Download

System and user credentials are listed on the download page.

License

GNU/General Public License (see license.txt)

The ERPNext code is licensed as GNU General Public License (v3) and the Documentation is licensed as Creative Commons (CC-BY-SA-3.0) and the copyright is owned by Frappe Technologies Pvt Ltd (Frappe) and Contributors.

Contributing

Logo and Trademark

The brand name ERPNext and the logo are trademarks of Frappe Technologies Pvt. Ltd.

Introduction

Frappe Technologies Pvt. Ltd. (Frappe) owns and oversees the trademarks for the ERPNext name and logos. We have developed this trademark usage policy with the following goals in mind:

We’d like to make it easy for anyone to use the ERPNext name or logo for community-oriented efforts that help spread and improve ERPNext.
We’d like to make it clear how ERPNext-related businesses and projects can (and cannot) use the ERPNext name and logo.
We’d like to make it hard for anyone to use the ERPNext name and logo to unfairly profit from, trick or confuse people who are looking for official ERPNext resources.

Frappe Trademark Usage Policy

Permission from Frappe is required to use the ERPNext name or logo as part of any project, product, service, domain or company name.

We will grant permission to use the ERPNext name and logo for projects that meet the following criteria:

The primary purpose of your project is to promote the spread and improvement of the ERPNext software.
Your project is non-commercial in nature (it can make money to cover its costs or contribute to non-profit entities, but it cannot be run as a for-profit project or business). Your project neither promotes nor is associated with entities that currently fail to comply with the GPL license under which ERPNext is distributed.
If your project meets these criteria, you will be permitted to use the ERPNext name and logo to promote your project in any way you see fit with one exception: Please do not use ERPNext as part of a domain name.

Use of the ERPNext name and logo is additionally allowed in the following situations:

All other ERPNext-related businesses or projects can use the ERPNext name and logo to refer to and explain their services, but they cannot use them as part of a product, project, service, domain, or company name and they cannot use them in any way that suggests an affiliation with or endorsement by ERPNext or Frappe Technologies or the ERPNext open source project. For example, a consulting company can describe its business as “123 Web Services, offering ERPNext consulting for small businesses,” but cannot call its business “The ERPNext Consulting Company.”

Similarly, it’s OK to use the ERPNext logo as part of a page that describes your products or services, but it is not OK to use it as part of your company or product logo or branding itself. Under no circumstances is it permitted to use ERPNext as part of a top-level domain name.

We do not allow the use of the trademark in advertising, including AdSense/AdWords.

Please note that it is not the goal of this policy to limit commercial activity around ERPNext. We encourage ERPNext-based businesses, and we would love to see hundreds of them.

When in doubt about your use of the ERPNext name or logo, please contact Frappe Technologies for clarification.

(inspired by WordPress)

Comments

Subscription functionality redesign
[ ] Create new "Subscription" doc type as below

[ ] Remove the current fields of the "recurring" section from the doc types: Sales Order, Sales Invoice,Purchase Order, Purchase Invoice

[ ] Refactor code that uses current fields to use the new "Subscription" doc type fields to create recurring documents and update the "Subscription ID" back to the base document(eg:Sales Order, Sales Invoice,Purchase Order,Purchase Invoice)

This new design will reduce redundant data which gets copied over to multiple invoices and also give a single page from where the user can set "Subscription IDs" for various doc types.
Shortlisted
opened by PawanMeh 73
[v12.1.6] Decimals in Currencies not working
Installed Apps ERPNext: v12.1.6 (version-12) Frappe Framework: v12.0.16 (version-12)

I’ve recently updated to v12.1.6. Afterwards the currencies are not working as expected.

The issue is about decimals:

100 converts to 100.00 (correct)

100,1 converts to 1.001,00 (wrong)

100,55 converts to 10.055,00 (wrong)

Quantaties, percentages, etc. are working as expected. Only currencies are wrong. The same happens when I use points instead of comma.

Please see also: https://discuss.erpnext.com/t/v12-1-6-decimals-in-currencies-not-working/53486 https://discuss.erpnext.com/t/decimals-behaving-strangely/53506
opened by ophl55 52
Support for Making Tax Digital (UK)
In the UK taxes are moving towards being submitted electronically via an API under the Making Tax Digital plan. Initially this is just for VAT-registered businesses to submit their VAT returns and needs to be in place by 1st April 2019.

They provide a list of existing software that can do this. I didn't look at all of them on the list, but I'm not aware that any of them are open source.

The documentation looks pretty good from what I've seen:

overview

developer tutorials

a somewhat verbose step-by-step walk through (pdf)

developer API docs

What would be involved in getting this supported by erpnext? Is this something that can be implemented as a seperate app/add-on, or would it need to go into the core?

I am a python developer myself and can likely work on this if we choose to use erpnext (which is dependent on being able to implement this).
localization
opened by nicksellen 52
[Feature Request] Multiple due dates in the same invoice

Its a very commom practice in Brazil, Spain and some other countries, Total must be split into multiple due dates against the same invoice (sales and purchase).

This is how it works on oodoo and others https://discuss.erpnext.com/t/payments-due-to-30-60-90-days-very-common-spanish-local-functionality/12932
selling buying

opened by applepipe 52
"Update this application" fails

Setup > Update this application. Fails to succeed

Traceback (most recent call last): File "lib/wnf.py", line 490, in run() File "lib/wnf.py", line 418, in run patch_sync_build() File "lib/wnf.py", line 81, in patch_sync_build patch_sync() File "lib/wnf.py", line 92, in patch_sync sync_all() File "lib/wnf.py", line 73, in sync_all webnotes.model.sync.sync_all(force) File "/home/erpnext/erpnext/lib/webnotes/model/sync.py", line 12, in sync_all sync_for("lib", force) File "/home/erpnext/erpnext/lib/webnotes/model/sync.py", line 18, in sync_for folder), force, sync_everything) File "/home/erpnext/erpnext/lib/webnotes/model/sync.py", line 41, in walk_and_sync if import_file(module_name, doctype, name, force): File "/home/erpnext/erpnext/lib/webnotes/modules/import_file.py", line 44, in import_file ret = import_file_by_path(path, force) File "/home/erpnext/erpnext/lib/webnotes/modules/import_file.py", line 65, in import_file_by_path import_doclist(doclist) File "/home/erpnext/erpnext/lib/webnotes/modules/import_file.py", line 115, in import_doclist new_bean.insert() File "/home/erpnext/erpnext/lib/webnotes/model/bean.py", line 299, in insert return self.save() File "/home/erpnext/erpnext/lib/webnotes/model/bean.py", line 312, in save self.save_main() File "/home/erpnext/erpnext/lib/webnotes/model/bean.py", line 255, in save_main self.doc.save(check_links = False, ignore_fields = self.ignore_fields) File "/home/erpnext/erpnext/lib/webnotes/model/doc.py", line 416, in save keep_timestamps=keep_timestamps) File "/home/erpnext/erpnext/lib/webnotes/model/doc.py", line 370, in _update_values (self.doctype, ', '.join(update_str), "%s"), values) File "/home/erpnext/erpnext/lib/webnotes/db.py", line 130, in sql raise e _mysql_exceptions.OperationalError: (1054, "Unknown column 'icon' in 'field list'")

opened by dannyarcher 44
Feature Request: Notification when user is mentioned in comment

ERPNext offers the awesome feature of basically commenting on everything. However it would be great if I could mention somebody in the comment like "@Mark please check out this sales order, it's stalling, we have to react before the customer writes us". Then this should be listed in the users notifications or some sort of inbox/messages so the user can check out whats happening needing his attention. This is how Asana does it and after an "@" mention happened the user is automatically a follower of that process and will be informed in the inbox of any further comments.
paid development

opened by dottenbr 41
Bugs in charts.erpnext.com
Reported by user via Support Issue /WN-SUP31248

edit the chart of accounts: nothing happens when we click on the button start or fork.

download chart of accounts: nothing happens when you click on download.

create a new chart of accounts: nothing happens when you click on create a new chart of accounts

bug
opened by umairsy 40
Loyalty Program
Note:

There can be multiple Loyalty Programs.

All the related customers can be auto opt-in for the program or can also be done manually from the customer doctype.

The collection factor can be flat or tiered on the basis of the total spent done by the customer.

All the loyalty points will be stored in the simple ledger after booking the income (via sales invoice only).

All the loyalty points earned has expiry date calculated as per the loyalty program.

Loyalty points will be deleted after canceling the invoice.

Redemption will be done via the Coupon/Gift Card (WIP) (Depends on https://github.com/frappe/erpnext/pull/12559)

Loyalty Program

Loyalty Point Entry/Ledger

Loyalty Point in Customer record

Fixes https://github.com/frappe/erpnext/issues/12322 Fixes https://github.com/frappe/erpnext/issues/12790
accounts CRM
opened by manassolanki 40
Add stripe payment service as a 'Pay Now' option on Sales Invoices

Feature request in User Story:

As a customer of a company that uses ERPNext, I want to receive invoices via email, and click a 'Pay Now' link on the invoice, that opens a webpage (https://erpnext.example.net/invoice/036zfd34-c3cd-4dce-a808-32xefaa1302b) so that I can pay the invoice by credit-card quickly and easily.

As a billing user of ERPNext, I want to send my customers invoices that have a 'Pay Now' link on the invoice PDF that, when clicked, the customer is taken to a on-line payment screen where the payment is processed via stripe, so that erpnext automatically updates the Sales Invocies as paid.

Examples of how a similar feature is implemented in the Xero accounting product;

Image showing payment link on a Invoice PDF

Image showing invoice on-line and prompting user for payment details.

The Pay Now link on the Payment Invoice has a hashed URL, which makes it a 'private link'. When the customer opens the link, they see their invoice, and the option to pay that invoice via credit-card (in this case stripe).

This feature request is related to #2088
accounts

opened by jevonearth 38
Batch Update of BOM Costs #feature request

Hello,

It would be nice to have a tool in the Manufacturing module that would allow us to update all the BOM costs at once. After an Item price change, we need to update manually every single BOM the item is in. This can take forever if you have hundreds of BOM and Items.

Best regards,

Nicolas

Want to back this issue? Place a bounty on it! We accept bounties via Bountysource.
manufacturing

opened by nmikaty 36
Multi-currency per account
[x] Add Account Currency to Account & Party

[x] Add Debit (in Alt Currency) and Credit (in Alt Currency) to GL Entry

[x] [validation] Do not allow currency to change if any transaction has been made for both Party and Account

[x] Currency input on creation of account from Chart of Accounts

[x] In GL Entry posting, also post in alternate currency if party and account currencies are alt and match

[x] Currency in Party and Account (Debtors) must match

[x] In Journal Entry, on selection of account, select currency for the row.

[x] In Journal Entry, Sales Invoice, Purchase Invoice post to default currency (DC) (based on exchange rate) and Account Currency (AC)

[x] Fetch Exchange rate in Journal Entry based on average exchange_rate in case of inter-bank transfer, otherwise fetch current exchange rate

[x] Currency in transactions must be either in party currency or company currency

[x] All selected accounts in a transaction must be with transaction currency or in company currency

[x] Invoice outstanding, advance amount in party account currency

[x] Invoice paid amount and write off amount in both company currency and transaction currency

[x] Patch for Outstanding, Paid, advance, write-off amount

[x] Payment Tool in party currency

[x] Accounting Currency in Customer / Supplier, patch for existing records

[x] Force to mention Receivable / Payable account in Customer/Supplier, if party account currency is different from company currency

[x] Show Receivable / Payable accounts, in accounting currency for customer/supplier and validate

[x] Update "Advance Paid" in Order, based on party account currency, validate with grand total based on currency

[x] Test Case

[x] Patch

Set currency in Account, GL Entry, Journal Entry

Update base_paid_amount, base_write_off_amount, party_account_currency value in sales / purchase invoice

Update Exchange Rate, debit/credit in account currency in Journal Entry and GL Entry

Set Accounting Currency for party

Set party account if default currency of party other than company's default currency

[x] Reports: Show Balance in account currency if filtered by account and account currency is different from company currency

General Ledger

Receivable

Payable

[ ] Reports: Show all balances in company currency based on exchange rate as on filter

Trial Balance

Balance Sheet

P&L

Financial Analytics

[x] Update manual

[x] Add multi currency data in erpnext-demo

[x] Set currency and exchange rate based on customer in Quotation while making from Opportunity

[x] Set currency and exchange rate based on Supplier in Supplier Quotation / Purchase Order while making from Material Request

Inter-currency Conversion

Account Debit Credit Debit (Alt) Credit (Alt)

Paypal (USD) 6000 $100

Bank (INR) 6100

Exchange Gain / Loss (INR) 100

Want to back this issue? Place a bounty on it! We accept bounties via Bountysource.
opened by rmehta 36
Item code not fetching in quality inspection

Information about bug

Item code is not fetching with respect to the reference we are doing. Like stock entry or sales invoice

attached the snapshot

Module

quality

Version

Installation method

FrappeCloud

Relevant log output / Stack trace / Full Error Message.

No response
bug

opened by sapl-santhosh 0
Accounts Payable Summary Report shows advance amount

Information about bug

When I reconcile payments and with supplier invoices from payment reconciliation. The invoice status is changed to "Paid" but in accounts payable summary, it shows the amount in advance amount section. In the genereal ledger of that supplier, the invoice number is also not showed against the payment entry although when I open the payment entry, the invoice is linked with that payment entry.

Module

accounts

Version

ERPNext: v14.12.0 (version-14) Frappe Framework: v14.21.1 (version-14)

Installation method

manual install

Relevant log output / Stack trace / Full Error Message.

No response
bug

opened by zahidmansoor 0
fix: better handling of duplicate bundle items
Make Sales Order with Bundled Item

Save

Add the Same Bundled Item and remove the first item

Save

Items from bundle [1] will still be in Packed Item table.
needs-tests
opened by ruthra-kumar 1
Incorrect values reflected in Stock Ledger vs Stock Recon

Information about bug

A client performed a stock recon for a single item with qty of 24 (see 1st image below). However, when we looked at the Stock Ledger report, it reflects 2 recon entries under the same voucher number (one, being a deduction of 18 units and the other, being the actual recon qty). At the same time, the final balance qty after the recon is also incorrect (see 2nd image below). Why is it like this?

Module

stock

Version

version 13

Installation method

None

Relevant log output / Stack trace / Full Error Message.

No response
bug

opened by kaienmanalo 0
Subcontract Manufacturing enhancement
Problem Statement: In version 14 we have extend subcontract Module. but still lots of issue regarding E-way Bill and its functionality not cope with GST. To improve this i have come up with solution need community input.

first of all discuss current Available Scenario: 1.Item: FG item, RAW Material Items, Service Item 2.BOM: FG Item with Raw material we create for subcontracting 3.Purchase Order: We create Purchase Order(is_subcontracted=1) then we have to use FG item and Service Item in PO child Table. 4.Subcontract Order: We create Subcontract Order from PO. which contain information related to FG, Service Item, Raw Material Item. 5.Subcontract Stock Entry: from subcontract order we need to create stock entry for vendor to move material from company warehouse to Supplier Warehouse. 6. Subcontract Receipt: From subcontract Order we need to create subcontract Receipt (which FG movement from Supplier warehouse to company warehouse).

Major Problem in above workflow: 1. Any good movement with goods value 50000 we need to generate e-way bill. in case of stock entry its not possible. 2. any movement we need to track record of GST tax which is not possible above.

My current solution for this, we can come with this workflow as mention in this Image.

Step 1 to 4 we keep it as it is. 5. Subcontract Delivery Note: like subcontract receipt create SDN. Which outward supply with tax and charges table. Contain tax detail and stock movement to supplier warehouse. It is easy for e-way bill generation 6. Subcontact Receipt: From subcontract Order we need to create subcontract Receipt (which FG movement from Supplier warehouse to company warehouse) with Tax details. It is easy for e-way bill generation

Need community input and any gap can be extend further

Update 1:

What will be implication of Scrap Material at Subcontractor how we will record and received scrap in subcontract Receipt

feature-request
opened by vishdha 0

Releases(v14.12.0)

v14.12.0(Jan 4, 2023)
14.12.0 (2023-01-04)

Bug Fixes

[concurrency issue] incorrect picked qty in sales order (e7254fd)

fg_item_qty in non-subcontracted PO (6e15331)

shipping_address for non-drop shipping item (a7a3654)

shipping_address in PO (448fbe5)

add missing 'ordered_qty' to get_bin_details (55e8e45)

consider child nodes while getting bin details (e296408)

Conversion factor error for invoices without item code (petty expenses) (#32714) (ba5a149)

Customer Primary Contact (backport #33424) (#33440) (73c9820)

Default dimensions on fetching items from BOM (backport #33439) (#33459) (a332b22)

Deferred revenue date comparison (#33515) (027510b)

ERR journals reported in AR/AP (823b352)

Get payment entry button not visible in Bank Clearance doc (backport #33518) (#33525) (fcf052d)

Missing opening entry in general ledger (backport #33519) (#33526) (8e375db)

Multi-currency issues in Bank Reconciliation Tool (#33488) (d030852)

Multiple rows for same warehouse and batches in pick list (backport #33456) (#33458) (a166a76)

payment terms and sales partner filter issue in AR/AP report (0f6790b)

pricing rule: consider child tables in condition (backport #33469) (#33470) (3bceb47)

Random behaviour while picking items using picklist (backport #33449) (#33450) (1edde9c)

set supplier details while mapping SE(Send to Subcontractor) (06e13b6)

timeout error while submitting stock entry (f30f77c)

typerror on multi warehouse in Packed Items (9b24940)

use base_net_amount in case of missing stock qty (#33457) (88ca780)

Features

Accounting Dimension updation in Payment Request and Entry (#33411) (e7704b2)

Source code(tar.gz)
Source code(zip)
v13.43.0(Jan 4, 2023)
13.43.0 (2023-01-04)

Bug Fixes

shipping_address for non-drop shipping item (19feebb)

shipping_address in PO (1068d0e)

add missing 'ordered_qty' to get_bin_details (66ba098)

consider child nodes while getting bin details (c9bf062)

Conversion factor error for invoices without item code (petty expenses) (#32714) (acf8b46)

debit note not pulled on reconciliation tool (cf133b2)

Deferred revenue date comparison (backport #33515) (#33517) (ea99ac9)

ecommerce: remove query parameters from referrer (backport #33269) (#33513) (6516e80)

ERR journals reported in AR/AP (c850635)

Missing opening entry in general ledger (backport #33519) (#33527) (865f233)

Multi-currency issues in Bank Reconciliation Tool (backport #33488) (#33493) (4ba2f1e)

No permission to read doctype (8e1c0cd)

provision to set tax_deducted_till_date after document is submited (64454e0)

reconciled credit notes being fetched again in Payment Reconciliation tool (#33471) (5ec11ba)

Tax withheld vouchers naming rule (#33467) (334219e)

test: holiday list dates in attendance test setup (8df1151)

test: monthly attendance sheet (e5a187e)

typerror on multi warehouse in Packed Items (6a394c5)

use base_net_amount in case of missing stock qty (#33457) (6e363a6)

use get_all instead of get_value as get_value api dont supports between condition (bc04e05)

Features

explicit time period for mark attendance (d2f86ea)

provision to setup opening balances for earnings and deductions while creating SSA (c3b9059)

Source code(tar.gz)
Source code(zip)
v13.42.7(Dec 30, 2022)
13.42.7 (2022-12-30)

Bug Fixes

debit note not pulled on reconciliation tool (e01ff0d)

Source code(tar.gz)
Source code(zip)
v13.42.6(Dec 29, 2022)
13.42.6 (2022-12-29)

Bug Fixes

reconciled credit notes being fetched again in Payment Reconciliation tool (#33471) (b4589d8)

reconciled credit notes being fetched again in Payment Reconciliation tool (#33471) (37ae2df)

Source code(tar.gz)
Source code(zip)
v14.11.1(Dec 27, 2022)
14.11.1 (2022-12-27)

Bug Fixes

Random behaviour while picking items using picklist (backport #33449) (#33451) (abfb3bf)

Source code(tar.gz)
Source code(zip)
v14.11.0(Dec 20, 2022)
14.11.0 (2022-12-20)

Bug Fixes

Consolidated financial report (16ce411)

Cost center filter not working in cash flow report (ce5065b)

Cost Center for tax withholding invoices (728643a)

cost_center filter fix for 'Get Outstanding Invoice' in PE (ff61997)

cost_center filter gives incorrect output (9b2b281)

daily scheduler to identify and fix stock transfer entries having incorrect valuation (deb3efd)

disabled items showing in the report 'Itemwise Recommended Reorder Level (493509e)

get_serial_nos_for_fg() missing 1 required positional argument: 'args' (bddb5b8)

incorrect type hints (backport #33381) (#33384) (fa77259)

Payment Request flow fixes from Order to Payment Entry (a01db8f)

remove unnecessary permissions from Appointment and Appointment Booking Settings (#33358) (#33395) (6ef7eaf)

translation for warning on Overbilling/-receipt/-delivery (ba51d50)

Unable to import COA through importer (f8c09ee)

unsupported operand type(s) for +: 'int' and 'NoneType' (7bdfb3d)

unsupported operand type(s) for +=: 'int' and 'NoneType' (88dc81b)

use highest precision for exchange rate. (4a8a84d)

Features

Ignore company related doctype for other apps via hooks (cd5a2af)

improve visibility of default values (7ff50b9)

incoterm named place (bfe57ac)

more control when printing RFQ (07cda0a)

Source code(tar.gz)
Source code(zip)
v13.42.5(Dec 20, 2022)
What's Changed

fix: get_serial_nos_for_fg() missing 1 required positional argument: … (backport #33332) by @mergify in https://github.com/frappe/erpnext/pull/33334

fix: translatability of warning on overbilling/-receipt/-delivery (backport #33323) by @mergify in https://github.com/frappe/erpnext/pull/33343

fix: unsupported operand type(s) for +: 'int' and 'NoneType' (backport #33354) by @mergify in https://github.com/frappe/erpnext/pull/33357

fix: disabled items showing in the report Itemwise Recommended Reorder Level (backport #33355) by @mergify in https://github.com/frappe/erpnext/pull/33360

perf: using subquery in get_dr_or_cr_notes() to improve performance by @ruthra-kumar in https://github.com/frappe/erpnext/pull/33367

fix: unsupported operand type(s) for +=: 'int' and 'NoneType' (backport #33382) by @mergify in https://github.com/frappe/erpnext/pull/33392

fix: daily scheduler to identify and fix stock transfer entries having incorrect valuation (backport #33387) by @mergify in https://github.com/frappe/erpnext/pull/33390

fix: Cost center filter not working in cash flow report (backport #33393) by @mergify in https://github.com/frappe/erpnext/pull/33401

chore: release v13 by @frappe-pr-bot in https://github.com/frappe/erpnext/pull/33403

Full Changelog: https://github.com/frappe/erpnext/compare/v13.42.4...v13.42.5
Source code(tar.gz)
Source code(zip)
v14.10.1(Dec 13, 2022)
14.10.1 (2022-12-13)

Bug Fixes

Enough Parts to Build in BOM Stock Report (3b9e9d2)

Material Request reference in internal Sales Order (416d178)

add translation variable order (ef933a8)

Buying and selling check in pricing rule (f5205a5)

ecommerce: remove query parameters from referer (40621b9)

handle_post_depr_entries_fail, show error alert and send email (b661f57)

incorrect balance on parent company due to key mismatch (436e93c)

index error on customer master (02cc618)

Maintain Same Rate Throughout Sales Cycle doesn't work (5398cf8), closes #32923

order status in Production Planning Report (a657db6)

Permission issue in Tax Detail report (7a5b80d)

pos: variable typo: s_pos -> is_pos (afbd48f)

Reapply pricing rule on qty change (c726c16)

Remove free items (5e5937d)

total value in Warehouse Wise Stock Balance (c5a54d7)

Performance Improvements

add indexes on payment entry reference (backport #33288) (#33289) (ce63086)

Source code(tar.gz)
Source code(zip)
v14.10.0(Dec 6, 2022)
14.10.0 (2022-12-06)

Bug Fixes

add company filter in RFQ Items (7c1595e)

Allow item rate udpates for non-stock invoices (0307656)

Bundle item rates (82cdf49)

data import mandatory account_head, charge_type (653cb9f)

default clear repost logs (e039a14)

Due date for month end payment term (9b40b7f)

Error on making stock entry from material request (701ccc3)

key error on p/l and balance sheet reports on foreign currency (23a0a53)

key error while filtering on date range and different currency (08bca7d)

lint: trailing whitespace (fae941c)

non empty FG batch picked while completing work order (e5e6b5d)

pos: partial return amount update (91920f4)

reload currency exchange settings (5b5a85e)

replace sql code with fields list in get_cached_value (e18d0ec)

Tax withholding net total for PI in reports (f87c3c6)

test case (39680ed)

type error on Sales Pipeline Analytics (3af2b9b)

use is_last_day_of_the_month in test_scrap_asset (fc175e2)

UX: Alert on change of item rate in Stock Entry (b2da76f)

Features

warehouse wise stock balance (7027fda)

Source code(tar.gz)
Source code(zip)
v14.9.0(Nov 29, 2022)
14.9.0 (2022-11-29)

Bug Fixes

production_item filter in Job Card Summary Report (c9f4f60)

Work Order filter typo in Job Card Summary Report (b157193)

Auto repeat date validations (2aada1a)

check for session user rather than owner (c9c7222)

company name with , in Job Card Summary Report (9c6d020)

company name with , in Work Order Summary Report (bc649b3)

create rounding gl entry for PCV during gle post processing (fd4bcd9)

Debit and Credit not equal while submitting PI containing asset item (c11a31b)

disbursable amount on currrent security price (5edaf83)

Dispatch address display (ef687e2)

incorrect balance qty (f92b501)

job card for quantity UX (59e2ab7)

MR Item description and item_name gets reset on qty change (85d108b)

only show serial no batch selector only once (8d0f715)

opportunity list doesn't show assigned user (backport #33110) (#33131) (0ba2a4d)

pos: filter on customer groups (c1ae5b0)

pos: warehouse should be in company (c03ec80)

precision in asset test_scrap_asset (0fe5e9a)

production plan UX (4607590)

remove duplicate schema (cdd13cd)

remove obsolete comment (978924a)

reposting error AttributeError: 'datetime.timedelta' object has no attribute 'replace' (4b0c9b6)

reset voucher_type and voucher_no if based_on is set to Item and Warehouse (e530f0b)

UX for inventory dimension (f1dd4d0)

ux: Action buttons in Bank Reconciliation (93b8cc3)

validation msg in stock entry (65ac84e)

Valuation Rate column UX in stock ledger report (5c065e8)

Features

add connections to Incoterm doctype (89b9a06)

add doctype Incoterm (b711931)

add german translations for incoterm titles (f7988de)

add incoterm to purchasing transactions (88346b1)

add incoterm to sales transactions (fcfe0cb)

create Incoterm records after install (93e029d)

create incoterms and migrate shipments (014896a)

german tax templates (5652af0)

item wise tds calculation for purchase order (5f8f574)

item wise tds calculation for purchase order. (2bd8bd2)

item wise tds in purchase order (ba36435)

make Material Request for sub-assembly items (5fc4dfa)

pos: invoice: fitler warehouse by company (c379baf)

validate repost item valuation against accounts freeze date (04f50ea)

Source code(tar.gz)
Source code(zip)
v13.42.2(Nov 29, 2022)
13.42.2 (2022-11-29)

Bug Fixes

production_item filter in Job Card Summary Report (ce54198)

Work Order filter typo in Job Card Summary Report (2de239c)

cannot update auth token until token expiry if credentials change (2121714)

company name with , in Job Card Summary Report (ffef0cb)

company name with , in Work Order Summary Report (11978fc)

create rounding gl entry for PCV during gle post processing (7af4597)

disbursable amount on currrent security price (eca2d96)

Dispatch address display (10cfcb5)

incorrect balance qty (78e64fa)

linter (b91860d)

MR Item description and item_name gets reset on qty change (b66976b)

Multicurrency invoice with exchange gain and loss showing up in AR/AP report (d38a289)

only consider draft pending asset repair docs (6da7b38)

only show serial no batch selector only once (0c6a7ce)

reset voucher_type and voucher_no if based_on is set to Item and Warehouse (ff59483)

validate voucher type while checking journal entry against payroll entry (07c25ac)

Source code(tar.gz)
Source code(zip)
v13.42.1(Nov 22, 2022)
13.42.1 (2022-11-22)

Bug Fixes

Accounting Dimension filtering for Sales and Purchase Report (58f3f2b)

cast POS query inputs to integers (backport #32975) (#32978) (3aba14f)

GP incorrect buying amount if no upd on SI and Delivery Note (40bb2cb)

incorrect fix of conversion factor in PP (726c3d3)

linter issue (72f9308)

make is_internal_supplier read-only (30b5d1c)

Opening journal entry templates (4ad3e28)

pos: item selector image border radius (ab31eb4)

realtime: Restrict updates to only last modified or current user (#33034) (ecdd849)

use list() on self mutating iteration (0070b5e)

Source code(tar.gz)
Source code(zip)
v14.7.0(Nov 15, 2022)
14.7.0 (2022-11-15)

Bug Fixes

add translate function to valitate company msg in chart of accounts importer (8de4430)

check type for reference name (a305793)

don't set WIP Warehouse if is checked in WO (f923183)

GP incorrect buying amount if no upd on SI and Delivery Note (2d8f00a)

incorrect fix of conversion factor in PP (c48d00a)

Label for applicable dimension table (eb4f8e4)

Maintain same rate between Quotation and Sales Order (6c155d2)

Project filter in timesheet (37bed12)

Purchase Receipt timeout error (0d5b726)

repayment schedule regeneration (2f5033b)

set WIP Warehouse in Job Card (c294652)

set stock UOM in args to ensure item price is fetched (a4187b9)

test cases (071ee5d)

ux: Tab break in Customer and Supplier form (eeaa932)

Write Off section visibility for non POS Invoices (07badbc)

Features

Repost Payment Ledger entries for vouchers (de59b50)

Reverts

Revert "fix: get consumed_qty based on received_qty in SCR" (7fd6c43)

Revert "fix: set received_qty before_validate SCR" (0ecb44d)

Source code(tar.gz)
Source code(zip)
v13.42.0(Nov 15, 2022)
13.42.0 (2022-11-15)

Bug Fixes

add Document Date in E-Invoice print format (a16347f)

ambiguous 'cost_center' on payment reconciliation (e9e5ded)

check type for reference name (ad648f3)

don't set WIP Warehouse if is checked in WO (4a17711)

Label for applicable dimension table (cbc8b2d)

Pricing rule item group consider UOM (1ed0b6e), closes #32566

query condition change (88ce59a)

repayment schedule regeneration (a19031c)

set WIP Warehouse in Job Card (f09e427)

set stock UOM in args to ensure item price is fetched (bd2242b)

wrong totals in hsn summary report (79d508f)

Features

page break in SoA pdf (e93ac3c)

Source code(tar.gz)
Source code(zip)
v14.6.0(Nov 8, 2022)
14.6.0 (2022-11-08)

Bug Fixes

Material Consumption option in case of Skip Transfer to WIP in WO (8c856cd)

add translate function to name of chart labels in budget_variance_report.py (16f364d)

add translate function to name of chart labels in deferred_revenue_and_expense.py (b8caa58)

add translate function to period in stock_analytics.py (b0c06d5)

add translate function to period in sales_analytics.py (e681f06)

add translate function to string on budget_variance_report.js to match the variance word translated (595aaad)

Auto advance allocation against partial invoices (b7763d9)

auto increment qty if item table has no items (d8e403b)

conflicts (ab87a95)

correct linters (8f6f9a4)

correct linters (440e208)

correct linters (5acc9be)

Create POS Opening Entry POS Profile filter. (60af9c0)

Disable tax included prices for internal transfers (#32794) (6838e5e)

for asset's purchase_date, if bill_date is set, use that instead of posting_date (01a1c96)

get consumed_qty based on received_qty in SCR (ea9a502)

Increase columns width in Warehouse wise Item Balance Age and Value (0b09c31)

linter (af60c8f)

make BOM required in SCR Item (3f79a05)

make consumed_qty editable when backflush based on Material Transfer (2c5a8c4)

make consumed_qty read-only in SCR Supplied Items (68229f0)

map BOM while mapping the return SCR (e629cba)

mysql syntax issue (4d9bbd4)

not able to select customer / supplier (6989cdf)

refactor code for better translatable string (2dc24f2)

refactor code for better translatable string in stock_ageing.py (0ead516)

rename test method (97445d9)

Scan Barcode UX (1944f4d)

set received_qty before_validate SCR (e316558)

test cases (0feec4c)

trailing whitespace (31bada9)

update advance paid in SO/PO from Payment Ledger (a561432)

use flt instead of cint in get_batch_no (6510464)

Features

Item Wise TDS Calculation (b9fb104)

Performance Improvements

use get_cached_value instead of db.get_value in controllers (#32776) (34ca17a)

Source code(tar.gz)
Source code(zip)
v13.41.1(Nov 8, 2022)
13.41.1 (2022-11-08)

Bug Fixes

Material Consumption option in case of Skip Transfer to WIP in WO (418c131)

Create POS Opening Entry POS Profile filter. (76e4bb4)

Disable tax included prices for internal transfers (#32794) (84ee1b8)

for asset's purchase_date, if bill_date is set, use that instead of posting_date (1d23c9a)

Reset advance paid amount on Oreder cancel and amend (e32e0bc)

use flt instead of cint in get_batch_no (601b1e3)

Source code(tar.gz)
Source code(zip)
v14.5.1(Nov 3, 2022)
14.5.1 (2022-11-03)

Bug Fixes

not able to select customer / supplier (dd4dbd4)

Source code(tar.gz)
Source code(zip)
v14.5.0(Nov 1, 2022)
14.5.0 (2022-11-01)

Bug Fixes

add Sales Order reference in Material Request Dashboard (fc63892)

Add condition for discount section collapse (953f78d)

Budget validation for main cost center (89a1c83)

Clear invoice table post importing invoices (6eafff8)

Company bank account filter in Bank Clearance (797512c)

Curreny in SOA print for multi-currency party (195500c)

duplicate custom fields for inventory dimension (1152ac3)

Filter fixes in Accounts Payable report (29197dc)

Issues while cancel/amending Purchase Invoice with TDS enabled (74a6479)

key error in filter access (6114241)

Mode of payment for returns in POS Sales Invoice (a260426)

Pass project to stock entry items (4035873)

pro_rata_amount calculation in assets tests (d1b2786)

Reference due date field type in Journal Entry Accounts table (faf25c0)

Reset advance paid amount on Oreder cancel and amend (34bd783)

Total Sales amount update in project via Sales Order (d742e6d)

Features

additional filters on Payment terms report (a03ec0a)

pricing rule: free qty rounding and recursion qty (#32577) (9b66020)

Source code(tar.gz)
Source code(zip)
v13.41.0(Nov 1, 2022)
13.41.0 (2022-11-01)

Bug Fixes

add Sales Order reference in Material Request Dashboard (cb89dba)

Do not force eligibilgity of itc for reverse charge (9dc0edf)

filter return pos in reconciliation tool (b877b0d)

group warehouse filter not working for Batch-wise Balance history report (310e7c5)

Issues while cancel/amending Purchase Invoice with TDS enabled (8888957)

Mode of payment for returns in POS Sales Invoice (9b63a1a)

Features

Repayment schedule types for term loans (c2817be)

Source code(tar.gz)
Source code(zip)
v14.4.0(Oct 26, 2022)
14.4.0 (2022-10-26)

Bug Fixes

Advance paid amount in orders (backport #32642) (#32648) (8a88105)

allow to create Sales Order from expired Quotation (#32641) (ccc58f4)

Billing Address for inter-company purchase docs (f8934fa)

BOM cost update message (e539579)

dont update item info twice (8876904)

incorrect qty in material request (da538a3)

number of months subscription plan (fff9e76)

overlap error not raised for job card in case of workstation with production capacity (ed2a093)

party type and party mandatory on updating outstanding (9a5e238)

searchfield not working for cuctsomer, supplier as per customize form (fb1c307)

unset contact details (d7a65b1)

Features

Basic Payment Ledger report (5cb9f7b)

Repayment schedule types for term loans (6ce32fd)

Performance Improvements

cache barcode scan result (backport #32629) (#32672) (3300856)

Source code(tar.gz)
Source code(zip)
v13.40.2(Oct 19, 2022)
13.40.2 (2022-10-19)

Bug Fixes

Brand Defaults filters (b1c70af)

don't try to update youtube data if disabled in settings (backport #32588) (#32590) (7e7122b)

Ignore linked purchase invoice on cancel (eec770a)

Party account for multi-order invoices (0ae2a4f)

pricing rule item code UOM apply & conversions (backport #32566) (#32636) (b8d97b8)

Source code(tar.gz)
Source code(zip)
v14.3.1(Oct 18, 2022)
14.3.1 (2022-10-18)

Bug Fixes

Brand Defaults filters (cb0c4b5)

add project settings to projects workspace (backport #32568) (#32600) (af4dafd)

delete old ple's on item value repost (62cabdf)

don't try to update youtube data if disabled in settings (backport #32588) (#32589) (ed85683)

group warehouse filter not working for Batchwise Balance history report (faedd85)

Ignore linked purchase invoice on cancel (cc938fb)

linter (831f60f)

Party account for multi-order invoices (eaea846)

pricing rule item code UOM apply & conversions (backport #32566) (#32637) (ffd82f3)

Renamed Dashboard tab label to Connections (dac5989)

Renamed Notes section to Comments (9e94dd9)

type-cast while saving an item (backport #32549) (#32578) (829a0ff)

Source code(tar.gz)
Source code(zip)
v14.3.0(Oct 12, 2022)
14.3.0 (2022-10-12)

Bug Fixes

consider outgoingrate while valuation rate calculate (423c019)

consider sales rate as incoming rate for transit warehouse in purchase flow (948b231)

Do not add tax withheld vouchers post tax withheding in one document (bd8e61b)

Explicitly update modified (backport #32519) (#32575) (154904e)

Hanlde rounding loss for internal transfer (8eda2db)

Incoming rate precision fixes for intra company transfer (b653f43)

make readings status mandatory in Quality Inspection (50d790c)

minor cleanup (236a5f3)

more fields reordering related to Tab Break (db4fbc9)

PO cancel post advance payment cancel against PO (bda25c4)

removed unnecessary imports (31782d6)

set Quality Inspection status based on readings status (e25db8b)

single column indexes (backport #32425) (#32513) (2f1b8af)

Tax withholding related fixes (d5f6938)

test case (0b26131)

test: test_rejected_qi_validation (943e619)

TooManyWritesError during reposting of stock (73742ff)

unlink payment on invoice cancellation (8ba503b)

use naming_series in budget (0a24859)

value error on pos submit (4b65dd7)

Features

JE: trigger account field when fetched from template (17dd1ab), closes #32409

provision to return non consumed components against the work order (d0f3818)

Tab Break in Material Request (79151be)

Tab Break in Purchase Invoice (89314d4)

Tab Break in Purchase Order (5a8329a)

Tab Break in Purchase Receipt (b092791)

Tab Break in Quotation (b0a9f79)

Tab Break in Sales Order, Delivery Note, Sales Invoice and Purchase Order (31cd96b)

Tab Break in Supplier Quotation (22ad3ad)

Source code(tar.gz)
Source code(zip)
v13.40.1(Oct 12, 2022)
What's Changed

fix: Incoming rate precision fixes for intra company transfer (backport #32272) by @mergify in https://github.com/frappe/erpnext/pull/32581

fix: consider sales rate as incoming rate for transit warehouse in purchase flow (backport #32563) by @mergify in https://github.com/frappe/erpnext/pull/32580

fix: Value error on validation of POS invoices with Serial Nos (backport #32557) by @mergify in https://github.com/frappe/erpnext/pull/32584

Full Changelog: https://github.com/frappe/erpnext/compare/v13.40.0...v13.40.1
Source code(tar.gz)
Source code(zip)
v13.40.0(Oct 12, 2022)
13.40.0 (2022-10-12)

Bug Fixes

Do not add tax withheld vouchers post tax withheding in one document (e1c41b9)

future attendance marking (cb4fbd5)

make readings status mandatory in Quality Inspection (257a2a3)

mark attendance issue with joining date (6f8d620)

mark attendance issue with relieving date (a9546dd)

PO cancel post advance payment cancel against PO (41599cf)

set Quality Inspection status based on readings status (d67b44f)

Tax withholding related fixes (32a9575)

test: test_rejected_qi_validation (2763d06)

TooManyWritesError during reposting of stock (476175b)

Features

cst ux improvement (552c595)

JE: trigger account field when fetched from template (baa4fec), closes #32409

Source code(tar.gz)
Source code(zip)
v14.2.3(Oct 7, 2022)
14.2.3 (2022-10-07)

Bug Fixes

Do not add tax withheld vouchers post tax withheding in one document (6060072)

Tax withholding related fixes (a226fcf)

Source code(tar.gz)
Source code(zip)
v13.39.5(Oct 7, 2022)
13.39.5 (2022-10-07)

Bug Fixes

Do not add tax withheld vouchers post tax withheding in one document (be404b7)

Tax withholding related fixes (6e9b52d)

Source code(tar.gz)
Source code(zip)
v14.2.2(Oct 4, 2022)
14.2.2 (2022-10-04)

Bug Fixes

(bulk transaction) key error and better error logging (backport #32445) (#32463) (7a80385)

add non-stock item filter for fg_item in PO (11f9279)

add validation for non-stock item in SCR (793fa18)

asset requiring maintenance sold status and added test [v14-hotfix] (c0a141b)

asset tests (6710337)

calculate depreciation properly on asset sale entry and scrap entry (f5f13c4)

Create accounting dimension fields in asset capitalization (9ec0d10)

Disbursement Account in patch to update old loans (0973989)

don't allow to update Maintain Stock if the item has a BOM (e5d1f59)

fetch swift_number in payment_request (f09222a)

fix restore asset value after depreciation (8605245)

fixes query builder order by issue in postgres (backport #32441) (#32465) (8851826)

Incorrect TCS amount deducted in Sales Invoice (4d51d73)

Item details fetching on making transaction from item dashboard (db60299)

not able to return sold expired batches (9c56a5f)

payment request make bank field Link instead of Read Only (c8c0f34)

pick list picked-qty for batch item (32107c4)

refactor asset capitilization (bad3b33)

searchfields as per customize form not working for Item (f167abb)

show Make Purchase Invoice button based on permission (fd86876)

supplied items added twice in Stock Entry (d91ac5e)

test_scrap_asset (fd232d1)

typo in sales_register's filter mode_of_payment (backport #32371) (#32446) (1918b5c)

update with new Frappe color. fix #32455 (#32456) (3e7582f)

Reverts

Revert "fix: fetch swift_number in payment_request" (d3c151f)

Source code(tar.gz)
Source code(zip)
v13.39.4(Oct 4, 2022)
13.39.4 (2022-10-04)

Bug Fixes

asset requiring maintenance sold status (14ab9d9)

conflict (0f8e34e)

Disbursement Account in patch to update old loans (b4a511c)

e-Way bill JSON for Intra-state internal transfers (b7fbf75)

fetch swift_number in payment_request (6074570)

Incorrect TCS amount deducted in Sales Invoice (32456bf)

Item details fetching on making transaction from item dashboard (1aed76f)

linter issue (4757a65)

not able to return sold expired batches (2fd4485)

payment reconciliation tool consider cost_center for JV (9f98891)

payment request make bank field Link instead of Read Only (299175e)

pick list picked-qty for batch item (96a6db0)

SEZ Without Payment of Tax don't add tax rows (a13eecc)

show Make Purchase Invoice button based on permission (7124328)

typo in sales_register's filter mode_of_payment (backport #32371) (#32447) (cdc8297)

update with new Frappe color. fix #32455 (#32456) (ad43b18)

Reverts

Revert "fix: fetch swift_number in payment_request" (8251b84)

Source code(tar.gz)
Source code(zip)
v13.39.3(Oct 2, 2022)
13.39.3 (2022-10-02)

Bug Fixes

asset requiring maintenance sold status (a668d4e)

Source code(tar.gz)
Source code(zip)