Update to the table FAGLFLEXA is wrong!

[Former Member]

Dear All,

I used an ABAP program to reverse the financial documents, and found the table FAGLFLEXA was updated wrong after completed the running of the program. Below is the detailed information:

Function of the program: Call BAPI: BAPI_ACC_DOCUMENT_REV_POST to reverse the FI documents

Before run the program: there's a posting between company A and company B, and genarated 2 FI documents(Example: 10000001 for company A, and 20000001 for company B), and the cross-company code document was 20000001000109.

Running the program: run the program to reverse FI document 10000001, and reverse successfully(both for company A and B).

After reversed the FI documents, I found everything is OK except 1 error: When I check the table FAGLFLEXA, I found the new value of field DRCRK is incorrect, the data is like:

part 1:

-

---

RLDNR DOCLN RACCT HSL DRCRK

0L 000001 6600960100 896.88- S

0L 000002 6600960100 108.29 S

0L 000003 6600960100 67.27- S

0L 000004 6600960100 2.60 S

0L 000005 6600960100 4.71 S

0L 000006 6600960100 35.85- S

0L 000007 9999020000 884.40 H

-

---

part 2:

-

---

RLDNR DOCLN RACCT HSL DRCRK

0L 000001 6600960100 896.88 S

0L 000002 6600960100 108.29- H

0L 000003 6600960100 67.27 S

0L 000004 6600960100 2.60- H

0L 000005 6600960100 4.71- H

0L 000006 6600960100 35.85 S

0L 000007 9999020000 884.40- H

-

---

in part 2, we can found the value of field DRCRK in some line was change from S to H, actually, it should as same as in part 1.

Can anybody who can tell me why?

With many thanks!

Brian Liu

[Former Member]

Somebody wrote a 'Commit Work.' insides a BTE process,this caused the error when update the G'L table FAGLFLEXA.

After removed the 'Commit work', the problem solved.

[Former Member]

In the document in part 1, you have a negative posting 896.88- with a debit indicator S. Could you check if this document is an original posting or a reversal document for another document?

A. With negative postings permitted checkbox unchecked in company code global parameters (T Code OBY6) and on the document types (in OBA7), the following is possible (I'm showing the records in FAGLFLEXA (with 'Check conversion exits' unchecked in User parameters).

Original entry

Ledger Line Item Account Number LC Amount Debit/Credit

0L 000001 0001081045 999.00 S

0L 000002 0006105050 999.00- H

Reversal of the above

Ledger Line Item Account Number LC Amount Debit/Credit

0L 000001 0001081045 999.00- H

0L 000002 0006105050 999.00 S

B. With negative postings permitted checkbox checked on the company code global parameters and on the document types.

Original entry

Ledger Line Item Account Number LC Amount Debit/Credit

0L 000001 0001081045 999.00 S

0L 000002 0006105050 999.00- H

Reversal of the above

Ledger Line Item Account Number LC Amount Debit/Credit

0L 000001 0001081045 999.00- S

0L 000002 0006105050 999.00 H

Notice the change in the DRCRK field value in the reversal documents above. With negative postings permitted, system posts a negative value with a Dr. indicator, so when you pull FAGLB03 report for the account, system shows a zero for that account (which indeed has two line items under it); FAGLFLEXT will have nothing in it. Without the negative postings permitted, the FAGLB03 shows a 999 and a -999 (in Dr. and Cr. postings respectively) and FAGLFLEXT has two entries.

[Former Member]

help ..........................

[former_member695461]

Hi Brain Liu

Basically the problem is with incorrect debit/credit indicator. This problem occurs some times when a reversal document gets an incorrect debit credit indicator.

I had also faced th s problem and can be fixed with help of SAP notes. after implementing sap notes if the problem stille xist please raise an oss message.

caution:-

becasue of incorrect debit/credit shidt as a result of document reversal ask your functional consultant to reconcile account baalnces.

Hope this helps.

Sanjeev

[Former Member]

Hi Sanjeev,

Would you please tell me which sap note should i refer to? thanks!