Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Is there a way to post date ACH payments in GP?

Posted on by 10

We want to be able to post date our ACH payments so that our cash is credited in one month (ex. June) and the expense hits in the next month (ex. July). This will be used for our Rent Batches, so that's why we want the expense to hit the next month (ex. July), we would process payment this month for next months rent. I hope this is making sense! 

Any help is greatly appreciated. Thnx!

Categories:
  • ACH HELP Profile Picture
    ACH HELP 10 on at
    RE: Is there a way to post date ACH payments in GP?

    This makes sense! I'm going to try this in our test company ASAP! I figured it had something to do with the post settings but wasn't sure how to manipulate the settings to achieve my goals.

    I will keep you posted!

    Thank you!

  • Suggested answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: Is there a way to post date ACH payments in GP?

    Hello,  

    So when you post you Invoice it will credit your Payables Account.  So in this case you would post your invoice for July (posting date, and make sure that your posting date is set up to pull from the transaction and not the batch under posting setup).  This will Credit your Payables account in July and Debit your Purchases account in July as well.    Then when you post the payment make the payment with a Posting Date of June.    The this will Debit your Payables Account in June, and credit hit your cash account in June.  Therefore the payment hits the GL in June, the Invoice hits the GL in July.  

    If you have tried this and still need assistance, this might be something that is easier explained or troubleshot through a support case.

    If you truly need to defer the payment you might have to look into the Revenue Expense Deferrals Module to see if that is more what you are looking for.

    Thanks!

    Isaac Olson

    Microsoft Support

  • Nookybutt Profile Picture
    Nookybutt 30 on at
    RE: Is there a way to post date ACH payments in GP?

    Okay, well there is your problem.  The invoice posting date and payment posting date need to be in the month that you wish them to show up.  That is the part that hits the GL.

  • ACH HELP Profile Picture
    ACH HELP 10 on at
    RE: Is there a way to post date ACH payments in GP?

    Yes, I changed it to 7/1 which is the month I want the expense to hit. 

    Right now I'm trying a Test Batch with the transaction and posting date both 7/1, then I'm going to create a check run with today's date and see if that doesn't work. Whenever I print the "detailed trial balance" previously, it's shown both the cash and expense in July. My AC has tried multiple methods as well but can't seem to perfect it either. I'm going to keep at it! I just made some changes to the Financial post settings, maybe that will work. Thank you, by the way! If you think of anything else please keep me updated and I will do the same.

  • Nookybutt Profile Picture
    Nookybutt 30 on at
    RE: Is there a way to post date ACH payments in GP?

    Did you change the actual posting date?

  • ACH HELP Profile Picture
    ACH HELP 10 on at
    RE: Is there a way to post date ACH payments in GP?

    Iforum-pic.png"/api/data/v9.1/msdyn_richtextfiles(C9BA6B6A-FDDF-4F6E-8B97-D747F469A45A)/msdyn_imageblob/$value?size=full">/api/data/v9.1/msdyn_richtextfiles(C9BA6B6A-FDDF-4F6E-8B97-D747F469A45A)/msdyn_imageblob/$value?size=full

  • Nookybutt Profile Picture
    Nookybutt 30 on at
    RE: Is there a way to post date ACH payments in GP?

    Yes, enter the invoice in the month that you want the expense, and do a payables payment to apply to that invoice with the date you want to enter cash. 

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,908 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans