Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

hello, how can I find a history of the payment journals posted so far?

(0) ShareShare
ReportReport
Posted on by 50

Hello,

How can I find the history of all payment journals posted in BC?

Thanks

  • Suggested answer
    MartinNL Profile Picture
    MartinNL 480 on at
    RE: hello, how can I find a history of the payment journals posted so far?

    Hello,

    Each line that you see in the G/L registers is a Journal that was posted, by selecting one of the lines (journals) and clicking the relevant Ledger (via Process in the ribbon) you will see exactly what was posted from that journal. From there you can navigate to other related entries or start filtering according to your requirements. 

    Regards,

    Martin

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: hello, how can I find a history of the payment journals posted so far?

    the line nos. from the payment journal are not saved to the ledger entries, but you can match the original journal lines and ledger entries with the posting date, document no., vendor no. and invoice no. in the description.

  • busybee Profile Picture
    busybee 50 on at
    RE: hello, how can I find a history of the payment journals posted so far?

    Hello,

    I followed your instructions up to there. I managed to find the payment journal source code  but I still do not see the payment journals history and the amounts paid on each line?

    thanks

  • Suggested answer
    MartinNL Profile Picture
    MartinNL 480 on at
    RE: hello, how can I find a history of the payment journals posted so far?

    Hi Busybee,

    Personally I find that using the "G/L Registers" (Archive) is the simplest, from the G/L Registers you can filter on "Source Code" for your Payment Journal. From there you can navigate to all related entries in the various ledgers such as Vendor, Bank, VAT, etc.

    pastedimage1584976910442v1.png

    pastedimage1584977262296v3.png

    If you are unsure what is the exact source code for your payment journal you can confirm this by checking the source code setup, under the Purchases FastTab you will see the defined source code for Payment Journals.

    pastedimage1584977045998v2.png

    Regards,

    Martin

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: hello, how can I find a history of the payment journals posted so far?

    depending on the used account type in the payment journal:

    * for bank account: goto the used bank account, then to ledger entries, filter by document type=payment

    * for g/l account: goto the chart of accounts, filter to the in the PJ used g/l account, goto ledger entries, filter by document type=payment

    * you'll find also according vendor ledger entries for the payment lines.

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

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans