web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to apply / tag inv...
Small and medium business | Business Central, N...
Answered

How to apply / tag invoices in Payment reconciliation Journal

(0) ShareShare
ReportReport
Posted on by Kavisha 310

Hi 

On the payment reconciliation journal, imported all the bank statement lines and map it against all the Customers, Vendors and G/L.

Now the entries mapped to the Customers, How can we apply it against the Invoices from the "Payment reconciliation journal" screen only?

Thankyou

Kavisha Ahuja

I have the same question (0)
  • Verified answer
    Maria Chambel Profile Picture
    Maria Chambel on at
    RE: How to apply / tag invoices in Payment reconciliation Journal

    Hello Kavisha, 

    I am not sure if I understood your question, but let me try to help you:

    Once you import the bank statement in Payment Reconciliation Journal, the system might map the transactions automatically based on Payment Rules.

    For the transactions not mapped automatically you can map it (apply it) manually by using the button "Apply Entries" and then select the document you want to apply (by selecting Applied field):

    pastedimage1632317706620v1.png

    pastedimage1632317765694v2.png

    In Document No. field you can check to what document is the transaction applied to.

    Once the journal is ready you can post it.

    Here are some links about this feature:

    Manage Bank Accounts - Business Central | Microsoft Docs

    Reconcile Bank Accounts and Apply Payments - Business Central | Microsoft Docs

    Hope it helps.

  • RustyAustralis Profile Picture
    RustyAustralis 202 on at
    RE: How to apply / tag invoices in Payment reconciliation Journal

    Pretty sure you are mixing up two things and I don't blame you. The auto mapping isn't about applying payments - it literally wants to create a completely new ledger entry. The auto-match is meant to recognise invoices and customers and try and suggesting applications.

    The MISSING functionality is for Business Central to remember a different name for a customer that comes through in the bank statement. If it did this and then auto-apply from oldest to newest it is probably what you want.

    This is an area which was advanced in its time but is now a little sparse in functionality compared with latest 2021.2 netsuite and products like Xero. I suspect there are add-on vendors who have solved this maybe.

  • Kavisha Profile Picture
    Kavisha 310 on at
    RE: How to apply / tag invoices in Payment reconciliation Journal

    Thanks Maria, I didn't had exact test data so was confused but your links and response has helped me. I understood it now that it helps to apply invoices to the payments.  I though the "application" on the Payment recon screen is only for the Bank ledger application which close the bank entries but does not apply customer ledger entries. But Now I have tries few scenarios and can figure the solution now. Thankyou.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,232

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,863

#3
Sumit Singh Profile Picture

Sumit Singh 2,819

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans