Logic to get closing bal of the prev's wrkng day as opening bal of curr day

[Former Member]

Hi All,

I have a requirement to create a report to get the closing balance of the previous working day as opening balance of the current day. I am fetching the contents from FEBKO table using date minus one logic in a do loop which may lead to performance issue if the user enters some wrong entry. Is their any alternative to get the closing balance of the previous working day as opening balance of today? Your answers are highly appreciated.

[Former Member]

solved

[Former Member]

This one's really not a WD Java problem - aside from being a java coding performance issue.

But your question's pertaining to looking for a formula that could possibly lead to a much optimized/efficient program, correct? For this, ask accounting or the functional expert on this.

If you're worried about the performance repercussions while doing the loop, utilize or create instead a backend query statement that could prove much more efficient.

Goodluck.

Regards,

Jan