cancel
Showing results for 
Search instead for 
Did you mean: 

Finance Document of Customer Invoice cannot be cleared

former_member287204
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member264579
Active Participant
0 Kudos

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

former_member287204
Participant
0 Kudos

Dear Harika Gali,

Thanks for your advice. For the above case, which field(s) / checkbox(s) should be selected / inputted when executing your above advised report "rfindex_nacc" ?

Many Thanks,

KH Fong

former_member287204
Participant
0 Kudos

Dear Harika Gali,

When executing your above advised report "rfindex_nacc" and inputting the selection criteria as below -

Found the following result -

For the above screens of result, found that "Errors" & "Errors found" are 0 and the inputted GL A/Cs & Customer A/C are "No_Difference".

Could you advise ?

Many Thanks,

KH Fong

Lakshmipathi
Active Contributor
0 Kudos

Whenever you add any post to your original query, please do so under "Comment" and not under "Answer", as you were not answering to a query but only providing additional informations as required by the member. Meanwhile, I have converted your above two posts from Answer to Comment.

former_member287204
Participant
0 Kudos

Thanks for your advice and help, G Lakshmipathi..

former_member287204
Participant
0 Kudos

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