Double Ledger Parties (Customer / Supplier as same party)

Mohammad_Ahmad_Zulfi · July 29, 2019, 2:15pm

Hi, I have made a custom app please have a look and comment

Double Ledger Management

App to accommodate parties that act as both customers and suppliers in ERPNEXT

Many times we see that a we buy from the same customer we sell our products to and vice versa. In that case it becomes tedious to operate two different ledgers and put adjustment entries manually. Adding manual entries leads to human error. This app will will take care of such accounts.

rmehta · July 30, 2019, 4:04am

This is a good solution , thanks for sharing!

Mohammad_Ahmad_Zulfi · July 30, 2019, 3:01pm

Thank you for your appreciation. I am your student and fan as well.

ofca · February 18, 2020, 2:08pm

Thanks for working on this. Any vision on merging this to the core?

szufisher · May 14, 2020, 12:38pm

smart solution!

pythonpen · July 24, 2020, 2:10pm

After installing this app - does it even out credit and debit for previous transactions? Or only for future transactions?

Mohammad_Ahmad_Zulfi · July 24, 2020, 3:02pm

Only for the future transactions

yanix84 · August 5, 2020, 10:06am

Hello @Mohammad_Ahmad_Zulfi, @rmehta
please how do i install it on my ERPNEXT V12? i am new to erpnext but if properly guided i can be able to do it.
Regards.

ponyooooo · September 29, 2020, 7:11am

Hi @Mohammad_Ahmad_Zulfi is it possible to use the open sales invoice as a payment for the open purchase invoice on the payment entry? so that both invoices will be paid?

Mohammad_Ahmad_Zulfi · September 29, 2020, 3:03pm

It is not possible through payment entry

max_morais_dmm · September 29, 2020, 3:13pm

@ponyooooo, what @Mohammad_Ahmad_Zulfi says is right, it’s not possible using “Payment Entry”, but you should make a Journal Entry for that case

ponyooooo · September 30, 2020, 8:21am

Thank you for the response. But how should I create a journal entry? What entries should be made? Will it not remove the status paid of 1 invoice?

ETCOMed_Eg · August 22, 2021, 3:50pm

Thank you so much @Mohammad_Ahmad_Zulfi.
It works with me and creates adjusting entries successfully. But I have one big problem with cancelling invoices.
When I try to cancel a purchase invoice, I get a message to device to cancel the adjusting entry as below:

But when I click to cancel, nothing happen, and I get a message that the Journal entry is linked.

I can’t also cancel the entry as it is linked with the invoice.
What part of the code can I check to solve this issue?

Mohammad_Ahmad_Zulfi · August 22, 2021, 4:42pm

Please look the code here.

github.com

ahmadpak/doubleledger/blob/master/doubleledger/double_ledger_management/doctype/double_ledger_parties/double_ledger_parties.py

# -*- coding: utf-8 -*-
# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and contributors
# For license information, please see license.txt

from __future__ import unicode_literals
import frappe
from frappe.model.document import Document
from erpnext.accounts.party import get_party_account

class DoubleLedgerParties(Document):
    pass

def create_invoice_adj_jv(self,cdt):
    if self.doctype == 'Sales Invoice' and self.is_pos == 0 and self.no_double_ledger==0:
        doc = frappe.get_doc(self,cdt)
        customer_list = frappe.get_list('Double Ledger Parties', filters= {'primary_role':'Supplier','customer':self.customer}, fields = "*" )
        customer_dp = None
        supplier_dp = None
        primary_role_dp = None

This file has been truncated. show original

A PR has been generated to merge this feature to ERPNext
https://github.com/frappe/erpnext/pull/27039

Kindly review
Regards

ETCOMed_Eg · August 24, 2021, 11:16am

Yes, this is the part of code that I checked, but couldn’t find the reason why my system doesn’t cancel the invoice and the Adjusting Journal entry as explained in my previous comment here

I guess it is a bug in the code.

Or do I miss something in the installation? Or there must be some other modifications in the ERPNext and Frappe Apps?

ETCOMed_Eg · August 31, 2021, 11:20am

Dear @ Mohammad_Ahmad_Zulfi
I wish if you can comment on that issue as it stops me from utilizing the “Double Ledger Parties” with ERPNext

Mohammad_Ahmad_Zulfi · September 16, 2021, 5:51am

This functionality has been released as a feature. You can find it in the latest v13.

ETCOMed_Eg · September 20, 2021, 10:20pm

Thank you so much Sir, testing and works well. great job.

Mohammad_Ahmad_Zulfi · September 21, 2021, 3:40am

My pleasure

wale · November 1, 2021, 6:53pm

Thanks a lot @Mohammad_Ahmad_Zulfi, this is very much appreciated!