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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Expense management - A...
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 Krakan99 217

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, 
Categories:
Financial Management
  • Suggested answer
    Michal Krejza Profile Picture
    Michal Krejza on at
    RE: Expense management - Allocate cash advance to an already posted expense claim etc

    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.

  • Suggested answer
    Krakan99 Profile Picture
    Krakan99 217 on at
    RE: Expense management - Allocate cash advance to an already posted expense claim etc

    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
    Rahul Mohta Profile Picture
    Rahul Mohta 21,010 on at
    RE: Expense management - Allocate cash advance to an already posted expense claim etc

    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

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

Dynamics 365 Community Update – Sep 16th

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

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

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

Last month Overall leaderboard

Featured topics

Test Comment 26-09-2024 16:14pm

Product updates

Dynamics 365 release plans