topic Re: Remove G/L Entry in Application Development and Automation Discussions

Remove G/L Entry

Former Member — Mon, 17 Apr 2006 12:24:51 GMT

Hi,

Do you know the best way to remove a G/L entry?

Using FBL3 you see accounting document entries from 2002 that need removed from a given G/L account. Surprising the auditors, as well as, the end-user requested this!

Possibly a function/bapi, but not sure.

Best regards

Jim

Re: Remove G/L Entry

Former Member — Mon, 17 Apr 2006 12:27:23 GMT

BAPI_ACC_GL_POSTING_REV_POST Accounting: Post General G/L Posting Reversal

See if this bapi is of any use to you.

Regards,

Ravi

Re: Remove G/L Entry

Former Member — Mon, 17 Apr 2006 12:35:05 GMT

Hi Jim

I believe it depends on what does REMOVE mean for you.

You can't delete a FI document from SAP, but you can reverse it: the document'll be in SAP, but the total amount for that G/L'll be zero.

So if you need to do that you can trx F.80 for mass reversal.

But if you need to delete the documents from database, you need to archive those documents, in this case see the trx SARA.

Max

Re: Remove G/L Entry

Former Member — Mon, 17 Apr 2006 15:55:43 GMT

Would you have a snipit of code or table info on how to properly format the functions obj_type, obj_key, and obj_sys.

Best regards

Re: Remove G/L Entry

Former Member — Mon, 17 Apr 2006 16:53:46 GMT

Those informations depends on which operation has created a certain document, you can see it in the header data, they usually indicate which document has created FI document.

So if you have to reverse the document 1/2006 of company Z000:

SELECT SINGLE * FROM BKPF WHERE BUKRS = 'Z000'

AND BELNR = '0000000001'

AND GJAHR = '2006'.

BAPIACREV-OBJ_TYPE = BKPF-AWTYP

BAPIACREV-OBJ_KEY = BKPF-AWKEY

BAPIACREV-OBJ_SYS = BKPF-AWSYS

........

Max