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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Expense management - Allocate cash advance to an already posted expense claim etc

(0) ShareShare
ReportReport
Posted on by 219

I am working with travel management in D365 version Update33 (7.0.5559.35512)

I have questions regarding the offset  of cash advance and already posted expenses


  1. Is it possible at all to offset a posted expense to a cahs advance that is posted after the travel expense?

  2. Is it possible to allocate a specific expense to a cash advance if cash advance is posted before the expense?
    I am looking for if there is a possibility like in AR to match a specific invoice and payment

  3. Is it possible to match 3 expenses to one cash advance?


  4. Is there some kind of reconciliation report for cash advances?


    If any tips for new information pages that would be highly appreciated.

    Not all of these final steps are covered in the documentation from Microsoft it seems. 
    I have read this link,

    http://d365tour.com/en/microsoft-dynamics-d365o/trade-logistics-d365fo-en/cash-advance/




    but it seems not to be covering reconcilation nor multiple expense reports to one cash advance and 



    I always like to find good reports for reconciliation purposes if possible, 
I have the same question (0)
  • Suggested answer
    Rahul Mohta Profile Picture
    21,032 on at

    What does your paraMETER looks for 

    Post cash advances immediately

    Use this option to post an approved cash advance when the process to Pay and transfer is completed. If this option is not selected, the Pay and transfer process will generate an unposted general journal.

    sharing an additiona link

    https://community.dynamics.com/ax/b/dynamics365tour/posts/using-cash-advance-functionality-in-the-microsoft-dynamics-365-for-operations-expense-management-module

  • Suggested answer
    Krakan99 Profile Picture
    219 on at

    Thank you for the answer. I have also found out that to be able to reconcile the cash travel account the function ledger settlement might be a good tool to explore as well

  • Suggested answer
    Michal Krejza Profile Picture
    on at

    Hello Eva,

    Unfortunately the Cash advance design in Expense management. I have answered all your questions below:


    1. Is it possible at all to offset a posted expense to a cash advance that is posted after the travel expense?

    No - it is not possible. Settlement between Expense report and Cash advance is done automatically when expense report is posted. So support order is only Cash Advance and Expense report. 

    2. Is it possible to allocate a specific expense to a cash advance if cash advance is posted before the expense?

    It is not possible. When expense report is posted, system locates a cash advance with balance and the remaining balance is used for Expense report settlement. This procedure ignores currency - expense in EUR can be settled to USD cash advance. 

    !!!ONLY!!! if the "Cash advance return" is used - then user can select Cash advance, but purpose of this category is to return cash advance money to company, not to settle Expense and Cash advance. I know that some users are confused about it. In this scenario 


    3. Is it possible to match 3 expenses to one cash advance?

    Yes, it is possible. It depends on balance of Cash Advance. If you have Cash advance for 1000 USD, you can create 4 Expense reports with 250USD and system will settle those to Cash Advance. 

    4. Is there some kind of reconciliation report for cash advances?

    Not at this moment. 


    If any tips for new information pages that would be highly appreciated.

    The blog post you have mentioned is perfect for starting with Cash Advances. There's one point missing - which is also important. When you setup Payment method - you have to setup Expense owner as Employee, and Offset account type as Worker.  Both are essential. 

    If you have any further questions let me know. If you want we can have a conference call and discuss there, but we would need Service request to our Microsoft support team.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 551 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans