Skip to Content
avatar image
Former Member

BEx query - pulling data back at a point in time - FS-CD

Hello,

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.

Angela

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 21, 2015 at 08:34 PM

    I've created two queries for this purpose that I am going to try to combine into a workbook.  If anyone has a better solution though, please let me know.  Thanks!

    Angela

    Add comment
    10|10000 characters needed characters exceeded