Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Hello,

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.

Angela

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question