Skip to Content
0

Finance Document of Customer Invoice cannot be cleared

Jan 30 at 02:54 AM

63

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Harika Gali
Feb 22 at 10:38 AM
0

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

Show 5 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

0

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.

0

Thanks for your advice and help, G Lakshmipathi..

0

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

0