Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Vendor payment proposal automation - delete journal if blank/empty/no lines

(1) ShareShare
ReportReport
Posted on by 5
We're looking into using the Vendor payment proposal automation (located under Accounts payable > Payment setup > Process automations) to auto create vendor payment journals for a specific payment method on a schedule (likely daily), and then a job to auto post the journals.  However, when there are no outstanding payments found, the journal is created with no lines, and then cannot be posted.  Subsequent automation job executions will create new journals.
 
Is there any option in the standard process automation setups to auto delete the auto created journal at the end if it contains no lines?
 
I've looked but couldn't find anything. Otherwise if we run this on a frequent schedule then we'll potentially end up with a lot of pending journals with no lines hanging around which someone will have to manually delete.
  • Adis Profile Picture
    Adis 2,450 on at
    Vendor payment proposal automation - delete journal if blank/empty/no lines
    Hi,
     
    I havent used this feature, but I can give you the following hints.
     
    1.: When you open a journal and close it without adding lines, the journal is deleted by default. I came across by accident around 10.0.39, maybe even 10.0.38 (we skipped 38. Therefore, have you tried how it works with the proposal automation?
     
    2.: As far as I know there is an entity for the payment journal, so that you can use Power Automate to do the job, i.e. check for not posted journals with empty lines and delete it, which can run every day during the night or so.
     
    Kind regards, Adis

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

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans