Skip to Content

Manual Reconciliation

Hello Experts,

In Banking -----> Bank Statements & External Reconciliation -----> Manual Reconciliation

after supplying the requisites, user finds it difficult to relate the payments.

User has to navigate to each transaction by clicking on the link arrow.

Through the REF# fields the information he gets is the

Document Number REF 1

Cheque Number REF 2

Payee Bank Name

Is there a way where the party's name will be displayed.

We tried to use REF 2 field. But the access to that field is through Journal entry window.

Is there a more easy way to achieve this ?

Are we on the right track of using these ref fields ?

Please guide .

Thanking You

Malhaar

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Aug 22, 2012 at 07:26 AM

    Hi,

    You can Update the Remarks field in the JDT1 with the Keyword(Payment or Receipt) as Prefix and it reflects in the Manual Reconciliation Remarks Column as shown in the below screen shots.

    You can try this...


    ManRec1.JPG (114.7 kB)
    ManRec2.JPG (175.4 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 21, 2012 at 10:53 AM

    HI Malhaar

    Try with the Journal(ojdt) memo field to enter party name and in the Manual Reconciliation use the remarks field to display the party.

    Regards

    Kennedy

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 22, 2012 at 09:48 AM

    Hi Kennedy & Jagankumar,

    What if after saving the document, in the journal entry window we edited ref1 and ref2 fields ?

    Because anything edited over there gets captured in manual reconciliation window.

    Thanking You

    Malhaar

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.