Skip to Content
author's profile photo Former Member
Former Member

Update to the table FAGLFLEXA is wrong!

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2009 at 11:51 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2009 at 04:32 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2009 at 06:39 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.