Double Ledger Parties (Customer / Supplier as same party)

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!

Mohammad_Ahmad_Zulfi · November 1, 2021, 9:52pm

Very welcome

AbdalAliy · December 6, 2021, 7:58am

https://github.com/frappe/erpnext/pull/28481
v13.16.0