on 01-30-2018 2:54 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Thanks for your advice and help, G Lakshmipathi..
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
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.