How to delete FI document generated from Goods Receipt and Service Entry Sheet

[Jacob_Do]

Dear Gurus,

We are facing a challenge during a phased SAP implementation and would appreciate your insights.

Context:

- SAP MM (Materials Management) was implemented and has been in use since 2020.

- During operations, the system has automatically generated FI documents when users performed Goods Receipt (GR) and Service Entry Sheet (SES).

- In 2025, we are now implementing SAP FICO. However, the accounting team does not accept the auto-generated FI postings that occurred before the FICO go-live.

- They require these postings to be completely removed from the system to ensure data consistency and integrity in the financial ledger.

Questions:

1. Is there any SAP-standard or technical way to delete these auto-generated FI documents (keep Material Doc)?

2. If deletion is not possible, are there any recommended alternative approaches to handle this situation?

Any guidance, technical insights, or real-world experience would be greatly appreciated. Thank you!

[duwhuy]

Hi Jacob Do

[sumesh_gupta · Accepted solution]

Hello @Jacob_Do  it is not possible to delete FI document posted in system only reversal allowed which not applicable in your case as document posted through material document for reversal material document also needs to be reversed.

it is also not suggested to delete data technically at table level in production it can result in system inconsistency.

one approach you can follow take balance of all gl which are posted via these material documents & post a JV to make balance of these GL zero manually.

Regards,

Sumesh Gupta 

[Jacob_Do · Accepted solution]

Thank you for your advice. However, using Journal Vouchers in this case would inflate the transaction volume on the Trial Balance during data migration (as we are migrating full transaction history from the customer's legacy system).

More importantly, G/L line items related to expense accounts have already been posted during the GR/SES steps.

[sumesh_gupta · Accepted solution]

Hi Jacob, consider below points as well.

1. When material documents posted, then in legacy system somewhere there finance impact should be there may be in B/S or P/L GL.

2. No need to post one by one JV just post one JV summarizing GL balance.

3. Example let say material consumption in SAP posted & debited GL X in sap in FI document & stock GL Y credit in SAP.

Now in legacy system corresponding GL should be there let say A for expense & B for stock credit.

When you post manual JV you can nullify X with Y in SAP Finally when you upload legacy data to SAP GL corresponding to A & B should have that balance considered.

Regards,

Sumesh Gupta

[Jacob_Do · Accepted solution]

Hi Sumesh,

The expense account X in SAP is actually the same as the expense account A in the legacy system.

Since this expense account has already been posted in SAP (due to auto-posting from GR/SES), migrating the full transaction data—including postings to this same expense account—from the legacy system will distort the Trial Balance.

The key concern from the accounting team is that all balances per G/L account must remain accurate and consistent. They require that no postings to G/L accounts (especially expense accounts) exist in SAP prior to the official FICO go-live.

It's a really challenge request.

[Jacob_Do · Accepted solution]

OBR1 helped in this case, since the FICO module has not officially live yet, then we delete all FI doc by using OBR1.