Date filter(Balance at Date) on 'Chart of Account' glitch

(1) Share

Report

Posted on by Rakesh Dobariya

Hello Folks,

Recently i have observed that on page "Chart of Account" while i choose filter "Balance at Date" and entered '010423..020523' as per below,

Just by next when i hit enter, system will filtered the data, but something noticed suspecious (that date filter turn in to numerical format ) as per below,

Hence on Item Ledger , Customer Ledger 'Posting Date' is working as per expected.

Thanks,

Rakesh Dobariya

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Tech-Lucky 1,267 Super User 2025 Season 2 on at

Like (0)

Report

This is not a Date Type Field applying the filter on the wrong Field as it is of Data Type Decimal.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (1)

Report

Hi Rakesh Dobariya ,

I found nothing wrong in this case, as this is a Decimal field not Date filed, so Not sure why you are putting Date filter into that, please try to put Decimal values only, thats why it working abnormally for you.

Thanks.

Was this reply helpful? Yes No
Verified answer

NAV_with_Narang 2,294 Moderator on at

Like (2)

Report

Hi Rakesh - "Balance at Date" is a decimal field, you can't enter date range in a decimal field

Please click on "Filter Totals By" instead of "Filter List By" and use the Date filter to put your date range

Was this reply helpful? Yes No
Jun Wang 8,202 Super User 2025 Season 2 on at

Like (0)

Report

seems your question got answered nicely, but it happens when user is misled by the naming as MS is very good at

Was this reply helpful? Yes No