sshepard03
Member
I am (still) on One World 7334. I added 2021 to the DATE PATTERN calendar. But via SQL query, it recognizes 01/01/21 as 01/01/1921. So when I run Trial Balance report for FY 21 and period 1, no data is displayed.
Oddly, many transactions and documents require the user to use date format MM/DD/YYYY when entering information.
So I updated the DATE PATTERN calendar to use MM/DD/YYYY, like 01/01/2021, then try to run Trial Balance for 21, 1, and still no data.
There is Data in FY 21 with UPMJs of 2021 in the GL (F0911) and the Account Balances (F0902). But apparently the Trial Balance thinks, when I enter FY 21 in Processing Options, it thinks I am asking for 1921 data.
Any thoughts ?
Oddly, many transactions and documents require the user to use date format MM/DD/YYYY when entering information.
So I updated the DATE PATTERN calendar to use MM/DD/YYYY, like 01/01/2021, then try to run Trial Balance for 21, 1, and still no data.
There is Data in FY 21 with UPMJs of 2021 in the GL (F0911) and the Account Balances (F0902). But apparently the Trial Balance thinks, when I enter FY 21 in Processing Options, it thinks I am asking for 1921 data.
Any thoughts ?