Haynal_Joy
Member
Hi
Most of you may have noticed that it is very rare to have opening balances on jd edwards reports. You only have an opening in the GL by object account report and the report is using a business function for that but the problem is that you cannot specify a date range you can only enter periods.
Therefore I have modified the R09423 report to have an opening balance. I just want to have a confirmation whether the method that I have explained below for the calculation is correct. That is
Suppose fiscal year runs from Jan-Dec 08
(1)If user enters a date 01/01/2008-31/01/2008-the opening balance for January will be the PYC value in the table F0902 of course depending on the ledger type AA/CA
(2)If user enters a date 15/01/2008-31/01/2008-the opening balance for 15 January will be the PYC value in table F0902 + sum of transactions(GLAA) values from table F0911 from 1st-14th of January.
Thanks in advance
Most of you may have noticed that it is very rare to have opening balances on jd edwards reports. You only have an opening in the GL by object account report and the report is using a business function for that but the problem is that you cannot specify a date range you can only enter periods.
Therefore I have modified the R09423 report to have an opening balance. I just want to have a confirmation whether the method that I have explained below for the calculation is correct. That is
Suppose fiscal year runs from Jan-Dec 08
(1)If user enters a date 01/01/2008-31/01/2008-the opening balance for January will be the PYC value in the table F0902 of course depending on the ledger type AA/CA
(2)If user enters a date 15/01/2008-31/01/2008-the opening balance for 15 January will be the PYC value in table F0902 + sum of transactions(GLAA) values from table F0911 from 1st-14th of January.
Thanks in advance
