Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Vendor payment proposa...
Finance forum
Unanswered

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

Posted on by 1
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 256 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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans