Pages

Friday 24 May 2013

Error: There is no Cust. Ledger Entry within the filter. Filters: Document No.: PSIXXXXX, Customer No.: CXXXXX, Document Type: Invoice, Open: Yes


Issue: Unable to post Sales Return Order due to following error message
“There is no Cust. Ledger Entry within the filter. Filters: Document No.: PSIXXXXX, Customer No.: CXXXXX, Document Type: Invoice, Open: Yes”











 
Reason: Referenced Customer Ledger Entry is closed by a Payment Entry.

Solutions:

Option 1
Step1: Unapply the referenced customer ledger entry from the payment entry, using Customer Ledger Entries window -> Select the Entry -> Actions -> Functions -> Unapply Entries…
Step2: Post a refund using Cash Receipt Journal -> Create a refund entry for the customer, then Actions -> Functions -> Use Apply Entries -> to select entry to be refunded. Finally, Actions -> Posting -> Post.
Step3: Now you should be able to post the Sales Return Order

In this option, payment amount have to be refunded to the customer.

Option 2
Step1: Remove the link between Sales Return Order and Posted Sales Invoice under Sales Return Order -> Invoicing Tab -> Clear the value in Applies-to Doc. No.: field.
Step2: Receive and Credit the Sales Return order.

In this option, the system would leave a credit balance on the customer account.