Difference in GR/IR clearing account balances of fs10n and customised report(grn done but not invoiced).

[Former Member]

In this scenario, my client is facing an issue wherein when he take a report for the month of February 2016 he gets a variation between the G/Laccount GR/IR clearing account balance of standard report fs10n and the customized report for GRN made but not invoiced. But the balances in fs10n and fbl03 are matching perfectly for the same G/L. The customized report showing the pending items to be invoiced are perfect. But unable to sort out the issue of mismatch in the balances. In addition to that there is a lot of open item yet to cleared in the GR/IR clearing account for which automatic clearing through f.13 had done. but it is not getting cleared. Kindly help me for this problem.

[former_member198650]

Hi Jacob,

1. First identify which documents are not getting display in custom report by comparing with FBL3N report. Then you will get solution.

2. For automatic clearing not happened, check the clearing criteria maintained for the account in OB74.

Regards,

Mukthar

[Former Member]

Get in to the details of FS10N and your custom report and find one line atleast that is present in one and not in another. Check for the characteristics of that line item and You will come to know why that difference is coming.

Actually you may compare the logic of Custom report with standard and that will resolve your issue.

Ex: Some of the document types are excluded or some user postings excluded or particular date based on which the report pulls the data and some thing like that.. are excluded like that

Regards,

Siva Cheruvu

[former_member200703]

Hi

you may give an example of your issue.. also check report MB5S to check the opening GR that not yet invoiced and compare it with the customized report.. what is the date that you run F.13 to clear GR-IR ?future date ..

Regards

Mahmoud EL Nady