D365 Finance & Operations and Dynamics AX Forum

 View Only
  • 1.  Expense Management Payment Method question

    SILVER CONTRIBUTOR
    Posted Dec 15, 2021 03:13 PM
    We are looking at using the expense management functionality for those employees who attend training conferences.  Early in the process, we pay some expenses like conference registration and airfare to a vendor in the AP module.  When the employee returns, they enter all trip expense regardless of who and how they're paid but we only post from the expense report the expenses paid personally by the employee that they're being reimbursed.  Management likes all expenses to be on the expense report so they know what the total trip cost is.  My question. Is there a way to configure a payment method for company paid expenses on the expense report so they won't post and are just their for information purposes, since these things like conference registration and airfare are paid separately in the AP module?

    P.S. - We're currently doing expense reports on excel and entering them manually.

    ------------------------------
    Brad Reeves
    Manager - Finance
    Bill And Hillary Clinton National Airport
    Little Rock AR
    ------------------------------


  • 2.  RE: Expense Management Payment Method question

    SILVER CONTRIBUTOR
    Posted Dec 16, 2021 06:42 AM
    Brad,
    Expenses can be entered with a negative value.
    This may be too much to track, if you have lots of employees, but what if.....
    1. You create a new Payment Method called something like (To Be Offset)
    2. Expense reports are entered for all travel items and the ones that were paid out of AP use this Payment Method.
    3. A second expense report is created for the lines that were paid out of AP using a negative dollar amount
    4. For reconciliation purposes, the 'Posted transactions' report can be filtered to just include the 'To Be Offset' Payment method

    See below how you could filter the report:



    Best of luck!

    ------------------------------
    Jonathan Struble
    Anthology Inc
    ------------------------------



  • 3.  RE: Expense Management Payment Method question

    Posted Dec 16, 2021 07:23 AM
    Yes, this can easily be done with your expense category and the setup for the Payment method for each Expense category.  For example, we have payment method of employee for expenses that need to be reimbursed to the employee and hit the GL at the time of the expense report.  Then we have PCard for a type for expenses that will hit the GL when the PCard transactions hit the GL and will not be reimbursed on the expense report.  Hope this information helps.

    ------------------------------
    Jennifer Erhard
    Manager, Accounting/ERP
    Kentucky Lottery Corporation
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role