Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Apply a Cash Advance to a Expense Report

Posted on by 160

Hi Expert!

 

I have issues in applying cash advance to expense report 

 

Travel and expense manual describe the applied cash advance to expense report as following:

Cash advances are automatically applied to expense reports. The user does not
have to manually reference the cash advance on the Expense entry form. The
system automatically calculates the balance. If the cash advance is less than the
actual expense incurred, the employee is reimbursed for the balance. If, on the
other hand, the cash advance is more than the actual expense, the employee must
return the excess cash advance to the company. To return the excess amount, the
employee must add a line of the cash advance return category to an expense
report.

 

 

unfortunately, when I register an expense report, the system doesn’t credit the cash advance account as mentioned in the previous paragraph. in all cases the system debits the expense account and credit account that assigned to the method of payment and don't take in consideration that the worker already has an advanced payment.

 

this the steps that I did:

1- cash advance request.                         

    Dr. cash advance account                                            5000

        Cr. Employee account (Ledger or Vendor)           5000

 

2- Payment

      Dr. Employee account (Ledger or vendor).         5000$

         Cr. Bank                                                       5000$

 

3- expense report (this is the issue)

according to the travel and expense manual the system should credit the cash advance account if the expense is less than the cash advance amount and generate the following entire

  Dr. Expense Category                                4000$

      Cr. Cash advance account                   4000$


unfortunately, the system generates the following:

Dr. Expense Category                                4000$

  Cr. Worker account (Ledger or Vendor)  4000$ // this account change depending on the method of payment but on my case I have one method of payment which assigned to worker account..

 

please advise 

 

 

 

*This post is locked for comments

  • Mehdi Kuchaki Profile Picture
    Mehdi Kuchaki 15 on at
    RE: Apply a Cash Advance to a Expense Report

    Based on the payment method, we have the following transaction:

    Expense owner = Company

    Offset account type = Worker

     Dr-Expense

       Cr-Worker account (Ledger or Vendor)

    Expense owner = Employee

    Offset account type = Worker

     Dr-Expense

       Cr-Advance to employees

  • Mehdi Kuchaki Profile Picture
    Mehdi Kuchaki 15 on at
    RE: Apply a Cash Advance to a Expense Report

    Hi every one

    When the expense report is less than the cash advance balance amount, the following voucher is issued

     Dr-Expense

          Cr-Cash advance account

    The following voucher is issued when the expense report is greater than the cash advance balance amount

     Dr-Expense

          Cr-Cash advance account = (cash advance balance amount)

          Cr- Worker account (Ledger or Vendor) = (Expense-cash advance balance amount)

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Apply a Cash Advance to a Expense Report

    thanks anyway.

  • Mohammad Ismail Profile Picture
    Mohammad Ismail 160 on at
    RE: Apply a Cash Advance to a Expense Report

    unfortunately no

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Apply a Cash Advance to a Expense Report

    Hi Mohammad,

    I've got the same error on D365FO. Did you get the solution on that ?

    Regards,

  • Mohammad Ismail Profile Picture
    Mohammad Ismail 160 on at
    RE: Apply a Cash Advance to a Expense Report

    unfrotunately

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Apply a Cash Advance to a Expense Report

    Hi,

    Here is a blog post for D365fO. about this topic

    d365tour.com/.../cash-advance

    Can you check if what is described there answers your question?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Apply a Cash Advance to a Expense Report

    Hi Mohammad, I think we both have the same issue. Did you find out how to solve this? 

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans