I need to calculate ending balances as of a certain fiscal period using the postinghist table.
I need to know the significance of a period showing in the field postinghistyearperiodtill with a value end in 00 or 999999.
I have already referenced KB article https://knowledgebase.qad.com/kmp/article/AA-79825.
postinghistyearperiodtill 999999 is for the latest
For example, the current month is 201912, if you add a posting in 201912,
then the postinghistyearperiodfrom will be 201912,
and postinghistyearperiodtill will be 999999.
postinghistyearperiodtill ends with 00 means the last
postinghist record of the past year.
For example, when the new year begins, you start to create postings
then the postinghist of 201912 will be updated,
the postinghistyearperiodtill will be changed to 202000.