Skip to Content

GL account clearing using transaction f-03 for field EBELN ( purchasing document )

Hello Expert,

I have added the field EBELN in the selection criteria of F-03 but the field is empty : is not picking up purchasing document information from document .

Is there any way in which I can manually clear open items using purchasing document field . ( i already used automatic clearing )

Thanks and regards,

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Nov 28, 2018 at 07:40 PM

    Please check the sort key assigned against the GL account. If you would like to clear based on purchasing doc., have that set as the sort key >> this ensures that purchasing doc is popualated in the Assignment field. Then have the clearing rules set as Assignment field (ZUONR) and then clearing should happen.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 30, 2018 at 06:32 PM

    Hi,

    What are the GL accounts you'd like to clear? Are you sure that they have PO-details filled on line item level for this particular GL account?

    What I'd like to say with that is that your document might have a reference to PO in one of the lines, but it doesn't mean that this reference will be filled in all line items. For example consider typical posting for vendor invoice: Cr. Vendor Dr. Gr/Ir account. PO number will be stored in GR/IR account, but not in vendor account. So if you try to clear vendor open items using EBELN as search criteria, it will not work.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 11, 2018 at 05:54 AM

    Hi There,

    If you are directly posting an entry from FI and even you include Purchasing Document(EBELN), but that entry will not be updated in Purchasing Document in Purchase Document History(EKBE) table, the reason is in EBELN we might have multiple GL relevant to BSX, but when system post the invoice(MIRO) then we have postings Vendor AC Credit and GR/IR Debit and when we post Payment then We Post Vendor AC Debit and Bank GL Credit.

    So if you want to clear GR/IR A/C you should use MR11 and to clear open POs you should use the PTP flow!

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded