Skip to Content

Finance Document of Customer Invoice cannot be cleared

Dear Experts,

Would like to ask the following two Questions -

Q1) Below is a clearing doc. 8300000075 for a Customer 10037 generated by our user. For the Item 3, suspected it was manually added by our user when generating this clearing doc., e.g. in F-28

Below is to drill down this Item 3, found that the relevant A/C doc. 6400002814 in 2014 Item 1 was inputted in the field "Payment for" and the Inv. 0095002870 of the relevant A/C doc. 6400002814 was inputted in the field "Assignment" -

However, the relevant A/C doc. 6400002814 in 2014 cannot be cleared in which the A/C doc. can still be found in table BSID (as below) but cannot be found in table BSAD -

Could you advise why the above A/C doc. 6400002814 in 2014 still cannot be cleared even if the relevant clearing doc. 8300000075 was generated ?

Q2) Could you also advise whether my understanding on the following tables are correct ?

BSIS - check GL A/Cs with open items

BSAS - check GL A/Cs with cleared items

BSID - check Customer A/Cs with open items

BSAD - check Customer A/Cs with cleared items

BSIK - check Vendor A/Cs with open items

BSAK - check Vendor A/Cs with cleared items

Many Thanks,

KH Fong

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 22 at 10:38 AM

    Hello,

    You are right about index tables.

    BSI*- means open items for GL/Vendor/Customer

    BSA*- Cleared items for GL/Vendor/Customer

    And the issue regarding the above A/C doc. 6400002814 in 2014 still cannot be cleared even if the relevant clearing doc. 8300000075 was generated might having any mismatch with any field because it was created manually.

    Please run rfindex_nacc report for that document and account and you can find out the errors if any.

    Best Regards,

    Harika

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Harika Gali,

      Do you have any comment on the above checking result of your above advised report "rfindex_nacc" ?

      For your info., GL A/C 37301001 is a P&L Statement A/C with A/C Group "PL Income statement accounts". This A/C is not found in the above report may be due to these settings in FS00.

      GL A/C 30801001 is Credit Entry (while Debit Entry is the Customer 10037) for the above A/C doc. 6400002814 in 2014.

      Many Thanks,

      KH Fong