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

All responses (4)

Answers (2)

Jun Wang 7,437 Super User 2024 Season 2 on at

Like (0)

Report

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

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

NAV_with_Narang 2,234 Super User 2024 Season 1 on at

Like (2)

Report

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

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
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (1)

Report

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

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.
Verified answer

Tech-Lucky 796 on at

Like (0)

Report

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

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