cancel
Showing results for 
Search instead for 
Did you mean: 

Document date and Posting date.

asafh2009
Member
0 Kudos

Dear community

is there a possibility to generate a report from transaction FBL3N with 2 different document types in order to check if document date of one document type is equal to the posting date of the second document type ? For example: The posting date of a document type "DP" should be equal to the document date of "BM".

Accepted Solutions (0)

Answers (3)

Answers (3)

mathurifico
Explorer
0 Kudos

It appears that you're referring to a specific transaction code, FBL3N, which is used for displaying G/L account balances. If you want to generate a report to check if the document date of one document type is equal to the posting date of another document type, you may need to customize a report or use a tool like SAP Query or SAP Report Painter.

Here's a general guide on how you might approach this task:

  1. Transaction FBL3N:

    • Execute transaction code FBL3N.
    • Enter the necessary parameters, such as company code, account number, and other relevant criteria.
  2. Filtering by Document Types:

    • Use the "Document Type" field in the selection screen to filter for the desired document types (e.g., "DP" and "BM"). You can enter multiple document types separated by commas.
  3. Layout Settings:

    • Adjust the layout settings to display the document date and posting date in the output list. You can use the "Settings" option in the menu bar to customize the layout.
  4. Export Data:

    • Export the data to a spreadsheet or a text file for further analysis.
  5. External Analysis:

    • Use external tools like Microsoft Excel or any other data analysis tool to compare the document date of one document type with the posting date of another document type.
  6. Formulas or Filters:

    • In the external tool, you can use formulas or filters to check if the document date of "DP" is equal to the posting date of "BM" for each line in the report.
  7. Custom Development:

    • If standard reports do not meet your requirements, you might need to consider custom development using tools like SAP ABAP to create a tailored report.

Remember that the exact steps may vary depending on your SAP version, customization settings, and user roles. If you're not familiar with SAP development or customization, it's recommended to involve your SAP technical team or consultants for assistance in creating a custom report that suits your specific needs.

sanilbhandari
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi

I do not know the business rationale for such a report. I do not believe this could be achieved in a standard way. However, easier approach would be to download the data in excel and quickly do the required analysis in excel.

Thanks & Regards

Sanil Bhandari

Neeraj_Jain
Active Contributor
0 Kudos

Hello asafh2009,

Yes, you need to discuss with your ABAP Consultant to develop customized report.

Regards,

Neeraj Jain