Company Name = ABCD
Credit Limit set on Customer Master = 10000
Credit Limit Set on Company Master = 0
Sold and item at 10000 with 5% tax
Received a PDC cheque with an amount of 10000. Posting date set on Current Date + 7 and reference date is current date. When I check the Customer Credit Balance showing 10000.
Since it is a PDC cheque and not yet cleared we need to stop any further sales with them. So how we can achieve this?
Pawan
January 31, 2018, 8:53am
2
Maybe you can create a Payment Entry and submit it only when the cheque is cleared.
Thank @Pawan , But in that case if the customer ask us the Statement it will not reflect their Cheque received information right?
Pawan
January 31, 2018, 1:59pm
4
Yes. Also, avoid tagging personally as replies on the forum are voluntary.
1 Like
Notedā¦
opened 11:33AM - 15 Nov 16 UTC
closed 03:36PM - 17 Nov 21 UTC
paid development
accounts
[](ht⦠tps://www.bountysource.com/issues/39242671-pdc-management-suggestion-full-feature?utm_source=39242671&utm_medium=shield&utm_campaign=ISSUE_BADGE)
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:


If any one is interested to develop this feature maybe I can contribute the money. Please post the cost.
Solufy
February 19, 2018, 4:28pm
6
Hope this pull request will work for the feature required : https://github.com/frappe/erpnext/pull/12961
Its exactly the same with bank statement management.