Small and medium business | Business Central, N...

Cash Receipt Journals Error

(0) Share

Report

Posted on by Business Central su...

Hello,

Thank you all.

There is a problem sudden appears in the Cash Receipt Journals.

When we go "Cash Management" -> "Cash Receipt Journals", we click "EUR REC'D" or "HKD REC'D", it shows the below error message "The filter "'HKD REC'D'" is not valid for the Name field on the Gen. Journal Batch table. An error occured while interpreting the filter: Did not expect value 'D''. For more information, see go.microsoft.com/.../

Attached is the screenshot of the flow.

Can you please help to resolve the probelm?

Thank you

Mia

screenshot_2D00_businesscentral.dynamics.com_2D00_2022.06.28_2D00_16_5F00_40_5F00_15.png

screenshot_2D00_businesscentral.dynamics.com_2D00_2022.06.28_2D00_16_5F00_22_5F00_42.png

All responses (2)

Answers (0)

Suggested answer

Dallefeld 11,425 User Group Leader on at

Like (0)

Report

RE: Cash Receipt Journals Error

Take out the apostrophe in the batch name. You should always refrain from using special characters in batch names, customer/vendor/item/bank/fixed asset numbers.
Suggested answer

Vaishnavi J 3,056 on at

Like (0)

Report

RE: Cash Receipt Journals Error

Hi,

if you open the Cash Receipt Journal from dashboard you might see this error.

But if you globally search Cash Receipt Journal and then switch batches it does not shows the error.

The reason why you are getting this error is there is logic written that apply filters on batches since it has apostrophe it is assuming a filter sign which is incorrect and due to which error is thrown.

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much