My vendor ageing report (FI),
The program is picking line item from table BSIK & BSAK(cleared items which are subsequently cleared and prior to report date (posting date)) and further segregating them seperately debits & credits and then showing them under bucket size defined.
I'm giving I/P as GL account (recon), posting date and company code, so when i'm processing program in night time (background - cos its taking too much time to run), output is matching with the FS10N, but same report when i processed in day time, its O/P is not matching with the FS10N.
Can anybody tell me, what could be the problem, as per my thinking some vendors balances may not been cleared or users might have worked on / locked those particular vendor, that's why report couldn't able to catch them, or may be there's some other reason.
I'm attaching my code too, please check and let me know, if you find any ambiguity.
Is your report run after the invoices are generated? During the day usually the invoices are not created. They are created in a nightly job.
Thank you for posting your code and the clear problem. It makes an answer easier. If this doesn't seem to answer the issue. I can say during the day is when our G/L is changed if needed.
Michelle
Hey hi,, thanks for the reply.
Currently i'm processing this report for 30/09/2017, means for older date,but still i'm facing this issue.
That's why i shared my code, just to confirm whether my code / logic is correct or not.
Wow - well then activity shouldn't be a problem. I'll look again and see if I can find anything.
I think you are comparing the wrong data. I believe your program is working correctly However, I would suggest running transaction S_ALR_87012084 instead of FS10N.