The error message to be prompted when create the journal and apply entry for the journal entry.
Cause of this problem and resolution
1 - Document Type - Check the document type. System have checking base on the document type. Try to remove the document type then preview post to see whether the error resolved or not.
2 - External Document No. - If this is not the Document Type issue, check the existing customer ledger entries. If there have same combination on Document No + External Document No. then system will always apply the first entry of the same key no matter user choose which entry to apply.
In general, this case will happen for "Deposit" case.
Case Example as below, the different entry have same Doc No + Ext Document, if user want to apply 002 and select this entry in Apply To Doc. in journal line, system will always apply 001 and the said error to be prompted.
Customer | Customer Ledger Entry | Document No | External Document No | Amount |
---|---|---|---|---|
CUA1 | 001 | CJ001 | INV123 | 100 |
CUA1 | 002 | CJ001 | INV123 | -100 |
To resolve the problem, user can create General Journal to make the unique key then apply again.
Customer | Apply To Doc. No | External Doc. No | Amount |
---|---|---|---|
CUA1 | 001 | 100 | |
CUA1 | INV123-1 | -100 |