Erpnext: PDC Management Suggestion - Full Feature [Bounty]

[ai-erp]

Dear ALL,

with reference to https://github.com/frappe/erpnext/issues/6859 , I think full feature required for managing PDCs are as follows:

 FIELD TO BE ADDED IN JOURNAL/PAYMENT ENTRY
• RECEIPT/VOUCHER DATE
• DATE DEPOSITED (FOR PDCs RECEIVED)

 In BANK RECONCILIATION, when bank account is not selected and the user clicked on “Get Payment Entries”, the Outstanding Cheques and Deposit in Transits for ALL Bank Accounts should be displayed based on the period covered selected.

From there, user can update to which bank the cheque has been deposited (column for Deposited to - Bank Account Option). It should also automatically update entry to reclass the previously selected bank account during the initial entry when the cheque has been received. This is important to note since the company with different bank accounts have the discretion to which bank they want to deposit the cheque when it is due for deposit. This is also useful for companies receiving too many cheques in a day or a week in monitoring which cheques are still on hand awaiting for deposit. Update button should be added.

In cases of Returned/Redeposited Cheques, there should also be a column in the Bank Reconciliation with label “Returned/Redeposited”. In the same way in entering when cheque was deposited, it should also automatically update reversal of initial entry on the journal (debiting back the receivable and crediting cash in bank for returned cheques / debiting back the cash in bank and crediting receivable for cheques redeposited)

 FROM JOURNAL/PAYMENT ENTRY, A REPORT SAME AS THE BANK RECONCILIATION
STATEMENT SHOULD BE GENERATED WITH THE FOLLOWING COLUMNS:
• RECEIPT/VOUCHER DATE
• POSTING DATE (SAME AS THE CHEQUE DATE)
• PAYMENT ENTRY (Receipt/Voucher created ex. PDCR-00001, PDCI-00001, etc.)
• AGAINST ACCOUNT (CUSTOMER/SUPPLIER, ETC.)
• DEBIT AMOUNT
• CREDIT AMOUNT
• TOTAL FOR BOTH DEBIT AND CREDIT SIDE
• CHEQUE/REFERENCE NO.
• CHEQUE/REFERENCE DATE
• DATE DEPOSITED / RETURNED
• DEPOSITED TO (BANK ACCOUNT OPTION)

NOTE: IN THIS REPORT, THERE SHOULD BE AN OPTION TO SELECT PERIOD COVERED FOR THE PERIOD WE WANT TO GENERATE

 In connection to the above details, In CUSTOMER/SUPPLIER dashboard, below should be added aside from annual billing and total UNPAID (refers to invoices/returns only) Portion.

PDCs RECEIVED BUT NOT YET CLEARED – this is to show how much PDCs were exactly received from the customer including uncleared cheques and paid to supplier including cheques date which have passed but not yet cleared in the bank.

TOTAL OUTSTANDING - this portion does not only reflect invoices/returns made by customer/supplier but should also include journal entries made to book receivables/payables. This amount should not deduct uncleared cheques received/issued.

NOTE: For most companies, not all users have the access to view GL to check how much PDC has been received/paid by customer or paid to supplier dashboard, in this case,
we suggest to have this feature in viewing customer/supplier in ERPNext. Below
is a sample for your reference:

[me2ne]

important feature , because of this weakness we are still using tally erp to manage our cheque and other thing we manage with erpnext .

[Devens]

+1

[ai-erp]

I have paid $100 for this post in Bounty Source. @me2ne @Devens hope you are going to contribute as well to add this feature in erpnext... Thanks...

[ahmedfme]

Yes , this feature is very important in Middle East.
I hope it will be available soon

[ahmedfme]

+1

[me2ne]

+1

[zbisho]

Any update on this feature please, much appreciated

[riyasrawther]

Yes very important for us too..

[bghayad]

@ai-erp
Have you tried this: https://github.com/hfaridgit/Cheque-Management?
Regards
Bilal

[riyasrawther]

@ai-erp I tried that, but no use

[riyasrawther]

Approximately how much money need to done this work.

[me2ne]

i think money not important , it's important that ERPNEXT team understand how much this option to control and manage PDC is important in some countries .

[me2ne]

Hi @bghayad
is it stable and good future for PDC management ?
why they didn't add it in erpnext ?
Regards

[hda]

Dear community,
Hope this pull request will work for the features required : https://github.com/frappe/erpnext/pull/12961
Its exactly the same with bank statement management as suggested in requirement specification above. Any feedback will be appreciated.

[bghayad]

Hello @hda
Thanks a lot for you.
How can we know that this cheque has been returned? There should be a status in the payment that declare this is returned cheque.
The returned cheques are required to be known to be able to follow up it again.
One more point which is also important: at the customer dashboard, it is required to know the PDC amount and the Returned PDC amount, because by knowing the Unpaid, the PDC amount and the Returned PDC amount, then it is possible to follow up the payments with the customer and it will be very good to control its payments and its credit.
Regards
Bilal

[zbisho]

Hi,

We tried to use this module, however we faced the issue that the code uses the default accounts payable defined in the company, and ignores the one we entered in the Payment Entry, It also ignores the bank account we entered in the payment entry, where it would be logical to use it to add to the cheque it creates instead of us going to manually update that in the check module itself.

These two issues are preventing us from rolling this module to production, I wish they could be handled

Cheers

[bghayad]

Hello @zbisho
I might need to install it and try it and come back for you.
But I have a question: it was contains the ability to determine if this cheque is cleared or returned (status of cheque)?
Regards
Bilal

[me2ne]

how we can install it ?is it module or only need to update erpnext ?

[bghayad]

It is module that needs to be installed.

[zbisho]

yes, it does

[mghoneem10]

any updates ??