Skip to Content
avatar image
Former Member

BEx query - splitting out positive/negative records when there's no indicator attached - FS-CD


I work for an insurance company that utilizes the FS-CD module (insurance-related receipts and disbursements).  I need to write a BEx query at the General Ledger account amount level, that breaks out open items within FS-CD by the positive and negative records - see the example below.  This would be easy on a General Ledger BW cube, since we have the debit/credit indicators on that cube.  I have not been able to find something like that in FS-CD though, and I'm struggling creating a formula or condition in my BEx query that can pull out the positive/negative records like this, without doing a dump of all the records first and manipulating with a workbook.  Does anyone have any ideas?  I would have thought it would be easy to summarize by just the records that are positive amounts, and negative amounts.

GL Account         Net                    Debits                    Credits         

1205011               $187,618          $$1,996,031          $(1,808,413)

2216011               (11,183)               498,953               (510,137)    

2216013               585,777               824,302               (238,525)

2216017               (19,833)               13,189                    (33,022)

Thank you for your help.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 22, 2015 at 01:59 AM

    Hi Angela,

    as positive values doesn't need any sign, for negative sign you can simply create a formula for credits (your key figure which you want values to be shows an negative) like below

    Formula --> - (credits)

    Net = debit - formula --> negative values will be shown with sign here as well.

    hope this is what you are looking for?

    Add comment
    10|10000 characters needed characters exceeded