BEx query - pulling data back at a point in time - FS-CD
I work for an insurance company that uses the FS-CD module (cash receipts and disbursements). FS-CD has a clearing process - for example, a premium receivable will be set up for a customer, and when we receive the payment, the receivable and payment will clear against each other.
There are times and other scenarios however where items will sit in suspense accounts. I would like to build a BEx query that will allow users to see what items were sitting in suspense accounts at any point in time - currently, back at a random day, back at a quarter-end, etc - any date they select. I believe this would be a combination of two scenarios:
- Items that were posted before the user selected date, that are still open (has not cleared against another record yet).
- Items that were posted before the user selected date, that cleared after that date.
Does something like this sound possible? We have been using T-code FPo4 for this purpose, but with how much data resides in our FS-CD tables, that T-code is a big drag on our system.
Thank you for your help.